I_OrdRtgProdnOrdChgRecdType

DDL: I_ORDRTGPRODNORDCHGRECDTYPE SQL: IOSRPRODNCRTYPE Type: view COMPOSITE

Chg Recd types for routing and prdn order

I_OrdRtgProdnOrdChgRecdType is a Composite CDS View that provides data about "Chg Recd types for routing and prdn order" in SAP S/4HANA. It reads from 4 data sources (I_ChangeRecordItemRel, I_ChangeRecordItemRel, I_ChangeRecordRefObj, I_ChangeRecordRefObj) and exposes 4 fields with key fields ChangeRecordType, RoutingItemRelevance, ProdnOrdItemRelevance.

4 data source(s) 4 fields

Data Sources (4)

SourceAliasJoin Type
I_ChangeRecordItemRel ItemRelPrn inner
I_ChangeRecordItemRel ItemRelRou inner
I_ChangeRecordRefObj RefObjPrn inner
I_ChangeRecordRefObj RefObjRou inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IOSRPRODNCRTYPE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Chg Recd types for routing and prdn order view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.sizeCategory #M view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY ChangeRecordType CRType ChangeRecordType
KEY RoutingItemRelevance I_ChangeRecordItemRel ChangeRecordItemRelevance
KEY ProdnOrdItemRelevance I_ChangeRecordItemRel ChangeRecordItemRelevance
ChangeRecordTypeDesc CRType ChangeRecordTypeDesc 
@AbapCatalog.sqlViewName: 'IOSRPRODNCRTYPE'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Chg Recd types for routing and prdn order'
@ObjectModel.usageType: {serviceQuality: #C,
                         dataClass: #CUSTOMIZING,
                         sizeCategory: #M}
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #COMPOSITE
define view I_OrdRtgProdnOrdChgRecdType
  as select distinct from I_ChangeRecordType    as CRType
    inner join            I_ChangeRecordRefObj  as RefObjRou  on CRType.ChangeRecordType = RefObjRou.ChangeRecordType
    inner join            I_ChangeRecordRefObj  as RefObjPrn  on CRType.ChangeRecordType = RefObjPrn.ChangeRecordType
    inner join            I_ChangeRecordItemRel as ItemRelRou on CRType.ChangeRecordType = ItemRelRou.ChangeRecordType
    inner join            I_ChangeRecordItemRel as ItemRelPrn on CRType.ChangeRecordType = ItemRelPrn.ChangeRecordType

{
  key CRType.ChangeRecordType,
  key ItemRelRou.ChangeRecordItemRelevance as RoutingItemRelevance,
  key ItemRelPrn.ChangeRecordItemRelevance as ProdnOrdItemRelevance,
      CRType.ChangeRecordTypeDesc
}
where CRType.ChangeRecordCategory          = 'ECR'
  and( RefObjRou.ChangeRecordReferenceType = 'ROU' and  RefObjPrn.ChangeRecordReferenceType  = 'PRN' )
  and( (ItemRelRou.ChangeRecordReferenceType = 'ROU' or ItemRelRou.ChangeRecordReferenceType = '')
         and (ItemRelRou.ChangeRecordItemRelevance = 'CRE' or ItemRelRou.ChangeRecordItemRelevance = 'CHG') )
  and( ( ItemRelPrn.ChangeRecordReferenceType = 'PRN' or ItemRelPrn.ChangeRecordReferenceType = '')
          and (ItemRelPrn.ChangeRecordItemRelevance = 'CHG') )  
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHANGERECORDITEMREL",
"I_CHANGERECORDREFOBJ",
"I_CHANGERECORDTYPE"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More