C_ReExAssignInternalOrder

DDL: C_REEXASSIGNINTERNALORDER SQL: CREEXASSINTORDER Type: view CONSUMPTION

Internal Order

C_ReExAssignInternalOrder is a Consumption CDS View that provides data about "Internal Order" in SAP S/4HANA. It reads from 1 data source (I_InternalOrder) and exposes 14 fields with key field InternalOrder.

Data Sources (1)

SourceAliasJoin Type
I_InternalOrder I_InternalOrder from

Annotations (10)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName CREEXASSINTORDER view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Internal Order view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
Search.searchable true view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY InternalOrder I_InternalOrder InternalOrder
InternalOrderDescription I_InternalOrder InternalOrderDescription
OrderCategory I_InternalOrder OrderCategory
BusinessArea I_InternalOrder BusinessArea
ControllingArea I_InternalOrder ControllingArea
Plant I_InternalOrder Plant
Currency I_InternalOrder Currency
ControllingObject I_InternalOrder ControllingObject
CompanyCode I_InternalOrder CompanyCode
ProfitCenter I_InternalOrder ProfitCenter
FunctionalArea I_InternalOrder FunctionalArea
OrderType I_InternalOrder OrderType
ResponsibleCostCenter I_InternalOrder ResponsibleCostCenter
InternalOrderResponsibleUser I_InternalOrder InternalOrderResponsibleUser
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'CREEXASSINTORDER'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Internal Order'
@VDM.viewType: #CONSUMPTION

@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory : #L
@ObjectModel.usageType.dataClass: #MIXED
@Search.searchable: true

define view C_ReExAssignInternalOrder
    as select from I_InternalOrder

{
      @Search.defaultSearchElement: true     
      @Search.ranking: #HIGH
  key I_InternalOrder.InternalOrder                            as InternalOrder,
      @Semantics.text: true
      I_InternalOrder.InternalOrderDescription                 as InternalOrderDescription,
      I_InternalOrder.OrderCategory                            as OrderCategory,
      I_InternalOrder.BusinessArea                             as BusinessArea,
      I_InternalOrder.ControllingArea                          as ControllingArea,
      I_InternalOrder.Plant                                    as Plant,
      I_InternalOrder.Currency                                 as Currency,
      I_InternalOrder.ControllingObject                        as ControllingObject,         
      I_InternalOrder.CompanyCode                              as CompanyCode,
      I_InternalOrder.ProfitCenter                             as ProfitCenter,
      I_InternalOrder.FunctionalArea                           as FunctionalArea,
      I_InternalOrder.OrderType                                as OrderType,
      I_InternalOrder.ResponsibleCostCenter                    as ResponsibleCostCenter,
      I_InternalOrder.InternalOrderResponsibleUser             as InternalOrderResponsibleUser


}
where OrderCategory ='01';             
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_INTERNALORDER"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/