/POSDW/LPA_PTNPP SAP table for – LPA : cluster table storing data during Parallelization

Here we would like to draw your attention to /POSDW/LPA_PTNPP 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/LPA_PTNPP is a SAP standard transp table used for storing LPA : cluster table storing data during Parallelization related data in SAP. It comes under the package /POSDW/LPA_DATABASE.

SAP /POSDW/LPA_PTNPP table

Table /POSDW/LPA_PTNPP technical data

Table/POSDW/LPA_PTNPP
Data storingLPA : cluster table storing data during Parallelization
ModuleBW
Sub ModuleBW-BCT-ISR-LPA
SAP Package/POSDW/LPA_DATABASE
Delivery ClassL – Table for storing temporary data
ComponentBI_CONT
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • RELID : Region in IMPORT/EXPORT Data Table
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • SRTFD : User-defined key in table INDX
    Its a key field. Its data type is CHAR (Character String) with field length 22
  • SRTF2 : Next record counter in EXPORT/IMPORT data tables
    Its a key field. Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • RETAILSTOREID : Store
    Its data type is CHAR (Character String) with field length 10
  • BUSINESSDAYDATE : Posting Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PTN_ID : LPA : Pattern Identifier
    Its data type is CHAR (Character String) with field length 10
  • LOEKZ : CHAR01 data element for SYST
    Its data type is CHAR (Character String) with field length 1
  • SPERR : CHAR01 data element for SYST
    Its data type is CHAR (Character String) with field length 1
  • AEDAT : (8-character) Date for SYST
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • USERA : User name
    Its data type is CHAR (Character String) with field length 12
  • PGMID : ABAP Program Name
    Its data type is CHAR (Character String) with field length 40
  • BEGDT : (8-character) Date for SYST
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ENDDT : (8-character) Date for SYST
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CLUSTR : Length field for user data in EXPORT/IMPORT tables
  • CLUSTD : Data field for IMPORT/EXPORT database tables
    Its data type is LRAW (Long byte string, requires preceding INT2 field) with field length 32000