R_SettledSuplrInvcItemBasic

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_SettledSuplrInvcItemBasic.
-- 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_SettledSuplrInvcItemBasic AS
SELECT
  BVDET.ConditionContract AS ConditionContract,
  BVDET.SettlmtDoc AS SettlmtDoc,
  BVDET.SettlmtDocItem AS SettlmtDocItem,
  cast( BVDET.SetldBusVolDocKey1 as wlf_setld_supr_invc ) AS SettledSuplrInvc,
  cast( BVDET.SetldBusVolDocKey2 as wlf_setld_supr_invc_fisc_year ) AS SettledSuplrInvcFiscalYear,
  cast (BVDET.SetldBusVolDocItem as wlf_setld_supr_invc_itm ) AS SettledSuplrInvcItem,
  cast( BVDET.SetldBusVolDocCategory as wb2_doc_type_busvol preserving type ) AS BusVolDocCat,
  BVDET.BusVolSelDteForSettlmt AS BusVolSelDteForSettlmt,
  cast( BVDET.SettledBusVolQty as wlf_setld_bv_qty preserving type ) AS SettledBusVolQty,
  BVDET.SettledBusVolQtyUnit AS SettledBusVolQtyUnit,
  BVDET.SettledBusVolAmount1 AS SettledBusVolAmount1,
  BVDET.SettledBusVolAmount2 AS SettledBusVolAmount2,
  BVDET.SettledBusVolAmount3 AS SettledBusVolAmount3,
  BVDET.SettledBusVolAmount4 AS SettledBusVolAmount4,
  BVDET.SettledBusVolNetWeight AS SettledBusVolNetWeight,
  BVDET.SettledBusVolGrossWeight AS SettledBusVolGrossWeight,
  BVDET.SettledBusVolWeightUnit AS SettledBusVolWeightUnit,
  BVDET.SettledBusVolVolume AS SettledBusVolVolume,
  BVDET.SettledBusVolVolumeUnit AS SettledBusVolVolumeUnit,
  BVDET.SettledBusVolPointsQty AS SettledBusVolPointsQty,
  BVDET.SettledBusVolPointsQtyUnit AS SettledBusVolPointsQtyUnit,
  BVDET.BusVolDocCurrency AS BusVolDocCurrency,
  CC.CndnContrType AS CndnContrType,
  CC.Supplier AS CndnContrSupplier,
  CC.Customer AS CndnContrCustomer,
  cast( CC.PurchasingOrganization as wlf_cndn_contr_purg_org preserving type ) AS CndnContrPurgOrg,
  cast( CC.PurchasingGroup as wlf_cndn_contr_purg_group preserving type ) AS CndnContrPurgGroup,
  cast( CC.SalesOrganization as wlf_cndn_contr_sls_org preserving type ) AS CndnContrSlsOrg,
  cast( CC.DistributionChannel as wlf_cndn_contr_distr_chnl preserving type ) AS CndnContrDistrChnl,
  cast( CC.Division as wlf_cndn_contr_divn preserving type ) AS CndnContrDivn,
  CC.CndnContrClassfctnType AS CndnContrClassfctnType,
  CC.CndnContrProcVar AS CndnContrProcVar,
  cast( CC.CndnContrSettlmtType as wb2_rebate_type preserving type ) AS CndnContrSettlmtType,
  CC.PersonWorkAgreement AS PersonWorkAgreement,
  CC.CompanyCode AS CndnContrCompanyCode,
  CC.CndnDocWorkerCostCenter AS CndnContrWorkerCostCenter,
  SDOC.InvoicingParty AS InvoicingParty,
  SDOC.BillToParty AS BillToParty,
  SDOC.PayeeParty AS PayeeParty,
  SDOC.PayerParty AS PayerParty,
  SDOC.AlternativeInvoicingParty AS AlternativeInvoicingParty,
  SDOC.SuplrSettlmtCompanyCode AS SettlmtCompanyCode,
  SDOC.PurchasingOrganization AS PurchasingOrganization,
  SDOC.PurchasingGroup AS PurchasingGroup,
  SDOC.SalesOrganization AS SalesOrganization,
  SDOC.DistributionChannel AS DistributionChannel,
  SDOC.Division AS Division,
  SDOC.SettlmtDocType AS SettlmtDocType,
  SDOC.DocumentDate AS DocumentDate,
  SDOC.PostingDate AS PostingDate,
  SDOC.SettlmtDocCurrency AS SettlmtDocCurrency,
  SDOC.SettlmtDate AS SettlmtDate,
  SDOC.SettlmtMgmtAcctgTransfSts AS SettlmtMgmtAcctgTransfSts,
  SDOC.SettlmtProcessType AS SettlmtProcessType,
  SDOC.PostingPartnerCat AS PostingPartnerCat,
  SDOC.CndnContrProcessCategory AS CndnContrProcessCategory,
  SDOC.CustSettlmtCompanyCode AS CustSettlmtCompanyCode,
  SDOC.SettlmtDocAuthznCat AS SettlmtDocAuthznCat,
  SDOCI.Product AS SettlmtProduct,
  SDOCI.SettlmtDocItemText AS SettlmtDocItemText,
  SDOCI.SuplrSettlmtControllingArea AS SettlmtControllingArea,
  SDOCI.CreationDate AS SettlmtCreationDate,
  SDOCI.SuplrSettlmtCostCenter AS SettlmtCostCenter,
  SDOCI.SuplrSettlmtProfitCenter AS SettlmtProfitCenter,
  BVD.root_key AS SettledSuplrInvcUUID,
  cast( BVD.budat as wlf_bv_doc_exch_rate_date preserving type ) AS BusVolDocExchangeRateDate,
  BVDI.MATNR AS BusVolDocItmProduct,
  BVDI.SHKZG AS DebitCreditCode,
  BVDI.WERKS AS BusVolDocItmPlant,
  cast ( BVDI.MENGE as wlf_bv_doc_itm_qty preserving type ) AS BusVolDocItmQuantity,
  cast( BVDI.BSTME as wlf_bv_doc_itm_qty_unit preserving type ) AS BusVolDocItmQuantityUnit,
  BVDI.BASME AS BaseUnit,
  BVDI.WRBTR AS BusVolDocItmNetAmount,
  BVDI.EBELN AS PurchaseOrder,
  BVDI.EBELP AS PurchaseOrderItem
FROM R_CndnContrSettlmtDetldStmnt AS BVDET
LEFT OUTER JOIN I_Currency AS _SettlmtDocCurrency ON SettlmtDocCurrency = _SettlmtDocCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _BusVolDocCurrency ON BusVolDocCurrency = _BusVolDocCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BusVolDocItmQuantityUnit ON BusVolDocItmQuantityUnit = _BusVolDocItmQuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _SettledBusVolQtyUnit ON SettledBusVolQtyUnit = _SettledBusVolQtyUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _SettledBusVolWeightUnit ON SettledBusVolWeightUnit = _SettledBusVolWeightUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _SettledBusVolVolumeUnit ON SettledBusVolVolumeUnit = _SettledBusVolVolumeUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _SettledBusVolPointsQtyUnit ON SettledBusVolPointsQtyUnit = _SettledBusVolPointsQtyUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnit ON BaseUnit = _BaseUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_PurchaseOrderItem AS _POItem ON PurchaseOrder = _POItem.PurchaseOrder AND PurchaseOrderItem = _POItem.PurchaseOrderItem  -- association [0..1]
;