C_SettlmtDocListItemOutputForm

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 C_SettlmtDocListItemOutputForm.
-- 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 C_SettlmtDocListItemOutputForm AS
SELECT
  SettlmtDocList,
  SettlmtDocListItem,
  SettlmtDoc,
  SettlmtDocListCurrency,
  _SettlmtDocList.CompanyCode AS CompanyCode,
  SettlmtDocListItemNetAmount,
  SettlmtDocListItemTaxAmount,
  NonDeductibleInputTaxAmount,
  SettlmtRemunerationNetAmt,
  SettlmtRemunerationTaxAmt,
  InvoicingParty,
  PayeeParty,
  BillToParty,
  PayerParty,
  SettlmtDocCat,
  SettlmtDocListCat,
  SettlmtDocListItemCat,
  RefSettlmtDoc,
  RefCustSettlmtList,
  RefSuplrSettlmtList,
  RefSettlmtDocList,
  RefCustSettlmt,
  RefSuplrSettlmt,
  SettlmtExtBillgDoc,
  SettlmtExtAcctgDocCompanyCode,
  SettlmtExtAcctgDoc,
  SettlmtExtAcctgDocFiscalYear,
  SettlmtExtAcctgDocItem,
  SettlmtDocListItemIsReversed AS SettlmtDocListItemIsCancelled,
  PrcDetnIsIncmplt
FROM R_SettlmtDocListItem
LEFT OUTER JOIN C_SettlmtDocListOutputForm AS _SettlmtDocList ON SettlmtDocList = _SettlmtDocList.SettlmtDocList  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN C_SettlmtDocOutputForm AS _RefSettlmtDoc ON RefSettlmtDoc = _RefSettlmtDoc.SettlmtDoc  -- association [0..1]
LEFT OUTER JOIN C_CustSettlmtListOutputForm AS _RefCustSettlmtList ON RefCustSettlmtList = _RefCustSettlmtList.CustSettlmtList  -- association [0..1]
LEFT OUTER JOIN C_SuplrSettlmtListOutputForm AS _RefSuplrSettlmtList ON RefSuplrSettlmtList = _RefSuplrSettlmtList.SuplrSettlmtList  -- association [0..1]
LEFT OUTER JOIN C_SettlmtDocListOutputForm AS _RefSettlmtDocList ON RefSettlmtDocList = _RefSettlmtDocList.SettlmtDocList  -- association [0..1]
LEFT OUTER JOIN C_SuplrSettlmtOutputForm AS _RefSuplrSettlmt ON RefSuplrSettlmt = _RefSuplrSettlmt.SuplrSettlmt  -- association [0..1]
LEFT OUTER JOIN C_CustSettlmtOutputForm AS _RefCustSettlmt ON RefCustSettlmt = _RefCustSettlmt.CustSettlmt  -- 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]
;