/POSDW/SOSTOR SAP table for – Store dependent short over value on aggregated level

Here we would like to draw your attention to /POSDW/SOSTOR table in SAP. As we know it is being mainly used with the SAP BW-BCT (Business Content and Extractors in BW) component which is coming under BW module (Business Warehouse). /POSDW/SOSTOR is a SAP standard transp table used for storing Store dependent short over value on aggregated level related data in SAP. It comes under the package /POSDW/DATABASE.

SAP /POSDW/SOSTOR table

Table /POSDW/SOSTOR technical data

Table/POSDW/SOSTOR
Data storingStore dependent short over value on aggregated level
ModuleBW
Sub ModuleBW-BCT-ISR-PIP
SAP Package/POSDW/DATABASE
Delivery ClassA – Application table (master and transaction data)
ComponentBI_CONT
Table CategoryTRANSP

SAP /POSDW/SOSTOR Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in /POSDW/SOSTOR table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • RETAILSTOREID : Store
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • BUSINESSDAYDATE : Posting Date
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TENDERTYPECODE : Means of Payment
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • TRANSCURRENCY : Transaction Currency
    Its a key field. Its data type is CUKY (Currency key for a currency field) with field length 5
  • ACTUALAMOUNT : Actual Amount
    Its data type is CURR (Currency Field) with field length 15
  • TENDERAMOUNT : Tender Value
    Its data type is CURR (Currency Field) with field length 15
  • SHORTOVERAMOUNT : Over/Short Amount
    Its data type is CURR (Currency Field) with field length 15
  • PAYINAMOUNT : Amount Added to the Till
    Its data type is CURR (Currency Field) with field length 15
  • PAYOUTAMOUNT : Amount Removed from the Till
    Its data type is CURR (Currency Field) with field length 15