R_PersSettlmtDocDEX

Personnel Settlmt Doc Basic Extraction | view: RWLFPERSSTDOCDEX | Extraction: Not supported | Component: Settlement Management
Tables used: WBRK, WBRP, TMFK
Column Name Description
PersonnelSettlementDocument FK Personnel Settlement Document Number
PersSettlmtDocItem Document Item
Column Name Description
💲 Currency of Settlement Document (PersSettlmtDocCurrency):
PersSettlmtDocTotalNetAmount Net Settlement Amount in Document Currency
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 for Total Quantity (TotalSettlmtQuantityUnit):
TotalSettlmtQuantity Total Quantity of the Business Volume in a Settlement Run
📏 Unit of Weight for Total Weight (TotalSettlmtWeightUnit):
TotalSettlmtNetWeight Total Net Weight of the Business Volume in a Settlement Run
TotalSettlmtGrossWeight Total Gross Weight of the Bus Volume in a Settlement Run
📏 Volume Unit for Total Volume (TotalSettlmtVolumeUnit):
TotalSettlmtVolume Total Volume of the Business Volume in a Settlement Run
📏 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
PostingDate Posting Date
DocumentDate Document Date in Settlement Management Document
CreationDate Date of Document Creation
CreationTime Time of Document Creation
LastChangeDate Date of Last Document Change
ExchangeRateDate Exchange Rate Date
ActualSettlmtDate Actual Settlement Date
SettlmtDate Rebates: Settlement Date
SettlmtPeriodStartDate Start Date of Settlement Period
SettlmtPeriodEndDate End Date of Settlement Period
JournalEntryCreationDate Journal Entry Creation Date in UTC
JournalEntryCreationTime Journal Entry Creation Time in UTC
PricingDate Date for Pricing and Exchange Rate
ServicesRenderedDate Date of Services Rendered
Column Name Description
SettlmtDocCat Settlement Document Category Show values
LogisticsDataEntryCat Entry Category for Logistics Data Show values
SettlmtProcessCat Settlement Process Category Show values
PersSettlmtAcctgTransfSts Posting Status for Transfer to Financial Accounting Show values
ExchangeRateIsFixed Indicator for Fixed Exchange Rate Show values
PersSettlmtDocIsReversed Personnel Settlement Document Is Reversed Show values
SettlmtReltdRefDocCat Contract Category of Related Contract Show values
SettlmtDateCat Rebates: Settlement Date Type Show values
SettlmtBusProcCat Use Case Type Show values
CndnContrProcessCategory Process Category of a Condition Contract Show values
PostingPartnerCat Posting Partner Show values
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
DocumentReferenceID Reference Document Number XBLNR1
AssignmentReference Assignment number ZUONR
PricingDocument Number of the Document Condition KNUMV
CreatedByUser Name of User who Created the Document USNAM
ExchangeRate Conversion Rate (Not Converted)
PaymentReference Payment Reference CHAR30
SettlmtReltdRefDoc Related Contract in the Settlement Management Doc. WCONTRACT
SettlmtReltdCndnContr Related Condition Contract in Settlement Management WCB_COCO_NUM
FiscalPeriod Fiscal Period POPER
SettlmtDateSequentialID Settlement Date - Sequential ID WB2_SETTLEMENT_DATE_SEQ_ID
PersonWorkAgreement Personnel Number PERNR
PersonnelCostCenter Personnel Cost Center KOSTL
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
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_PERSSETTLMTDOCDEX.MANDT == T006.MANDT
  • R_PERSSETTLMTDOCDEX.BASEUNIT == T006.MSEHI
Business Area
  • Client
  • Business Area
  • R_PERSSETTLMTDOCDEX.MANDT == TGSB.MANDT
  • R_PERSSETTLMTDOCDEX.BUSINESSAREA == TGSB.GSBER
Condition Contract Type
  • Condition Contract Type
  • Client
Company Code
  • Client
  • Company Code
  • R_PERSSETTLMTDOCDEX.MANDT == T001.MANDT
  • R_PERSSETTLMTDOCDEX.COMPANYCODE == T001.BUKRS
Controlling Area
  • Client
  • Controlling Area
  • R_PERSSETTLMTDOCDEX.MANDT == TKA01.MANDT
  • R_PERSSETTLMTDOCDEX.CONTROLLINGAREA == TKA01.KOKRS
Distribution Channel
  • Client
  • Distribution Channel
  • R_PERSSETTLMTDOCDEX.MANDT == TVTW.MANDT
  • R_PERSSETTLMTDOCDEX.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • R_PERSSETTLMTDOCDEX.MANDT == TSPA.MANDT
  • R_PERSSETTLMTDOCDEX.DIVISION == TSPA.SPART
