I_PersSettlmtDocJournalEntry

DDL: I_PERSSETTLMTDOCJOURNALENTRY Type: view BASIC
5 Fields 1 Data Sources 1 Associations

Journal Entry for Personnel Settlement Documents

I_PersSettlmtDocJournalEntry is a Basic CDS View that provides data about "Journal Entry for Personnel Settlement Documents" in SAP S/4HANA. It reads from 1 data source (R_PersSettlmtDoc) and exposes 5 fields with key field PersonnelSettlementDocument. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
R_PersSettlmtDoc _PersSettlmtDoc from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_JournalEntry _JournalEntry $projection.JournalEntry = _JournalEntry.AccountingDocument and $projection.CompanyCode = _JournalEntry.CompanyCode and $projection.FiscalYear = _JournalEntry.FiscalYear

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IWLFPSDOCJE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Journal Entry for Personnel Settlement Documents view
Metadata.ignorePropagatedAnnotations true view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY PersonnelSettlementDocument R_PersSettlmtDoc PersonnelSettlementDocument Personnel Settlement Document
JournalEntry
CompanyCode R_PersSettlmtDoc CompanyCode Receiver Company Code
FiscalYear
_JournalEntry _JournalEntry

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_PersSettlmtDocJournalEntry.
-- 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_PersSettlmtDocJournalEntry AS
SELECT
  _PersSettlmtDoc.PersonnelSettlementDocument AS PersonnelSettlementDocument,
  cast( _SettlmtMgmtDocProcessFlow.SettlmtSubsqntDoc as farp_belnr_d preserving type ) AS JournalEntry,
  _PersSettlmtDoc.CompanyCode AS CompanyCode,
  cast( _SettlmtMgmtDocProcessFlow.SettlmtPrecdgDocFiscalYear as fis_gjahr_no_conv preserving type ) AS FiscalYear
FROM R_PersSettlmtDoc AS _PersSettlmtDoc
LEFT OUTER JOIN I_JournalEntry AS _JournalEntry ON JournalEntry = _JournalEntry.AccountingDocument AND CompanyCode = _JournalEntry.CompanyCode AND FiscalYear = _JournalEntry.FiscalYear  -- association [0..1]
;

Learn More