P_MFGORDERITEMAMOUNT

CDS View
66 Fields 1 CDS Views

Manufacturing Order Item Amount

P_MFGORDERITEMAMOUNT is a CDS View in S/4HANA. Manufacturing Order Item Amount. It contains 66 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_MfgOrderItemAmount view from COMPOSITE Manufacturing Order Item Amount

Fields (66)

KeyField CDS FieldsUsed in Views
KEY ManufacturingOrder ManufacturingOrder 1
_BaseUnit _BaseUnit 1
_BusinessArea _BusinessArea 1
_DeliveryCompletedIndicator _DeliveryCompletedIndicator 1
_InventoryValuationType _InventoryValuationType 1
_Material _Material 1
_MfgOrderCategory _MfgOrderCategory 1
_MfgOrderType _MfgOrderType 1
_MRPArea _MRPArea 1
_MRPPlant _MRPPlant 1
_ProductionPlant _ProductionPlant 1
_ProductionSupervisor _ProductionSupervisor 1
_ProductionUnit _ProductionUnit 1
_ProductionVersion _ProductionVersion 1
_SalesOrder _SalesOrder 1
_SalesOrderItem _SalesOrderItem 1
_StorageLocation _StorageLocation 1
BaseUnit BaseUnit 1
Batch Batch 1
BusinessArea BusinessArea 1
GoodsRecipientName GoodsRecipientName 1
InventoryValuationType InventoryValuationType 1
ManufacturingOrderCategory ManufacturingOrderCategory 1
ManufacturingOrderType ManufacturingOrderType 1
Material Material 1
MaterialGoodsReceiptDuration MaterialGoodsReceiptDuration 1
MfgOrderActualEndDate MfgOrderActualEndDate 1
MfgOrderActualReleaseDate MfgOrderActualReleaseDate 1
MfgOrderActualStartDate MfgOrderActualStartDate 1
MfgOrderActualStartTime MfgOrderActualStartTime 1
MfgOrderConfirmedEndDate MfgOrderConfirmedEndDate 1
MfgOrderConfirmedEndTime MfgOrderConfirmedEndTime 1
MfgOrderConfirmedReworkQty MfgOrderConfirmedReworkQty 1
MfgOrderConfirmedScrapQty MfgOrderConfirmedScrapQty 1
MfgOrderConfirmedTotalQty MfgOrderConfirmedTotalQty 1
MfgOrderConfirmedYieldQty MfgOrderConfirmedYieldQty 1
MfgOrderItemActualDeliveryDate MfgOrderItemActualDeliveryDate 1
MfgOrderItemActualDeviationQty MfgOrderItemActualDeviationQty 1
MfgOrderItemGoodsReceiptQty MfgOrderItemGoodsReceiptQty 1
MfgOrderItemIsFinallyDelivered MfgOrderItemIsFinallyDelivered 1
MfgOrderItemPlannedEndDate MfgOrderItemPlannedEndDate 1
MfgOrderItemPlannedScrapQty MfgOrderItemPlannedScrapQty 1
MfgOrderItemPlannedTotalQty MfgOrderItemPlannedTotalQty 1
MfgOrderItemPlannedYieldQty MfgOrderItemPlannedYieldQty 1
MfgOrderItemScheduledEndDate MfgOrderItemScheduledEndDate 1
MfgOrderPlannedEndDate MfgOrderPlannedEndDate 1
MfgOrderPlannedEndTime MfgOrderPlannedEndTime 1
MfgOrderPlannedStartDate MfgOrderPlannedStartDate 1
MfgOrderPlannedStartTime MfgOrderPlannedStartTime 1
MfgOrderScheduledEndDate MfgOrderScheduledEndDate 1
MfgOrderScheduledEndTime MfgOrderScheduledEndTime 1
MfgOrderScheduledReleaseDate MfgOrderScheduledReleaseDate 1
MfgOrderScheduledStartDate MfgOrderScheduledStartDate 1
MfgOrderScheduledStartTime MfgOrderScheduledStartTime 1
MRPArea MRPArea 1
MRPController MRPController 1
MRPPlant MRPPlant 1
ProductionPlant ProductionPlant 1
ProductionSupervisor ProductionSupervisor 1
ProductionUnit ProductionUnit 1
ProductionVersion ProductionVersion 1
SalesOrder SalesOrder 1
SalesOrderItem SalesOrderItem 1
StorageLocation StorageLocation 1
UnloadingPointName UnloadingPointName 1
WBSElementInternalID_2 WBSElementInternalID 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.

-- Manufacturing Order Item Amount
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_MFGORDERITEMAMOUNT (
    MANUFACTURINGORDER,
    _BASEUNIT,
    _BUSINESSAREA,
    _DELIVERYCOMPLETEDINDICATOR,
    _INVENTORYVALUATIONTYPE,
    _MATERIAL,
    _MFGORDERCATEGORY,
    _MFGORDERTYPE,
    _MRPAREA,
    _MRPPLANT,
    _PRODUCTIONPLANT,
    _PRODUCTIONSUPERVISOR,
    _PRODUCTIONUNIT,
    _PRODUCTIONVERSION,
    _SALESORDER,
    _SALESORDERITEM,
    _STORAGELOCATION,
    BASEUNIT,
    BATCH,
    BUSINESSAREA,
    GOODSRECIPIENTNAME,
    INVENTORYVALUATIONTYPE,
    MANUFACTURINGORDERCATEGORY,
    MANUFACTURINGORDERTYPE,
    MATERIAL,
    MATERIALGOODSRECEIPTDURATION,
    MFGORDERACTUALENDDATE,
    MFGORDERACTUALRELEASEDATE,
    MFGORDERACTUALSTARTDATE,
    MFGORDERACTUALSTARTTIME,
    MFGORDERCONFIRMEDENDDATE,
    MFGORDERCONFIRMEDENDTIME,
    MFGORDERCONFIRMEDREWORKQTY,
    MFGORDERCONFIRMEDSCRAPQTY,
    MFGORDERCONFIRMEDTOTALQTY,
    MFGORDERCONFIRMEDYIELDQTY,
    MFGORDERITEMACTUALDELIVERYDATE,
    MFGORDERITEMACTUALDEVIATIONQTY,
    MFGORDERITEMGOODSRECEIPTQTY,
    MFGORDERITEMISFINALLYDELIVERED,
    MFGORDERITEMPLANNEDENDDATE,
    MFGORDERITEMPLANNEDSCRAPQTY,
    MFGORDERITEMPLANNEDTOTALQTY,
    MFGORDERITEMPLANNEDYIELDQTY,
    MFGORDERITEMSCHEDULEDENDDATE,
    MFGORDERPLANNEDENDDATE,
    MFGORDERPLANNEDENDTIME,
    MFGORDERPLANNEDSTARTDATE,
    MFGORDERPLANNEDSTARTTIME,
    MFGORDERSCHEDULEDENDDATE,
    MFGORDERSCHEDULEDENDTIME,
    MFGORDERSCHEDULEDRELEASEDATE,
    MFGORDERSCHEDULEDSTARTDATE,
    MFGORDERSCHEDULEDSTARTTIME,
    MRPAREA,
    MRPCONTROLLER,
    MRPPLANT,
    PRODUCTIONPLANT,
    PRODUCTIONSUPERVISOR,
    PRODUCTIONUNIT,
    PRODUCTIONVERSION,
    SALESORDER,
    SALESORDERITEM,
    STORAGELOCATION,
    UNLOADINGPOINTNAME,
    WBSELEMENTINTERNALID_2,
    PRIMARY KEY (MANUFACTURINGORDER)
);

Learn More