/POSDW/PROF SAP table for – Customizing Profile

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

SAP /POSDW/PROF table

Table /POSDW/PROF technical data

Table/POSDW/PROF
Data storingCustomizing Profile
ModuleBW
Sub ModuleBW-BCT-ISR-PIP
SAP Package/POSDW/DATABASE
Delivery ClassE – System table whose data is transported with its own transport objects
ComponentBI_CONT
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • MATNR : Material Number
    Its a key field. Its data type is CHAR (Character String) with field length 18
  • WERKS : Plant
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • KZONL : Indicator: processing control online or in the background
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • POSN2 : Item number (2 digits)
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 2
  • MSGNR : Message number
    Its data type is CHAR (Character String) with field length 3
  • MSGV1 : Message variable 01
    Its data type is CHAR (Character String) with field length 50
  • MSGV2 : Message variable 02
    Its data type is CHAR (Character String) with field length 50
  • MSGV3 : Message variable 03
    Its data type is CHAR (Character String) with field length 50
  • MSGV4 : Message variable 04
    Its data type is CHAR (Character String) with field length 50