C_MntrProdAllocOrderItem

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_MntrProdAllocOrderItem.
-- 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: CMPAORDITM

CREATE VIEW C_MntrProdAllocOrderItem AS
SELECT
  cast ( ProdAllocAssignedOrder as prodallocorder preserving type ) AS ProdAllocAssignedOrder,
  ProdAllocAssignedOrderItem AS OrderItem,
  ProdAllocAssignedOrderType,
  SalesDocumentType,
  OrganizationDivision,
  SalesOrganization,
  P_MntrProdAllocOrderItem.DistributionChannel AS DistributionChannel,
  cast(concat_with_space(ltrim(ProdAllocAssignedOrder,'0'), concat_with_space('-', ltrim(ProdAllocAssignedOrderItem, '0'), 1), 1) as prodallocassignedorderitemid) AS ProdAllocAssignedOrderItem,
  Plant,
  Material,
  ReceivingPlant,
  SoldToParty,
  PurchaseOrderByCustomer,
  _CustomerVH.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  SDProcessStatus,
  TotalBlockStatus,
  DeliveryBlockStatus,
  TotalDeliveryStatus,
  cast(RequestedDeliveryDate as pal_reqddeliverydate) AS ProdAllocationPeriodStartDate,
  cast(ProductAllocationPeriodEndDate as pal_latestdeliverydate) AS ProductAllocationPeriodEndDate,
  cast(RequestedDeliveryDate as pal_reqddeliverydate_earliest) AS RequestedDeliveryDate,
  RequestedQuantityUnit,
  cast(RequestedQuantity as pal_requestedquantity) AS RequestedQuantity,
  ConfirmedQuantityUnit,
  cast(ConfirmedQuantity as prodallocconfirmationquantity) AS ConfirmedQuantity,
  DeliveredQuantityUnit,
  cast(DeliveredQtyInOrderQtyUnit as pal_deliveredquantity) AS DeliveredQtyInOrderQtyUnit,
  cast(P_MntrProdAllocOrderItem.ProdAllocATPStatus as prodallocatpstatus) AS ProdAllocATPStatus,
  cast(HigherLevelItem as prodallochigherlevelorderitem) AS HigherLevelItem,
  CreationDate,
  CreatedByUserName,
  SDDocumentCategory,
  cast( ' ' as productallocationobject preserving type ) AS ProductAllocationObject,
  cast( ' ' as prodalloccharcvalcombn ) AS ProdAllocCharcValCombn
FROM P_MntrProdAllocOrderItem
LEFT OUTER JOIN C_MntrProdAllocOrderItemPerds AS _MntrProdAllocOrderItemPerds ON OrderItem = _MntrProdAllocOrderItemPerds.ProdAllocAssignedOrderItem AND ProdAllocAssignedOrderType = _MntrProdAllocOrderItemPerds.ProdAllocAssignedOrderType AND ProdAllocAssignedOrder = _MntrProdAllocOrderItemPerds.ProdAllocAssignedOrder  -- association [0..*]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON Material = _MaterialText.Material  -- association [0..*]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _ReceivingPlant ON ReceivingPlant = _ReceivingPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_Customer_VH AS _CustomerVH ON SoldToParty = _CustomerVH.Customer  -- association [0..1]
LEFT OUTER JOIN I_TotalBlockStatus AS _TotalBlockStatus ON TotalBlockStatus = _TotalBlockStatus.TotalBlockStatus  -- association [0..1]
LEFT OUTER JOIN I_DeliveryBlockStatus AS _DeliveryBlockStatus ON DeliveryBlockStatus = _DeliveryBlockStatus.DeliveryBlockStatus  -- association [0..1]
LEFT OUTER JOIN I_TotalDeliveryStatus AS _TotalDeliveryStatus ON TotalDeliveryStatus = _TotalDeliveryStatus.TotalDeliveryStatus  -- association [0..1]
LEFT OUTER JOIN I_SDProcessStatus AS _SDProcessStatus ON SDProcessStatus = _SDProcessStatus.SDProcessStatus  -- association [0..1]
LEFT OUTER JOIN I_ProdAllocATPStatus AS _ProdAllocATPStatus ON ProdAllocATPStatus = _ProdAllocATPStatus.ProdAllocATPStatus  -- association [0..1]
;