I_PRODALLOCQUANTITYASSIGNMENT

CDS View
11 Fields 7 CDS Views

Product Allocation Quantity Assignment

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

CDS Views using this table (7)

ViewTypeJoinVDMDescription
I_ProdAllocQtyNoTmeSersOvw view from COMPOSITE Quantity Assignment Overview without Time Series
I_ProdAllocTmeSersAssignedQty view_entity from COMPOSITE Product Allocation Time Series Assigned Quantity
P_MntrAllocQtyAssgmtNoTmeSers view from COMPOSITE
P_MntrProdAllocQtyAssgmt view left_outer COMPOSITE
P_ProdAllocAgingData view left_outer COMPOSITE
P_ProdAllocQuantityAssignment view from COMPOSITE
P_RevProdAllocChkPerdOrdItm view from TRANSACTIONAL

Fields (11)

KeyField CDS FieldsUsed in Views
KEY CharcValueCombinationUUID CharcValueCombinationUUID 3
KEY ProdAllocAssignedOrderType ProdAllocAssignedOrderType 2
KEY ProdAllocPerdStartUTCDateTime ProdAllocPerdStartUTCDateTime 4
KEY ProdAllocSqncConstraintUUID ProdAllocSqncConstraintUUID 1
AssignmentSequenceNumberValue AssignmentSequenceNumberValue 1
ConfirmationUTCDateTime ConfirmationUTCDateTime 1
ProdAllocAssignedOrder ProdAllocAssignedOrder 1
ProdAllocAssignedOrderItem ProdAllocAssignedOrderItem 1
ProdAllocAssignedQuantity ProdAllocAssignedQuantity 1
ProdAllocAssignedQuantityUnit ProdAllocAssignedQuantityUnit,ProductAllocationQuantityUnit 3
ProdAllocPeriodStartTimeZone ProdAllocPeriodStartTimeZone 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 I_PRODALLOCQUANTITYASSIGNMENT (
    CHARCVALUECOMBINATIONUUID,
    PRODALLOCASSIGNEDORDERTYPE,
    PRODALLOCPERDSTARTUTCDATETIME,
    PRODALLOCSQNCCONSTRAINTUUID,
    ASSIGNMENTSEQUENCENUMBERVALUE,
    CONFIRMATIONUTCDATETIME,
    PRODALLOCASSIGNEDORDER,
    PRODALLOCASSIGNEDORDERITEM,
    PRODALLOCASSIGNEDQUANTITY,
    PRODALLOCASSIGNEDQUANTITYUNIT,
    PRODALLOCPERIODSTARTTIMEZONE,
    PRIMARY KEY (CHARCVALUECOMBINATIONUUID, PRODALLOCASSIGNEDORDERTYPE, PRODALLOCPERDSTARTUTCDATETIME, PRODALLOCSQNCCONSTRAINTUUID)
);

Learn More