C_EngSnpshtChgRecdTypeDocVH

DDL: C_ENGSNPSHTCHGRECDTYPEDOCVH SQL: CSNPCRTYPDOCVH Type: view CONSUMPTION

Change Record Type

C_EngSnpshtChgRecdTypeDocVH 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_ChgRecdTypeRlvtSnpshtWthDoc) and exposes 4 fields with key field ChangeRecordType.

2 data source(s) 4 fields

Data Sources (2)

SourceAliasJoin Type
I_ChangeRecordType ChgRecdType from
I_ChgRecdTypeRlvtSnpshtWthDoc ChgRecdTypeRlvtEngSnpshtWthDoc inner

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CSNPCRTYPDOCVH 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_ChgRecdTypeRlvtSnpshtWthDoc IsExternalNumberRange 
@AbapCatalog.sqlViewName: 'CSNPCRTYPDOCVH'
@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_EngSnpshtChgRecdTypeDocVH as select from I_ChangeRecordType as ChgRecdType
            inner join I_ChgRecdTypeRlvtSnpshtWthDoc  as ChgRecdTypeRlvtEngSnpshtWthDoc on ChgRecdTypeRlvtEngSnpshtWthDoc.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
      ChgRecdTypeRlvtEngSnpshtWthDoc.IsExternalNumberRange
}

Learn More