P_PayReqnLineItems

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_PayReqnLineItems.
-- 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: PPAYREQLINEITEM

CREATE VIEW P_PayReqnLineItems AS
SELECT
  CompanyCode,
  AccountingDocument,
  FiscalYear,
  AccountingDocumentItem,
  AccountingDocumentCategory,
  FinancialAccountType,
  NetDueDate,
  TransactionCurrency,
  AmountInTransactionCurrency,
  abs(AmountInTransactionCurrency) AS AbsAmountInTransactionCurrency,
  Supplier,
  BPBankAccountInternalID AS SupplierBankType,
  div( dats_days_between( cast( concat( FiscalYear , '0101' ) as abap.dats ), cast($session.system_date as abap.dats) ), 7) AS TodayWeekOfYear,
  div( dats_days_between( cast( concat( FiscalYear , '0101' ) as abap.dats ), NetDueDate ), 7) AS DueDateWeekOfYear,
  dats_days_between(cast($session.system_date as abap.dats), cast(NetDueDate as abap.dats)) AS NetDueArrearsDays,
  ClearingAccountingDocument,
  ClearingIsReversed,
  DocumentDate,
  PostingDate,
  SpecialGLCode,
  PaymentMethod,
  CostCenter,
  PurchasingDocument,
  PurchasingDocumentItem,
  SalesDocument,
  SalesDocumentItem,
  CashDiscount1DueDate,
  CashDiscount1Percent,
  CashDiscount1Days,
  CashDiscount2Percent,
  CashDiscount2Days,
  DueCalculationBaseDate,
  WBSElementInternalID,
  _WBSElementBasicData.WBSElementExternalID AS WBSElementExternalID,
  ControllingArea,
  ProfitCenter,
  BranchCode,
  DocumentItemText,
  AssignmentReference,
  _JournalEntry.ReferenceDocumentType AS ReferenceDocumentType,
  _JournalEntry.OriginalReferenceDocument AS OriginalReferenceDocument,
  I_OperationalAcctgDocItem.PaymentBlockingReason AS PaymentBlockingReason,
  Reference1IDByBusinessPartner,
  Reference2IDByBusinessPartner,
  Reference3IDByBusinessPartner,
  'M' AS ItemType
FROM I_OperationalAcctgDocItem
INNER JOIN I_Customer AS Customer ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_JournalEntry AS _JournalEntry ON CompanyCode = _JournalEntry.CompanyCode AND FiscalYear = _JournalEntry.FiscalYear AND AccountingDocument = _JournalEntry.AccountingDocument  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.Currency  -- association [0..1]
-- UNION ALL with additional select branch(es): I_OperationalAcctgDocItem
;