/POSDW/SOPROF SAP table for – Short over profile

Here we would like to draw your attention to /POSDW/SOPROF 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/SOPROF is a SAP standard transp table used for storing Short over profile related data in SAP. It comes under the package /POSDW/DATABASE.

SAP /POSDW/SOPROF table

Table /POSDW/SOPROF technical data

Table/POSDW/SOPROF
Data storingShort over profile
ModuleBW
Sub ModuleBW-BCT-ISR-PIP
SAP Package/POSDW/DATABASE
Delivery ClassC – Customer table, data is only maintained by the customer
ComponentBI_CONT
Table CategoryTRANSP

SAP /POSDW/SOPROF 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/SOPROF table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • SO_PROFILE : Over/Short Profile
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • SO_TOL_SET_STORE : Tolerance Setting on Store Level
    Its data type is CHAR (Character String) with field length 4
  • SO_TOL_SET_LOWER : Tolerance Setting on Lower Level
    Its data type is CHAR (Character String) with field length 4
  • SO_TOL_LEVEL : Tolerance Level
    Its data type is CHAR (Character String) with field length 1
  • STATUS_EVAL_LEVE : Status Evaluation Level
    Its data type is CHAR (Character String) with field length 1
  • SO_CALCULATE_AMO : Scenario That Controls How Tender Amount is Calculated
    Its data type is CHAR (Character String) with field length 1