C_MRPOutboundDeliveryCard

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_MRPOutboundDeliveryCard.
-- 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 C_MRPOutboundDeliveryCard AS
SELECT
  I_MRPOutboundDelivery.Delivery AS OutboundDelivery,
  I_MRPOutboundDelivery.DeliveryItem AS OutboundDeliveryItem,
  I_MRPOutboundDelivery.DeliveryType AS DeliveryType,
  I_MRPOutboundDelivery.MRPPlant AS MRPPlant,
  I_MRPOutboundDelivery.MRPPlantName AS MRPPlantName,
  I_MRPOutboundDelivery.BaseUnit AS BaseUnit,
  I_MRPOutboundDelivery.SalesUnit AS SalesUnit,
  I_MRPOutboundDelivery.DeliveredQuantityInSalesUnit AS DeliveredQuantityInSalesUnit,
  I_MRPOutboundDelivery.Customer AS Customer,
  I_MRPOutboundDelivery.CustomerName AS CustomerName,
  cast('' as ad_namtext) AS ContactPersonName,
  cast('' as ad_tlnmbr1) AS ContactPersonPhoneNumber,
  cast('' as ad_smtpadr) AS InternalContactEmailAddress,
  I_MRPOutboundDelivery.DocumentDate AS DocumentDate,
  I_MRPOutboundDelivery.ProductAvailabilityDate AS ProductAvailabilityDate,
  I_MRPOutboundDelivery.RequestedLoadingDate AS RequestedLoadingDate,
  I_MRPOutboundDelivery.RequestedDeliveryDate AS RequestedDeliveryDate,
  I_MRPOutboundDelivery.DeliveredQuantityInBaseUnit AS DeliveredQuantityInBaseUnit,
  I_MRPOutboundDelivery.ReferenceDocument AS ReferenceDocument,
  I_MRPOutboundDelivery.DeliveryPriority AS DeliveryPriority,
  I_MRPOutboundDelivery.DeliveryPriorityDesc AS DeliveryPriorityDesc,
  I_MRPOutboundDelivery.DeliveryBlockReason AS DeliveryBlockReason,
  I_MRPOutboundDelivery.DeliveryBlockReasonText AS DeliveryBlockReasonText,
  cast(0 as mng01) AS OpenDeliveryQuantity,
  I_MRPOutboundDelivery.OrderQuantity AS OrderQuantityInBaseUnit,
  I_MRPOutboundDelivery.ReferenceDocumentItem AS ReferenceDocumentItem,
  _SalesDocumentItem.SalesDocumentItemText AS SalesDocumentItemText,
  I_MRPOutboundDelivery.ReferenceSDDocumentCategory AS ReferenceSDDocumentCategory,
  I_MRPOutboundDelivery.ReferenceSDDocument AS ReferenceSDDocument,
  cast ( concat( ltrim ( I_MRPOutboundDelivery.Delivery, '0' ), concat( '-', ltrim ( I_MRPOutboundDelivery.DeliveryItem, '0' ) ) ) as abap.char( 18 ) ) as SourceOrderName AS char18asSourceOrderName,
  MaterialByCustomer,
  WBSElementExternalID,
  WBSDescription,
  ResponsiblePerson,
  ResponsiblePersonName,
  ProjectExternalID,
  ProjectDescription,
  I_MRPOutboundDelivery.Material AS Material,
  I_MRPOutboundDelivery.MaterialName AS MaterialName,
  cast ( 'VJ' as delkz preserving type ) AS MRPElementCategory,
  cast( concat( _MRPElementCategoryText.MRPElementCategoryShortName, concat( '-', concat( ltrim ( I_MRPOutboundDelivery.Delivery, '0' ), concat( '-', ltrim ( I_MRPOutboundDelivery.DeliveryItem, '0' ) ) ) ) ) as char30 ) as MRPAffectedOrder AS DeliveryItem0aschar30asMRPAffectedOrder,
  cast ( case when Customer is initial then 'X' else '' end as boolean preserving type ) AS UICT_Customer,
  cast ( '' as boolean preserving type ) AS UICT_ContactPersonName,
  cast ( '' as boolean preserving type ) AS UICT_ContactPersonPhoneNumber,
  cast ( '' as boolean preserving type ) AS UICT_IntContactEmailAddress,
  cast ( case when DocumentDate is initial then 'X' else '' end as boolean preserving type ) AS UICT_DocumentDate,
  cast ( case when ProductAvailabilityDate is initial then 'X' else '' end as boolean preserving type ) AS UICT_ProductAvailabilityDate,
  cast ( case when RequestedLoadingDate is initial then 'X' else '' end as boolean preserving type ) AS UICT_RequestedLoadingDate,
  cast ( case when RequestedDeliveryDate is initial then 'X' else '' end as boolean preserving type ) AS UICT_RequestedDeliveryDate,
  cast ( case when DeliveredQuantityInBaseUnit is initial then 'X' else '' end as boolean preserving type ) AS UICT_DeliveredQuantInBaseUnit,
  cast ( case when ReferenceDocument is initial then 'X' else '' end as boolean preserving type ) AS UICT_ReferenceDocument,
  cast ( case when DeliveryPriority is initial then 'X' else '' end as boolean preserving type ) AS UICT_DeliveryPriority,
  cast ( case when deliveryblockreason is initial then 'X' else '' end as boolean preserving type ) AS UICT_DeliveryBlockReason,
  cast ( '' as boolean preserving type ) AS UICT_OpenDeliveryQuantity,
  cast ( case when OrderQuantityInBaseUnit is initial then 'X' else '' end as boolean preserving type ) AS UICT_OrderQuantityInBaseUnit,
  cast ( case when MaterialByCustomer is initial then 'X' else '' end as boolean preserving type ) AS UICT_MaterialByCustomer,
  cast ( case when WBSElementExternalID is initial then 'X' else '' end as boolean preserving type ) AS UICT_WBSElementExternalID,
  cast ( case when WBSDescription is initial then 'X' else '' end as boolean preserving type ) AS UICT_WBSDescription,
  cast ( case when ResponsiblePerson = '00000000' then 'X' else '' end as boolean preserving type ) AS UICT_ResponsiblePerson,
  cast ( case when ResponsiblePersonName is initial then 'X' else '' end as boolean preserving type ) AS UICT_ResponsiblePersonName,
  cast ( case when ProjectExternalID is initial then 'X' else '' end as boolean preserving type ) AS UICT_ProjectExternalID,
  cast ( case when ProjectDescription is initial then 'X' else '' end as boolean preserving type ) AS UICT_ProjectDescription,
  cast ( case when Material is initial then 'X' else '' end as boolean preserving type ) AS UICT_Material,
  cast ( case when MaterialName is initial then 'X' else '' end as boolean preserving type ) AS UICT_MaterialName
LEFT OUTER JOIN C_OutboundDeliveryFs AS _OutboundDelivery ON OutboundDelivery = _OutboundDelivery.OutboundDelivery  -- association [1..1]
LEFT OUTER JOIN I_MRPElementCategoryText AS _MRPElementCategoryText ON _MRPElementCategoryText.MRPElementCategory = 'VJ' AND _MRPElementCategoryText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentItem AS _SalesDocumentItem ON ReferenceDocument = _SalesDocumentItem.SalesDocument AND ReferenceDocumentItem = _SalesDocumentItem.SalesDocumentItem  -- association [0..1]
;