Exchange Rate Type
  • Client
  • Exchange Rate Type
  • R_PERSSETTLMTDOCDEX.MANDT == TCURV.MANDT
  • R_PERSSETTLMTDOCDEX.EXCHANGERATETYPE == TCURV.KURST
G/L Account
  • ?
  • Client
  • G/L Account
  • R_PERSSETTLMTDOCDEX.[column in domain "KTOPL"] == SKA1.KTOPL
  • R_PERSSETTLMTDOCDEX.MANDT == SKA1.MANDT
  • R_PERSSETTLMTDOCDEX.GLACCOUNT == SKA1.SAKNR
Volume unit
  • Client
  • Volume unit
  • R_PERSSETTLMTDOCDEX.MANDT == T006.MANDT
  • R_PERSSETTLMTDOCDEX.ITEMVOLUMEUNIT == T006.MSEHI
Weight Unit
  • Weight Unit
  • Client
  • R_PERSSETTLMTDOCDEX.ITEMWEIGHTUNIT == T006.MSEHI
  • R_PERSSETTLMTDOCDEX.MANDT == T006.MANDT
Settlement Management Document Item Price Unit
  • Client
  • Settlement Management Document Item Price Unit
  • R_PERSSETTLMTDOCDEX.MANDT == T006.MANDT
  • R_PERSSETTLMTDOCDEX.NETPRICEQUANTITYUNIT == T006.MSEHI
Header Activity Reason for Document Creation
  • Header Activity Reason for Document Creation
  • Activity Reason for Document Creation
  • Client
  • R_PERSSETTLMTDOCDEX.PERSSETTLMTDOCACTIVITYREASON == TMLFG.LFGRU
  • R_PERSSETTLMTDOCDEX.PERSSETTLMTDOCITMACTYREASON == TMLFG.LFGRU
  • R_PERSSETTLMTDOCDEX.MANDT == TMLFG.MANDT
Currency of Settlement Document
  • Client
  • Currency of Settlement Document
  • R_PERSSETTLMTDOCDEX.MANDT == TCURC.MANDT
  • R_PERSSETTLMTDOCDEX.PERSSETTLMTDOCCURRENCY == TCURC.WAERS
Incompleteness Reason of Settlement Management Document
  • Client
  • Incompleteness Reason of Settlement Management Document
  • R_PERSSETTLMTDOCDEX.MANDT == TWLF_IR.MANDT
  • R_PERSSETTLMTDOCDEX.PERSSETTLMTDOCINCMPLTNSRSN == TWLF_IR.INCOMPL_REASON
Activity Reason for Document Creation
  • Header Activity Reason for Document Creation
  • Activity Reason for Document Creation
  • Client
  • R_PERSSETTLMTDOCDEX.PERSSETTLMTDOCACTIVITYREASON == TMLFG.LFGRU
  • R_PERSSETTLMTDOCDEX.PERSSETTLMTDOCITMACTYREASON == TMLFG.LFGRU
  • R_PERSSETTLMTDOCDEX.MANDT == TMLFG.MANDT
Order for Account Assignment in Settlement Management
  • Client
  • Order for Account Assignment in Settlement Management
  • R_PERSSETTLMTDOCDEX.MANDT == AUFK.MANDT
  • R_PERSSETTLMTDOCDEX.PERSSETTLMTDOCORDER == AUFK.AUFNR
Plant
  • Client
  • Plant
  • R_PERSSETTLMTDOCDEX.MANDT == T001W.MANDT
  • R_PERSSETTLMTDOCDEX.PLANT == T001W.WERKS
Pricing Procedure
  • Client
  • ?
  • Pricing Procedure
  • ?
  • R_PERSSETTLMTDOCDEX.MANDT == T683.MANDT
  • R_PERSSETTLMTDOCDEX.[column in domain "KVEWE"] == T683.KVEWE
  • R_PERSSETTLMTDOCDEX.PRICINGPROCEDURE == T683.KALSM
  • R_PERSSETTLMTDOCDEX.[column in domain "KAPPL"] == T683.KAPPL
Product Number
  • Client
  • Product Number
  • R_PERSSETTLMTDOCDEX.MANDT == MARA.MANDT
  • R_PERSSETTLMTDOCDEX.PRODUCT == MARA.MATNR
Product Group
  • Client
  • Product Group
  • R_PERSSETTLMTDOCDEX.MANDT == T023.MANDT
  • R_PERSSETTLMTDOCDEX.PRODUCTGROUP == T023.MATKL
