/POSDW/DEFLT SAP table for – Standard Values

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

SAP /POSDW/DEFLT table

Table /POSDW/DEFLT technical data

Table/POSDW/DEFLT
Data storingStandard Values
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/DEFLT 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/DEFLT table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • PROFILETYPE : Customizing Profile Type
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • DEFAULTPARTNERID : Partner Number
    Its data type is CHAR (Character String) with field length 13
  • ERRORPARTNERID : Partner Number
    Its data type is CHAR (Character String) with field length 13
  • DEFAULTMATNR : Standard for Material If Blank in POS Transaction
    Its data type is CHAR (Character String) with field length 18
  • ERRORMATNR : Standard for Material, if Incorrect in POS Transaction
    Its data type is CHAR (Character String) with field length 18
  • TEXTMATNR : Standard for Material, if Text Sent in Field ItemID
    Its data type is CHAR (Character String) with field length 18
  • TRANSCURRENCY : Standard for Document Currency if Not in POS Transaction
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • RETAIL : POS Transaction Type for Sales Movements
    Its data type is CHAR (Character String) with field length 4
  • TOTALS : POS Transaction Type for Totals Records
    Its data type is CHAR (Character String) with field length 4
  • FIMOVEMENT : POS Transaction Category for Financial Transactions
    Its data type is CHAR (Character String) with field length 4
  • GOODSMOVEMENT : POS Transaction Type for Goods Movements, if Missing
    Its data type is CHAR (Character String) with field length 4
  • CONTROL : POS Transaction Type for Control Transactions, if Missing
    Its data type is CHAR (Character String) with field length 4
  • POSTVOID : POS Transaction Type for Cancellation Transactions
    Its data type is CHAR (Character String) with field length 4
  • RETAILTYPECODE : Sales Item Type Code, if Missing
    Its data type is CHAR (Character String) with field length 4