R_CollectionsInvoiceTP

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 R_CollectionsInvoiceTP.
-- 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 R_CollectionsInvoiceTP AS
SELECT
  CollectionSegment,
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  AccountingDocumentItem,
  Customer,
  BranchAccount,
  DocumentDate,
  PostingDate,
  DunningLevel,
  LastDunningDate,
  NetDueDate,
  Reference1InDocumentHeader,
  Reference2InDocumentHeader,
  PaymentMethod,
  FinancialAccountType,
  cast ( OverdueDays as coll_pr_days_in_arrears ) AS OverdueDays,
  cast ( CashDiscount1Days as coll_pr_due_for_cashdisc_1 preserving type ) AS CashDiscount1Days,
  AmountInTransactionCurrency,
  PaidAmount,
  DunnedAmount,
  OpenAmountInDocumentCurrency,
  cast ( CashDiscountAmtInTransacCrcy as coll_pr_cash_discount_amt ) AS CashDiscountAmtInTransacCrcy,
  TransactionCurrency,
  PaymentDate,
  DunningBlockingReason,
  SpecialGLCode,
  cast( OperationalGLAccount as coll_pr_gl_account preserving type ) AS OperationalGLAccount,
  FiscalPeriod,
  BillingDocument,
  PostingKey,
  DocumentItemText,
  ReferenceDocumentLogicalSystem,
  LastDunningDurationInDays,
  CaseStatus,
  CaseStatusName,
  CaseReason,
  ReasonCodeName,
  PromiseToPayStatus,
  DisputeCase,
  PromiseToPay,
  NumberOfResubmissions,
  NumberOfDaysSinceResubmission,
  ArrangedAmount,
  PromisedAmount,
  cast( PromiseToPayLevel as coll_pr_p2p_level ) AS PromiseToPayLevel,
  PromiseToPayDueDate,
  DisputedAmount,
  CreditedAmount,
  DocumentReferenceID,
  ObjectKey,
  Country,
  ResubmissionUUID,
  ResubmissionDueDate,
  ResubmissionReason,
  CaseUniqueID,
  LatePaymentRisk
FROM I_CollectionsInvoice
LEFT OUTER JOIN I_CollectionsInvoiceNote AS _CollectionsInvoiceNote ON CompanyCode = _CollectionsInvoiceNote.CompanyCode AND AccountingDocument = _CollectionsInvoiceNote.AccountingDocument AND FiscalYear = _CollectionsInvoiceNote.FiscalYear AND AccountingDocumentItem = _CollectionsInvoiceNote.AccountingDocumentItem  -- association [0..*]
LEFT OUTER JOIN I_OperationalAcctgDocItem AS _OperationalAcctgDocItem ON CompanyCode = _OperationalAcctgDocItem.CompanyCode AND FiscalYear = _OperationalAcctgDocItem.FiscalYear AND AccountingDocument = _OperationalAcctgDocItem.AccountingDocument AND AccountingDocumentItem = _OperationalAcctgDocItem.AccountingDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_CollsInvoiceRelatedDsputCase AS _LinkedDisputeCase ON CompanyCode = _LinkedDisputeCase.CompanyCode AND AccountingDocument = _LinkedDisputeCase.AccountingDocument AND FiscalYear = _LinkedDisputeCase.FiscalYear AND AccountingDocumentItem = _LinkedDisputeCase.AccountingDocumentItem  -- association [0..*]
LEFT OUTER JOIN I_CollsInvoiceRelatedPrms2P AS _LinkedPromiseToPay ON CompanyCode = _LinkedPromiseToPay.CompanyCode AND AccountingDocument = _LinkedPromiseToPay.AccountingDocument AND FiscalYear = _LinkedPromiseToPay.FiscalYear AND AccountingDocumentItem = _LinkedPromiseToPay.AccountingDocumentItem  -- association [0..*]
LEFT OUTER JOIN I_CollsInvoiceRelatedResubmsn AS _LinkedResubmission ON CompanyCode = _LinkedResubmission.CompanyCode AND AccountingDocument = _LinkedResubmission.AccountingDocument AND FiscalYear = _LinkedResubmission.FiscalYear AND AccountingDocumentItem = _LinkedResubmission.AccountingDocumentItem  -- association [0..*]
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]
LEFT OUTER JOIN E_CollectionsInvoice AS _Extension ON CollectionSegment = _Extension.CollectionSegment AND CompanyCode = _Extension.CompanyCode AND AccountingDocument = _Extension.AccountingDocument AND FiscalYear = _Extension.FiscalYear AND AccountingDocumentItem = _Extension.AccountingDocumentItem  -- association [1]
;