R_SuplrBillgDocItem

Supplier Billing Document Item | view: RWLFSUPLRBGDITM | TRAN | Extraction: Not supported | Component: Settlement Management
Tables used: WBRK, WBRP
Column Name Description
SuplrBillgDoc FK Supplier Billing Document Number
SuplrBillgDocItem Document Item
Column Name Description
💲 Currency of Settlement Document (SuplrBillgDocCurrency):
NetPriceAmount Net Price in Document Currency
SuplrBillgDocItemTaxAmount Item Tax Amount in Document Currency
SuplrBillgDocItemGrossAmount Gross Amount of Item in Document Currency
SuplrBillgDocItemNetAmount Net Amount of Item in Document Currency
SuplrBillgDocSubtotal1Amount Subtotal 1 Amount
SuplrBillgDocSubtotal2Amount Subtotal 2 Amount
SuplrBillgDocSubtotal3Amount Subtotal 3 Amount
SuplrBillgDocSubtotal4Amount Subtotal 4 Amount
SuplrBillgDocSubtotal5Amount Subtotal 5 Amount
SuplrBillgDocSubtotal6Amount Subtotal 6 Amount
SuplrBillgDocRebateBasisAmount Rebate Basis Amount
SuplrBillgDocEffctvItemAmount Effective Amount of Item
SuplrItmEligibleAmtForCshDisc Amount Eligible for Cash Discount in Document Currency
NonDeductibleInputTaxAmount Non Deductible Input Tax Amount
Column Name Description
📏 Unit of Measure of Settlement Management Doc Item Quantity (SettlmtQuantityUnit):
SettlmtQuantity Quantity of Settlement Management Document Item
📏 Weight Unit (ItemWeightUnit):
ItemNetWeight Net Weight
ItemGrossWeight Gross Weight
📏 Volume unit (ItemVolumeUnit):
ItemVolume Volume
📏 Quantity Unit of Purchase Points of a Product (ProductPurchasePointsQtyUnit):
ProductPurchasePointsQty Purchase Points Quantity of a Product
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
SuplrBillgDocItmStstclPrpty Statistical Property of Settlement Management Item Show values
CashDiscountIsDeductible Cash Discount is Deductible Show values
SettlmtSourceDocCat Document Category of Source Document Show values
PrcDetnIsIncmplt Price Determination is Incomplete Show values
SettlmtPrecdgDocCat Document Category of Preceding Document Show values
SuplrBillgDocItmCat Item Category Show values
SettlmtItemReltdRefDocCat Settlement Item Related Reference Document Category Show values
SuplrBillgDocItemStatus Item Status Show values
SuplrBillgDocItmReversed Item Was Canceled 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
SettlmtAddlRefDocCat Additional Reference Document Category Show values
Column Name Description Domain name
PricingDocument Number of the Document Condition KNUMV
NetPriceQuantity Price Unit of Settlement Management Document Item DEC5
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
SettlmtRefDocReltdFiscalYear Fiscal Year GJAHR
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
SuplrBillgDocItemText Short Text TEXT40
CostCenter Cost Center KOSTL
ProfitCenter 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
SettlmtItemReltdRefDoc Settlement Item Related Reference Document WCONTRACT
SettlmtItemReltdRefDocItem Settlement Item Related Reference Document Item NUMC6
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
SettlementFiscalYear Fiscal Year of Settlement GJAHR
HigherLevelItem Higher-Level Item in Bill of Material Structures POSNR
SettlmtRefDocType Type of Reference Document for Settlement Management WLF_REF_DOC_TYPE
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
SettlmtAddlRefDocType Type of Additional Reference Document for Settlmt Mgmt WLF_REF_DOC_TYPE
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
SupplierProductID Material Number Used by Supplier IDNEX
Master Data Relations Join Conditions
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • R_SUPLRBILLGDOCITEM.BASEUNIT == T006.MSEHI
  • R_SUPLRBILLGDOCITEM.MANDT == T006.MANDT
Batch Number
  • Product Number
  • Client
  • Batch Number
  • R_SUPLRBILLGDOCITEM.PRODUCT == MCH1.MATNR
  • R_SUPLRBILLGDOCITEM.MANDT == MCH1.MANDT
  • R_SUPLRBILLGDOCITEM.BATCH == MCH1.CHARG
