C_SettlmtDocOPgItem

Settlement Document Item Object Page | view: CWLFSDOCOPGITEM | Extraction: Not supported | Component: Settlement Management
Tables used: WBRK, WBRP, MARA, T001W, MARA, MAKT
Column Name Description
SettlmtDoc FK Settlement Document Number
SettlmtDocItem Document Item
Column Name Description
💲 Currency of Settlement Document (SettlmtDocCurrency):
NetPriceAmount Net Price in Document Currency
CustomerItemGrossAmount Item Gross Amount for Customer in Document Currency
CustomerItemNetAmount Item Net Amount for Customer in Document Currency
CustomerItemTaxAmount Item Tax Amount of Customer in Document Currency
SupplierItemGrossAmount Item Gross Amount for Supplier in Document Currency
SupplierItemNetAmount Item Net Amount for Supplier in Document Currency
SupplierItemTaxAmount Item Tax Amount of Supplier in Document Currency
SupplierSubtotal1Amount Subtotal 1 from Prcg. Proced. for Condition of Supplier
SupplierSubtotal2Amount Subtotal 2 from Prcg. Proced. for Condition of Supplier
SupplierSubtotal3Amount Subtotal 3 from Prcg. Proced. for Condition of Supplier
SupplierSubtotal4Amount Subtotal 4 from Prcg. Proced. for Condition of Supplier
SupplierSubtotal5Amount Subtotal 5 from Prcg. Proced. for Condition of Supplier
SupplierSubtotal6Amount Subtotal 6 from Prcg. Proced. for Condition of Supplier
SupplierRebateBasisAmount Rebate Basis of Supplier
SupplierEffectiveItemAmount Supplier Effective Item Amount
SuplrItmEligibleAmtForCshDisc Amount eligible for cash discount in document currency
CustomerSubtotal1Amount Subtotal 1 from Prcg. Proced. for Condition of Customer
CustomerSubtotal2Amount Subtotal 2 from Prcg. Proced. for Condition of Customer
CustomerSubtotal3Amount Subtotal 3 from Prcg. Proced. for Condition of Customer
CustomerSubtotal4Amount Subtotal 4 from Prcg. Proced. for Condition of Customer
CustomerSubtotal5Amount Subtotal 5 from Prcg. Proced. for Condition of Customer
CustomerSubtotal6Amount Subtotal 6 from Prcg. Proced. for Condition of Customer
CustomerRebateBasisAmount Rebate Basis of Customer
CustomerEffectiveItemAmount Customer Effective Item Amount in Document Currency
CustItmEligibleAmtForCshDisc Amount Eligible for Cash Discount in Doc. Curr. (Cust.-Side)
NonDeductibleInputTaxAmount Non-deductible input tax
Column Name Description
📏 Unit of Measure of Settlement Management Doc Item Quantity (SettlmtQuantityUnit):
SettlmtQuantity Quantity of Settlement Management Document Item
ItemNetWeight Net Weight
ItemGrossWeight Gross Weight
ItemVolume Volume
ProductPurchasePointsQty Number of Points
Column Name Description
PricingDate Date for Pricing and Exchange Rate
CreationDate Date of Document Creation
CreationTime Time of Document Creation
ServicesRenderedDate Date of Services Rendered
Column Name Description
SettlmtDocItemCat Item Category Show values
SettlmtItmStatisticalPrpty Statistical Property of Settlement Management Item Show values
CashDiscountIsDeductible Cash Discount Indicator Show values
SettlmtSourceDocCat Document Category of Source Document Show values
SupplierPrcDetnIsIncmplt Item Pricing Incompleteness Indicator for Supplier Show values
CustomerPrcDetnIsIncmplt Item Pricing Incompleteness Indicator for Customer Show values
SettlmtPrecdgDocCat Document Category of Preceding Document Show values
SettlmtDocItemStatus Item Status Show values
SettlmtDocItemCancld Item Was Canceled Show values
SupplierItemSettlmtStatus Settlement Status - Item - Supplier Show values
CustomerItemSettlmtStatus Settlement Status - Item - Customer Show values
ItemSettlmtRelevance Item Settlement Relevance Show values
LowerLevelItemExists Subitems Exist Show values
ItemDistributionStatus Status Distribution of Item Show values
SettlmtRefDocCat Reference Document Category in Settlement Management Show values
ItemIntrastatRelevance Document Item is Relevant for Intrastat Declarations Show values
SettlmtDocItemCollSts Status for Collection of Settlement Document Item Show values
ItmSettlmtDocCollRelevance Collective Settlement Relevance of Settlement Documents Show values
SettlmtAddlRefDocCat Additional Reference Document Category Show values
Column Name Description Domain name
ProductName Product Description TEXT40
PlantName Plant Name TEXT30
NetPriceQuantity Price Unit of Settlement Management Document Item DEC5
SupplierProductID Material Number Used by Supplier IDNEX
SupplierPricingDocument Supplier Document Condition of Settlement Document KNUMV
CustomerPricingDocument Customer Document Condition of Settlement Document KNUMV
SettlmtToBaseQuantityNmrtr Numerator Converting Qty in Settlement Document to Base Unit UMBSZ
SettlmtToBaseQuantityDnmntr Denominator Converting Qty in Settlement Doc. to Base Unit UMBSN
SettlmtToNetPriceQtyNmrtr Numerator for Converting Settl. UoM to Settl. Price UoM UMBSZ
SettlmtToNetPriceQtyDnmntr Denominator for Converting Settl. UoM to Settl. Price UoM UMBSZ
CreatedByUser Name of User who Created the Document USNAM
SettlmtSourceDoc Document Number of the Source Document CHAR10
SettlmtSourceDocItem Item Number of the Source Document Item NUMC6
SettlmtSourceDocFiscalYear Fiscal Year of a Source Document in Settlement Management GJAHR
SettlmtDocItemText Short Text TEXT40
SuplrSettlmtCostCenter Cost Center KOSTL
SuplrSettlmtProfitCenter Profit Center PRCTR
IncotermsTransferLocation Incoterms (Part 2) INCO2
IncotermsLocation1 Incoterms Location 1 INCO_L
IncotermsLocation2 Incoterms Location 2 INCO_L
SettlmtPrecdgDoc Preceding Document of the Settlement Management Document CHAR10
SettlmtPrecdgDocItem Preceding Document Item in the Settlement Management Doc. NUMC6
SettlmtPrecdgDocFiscalYear Fiscal Year of a Preceding Document in Settlement Management GJAHR
SettlmtItemReltdCndnContr Related Condition Contract of a Settlement Management Item WCB_COCO_NUM
SettlmtItemReltdTrdgContr Related Trading Contract of a Settlement Management Item TKONN
SettlmtItemReltdTrdgContrItem Related Trading Contract Item of a Settlmt Mgmt Item TPOSN
SettlmtItemReltdPurgDoc Related Purchasing Document of a Settlement Management Item EBELN
SettlmtItemReltdPurgDocItem Related Purchasing Document Item of a Settlmt Mgmt Item EBELP
SettlmtItemReltdBillgDoc Related Billing Document of a Settlement Management Item VBELN
SettlmtItemReltdBillgDocItem Related Billing Document Item of a Settlmt Mgmt Item POSNR_VF
SettlementFiscalYear CCS: Fiscal Year of Settlement GJAHR
HigherLevelItem Higher-Level Item in Bill of Material Structures POSNR
SettlmtRefDoc Reference Document for Settlement Management WLF_REF_DOC_NUMBER
SettlmtRefDocFiscalYear Year of Reference Document for Settlement Management GJAHR
SettlmtRefDocLogicalSyst Logical System of Reference Document for Smt Mgmt LOGSYS
SettlmtRefDocItem Reference Document Item for Settlement Management Document WLF_REF_ITEM_NUMBER
SettlmtAddlRefDoc Additional Reference Document for Settlement Management WLF_REF_DOC_NUMBER
SettlmtAddlRefDocFiscalYear Year of Additional Reference Document for Smt Mgmt GJAHR
SettlmtAddlRefDocLogicalSyst Logical System of Additional Reference Document for Smt Mgmt LOGSYS
SettlmtAddlRefDocItem Additional Reference Doc Item for Settlement Mgmt. Document WLF_REF_ITEM_NUMBER
Master Data Relations Join Conditions
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • C_SETTLMTDOCOPGITEM.MANDT == T006.MANDT
  • C_SETTLMTDOCOPGITEM.BASEUNIT == T006.MSEHI
