R_SettlmtDocListItem

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_SettlmtDocListItem.
-- 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_SettlmtDocListItem AS
SELECT
  cast( SettlmtMgmtDoc as wbeln_rl preserving type ) AS SettlmtDocList,
  SettlmtMgmtDocListItem AS SettlmtDocListItem,
  ReferenceSettlmtMgmtDoc AS SettlmtDoc,
  SettlmtDocCurrency AS SettlmtDocListCurrency,
  _SettlmtDocList.CompanyCode AS CompanyCode,
  SettlmtDocListItemNetAmount,
  SettlmtDocListItemTaxAmount,
  NonDeductibleInputTaxAmount,
  SettlmtRemunerationNetAmt,
  SettlmtRemunerationTaxAmt,
  InvoicingParty,
  PayeeParty,
  BillToParty,
  PayerParty,
  SettlmtDocCat,
  SettlmtDocListCat,
  SettlmtDocListItemCat,
  SettlmtExtBillgDoc,
  SettlmtExtAcctgDocCompanyCode,
  SettlmtExtAcctgDoc,
  SettlmtExtAcctgDocFiscalYear,
  SettlmtExtAcctgDocItem,
  SettlmtDocListItemIsCancelled AS SettlmtDocListItemIsReversed,
  PrcDetnIsIncmplt
FROM R_SettlmtMgmtDocListItem
LEFT OUTER JOIN R_SettlmtDocList AS _SettlmtDocList ON SettlmtDocList = _SettlmtDocList.SettlmtDocList  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _SettlmtDocListCurrency ON SettlmtDocListCurrency = _SettlmtDocListCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_SettlmtMgmtDocCat AS _SettlmtDocListCat ON SettlmtDocListCat = _SettlmtDocListCat.SettlmtMgmtDocCat  -- association [0..1]
LEFT OUTER JOIN I_SettlmtDocListItemCat AS _SettlmtDocListItemCat ON SettlmtDocListItemCat = _SettlmtDocListItemCat.SettlmtDocListItemCat  -- association [0..1]
LEFT OUTER JOIN R_SettlmtDoc AS _RefSettlmtDoc ON RefSettlmtDoc = _RefSettlmtDoc.SettlmtDoc  -- association [0..1]
LEFT OUTER JOIN R_CustSettlmtList AS _RefCustSettlmtList ON RefCustSettlmtList = _RefCustSettlmtList.CustSettlmtList  -- association [0..1]
LEFT OUTER JOIN R_SuplrSettlmtList AS _RefSuplrSettlmtList ON RefSuplrSettlmtList = _RefSuplrSettlmtList.SuplrSettlmtList  -- association [0..1]
LEFT OUTER JOIN R_SettlmtDocList AS _RefSettlmtDocList ON RefSettlmtDocList = _RefSettlmtDocList.SettlmtDocList  -- association [0..1]
LEFT OUTER JOIN R_SuplrSettlmt AS _RefSuplrSettlmt ON RefSuplrSettlmt = _RefSuplrSettlmt.SuplrSettlmt  -- association [0..1]
LEFT OUTER JOIN R_CustSettlmt AS _RefCustSettlmt ON RefCustSettlmt = _RefCustSettlmt.CustSettlmt  -- association [0..1]
LEFT OUTER JOIN I_BillingDocument AS _SettlmtExtBillgDoc ON SettlmtExtBillgDoc = _SettlmtExtBillgDoc.BillingDocument  -- association [0..1]
LEFT OUTER JOIN I_OperationalAcctgDocItem AS _SettlmtExtOplAcctgDocItem ON SettlmtExtAcctgDocCompanyCode = _SettlmtExtOplAcctgDocItem.CompanyCode AND SettlmtExtAcctgDoc = _SettlmtExtOplAcctgDocItem.AccountingDocument AND SettlmtExtAcctgDocFiscalYear = _SettlmtExtOplAcctgDocItem.FiscalYear AND SettlmtExtAcctgDocItem = _SettlmtExtOplAcctgDocItem.AccountingDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_SupplierCompany AS _InvoicingPartyCompany ON InvoicingParty = _InvoicingPartyCompany.Supplier AND CompanyCode = _InvoicingPartyCompany.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_SupplierCompany AS _PayeePartyCompany ON PayeeParty = _PayeePartyCompany.Supplier AND CompanyCode = _PayeePartyCompany.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CustomerCompany AS _BillToPartyCompany ON BillToParty = _BillToPartyCompany.Customer AND CompanyCode = _BillToPartyCompany.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CustomerCompany AS _PayerPartyCompany ON PayerParty = _PayerPartyCompany.Customer AND CompanyCode = _PayerPartyCompany.CompanyCode  -- association [0..1]
LEFT OUTER JOIN E_SettlmtMgmtDocListItem AS _Extension ON SettlmtDocList = _Extension.SettlmtMgmtDoc AND SettlmtDocListItem = _Extension.SettlmtMgmtDocListItem  -- association [1..1]
;