C_MntrProdAllocOrderItemPerds

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_MntrProdAllocOrderItemPerds.
-- 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: CMPAORDITMPERDS

CREATE VIEW C_MntrProdAllocOrderItemPerds AS
SELECT
  ProdAllocAssignedOrder,
  ProdAllocAssignedOrderItem,
  ProdAllocAssignedOrderType,
  ProdAllocPerdStartUTCDateTime,
  ConfirmationUTCDateTime,
  AssignmentSequenceNumberValue,
  CharcValueCombinationUUID,
  cast(ProdAllocationConfirmationDate as prodallocationconfirmationdate) AS ProdAllocationConfirmationDate,
  cast(ProdAllocationPeriodStartDate as prodallocationperiodstartdate) AS ProdAllocationPeriodStartDate,
  cast(ProductAllocationPeriodEndDate as productallocationperiodenddate) AS ProductAllocationPeriodEndDate,
  ProdAllocCharc01,
  ProdAllocCharc02,
  ProdAllocCharc03,
  ProdAllocCharc04,
  ProdAllocCharc05,
  ProdAllocCharc06,
  ProdAllocCharc07,
  ProdAllocCharc08,
  ProdAllocCharc09,
  ProdAllocCharc10,
  CharcValAuthznGroup,
  ProductAllocationObjectUUID,
  cast( ' ' as prodallocobjcharacteristics ) AS ProdAllocObjCharacteristics,
  cast( ' ' as prodalloccharcvalcombn ) AS ProdAllocCharcValCombn,
  cast( ' ' as prodalloccharcvalcombdesc ) AS ProdAllocCharcValCombDesc,
  ConfirmationDateTimeType,
  _ProductAllocationObjectText.ProdAllocObjectDescription AS ProdAllocObjectDescription,
  ProductAllocationObject,
  ProdAllocSqncConstraintUUID,
  ProductAllocationSequenceUUID,
  _ProductAllocationSequenceT.ProductAllocationSequenceDesc AS ProductAllocationSequenceDesc,
  _ProdAllocSequenceConstraint._ProductAllocationSequence.ProductAllocationSequence AS ProductAllocationSequence,
  _ProdAllocSequenceConstraint.ProdAllocSequenceConstraint AS ProdAllocSequenceConstraint,
  _ProdAllocSequenceConstraint.ProductAllocationSequenceGroup AS ProductAllocationSequenceGroup,
  _ProdAllocSequenceConstraint._ProdAllocationSequenceGroup.ProdAllocSequenceGroupType AS ProdAllocSequenceGroupType,
  ProdAllocSqncGrpPriorityValue,
  ProdAllocAssignedQuantityUnit,
  ProdAllocAssignedQuantity,
  P_MntrProdAllocOrderItemPerds.ProdAllocSqncCstrtCnsmpnUnit AS ProdAllocSqncConsumptionUnit,
  cast(division(ProdAllocAssignedQuantity, _ProdAllocSequenceConstraint.ProductAllocationRate, 3) as prodalloccnsmdqtyincnsmpnunit) AS ProdAllocCnsmdQtyInCnsmpnUnit
FROM P_MntrProdAllocOrderItemPerds
LEFT OUTER JOIN I_ProductAllocationObjectText AS _ProductAllocationObjectText ON ProductAllocationObjectUUID = _ProductAllocationObjectText.ProductAllocationObjectUUID AND _ProductAllocationObjectText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ProductAllocationSequenceT AS _ProductAllocationSequenceT ON ProductAllocationSequenceUUID = _ProductAllocationSequenceT.ProductAllocationSequenceUUID AND _ProductAllocationSequenceT.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ProdAllocSequenceGroupType AS _ProdAllocSequenceGroupType ON _ProdAllocSequenceGroupType.ProdAllocSequenceGroupType = prodallocsequencegrouptype  -- association [0..1]
;