I_CollectionsInvoice

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 I_CollectionsInvoice.
-- 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.

CREATE VIEW I_CollectionsInvoice AS
SELECT
  CollectionSegment,
  I_OperationalAcctgDocItem.CompanyCode AS CompanyCode,
  FiscalYear,
  AccountingDocument,
  AccountingDocumentItem,
  Customer,
  BranchAccount,
  _OperationalAcctgDocItem.DocumentDate AS DocumentDate,
  PostingDate,
  DunningLevel,
  LastDunningDate,
  NetDueDate,
  _JournalEntry.Reference1InDocumentHeader AS Reference1InDocumentHeader,
  _JournalEntry.Reference2InDocumentHeader AS Reference2InDocumentHeader,
  PaymentMethod,
  FinancialAccountType,
  cast( 0 as verzn ) AS OverdueDays,
  cast( '00000000' as sk1dt ) AS CashDiscount1Days,
  AmountInTransactionCurrency,
  cast( '0' as bdm_paid_amount ) AS PaidAmount,
  cast( 0 as fdm_dunning_amount ) AS DunnedAmount,
  cast( 0 as fdm_open_amount ) AS OpenAmountInDocumentCurrency,
  cast( 0 as wskto_cs ) AS CashDiscountAmtInTransacCrcy,
  TransactionCurrency,
  cast( '00000000' as fdm_last_payment_date ) AS PaymentDate,
  DunningBlockingReason,
  SpecialGLCode,
  OperationalGLAccount,
  FiscalPeriod,
  BillingDocument,
  PostingKey,
  DocumentItemText,
  _JournalEntry.DocumentReferenceID AS DocumentReferenceID,
  InvoiceReference,
  InvoiceReferenceFiscalYear,
  InvoiceItemReference,
  FollowOnDocumentType,
  ClearingDate,
  AccountingDocumentCategory,
  ReferenceDocumentLogicalSystem,
  cast( 0 as coll_pr_days_since_dunning ) AS LastDunningDurationInDays,
  cast( '00' as scmgstatusonr ) AS CaseStatus,
  cast( '' as scmgstat_descr ) AS CaseStatusName,
  cast( '0' as scmg_reason_code ) AS CaseReason,
  cast( '' as text60 ) AS ReasonCodeName,
  cast( '' as bdm_promise_state ) AS PromiseToPayStatus,
  cast( 0 as fdm_ext_key ) AS DisputeCase,
  cast( 0 as fdm_ext_key ) AS PromiseToPay,
  cast( 0 as fdm_inv_no_of_rsm ) AS NumberOfResubmissions,
  cast( 0 as scmg_case_guid ) AS ResubmissionUUID,
  cast( '' as bdm_rsm_date ) AS ResubmissionDueDate,
  cast( '' as bdm_rsm_reason ) AS ResubmissionReason,
  cast( 0 as coll_rsm_days_since_rsm ) AS NumberOfDaysSinceResubmission,
  cast( 0 as fdm_payment_arranged ) AS ArrangedAmount,
  cast( 0 as fdm_current_p2p_amount ) AS PromisedAmount,
  cast( 0 as bdm_promise_level ) AS PromiseToPayLevel,
  cast( '00000000' as bdm_promise_due_date ) AS PromiseToPayDueDate,
  cast( 0 as fdm_disputed_amount ) AS DisputedAmount,
  cast( 0 as fdm_credit_amount ) AS CreditedAmount,
  cast ( '' as swo_typeid ) AS ObjectKey,
  _Customer.Country AS Country,
  cast ( '' as scmg_case_guid ) AS CaseUniqueID,
  cast ( '' as udm_coll_late_payment_risk ) AS LatePaymentRisk,
  I_OperationalAcctgDocItem._CompanyCode AS _CompanyCode,
  I_OperationalAcctgDocItem._SpecialGLCode AS _SpecialGLCode
FROM I_CollsSgmtCompanyCodeAssgmt
INNER JOIN I_OperationalAcctgDocItem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CollectionSegment AS _CollectionSegment ON CollectionSegment = _CollectionSegment.CollectionSegment  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _BranchAccount ON BranchAccount = _BranchAccount.Customer  -- association [0..1]
LEFT OUTER JOIN I_BillingDocument AS _BillingDocument ON BillingDocument = _BillingDocument.BillingDocument  -- association [0..1]
LEFT OUTER JOIN I_DunningBlockingReasonCode AS _DunningBlockingReasonCode ON DunningBlockingReason = _DunningBlockingReasonCode.DunningBlockingReason  -- association [0..1]
LEFT OUTER JOIN I_CollsPromiseToPayStatus AS _PromiseToPayStatus ON PromiseToPayStatus = _PromiseToPayStatus.PromiseToPayStatus  -- association [0..1]
LEFT OUTER JOIN I_PaymentMethod AS _PaymentMethod ON PaymentMethod = _PaymentMethod.PaymentMethod AND Country = _PaymentMethod.Country  -- association [0..1]
LEFT OUTER JOIN I_OperationalAcctgDocItem AS _OperationalAcctgDocItem ON CompanyCode = _OperationalAcctgDocItem.CompanyCode AND AccountingDocument = _OperationalAcctgDocItem.AccountingDocument AND FiscalYear = _OperationalAcctgDocItem.FiscalYear AND AccountingDocumentItem = _OperationalAcctgDocItem.AccountingDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_CollsInvcPaytDelayPrediction AS _CollsInvcPaytDelayPrediction ON CompanyCode = _CollsInvcPaytDelayPrediction.CompanyCode AND AccountingDocument = _CollsInvcPaytDelayPrediction.AccountingDocument AND FiscalYear = _CollsInvcPaytDelayPrediction.FiscalYear AND AccountingDocumentItem = _CollsInvcPaytDelayPrediction.AccountingDocumentItem  -- association [0..1]
;