C_OutboundDeliveryItemFs

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 C_OutboundDeliveryItemFs.
-- 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.
-- SQL view name: COUTBDELIVITMFS

CREATE VIEW C_OutboundDeliveryItemFs AS
SELECT
  OutboundDelivery,
  cast(OutboundDeliveryItem as le_doc_item ) AS OutboundDeliveryItem,
  OutboundDeliveryItem AS DeliveryDocumentItem,
  HigherLevelItem,
  HigherLvlItmOfBatSpltItm,
  cast( case when ( HigherLevelItem = '000000' and HigherLvlItmOfBatSpltItm = '000000' ) then concat( OutboundDeliveryItem, '0000000000000' ) when ( HigherLevelItem <> '000000' and HigherLvlItmOfBatSpltItm = '000000' ) then concat(concat(HigherLevelItem, OutboundDeliveryItem), HigherLvlItmOfBatSpltItm ) when ( HigherLevelItem <> '000000' and HigherLvlItmOfBatSpltItm <> '000000' ) then concat(concat(HigherLevelItem, HigherLvlItmOfBatSpltItm), OutboundDeliveryItem ) else concat(concat(HigherLvlItmOfBatSpltItm, OutboundDeliveryItem), HigherLevelItem ) end as abap.char( 18 )) as SortField AS char18asSortField,
  PickingStatus,
  cast( case PickingStatus when '' then 0 when 'A' then 2 when 'B' then 2 when 'C' then 3 else 0 end as abap.int1 ) as PickingStatusCriticality AS int1asPickingStatusCriticality,
  PickingConfirmationStatus,
  WarehouseActivityStatus,
  / Material AS Material,
  _Material._Text[1: Language=$session.system_language].MaterialName AS MaterialName,
  DeliveryDocumentItemText,
  DeliveryDocumentItemCategory,
  MaterialByCustomer,
  Batch,
  cast(InventoryValuationType as valuationtype) AS InventoryValuationType,
  InternationalArticleNumber,
  ManufactureDate,
  ShelfLifeExpirationDate,
  InspectionLot,
  cast( OriginalDeliveryQuantity as wmeng ) AS OrderQuantity,
  DeliveryQuantityUnit,
  ActualDeliveryQuantity,
  cast( concat_with_space( concat_with_space( concat_with_space( cast( DeliveryToBaseQuantityDnmntr as abap.char(9) ), DeliveryQuantityUnit, 1 ) , ':' , 1 ) , concat_with_space( cast( DeliveryToBaseQuantityNmrtr as abap.char(9) ) , BaseUnit , 1 ) , 1 ) as abap.char(20) ) as ConversionFactor AS char20asConversionFactor,
  cast(ActualDeliveredQtyInBaseUnit as le_lgmng) AS ActualDeliveredQtyInBaseUnit,
  BaseUnit,
  UnlimitedOverdeliveryIsAllowed,
  concat_with_space( cast( OverdelivTolrtdLmtRatioInPct as char10 ) , '%', 1) AS OverdelivTolrtdLmtRatioInPct,
  concat_with_space( cast( UnderdelivTolrtdLmtRatioInPct as char10 ) , '%', 1) AS UnderdelivTolrtdLmtRatioInPct,
  Plant,
  _Plant.PlantName AS PlantName,
  StorageLocation,
  _StorageLocation.StorageLocationName AS StorageLocationName,
  DeliveryItemResourceID,
  Warehouse,
  cast('' as char1) AS LastMileDistrIsActive,
  LoadingGroup,
  TransportationGroup,
  WarehouseStagingArea,
  ItemGrossWeight,
  ItemNetWeight,
  ItemWeightUnit,
  ItemVolume,
  ItemVolumeUnit,
  PackingStatus,
  ReceivingPoint,
  DepartmentClassificationByCust,
  LoadingPointForDelivery,
  ItemBillingBlockReason,
  DeliveryRelatedBillingStatus,
  IntercompanyBillingStatus,
  GoodsMovementStatus,
  InventorySpecialStockType,
  StockType,
  GoodsMovementType,
  SubsequentMovementType,
  WarehouseStockCategory,
  FldLogsStatus,
  _FldLogsDelivRefLinkInfo.FldLogsRefDocType AS FldLogsRefDocType,
  _FldLogsDelivRefLinkInfo._DelivRefDocTypeTxt.FldLogsRefDocTypeText AS FldLogsRefDocTypeText,
  _FldLogsDelivRefLinkInfo.FldLogsDelivRefDocNumberInfo AS FldLogsDelivRefDocNumberInfo,
  _FldLogsDelivRefLinkInfo.FldLogsRefDocItem AS FldLogsRefDocItem,
  _FldLogsDelivRefLinkInfo.FldLogsCrossDockingInfo AS FldLogsCrossDockingInfo,
  _OutboundDelivery.ShipToParty AS ShipToParty,
  cast('' as ad_namtext ) AS ShipToPartyFullName,
  ValueChainInstanceChar32UUID,
  cast( '' as vcm_value_chain_type ) AS ValueChainType,
  cast( '' as vcm_version_number ) AS ValueChainTypeVersion,
  ValueChainCategory,
  cast('' as char005) AS IsActive,
  cast('' as xfeld) AS ExciseMovementIsActive,
  I_OutboundDeliveryItem.ReferenceSDDocument AS ReferenceSDDocument,
  I_OutboundDeliveryItem.ReferenceSDDocumentItem AS JITCallComponentGrpItemNumber,
  I_OutboundDeliveryItem.ReferenceSDDocumentCategory AS ReferenceSDDocumentCategory
