1. SAP Tutorial
  2. Business Warehouse

/POSDW/LPA_EXDET SAP table for – LPA : Exception Template Details (Parameters)

Here we would like to draw your attention to /POSDW/LPA_EXDET 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_EXDET is a SAP standard transp table used for storing LPA : Exception Template Details (Parameters) related data in SAP. It comes under the package /POSDW/LPA_DATABASE.

SAP /POSDW/LPA_EXDET table

Table /POSDW/LPA_EXDET technical data

Table/POSDW/LPA_EXDET
Data storingLPA : Exception Template Details (Parameters)
ModuleBW
Sub ModuleBW-BCT-ISR-LPA
SAP Package/POSDW/LPA_DATABASE
Delivery ClassE – System table whose data is transported with its own transport objects
ComponentBI_CONT
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • PRF_TYPE : Customizing Profile Type
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • PTN_ID : LPA : Pattern Identifier
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • TMPL_ID : LPA : Exception Template ID
    Its data type is CHAR (Character String) with field length 10
  • STORE_START_TIME : LPA : Store Start Time
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • STORE_END_TIME : LPA : Store End Time
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • TRAN_TYPE : Transaction Type
    Its data type is CHAR (Character String) with field length 4
  • ORPH_TVAL : LPA : Orphan Time (min)
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • LATE_MEASURE_VAL : LPA : Measure Value for Exception Templates
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • LATE_MEASURE_TYP : LPA : Late Template Measure Type
    Its data type is CHAR (Character String) with field length 3
  • TENDER_TYPE : Means of Payment
    Its data type is CHAR (Character String) with field length 4
  • MAT_NO : Material Number
    Its data type is CHAR (Character String) with field length 18
  • BA_MAT_NO : LPA : Material Number 1
    Its data type is CHAR (Character String) with field length 18
  • TRAN_TYPE1 : LPA : Transaction Type 1
    Its data type is CHAR (Character String) with field length 4
  • TENDER_TYPE1 : LPA : Means of Payment
    Its data type is CHAR (Character String) with field length 4
  • TENDER_TYPE2 : LPA : Means of Payment
    Its data type is CHAR (Character String) with field length 4
  • TENDER_TYPE3 : LPA : Means of Payment
    Its data type is CHAR (Character String) with field length 4
  • TENDER_TYPE4 : LPA : Means of Payment
    Its data type is CHAR (Character String) with field length 4
  • TENDER_TYPE5 : LPA : Means of Payment
    Its data type is CHAR (Character String) with field length 4
  • TENDER_TYPE6 : LPA : Means of Payment
    Its data type is CHAR (Character String) with field length 4
  • TENDER_TYPE7 : LPA : Means of Payment
    Its data type is CHAR (Character String) with field length 4
  • CUST_TYPE : Type of Customer Information
    Its data type is CHAR (Character String) with field length 4
  • LOOKREF_TYP : LPA : Refund Transaction ID
    Its data type is CHAR (Character String) with field length 1
  • BA_COMPARISONREL : LPA : Relationship Between Two Transactions
    Its data type is CHAR (Character String) with field length 2
  • BA_MEASURE_VAL : LPA : Before/After Template Measure Value
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • BA_MEASURE_TYPE : LPA : Before/After Template Measure Type
    Its data type is CHAR (Character String) with field length 4
  • BA_MEASURE_BASIS : LPA : Before/After Template Measure With
    Its data type is CHAR (Character String) with field length 3
  • DSCT_TYP : LPA : Discount Type
    Its data type is CHAR (Character String) with field length 10
  • DSCT_TYPVAL : LPA : Discount Value
    Its data type is CURR (Currency Field) with field length 15
  • FL_MEASURE_TYP : LPA : First/Last Hour Template Measure Type
    Its data type is CHAR (Character String) with field length 6
  • FL_MEASURE_VAL : LPA : First/Last Hour Template Measure Value
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • RANGE_FROM : LPA : Cashier ID or Total Ringtime From
    Its data type is CHAR (Character String) with field length 30
  • RANGE_TO : LPA : Cashier ID or Total Ringtime To
    Its data type is CHAR (Character String) with field length 30
  • RINGTIME_FROM : LPA : Total Ringtime From
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • RINGTIME_TO : LPA : Total Ringtime To
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • SKUID_FROM : LPA : SKU ID From
    Its data type is CHAR (Character String) with field length 18
  • SKUID_TO : LPA : SKU ID To
    Its data type is CHAR (Character String) with field length 18
  • TXNAMOUNT_FROM : LPA : Transaction Amount From
    Its data type is CURR (Currency Field) with field length 15
  • TXNAMOUNT_TO : LPA : Transaction Amount To
    Its data type is CURR (Currency Field) with field length 15
  • REF_TYPE : LPA : Refund Type
    Its data type is CHAR (Character String) with field length 5
  • TRANSCURRENCY : Transaction Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • REL_OPER : LPA : Relational Operator
    Its data type is CHAR (Character String) with field length 3
  • REL_OPR1 : LPA: Relational Operator
    Its data type is CHAR (Character String) with field length 3
  • REL_OPR2 : LPA: Relational Operator
    Its data type is CHAR (Character String) with field length 3
  • REL_OPR3 : LPA: Relational Operator
    Its data type is CHAR (Character String) with field length 3
  • REL_OPR4 : LPA: Relational Operator
    Its data type is CHAR (Character String) with field length 3
  • LOGIC_OPER : LPA : Logical Operator
    Its data type is CHAR (Character String) with field length 3
  • LOG_OPR1 : LPA : Logical Operator
    Its data type is CHAR (Character String) with field length 3
  • LOG_OPR2 : LPA : Logical Operator
    Its data type is CHAR (Character String) with field length 3
  • LOG_OPR3 : LPA : Logical Operator
    Its data type is CHAR (Character String) with field length 3
  • ITM_CNT : LPA : Item Count
    Its data type is NUMC (Character String with Digits Only) with field length 10
  • ITM_MSTYP : LPA : Item Scan Rate Template Measure Type
    Its data type is CHAR (Character String) with field length 20
  • TI_MSTYP : LPA : Tender Information Template Measure Type
    Its data type is CHAR (Character String) with field length 6
  • TI_MSVAL : LPA : Tender Information Template Measure Value
    Its data type is CHAR (Character String) with field length 25
  • SMCARD_MS : LPA : Same Card Used Template Measure Type
    Its data type is CHAR (Character String) with field length 4
  • SMCARD_MSVAL : LPA : Same Card Used Template Measure Value
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • SPLORD_MS : LPA : Transaction Header Template Measure Value
    Its data type is CHAR (Character String) with field length 5
  • TXN_INSUFFINFO : LPA : Insufficient Information Template Measure Type
    Its data type is CHAR (Character String) with field length 6
  • ITM_ATTR : LPA : Item Attribute
    Its data type is CHAR (Character String) with field length 10
  • ITM_ATRVAL : LPA : Item Attribute Value
    Its data type is CHAR (Character String) with field length 10
  • ITM_ATTR1 : LPA : Item Attribute 1
    Its data type is CHAR (Character String) with field length 10
  • ITM_ATRVAL1 : LPA : Item Attribute Value 1
    Its data type is CHAR (Character String) with field length 10
  • ORD_ATTR : LPA : Order Attribute
    Its data type is CHAR (Character String) with field length 10
  • ORD_ATRVAL : LPA : Order Attribute Value
    Its data type is CHAR (Character String) with field length 10
  • ORD_ATTR1 : LPA : Order Attribute 1
    Its data type is CHAR (Character String) with field length 10
  • ORD_ATRVAL1 : LPA : Order Attribute Value 1
    Its data type is CHAR (Character String) with field length 10
  • ITMATR_MSTYP : LPA :Transaction Line Item Template Measure Type
    Its data type is CHAR (Character String) with field length 6
  • ITMATR_MSVAL : LPA: Transaction Line Item Template Measure Value
    Its data type is CURR (Currency Field) with field length 15
  • SPLSKU_MSTYP : LPA : SKU Matching Amount Template Measure Type
    Its data type is CHAR (Character String) with field length 6
  • REASONCODE : Reason
    Its data type is CHAR (Character String) with field length 4
  • RETAILTYPECODE : Sales Item Type
    Its data type is CHAR (Character String) with field length 4
  • SPLSKU_MSVAL : LPA : SKU Matching Amount Template Measure Value
    Its data type is CURR (Currency Field) with field length 15
  • LOG_OPR_LTD : LPA: Logical Operator Limited Values
    Its data type is CHAR (Character String) with field length 3
  • SRT_TIMVAL : LPA: Scan Rate Template Time value
    Its data type is NUMC (Character String with Digits Only) with field length 10
  • SRT_MERCHG : LPA:Scan Rate Template Merchandise Group
    Its data type is CHAR (Character String) with field length 9
  • SRT_MERCHGCOLL : LPA: Merchandise Group Collection
    Its data type is CHAR (Character String) with field length 255
  • SRT_EXMERCHG : LPA: Scan Rate Template Exclude Merchandise Groups
    Its data type is CHAR (Character String) with field length 1
  • SRT_MANUAL : LPA: Scan Rate Template Manual Entries Indicator
    Its data type is CHAR (Character String) with field length 1
  • SRT_MSVAL : LPA: Scan Rate Template Item count
    Its data type is NUMC (Character String with Digits Only) with field length 10
  • LOG_OPR1_LTD : LPA: Logical Operator Limited Values
    Its data type is CHAR (Character String) with field length 3
  • PTN_STATUS : LPA : Pattern Status
    Its data type is CHAR (Character String) with field length 4
  • CREATED_ON : LPA : Template/Pattern Created On Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CHANGED_ON : LPA : Template/Pattern Changed Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • AUTHOR : User Name
    Its data type is CHAR (Character String) with field length 12
  • CHANGEDBY : User Name
    Its data type is CHAR (Character String) with field length 12
  • REF_WO_TENDER : LPA: Indicator for Diff. Tender Types in Refund /Sales
    Its data type is CHAR (Character String) with field length 1
  • REF_WO_TENDTY : LPA: Indicator for Different Credit Cards in Refund /Sales
    Its data type is CHAR (Character String) with field length 1
  • LOG_OPR2_LTD : LPA: Logical Operator Limited Values
    Its data type is CHAR (Character String) with field length 3
  • LOG_OPR3_LTD : LPA: Logical Operator Limited Values
    Its data type is CHAR (Character String) with field length 3
  • DISC_TYPE_GRP1 : LPA: Discount Type Group 1
    Its data type is CHAR (Character String) with field length 4
  • DISC_TYPE_GRP2 : LPA: Discount Type Group 2
    Its data type is CHAR (Character String) with field length 4
  • TENDER_TYPE_GRP1 : LPA: Tender Type Group 1
    Its data type is CHAR (Character String) with field length 4
  • TENDER_TYPE_GRP2 : LPA: Tender Type Group 2
    Its data type is CHAR (Character String) with field length 4
  • TRAN_TYPE_GRP1 : LPA: Transaction Type Group 1
    Its data type is CHAR (Character String) with field length 4
  • TRAN_TYPE_GRP2 : LPA: Transaction Type Group 2
    Its data type is CHAR (Character String) with field length 4
  • TASKCODE : Task Code
    Its data type is CHAR (Character String) with field length 4

    • /POSDW/LPA_EXDET related tables

    • /POSDW/LPA_GENRL : LPA: Basic settings
    • /POSDW/LPA_PTNPP : LPA : cluster table storing data during Parallelization
    • /POSDW/LPA_EXP : LPA : Master data Corresponding To Exception Templates
    • /POSDW/LPA_CUST : LPA : Customization mapping for Customer and Refund Details
    • /POSDW/LPA_PTNT : LPA : Text Table For Patterns of Exception Templates
    • /POSDW/LPA_EXPT : LPA : Text Table For Exception Templates
    • /POSDW/LPA_EXDET : LPA : Exception Template Details (Parameters)

    Related References

    Related Tutorials

    /POSDW/LPA_EXP SAP table for – LPA : Master data Corresponding To Exception Templates

    /POSDW/LPA_EXP table in SAP BW (Business Content and Extractors in BW) module. This table is used for storing data of...

    /POSDW/LPA_EXPT SAP table for – LPA : Text Table For Exception Templates

    /POSDW/LPA_EXPT table in SAP BW (Business Content and Extractors in BW) module. This table is used for storing data of...

    /POSDW/LPA_PTNT SAP table for – LPA : Text Table For Patterns of Exception Templates

    /POSDW/LPA_PTNT table in SAP BW (Business Content and Extractors in BW) module. This table is used for storing data of...

    /POSDW/LPA_CUST SAP table for – LPA : Customization mapping for Customer and Refund Details

    /POSDW/LPA_CUST table in SAP BW (Business Content and Extractors in BW) module. This table is used for storing data of...

    /POSDW/LPA_GENRL SAP table for – LPA: Basic settings

    /POSDW/LPA_GENRL table in SAP BW (Business Content and Extractors in BW) module. This table is used for storing data of...

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

    /POSDW/LPA_PTNPP table in SAP BW (Business Content and Extractors in BW) module. This table is used for storing data of...

    /POSDW/LPA_DTSK SAP table for – LPA: Default Task Code

    /POSDW/LPA_DTSK table in SAP BW (Business Content and Extractors in BW) module. This table is used for storing data of...

    «
    »