C_RevProdAllocChkPerdOrdItm

DDL: C_REVPRODALLOCCHKPERDORDITM Type: view_entity CONSUMPTION Package: PAL_REVIEW_CHECK_RESULT
17 Fields 1 Data Sources 2 OData Services 1 Fiori Apps

Review Product Allocation Check Period Order Item

C_RevProdAllocChkPerdOrdItm is a Consumption CDS View that provides data about "Review Product Allocation Check Period Order Item" in SAP S/4HANA. It reads from 1 data source (P_RevProdAllocChkPerdOrdItmGrp) and exposes 17 fields with key fields ProdAllocAssignedOrder, ProdAllocAssignedOrderItem, ProdAllocAssignedOrderType, CharcValueCombinationUUID, ProdAllocPerdStartUTCDateTime. It is exposed through 2 OData services (ASQL_F4736, UI_REV_PROD_ALLOC_CHK_RSLT). It is used in 1 Fiori application: Review Availability Check Result - Product Allocation. Part of development package PAL_REVIEW_CHECK_RESULT.

Data Sources (1)

SourceAliasJoin Type
P_RevProdAllocChkPerdOrdItmGrp P_RevProdAllocChkPerdOrdItmGrp from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
EndUserText.label Review Product Allocation Check Period Order Item view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F4736 ASQL_F4736 C2 NOT_RELEASED
UI_REV_PROD_ALLOC_CHK_RSLT UI_REV_PROD_ALLOC_CHK_RSLT V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F5294 Review Availability Check Result - Product Allocation Transactional, Reuse Component Review Availability Check Result - Product Allocation

Review Availability Check Result - Product Allocation

Business Role: Others

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY ProdAllocAssignedOrder ProdAllocAssignedOrder Assigned Order
KEY ProdAllocAssignedOrderItem ProdAllocAssignedOrderItem Assigned Order Item
KEY ProdAllocAssignedOrderType ProdAllocAssignedOrderType Order Type
KEY CharcValueCombinationUUID CharcValueCombinationUUID Characteristic Value Combination UUID
KEY ProdAllocPerdStartUTCDateTime ProdAllocPerdStartUTCDateTime Period Start Date Time
KEY ATPCheckUUID ATPCheckUUID Check ID
KEY ProdAllocSqncConsumptionUnit ProdAllocSqncConsumptionUnit Consumption Unit
KEY ProdAllocQtyAssgmtIsTmp ProdAllocQtyAssgmtIsTmp
ProdAllocPeriodStartTimeZone ProdAllocPeriodStartTimeZone Period Start Time Zone
ProdAllocAssignedQuantity ProdAllocAssignedQuantity Assigned Quantity
ProdAllocAssignedQuantityUnit ProdAllocAssignedQuantityUnit Assigned Quantity Unit
ProdAllocCnsmdQtyInCnsmpnUnit ProdAllocCnsmdQtyInCnsmpnUnit
QuantityInBaseUnit
BaseUnit BaseUnit Unit of Measure
ProdAllocAssgdOrderTypeDesc ProdAllocAssgdOrderTypeDesc Order Type
Material Material Vehicle Model
HigherLevelItem HigherLevelItem Higher-Lev.Item

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_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.

CREATE VIEW C_RevProdAllocChkPerdOrdItm AS
SELECT
  ProdAllocAssignedOrder,
  ProdAllocAssignedOrderItem,
  ProdAllocAssignedOrderType,
  CharcValueCombinationUUID,
  ProdAllocPerdStartUTCDateTime,
  ATPCheckUUID,
  ProdAllocSqncConsumptionUnit,
  ProdAllocQtyAssgmtIsTmp,
  ProdAllocPeriodStartTimeZone,
  ProdAllocAssignedQuantity,
  ProdAllocAssignedQuantityUnit,
  ProdAllocCnsmdQtyInCnsmpnUnit,
  cast( 0 as revprodallocchkconsumption ) AS QuantityInBaseUnit,
  BaseUnit,
  ProdAllocAssgdOrderTypeDesc,
  Material,
  HigherLevelItem
FROM P_RevProdAllocChkPerdOrdItmGrp
;

Learn More