P_RevProdAllocChkPerdOrdItm

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 P_RevProdAllocChkPerdOrdItm.
-- 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: PRPACPERORITM

CREATE VIEW P_RevProdAllocChkPerdOrdItm AS
SELECT
  cast(QuantityAssignment.ProdAllocAssignedOrder as revprodallocchkcorder preserving type ) AS ProdAllocAssignedOrder,
  cast(QuantityAssignment.ProdAllocAssignedOrderItem as revprodallocchkcorderitem preserving type ) AS ProdAllocAssignedOrderItem,
  QuantityAssignment.ProdAllocAssignedOrderType AS ProdAllocAssignedOrderType,
  QuantityAssignment.CharcValueCombinationUUID AS CharcValueCombinationUUID,
  QuantityAssignment.ProdAllocPerdStartUTCDateTime AS ProdAllocPerdStartUTCDateTime,
  QuantityAssignment.ProdAllocSqncConstraintUUID AS ProdAllocSqncConstraintUUID,
  QuantityAssignment.ProdAllocPeriodStartTimeZone AS ProdAllocPeriodStartTimeZone,
  QuantityAssignment.ProdAllocAssignedQuantity AS ProdAllocAssignedQuantity,
  cast(division(cast( QuantityAssignment.ProdAllocAssignedQuantity as revprodallocchkconsumption preserving type),QuantityAssignment._ProdAllocSequenceConstraint.ProductAllocationRate,3) as revprodallocchkconsumption ) AS ProdAllocCnsmdQtyInCnsmpnUnit,
  QuantityAssignment._ProdAllocSequenceConstraint.ProductAllocationRate AS ProductAllocationRate,
  QuantityAssignment.ProdAllocAssignedQuantityUnit AS ProdAllocAssignedQuantityUnit,
  cast('' as prodallocqtyassgmtistmp preserving type ) AS ProdAllocQtyAssgmtIsTmp,
  cast( hextobin('00000000000000000000000000000000') as atp_cid preserving type ) AS ATPCheckUUID,
  SalesDocItem.Material AS Material,
  SalesDocItem._Material.MaterialBaseUnit AS BaseUnit,
  TmpQuantityAssignmentNoOrder.ProdAllocAssignedQuantityUnit AS ProdAllocSqncConsumptionUnit,
  cast('' as uepos) AS HigherLevelItem
FROM I_ProdAllocQuantityAssignment AS QuantityAssignment
-- UNION ALL with additional select branch(es): I_ProdAllocTmpQtyAssignment, I_ProdAllocTmpQtyAssignment
;