I_PersSettlmtDoc

Personnel Settlement Document | view: IWLFPERSSMTDOC | ATTR | Extraction: Not supported | Component: Settlement Management
Tables used: WBRKWBRK
Column Name Description
PersonnelSettlementDocument Personnel Settlement Document Number
Column Name Description
💲 Currency of Settlement Document (PersSettlmtDocCurrency):
TotalNetAmount Net Settlement Amount in Document Currency
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
Column Name Description
PostingDate Posting Date
CreationDate Date of Document Creation
CreationTime Time of Document Creation
LastChangeDate Date of Last Document Change
DocumentDate Document Date in Settlement Management Document
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
Column Name Description
SettlmtDocCat Settlement Document Category Show values
SettlmtProcessCat Settlement Process Category Show values
LogisticsDataEntryCat Entry Category for Logistics Data Show values
PersSettlmtAcctgTransfSts Posting Status for Transfer to Financial Accounting Show values
ExchangeRateIsFixed Indicator for Fixed Exchange Rate Show values
PersSettlmtDocIsReversed Settlement Document is Reversed Show values
SettlmtDateCat Rebates: Settlement Date Type Show values
SettlmtBusProcCat Use Case Type Show values
PostingPartnerCat Posting Partner Show values
CndnContrProcessCategory Process Category of a Condition Contract Show values
Column Name Description Domain name
PricingProcedure Pricing Procedure KALSM
PricingDocument Number of the Document Condition KNUMV
CreatedByUser Name of User who Created the Document USNAM
DocumentReferenceID Reference Document Number XBLNR1
AssignmentReference Assignment number ZUONR
ExchangeRate Conversion Rate (Not Converted)
PaymentReference Payment Reference CHAR30
SettlmtReltdCndnContr Related Condition Contract in Settlement Management WCB_COCO_NUM
SettlmtDateSequentialID Settlement Date - Sequential ID WB2_SETTLEMENT_DATE_SEQ_ID
PersonWorkAgreement Personnel Number PERNR
PersonnelCostCenter Personnel Cost Center KOSTL
FiscalPeriod Fiscal Period POPER
PersSettlmtDocChangeState Change State of a Settlement Management Document (ETag) WLF_CHANGE_STATE
Master Data Relations Join Conditions
Condition Contract Type
  • Condition Contract Type
  • Client
Company Code
  • Company Code
  • Client
  • I_PERSSETTLMTDOC.COMPANYCODE == T001.BUKRS
  • I_PERSSETTLMTDOC.MANDT == T001.MANDT
Distribution Channel
  • Distribution Channel
  • Client
  • I_PERSSETTLMTDOC.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • I_PERSSETTLMTDOC.MANDT == TVTW.MANDT
Division
  • Client
  • Division
  • I_PERSSETTLMTDOC.MANDT == TSPA.MANDT
  • I_PERSSETTLMTDOC.DIVISION == TSPA.SPART
Exchange Rate Type
  • Exchange Rate Type
  • Client
  • I_PERSSETTLMTDOC.EXCHANGERATETYPE == TCURV.KURST
  • I_PERSSETTLMTDOC.MANDT == TCURV.MANDT
Currency of Settlement Document
  • Currency of Settlement Document
  • Client
  • I_PERSSETTLMTDOC.PERSSETTLMTDOCCURRENCY == TCURC.WAERS
  • I_PERSSETTLMTDOC.MANDT == TCURC.MANDT
Incompleteness Reason of Settlement Management Document
  • Incompleteness Reason of Settlement Management Document
  • Client
  • I_PERSSETTLMTDOC.PERSSETTLMTDOCINCMPLTNSRSN == TWLF_IR.INCOMPL_REASON
  • I_PERSSETTLMTDOC.MANDT == TWLF_IR.MANDT
Check Sales Group
  • Client
  • Sales group
  • I_PERSSETTLMTDOC.MANDT == TVKGR.MANDT
  • I_PERSSETTLMTDOC.SALESGROUP == TVKGR.VKGRP
Check Sales Office
  • Sales office
  • Client
  • I_PERSSETTLMTDOC.SALESOFFICE == TVBUR.VKBUR
  • I_PERSSETTLMTDOC.MANDT == TVBUR.MANDT
Sales Organization
  • Sales Organization
  • Client
  • I_PERSSETTLMTDOC.SALESORGANIZATION == TVKO.VKORG
  • I_PERSSETTLMTDOC.MANDT == TVKO.MANDT
Application Status for a Settlement Management Document
  • Application Status for a Settlement Management Document
  • Client
  • I_PERSSETTLMTDOC.SETTLMTAPPLSTS == TMPA2.ESTATUS
  • I_PERSSETTLMTDOC.MANDT == TMPA2.MANDT
Status Group for Settlement Management Documents
  • Client
  • Status Group for Settlement Management Documents
  • I_PERSSETTLMTDOC.MANDT == TMPA4.MANDT
  • I_PERSSETTLMTDOC.SETTLMTAPPLSTSGRP == TMPA4.STATGRP
Compensation Reason for a Settlement Management Document
  • Compensation Reason for a Settlement Management Document
  • Client
Compensation Variant
  • Compensation Variant
  • Client
Header Activity Reason for Document Creation
  • Client
  • Header Activity Reason for Document Creation
  • I_PERSSETTLMTDOC.MANDT == TMLFG.MANDT
  • I_PERSSETTLMTDOC.SETTLMTDOCACTIVITYREASON == TMLFG.LFGRU
Settlement Document Type
  • Settlement Document Type
  • Client
  • I_PERSSETTLMTDOC.SETTLMTDOCTYPE == TMFK.LFART
  • I_PERSSETTLMTDOC.MANDT == TMFK.MANDT
Settlement Process Type
  • Client
  • Settlement Process Type
  • I_PERSSETTLMTDOC.MANDT == TMZR.MANDT
  • I_PERSSETTLMTDOC.SETTLMTPROCESSTYPE == TMZR.WRART
Volume Unit for Total Volume
  • Volume Unit for Total Volume
  • Client
  • I_PERSSETTLMTDOC.TOTALSETTLMTVOLUMEUNIT == T006.MSEHI
  • I_PERSSETTLMTDOC.MANDT == T006.MANDT
Unit of Weight for Total Weight
  • Client
  • Unit of Weight for Total Weight
  • I_PERSSETTLMTDOC.MANDT == T006.MANDT
  • I_PERSSETTLMTDOC.TOTALSETTLMTWEIGHTUNIT == T006.MSEHI