C_SlsDocFlfmtDelivDocItem

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_SlsDocFlfmtDelivDocItem.
-- 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: CSOFDELIVDOCITEM

CREATE VIEW C_SlsDocFlfmtDelivDocItem AS
SELECT
  Item.DeliveryDocument AS DeliveryDocument,
  Item.DeliveryDocumentItem AS DeliveryDocumentItem,
  Item.DeliveryDocumentItemCategory AS DeliveryDocumentItemCategory,
  Item.DeliveryDocumentItemText AS DeliveryDocumentItemText,
  cast(Item.Material as productnumber preserving type ) AS Material,
  Item._Material._Text[1:Language=$session.system_language].MaterialName AS MaterialName,
  Item.MaterialByCustomer AS MaterialByCustomer,
  cast(Item.MaterialGroup as productgroup preserving type ) AS MaterialGroup,
  Item.Batch AS Batch,
  Item.Plant AS Plant,
  Item.Warehouse AS Warehouse,
  Item._Warehouse._Text[1:Language=$session.system_language].WarehouseName AS WarehouseName,
  Item.StorageLocation AS StorageLocation,
  Item.ActualDeliveryQuantity AS ActualDeliveryQuantity,
  Item.DeliveryQuantityUnit AS DeliveryQuantityUnit,
  Item.ItemGrossWeight AS ItemGrossWeight,
  Item.ItemNetWeight AS ItemNetWeight,
  Item.ItemWeightUnit AS ItemWeightUnit,
  Item.ItemVolume AS ItemVolume,
  Item.ItemVolumeUnit AS ItemVolumeUnit,
  Item.LoadingGroup AS LoadingGroup,
  Item.TransportationGroup AS TransportationGroup,
  Item.GoodsMovementType AS GoodsMovementType,
  Item.InventorySpecialStockType AS InventorySpecialStockType,
  Item.StockType AS StockType,
  Item.WarehouseStagingArea AS WarehouseStagingArea,
  Item._WarehouseStagingArea._Text[1:Language=$session.system_language].WarehouseStagingAreaName AS WarehouseStagingAreaName,
  Item.OverdelivTolrtdLmtRatioInPct AS OverdelivTolrtdLmtRatioInPct,
  Item.UnderdelivTolrtdLmtRatioInPct AS UnderdelivTolrtdLmtRatioInPct,
  Item.ItemBillingBlockReason AS ItemBillingBlockReason,
  Item.PickingStatus AS PickingStatus,
  Item.DeliveryRelatedBillingStatus AS DeliveryRelatedBillingStatus,
  Item.PackingStatus AS PackingStatus,
  Item.PickingConfirmationStatus AS PickingConfirmationStatus,
  Item.WarehouseActivityStatus AS WarehouseActivityStatus,
  Item.GoodsMovementStatus AS GoodsMovementStatus,
  cast( Item.ChmlCmplncStatus as mon_tdd_pcsta preserving type ) AS ChmlCmplncStatus,
  cast( Item.DangerousGoodsStatus as mon_tdd_dgsta preserving type ) AS DangerousGoodsStatus,
  cast( Item.SafetyDataSheetStatus as mon_tdd_sdssta preserving type ) AS SafetyDataSheetStatus,
  cast( Item.TrdCmplncEmbargoSts as embargochksts preserving type ) AS TrdCmplncEmbargoSts,
  cast( Item.TrdCmplncSnctndListChkSts as watchlistscrngchksts preserving type ) AS TrdCmplncSnctndListChkSts,
  cast( Item.TrdCmplncLegalControlSts as trdcmplnclglctrlchksts preserving type ) AS TrdCmplncLegalControlSts,
  Item._ChmlCmplncStatus AS _ChmlCmplncStatus,
  Item._DangerousGoodsStatus AS _DangerousGoodsStatus,
  Item._SafetyDataSheetStatus AS _SafetyDataSheetStatus,
  Item._TrdCmplncEmbargoSts AS _TrdCmplncEmbargoSts,
  Item._TrdCmplncSnctndListChkSts AS _TrdCmplncSnctndListChkSts,
  Item._TrdCmplncLegalControlSts AS _TrdCmplncLegalControlSts
FROM I_DeliveryDocumentItem AS Item
LEFT OUTER JOIN E_DeliveryDocumentItem AS _Extension ON DeliveryDocument = _Extension.DeliveryDocument AND DeliveryDocumentItem = _Extension.DeliveryDocumentItem  -- association [0..1]
;