P_JrnlEntrWthFuncnlCrcy

DDL: P_JRNLENTRWTHFUNCNLCRCY SQL: PJRNLENTRFC Type: view COMPOSITE Package: ODATA_GL_JOURNALENTRY_VER
10 Fields 1 Data Sources 2 Associations

Journal Entry Header with Functial Crcy

P_JrnlEntrWthFuncnlCrcy is a Composite CDS View that provides data about "Journal Entry Header with Functial Crcy" in SAP S/4HANA. It reads from 1 data source (I_ParkedGeneralLedgerItem) and exposes 10 fields with key fields SourceCompanyCode, AccountingDocument, FiscalYear, CompanyCode, AccountingDocumentItem. It has 2 associations to related views. Part of development package ODATA_GL_JOURNALENTRY_VER.

Data Sources (1)

SourceAliasJoin Type
I_ParkedGeneralLedgerItem I_ParkedGeneralLedgerItem from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_Ledger _Ledger _LedgerGroup.Ledger = _Ledger.Ledger or ( _Header.LedgerGroup = '' and _Ledger.IsLeadingLedger = 'X')
[1..1] I_AdditionalCurrencyRoles _CurrencyRole I_ParkedGeneralLedgerItem.CompanyCode = _CurrencyRole.CompanyCode and _Header.LedgerGroup = _CurrencyRole.LedgerGroup and _Header.Ledger = _CurrencyRole.Ledger

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PJRNLENTRFC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY SourceCompanyCode I_ParkedGeneralLedgerItem SourceCompanyCode Source CoCode
KEY AccountingDocument I_ParkedGeneralLedgerItem AccountingDocument Journal Entry
KEY FiscalYear I_ParkedGeneralLedgerItem FiscalYear G/L Fiscal Year
KEY CompanyCode I_ParkedGeneralLedgerItem CompanyCode Receiver Company Code
KEY AccountingDocumentItem I_ParkedGeneralLedgerItem AccountingDocumentItem Posting View Item
LedgerGroup _Header LedgerGroup Ledger Group
Ledger _Ledger Ledger Ledger
AdditionalCurrency1Role _CurrencyRole AdditionalCurrency1Role LC2 Crcy Type
AdditionalCurrency2Role _CurrencyRole AdditionalCurrency2Role LC3 Crcy Type
FunctionalCurrencyRole _CurrencyRole FunctionalCurrencyRole

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 P_JrnlEntrWthFuncnlCrcy.
-- 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: PJRNLENTRFC

CREATE VIEW P_JrnlEntrWthFuncnlCrcy AS
SELECT
  I_ParkedGeneralLedgerItem.SourceCompanyCode AS SourceCompanyCode,
  I_ParkedGeneralLedgerItem.AccountingDocument AS AccountingDocument,
  I_ParkedGeneralLedgerItem.FiscalYear AS FiscalYear,
  I_ParkedGeneralLedgerItem.CompanyCode AS CompanyCode,
  I_ParkedGeneralLedgerItem.AccountingDocumentItem AS AccountingDocumentItem,
  _Header.LedgerGroup AS LedgerGroup,
  _Ledger.Ledger AS Ledger,
  _CurrencyRole.AdditionalCurrency1Role AS AdditionalCurrency1Role,
  _CurrencyRole.AdditionalCurrency2Role AS AdditionalCurrency2Role,
  _CurrencyRole.FunctionalCurrencyRole AS FunctionalCurrencyRole
FROM I_ParkedGeneralLedgerItem
LEFT OUTER JOIN I_Ledger AS _Ledger ON _LedgerGroup.Ledger = _Ledger.Ledger OR ( _Header.LedgerGroup = '' AND _Ledger.IsLeadingLedger = 'X')  -- association [1..1]
LEFT OUTER JOIN I_AdditionalCurrencyRoles AS _CurrencyRole ON I_ParkedGeneralLedgerItem.CompanyCode = _CurrencyRole.CompanyCode AND _Header.LedgerGroup = _CurrencyRole.LedgerGroup AND _Header.Ledger = _CurrencyRole.Ledger  -- association [1..1]
;

Learn More