Product hierarchy
  • Client
  • Product hierarchy
  • R_PERSSETTLMTDOCDEX.MANDT == T179.MANDT
  • R_PERSSETTLMTDOCDEX.PRODUCTHIERARCHY == T179.PRODH
Check Sales Group
  • Client
  • Sales group
  • R_PERSSETTLMTDOCDEX.MANDT == TVKGR.MANDT
  • R_PERSSETTLMTDOCDEX.SALESGROUP == TVKGR.VKGRP
Check Sales Office
  • Client
  • Sales office
  • R_PERSSETTLMTDOCDEX.MANDT == TVBUR.MANDT
  • R_PERSSETTLMTDOCDEX.SALESOFFICE == TVBUR.VKBUR
Sales Organization
  • Client
  • Sales Organization
  • R_PERSSETTLMTDOCDEX.MANDT == TVKO.MANDT
  • R_PERSSETTLMTDOCDEX.SALESORGANIZATION == TVKO.VKORG
Sales-Specific Product Group 1
  • Client
  • Sales-Specific Product Group 1
  • R_PERSSETTLMTDOCDEX.MANDT == TVM1.MANDT
  • R_PERSSETTLMTDOCDEX.SALESSPCFCPRODUCTGROUP1 == TVM1.MVGR1
Sales-Specific Product Group 2
  • Client
  • Sales-Specific Product Group 2
  • R_PERSSETTLMTDOCDEX.MANDT == TVM2.MANDT
  • R_PERSSETTLMTDOCDEX.SALESSPCFCPRODUCTGROUP2 == TVM2.MVGR2
Sales-Specific Product Group 3
  • Client
  • Sales-Specific Product Group 3
  • R_PERSSETTLMTDOCDEX.MANDT == TVM3.MANDT
  • R_PERSSETTLMTDOCDEX.SALESSPCFCPRODUCTGROUP3 == TVM3.MVGR3
Sales-Specific Product Group 4
  • Client
  • Sales-Specific Product Group 4
  • R_PERSSETTLMTDOCDEX.MANDT == TVM4.MANDT
  • R_PERSSETTLMTDOCDEX.SALESSPCFCPRODUCTGROUP4 == TVM4.MVGR4
Sales-Specific Product Group 5
  • Client
  • Sales-Specific Product Group 5
  • R_PERSSETTLMTDOCDEX.MANDT == TVM5.MANDT
  • R_PERSSETTLMTDOCDEX.SALESSPCFCPRODUCTGROUP5 == TVM5.MVGR5
Application Status for a Settlement Management Document
  • Client
  • Application Status for a Settlement Management Document
  • R_PERSSETTLMTDOCDEX.MANDT == TMPA2.MANDT
  • R_PERSSETTLMTDOCDEX.SETTLMTAPPLSTS == TMPA2.ESTATUS
Status Group for Settlement Management Documents
  • Client
  • Status Group for Settlement Management Documents
  • R_PERSSETTLMTDOCDEX.MANDT == TMPA4.MANDT
  • R_PERSSETTLMTDOCDEX.SETTLMTAPPLSTSGRP == TMPA4.STATGRP
Compensation Reason for a Settlement Management Document
  • Client
  • Compensation Reason for a Settlement Management Document
Compensation Variant
  • Client
  • Compensation Variant
Settlement Document Type
  • Settlement Document Type
  • Client
  • R_PERSSETTLMTDOCDEX.SETTLMTDOCTYPE == TMFK.LFART
  • R_PERSSETTLMTDOCDEX.MANDT == TMFK.MANDT
Settlement Process Type
  • Client
  • Settlement Process Type
  • R_PERSSETTLMTDOCDEX.MANDT == TMZR.MANDT
  • R_PERSSETTLMTDOCDEX.SETTLMTPROCESSTYPE == TMZR.WRART
Unit of Measure of Settlement Management Doc Item Quantity
  • Client
  • Unit of Measure of Settlement Management Doc Item Quantity
  • R_PERSSETTLMTDOCDEX.MANDT == T006.MANDT
  • R_PERSSETTLMTDOCDEX.SETTLMTQUANTITYUNIT == T006.MSEHI
Volume Unit for Total Volume
  • Client
  • Volume Unit for Total Volume
  • R_PERSSETTLMTDOCDEX.MANDT == T006.MANDT
  • R_PERSSETTLMTDOCDEX.TOTALSETTLMTVOLUMEUNIT == T006.MSEHI
Unit of Weight for Total Weight
  • Client
  • Unit of Weight for Total Weight
  • R_PERSSETTLMTDOCDEX.MANDT == T006.MANDT
  • R_PERSSETTLMTDOCDEX.TOTALSETTLMTWEIGHTUNIT == T006.MSEHI