I_ChangeRecordType_2

DDL: I_CHANGERECORDTYPE_2 Type: view_entity BASIC Package: VDM_PLMB_CR

CR Type V4

I_ChangeRecordType_2 is a Basic CDS View that provides data about "CR Type V4" in SAP S/4HANA. It reads from 1 data source (/plmi/chgrectype) and exposes 10 fields with key field ChangeRecordType. It has 1 association to related views. Part of development package VDM_PLMB_CR.

Data Sources (1)

SourceAliasJoin Type
/plmi/chgrectype CR_type from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_ChangeRecordTypeText_2 _Text $projection.ChangeRecordType = _Text.ChangeRecordType

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label CR Type V4 view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
VDM.viewType #BASIC view
Feature /PLMI/CHANGERECORD_CONFIG view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY ChangeRecordType /plmi/chgrectype cr_type
ChangeRecordNumberRangeIntID /plmi/chgrectype number_range
ChangeRecordUserStatusProfile /plmi/chgrectype user_status_profile
ChangeRecdLifeCycleStsProfile /plmi/chgrectype lifecycle_status_profile
ChgRecdItemProcgStatusIsEnbld /plmi/chgrectype proc_status_enabled
ChangeRecordTypeIsInactive /plmi/chgrectype inactive
ChgRecdTypeIsRegulatedIndustry /plmi/chgrectype regulated_industry
ChangeRecordPurposeType /plmi/chgrectype purpose_type
ChangeRecordTypeDesc
_Text _Text
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'CR Type V4'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #B,
  sizeCategory: #S,
  dataClass: #CUSTOMIZING
}
@VDM.viewType: #BASIC

@Feature: '/PLMI/CHANGERECORD_CONFIG'
define view entity I_ChangeRecordType_2 as select from /plmi/chgrectype as CR_type
  association [0..*] to I_ChangeRecordTypeText_2 as _Text on $projection.ChangeRecordType = _Text.ChangeRecordType
{
  key CR_type.cr_type                             as ChangeRecordType,
      CR_type.number_range                        as ChangeRecordNumberRangeIntID,
      CR_type.user_status_profile                 as ChangeRecordUserStatusProfile,
      CR_type.lifecycle_status_profile            as ChangeRecdLifeCycleStsProfile,
      @Semantics.booleanIndicator:true
      CR_type.proc_status_enabled                 as ChgRecdItemProcgStatusIsEnbld,
      @Semantics.booleanIndicator:true
      case CR_type.proc_status_enabled
            when 'X' then ' '
            else 'X'
      end                                         as ChgRecItemProcStatusIsDisabled,
      @Semantics.booleanIndicator:true
      CR_type.inactive                            as ChangeRecordTypeIsInactive,
      @Semantics.booleanIndicator:true
      CR_type.regulated_industry                  as ChgRecdTypeIsRegulatedIndustry,
      CR_type.purpose_type                        as ChangeRecordPurposeType,
      _Text[1:Language = $session.system_language].ChangeRecordTypeDesc as ChangeRecordTypeDesc,
      _Text
}
where CR_type.inactive <> 'X'