I_CHGRECDTYPECONFIGURATION

CDS View

Change Record Type Configuration

I_CHGRECDTYPECONFIGURATION is a CDS View in S/4HANA. Change Record Type Configuration. It contains 1 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 1 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_ChgRecdTypeRlvtForEngSnpsht view inner COMPOSITE Change Record Types:Snpsht,EBOM,PLS,MBOM
I_ChgRecdTypeRlvtForMfgSnpsht view inner COMPOSITE Change Record Types for Mfg Snapshot
I_ChgRecdTypeRlvtSnpshtWthDoc view inner COMPOSITE Change Record Types:Snpsht,EBOM,PLS,MBOM,DOC

Fields (1)

KeyField CDS FieldsUsed in Views
IsExternalNumberRange IsExternalNumberRange 3 
@AbapCatalog.sqlViewName: 'ICRTYPCONFIGN'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #S, dataClass: #MASTER}
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Change Record Type Configuration'

define view I_ChgRecdTypeConfiguration
  as select from /iam/c_issuetyp as Issue_Type
    inner join   /plmi/cr_type   as CR_Type             on Issue_Type.issue_type = CR_Type.cr_type
    inner join   nriv            as NumberRangeInterval on(
      Issue_Type.nrange_interval = NumberRangeInterval.nrrangenr
    )
{
  key Issue_Type.issue_type         as ChangeRecordType,
      NumberRangeInterval.externind as IsExternalNumberRange
}
where
      Issue_Type.application     = 'CR'
  and CR_Type.cr_category        = 'ECR'
  and NumberRangeInterval.object = '/IAM/ISSUE'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"/IAM/C_ISSUETYP",
"/PLMI/CR_TYPE",
"NRIV"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More