P_SettlmtMgmtDocListItem

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_SettlmtMgmtDocListItem.
-- 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 P_SettlmtMgmtDocListItem AS
SELECT
  wbrl.wbeln AS SettlmtMgmtDoc,
  wbrl.posnr AS SettlmtMgmtDocListItem,
  cast( wbrl.wbeln_lf as wbeln_ag preserving type ) AS ReferenceSettlmtMgmtDoc,
  wbrl.fksto_li AS SettlmtDocListItemIsCancelled,
  wbrl.wuvprs AS PrcDetnIsIncmplt,
  wbrl.lifre AS InvoicingParty,
  wbrl.lnrzb AS PayeeParty,
  wbrl.kunre AS BillToParty,
  wbrl.kunrg AS PayerParty,
  cast( wbrl.netwr as wlf_netwr_rl preserving type ) AS SettlmtDocListItemNetAmount,
  cast( wbrl.mwsbp as mwsbp preserving type ) AS SettlmtDocListItemTaxAmount,
  wbrl.navnw AS NonDeductibleInputTaxAmount,
  wbrl.kwert_rl AS SettlmtRemunerationNetAmt,
  wbrl.mwsbp_rl AS SettlmtRemunerationTaxAmt,
  wbrl.tax_country AS TaxCountry,
  wbrl.txjcd AS TaxJurisdiction,
  wbrl.bupla AS BusinessPlace,
  wbrl.lftyp AS SettlmtDocCat,
  wbrl.wdtyp_l AS SettlmtDocListCat,
  wbrl.wdtyp_li AS SettlmtDocListItemCat,
  cast( substring( wbrl.ext_doc_item, 8, 3 ) as wlf_ext_buzei ) AS SettlmtExtAcctgDocItem,
  cast( wbrl.ext_doc_year as wlf_ext_acctg_gjahr_no_cnext preserving type ) AS SettlmtExtAcctgDocFiscalYear,
  cast( wbrl.ext_doc_bukrs as wlf_ext_acctg_bukrs preserving type ) AS SettlmtExtAcctgDocCompanyCode
FROM wbrl
;