I_PLANNEDORDERCOMPONENT
Planned Order Component
I_PLANNEDORDERCOMPONENT is a CDS View in S/4HANA. Planned Order Component. It contains 39 fields. 6 CDS views read from this table.
CDS Views using this table (6)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| /VSCEW/C_SC_Component_PA | view_entity | from | Supply Chain Component PA (Plan. Order) | |
| A_PlannedOrderComponent | view | from | COMPOSITE | Planned Order Components |
| C_PlannedOrderObjPgComp | view_entity | from | CONSUMPTION | Planned Order Components : Object Page |
| I_PlndOrdCompWithIssue | view | from | COMPOSITE | Planned order components with issues |
| I_RFM_PlannedOrderComp | view_entity | from | COMPOSITE | Planned Order Component |
| R_PlannedOrderComponentTP | view_entity | from | TRANSACTIONAL | RAP BO Planned Order Component view |
Fields (39)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | RecordType | RecordType,ReservationRecordType | 2 |
| KEY | Reservation | Reservation | 4 |
| KEY | ReservationItem | ReservationItem | 4 |
| _Material | _Material | 1 | |
| _MRPController | _MRPController | 1 | |
| _Plant | _Plant | 1 | |
| _Reservation | _Reservation | 1 | |
| _StorageLocation | _StorageLocation | 1 | |
| _SupplyArea | _SupplyArea | 1 | |
| BaseUnit | BaseUnit | 3 | |
| BillOfMaterialCategory | BillOfMaterialCategory | 2 | |
| BillOfMaterialItemNumber | BillOfMaterialItemNumber | 1 | |
| BOMItem | BOMItem | 2 | |
| BOMItemDescription | BOMItemDescription | 2 | |
| BOMItemText2 | BOMItemText2 | 1 | |
| ComponentScrapInPercent | ScrapInPercent | 1 | |
| DebitCreditCode | DebitCreditCode | 1 | |
| EntryUnit | EntryUnit | 1 | |
| FollowUpMaterialIsActive | FollowUpProductIsActive | 1 | |
| GoodsMovementEntryQty | EntryQuantity | 1 | |
| InventorySpecialStockType | InventorySpecialStockType | 1 | |
| IsBulkMaterialComponent | IsBulk | 1 | |
| Material | Material,Product | 3 | |
| MaterialGroup | ProductGroup | 1 | |
| MatlCompDiscontinuationType | DiscontinuationType | 1 | |
| MatlCompRequirementDate | MatlCompRequirementDate,RequirementDate | 3 | |
| MatlCompRequirementTime | RequirementTime | 1 | |
| MRPController | MRPController | 2 | |
| OperationLeadTimeOffset | OperationLeadTimeOffset | 1 | |
| OperationLeadTimeOffsetUnit | OperationLeadTimeOffsetUnit | 1 | |
| PlannedOrder | PlannedOrder | 2 | |
| Plant | Plant | 3 | |
| QuantityIsFixed | QuantityIsFixed | 1 | |
| RequiredQuantity | RequiredQuantity | 3 | |
| ReservationIsFinallyIssued | ReservationIsFinallyIssued | 1 | |
| SalesOrder | SalesOrder | 1 | |
| SalesOrderItem | SalesOrderItem | 1 | |
| SupplyArea | SupplyArea | 1 | |
| WithdrawnQuantity | WithdrawnQuantity | 3 |
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 Component
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PLANNEDORDERCOMPONENT (
RECORDTYPE,
RESERVATION,
RESERVATIONITEM,
_MATERIAL,
_MRPCONTROLLER,
_PLANT,
_RESERVATION,
_STORAGELOCATION,
_SUPPLYAREA,
BASEUNIT,
BILLOFMATERIALCATEGORY,
BILLOFMATERIALITEMNUMBER,
BOMITEM,
BOMITEMDESCRIPTION,
BOMITEMTEXT2,
COMPONENTSCRAPINPERCENT,
DEBITCREDITCODE,
ENTRYUNIT,
FOLLOWUPMATERIALISACTIVE,
GOODSMOVEMENTENTRYQTY,
INVENTORYSPECIALSTOCKTYPE,
ISBULKMATERIALCOMPONENT,
MATERIAL,
MATERIALGROUP,
MATLCOMPDISCONTINUATIONTYPE,
MATLCOMPREQUIREMENTDATE,
MATLCOMPREQUIREMENTTIME,
MRPCONTROLLER,
OPERATIONLEADTIMEOFFSET,
OPERATIONLEADTIMEOFFSETUNIT,
PLANNEDORDER,
PLANT,
QUANTITYISFIXED,
REQUIREDQUANTITY,
RESERVATIONISFINALLYISSUED,
SALESORDER,
SALESORDERITEM,
SUPPLYAREA,
WITHDRAWNQUANTITY,
PRIMARY KEY (RECORDTYPE, RESERVATION, RESERVATIONITEM)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA