Which CDS Views use I_ORDERITEM?

I_ORDERITEM is used by 33 CDS view(s), including: C_MfgOpInPrgrsNoHoldNoMisgComp, C_MfgOpInProgressNotOnHold, C_MfgOpReldNoHoldNoMisgComp, C_MfgOrderObjPgOpr, C_ProcessOrderObjPgOpr, C_SchedProdnSalesDocumentVH, C_ShopFloorItem, I_EventBasedWIPLogHeader, I_ManufacturingOrder, I_ManufacturingOrderItem.

How many fields does I_ORDERITEM have?

I_ORDERITEM has 110 fields. Key fields: Material, MRPPlant, OrderID, OrderItem, StorageLocation.

I_ORDERITEM

CDS View

110 Fields 33 CDS Views

Order Item

I_ORDERITEM is a CDS View in S/4HANA. Order Item. It contains 110 fields. 33 CDS views read from this table.

CDS Views using this table (33)

View	Type	Join	VDM	Description
C_MfgOpInPrgrsNoHoldNoMisgComp	view_entity	inner	CONSUMPTION	Operation In Progress without Hold and missing Components
C_MfgOpInProgressNotOnHold	view_entity	inner	CONSUMPTION	Operation In Progress not on Hold
C_MfgOpReldNoHoldNoMisgComp	view_entity	inner	CONSUMPTION	Not started Oper wo Hold and misg Comps
C_MfgOrderObjPgOpr	view	inner	CONSUMPTION	Manufacturing Order Opr : Object Page
C_ProcessOrderObjPgOpr	view_entity	inner	CONSUMPTION	Manufacturing Order Opr : Object Page
C_SchedProdnSalesDocumentVH	view	inner	CONSUMPTION	Sales Document
C_ShopFloorItem	view	inner	CONSUMPTION	Serial Number
I_EventBasedWIPLogHeader	view	left_outer	BASIC	Event-Based WIP Order Application Log Header
I_ManufacturingOrder	view	inner	BASIC	Manufacturing Order
I_ManufacturingOrderItem	view	from	BASIC	Manufacturing Order Item
I_MfgExecEventHistory	view	inner	COMPOSITE	Manufacturing Execution Event History
I_MfgOrder	view	inner	BASIC	Manufacturing Order
I_MfgOrderBasicFilter	view_entity	inner	COMPOSITE	Manufacturing Order
I_MfgOrderItem	view	from	BASIC	Manufacturing Order Item
I_MfgOrderItemLongText	view_entity	inner	COMPOSITE	Manufacturing Order Item - Text
I_MfgOrderOperationConfCube	view	inner	COMPOSITE	Manufacturing Order Operation Confirmation - Cube
I_MfgOrderOperationConfOper	view	inner	COMPOSITE	Mfg Order Operation Confirmation with Operation Details
I_MfgOrderOperationDurnCube	view	inner	COMPOSITE	Manufacturing Order Operation Duration - Cube
I_MfgOrderOperationForConf	view	inner	COMPOSITE	Mfg Order Operation for Confirmation
I_MfgOrderPickList	view	left_outer	COMPOSITE	Mfg Order Header (Pick List)
I_MRPMfgOrderItem	view	from	COMPOSITE	MRP Manufacturing Order Item
I_ProdCmplncLicRlvtProdnDocs	view	from	COMPOSITE	License Relevant Production Order Items
I_ProductionOrderItem	view_entity	from	BASIC	Production Order Item
I_RealTimeMfgOrderLog	view	left_outer	BASIC	Analyze Event-Based WIP and Variance Exceptions Log
I_RFM_MasterOrderVH	view_entity	from	BASIC	Master Order Search Help
MMIMProductionOrderVH	view	from		Value Help for Production Plants
P_DDOrderDetails	view	union_all	CONSUMPTION
P_MfgOrderItemCost	view_entity	from	COMPOSITE
P_MfgOrderItemGRBatch	view_entity	inner	COMPOSITE
P_MfgProcgExecOperation	view	inner	CONSUMPTION
P_OpActyAffectedByProdnHold	view	inner	COMPOSITE
P_OperationAffectedByProdnHold	view_entity	inner	COMPOSITE
P_OrderItemCategoryObj	view	inner	COMPOSITE

Fields (110)

