P_PRODALLOCPERDSVALCOMBNORDITM

CDS View

P_PRODALLOCPERDSVALCOMBNORDITM is a CDS View in S/4HANA. It contains 13 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_VrtlProdAllocQtyAssignment view_entity from COMPOSITE

Fields (13)

KeyField CDS FieldsUsed in Views
KEY CharcValueCombinationUUID CharcValueCombinationUUID 1
KEY ProdAllocAssignedOrder ProdAllocAssignedOrder 1
KEY ProdAllocAssignedOrderItem ProdAllocAssignedOrderItem 1
KEY ProdAllocAssignedOrderType ProdAllocAssignedOrderType 1
KEY ProdAllocPerdStartUTCDateTime ProdAllocPerdStartUTCDateTime 1
ProdAllocAssignedQuantity ProdAllocAssignedQuantity 1
ProdAllocAssignedQuantityUnit ProdAllocAssignedQuantityUnit 1
ProdAllocPeriodEndTimeZone ProdAllocPeriodEndTimeZone 1
ProdAllocPeriodEndUTCDateTime ProdAllocPeriodEndUTCDateTime 1
ProdAllocPeriodStartTimeZone ProdAllocPeriodStartTimeZone 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_PRODALLOCPERDSVALCOMBNORDITM (
    CHARCVALUECOMBINATIONUUID,
    PRODALLOCASSIGNEDORDER,
    PRODALLOCASSIGNEDORDERITEM,
    PRODALLOCASSIGNEDORDERTYPE,
    PRODALLOCPERDSTARTUTCDATETIME,
    PRODALLOCASSIGNEDQUANTITY,
    PRODALLOCASSIGNEDQUANTITYUNIT,
    PRODALLOCPERIODENDTIMEZONE,
    PRODALLOCPERIODENDUTCDATETIME,
    PRODALLOCPERIODSTARTTIMEZONE,
    PRODALLOCSQNCCONSTRAINTUUID,
    PRODALLOCSQNCCSTRTCNSMPNUNIT,
    PURCHASEORDERITEM,
    PRIMARY KEY (CHARCVALUECOMBINATIONUUID, PRODALLOCASSIGNEDORDER, PRODALLOCASSIGNEDORDERITEM, PRODALLOCASSIGNEDORDERTYPE, PRODALLOCPERDSTARTUTCDATETIME)
);