P_SCHEDORDEXTDDETS

CDS View
17 Fields 1 CDS Views

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_SchedProdnDispatchOrderDets view from COMPOSITE

Fields (17)

KeyField CDS FieldsUsed in Views
KEY CapacityRequirementItem CapacityRequirementItem 1
KEY CapacityRqmtItemCapacity CapacityRqmtItemCapacity 1
KEY OrderCategory OrderCategory 1
KEY OrderID OrderID 1
BaseUnit BaseUnit 1
CapacityRequirement CapacityRequirement 1
LastChangeDateTime LastChangeDateTime 1
ManufacturingOrder ManufacturingOrder 1
Material Material 1
OperationSetupGroup OperationSetupGroup 1
OperationSetupGroupCategory OperationSetupGroupCategory 1
OrderPlannedTotalQty OrderPlannedTotalQty 1
PlannedOrder PlannedOrder 1
Plant Plant 1
ProductionVersion ProductionVersion 1
SchedldOrdEndDteTme ReceiptDate,SchedldOrdEndDteTme 1
SchedldOrdStartDteTme SchedldOrdStartDteTme 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_SCHEDORDEXTDDETS (
    CAPACITYREQUIREMENTITEM,
    CAPACITYRQMTITEMCAPACITY,
    ORDERCATEGORY,
    ORDERID,
    BASEUNIT,
    CAPACITYREQUIREMENT,
    LASTCHANGEDATETIME,
    MANUFACTURINGORDER,
    MATERIAL,
    OPERATIONSETUPGROUP,
    OPERATIONSETUPGROUPCATEGORY,
    ORDERPLANNEDTOTALQTY,
    PLANNEDORDER,
    PLANT,
    PRODUCTIONVERSION,
    SCHEDLDORDENDDTETME,
    SCHEDLDORDSTARTDTETME,
    PRIMARY KEY (CAPACITYREQUIREMENTITEM, CAPACITYRQMTITEMCAPACITY, ORDERCATEGORY, ORDERID)
);

Learn More