I_MFGORDERITEMAMOUNT

CDS View
63 Fields 1 CDS Views

Manufacturing Order Item Amount

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_MfgOrderItemAmountCube view from COMPOSITE Manufacturing Order Item Amount - Cube

Fields (63)

KeyField CDS FieldsUsed in Views
KEY ManufacturingOrder ManufacturingOrder 1
KEY ManufacturingOrderItem ManufacturingOrderItem 1
_BaseUnit _BaseUnit 1
_CompanyCodeCurrency _CompanyCodeCurrency 1
_InventoryValuationType _InventoryValuationType 1
_MfgOrderCategory _MfgOrderCategory 1
_MfgOrderType _MfgOrderType 1
_MRPController _MRPController 1
_MRPPlant _MRPPlant 1
_Product _Product 1
_ProductionPlant _ProductionPlant 1
_ProductionSupervisor _ProductionSupervisor 1
_ProductionUnit _ManufacturingOrderUnit 1
_StorageLocation _StorageLocation 1
_ValuationArea _ValuationArea 1
BaseUnit BaseUnit 1
Batch Batch 1
BusinessArea BusinessArea 1
CompanyCodeCurrency CompanyCodeCurrency 1
CostEstimate CostEstimate 1
FiscalPeriod FiscalPeriod 1
FiscalYear FiscalYear_2 1
InventoryPrice InventoryPrice 1
InventoryValuationType InventoryValuationType 1
ManufacturingOrderCategory ManufacturingOrderCategory 1
ManufacturingOrderType ManufacturingOrderType 1
MaterialGoodsReceiptDuration MaterialGoodsReceiptDuration 1
MaterialPriceUnitQty MaterialPriceUnitQty 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
MRPController MRPController 1
MRPPlant MRPPlant 1
ProductionPlant ProductionPlant 1
ProductionSupervisor ProductionSupervisor 1
ProductionUnit ManufacturingOrderUnit 1
StorageLocation StorageLocation 1
ValuationArea ValuationArea 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 I_MFGORDERITEMAMOUNT (
    MANUFACTURINGORDER,
    MANUFACTURINGORDERITEM,
    _BASEUNIT,
    _COMPANYCODECURRENCY,
    _INVENTORYVALUATIONTYPE,
    _MFGORDERCATEGORY,
    _MFGORDERTYPE,
    _MRPCONTROLLER,
    _MRPPLANT,
    _PRODUCT,
    _PRODUCTIONPLANT,
    _PRODUCTIONSUPERVISOR,
    _PRODUCTIONUNIT,
    _STORAGELOCATION,
    _VALUATIONAREA,
    BASEUNIT,
    BATCH,
    BUSINESSAREA,
    COMPANYCODECURRENCY,
    COSTESTIMATE,
    FISCALPERIOD,
    FISCALYEAR,
    INVENTORYPRICE,
    INVENTORYVALUATIONTYPE,
    MANUFACTURINGORDERCATEGORY,
    MANUFACTURINGORDERTYPE,
    MATERIALGOODSRECEIPTDURATION,
    MATERIALPRICEUNITQTY,
    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,
    MRPCONTROLLER,
    MRPPLANT,
    PRODUCTIONPLANT,
    PRODUCTIONSUPERVISOR,
    PRODUCTIONUNIT,
    STORAGELOCATION,
    VALUATIONAREA,
    PRIMARY KEY (MANUFACTURINGORDER, MANUFACTURINGORDERITEM)
);

Learn More