I_Order
Order Header
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. It is exposed through 1 OData service (FARR_SD_REV_CATCHUP).
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_OrderBasic | aufk | from |
Associations (1)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..1] | E_LogisticsOrder | _Extension | $projection.OrderID = _Extension.OrderID |
Annotations (17)
| Name | Value | Level | Field |
|---|---|---|---|
| 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 |
OData Services (1)
| Service | Binding | Version | Contract | Release |
|---|---|---|---|---|
| FARR_SD_REV_CATCHUP | FARR_SDB_REV_CATCHUP | V2 | C1 | NOT_RELEASED |
Fields (25)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | OrderID | I_OrderBasic | OrderID | |
| OrderCategory | I_OrderBasic | OrderCategory | ||
| OrderType | I_OrderBasic | OrderType | ||
| OrderInternalID | afko | OrderInternalID | ||
| OrderDescription | I_OrderBasic | OrderDescription | ||
| OrderHasLongText | I_OrderBasic | OrderHasLongText | ||
| Plant | I_OrderBasic | Plant | ||
| MRPController | afko | MRPController | ||
| ControllingArea | I_OrderBasic | ControllingArea | ||
| CompanyCode | I_OrderBasic | CompanyCode | ||
| ProfitCenter | I_OrderBasic | ProfitCenter | ||
| ObjectInternalID | I_OrderBasic | ObjectInternalID | ||
| IsStatisticalOrder | I_OrderBasic | IsStatisticalOrder | ||
| IsMarkedForDeletion | I_OrderBasic | IsMarkedForDeletion | ||
| OrderActualReleaseDate | I_OrderBasic | OrderActualReleaseDate | ||
| TechnicalCompletionDate | I_OrderBasic | TechnicalCompletionDate | ||
| OrderActualCloseDate | I_OrderBasic | OrderActualCloseDate | ||
| OrderIsCreated | I_OrderBasic | OrderIsCreated | ||
| OrderIsReleased | I_OrderBasic | OrderIsReleased | ||
| OrderIsCompleted | I_OrderBasic | OrderIsCompleted | ||
| OrderIsClosed | I_OrderBasic | OrderIsClosed | ||
| _OrderCategory | I_OrderBasic | _OrderCategory | ||
| _OrderType | I_OrderBasic | _OrderType | ||
| _OrderInternalID | afko | _OrderInternalID | ||
| _OrderHierarchyNode | I_OrderBasic | _OrderHierarchyNode |
@AbapCatalog.sqlViewName: 'IORDER'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Analytics.dataCategory: #DIMENSION
@ClientHandling.algorithm: #SESSION_VARIABLE
@ClientHandling.type: #CLIENT_DEPENDENT
@Metadata.allowExtensions: true
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.modelingPattern: #ANALYTICAL_DIMENSION
@ObjectModel.supportedCapabilities: [#ANALYTICAL_DIMENSION, #CDS_MODELING_ASSOCIATION_TARGET, #SEARCHABLE_ENTITY]
@ObjectModel.representativeKey: 'OrderID'
@ObjectModel.semanticKey: ['OrderID']
@ObjectModel.usageType: {serviceQuality: #A, sizeCategory: #L, dataClass: #TRANSACTIONAL}
@Search.searchable: true
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@VDM.viewType: #BASIC
@EndUserText.label: 'Order Header'
// basic view for existence check on orders of any category (AUFTYP);
// details on orders are provided e.g. by basic views I_LogisticsOrder or I_InternalOrder
/*+[hideWarning] { "IDS" : [ "CALCULATED_FIELD_CHECK" ] } */
define view I_Order
as select from I_OrderBasic as aufk
left outer to one join I_LogisticsOrderBasic as afko on afko.OrderID = aufk.OrderID
association [1..1] to E_LogisticsOrder as _Extension on $projection.OrderID = _Extension.OrderID
{
// Key
@ObjectModel.hierarchy.association: '_OrderHierarchyNode'
@ObjectModel.text.element: ['OrderDescription']
@Search:{
defaultSearchElement: true,
fuzzinessThreshold: 0.8,
ranking: #HIGH
}
key aufk.OrderID,
// Category and Type
@ObjectModel.foreignKey.association: '_OrderCategory'
@Search:{
defaultSearchElement: true,
fuzzinessThreshold: 0.8,
ranking: #LOW
}
aufk.OrderCategory,
@ObjectModel.foreignKey.association: '_OrderType'
@Search:{
defaultSearchElement: true,
fuzzinessThreshold: 0.8,
ranking: #LOW
}
aufk.OrderType,
// Internal ID
@ObjectModel.foreignKey.association: '_OrderInternalID'
@Search:{
defaultSearchElement: true,
fuzzinessThreshold: 0.8,
ranking: #LOW
}
afko.OrderInternalID,
// Text
@Semantics.text: true
@Search:{
defaultSearchElement: true,
fuzzinessThreshold: 0.8,
ranking: #LOW
}
aufk.OrderDescription,
aufk.OrderHasLongText,
// Additionals
@Search:{
defaultSearchElement: true,
fuzzinessThreshold: 0.8,
ranking: #LOW
}
aufk.Plant,
@Search:{
defaultSearchElement: true,
fuzzinessThreshold: 0.8,
ranking: #LOW
}
afko.MRPController,
@Search:{
defaultSearchElement: true,
fuzzinessThreshold: 0.8,
ranking: #LOW
}
aufk.ControllingArea,
@Search:{
defaultSearchElement: true,
fuzzinessThreshold: 0.8,
ranking: #LOW
}
aufk.CompanyCode,
@Search:{
defaultSearchElement: true,
fuzzinessThreshold: 0.8,
ranking: #LOW
}
aufk.ProfitCenter,
aufk.ObjectInternalID,
aufk.IsStatisticalOrder,
aufk.IsMarkedForDeletion,
aufk.OrderActualReleaseDate,
aufk.TechnicalCompletionDate,
aufk.OrderActualCloseDate,
aufk.OrderIsCreated,
aufk.OrderIsReleased,
aufk.OrderIsCompleted,
aufk.OrderIsClosed,
// Associations
aufk._OrderCategory,
aufk._OrderType,
afko._OrderInternalID,
aufk._OrderHierarchyNode
};
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- 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