Batch Number
  • Batch Number
  • Client
  • Product Number
  • C_SETTLMTDOCOPGITEM.BATCH == MCH1.CHARG
  • C_SETTLMTDOCOPGITEM.MANDT == MCH1.MANDT
  • C_SETTLMTDOCOPGITEM.PRODUCT == MCH1.MATNR
Reason for Collective Settlement Item Block
  • Client
  • Reason for Collective Settlement Item Block
  • C_SETTLMTDOCOPGITEM.MANDT == TMSB.MANDT
  • C_SETTLMTDOCOPGITEM.COLLSETTLMTITEMBLKGREASON == TMSB.SETTLEMENT_BLOCK
Reason for Customer Settlement Block at Item
  • Reason for Customer Settlement Block at Item
  • Client
  • C_SETTLMTDOCOPGITEM.CUSTOMERITEMSETTLMTBLKGREASON == TMSB.SETTLEMENT_BLOCK
  • C_SETTLMTDOCOPGITEM.MANDT == TMSB.MANDT
Order for Customer related Account Assignment
  • Client
  • Order for Customer related Account Assignment
  • C_SETTLMTDOCOPGITEM.MANDT == AUFK.MANDT
  • C_SETTLMTDOCOPGITEM.CUSTOMERSETTLEMENTORDER == AUFK.AUFNR