FROM I_OutboundDeliveryItem
LEFT OUTER JOIN C_RelSalesOrderItmDlvrFSS AS _SalesOrder ON OutboundDelivery = _SalesOrder.SalesDocument AND DeliveryDocumentItem = _SalesOrder.SalesDocumentItem AND _SalesOrder.SubsequentDocumentCategory = 'J'  -- association [0..*]
LEFT OUTER JOIN C_DeliveryPickSum AS _PickingSum ON OutboundDelivery = _PickingSum.PrecedingDocument AND DeliveryDocumentItem = _PickingSum.PrecedingDocumentItem  -- association [0..1]
LEFT OUTER JOIN C_DeliveryPickSub AS _PickingSub ON OutboundDelivery = _PickingSub.PrecedingDocument AND DeliveryDocumentItem = _PickingSub.PrecedingDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_PickingStatus AS _PickingStatus ON PickingStatus = _PickingStatus.PickingStatus  -- association [0..1]
LEFT OUTER JOIN C_SerialNmbrEquipNmbrDelivery AS _SerialNmbrEquipNmbrDelivery ON OutboundDelivery = _SerialNmbrEquipNmbrDelivery.DeliveryDocument AND DeliveryDocumentItem = _SerialNmbrEquipNmbrDelivery.DeliveryDocumentItem  -- association [0..*]
LEFT OUTER JOIN I_ValueChainType AS _ValueChainType ON ValueChainType = _ValueChainType.ValueChainType AND ValueChainTypeVersion = _ValueChainType.ValueChainTypeVersion  -- association [0..1]
LEFT OUTER JOIN C_OutbDlvItmJITCallCompGrpDet AS _JITInbCallComponentGroupDet ON ReferenceSDDocument = _JITInbCallComponentGroupDet.InternalJITCallNumber AND JITCallComponentGrpItemNumber = _JITInbCallComponentGroupDet.JITCallComponentGrpItemNumber AND ReferenceSDDocumentCategory = 'JITC'  -- association [0..*]
LEFT OUTER JOIN E_DeliveryDocumentItem AS _Extension ON OutboundDelivery = _Extension.DeliveryDocument AND DeliveryDocumentItem = _Extension.DeliveryDocumentItem  -- association [1]
;