P_PRODALLOCQUANTITYASSIGNMENT

CDS View
11 Fields 6 CDS Views

Product Allocation Quantity Assignment

P_PRODALLOCQUANTITYASSIGNMENT is a CDS View in S/4HANA. Product Allocation Quantity Assignment. It contains 11 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
I_ProdAllocOvwOrderItemPerds view_entity from COMPOSITE Product Allocation Overview Order Item Periods
P_AllocQtyAssgmtOrdItmValCombn view_entity from COMPOSITE Allocation Quantity Assignment Order Item Value Combination
P_AllProdAllocQtyAssignment view_entity union_all COMPOSITE All Product Allocation Quantity Assignment
P_MntrProdAllocOrderItemPerds view from CONSUMPTION Monitor Product Allocation Order Item Periods
P_ProdAllocOvwOrderItem view_entity from CONSUMPTION ProdAllocOvwOrderItem
P_QtyAssgmtOrdItmValCombnRate view_entity from COMPOSITE Quantity Assignment Order Item Value Combination Rate

Fields (11)

KeyField CDS FieldsUsed in Views
KEY AssignmentSequenceNumberValue AssignmentSequenceNumberValue 1
KEY CharcValueCombinationUUID CharcValueCombinationUUID 2
KEY ConfirmationUTCDateTime ConfirmationUTCDateTime 1
KEY ProdAllocAssignedOrder ProdAllocAssignedOrder 2
KEY ProdAllocAssignedOrderItem ProdAllocAssignedOrderItem 2
KEY ProdAllocAssignedOrderType ProdAllocAssignedOrderType 2
KEY ProdAllocPerdStartUTCDateTime ProdAllocPerdStartUTCDateTime 1
_ProdAllocSequenceConstraint _ProdAllocSequenceConstraint 1
ProdAllocSqncConstraintUUID ProdAllocSqncConstraintUUID 1
ProdAllocSqncCstrtCnsmpnUnit ProdAllocSqncCstrtCnsmpnUnit 1
PurchaseOrderItem PurchaseOrderItem 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Product Allocation Quantity Assignment
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_PRODALLOCQUANTITYASSIGNMENT (
    ASSIGNMENTSEQUENCENUMBERVALUE,
    CHARCVALUECOMBINATIONUUID,
    CONFIRMATIONUTCDATETIME,
    PRODALLOCASSIGNEDORDER,
    PRODALLOCASSIGNEDORDERITEM,
    PRODALLOCASSIGNEDORDERTYPE,
    PRODALLOCPERDSTARTUTCDATETIME,
    _PRODALLOCSEQUENCECONSTRAINT,
    PRODALLOCSQNCCONSTRAINTUUID,
    PRODALLOCSQNCCSTRTCNSMPNUNIT,
    PURCHASEORDERITEM,
    PRIMARY KEY (ASSIGNMENTSEQUENCENUMBERVALUE, CHARCVALUECOMBINATIONUUID, CONFIRMATIONUTCDATETIME, PRODALLOCASSIGNEDORDER, PRODALLOCASSIGNEDORDERITEM, PRODALLOCASSIGNEDORDERTYPE, PRODALLOCPERDSTARTUTCDATETIME)
);

Learn More