Key	Field	CDS Fields	Used in Views
KEY	Material	Article,Material	18
KEY	MRPPlant	MRPPlant,PlanningPlant,Plant	11
KEY	OrderID	ManufacturingOrder,OrderID	7
KEY	OrderItem	ManufacturingOrderItem,OrderItem	5
KEY	StorageLocation	PlannedStorageLocation,StorageLocation	9
	_AccountAssignmentCategory	_AccountAssignmentCategory	3
	_BaseUnit	_BaseUnit	3
	_Batch	_Batch	1
	_BusinessArea	_BusinessArea	3
	_ConsumptionPosting	_ConsumptionPosting	3
	_CoProductReservation	_CoProductReservation	3
	_CoProductReservationItem	_CoProductReservationItem	3
	_DeliveryCompletedIndicator	_DeliveryCompletedIndicator	2
	_InventorySpecialStockType	_InventorySpecialStockType	4
	_InventorySpecialStockValnType	_InventorySpecialStockValnType	3
	_InventoryUsabilityCode	_InventoryUsabilityCode	4
	_InventoryValuationType	_InventoryValuationType	3
	_Material	_Material	10
	_MatlProcurementCategory	_MatlProcurementCategory	2
	_MatlProcurementType	_MatlProcurementType	2
	_MRPArea	_MRPArea	5
	_MRPPlant	_MRPPlant,_PlanningPlant	7
	_Order	_Order	2
	_OrderCategory	_OrderCategory	2
	_OrderType	_OrderType	2
	_PlannedOrder	_PlannedOrder	4
	_Product	_Product	1
	_ProductionPlant	_ProductionPlant	6
	_ProductionUnit	_ProductionUnit	6
	_ProductionVersion	_ProductionVersion	4
	_QuotaArrangement	_QuotaArrangement	3
	_QuotaArrangementItem	_QuotaArrangementItem	3
	_SalesOrder	_SalesOrder	5
	_SalesOrderItem	_SalesOrderItem	5
	_SalesOrderScheduleLine	_SalesOrderScheduleLine	2
	_SerialNumberProfile	_SerialNumberProfile	3
	_SettlementReservation	_SettlementReservation	4
	_SettlementReservationItem	_SettlementReservationItem	3
	_StorageLocation	_StorageLocation	4
	_WBSElement	_WBSElement	3
	_WBSElementBasicData	_WBSElementBasicData	1
	_WBSElementBasicData2	_WBSElementBasicData,_WBSElementBasicData2	4
	AccountAssignmentCategory	AccountAssignmentCategory	3
	ActualDeliveryDate	ActualDeliveryDate,MfgOrderItemActualDeliveryDate	7
	BaseUnit	BaseUnit	6
	Batch	Batch,PlannedBatch	9
	BusinessArea	BusinessArea	3
	ConsumptionPosting	ConsumptionPosting	4
	CoProductReservation	CoProductReservation	3
	CoProductReservationItem	CoProductReservationItem	2
	EffectivityParameterVariant	EffectivityParameterVariant	8
	GoodsReceiptAmountInCoCodeCrcy	GoodsReceiptAmountInCoCodeCrcy	2
	GoodsReceiptIsExpected	GoodsReceiptIsExpected,MfgOrderItemGdsRcptIsAllowed	3
	GoodsReceiptIsNonValuated	GoodsReceiptIsNonValuated,MfgOrderItemGdsRcptIsNonVltd	3
	GoodsRecipientName	GoodsRecipientName	4
	InventorySpecialStockType	InventorySpecialStockType	4
	InventorySpecialStockValnType	InventorySpecialStockValnType	3
	InventoryUsabilityCode	InventoryUsabilityCode	4
	InventoryValuationCategory	InventoryValuationCategory	3
	InventoryValuationType	InventoryValuationType	3
	IsCompletelyDelivered	IsCompletelyDelivered,MfgOrderItemIsFinallyDelivered	9
	IsMarkedForDeletion	IsMarkedForDeletion,MfgOrderIsToBeDeleted	3
	ItemQuantity	ItemQuantity,PlannedTotalQty	2
	MaterialGoodsReceiptDuration	MaterialGoodsReceiptDuration	6
	MaterialProcurementCategory	MaterialProcurementCategory	2
	MaterialProcurementType	MaterialProcurementType	2
	MaterialQtyToBaseQtyDnmntr	MfgOrderItemQtyToBaseQtyDnmntr	1
	MaterialQtyToBaseQtyNmrtr	MfgOrderItemQtyToBaseQtyNmrtr	1
	MfgOrderItemActualDeviationQty	MfgOrderItemActualDeviationQty	1
	MfgOrderItemGoodsReceiptQty	ActualDeliveredQuantity,DeliveredQuantity,MfgOrderItemGoodsReceiptQty	5
	MfgOrderItemPlannedScrapQty	MfgOrderItemPlannedScrapQty	1
	MfgOrderItemReplnmtElmntType	MfgOrderItemReplnmtElmntType,ReplenishmentElementType	3
	MRPArea	MRPArea	7
	NumberOfSerialNumbers	NumberOfSerialNumbers	4
	ObjectInternalID	ObjectInternalID	3
	OrderCategory	OrderCategory	4
	OrderIsReleased	OrderIsReleased	1
	OrderItemIsNotRelevantForMRP	OrderItemIsNotRelevantForMRP	2
	OrderPlannedScrapQty	PlndOrderPlannedScrapQty	1
	OrderPlannedTotalQty	OrderPlannedTotalQty,PlndOrderPlannedTotalQty,TotalQuantity	3
	OrderType	OrderType	3
	OriginalEffctyParameterVariant	OriginalEffctyParameterVariant	2
	OverdelivTolrtdLmtRatioInPct	MfgOrderItemAllowedOverdelyPct,OverdelivTolrtdLmtRatioInPct	3
	PlannedDeliveryDate	MfgOrderItemPlndDeliveryDate,PlannedOrderPlannedDeliveryDte	3
	PlannedEndDate	DeliveryDate,PlannedEndDate	2
	PlannedOrder	PlannedOrder	6
	PlannedOrderOpeningDate	OpeningDate,PlannedOrderOpeningDate	2
	PlndOrderPlannedStartDate	PlndOrderPlannedStartDate,ReleaseDate	2
	ProductCollection	ProductCollection	3
	ProductConfiguration	ProductConfiguration	1
	ProductionPlant	ProductionPlant	7
	ProductionUnit	ProductionUnit	7
	ProductionVersion	ProductionVersion	7
	ProductSeason	ProductSeason	3
	ProductSeasonYear	ProductSeasonYear	3
	ProductTheme	ProductTheme	3
	QuantityDistributionKey	QuantityDistributionKey	4
	SalesOrder	SalesOrder	9
	SalesOrderItem	SalesOrderItem	9
	SalesOrderScheduleLine	SalesOrderScheduleLine	2
	SerialNumberAssgmtProfile	SerialNumberAssgmtProfile	3
	SettlementReservation	SettlementReservation	4
	SettlementReservationItem	SettlementReservationItem	3
	StockSegment	StockSegment	4
	TotalCommitmentDate	MfgOrderItemTotalCmtmtDate,MfgOrderTotalCommitmentDate,TotalCommitmentDate	4
	UnderdelivTolrtdLmtRatioInPct	MfgOrderItmAllowedUnderdelyPct,UnderdelivTolrtdLmtRatioInPct	3
	UnlimitedOverdeliveryIsAllowed	MfgOrdItmHasUnlmtdOverdelivery,UnlimitedOverdeliveryIsAllowed	3
	UnloadingPointName	UnloadingPointName	4
	WBSElementInternalID	WBSElementInternalID	4
	WBSElementInternalID_2	WBSElementInternalID,WBSElementInternalID_2	4

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.

