R_PersSettlmtDocItem

Personnel Settlement Document Item | view: RWLFPERSMTDOCITM | TRAN | Extraction: Not supported | Component: Settlement Management
Tables used: WBRK, WBRP
Column Name Description
PersonnelSettlementDocument FK Personnel Settlement Document Number
PersSettlmtDocItem Document Item
Column Name Description
💲 Currency of Settlement Document (PersSettlmtDocCurrency):
NetPriceAmount Net Price in Document Currency
PersSettlmtDocItemNetAmount Net Amount of Item in Document Currency
PersSettlmtDocSubtotal1Amount Subtotal 1 Amount
PersSettlmtDocSubtotal2Amount Subtotal 2 Amount
PersSettlmtDocSubtotal3Amount Subtotal 3 Amount
PersSettlmtDocSubtotal4Amount Subtotal 4 Amount
PersSettlmtDocSubtotal5Amount Subtotal 5 Amount
PersSettlmtDocSubtotal6Amount Subtotal 6 Amount
PersSettlmtDocRbteBasisAmount Rebate Basis 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
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
PersSettlmtDocItmStstclPrpty Statistical Property of Settlement Management Item Show values
PrcDetnIsIncmplt Price Determination is Incomplete Show values
PersSettlmtDocItemCat Item Category Show values
SettlmtItemReltdRefDocCat Settlement Item Related Reference Document Category Show values
PersSettlmtDocItemStatus Item Status Show values
PersSettlmtDocItemRvsd Item Was Canceled 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
PersSettlmtDocItemText Short Text TEXT40
CostCenter Cost Center KOSTL
ProfitCenter Profit Center PRCTR
SettlmtItemReltdRefDoc Settlement Item Related Reference Document WCONTRACT
SettlmtItemReltdCndnContr Related Condition Contract of a Settlement Management Item WCB_COCO_NUM
SettlementFiscalYear Fiscal Year of Settlement GJAHR
BusTransDocReferenceID BusinessTransactionDocumentID
BusTransDocReferenceItemID BusinessTransactionDocumentItemID CHAR10
Master Data Relations Join Conditions
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • R_PERSSETTLMTDOCITEM.MANDT == T006.MANDT
  • R_PERSSETTLMTDOCITEM.BASEUNIT == T006.MSEHI
Business Area
  • Business Area
  • Client
  • R_PERSSETTLMTDOCITEM.BUSINESSAREA == TGSB.GSBER
  • R_PERSSETTLMTDOCITEM.MANDT == TGSB.MANDT
Company Code
  • Client
  • Company Code
  • R_PERSSETTLMTDOCITEM.MANDT == T001.MANDT
  • R_PERSSETTLMTDOCITEM.COMPANYCODE == T001.BUKRS
Controlling Area
  • Client
  • Controlling Area
  • R_PERSSETTLMTDOCITEM.MANDT == TKA01.MANDT
  • R_PERSSETTLMTDOCITEM.CONTROLLINGAREA == TKA01.KOKRS
G/L Account
  • ?
  • Client
  • G/L Account
  • R_PERSSETTLMTDOCITEM.[column in domain "KTOPL"] == SKA1.KTOPL
  • R_PERSSETTLMTDOCITEM.MANDT == SKA1.MANDT
  • R_PERSSETTLMTDOCITEM.GLACCOUNT == SKA1.SAKNR
Volume unit
  • Client
  • Volume unit
  • R_PERSSETTLMTDOCITEM.MANDT == T006.MANDT
  • R_PERSSETTLMTDOCITEM.ITEMVOLUMEUNIT == T006.MSEHI
Weight Unit
  • Client
  • Weight Unit
  • R_PERSSETTLMTDOCITEM.MANDT == T006.MANDT
  • R_PERSSETTLMTDOCITEM.ITEMWEIGHTUNIT == T006.MSEHI
