I_CFinRpldSalesDocumentItem

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 I_CFinRpldSalesDocumentItem.
-- 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 I_CFinRpldSalesDocumentItem AS
SELECT
  cfin_av_so_item.fins_logsys AS SenderLogicalSystem,
  cast(cfin_av_so_item.vbeln as fins_cfin_av_rpld_sls_doc preserving type ) AS CFinReplicatedSalesDocument,
  cast(cfin_av_so_item.posnr as fins_cfin_av_rpld_sls_doc_item preserving type ) AS CFinRpldSalesDocumentItem,
  cfin_av_so_item.vgbel AS ReferenceSDDocument,
  cfin_av_so_item.vgpos AS ReferenceSDDocumentItem,
  cfin_av_so_item.vgtyp AS ReferenceSDDocumentCategory,
  cfin_av_so_item.gsber AS BusinessArea,
  cfin_av_so_item.matnr AS Material,
  cfin_av_so_item.pstyv AS SalesDocumentItemCategory,
  cfin_av_so_item.spart AS Division,
  cfin_av_so_item.werks AS Plant,
  cfin_av_so_item.matkl AS MaterialGroup,
  cfin_av_so_item.lgort AS StorageLocation,
  cfin_av_so_item.prctr AS ProfitCenter,
  cfin_av_so_item.erdat AS CreationDate,
  cfin_av_so_item.aedat AS LastChangeDate,
  cfin_av_so_item.shkzg AS IsReturnsItem,
  cfin_av_so_item.vbelv AS OriginSDDocument,
  cfin_av_so_item.posnv AS OriginSDDocumentItem,
  cfin_av_so_item.kwmeng AS OrderQuantity,
  cfin_av_so_item.umvkn AS OrderToBaseQuantityDnmntr,
  cfin_av_so_item.umvkz AS OrderToBaseQuantityNmrtr,
  cfin_av_so_item.meins AS BaseUnit,
  cfin_av_so_item.zmeng AS TargetQuantity,
  cfin_av_so_item.umzin AS TargetToBaseQuantityDnmntr,
  cfin_av_so_item.umziz AS TargetToBaseQuantityNmrtr,
  cfin_av_so_item.aufnr AS OrderID,
  cfin_av_so_item.fkrel AS ItemIsBillingRelevant,
  cfin_av_so_item.fixmg AS DeliveryDateQuantityIsFixed,
  cfin_av_so_item.waerk AS TransactionCurrency,
  cfin_av_so_item.kbmeng AS ConfdDelivQtyInOrderQtyUnit,
  cfin_av_so_item.vrkme AS OrderQuantityUnit,
  cfin_av_so_item.abgru AS SalesDocumentRjcnReason,
  cfin_av_so_item.kowrr AS StatisticalValueControl,
  cfin_av_so_item.netwr AS NetAmount,
  cfin_av_so_item.brgew AS ItemGrossWeight,
  cfin_av_so_item.ntgew AS ItemNetWeight,
  cfin_av_so_item.gewei AS ItemWeightUnit,
  cfin_av_so_item.volum AS ItemVolume,
  cfin_av_so_item.voleh AS ItemVolumeUnit,
  cfin_av_so_item.zieme AS TargetQuantityUnit,
  cfin_av_so_item.paobjnr AS ProfitabilitySegment,
  cast( cfin_av_so_item.ps_psp_pnr as ps_s4_pspnr preserving type ) AS WBSElementInternalID,
  cfin_av_so_item.bukrs AS CompanyCode,
  cfin_av_so_biz.kdgrp AS CustomerGroup,
  cfin_av_so_biz.prsdt AS PricingDate,
  cfin_av_so_biz.valtg AS AdditionalValueDays,
  cfin_av_so_biz.fkdat AS BillingDocumentDate
