I_DfctChgRecdType

DDL: I_DFCTCHGRECDTYPE SQL: IDFCTCRTYPE Type: view COMPOSITE

Chg Recd types for defect

I_DfctChgRecdType is a Composite CDS View that provides data about "Chg Recd types for defect" in SAP S/4HANA. It reads from 8 data sources and exposes 2 fields with key field ChangeRecordType.

8 data source(s) 2 fields

Data Sources (8)

SourceAliasJoin Type
I_ChangeRecordItemRel ItemRelDef inner
I_ChangeRecordItemRel ItemRelMBOM inner
I_ChangeRecordItemRel ItemRelPrn inner
I_ChangeRecordItemRel ItemRelRou inner
I_ChangeRecordRefObj RefObjDef inner
I_ChangeRecordRefObj RefObjMBOM inner
I_ChangeRecordRefObj RefObjPrn inner
I_ChangeRecordRefObj RefObjRou inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IDFCTCRTYPE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Chg Recd types for defect 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 (2)

KeyFieldSource TableSource FieldDescription
KEY ChangeRecordType CRType ChangeRecordType
ChangeRecordTypeDesc CRType ChangeRecordTypeDesc 
@AbapCatalog.sqlViewName: 'IDFCTCRTYPE'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Chg Recd types for defect'
@ObjectModel.usageType: {serviceQuality: #C,
                         dataClass: #CUSTOMIZING,
                         sizeCategory: #M}
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #COMPOSITE

define view I_DfctChgRecdType
  as select distinct from I_ChangeRecordType    as CRType
    inner join            I_ChangeRecordRefObj  as RefObjDef   on CRType.ChangeRecordType = RefObjDef.ChangeRecordType
    inner join            I_ChangeRecordRefObj  as RefObjMBOM  on CRType.ChangeRecordType = RefObjMBOM.ChangeRecordType
    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 ItemRelDef  on CRType.ChangeRecordType = ItemRelDef.ChangeRecordType
    inner join            I_ChangeRecordItemRel as ItemRelMBOM on CRType.ChangeRecordType = ItemRelMBOM.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,
      CRType.ChangeRecordTypeDesc
}
where CRType.ChangeRecordCategory = 'ECR'
  and( RefObjDef.ChangeRecordReferenceType = 'DEF' and RefObjMBOM.ChangeRecordReferenceType = 'MBM' and 
       RefObjRou.ChangeRecordReferenceType = 'ROU' and RefObjPrn.ChangeRecordReferenceType  = 'PRN' )
  and( ( ItemRelDef.ChangeRecordReferenceType = 'DEF' or ItemRelDef.ChangeRecordReferenceType = '')
          and (ItemRelDef.ChangeRecordItemRelevance = 'CTR') )  
  and( ( ItemRelMBOM.ChangeRecordReferenceType = 'MBM' or ItemRelMBOM.ChangeRecordReferenceType = '')
          and (ItemRelMBOM.ChangeRecordItemRelevance = 'REF') )
  and( (ItemRelRou.ChangeRecordReferenceType = 'ROU' or ItemRelRou.ChangeRecordReferenceType = '')
         and (ItemRelRou.ChangeRecordItemRelevance = 'REF') )
  and( ( ItemRelPrn.ChangeRecordReferenceType = 'PRN' or ItemRelPrn.ChangeRecordReferenceType = '')
          and (ItemRelPrn.ChangeRecordItemRelevance = 'REF') )  
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHANGERECORDITEMREL",
"I_CHANGERECORDREFOBJ",
"I_CHANGERECORDTYPE"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More