Customer Settlement Recipient
  • Customer Settlement Recipient
  • Client
  • C_SETTLMTDOCOPGITEM.CUSTOMERSETTLMTRECIPIENT == KNA1.KUNNR
  • C_SETTLMTDOCOPGITEM.MANDT == KNA1.MANDT
Customer Tax Code
  • Client
  • ?
  • Customer Tax Code
  • C_SETTLMTDOCOPGITEM.MANDT == T007A.MANDT
  • C_SETTLMTDOCOPGITEM.[column in domain "KALSM_D"] == T007A.KALSM
  • C_SETTLMTDOCOPGITEM.CUSTOMERTAXCODE == T007A.MWSKZ
Customer Business Area
  • Client
  • Customer Business Area
  • C_SETTLMTDOCOPGITEM.MANDT == TGSB.MANDT
  • C_SETTLMTDOCOPGITEM.CUSTSETTLMTBUSINESSAREA == TGSB.GSBER
Customer Controlling Area
  • Client
  • Customer Controlling Area
  • C_SETTLMTDOCOPGITEM.MANDT == TKA01.MANDT
  • C_SETTLMTDOCOPGITEM.CUSTSETTLMTCONTROLLINGAREA == TKA01.KOKRS
Customer Cost Center
  • Customer Cost Center
  • Client
  • Date for Pricing and Exchange Rate
  • Customer Controlling Area
  • C_SETTLMTDOCOPGITEM.CUSTSETTLMTCOSTCENTER == CSKS.KOSTL
  • C_SETTLMTDOCOPGITEM.MANDT == CSKS.MANDT
  • C_SETTLMTDOCOPGITEM.PRICINGDATE == CSKS.DATBI
  • C_SETTLMTDOCOPGITEM.CUSTSETTLMTCONTROLLINGAREA == CSKS.KOKRS
Alternative Customer Profit Center
  • Client
  • Date for Pricing and Exchange Rate
  • Customer Controlling Area
  • Alternative Customer Profit Center
  • C_SETTLMTDOCOPGITEM.MANDT == CEPC.MANDT
  • C_SETTLMTDOCOPGITEM.PRICINGDATE == CEPC.DATBI
  • C_SETTLMTDOCOPGITEM.CUSTSETTLMTCONTROLLINGAREA == CEPC.KOKRS
  • C_SETTLMTDOCOPGITEM.CUSTSETTLMTPROFITCENTER == CEPC.PRCTR
