P_ARJrnlEntrItmOpenRec1_CC

DDL: P_ARJRNLENTRITMOPENREC1_CC Type: view_entity COMPOSITE
66 Fields 1 Data Sources

P_ARJrnlEntrItmOpenRec1_CC is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_JournalEntryOperationalView) and exposes 66 fields with key fields CompanyCode, FiscalYear, AccountingDocument, LedgerGLLineItem.

Data Sources (1)

SourceAliasJoin Type
I_JournalEntryOperationalView OpenReceivables from

Parameters (2)

NameTypeDefault
P_KeyDate vdm_v_key_date
P_LeadingLedger fins_ledger

Annotations (3)

NameValueLevelField
VDM.viewType #COMPOSITE view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (66)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_JournalEntryOperationalView CompanyCode Receiver Company Code
KEY FiscalYear I_JournalEntryOperationalView FiscalYear G/L Fiscal Year
KEY AccountingDocument I_JournalEntryOperationalView AccountingDocument Journal Entry
KEY LedgerGLLineItem I_JournalEntryOperationalView LedgerGLLineItem Journal Entry Item
AccountingDocumentCategory I_JournalEntryOperationalView AccountingDocumentCategory Journal Entry Category
AccountingDocumentType I_JournalEntryOperationalView AccountingDocumentType Journal Entry Type
AccountingDocumentItem I_JournalEntryOperationalView AccountingDocumentItem Posting View Item
InvoiceReference I_JournalEntryOperationalView InvoiceReference Invoice Reference
InvoiceItemReference I_JournalEntryOperationalView InvoiceItemReference Item
InvoiceReferenceFiscalYear I_JournalEntryOperationalView InvoiceReferenceFiscalYear Invoice Reference Fiscal Year
ClearingDate I_JournalEntryOperationalView ClearingDate Clearing Date
PostingDate I_JournalEntryOperationalView PostingDate Posting Date for GR
DocumentDate I_JournalEntryOperationalView DocumentDate Journal Entry Date
FinancialAccountType I_JournalEntryOperationalView FinancialAccountType Fin. Account Type
Customer I_JournalEntryOperationalView Customer Sold-to Party
FollowOnDocumentType I_JournalEntryOperationalView FollowOnDocumentType Follow-On Document Type
NetDueDate I_JournalEntryOperationalView NetDueDate Net Due Date
SpecialGLCode I_JournalEntryOperationalView SpecialGLCode Special G/L Ind
SpecialGLTransactionType I_JournalEntryOperationalView SpecialGLTransactionType Transact.Type
GLAccount I_JournalEntryOperationalView GLAccount General Ledger
ProfitCenter I_JournalEntryOperationalView ProfitCenter Profit Center
FunctionalArea I_JournalEntryOperationalView FunctionalArea Sendr Fctl Area
BusinessArea I_JournalEntryOperationalView BusinessArea Business Area
Segment I_JournalEntryOperationalView Segment Segment number
BillingDocument I_JournalEntryOperationalView BillingDocument SD Document
AssignmentReference I_JournalEntryOperationalView AssignmentReference Assignment Reference
CompanyCodeCurrency I_JournalEntryOperationalView CompanyCodeCurrency Local Currency
AmountInCompanyCodeCurrency I_JournalEntryOperationalView AmountInCompanyCodeCurrency Local Crcy Amt
TransactionCurrency I_JournalEntryOperationalView TransactionCurrency Transaction Currency
AmountInTransactionCurrency I_JournalEntryOperationalView AmountInTransactionCurrency Pt Crcy Amt
Reference1IDByBusinessPartner I_JournalEntryOperationalView Reference1IDByBusinessPartner Reference Key 1
Reference2IDByBusinessPartner I_JournalEntryOperationalView Reference2IDByBusinessPartner Reference Key 2
Reference3IDByBusinessPartner I_JournalEntryOperationalView Reference3IDByBusinessPartner Reference Key 3
PaymentMethod I_JournalEntryOperationalView PaymentMethod Pymt Meth.
ChartOfAccounts I_JournalEntryOperationalView ChartOfAccounts Node Class
ControllingArea I_JournalEntryOperationalView ControllingArea Controlling Area
WBSElementExternalID I_JournalEntryOperationalView WBSElementExternalID WBS Element External ID
WBSElementInternalID I_JournalEntryOperationalView WBSElementInternalID WBS Internal ID
ProjectExternalID I_JournalEntryOperationalView ProjectExternalID Project def.
ProjectInternalID I_JournalEntryOperationalView ProjectInternalID Project Def.
_Customer _Customer
_CompanyCode _CompanyCode
_JournalEntry _JournalEntry
_SpecialGLCode _SpecialGLCode
_FinancialAccountType _FinancialAccountType
_ChartOfAccounts _ChartOfAccounts
_GLAccountInChartOfAccounts _GLAccountInChartOfAccounts
_ProfitCenter _ProfitCenter
_CurrentProfitCenter _CurrentProfitCenter
CustomerCountry
CustomerRegion
CustomerAccountGroup
CompanyCodeCountry
CustomerBasicAuthorizationGrp
CustomerClassification
CustomerCorporateGroup
_CompanyCodeCountry _CompanyCode _Country
_ControllingArea _ControllingArea
_CustomerClassification _Customer _CustomerClassification
_FunctionalArea _FunctionalArea
_BusinessArea _BusinessArea
_Segment _Segment
_WBSElementBasicData _WBSElementBasicData
_ProjectBasicData _ProjectBasicData
_WBSElementExternalID _WBSElementExternalID
_ProjectExternalID _ProjectExternalID

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_ARJrnlEntrItmOpenRec1_CC.
-- 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.
-- Parameters: P_KeyDate : vdm_v_key_date, P_LeadingLedger : fins_ledger

