P_PRODORDMGMTOPBASIC

CDS View

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ProductionOrdOpBasic view_entity from BASIC Production Order Operation afvg

Fields (41)

KeyField CDS FieldsUsed in Views
KEY aplzl OrderOperationInternalID 1
KEY aufpl OrderInternalID 1
aplfl Sequence 1
arbid WorkCenterInternalID 1
asvrg OpPlannedScrapQuantity 1
fsedd OpErlstSchedldExecEndDte 1
fsedz OpErlstSchedldExecEndTme 1
iedd OpActualExecutionEndDate 1
iedz OpActualExecutionEndTime 1
isdd OpActualExecutionStartDate 1
isdz OpActualExecutionStartTime 1
istkn BillOfMaterialItemNodeNumber 1
istnr BillOfMaterialInternalID 1
istpo BOMItemNodeCount 1
istty BillOfMaterialCategory 1
lmnga OpTotalConfirmedYieldQty 1
ltxa1 OperationText 1
ManufacturingOrder ManufacturingOrder 1
ManufacturingOrderCategory ManufacturingOrderCategory 1
meinh OperationUnit 1
mgvrg OpPlannedTotalQuantity 1
objnr ObjectInternalID 1
phflg MfgOrderOperationIsPhase 1
plnal BillOfOperationsVariant 1
plnfl BillOfOperationsSequence 1
plnkn BOOOperationInternalID 1
plnnr BillOfOperationsGroup 1
plnty BillOfOperationsType 1
ProductionPlant ProductionPlant 1
ProductionSupervisor ProductionSupervisor 1
pvzkn OrderIntBillOfOpItemOfPhase 1
ssavd OpLtstSchedldExecStrtDte 1
ssavz OpLtstSchedldExecStrtTme 1
ssedd OpLtstSchedldExecEndDte 1
ssedz OpLtstSchedldExecEndTme 1
sumnr SuperiorOperationInternalID 1
tl_versn BillOfOperationsVersion 1
txtsp Language 1
vornr Operation 1
werks Plant 1
xmnga OpTotalConfirmedScrapQty 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_PRODORDMGMTOPBASIC (
    APLZL,
    AUFPL,
    APLFL,
    ARBID,
    ASVRG,
    FSEDD,
    FSEDZ,
    IEDD,
    IEDZ,
    ISDD,
    ISDZ,
    ISTKN,
    ISTNR,
    ISTPO,
    ISTTY,
    LMNGA,
    LTXA1,
    MANUFACTURINGORDER,
    MANUFACTURINGORDERCATEGORY,
    MEINH,
    MGVRG,
    OBJNR,
    PHFLG,
    PLNAL,
    PLNFL,
    PLNKN,
    PLNNR,
    PLNTY,
    PRODUCTIONPLANT,
    PRODUCTIONSUPERVISOR,
    PVZKN,
    SSAVD,
    SSAVZ,
    SSEDD,
    SSEDZ,
    SUMNR,
    TL_VERSN,
    TXTSP,
    VORNR,
    WERKS,
    XMNGA,
    PRIMARY KEY (APLZL, AUFPL)
);