P_ARJrnlEntrItmOpenRec2_WSJ_CC

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_ARJrnlEntrItmOpenRec2_WSJ_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_ARJrnlEntrItmOpenRec2_WSJ_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.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,
  ReferencedInvoices.DocumentDate AS RefInvcDocumentDate,
  ReferencedInvoices.FinancialAccountType AS RefInvcFinancialAccountType,
  ReferencedInvoices.DebitCreditCode AS RefInvcDebitCreditCode,
  ReferencedInvoices.NetPaymentDays AS RefInvcNetPaymentDays,
  ReferencedInvoices.InvoiceReference AS RefInvcInvoiceReference,
  ReferencedInvoices.NetDueDate AS RefInvcNetDueDate,
  ReferencedInvoices.NetDueDate AS NetDueDate,
  OpenReceivables._Customer AS _Customer,
  OpenReceivables._CompanyCode AS _CompanyCode,
  OpenReceivables._JournalEntry AS _JournalEntry,
  OpenReceivables._SpecialGLCode AS _SpecialGLCode,
  OpenReceivables._FinancialAccountType AS _FinancialAccountType,
  OpenReceivables._ChartOfAccounts AS _ChartOfAccounts,
  OpenReceivables._GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts,
  OpenReceivables._ProfitCenter AS _ProfitCenter,
  OpenReceivables.CustomerCountry AS CustomerCountry,
  OpenReceivables.CustomerRegion AS CustomerRegion,
  OpenReceivables.CustomerAccountGroup AS CustomerAccountGroup,
  OpenReceivables.CompanyCodeCountry AS CompanyCodeCountry,
  OpenReceivables.CustomerBasicAuthorizationGrp AS CustomerBasicAuthorizationGrp,
  OpenReceivables.CustomerClassification AS CustomerClassification,
  OpenReceivables.CustomerCorporateGroup AS CustomerCorporateGroup,
  OpenReceivables._CurrentProfitCenter AS _CurrentProfitCenter,
  OpenReceivables._CompanyCodeCountry AS _CompanyCodeCountry,
  OpenReceivables._ControllingArea AS _ControllingArea,
  OpenReceivables._CustomerClassification AS _CustomerClassification,
  OpenReceivables._FunctionalArea AS _FunctionalArea,
  OpenReceivables._BusinessArea AS _BusinessArea,
  OpenReceivables._Segment AS _Segment,
  OpenReceivables._WBSElementBasicData AS _WBSElementBasicData,
  OpenReceivables._ProjectBasicData AS _ProjectBasicData,
  OpenReceivables._WBSElementExternalID AS _WBSElementExternalID,
  OpenReceivables._ProjectExternalID AS P_KeyDate,
  OpenReceivables._ProjectExternalID AS _ProjectExternalID
FROM P_ARJrnlEntrItmOpenRec1_CC
INNER JOIN P_ReceivablesItem AS ReferencedInvoices ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): P_ARJrnlEntrItmOpenRec1_CC
;