I_PRODUCTIONORDOPBASIC

CDS View
8 Fields 6 CDS Views

Production Order Operation afvg

I_PRODUCTIONORDOPBASIC is a CDS View in S/4HANA. Production Order Operation afvg. It contains 8 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
P_MfgOrderWrkCtrHoldCount view_entity from CONSUMPTION
P_OrdFirstOper view_entity left_outer CONSUMPTION
P_OrdFirstOperAggr view_entity from CONSUMPTION
P_Ordlatestoper view_entity left_outer CONSUMPTION
P_OrdLatestOperAggr view_entity from CONSUMPTION
P_Ordoperaggr view_entity from CONSUMPTION

Fields (8)

KeyField CDS FieldsUsed in Views
KEY ManufacturingOrder ManufacturingOrder 3
KEY OrderInternalID OrderInternalBillOfOperations 3
ManufacturingOrderCategory ManufacturingOrderCategory 2
OperationText FirstOperationText,LatestOperationText 2
OperationUnit OperationUnit 2
OpPlannedTotalQuantity OpFirstPlannedTotalQty,OpLtstPlannedTotalQty 2
OpTotalConfirmedScrapQty OpLtstConfirmedScrapQty 1
OpTotalConfirmedYieldQty OpFirstConfirmedYieldQty,OpLtstConfirmedYieldQty 2

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.

-- Production Order Operation afvg
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PRODUCTIONORDOPBASIC (
    MANUFACTURINGORDER,
    ORDERINTERNALID,
    MANUFACTURINGORDERCATEGORY,
    OPERATIONTEXT,
    OPERATIONUNIT,
    OPPLANNEDTOTALQUANTITY,
    OPTOTALCONFIRMEDSCRAPQTY,
    OPTOTALCONFIRMEDYIELDQTY,
    PRIMARY KEY (MANUFACTURINGORDER, ORDERINTERNALID)
);

Learn More