I_Order

DDL: I_ORDER SQL: IORDER Type: view BASIC

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)

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

OData Services (1)

ServiceBindingVersionContractRelease
FARR_SD_REV_CATCHUP FARR_SDB_REV_CATCHUP V2 C1 NOT_RELEASED

Fields (25)

KeyFieldSource TableSource FieldDescription
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
};