-- Order Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_ORDERITEM (
    MATERIAL,
    MRPPLANT,
    ORDERID,
    ORDERITEM,
    STORAGELOCATION,
    _ACCOUNTASSIGNMENTCATEGORY,
    _BASEUNIT,
    _BATCH,
    _BUSINESSAREA,
    _CONSUMPTIONPOSTING,
    _COPRODUCTRESERVATION,
    _COPRODUCTRESERVATIONITEM,
    _DELIVERYCOMPLETEDINDICATOR,
    _INVENTORYSPECIALSTOCKTYPE,
    _INVENTORYSPECIALSTOCKVALNTYPE,
    _INVENTORYUSABILITYCODE,
    _INVENTORYVALUATIONTYPE,
    _MATERIAL,
    _MATLPROCUREMENTCATEGORY,
    _MATLPROCUREMENTTYPE,
    _MRPAREA,
    _MRPPLANT,
    _ORDER,
    _ORDERCATEGORY,
    _ORDERTYPE,
    _PLANNEDORDER,
    _PRODUCT,
    _PRODUCTIONPLANT,
    _PRODUCTIONUNIT,
    _PRODUCTIONVERSION,
    _QUOTAARRANGEMENT,
    _QUOTAARRANGEMENTITEM,
    _SALESORDER,
    _SALESORDERITEM,
    _SALESORDERSCHEDULELINE,
    _SERIALNUMBERPROFILE,
    _SETTLEMENTRESERVATION,
    _SETTLEMENTRESERVATIONITEM,
    _STORAGELOCATION,
    _WBSELEMENT,
    _WBSELEMENTBASICDATA,
    _WBSELEMENTBASICDATA2,
    ACCOUNTASSIGNMENTCATEGORY,
    ACTUALDELIVERYDATE,
    BASEUNIT,
    BATCH,
    BUSINESSAREA,
    CONSUMPTIONPOSTING,
    COPRODUCTRESERVATION,
    COPRODUCTRESERVATIONITEM,
    EFFECTIVITYPARAMETERVARIANT,
    GOODSRECEIPTAMOUNTINCOCODECRCY,
    GOODSRECEIPTISEXPECTED,
    GOODSRECEIPTISNONVALUATED,
    GOODSRECIPIENTNAME,
    INVENTORYSPECIALSTOCKTYPE,
    INVENTORYSPECIALSTOCKVALNTYPE,
    INVENTORYUSABILITYCODE,
    INVENTORYVALUATIONCATEGORY,
    INVENTORYVALUATIONTYPE,
    ISCOMPLETELYDELIVERED,
    ISMARKEDFORDELETION,
    ITEMQUANTITY,
    MATERIALGOODSRECEIPTDURATION,
    MATERIALPROCUREMENTCATEGORY,
    MATERIALPROCUREMENTTYPE,
    MATERIALQTYTOBASEQTYDNMNTR,
    MATERIALQTYTOBASEQTYNMRTR,
    MFGORDERITEMACTUALDEVIATIONQTY,
    MFGORDERITEMGOODSRECEIPTQTY,
    MFGORDERITEMPLANNEDSCRAPQTY,
    MFGORDERITEMREPLNMTELMNTTYPE,
    MRPAREA,
    NUMBEROFSERIALNUMBERS,
    OBJECTINTERNALID,
    ORDERCATEGORY,
    ORDERISRELEASED,
    ORDERITEMISNOTRELEVANTFORMRP,
    ORDERPLANNEDSCRAPQTY,
    ORDERPLANNEDTOTALQTY,
    ORDERTYPE,
    ORIGINALEFFCTYPARAMETERVARIANT,
    OVERDELIVTOLRTDLMTRATIOINPCT,
    PLANNEDDELIVERYDATE,
    PLANNEDENDDATE,
    PLANNEDORDER,
    PLANNEDORDEROPENINGDATE,
    PLNDORDERPLANNEDSTARTDATE,
    PRODUCTCOLLECTION,
    PRODUCTCONFIGURATION,
    PRODUCTIONPLANT,
    PRODUCTIONUNIT,
    PRODUCTIONVERSION,
    PRODUCTSEASON,
    PRODUCTSEASONYEAR,
    PRODUCTTHEME,
    QUANTITYDISTRIBUTIONKEY,
    SALESORDER,
    SALESORDERITEM,
    SALESORDERSCHEDULELINE,
    SERIALNUMBERASSGMTPROFILE,
    SETTLEMENTRESERVATION,
    SETTLEMENTRESERVATIONITEM,
    STOCKSEGMENT,
    TOTALCOMMITMENTDATE,
    UNDERDELIVTOLRTDLMTRATIOINPCT,
    UNLIMITEDOVERDELIVERYISALLOWED,
    UNLOADINGPOINTNAME,
    WBSELEMENTINTERNALID,
    WBSELEMENTINTERNALID_2,
    PRIMARY KEY (MATERIAL, MRPPLANT, ORDERID, ORDERITEM, STORAGELOCATION)
);

Depth:

I_ORDERITEM

CDS Views using this table (33)

Fields (110)

Learn More