Settlement Management Document Item Price Unit
  • Client
  • Settlement Management Document Item Price Unit
  • R_PERSSETTLMTDOCITEM.MANDT == T006.MANDT
  • R_PERSSETTLMTDOCITEM.NETPRICEQUANTITYUNIT == T006.MSEHI
Currency of Settlement Document
  • Currency of Settlement Document
  • Client
  • R_PERSSETTLMTDOCITEM.PERSSETTLMTDOCCURRENCY == TCURC.WAERS
  • R_PERSSETTLMTDOCITEM.MANDT == TCURC.MANDT
Activity Reason for Document Creation
  • Client
  • Activity Reason for Document Creation
  • R_PERSSETTLMTDOCITEM.MANDT == TMLFG.MANDT
  • R_PERSSETTLMTDOCITEM.PERSSETTLMTDOCITMACTYREASON == TMLFG.LFGRU
Order for Account Assignment in Settlement Management
  • Client
  • Order for Account Assignment in Settlement Management
  • R_PERSSETTLMTDOCITEM.MANDT == AUFK.MANDT
  • R_PERSSETTLMTDOCITEM.PERSSETTLMTDOCORDER == AUFK.AUFNR
Plant
  • Client
  • Plant
  • R_PERSSETTLMTDOCITEM.MANDT == T001W.MANDT
  • R_PERSSETTLMTDOCITEM.PLANT == T001W.WERKS
Product Number
  • Product Number
  • Client
  • R_PERSSETTLMTDOCITEM.PRODUCT == MARA.MATNR
  • R_PERSSETTLMTDOCITEM.MANDT == MARA.MANDT
Product Group
  • Client
  • Product Group
  • R_PERSSETTLMTDOCITEM.MANDT == T023.MANDT
  • R_PERSSETTLMTDOCITEM.PRODUCTGROUP == T023.MATKL
Product hierarchy
  • Client
  • Product hierarchy
  • R_PERSSETTLMTDOCITEM.MANDT == T179.MANDT
  • R_PERSSETTLMTDOCITEM.PRODUCTHIERARCHY == T179.PRODH
Sales-Specific Product Group 1
  • Client
  • Sales-Specific Product Group 1
  • R_PERSSETTLMTDOCITEM.MANDT == TVM1.MANDT
  • R_PERSSETTLMTDOCITEM.SALESSPCFCPRODUCTGROUP1 == TVM1.MVGR1
Sales-Specific Product Group 2
  • Client
  • Sales-Specific Product Group 2
  • R_PERSSETTLMTDOCITEM.MANDT == TVM2.MANDT
  • R_PERSSETTLMTDOCITEM.SALESSPCFCPRODUCTGROUP2 == TVM2.MVGR2
Sales-Specific Product Group 3
  • Sales-Specific Product Group 3
  • Client
  • R_PERSSETTLMTDOCITEM.SALESSPCFCPRODUCTGROUP3 == TVM3.MVGR3
  • R_PERSSETTLMTDOCITEM.MANDT == TVM3.MANDT
Sales-Specific Product Group 4
  • Client
  • Sales-Specific Product Group 4
  • R_PERSSETTLMTDOCITEM.MANDT == TVM4.MANDT
  • R_PERSSETTLMTDOCITEM.SALESSPCFCPRODUCTGROUP4 == TVM4.MVGR4
Sales-Specific Product Group 5
  • Client
  • Sales-Specific Product Group 5
  • R_PERSSETTLMTDOCITEM.MANDT == TVM5.MANDT
  • R_PERSSETTLMTDOCITEM.SALESSPCFCPRODUCTGROUP5 == TVM5.MVGR5
Unit of Measure of Settlement Management Doc Item Quantity
  • Client
  • Unit of Measure of Settlement Management Doc Item Quantity
  • R_PERSSETTLMTDOCITEM.MANDT == T006.MANDT
  • R_PERSSETTLMTDOCITEM.SETTLMTQUANTITYUNIT == T006.MSEHI