P_ARLineItemForCorrespondence

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_ARLineItemForCorrespondence.
-- 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: PARLIITFORCOR
-- Parameters: P_KeyDate : vdm_v_key_date, P_TodayDate : abap.dats

CREATE VIEW P_ARLineItemForCorrespondence AS
SELECT
  CompanyCode,
  AccountingDocument,
  FiscalYear,
  AccountingDocumentItem,
  FinancialAccountType,
  Customer AS CustomerSupplierAccount,
  PostingDate,
  DocumentDate,
  I_OperationalAcctgDocItem._JournalEntry.AccountingDocumentCreationDate AS AccountingDocumentCreationDate,
  TransactionCurrency,
  CompanyCodeCurrency,
  I_OperationalAcctgDocItem._JournalEntry.DocumentReferenceID AS DocumentReferenceID,
  AccountingDocumentType,
  AccountingDocumentCategory,
  BranchAccount,
  FiscalPeriod,
  PostingKey,
  SpecialGLCode,
  Customer,
  Supplier,
  ClearingDate,
  ClearingJournalEntry AS ClearingAccountingDocument,
  AssignmentReference,
  DebitCreditCode,
  AmountInTransactionCurrency,
  AmountInCompanyCodeCurrency,
  BalanceTransactionCurrency,
  AmountInBalanceTransacCrcy,
  NetDueDate,
  DocumentItemText,
  cast ( 'BSEG_DEBIT_SIDE_BRANCH' as char30 ) AS ItemTypeBranch,
  DueCalculationBaseDate,
  CashDiscount1Days,
  CashDiscount2Days,
  CashDiscount1DueDate,
  CashDiscount2DueDate,
  BillingDocument,
  Reference1IDByBusinessPartner,
  Reference2IDByBusinessPartner,
  Reference3IDByBusinessPartner,
  BPBankAccountInternalID,
  PaymentReference,
  ReferenceDocumentType,
  OriginalReferenceDocument AS SupplierkeyCompanyCode,
  OriginalReferenceDocument AS CompanyCodekeyCompanyCode,
  OriginalReferenceDocument
FROM I_OperationalAcctgDocItem
INNER JOIN P_CustomerAsSupplier ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ParkedAccountingDocument AS _ParkedAccountingDocument ON AccountingDocument = _ParkedAccountingDocument.AccountingDocument AND FiscalYear = _ParkedAccountingDocument.FiscalYear AND CompanyCode = _ParkedAccountingDocument.CompanyCode  -- association [1..1]
-- UNION ALL with additional select branch(es): I_OperationalAcctgDocItem, I_ParkedReceivablesItem, I_ParkedPayablesItem
;