C_EngSnpshtChgRecdTypeVH

DDL: C_ENGSNPSHTCHGRECDTYPEVH SQL: CENGSNPCRTYPVH Type: view CONSUMPTION Package: VDM_MPE_PLAN_ENG_SNPSHT

Change Record Type

C_EngSnpshtChgRecdTypeVH is a Consumption CDS View that provides data about "Change Record Type" in SAP S/4HANA. It reads from 2 data sources (I_ChangeRecordType, I_ChgRecdTypeRlvtForEngSnpsht) and exposes 4 fields with key field ChangeRecordType. Part of development package VDM_MPE_PLAN_ENG_SNPSHT.

2 data source(s) 4 fields

Data Sources (2)

SourceAliasJoin Type
I_ChangeRecordType ChgRecdType from
I_ChgRecdTypeRlvtForEngSnpsht ChgRecdTypeRlvtForEngSnpsht inner

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CENGSNPCRTYPVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
Search.searchable true view
EndUserText.label Change Record Type view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY ChangeRecordType I_ChangeRecordType ChangeRecordType
ChangeRecordTypeDesc
ChangeRecordCategory I_ChangeRecordType ChangeRecordCategory
IsExternalNumberRange I_ChgRecdTypeRlvtForEngSnpsht IsExternalNumberRange 
@AbapCatalog.sqlViewName: 'CENGSNPCRTYPVH'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #CONSUMPTION
@Search.searchable: true
@EndUserText.label: 'Change Record Type'
@ObjectModel.usageType: {serviceQuality: #C,
                         dataClass: #MIXED,
                         sizeCategory: #L}
@ClientHandling.algorithm: #SESSION_VARIABLE
define view C_EngSnpshtChgRecdTypeVH as select from I_ChangeRecordType as ChgRecdType
            inner join I_ChgRecdTypeRlvtForEngSnpsht as ChgRecdTypeRlvtForEngSnpsht on ChgRecdTypeRlvtForEngSnpsht.ChangeRecordType = ChgRecdType.ChangeRecordType  
    
    {
      @Search.defaultSearchElement: true
      @Search.ranking: #HIGH
      @Search.fuzzinessThreshold: 0.8
      @ObjectModel.text.element: 'ChangeRecordTypeDesc'
  key ChgRecdType.ChangeRecordType,
      @Search.defaultSearchElement: true      
      cast(ChgRecdType.ChangeRecordTypeDesc as /plmb/cr_type_desc preserving type) as ChangeRecordTypeDesc,
      @UI.hidden: true
      ChgRecdType.ChangeRecordCategory,  
      @UI.hidden: true
      ChgRecdTypeRlvtForEngSnpsht.IsExternalNumberRange
}

Learn More