I_PLANNEDORDER

CDS View
62 Fields 28 CDS Views

Planned Order

I_PLANNEDORDER is a CDS View in S/4HANA. Planned Order. It contains 62 fields. 28 CDS views read from this table.

CDS Views using this table (28)

ViewTypeJoinVDMDescription
A_PlannedOrder view from COMPOSITE Planned Order
C_BSOrdProcFlwPlndOrd view from CONSUMPTION MTO Planned Order Attribute
C_ConvertPlannedOrder view from CONSUMPTION Convert Planned Orders
C_JITPlannedOrderVH view from CONSUMPTION Value help for Planned Order
C_PlannedOrderObjPg view from CONSUMPTION Planned Order Object Page
C_PlannedOrders view from CONSUMPTION Manage Planned Orders
C_PlannedOrderTP view_entity from CONSUMPTION Manage Planned Orders
ESH_N_PLANNEDORDER view from
I_ARunSupSelRulePlndOrdVH view from BASIC
I_JITOutbRtgRptgPt view inner COMPOSITE Routing Reporting Point
I_MRPPlannedOrder view from COMPOSITE MRP Planned Order
I_PlannedOrderComponent view inner BASIC Planned Order Component
I_PlannedOrderStdVH view from COMPOSITE Planned Order
I_PlannedOrderVH view_entity from COMPOSITE Planned Order
I_RFM_PlannedOrder view_entity from COMPOSITE Planned Order
I_SchedProdnGetPlndOrdEndDate view from COMPOSITE Planned order end date
I_SchedProdnWrkCtrSqncVH view inner COMPOSITE Work Ctr Filter for dispatch by sequence
P_BUSSOLNORDSLSORDFLWLVL9 view inner CONSUMPTION
P_DDOrderDetails view union_all CONSUMPTION
P_EvaltCapWrkCtrCapOperations view_entity union_all COMPOSITE
P_JITMatlRcpntDocuments view union_all COMPOSITE
P_PlannedOrderQuickView view from BASIC
P_RFM_SlsOrdPrgrsMntrPlndOrd view from COMPOSITE
P_Sched_Past_Operations view union_all COMPOSITE Past orders for Deallocate action
P_SchedOperations_Version_2 view union_all COMPOSITE
P_WBSOrders view union_all COMPOSITE
P_WorkCenterCapPplineOp view union_all COMPOSITE
R_PlannedOrderTP view_entity from TRANSACTIONAL RAP BO Planned Order view

Fields (62)

KeyField CDS FieldsUsed in Views
KEY Material Material 4
KEY MRPPlant MRPPlant,Plant 4
KEY PlannedOrder ARunSupplySelRuleAttribVal,OrderID,PlannedOrder,SubsequentDocument 8
KEY PlannedOrderCategory PlannedOrderCategory,SubsequentDocumentCategory 3
KEY SalesOrderItem SalesOrderItem,SubsequentDocumentItem 5
_CapacityRequirement _CapacityRequirement 1
_Material _Material 3
_MRPController _MRPController 1
_PurchasingDocument _PurchasingDocument 1
_Supplier _Supplier 1
AccountAssignmentCategory AccountAssignmentCategory 2
BaseUnit BaseUnit 6
BillOfMaterialStatus BillOfMaterialStatus 2
CapacityRequirement CapacityRequirement 1
Customer Customer 2
FixedSupplier FixedSupplier,Supplier 4
GoodsReceiptQtyInBaseUnit GoodsReceiptQty,GoodsReceiptQuantity 2
InventorySpecialStockType InventorySpecialStockType 1
IsPlannedWithoutFinalAssembly IsPlannedWithoutFinalAssembly 1
LastChangeDateTime LastChangeDateTime,PlannedOrderLastChangeDateTime 3
MasterPlannedOrder MasterPlannedOrder 1
MaterialGoodsReceiptDuration MaterialGoodsReceiptDuration 3
MaterialProcurementCategory MaterialProcurementCategory 4
MaterialProcurementType MaterialProcurementType 3
MRPArea MRPArea 4
MRPController MRPController 7
MRPPlanningScenario MRPPlanningScenario 1
PlannedOrderBOMIsFixed PlannedOrderBOMIsFixed 1
PlannedOrderCapacityIsDsptchd PlannedOrderCapacityIsDsptchd 1
PlannedOrderIsConvertible PlannedOrderIsConvertible 2
PlannedOrderIsFirm PlannedOrderIsFirm 3
PlannedOrderLongText PlannedOrderLongText 4
PlannedOrderOpeningDate OpeningDate,PlannedOrderOpeningDate 4
PlannedOrderType OrderType,PlannedOrderType 6
PlannedScrapQtyInBaseUnit PlndOrderPlannedScrapQty 2
PlannedTotalQtyInBaseUnit OrderPlannedTotalQty,PlannedTotalQtyInBaseUnit,PlndOrderPlannedTotalQty,TotalQuantity 5
PlndOrderPlannedEndDate DeliveryDate,PlannedEndDate,PlndOrderPlannedEndDate 6
PlndOrderPlannedEndTime PlndOrderPlannedEndTime 1
PlndOrderPlannedStartDate PlannedStartDate,PlndOrderPlannedStartDate,ReleaseDate 6
PlndOrderPlannedStartTime PlndOrderPlannedStartTime 1
Product Product 1
ProductCollection ProductCollection 1
ProductionEndDate ProductionEndDate 1
ProductionPlant Plant,ProductionPlant,SupplyingPlant 5
ProductionStartDate ProductionStartDate 1
ProductionSupervisor ProductionSupervisor 4
ProductionVersion ProductionVersion 7
ProductSeason ProductSeason 1
ProductSeasonYear ProductSeasonYear 1
ProductTheme ProductTheme 1
PurchasingDocument PurchasingDocument 1
PurchasingDocumentItem PurchasingDocumentItem 1
PurchasingOrganization PurchasingOrganization 2
QuantityWithdrawnInBaseUnit IssuedQuantity 1
QuotaArrangement QuotaArrangement 1
QuotaArrangementItem QuotaArrangementItem 1
Reservation Reservation 1
SalesOrder SalesOrder 4
SettlementReservation SettlementReservation 1
StockSegment StockSegment 1
StorageLocation StorageLocation 2
WBSElementInternalID 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.

