R_SettledSuplrBillgDocItmBasic

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_SettledSuplrBillgDocItmBasic.
-- 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_SettledSuplrBillgDocItmBasic AS
SELECT
  BVDET.ConditionContract AS ConditionContract,
  BVDET.SettlmtDoc AS SettlmtDoc,
  BVDET.SettlmtDocItem AS SettlmtDocItem,
  cast (BVDET.SetldBusVolDocKey1 as wlf_setld_suplr_billg_doc ) AS SettledSuplrBillgDoc,
  cast( BVDET.SetldBusVolDocItem as wlf_setld_suplr_billg_doc_itm ) AS SettledSuplrBillgDocItem,
  BVDET.SetldBusVolDocCategory AS BusVolDocCat,
  BVDET.BusVolSelDteForSettlmt AS BusVolSelDteForSettlmt,
  BVDET.SettledBusVolQty 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.AlternativeInvoicingParty AS AlternativeInvoicingParty,
  SDOC.PayerParty AS PayerParty,
  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,
  cast( SDOCI.Product as wb2_settlement_product ) AS SettlmtProduct,
  SDOCI.SettlmtDocItemText AS SettlmtDocItemText,
  SDOCI.SuplrSettlmtControllingArea AS SettlmtControllingArea,
  SDOCI.CreationDate AS SettlmtCreationDate,
  SDOCI.SuplrSettlmtCostCenter AS SettlmtCostCenter,
  SDOCI.SuplrSettlmtProfitCenter AS SettlmtProfitCenter,
  BVD.ExchangeRateDate AS BusVolDocExchangeRateDate,
  BVD.SettlmtDocCat AS SettlmtDocCat,
  BVDI.Product AS BusVolDocItmProduct,
  cast( BVDI.SuplrBillgDocItemText as wlf_bv_doc_itm_text ) AS BusVolDocItmText,
  BVDI.ProductGroup AS BusVolDocItmProductGroup,
  BVDI.SuplrBillgDocItmCat AS SuplrBillgDocItmCat,
  BVDI.Plant AS BusVolDocItmPlant,
  BVDI.SettlmtQuantity AS BusVolDocItmQuantity,
  BVDI.SettlmtQuantityUnit AS BusVolDocItmQuantityUnit,
  BVDI.SettlmtToBaseQuantityNmrtr AS SettlmtToBaseQuantityNmrtr,
  BVDI.SettlmtToBaseQuantityDnmntr AS SettlmtToBaseQuantityDnmntr,
  BVDI.BaseUnit AS BaseUnit,
  BVDI.SupplierItemNetAmount AS BusVolDocItmNetAmount
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]
;