I_Order

DDL: I_ORDER SQL: IORDER Type: view BASIC
25 Fields 1 Data Sources 1 Associations

Order Header

I_Order (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Manufacturing

I_Order is a Basic CDS View (Dimension) that provides data about "Order Header" in SAP S/4HANA. It reads from 1 data source (I_OrderBasic) and exposes 25 fields with key field OrderID. It has 1 association to related views.

SAP Help Documentation

CategoryCDS Views for Discrete and Process Manufacturing
Data CategoryDimension
Purpose
The purpose of this CDS view is to retrieve a list of orders for a particular order category or order type, such as CO internal orders or manufacturing orders. The following released views are provided for order details: I_InternalOrder I_ProductCostCtrlgOrder I_ManufacturingOrder This CDS view provides the prerequisites for answering the following business question: Which orders exist for a specific order category? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to use this CDS view don't need any special authorization.

Structure
Important Fields Important fields in this view include the following: Field Name Description OrderID Order Number OrderCategory Order Category OrderType Order Type OrderInternalID Order Internal ID OrderDescription Order Description OrderHasLongText Long Text Exists Plant Plant MRPController MRP Controller ControllingArea Controlling Area CompanyCode Company Code ProfitCenter Profit Center ObjectInternalID Object Internal ID IsStatisticalOrder Identifier for statistical order IsMarkedForDeletion Deletion Flag OrderActualReleaseDate Release date TechnicalCompletionDate Technical completion date OrderActualCloseDate Close date OrderIsCreated Phase "Order created" OrderIsReleased Phase "Order released" OrderIsCompleted Phase "Order completed" OrderIsClosed Phase "Order closed"

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessManufacturing
Application ComponentPP-VDM
CapabilitiesAssociation Target for Defining CDS Entities, Analytical Dimension, Data Source for Search
PackageManufacturing for SAP S/4HANA Cloud Private Edition
Description The purpose of this CDS view is to retrieve a list of orders for a particular order category or order type, such as CO internal orders or manufacturing orders. The following released views are provided for order details:<ul> <li><p>I_InternalOrder</p></li> <li><p>I_ProductCostCtrlgOrder</p></li> <li><p>I_ManufacturingOrder</p></li> </ul> <p>This CDS view provides the prerequisites for answering the following business question:</p> <ul> <li><p>Which orders exist for a specific order category?</p></li> </ul> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
I_OrderBasic aufk from

Associations (1)

CardinalityTargetAliasCondition
[1..1] E_LogisticsOrder _Extension $projection.OrderID = _Extension.OrderID

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName IORDER view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
Analytics.dataCategory #DIMENSION view
ClientHandling.algorithm #SESSION_VARIABLE view
ClientHandling.type #CLIENT_DEPENDENT view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.representativeKey OrderID view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Search.searchable true view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #BASIC view
EndUserText.label Order Header view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY OrderID I_OrderBasic OrderID Order Number
OrderCategory I_OrderBasic OrderCategory Order Category
OrderType I_OrderBasic OrderType Order Type
OrderInternalID afko OrderInternalID Order Internal ID
OrderDescription I_OrderBasic OrderDescription Order Description
OrderHasLongText I_OrderBasic OrderHasLongText Order Has Long Text
Plant I_OrderBasic Plant Valuation Area
MRPController afko MRPController MRP Controller
ControllingArea I_OrderBasic ControllingArea Controlling Area
CompanyCode I_OrderBasic CompanyCode Receiver Company Code
ProfitCenter I_OrderBasic ProfitCenter Profit Center
ObjectInternalID I_OrderBasic ObjectInternalID Object Internal ID
IsStatisticalOrder I_OrderBasic IsStatisticalOrder Identifier for Statistical Order
IsMarkedForDeletion I_OrderBasic IsMarkedForDeletion Purch.org. data
OrderActualReleaseDate I_OrderBasic OrderActualReleaseDate Release Date
TechnicalCompletionDate I_OrderBasic TechnicalCompletionDate Technical Completion Date
OrderActualCloseDate I_OrderBasic OrderActualCloseDate Close Date
OrderIsCreated I_OrderBasic OrderIsCreated Phase "Order Created"
OrderIsReleased I_OrderBasic OrderIsReleased Phase "Order Released"
OrderIsCompleted I_OrderBasic OrderIsCompleted Phase "Order Completed"
OrderIsClosed I_OrderBasic OrderIsClosed Phase "Order Closed"
_OrderCategory I_OrderBasic _OrderCategory
_OrderType I_OrderBasic _OrderType
_OrderInternalID afko _OrderInternalID
_OrderHierarchyNode I_OrderBasic _OrderHierarchyNode

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_Order.
-- 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: IORDER

CREATE VIEW I_Order AS
SELECT
  aufk.OrderID AS OrderID,
  aufk.OrderCategory AS OrderCategory,
  aufk.OrderType AS OrderType,
  afko.OrderInternalID AS OrderInternalID,
  aufk.OrderDescription AS OrderDescription,
  aufk.OrderHasLongText AS OrderHasLongText,
  aufk.Plant AS Plant,
  afko.MRPController AS MRPController,
  aufk.ControllingArea AS ControllingArea,
  aufk.CompanyCode AS CompanyCode,
  aufk.ProfitCenter AS ProfitCenter,
  aufk.ObjectInternalID AS ObjectInternalID,
  aufk.IsStatisticalOrder AS IsStatisticalOrder,
  aufk.IsMarkedForDeletion AS IsMarkedForDeletion,
  aufk.OrderActualReleaseDate AS OrderActualReleaseDate,
  aufk.TechnicalCompletionDate AS TechnicalCompletionDate,
  aufk.OrderActualCloseDate AS OrderActualCloseDate,
  aufk.OrderIsCreated AS OrderIsCreated,
  aufk.OrderIsReleased AS OrderIsReleased,
  aufk.OrderIsCompleted AS OrderIsCompleted,
  aufk.OrderIsClosed AS OrderIsClosed,
  aufk._OrderCategory AS _OrderCategory,
  aufk._OrderType AS _OrderType,
  afko._OrderInternalID AS _OrderInternalID,
  aufk._OrderHierarchyNode AS _OrderHierarchyNode
FROM I_OrderBasic AS aufk
LEFT OUTER JOIN E_LogisticsOrder AS _Extension ON OrderID = _Extension.OrderID  -- association [1..1]
;

Learn More