-- Planned Order
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PLANNEDORDER (
    MATERIAL,
    MRPPLANT,
    PLANNEDORDER,
    PLANNEDORDERCATEGORY,
    SALESORDERITEM,
    _CAPACITYREQUIREMENT,
    _MATERIAL,
    _MRPCONTROLLER,
    _PURCHASINGDOCUMENT,
    _SUPPLIER,
    ACCOUNTASSIGNMENTCATEGORY,
    BASEUNIT,
    BILLOFMATERIALSTATUS,
    CAPACITYREQUIREMENT,
    CUSTOMER,
    FIXEDSUPPLIER,
    GOODSRECEIPTQTYINBASEUNIT,
    INVENTORYSPECIALSTOCKTYPE,
    ISPLANNEDWITHOUTFINALASSEMBLY,
    LASTCHANGEDATETIME,
    MASTERPLANNEDORDER,
    MATERIALGOODSRECEIPTDURATION,
    MATERIALPROCUREMENTCATEGORY,
    MATERIALPROCUREMENTTYPE,
    MRPAREA,
    MRPCONTROLLER,
    MRPPLANNINGSCENARIO,
    PLANNEDORDERBOMISFIXED,
    PLANNEDORDERCAPACITYISDSPTCHD,
    PLANNEDORDERISCONVERTIBLE,
    PLANNEDORDERISFIRM,
    PLANNEDORDERLONGTEXT,
    PLANNEDORDEROPENINGDATE,
    PLANNEDORDERTYPE,
    PLANNEDSCRAPQTYINBASEUNIT,
    PLANNEDTOTALQTYINBASEUNIT,
    PLNDORDERPLANNEDENDDATE,
    PLNDORDERPLANNEDENDTIME,
    PLNDORDERPLANNEDSTARTDATE,
    PLNDORDERPLANNEDSTARTTIME,
    PRODUCT,
    PRODUCTCOLLECTION,
    PRODUCTIONENDDATE,
    PRODUCTIONPLANT,
    PRODUCTIONSTARTDATE,
    PRODUCTIONSUPERVISOR,
    PRODUCTIONVERSION,
    PRODUCTSEASON,
    PRODUCTSEASONYEAR,
    PRODUCTTHEME,
    PURCHASINGDOCUMENT,
    PURCHASINGDOCUMENTITEM,
    PURCHASINGORGANIZATION,
    QUANTITYWITHDRAWNINBASEUNIT,
    QUOTAARRANGEMENT,
    QUOTAARRANGEMENTITEM,
    RESERVATION,
    SALESORDER,
    SETTLEMENTRESERVATION,
    STOCKSEGMENT,
    STORAGELOCATION,
    WBSELEMENTINTERNALID,
    PRIMARY KEY (MATERIAL, MRPPLANT, PLANNEDORDER, PLANNEDORDERCATEGORY, SALESORDERITEM)
);

Learn More