ESH_S_PERSSETTLMTDOC

DDL: ESH_S_PERSSETTLMTDOC SQL: ESH_U_PERSSMTDOC Type: view
32 Fields 1 Data Sources

ESH_S_PERSSETTLMTDOC is a CDS View in SAP S/4HANA. It reads from 1 data source (ESH_N_PERSSETTLMTDOC) and exposes 32 fields with key field PERSONNELSETTLEMENTDOCUMENT.

Data Sources (1)

SourceAliasJoin Type
ESH_N_PERSSETTLMTDOC ESH_N_PERSSETTLMTDOC from

Parameters (1)

NameTypeDefault
P_Language abap.lang

Annotations (19)

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
ObjectModel.modelingPattern #ENTERPRISE_SEARCH_PROVIDER view
Metadata.allowExtensions true view
Search.searchable true view
EnterpriseSearch.enabled true view
UI.headerInfo.typeName Personnel Settlement Document view
UI.headerInfo.typeNamePlural Personnel Settlement Documents view
Consumption.semanticObject PersonnelSettlementDocument view
Metadata.ignorePropagatedAnnotations true view
UI.headerInfo.title.value PERSONNELSETTLEMENTDOCUMENT view
UI.headerInfo.description.value SETTLMTDOCTYPEDESC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName ESH_U_PERSSMTDOC view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY PERSONNELSETTLEMENTDOCUMENT PERSONNELSETTLEMENTDOCUMENT Personnel Settlement Document
ACTUALSETTLMTDATE ACTUALSETTLMTDATE Actual Settl. Date
ASSIGNMENTREFERENCE ASSIGNMENTREFERENCE Assignment Reference
AUTHORIZATIONGROUP AUTHORIZATIONGROUP AuthorizGroup
COMPANYCODE COMPANYCODE Receiver Company Code
COMPANYCODENAME COMPANYCODENAME Company
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 PERSONFULLNAME Employee
PERSONNELCOSTCENTER PERSONNELCOSTCENTER Worker Cost Center
PERSONWORKAGREEMENT PERSONWORKAGREEMENT Personnel No.
PERSSETTLMTACCTGTRANSFSTS PERSSETTLMTACCTGTRANSFSTS Posting Status
PERSSETTLMTACCTGTRANSFSTSNAME PERSSETTLMTACCTGTRANSFSTSNAME
PERSSETTLMTDOCCURRENCY PERSSETTLMTDOCCURRENCY Doc. Currency
POSTINGDATE POSTINGDATE Posting Date for GR
SALESORGANIZATION SALESORGANIZATION Sales Organization
SETTLMTACTIVITYREASONDESC SETTLMTACTIVITYREASONDESC Activity Reason Description
SETTLMTAPPLSTS SETTLMTAPPLSTS Appl. Status
SETTLMTAPPLSTSDESC SETTLMTAPPLSTSDESC
SETTLMTCOMPENSATIONREASON SETTLMTCOMPENSATIONREASON Compensation Reason
SETTLMTCOMPNRSNDESC SETTLMTCOMPNRSNDESC Compensation Reason Description
SETTLMTDOCACTIVITYREASON SETTLMTDOCACTIVITYREASON Activity Reason
SETTLMTDOCTYPE SETTLMTDOCTYPE Settlement Document Type
SETTLMTDOCTYPEDESC SETTLMTDOCTYPEDESC Settlement Doc. Type
SETTLMTPROCESSTYPE SETTLMTPROCESSTYPE Settlement Process Type
TOTALNETAMOUNT TOTALNETAMOUNT Total Net Amount
USERDESCRIPTION USERDESCRIPTION Created By

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_S_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_U_PERSSMTDOC
-- Parameters: P_Language : abap.lang

CREATE VIEW ESH_S_PERSSETTLMTDOC AS
SELECT
  PERSONNELSETTLEMENTDOCUMENT,
  ACTUALSETTLMTDATE,
  ASSIGNMENTREFERENCE,
  AUTHORIZATIONGROUP,
  COMPANYCODE,
  COMPANYCODENAME,
  CREATEDBYUSER,
  CREATIONDATE,
  DISTRIBUTIONCHANNEL,
  DIVISION,
  DOCUMENTDATE,
  DOCUMENTREFERENCEID,
  PAYMENTREFERENCE,
  PERSONFULLNAME,
  PERSONNELCOSTCENTER,
  PERSONWORKAGREEMENT,
  PERSSETTLMTACCTGTRANSFSTS,
  PERSSETTLMTACCTGTRANSFSTSNAME,
  PERSSETTLMTDOCCURRENCY,
  POSTINGDATE,
  SALESORGANIZATION,
  SETTLMTACTIVITYREASONDESC,
  SETTLMTAPPLSTS,
  SETTLMTAPPLSTSDESC,
  SETTLMTCOMPENSATIONREASON,
  SETTLMTCOMPNRSNDESC,
  SETTLMTDOCACTIVITYREASON,
  SETTLMTDOCTYPE,
  SETTLMTDOCTYPEDESC,
  SETTLMTPROCESSTYPE,
  TOTALNETAMOUNT,
  USERDESCRIPTION
FROM ESH_N_PERSSETTLMTDOC
;

Learn More