FROM cfin_av_so_item
LEFT OUTER JOIN I_CFinReplicatedSalesDocument AS _SalesDocument ON CFinReplicatedSalesDocument = _SalesDocument.CFinReplicatedSalesDocument AND SenderLogicalSystem = _SalesDocument.SenderLogicalSystem  -- association [1..1]
LEFT OUTER JOIN I_CFinRpldSalesDocScheduleLine AS _ScheduleLine ON CFinReplicatedSalesDocument = _ScheduleLine.CFinReplicatedSalesDocument AND CFinRpldSalesDocumentItem = _ScheduleLine.CFinRpldSalesDocumentItem AND SenderLogicalSystem = _ScheduleLine.SenderLogicalSystem  -- association [0..*]
LEFT OUTER JOIN I_SalesDocumentItemCategory AS _ItemCategory ON SalesDocumentItemCategory = _ItemCategory.SalesDocumentItemCategory  -- association [0..1]
LEFT OUTER JOIN I_Division AS _Division ON Division = _Division.Division  -- association [0..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_MaterialGroup AS _MaterialGroup ON MaterialGroup = _MaterialGroup.MaterialGroup  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _OrderQuantityUnit ON OrderQuantityUnit = _OrderQuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _TargetQuantityUnit ON TargetQuantityUnit = _TargetQuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnit ON BaseUnit = _BaseUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ItemWeightUnit ON ItemWeightUnit = _ItemWeightUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ItemVolumeUnit ON ItemVolumeUnit = _ItemVolumeUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_CustomerGroup AS _CustomerGroup ON CustomerGroup = _CustomerGroup.CustomerGroup  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentRjcnReason AS _SalesDocumentRjcnReason ON SalesDocumentRjcnReason = _SalesDocumentRjcnReason.SalesDocumentRjcnReason  -- association [0..1]
LEFT OUTER JOIN I_StatisticalValueControl AS _StatisticalValueControl ON StatisticalValueControl = _StatisticalValueControl.StatisticalValueControl  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS _StorageLocation ON Plant = _StorageLocation.Plant AND StorageLocation = _StorageLocation.StorageLocation  -- association [0..1]
LEFT OUTER JOIN I_BillingRelevanceCode AS _ItemIsBillingRelevant ON ItemIsBillingRelevant = _ItemIsBillingRelevant.BillingRelevanceCode  -- association [0..1]
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON BusinessArea = _BusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_CFinReplicatedSalesDocument AS _ReferenceSDDocument ON ReferenceSDDocument = _ReferenceSDDocument.CFinReplicatedSalesDocument AND SenderLogicalSystem = _ReferenceSDDocument.SenderLogicalSystem  -- association [0..1]
LEFT OUTER JOIN I_CFinRpldSalesDocumentItem AS _ReferenceSDDocumentItem ON ReferenceSDDocument = _ReferenceSDDocumentItem.CFinReplicatedSalesDocument AND ReferenceSDDocumentItem = _ReferenceSDDocumentItem.CFinRpldSalesDocumentItem AND SenderLogicalSystem = _ReferenceSDDocumentItem.SenderLogicalSystem  -- association [0..1]
LEFT OUTER JOIN I_SDDocumentCategory AS _ReferenceSDDocumentCategory ON ReferenceSDDocumentCategory = _ReferenceSDDocumentCategory.SDDocumentCategory  -- association [0..1]
LEFT OUTER JOIN I_LogicalSystem AS _LogicalSystem ON SenderLogicalSystem = _LogicalSystem.LogicalSystem  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicData ON WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenter AS _ProfitCenter ON ProfitCenter = _ProfitCenter.ProfitCenter AND ControllingArea = _ProfitCenter.ControllingArea  -- association [0..*]
LEFT OUTER JOIN E_CFinRpldSalesDocumentItem AS _Extension ON CFinReplicatedSalesDocument = _Extension.CFinReplicatedSalesDocument AND SenderLogicalSystem = _Extension.SourceSystemLogicalSystem AND CFinRpldSalesDocumentItem = _Extension.CFinRpldSalesDocumentItem  -- association [1..1]
;