Business Area
  • Business Area
  • Client
  • R_SUPLRBILLGDOCITEM.BUSINESSAREA == TGSB.GSBER
  • R_SUPLRBILLGDOCITEM.MANDT == TGSB.MANDT
Company Code
  • Client
  • Company Code
  • R_SUPLRBILLGDOCITEM.MANDT == T001.MANDT
  • R_SUPLRBILLGDOCITEM.COMPANYCODE == T001.BUKRS
Controlling Area
  • Controlling Area
  • Client
  • R_SUPLRBILLGDOCITEM.CONTROLLINGAREA == TKA01.KOKRS
  • R_SUPLRBILLGDOCITEM.MANDT == TKA01.MANDT
Customer Settlement Recipient
  • Customer Settlement Recipient
  • Client
  • R_SUPLRBILLGDOCITEM.CUSTOMERSETTLMTRECIPIENT == KNA1.KUNNR
  • R_SUPLRBILLGDOCITEM.MANDT == KNA1.MANDT
G/L Account
  • Client
  • G/L Account
  • ?
  • R_SUPLRBILLGDOCITEM.MANDT == SKA1.MANDT
  • R_SUPLRBILLGDOCITEM.GLACCOUNT == SKA1.SAKNR
  • R_SUPLRBILLGDOCITEM.[column in domain "KTOPL"] == SKA1.KTOPL
Incoterms (Part 1)
  • Client
  • Incoterms (Part 1)
  • R_SUPLRBILLGDOCITEM.MANDT == TINC.MANDT
  • R_SUPLRBILLGDOCITEM.INCOTERMSCLASSIFICATION == TINC.INCO1
Incoterms Version
  • Client
  • Incoterms Version
  • R_SUPLRBILLGDOCITEM.MANDT == TINCV.MANDT
  • R_SUPLRBILLGDOCITEM.INCOTERMSVERSION == TINCV.INCOV
Inventory Valuation Type
  • Client
  • Inventory Valuation Type
  • R_SUPLRBILLGDOCITEM.MANDT == T149D.MANDT
  • R_SUPLRBILLGDOCITEM.INVENTORYVALUATIONTYPE == T149D.BWTAR
Volume unit
  • Volume unit
  • Client
  • R_SUPLRBILLGDOCITEM.ITEMVOLUMEUNIT == T006.MSEHI
  • R_SUPLRBILLGDOCITEM.MANDT == T006.MANDT
Weight Unit
  • Weight Unit
  • Client
  • R_SUPLRBILLGDOCITEM.ITEMWEIGHTUNIT == T006.MSEHI
  • R_SUPLRBILLGDOCITEM.MANDT == T006.MANDT
Settlement Management Document Item Price Unit
  • Settlement Management Document Item Price Unit
  • Client
  • R_SUPLRBILLGDOCITEM.NETPRICEQUANTITYUNIT == T006.MSEHI
  • R_SUPLRBILLGDOCITEM.MANDT == T006.MANDT
Plant
  • Plant
  • Client
  • R_SUPLRBILLGDOCITEM.PLANT == T001W.WERKS
  • R_SUPLRBILLGDOCITEM.MANDT == T001W.MANDT
Prior Supplier
  • Client
  • Prior Supplier
  • R_SUPLRBILLGDOCITEM.MANDT == LFA1.MANDT
  • R_SUPLRBILLGDOCITEM.PRIORSUPPLIER == LFA1.LIFNR
Product Number
  • Product Number
  • Client
  • R_SUPLRBILLGDOCITEM.PRODUCT == MARA.MATNR
  • R_SUPLRBILLGDOCITEM.MANDT == MARA.MANDT
Product Group
  • Client
  • Product Group
  • R_SUPLRBILLGDOCITEM.MANDT == T023.MANDT
  • R_SUPLRBILLGDOCITEM.PRODUCTGROUP == T023.MATKL
Product hierarchy
  • Product hierarchy
  • Client
  • R_SUPLRBILLGDOCITEM.PRODUCTHIERARCHY == T179.PRODH
  • R_SUPLRBILLGDOCITEM.MANDT == T179.MANDT
