R_SettledMatlDocItemBasic

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_SettledMatlDocItemBasic.
-- 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_SettledMatlDocItemBasic AS
SELECT
  BVDET.ConditionContract AS ConditionContract,
  BVDET.SettlmtDoc AS SettlmtDoc,
  BVDET.SettlmtDocItem AS SettlmtDocItem,
  cast ( BVDET.SetldBusVolDocKey1 as wlf_setld_mat_doc ) AS SettledMaterialDocument,
  cast ( BVDET.SetldBusVolDocKey2 as wlf_setld_mat_doc_year ) AS SettledMaterialDocumentYear,
  cast ( BVDET.SetldBusVolDocItem as wlf_setld_mat_doc_item ) AS SettledMaterialDocumentItem,
  cast( BVDET.SetldBusVolDocCategory as wb2_doc_type_busvol preserving type ) 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.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.CndnContrProcessCategory AS CndnContrProcessCategory,
  SDOC.SettlmtDocCurrency AS SettlmtDocCurrency,
  SDOC.SettlmtDate AS SettlmtDate,
  SDOC.SettlmtMgmtAcctgTransfSts AS SettlmtMgmtAcctgTransfSts,
  SDOC.SettlmtProcessType AS SettlmtProcessType,
  SDOC.PostingPartnerCat AS PostingPartnerCat,
  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,
  cast( BVD.PostingDate as wlf_bv_doc_exch_rate_date preserving type ) AS BusVolDocExchangeRateDate,
  BVDI.Material AS BusVolDocItmProduct,
  BVDI.DebitCreditCode AS DebitCreditCode,
  BVDI.Plant AS BusVolDocItmPlant,
  BVDI.QuantityInEntryUnit AS BusVolDocItmQuantity,
  BVDI.EntryUnit AS BusVolDocItmQuantityUnit,
  cast( BVDI.QuantityInBaseUnit as wlf_bv_doc_itm_qty_in_bs_unit preserving type ) AS BusVolDocItmQtyInBsUnt,
  BVDI.MaterialBaseUnit AS BaseUnit,
  BVDI.TotalGoodsMvtAmtInCCCrcy AS BusVolDocItmNetAmount,
  BVDI.PurchaseOrder AS PurchaseOrder,
  BVDI.PurchaseOrderItem AS PurchaseOrderItem
FROM R_CndnContrSettlmtDetldStmnt AS BVDET
LEFT OUTER JOIN I_PurchaseOrderItem AS _POItem ON PurchaseOrder = _POItem.PurchaseOrder AND PurchaseOrderItem = _POItem.PurchaseOrderItem  -- association [0..1]
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]
;