CREATE VIEW P_ARJrnlEntrItmOpenRec1_CC AS
SELECT
  OpenReceivables.CompanyCode AS CompanyCode,
  OpenReceivables.FiscalYear AS FiscalYear,
  OpenReceivables.AccountingDocument AS AccountingDocument,
  OpenReceivables.LedgerGLLineItem AS LedgerGLLineItem,
  OpenReceivables.AccountingDocumentCategory AS AccountingDocumentCategory,
  OpenReceivables.AccountingDocumentType AS AccountingDocumentType,
  OpenReceivables.AccountingDocumentItem AS AccountingDocumentItem,
  OpenReceivables.InvoiceReference AS InvoiceReference,
  OpenReceivables.InvoiceItemReference AS InvoiceItemReference,
  OpenReceivables.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
  OpenReceivables.ClearingDate AS ClearingDate,
  OpenReceivables.PostingDate AS PostingDate,
  OpenReceivables.DocumentDate AS DocumentDate,
  OpenReceivables.FinancialAccountType AS FinancialAccountType,
  OpenReceivables.Customer AS Customer,
  OpenReceivables.FollowOnDocumentType AS FollowOnDocumentType,
  OpenReceivables.NetDueDate AS NetDueDate,
  OpenReceivables.SpecialGLCode AS SpecialGLCode,
  OpenReceivables.SpecialGLTransactionType AS SpecialGLTransactionType,
  OpenReceivables.GLAccount AS GLAccount,
  OpenReceivables.ProfitCenter AS ProfitCenter,
  OpenReceivables.FunctionalArea AS FunctionalArea,
  OpenReceivables.BusinessArea AS BusinessArea,
  OpenReceivables.Segment AS Segment,
  OpenReceivables.BillingDocument AS BillingDocument,
  OpenReceivables.AssignmentReference AS AssignmentReference,
  OpenReceivables.CompanyCodeCurrency AS CompanyCodeCurrency,
  OpenReceivables.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  OpenReceivables.TransactionCurrency AS TransactionCurrency,
  OpenReceivables.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  OpenReceivables.Reference1IDByBusinessPartner AS Reference1IDByBusinessPartner,
  OpenReceivables.Reference2IDByBusinessPartner AS Reference2IDByBusinessPartner,
  OpenReceivables.Reference3IDByBusinessPartner AS Reference3IDByBusinessPartner,
  OpenReceivables.PaymentMethod AS PaymentMethod,
  OpenReceivables.ChartOfAccounts AS ChartOfAccounts,
  OpenReceivables.ControllingArea AS ControllingArea,
  OpenReceivables.WBSElementExternalID AS WBSElementExternalID,
  OpenReceivables.WBSElementInternalID AS WBSElementInternalID,
  OpenReceivables.ProjectExternalID AS ProjectExternalID,
  OpenReceivables.ProjectInternalID AS ProjectInternalID,
  OpenReceivables._Customer._AddressRepresentation.Country AS CustomerCountry,
  OpenReceivables._Customer._AddressRepresentation.Region AS CustomerRegion,
  OpenReceivables._Customer.CustomerAccountGroup AS CustomerAccountGroup,
  OpenReceivables._CompanyCode.Country AS CompanyCodeCountry,
  OpenReceivables._Customer.AuthorizationGroup AS CustomerBasicAuthorizationGrp,
  OpenReceivables._Customer.CustomerClassification AS CustomerClassification,
  OpenReceivables._Customer.CustomerCorporateGroup AS CustomerCorporateGroup,
  _CompanyCode._Country AS _CompanyCodeCountry,
  _Customer._CustomerClassification AS _CustomerClassification
FROM I_JournalEntryOperationalView AS OpenReceivables
;

Learn More