P_QtyAssgmtOrdItmValCombnRate

DDL: P_QTYASSGMTORDITMVALCOMBNRATE Type: view_entity COMPOSITE Package: PROD_ALLOC_TRANSACTIONAL_DATA
7 Fields 1 Data Sources

Quantity Assignment Order Item Value Combination Rate

P_QtyAssgmtOrdItmValCombnRate is a Composite CDS View that provides data about "Quantity Assignment Order Item Value Combination Rate" in SAP S/4HANA. It reads from 1 data source (P_ProdAllocQuantityAssignment) and exposes 7 fields with key fields ProdAllocAssignedOrder, ProdAllocAssignedOrderItem, ProdAllocAssignedOrderType, CharcValueCombinationUUID, ProdAllocSqncCstrtCnsmpnUnit. Part of development package PROD_ALLOC_TRANSACTIONAL_DATA.

Data Sources (1)

SourceAliasJoin Type
P_ProdAllocQuantityAssignment P_ProdAllocQuantityAssignment from

Annotations (6)

NameValueLevelField
VDM.private true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (7)

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 ProdAllocSqncCstrtCnsmpnUnit ProdAllocSqncCstrtCnsmpnUnit Constraint Consumption Unit
KEY ProdAllocSqncConstraintUUID ProdAllocSqncConstraintUUID Product Allocation Sequence Constraint UUID
PurchaseOrderItem PurchaseOrderItem Purchasing Document 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 P_QtyAssgmtOrdItmValCombnRate.
-- 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 P_QtyAssgmtOrdItmValCombnRate AS
SELECT
  ProdAllocAssignedOrder,
  ProdAllocAssignedOrderItem,
  ProdAllocAssignedOrderType,
  CharcValueCombinationUUID,
  ProdAllocSqncCstrtCnsmpnUnit,
  ProdAllocSqncConstraintUUID,
  PurchaseOrderItem
FROM P_ProdAllocQuantityAssignment
;

Learn More