ESH_N_PERSSETTLMTDOC

Anchor view -PERSSETTLMTDOC | view: ESH_L_PERSSMTDOC | Extraction: Not supported | Component: Settlement Management
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
Column Name Description
ACTUALSETTLMTDATE Actual Settlement Date
CREATIONDATE Date of Document Creation
DOCUMENTDATE Document Date in Settlement Management Document
POSTINGDATE Posting Date
Column Name Description
PERSSETTLMTACCTGTRANSFSTS Posting Status for Transfer to Financial Accounting Show values
Column Name Description Domain name
ASSIGNMENTREFERENCE Assignment number ZUONR
COMPANYCODENAME Name of Company Code or Company TEXT25
CREATEDBYUSER Name of User who Created the Document USNAM
DOCUMENTREFERENCEID Reference Document Number XBLNR1
PAYMENTREFERENCE Payment Reference CHAR30
PERSONFULLNAME Full Name TEXT80
PERSONNELCOSTCENTER Personnel Cost Center KOSTL
PERSONWORKAGREEMENT Personnel Number PERNR
PERSSETTLMTACCTGTRANSFSTSNAME Short Text for Fixed Values DDTEXT
SETTLMTACTIVITYREASONDESC Description TEXT100
SETTLMTAPPLSTS Application Status for a Settlement Management Document WSTATE
SETTLMTAPPLSTSDESC Application Status Description TEXT40
SETTLMTCOMPNRSNDESC Settlement Compensation Reason Description AS4TEXT
SETTLMTDOCTYPEDESC Settlement Document Type Description TEXT40
USERDESCRIPTION User Description SUIDTECHDESC
Master Data Relations Join Conditions
Authorization Group
  • Client
  • Authorization Group
  • ?
  • ESH_N_PERSSETTLMTDOC.MANDT == TB037.CLIENT
  • ESH_N_PERSSETTLMTDOC.AUTHORIZATIONGROUP == TB037.AUGRP
  • ESH_N_PERSSETTLMTDOC.[column in domain "BU_AUOBJ"] == TB037.AUOBJ
Company Code
  • Client
  • Company Code
  • ESH_N_PERSSETTLMTDOC.MANDT == T001.MANDT
  • ESH_N_PERSSETTLMTDOC.COMPANYCODE == T001.BUKRS
Distribution Channel
  • Client
  • Distribution Channel
  • ESH_N_PERSSETTLMTDOC.MANDT == TVTW.MANDT
  • ESH_N_PERSSETTLMTDOC.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • ESH_N_PERSSETTLMTDOC.MANDT == TSPA.MANDT
  • ESH_N_PERSSETTLMTDOC.DIVISION == TSPA.SPART
Currency of Settlement Document
  • Client
  • Currency of Settlement Document
  • ESH_N_PERSSETTLMTDOC.MANDT == TCURC.MANDT
  • ESH_N_PERSSETTLMTDOC.PERSSETTLMTDOCCURRENCY == TCURC.WAERS
Sales Organization
  • Client
  • Sales Organization
  • ESH_N_PERSSETTLMTDOC.MANDT == TVKO.MANDT
  • ESH_N_PERSSETTLMTDOC.SALESORGANIZATION == TVKO.VKORG
Compensation Reason for a Settlement Management Document
  • Client
  • Compensation Reason for a Settlement Management Document
Header Activity Reason for Document Creation
  • Header Activity Reason for Document Creation
  • Client
  • ESH_N_PERSSETTLMTDOC.SETTLMTDOCACTIVITYREASON == TMLFG.LFGRU
  • ESH_N_PERSSETTLMTDOC.MANDT == TMLFG.MANDT
Settlement Document Type
  • Client
  • Settlement Document Type
  • ESH_N_PERSSETTLMTDOC.MANDT == TMFK.MANDT
  • ESH_N_PERSSETTLMTDOC.SETTLMTDOCTYPE == TMFK.LFART
Settlement Process Type
  • Client
  • Settlement Process Type
  • ESH_N_PERSSETTLMTDOC.MANDT == TMZR.MANDT
  • ESH_N_PERSSETTLMTDOC.SETTLMTPROCESSTYPE == TMZR.WRART