I_MRPPlannedOrder
MRP Planned Order
I_MRPPlannedOrder is a Composite CDS View that provides data about "MRP Planned Order" in SAP S/4HANA. It reads from 1 data source (I_PlannedOrder) and exposes 94 fields with key field PlannedOrder. It has 3 associations to related views. Part of development package ODATA_PP_MRP.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_PlannedOrder | I_PlannedOrder | from |
Parameters (1)
| Name | Type | Default |
|---|---|---|
| P_MRPElementCategory | mrpelementcategory |
Associations (3)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | I_ProductSupplyPlanning | _ProductSupplyPlanning | $projection.Material = _ProductSupplyPlanning.Product and $projection.MRPPlant = _ProductSupplyPlanning.Plant |
| [0..1] | I_EntProjectResponsiblePerson | _ProjectRespPersn | $projection.WBSElementInternalID = _ProjectRespPersn.WBSElementInternalID and _ProjectRespPersn.WBSElementInternalID is not initial |
| [0..1] | P_MRPMATERIALSTATUS | _MRPMaterialStatus | $projection.MRPPlant = _MRPMaterialStatus.MRPPlant and $projection.Material = _MRPMaterialStatus.Material |
Annotations (9)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | IMRPPLANNEDORDER | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| EndUserText.label | MRP Planned Order | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| ObjectModel.usageType.serviceQuality | #X | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| VDM.viewType | #COMPOSITE | view |
Fields (94)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | PlannedOrder | I_PlannedOrder | PlannedOrder | Planned Order |
| PlannedOrderType | I_PlannedOrder | PlannedOrderType | ||
| PlannedOrderTypeName | ||||
| Supplier | I_PlannedOrder | FixedSupplier | Fixed Vendor | |
| Material | I_PlannedOrder | Material | Vehicle Model | |
| MaterialName | ||||
| Product | I_PlannedOrder | Product | Product Sold | |
| MRPPlant | I_PlannedOrder | MRPPlant | Plant | |
| MRPArea | I_PlannedOrder | MRPArea | MRP Area | |
| ProductionVersion | I_PlannedOrder | ProductionVersion | Version ID | |
| MRPController | I_PlannedOrder | MRPController | MRP Controller | |
| ProductionPlant | I_PlannedOrder | ProductionPlant | Prod plnt | |
| SupplyingPlant | I_PlannedOrder | ProductionPlant | Prod plnt | |
| SupplierName | ||||
| PurchasingOrganization | I_PlannedOrder | PurchasingOrganization | Purchasing Organization | |
| PurchasingOrganizationName | ||||
| PurchasingGroup | ||||
| PurchasingGroupName | ||||
| PurchasingGroupPhoneNumber | ||||
| PurchasingGroupEmailAddress | ||||
| ProductionVersionText | ||||
| ProductionLine | ||||
| Plant | ||||
| InventorySpecialStockType | I_PlannedOrder | InventorySpecialStockType | Special Stock Type | |
| SalesOrder | I_PlannedOrder | SalesOrder | SD Document | |
| SalesOrderItem | I_PlannedOrder | SalesOrderItem | Sales Order Item | |
| SalesOrderType | ||||
| SalesOrderTypeName | ||||
| SalesOrderItemMaterial | ||||
| SalesOrderItemMaterialName | ||||
| Customer | I_PlannedOrder | Customer | Sold-to Party | |
| CustomerName | ||||
| WBSElementInternalID | I_PlannedOrder | WBSElementInternalID_2 | ||
| WBSElement | ||||
| WBSDescription | ||||
| ResponsiblePerson | ||||
| ResponsiblePersonName | ||||
| ProjectInternalID | ||||
| Project | ||||
| ProjectDescription | ||||
| ProjectResponsiblePerson | ||||
| ProjectResponsiblePersonName | ||||
| PlannedOrderOpeningDate | I_PlannedOrder | PlannedOrderOpeningDate | Opening Date | |
| PlndOrderPlannedStartDate | I_PlannedOrder | PlndOrderPlannedStartDate | Order Start | |
| PlndOrderPlannedEndDate | I_PlannedOrder | PlndOrderPlannedEndDate | Order End Date | |
| PlndOrderPlannedTotalQty | I_PlannedOrder | PlannedTotalQtyInBaseUnit | Total Quantity | |
| PlndOrderPlannedScrapQty | I_PlannedOrder | PlannedScrapQtyInBaseUnit | Scrap Quantity | |
| PlndOrderPlannedOpenQty | ||||
| GoodsReceiptQuantity | I_PlannedOrder | GoodsReceiptQtyInBaseUnit | Received | |
| BaseUnit | I_PlannedOrder | BaseUnit | Unit of Measure | |
| UnitOfMeasureNumberOfDecimals | ||||
| UnitOfMeasureDspNmbrOfDcmls | ||||
| UnitOfMeasureCommercialName | ||||
| MaterialProcurementCategory | I_PlannedOrder | MaterialProcurementCategory | Procurement | |
| MaterialProcurementCatName | ||||
| MaterialProcurementType | I_PlannedOrder | MaterialProcurementType | Spec. procuremt | |
| MaterialGoodsReceiptDuration | I_PlannedOrder | MaterialGoodsReceiptDuration | GR proc. time | |
| ProductionSupervisor | I_PlannedOrder | ProductionSupervisor | Prodn Supervisor | |
| SettlementReservation | I_PlannedOrder | SettlementReservation | ||
| IsPlannedWithoutFinalAssembly | I_PlannedOrder | IsPlannedWithoutFinalAssembly | ||
| LastChangeDateTime | I_PlannedOrder | LastChangeDateTime | Timestamp | |
| MaterialPlannedDeliveryDurn | _ProductSupplyPlanning | PlannedDeliveryDurationInDays | Plnd dely time | |
| MaterialPlannedProductionDurn | _ProductSupplyPlanning | InHouseProductionTime | InhseProdTime | |
| TotalReplenishmentLeadDuration | _ProductSupplyPlanning | TotalReplenishmentLeadTime | Total RL time | |
| MaterialFixedLotSizeQuantity | _ProductSupplyPlanning | FixedLotSizeQuantity | Fixed lot size | |
| MaterialMinLotSizeQuantity | _ProductSupplyPlanning | MinimumLotSizeQuantity | Min. Lot Size | |
| MaterialMaxLotSizeQuantity | _ProductSupplyPlanning | MaximumLotSizeQuantity | Max. Lot Size | |
| LotSizeRoundingQuantity | _ProductSupplyPlanning | LotSizeRoundingQuantity | Rounding value | |
| MaterialRoundingProfile | _ProductSupplyPlanning | RoundingProfile | Rnding Profile | |
| QuickViewCategory | ||||
| MRPElementCategory | ||||
| MRPValidMaterialStatus | _MRPMaterialStatus | MRPValidMaterialStatus | ||
| _MRPPlant | _MRPPlant | |||
| _Material | _Material | |||
| _MatlProcurementCategory | _MatlProcurementCategory | |||
| _ProductionSupervisor | _ProductionSupervisor | |||
| _SettlementReservation | _SettlementReservation | |||
| _PlannedOrderType | _PlannedOrderType | |||
| _Supplier | _Supplier | |||
| _MRPArea | _MRPArea | |||
| _ProductionVersion_2 | _ProductionVersion_2 | |||
| _MRPController | _MRPController | |||
| _ProductionPlant | _ProductionPlant | |||
| _SalesOrder | _SalesOrder | |||
| _SalesOrderItem | _SalesOrderItem | |||
| _Customer | _Customer | |||
| _WBSElementBasic2 | _WBSElementBasic2 | |||
| _ProductSupplyPlanning | _ProductSupplyPlanning | |||
| _PurchasingGroup | _PurchasingDocument | _PurchasingGroup | ||
| _ProductionLine | _ProductionVersion_2 | _ProductionLine | ||
| _Plant | _ProductionVersion_2 | _Plant | ||
| _MatlProcurementType | _MatlProcurementType | |||
| _InventorySpecialStockType | _InventorySpecialStockType | |||
| _PurchasingOrganization | _PurchasingOrganization |
Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.
-- Derived SQL interpretation of CDS view I_MRPPlannedOrder.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IMRPPLANNEDORDER
-- Parameters: P_MRPElementCategory : mrpelementcategory
CREATE VIEW I_MRPPlannedOrder AS
SELECT
I_PlannedOrder.PlannedOrder AS PlannedOrder,
I_PlannedOrder.PlannedOrderType AS PlannedOrderType,
I_PlannedOrder._PlannedOrderType._Text[1: Language = $session.system_language ].PlannedOrderTypeName AS PlannedOrderTypeName,
I_PlannedOrder.FixedSupplier AS Supplier,
I_PlannedOrder.Material AS Material,
I_PlannedOrder._Material._Text[1: Language = $session.system_language ].MaterialName AS MaterialName,
I_PlannedOrder.Product AS Product,
I_PlannedOrder.MRPPlant AS MRPPlant,
I_PlannedOrder.MRPArea AS MRPArea,
I_PlannedOrder.ProductionVersion AS ProductionVersion,
I_PlannedOrder.MRPController AS MRPController,
I_PlannedOrder.ProductionPlant AS ProductionPlant,
I_PlannedOrder.ProductionPlant AS SupplyingPlant,
I_PlannedOrder._Supplier.BPSupplierFullName AS SupplierName,
I_PlannedOrder.PurchasingOrganization AS PurchasingOrganization,
I_PlannedOrder._PurchasingOrganization.PurchasingOrganizationName AS PurchasingOrganizationName,
I_PlannedOrder._PurchasingDocument.PurchasingGroup AS PurchasingGroup,
I_PlannedOrder._PurchasingDocument._PurchasingGroup.PurchasingGroupName AS PurchasingGroupName,
I_PlannedOrder._PurchasingDocument._PurchasingGroup.PhoneNumber AS PurchasingGroupPhoneNumber,
I_PlannedOrder._PurchasingDocument._PurchasingGroup.EmailAddress AS PurchasingGroupEmailAddress,
I_PlannedOrder._ProductionVersion_2.ProductionVersionText AS ProductionVersionText,
I_PlannedOrder._ProductionVersion_2.ProductionLine AS ProductionLine,
I_PlannedOrder._ProductionVersion_2.Plant AS Plant,
I_PlannedOrder.InventorySpecialStockType AS InventorySpecialStockType,
I_PlannedOrder.SalesOrder AS SalesOrder,
I_PlannedOrder.SalesOrderItem AS SalesOrderItem,
I_PlannedOrder._SalesOrder._SalesOrderType.SalesOrderType AS SalesOrderType,
I_PlannedOrder._SalesOrder._SalesOrderType._Text[1: Language = $session.system_language ].SalesDocumentTypeName AS SalesOrderTypeName,
I_PlannedOrder._SalesOrderItem.Material AS SalesOrderItemMaterial,
I_PlannedOrder._SalesOrderItem._Material._Text[1: Language = $session.system_language ].MaterialName AS SalesOrderItemMaterialName,
I_PlannedOrder.Customer AS Customer,
I_PlannedOrder._Customer.BPCustomerName AS CustomerName,
I_PlannedOrder.WBSElementInternalID_2 AS WBSElementInternalID,
I_PlannedOrder._WBSElementBasic2.WBSElementExternalID AS WBSElement,
I_PlannedOrder._WBSElementBasic2.WBSDescription AS WBSDescription,
cast( _ProjectRespPersn.PersonWorkAgreement as ps_s4_vernr preserving type ) AS ResponsiblePerson,
_ProjectRespPersn._WorkforcePerson.PersonFullName AS ResponsiblePersonName,
cast (I_PlannedOrder._WBSElementBasic2.ProjectInternalID as ps_s4_proj_pspnr preserving type ) AS ProjectInternalID,
I_PlannedOrder._WBSElementBasic2._Project.ProjectExternalID AS Project,
I_PlannedOrder._WBSElementBasic2._Project.ProjectDescription AS ProjectDescription,
cast( _ProjectRespPersn.PersonWorkAgreement as ps_s4_vernr preserving type ) AS ProjectResponsiblePerson,
_ProjectRespPersn._WorkforcePerson.PersonFullName AS ProjectResponsiblePersonName,
I_PlannedOrder.PlannedOrderOpeningDate AS PlannedOrderOpeningDate,
I_PlannedOrder.PlndOrderPlannedStartDate AS PlndOrderPlannedStartDate,
I_PlannedOrder.PlndOrderPlannedEndDate AS PlndOrderPlannedEndDate,
I_PlannedOrder.PlannedTotalQtyInBaseUnit AS PlndOrderPlannedTotalQty,
I_PlannedOrder.PlannedScrapQtyInBaseUnit AS PlndOrderPlannedScrapQty,
(I_PlannedOrder.PlannedTotalQtyInBaseUnit - I_PlannedOrder.PlannedScrapQtyInBaseUnit - I_PlannedOrder.GoodsReceiptQtyInBaseUnit) AS PlndOrderPlannedOpenQty,
I_PlannedOrder.GoodsReceiptQtyInBaseUnit AS GoodsReceiptQuantity,
I_PlannedOrder.BaseUnit AS BaseUnit,
I_PlannedOrder._BaseUnit.UnitOfMeasureNumberOfDecimals AS UnitOfMeasureNumberOfDecimals,
I_PlannedOrder._BaseUnit.UnitOfMeasureDspNmbrOfDcmls AS UnitOfMeasureDspNmbrOfDcmls,
I_PlannedOrder._BaseUnit._Text[1: Language = $session.system_language ].UnitOfMeasureCommercialName AS UnitOfMeasureCommercialName,
I_PlannedOrder.MaterialProcurementCategory AS MaterialProcurementCategory,
I_PlannedOrder._MatlProcurementCategory._Text[1: Language = $session.system_language ].MaterialProcurementCatName AS MaterialProcurementCatName,
I_PlannedOrder.MaterialProcurementType AS MaterialProcurementType,
I_PlannedOrder.MaterialGoodsReceiptDuration AS MaterialGoodsReceiptDuration,
I_PlannedOrder.ProductionSupervisor AS ProductionSupervisor,
I_PlannedOrder.SettlementReservation AS SettlementReservation,
I_PlannedOrder.IsPlannedWithoutFinalAssembly AS IsPlannedWithoutFinalAssembly,
I_PlannedOrder.LastChangeDateTime AS LastChangeDateTime,
_ProductSupplyPlanning.PlannedDeliveryDurationInDays AS MaterialPlannedDeliveryDurn,
_ProductSupplyPlanning.InHouseProductionTime AS MaterialPlannedProductionDurn,
_ProductSupplyPlanning.TotalReplenishmentLeadTime AS TotalReplenishmentLeadDuration,
_ProductSupplyPlanning.FixedLotSizeQuantity AS MaterialFixedLotSizeQuantity,
_ProductSupplyPlanning.MinimumLotSizeQuantity AS MaterialMinLotSizeQuantity,
_ProductSupplyPlanning.MaximumLotSizeQuantity AS MaterialMaxLotSizeQuantity,
_ProductSupplyPlanning.LotSizeRoundingQuantity AS LotSizeRoundingQuantity,
_ProductSupplyPlanning.RoundingProfile AS MaterialRoundingProfile,
'000' AS QuickViewCategory,
$parameters.P_MRPElementCategory AS MRPElementCategory,
_MRPMaterialStatus.MRPValidMaterialStatus AS MRPValidMaterialStatus,
_PurchasingDocument._PurchasingGroup AS _PurchasingGroup,
_ProductionVersion_2._ProductionLine AS _ProductionLine,
_ProductionVersion_2._Plant AS _Plant
FROM I_PlannedOrder
LEFT OUTER JOIN I_ProductSupplyPlanning AS _ProductSupplyPlanning ON Material = _ProductSupplyPlanning.Product AND MRPPlant = _ProductSupplyPlanning.Plant -- association [0..1]
LEFT OUTER JOIN I_EntProjectResponsiblePerson AS _ProjectRespPersn ON WBSElementInternalID = _ProjectRespPersn.WBSElementInternalID AND _ProjectRespPersn.WBSElementInternalID is not initial -- association [0..1]
LEFT OUTER JOIN P_MRPMATERIALSTATUS AS _MRPMaterialStatus ON MRPPlant = _MRPMaterialStatus.MRPPlant AND Material = _MRPMaterialStatus.Material -- association [0..1]
;Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- 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
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA