C_MntrPersSettlmtDoc

Monitor Personnel Settlement Documents | view: CWLFPSDOCMON | Extraction: Not supported | Component: Settlement Management
Column Name Description
PersonnelSettlementDocument Personnel Settlement Document Number
Column Name Description
💲 Currency of Settlement Document (PersSettlmtDocCurrency):
TotalNetAmount Personnel Total Net Amount In Document Currency
💲 Display Currency (DisplayCurrency):
CnvrtdTotalNetAmount Converted Personnel Total Net Amount in Display Currency
Column Name Description
Column Name Description
DocumentDate Document Date in Settlement Management Document
PostingDate Posting Date
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
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
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
SettlmtBusProcCat Use Case Type Show values
PersSettlmtAcctgTransfStsCritl Criticality of the Accounting Transfer Status Show values
Column Name Description Domain name
SettlmtDocTypeDesc Settlement Document Type Description TEXT40
SettlmtProcessTypeDesc Settlement Process Type Description TEXT40
FiscalPeriod Fiscal Period POPER
PersSettlmtAcctgTransfStsName Description of Posting Status DDTEXT
PersonWorkAgreement Personnel Number PERNR
PersonFullName Full Name TEXT80
CompanyCodeName Name of Company Code or Company TEXT25
PersonnelCostCenter Personnel Cost Center KOSTL
CreatedByUser Name of User who Created the Document USNAM
CreatedByUserFullName Created By User Full Name
CreationDateTime Date and Time of Document Creation TZNTSTMPS
PaymentReference Payment Reference CHAR30
DocumentReferenceID Reference Document Number XBLNR1
AssignmentReference Assignment number ZUONR
ExchangeRate Conversion Rate (Not Converted)
SettlmtCompnRsnDesc Settlement Compensation Reason Description AS4TEXT
SettlmtCompnVarDesc Compensation Variant Description TEXT100
CalendarYear Calendar Year NUM4
CalendarQuarter Calendar Quarter NUM1
CalendarQuarterName Short Text for Fixed Values
YearQuarter Year Quarter NUM5
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • C_MNTRPERSSETTLMTDOC.COMPANYCODE == T001.BUKRS
  • C_MNTRPERSSETTLMTDOC.MANDT == T001.MANDT
Controlling Area
  • Controlling Area
  • Client
  • C_MNTRPERSSETTLMTDOC.CONTROLLINGAREA == TKA01.KOKRS
  • C_MNTRPERSSETTLMTDOC.MANDT == TKA01.MANDT
Distribution Channel
  • Distribution Channel
  • Client
  • C_MNTRPERSSETTLMTDOC.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • C_MNTRPERSSETTLMTDOC.MANDT == TVTW.MANDT
Division
  • Client
  • Division
  • C_MNTRPERSSETTLMTDOC.MANDT == TSPA.MANDT
  • C_MNTRPERSSETTLMTDOC.DIVISION == TSPA.SPART
Exchange Rate Type
  • Exchange Rate Type
  • Client
  • C_MNTRPERSSETTLMTDOC.EXCHANGERATETYPE == TCURV.KURST
  • C_MNTRPERSSETTLMTDOC.MANDT == TCURV.MANDT
Currency of Settlement Document
  • Client
  • Currency of Settlement Document
  • C_MNTRPERSSETTLMTDOC.MANDT == TCURC.MANDT
  • C_MNTRPERSSETTLMTDOC.PERSSETTLMTDOCCURRENCY == TCURC.WAERS
Sales Organization
  • Client
  • Sales Organization
  • C_MNTRPERSSETTLMTDOC.MANDT == TVKO.MANDT
  • C_MNTRPERSSETTLMTDOC.SALESORGANIZATION == TVKO.VKORG
Application Status for a Settlement Management Document
  • Application Status for a Settlement Management Document
  • Client
  • C_MNTRPERSSETTLMTDOC.SETTLMTAPPLSTS == TMPA2.ESTATUS
  • C_MNTRPERSSETTLMTDOC.MANDT == TMPA2.MANDT
Status Group for Settlement Management Documents
  • Client
  • Status Group for Settlement Management Documents
  • C_MNTRPERSSETTLMTDOC.MANDT == TMPA4.MANDT
  • C_MNTRPERSSETTLMTDOC.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
  • Header Activity Reason for Document Creation
  • Client
  • C_MNTRPERSSETTLMTDOC.SETTLMTDOCACTIVITYREASON == TMLFG.LFGRU
  • C_MNTRPERSSETTLMTDOC.MANDT == TMLFG.MANDT
Settlement Document Type
  • Client
  • Settlement Document Type
  • C_MNTRPERSSETTLMTDOC.MANDT == TMFK.MANDT
  • C_MNTRPERSSETTLMTDOC.SETTLMTDOCTYPE == TMFK.LFART
Settlement Process Type
  • Client
  • Settlement Process Type
  • C_MNTRPERSSETTLMTDOC.MANDT == TMZR.MANDT
  • C_MNTRPERSSETTLMTDOC.SETTLMTPROCESSTYPE == TMZR.WRART