G/L Account
  • Client
  • ?
  • G/L Account
  • C_SETTLMTDOCOPGITEM.MANDT == SKA1.MANDT
  • C_SETTLMTDOCOPGITEM.[column in domain "KTOPL"] == SKA1.KTOPL
  • C_SETTLMTDOCOPGITEM.GLACCOUNT == SKA1.SAKNR
Incoterms (Part 1)
  • Client
  • Incoterms (Part 1)
  • C_SETTLMTDOCOPGITEM.MANDT == TINC.MANDT
  • C_SETTLMTDOCOPGITEM.INCOTERMSCLASSIFICATION == TINC.INCO1
Incoterms Version
  • Incoterms Version
  • Client
  • C_SETTLMTDOCOPGITEM.INCOTERMSVERSION == TINCV.INCOV
  • C_SETTLMTDOCOPGITEM.MANDT == TINCV.MANDT
Valuation Type
  • Valuation Type
  • Client
  • C_SETTLMTDOCOPGITEM.INVENTORYVALUATIONTYPE == T149D.BWTAR
  • C_SETTLMTDOCOPGITEM.MANDT == T149D.MANDT
Volume unit
  • Client
  • Volume unit
  • C_SETTLMTDOCOPGITEM.MANDT == T006.MANDT
  • C_SETTLMTDOCOPGITEM.ITEMVOLUMEUNIT == T006.MSEHI
Weight Unit
  • Weight Unit
  • Client
  • C_SETTLMTDOCOPGITEM.ITEMWEIGHTUNIT == T006.MSEHI
  • C_SETTLMTDOCOPGITEM.MANDT == T006.MANDT
Settlement Management Document Item Price Unit
  • Settlement Management Document Item Price Unit
  • Client
  • C_SETTLMTDOCOPGITEM.NETPRICEQUANTITYUNIT == T006.MSEHI
  • C_SETTLMTDOCOPGITEM.MANDT == T006.MANDT
Plant
  • Plant
  • Client
  • C_SETTLMTDOCOPGITEM.PLANT == T001W.WERKS
  • C_SETTLMTDOCOPGITEM.MANDT == T001W.MANDT
Prior Supplier
  • Prior Supplier
  • Client
  • C_SETTLMTDOCOPGITEM.PRIORSUPPLIER == LFA1.LIFNR
  • C_SETTLMTDOCOPGITEM.MANDT == LFA1.MANDT
Product Number
  • Client
  • Product Number
  • C_SETTLMTDOCOPGITEM.MANDT == MARA.MANDT
  • C_SETTLMTDOCOPGITEM.PRODUCT == MARA.MATNR
Product Group
  • Client
  • Product Group
  • C_SETTLMTDOCOPGITEM.MANDT == T023.MANDT
  • C_SETTLMTDOCOPGITEM.PRODUCTGROUP == T023.MATKL
Product hierarchy
  • Client
  • Product hierarchy
  • C_SETTLMTDOCOPGITEM.MANDT == T179.MANDT
  • C_SETTLMTDOCOPGITEM.PRODUCTHIERARCHY == T179.PRODH
Points Unit
  • Points Unit
  • Client
  • C_SETTLMTDOCOPGITEM.PRODUCTPURCHASEPOINTSQTYUNIT == T006.MSEHI
  • C_SETTLMTDOCOPGITEM.MANDT == T006.MANDT
Sales-Specific Product Group 1
  • Sales-Specific Product Group 1
  • Client
  • C_SETTLMTDOCOPGITEM.SALESSPCFCPRODUCTGROUP1 == TVM1.MVGR1
  • C_SETTLMTDOCOPGITEM.MANDT == TVM1.MANDT
Sales-Specific Product Group 2
  • Client
  • Sales-Specific Product Group 2
  • C_SETTLMTDOCOPGITEM.MANDT == TVM2.MANDT
  • C_SETTLMTDOCOPGITEM.SALESSPCFCPRODUCTGROUP2 == TVM2.MVGR2
Sales-Specific Product Group 3
  • Client
  • Sales-Specific Product Group 3
  • C_SETTLMTDOCOPGITEM.MANDT == TVM3.MANDT
  • C_SETTLMTDOCOPGITEM.SALESSPCFCPRODUCTGROUP3 == TVM3.MVGR3