Quantity Unit of Purchase Points of a Product
  • Quantity Unit of Purchase Points of a Product
  • Client
  • R_SUPLRBILLGDOCITEM.PRODUCTPURCHASEPOINTSQTYUNIT == T006.MSEHI
  • R_SUPLRBILLGDOCITEM.MANDT == T006.MANDT
Sales-Specific Product Group 1
  • Sales-Specific Product Group 1
  • Client
  • R_SUPLRBILLGDOCITEM.SALESSPCFCPRODUCTGROUP1 == TVM1.MVGR1
  • R_SUPLRBILLGDOCITEM.MANDT == TVM1.MANDT
Sales-Specific Product Group 2
  • Client
  • Sales-Specific Product Group 2
  • R_SUPLRBILLGDOCITEM.MANDT == TVM2.MANDT
  • R_SUPLRBILLGDOCITEM.SALESSPCFCPRODUCTGROUP2 == TVM2.MVGR2
Sales-Specific Product Group 3
  • Sales-Specific Product Group 3
  • Client
  • R_SUPLRBILLGDOCITEM.SALESSPCFCPRODUCTGROUP3 == TVM3.MVGR3
  • R_SUPLRBILLGDOCITEM.MANDT == TVM3.MANDT
Sales-Specific Product Group 4
  • Client
  • Sales-Specific Product Group 4
  • R_SUPLRBILLGDOCITEM.MANDT == TVM4.MANDT
  • R_SUPLRBILLGDOCITEM.SALESSPCFCPRODUCTGROUP4 == TVM4.MVGR4
Sales-Specific Product Group 5
  • Client
  • Sales-Specific Product Group 5
  • R_SUPLRBILLGDOCITEM.MANDT == TVM5.MANDT
  • R_SUPLRBILLGDOCITEM.SALESSPCFCPRODUCTGROUP5 == TVM5.MVGR5
Unit of Measure of Settlement Management Doc Item Quantity
  • Client
  • Unit of Measure of Settlement Management Doc Item Quantity
  • R_SUPLRBILLGDOCITEM.MANDT == T006.MANDT
  • R_SUPLRBILLGDOCITEM.SETTLMTQUANTITYUNIT == T006.MSEHI
Currency of Settlement Document
  • Client
  • Currency of Settlement Document
  • R_SUPLRBILLGDOCITEM.MANDT == TCURC.MANDT
  • R_SUPLRBILLGDOCITEM.SUPLRBILLGDOCCURRENCY == TCURC.WAERS
Activity Reason for Document Creation
  • Client
  • Activity Reason for Document Creation
  • R_SUPLRBILLGDOCITEM.MANDT == TMLFG.MANDT
  • R_SUPLRBILLGDOCITEM.SUPLRBILLGDOCITMACTYREASON == TMLFG.LFGRU
Order for Account Assignment in Settlement Management
  • Client
  • Order for Account Assignment in Settlement Management
  • R_SUPLRBILLGDOCITEM.MANDT == AUFK.MANDT
  • R_SUPLRBILLGDOCITEM.SUPPLIERBILLINGDOCUMENTORDER == AUFK.AUFNR
Supplier Subrange
  • Client
  • Prior Supplier
  • Supplier Subrange
  • R_SUPLRBILLGDOCITEM.MANDT == WYT1.MANDT
  • R_SUPLRBILLGDOCITEM.PRIORSUPPLIER == WYT1.LIFNR
  • R_SUPLRBILLGDOCITEM.SUPPLIERSUBRANGE == WYT1.LTSNR
Tax on Sales/Purchases Code
  • Client
  • Tax on Sales/Purchases Code
  • ?
  • R_SUPLRBILLGDOCITEM.MANDT == T007A.MANDT
  • R_SUPLRBILLGDOCITEM.TAXCODE == T007A.MWSKZ
  • R_SUPLRBILLGDOCITEM.[column in domain "KALSM_D"] == T007A.KALSM
Tax Jurisdiction
  • Client
  • Tax Jurisdiction
  • ?
  • R_SUPLRBILLGDOCITEM.MANDT == TTXJ.MANDT
  • R_SUPLRBILLGDOCITEM.TAXJURISDICTION == TTXJ.TXJCD
  • R_SUPLRBILLGDOCITEM.[column in domain "TAX_KALSM"] == TTXJ.KALSM