ESH_N_PERSSETTLMTDOC

DDL: ESH_N_PERSSETTLMTDOC SQL: ESH_L_PERSSMTDOC Type: view
32 Fields 1 Data Sources 2 Associations

ESH_N_PERSSETTLMTDOC is a CDS View in SAP S/4HANA. It reads from 1 data source (I_PERSSETTLMTDOC) and exposes 32 fields with key field PERSONNELSETTLEMENTDOCUMENT. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_PERSSETTLMTDOC I_PERSSETTLMTDOC from

Parameters (1)

NameTypeDefault
P_Language abap.lang

Associations (2)

CardinalityTargetAliasCondition
[0..1] N_PERSONWORKAGREEMENT_1 _PERSONWORKAGREEMENT $projection.PersonWorkAgreement=_PERSONWORKAGREEMENT.PersonWorkAgreement
[0..*] dd07t _PERSSETTLMTACCTGTRANSFSTS $projection.PersSettlmtAcctgTransfSts=_PERSSETTLMTACCTGTRANSFSTS.domvalue_l and _PERSSETTLMTACCTGTRANSFSTS.domname='WFBSK' and _PERSSETTLMTACCTGTRANSFSTS.as4local='A'

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName ESH_L_PERSSMTDOC view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY PERSONNELSETTLEMENTDOCUMENT PERSONNELSETTLEMENTDOCUMENT Personnel Settlement Document
ACTUALSETTLMTDATE ACTUALSETTLMTDATE Actual Settl. Date
ASSIGNMENTREFERENCE ASSIGNMENTREFERENCE Assignment Reference
AUTHORIZATIONGROUP _PERSONWORKAGREEMENT AUTHORIZATIONGROUP AuthorizGroup
COMPANYCODE COMPANYCODE Receiver Company Code
COMPANYCODENAME _COMPANYCODE COMPANYCODENAME Company Name
CREATEDBYUSER CREATEDBYUSER User Name
CREATIONDATE CREATIONDATE Time Stamp
DISTRIBUTIONCHANNEL DISTRIBUTIONCHANNEL RefDistCh-Cust/Mat.
DIVISION DIVISION Internal Division ID
DOCUMENTDATE DOCUMENTDATE Journal Entry Date
DOCUMENTREFERENCEID DOCUMENTREFERENCEID Reference
PAYMENTREFERENCE PAYMENTREFERENCE Payment Reference
PERSONFULLNAME _PERSONWORKAGREEMENT PERSONFULLNAME Full Name
PERSONNELCOSTCENTER PERSONNELCOSTCENTER Worker Cost Center
PERSONWORKAGREEMENT PERSONWORKAGREEMENT Personnel No.
PERSSETTLMTACCTGTRANSFSTS PERSSETTLMTACCTGTRANSFSTS Posting Status
PERSSETTLMTACCTGTRANSFSTSNAME
PERSSETTLMTDOCCURRENCY PERSSETTLMTDOCCURRENCY Doc. Currency
POSTINGDATE POSTINGDATE Posting Date for GR
SALESORGANIZATION SALESORGANIZATION Sales Organization
SETTLMTACTIVITYREASONDESC
SETTLMTAPPLSTS _SETTLMTAPPLSTS SETTLMTAPPLSTS Appl. Status
SETTLMTAPPLSTSDESC
SETTLMTCOMPENSATIONREASON SETTLMTCOMPENSATIONREASON Compensation Reason
SETTLMTCOMPNRSNDESC
SETTLMTDOCACTIVITYREASON SETTLMTDOCACTIVITYREASON Header Document Creation Activity Reason
SETTLMTDOCTYPE SETTLMTDOCTYPE Settlement Document Type
SETTLMTDOCTYPEDESC
SETTLMTPROCESSTYPE SETTLMTPROCESSTYPE Settlement Process Type
TOTALNETAMOUNT TOTALNETAMOUNT Total Net Amount
USERDESCRIPTION _CREATEDBYUSER USERDESCRIPTION Full Name

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view ESH_N_PERSSETTLMTDOC.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: ESH_L_PERSSMTDOC
-- Parameters: P_Language : abap.lang

CREATE VIEW ESH_N_PERSSETTLMTDOC AS
SELECT
  PERSONNELSETTLEMENTDOCUMENT,
  ACTUALSETTLMTDATE,
  ASSIGNMENTREFERENCE,
  _PERSONWORKAGREEMENT.AUTHORIZATIONGROUP AS AUTHORIZATIONGROUP,
  COMPANYCODE,
  _COMPANYCODE.COMPANYCODENAME AS COMPANYCODENAME,
  CREATEDBYUSER,
  CREATIONDATE,
  DISTRIBUTIONCHANNEL,
  DIVISION,
  DOCUMENTDATE,
  DOCUMENTREFERENCEID,
  PAYMENTREFERENCE,
  _PERSONWORKAGREEMENT.PERSONFULLNAME AS PERSONFULLNAME,
  PERSONNELCOSTCENTER,
  PERSONWORKAGREEMENT,
  PERSSETTLMTACCTGTRANSFSTS,
  _PERSSETTLMTACCTGTRANSFSTS[1: ddlanguage = $parameters. P_Language].ddtext AS PERSSETTLMTACCTGTRANSFSTSNAME,
  PERSSETTLMTDOCCURRENCY,
  POSTINGDATE,
  SALESORGANIZATION,
  _SETTLMTDOCACTIVITYREASON._TEXT[1: Language = $parameters. P_Language].SETTLMTACTIVITYREASONDESC AS SETTLMTACTIVITYREASONDESC,
  _SETTLMTAPPLSTS.SETTLMTAPPLSTS AS SETTLMTAPPLSTS,
  _SETTLMTAPPLSTS._TEXT[1: Language = $parameters. P_Language].SETTLMTAPPLSTSDESC AS SETTLMTAPPLSTSDESC,
  SETTLMTCOMPENSATIONREASON,
  _SETTLMTCOMPNRSN._TEXT[1: Language = $parameters. P_Language].SETTLMTCOMPNRSNDESC AS SETTLMTCOMPNRSNDESC,
  SETTLMTDOCACTIVITYREASON,
  SETTLMTDOCTYPE,
  _SETTLMTDOCTYPE._TEXT[1: Language = $parameters. P_Language].SETTLMTDOCTYPEDESC AS SETTLMTDOCTYPEDESC,
  SETTLMTPROCESSTYPE,
  TOTALNETAMOUNT,
  _CREATEDBYUSER.USERDESCRIPTION AS USERDESCRIPTION
FROM I_PERSSETTLMTDOC
LEFT OUTER JOIN N_PERSONWORKAGREEMENT_1 AS _PERSONWORKAGREEMENT ON PersonWorkAgreement=_PERSONWORKAGREEMENT.PersonWorkAgreement  -- association [0..1]
LEFT OUTER JOIN dd07t AS _PERSSETTLMTACCTGTRANSFSTS ON PersSettlmtAcctgTransfSts=_PERSSETTLMTACCTGTRANSFSTS.domvalue_l AND _PERSSETTLMTACCTGTRANSFSTS.domname='WFBSK' AND _PERSSETTLMTACCTGTRANSFSTS.as4local='A'  -- association [0..*]
;

Learn More