Sales-Specific Product Group 4
  • Sales-Specific Product Group 4
  • Client
  • C_SETTLMTDOCOPGITEM.SALESSPCFCPRODUCTGROUP4 == TVM4.MVGR4
  • C_SETTLMTDOCOPGITEM.MANDT == TVM4.MANDT
Sales-Specific Product Group 5
  • Sales-Specific Product Group 5
  • Client
  • C_SETTLMTDOCOPGITEM.SALESSPCFCPRODUCTGROUP5 == TVM5.MVGR5
  • C_SETTLMTDOCOPGITEM.MANDT == TVM5.MANDT
Currency of Settlement Document
  • Currency of Settlement Document
  • Client
  • C_SETTLMTDOCOPGITEM.SETTLMTDOCCURRENCY == TCURC.WAERS
  • C_SETTLMTDOCOPGITEM.MANDT == TCURC.MANDT
Activity Reason for Document Creation
  • Activity Reason for Document Creation
  • Client
  • C_SETTLMTDOCOPGITEM.SETTLMTITEMACTIVITYREASON == TMLFG.LFGRU
  • C_SETTLMTDOCOPGITEM.MANDT == TMLFG.MANDT
Unit of Measure of Settlement Management Doc Item Quantity
  • Client
  • Unit of Measure of Settlement Management Doc Item Quantity
  • C_SETTLMTDOCOPGITEM.MANDT == T006.MANDT
  • C_SETTLMTDOCOPGITEM.SETTLMTQUANTITYUNIT == T006.MSEHI
Business Area
  • Client
  • Business Area
  • C_SETTLMTDOCOPGITEM.MANDT == TGSB.MANDT
  • C_SETTLMTDOCOPGITEM.SUPLRSETTLMTBUSINESSAREA == TGSB.GSBER
Supplier Company Code
  • Client
  • Supplier Company Code
  • C_SETTLMTDOCOPGITEM.MANDT == T001.MANDT
  • C_SETTLMTDOCOPGITEM.SUPLRSETTLMTCOMPANYCODE == T001.BUKRS
Controlling Area
  • Controlling Area
  • Client
  • C_SETTLMTDOCOPGITEM.SUPLRSETTLMTCONTROLLINGAREA == TKA01.KOKRS
  • C_SETTLMTDOCOPGITEM.MANDT == TKA01.MANDT
Reason for Supplier Settlement Block at Item
  • Client
  • Reason for Supplier Settlement Block at Item
  • C_SETTLMTDOCOPGITEM.MANDT == TMSB.MANDT
  • C_SETTLMTDOCOPGITEM.SUPPLIERITEMSETTLMTBLKGREASON == TMSB.SETTLEMENT_BLOCK
Order for Account Assignment
  • Order for Account Assignment
  • Client
  • C_SETTLMTDOCOPGITEM.SUPPLIERSETTLEMENTORDER == AUFK.AUFNR
  • C_SETTLMTDOCOPGITEM.MANDT == AUFK.MANDT
Supplier Subrange
  • Prior Supplier
  • Client
  • Supplier Subrange
  • C_SETTLMTDOCOPGITEM.PRIORSUPPLIER == WYT1.LIFNR
  • C_SETTLMTDOCOPGITEM.MANDT == WYT1.MANDT
  • C_SETTLMTDOCOPGITEM.SUPPLIERSUBRANGE == WYT1.LTSNR
Supplier Tax Code
  • Client
  • Supplier Tax Code
  • ?
  • C_SETTLMTDOCOPGITEM.MANDT == T007A.MANDT
  • C_SETTLMTDOCOPGITEM.SUPPLIERTAXCODE == T007A.MWSKZ
  • C_SETTLMTDOCOPGITEM.[column in domain "KALSM_D"] == T007A.KALSM
Tax Jurisdiction
  • Tax Jurisdiction
  • Client
  • ?
  • C_SETTLMTDOCOPGITEM.TAXJURISDICTION == TTXJ.TXJCD
  • C_SETTLMTDOCOPGITEM.MANDT == TTXJ.MANDT
  • C_SETTLMTDOCOPGITEM.[column in domain "TAX_KALSM"] == TTXJ.KALSM