I_PersSettlmtDocStdVH

DDL: I_PERSSETTLMTDOCSTDVH Type: view_entity COMPOSITE
17 Fields 1 Data Sources 1 Associations

Personnel Settlement Document

I_PersSettlmtDocStdVH is a Composite CDS View that provides data about "Personnel Settlement Document" in SAP S/4HANA. It reads from 1 data source (I_PersSettlmtDoc) and exposes 17 fields with key field PersonnelSettlementDocument. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_PersSettlmtDoc I_PersSettlmtDoc from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_SettlmtCompnVar _SettlmtCompnVar $projection.SettlmtCompnVar = _SettlmtCompnVar.SettlmtCompnVar

Annotations (14)

NameValueLevelField
EndUserText.label Personnel Settlement Document view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey PersonnelSettlementDocument view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
Analytics.internalName #LOCAL view
UI.headerInfo.typeName Personnel Settlement Document view
UI.headerInfo.typeNamePlural Personnel Settlement Documents view
Search.searchable true view
Metadata.ignorePropagatedAnnotations true view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY PersonnelSettlementDocument PersonnelSettlementDocument Personnel Settlement Document
SettlmtDocType SettlmtDocType Settlement Document Type
SettlmtDocTypeDesc
PersonWorkAgreement PersonWorkAgreement Personnel No.
PersonFullName _PersonWorkAgreement PersonFullName Full Name
SettlmtCompensationReason SettlmtCompensationReason Compensation Reason
SettlmtCompnRsnDesc
SettlmtCompnVar SettlmtCompnVar Compensation Variant
SettlmtCompnVarDesc
CompanyCode CompanyCode Receiver Company Code
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Division Division Internal Division ID
PersonnelCostCenter PersonnelCostCenter Worker Cost Center
_PersonWorkAgreement _PersonWorkAgreement
_SettlmtCompnRsn _SettlmtCompnRsn
_SettlmtCompnVar _SettlmtCompnVar

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 I_PersSettlmtDocStdVH.
-- 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.

CREATE VIEW I_PersSettlmtDocStdVH AS
SELECT
  PersonnelSettlementDocument,
  SettlmtDocType,
  _SettlmtDocType._Text[1: Language = $session.system_language].SettlmtDocTypeDesc AS SettlmtDocTypeDesc,
  PersonWorkAgreement,
  _PersonWorkAgreement.PersonFullName AS PersonFullName,
  SettlmtCompensationReason,
  _SettlmtCompnRsn._Text[1: Language = $session.system_language].SettlmtCompnRsnDesc AS SettlmtCompnRsnDesc,
  SettlmtCompnVar,
  _SettlmtCompnVar._Text[1: Language = $session.system_language].SettlmtCompnVarDesc AS SettlmtCompnVarDesc,
  CompanyCode,
  SalesOrganization,
  DistributionChannel,
  Division,
  PersonnelCostCenter
FROM I_PersSettlmtDoc
LEFT OUTER JOIN I_SettlmtCompnVar AS _SettlmtCompnVar ON SettlmtCompnVar = _SettlmtCompnVar.SettlmtCompnVar  -- association [0..1]
;

Learn More