I_ChangeMasterTP

DDL: I_CHANGEMASTERTP Type: view_entity TRANSACTIONAL Package: VDM_PLMB_ECN

Change Number (Transactional Processsing)

I_ChangeMasterTP is a Transactional CDS View that provides data about "Change Number (Transactional Processsing)" in SAP S/4HANA. It reads from 1 data source (I_ChangeMaster) and exposes 28 fields with key field ChangeNumber. It has 6 associations to related views. Part of development package VDM_PLMB_ECN.

Data Sources (1)

SourceAliasJoin Type
I_ChangeMaster I_ChangeMaster from

Associations (6)

CardinalityTargetAliasCondition
[1..*] I_ChangeMasterAltDateTP _AlternativeDate
[1..*] I_ChangeMasterObjTypeAssgmtTP _ObjTypeAssignment
[1..*] I_ChangeMstrObjectMgmtRecordTP _ChangeMstrObjectMgmtRecord
[1..*] I_ChangeMstrObMgReMaterialTP _ChangeMstrObMgReMaterial
[1..*] I_ChangeMstrObMgReMatlBOMTP _ChangeMstrObMgReMatlBOM
[1..*] I_ChgMstrObMgReDocInfoRecdTP _ChangeMstrObMgReDocInfoRecd

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.representativeKey ChangeNumber view
ObjectModel.sapObjectNodeType.name ChangeMaster view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
EndUserText.label Change Number (Transactional Processsing) view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY ChangeNumber ChangeNumber
ChangeNumberStatus ChangeNumberStatus
AuthorizationGroup AuthorizationGroup
ChangeNumberFunction ChangeNumberFunction
IsTechnicallyReleased IsTechnicallyReleased
ChangeNumberReleaseKey ChangeNumberReleaseKey
ReasonForChangeText ReasonForChangeText
ChangeNumberDescription ChangeNumberDescription
ChangeNumberValidFromDate ChangeNumberValidFromDate
ChangeNumberCreationDate ChangeNumberCreationDate
ChangeNumberCreatedByUser ChangeNumberCreatedByUser
ChangeNumberLastChangedDate ChangeNumberLastChangedDate
ChangeNumberLastChangedByUser ChangeNumberLastChangedByUser
IsUsedForDataDefinition IsUsedForDataDefinition
ChangeNumberIsMrkdForDeletion ChangeNumberIsMrkdForDeletion
_ChangeNumberStatus _ChangeNumberStatus
_AlternativeDate _AlternativeDate
_ObjTypeAssignment _ObjTypeAssignment
_ChangeMstrObjectMgmtRecord _ChangeMstrObjectMgmtRecord
_ChangeMstrObMgReMaterial _ChangeMstrObMgReMaterial
_ChangeMstrObMgReMatlBOM _ChangeMstrObMgReMatlBOM
_ChangeMstrObMgReDocInfoRecd _ChangeMstrObMgReDocInfoRecd
_LogAccMObjectTypeActive _LogAccMObjectTypeActive
_LogAccMObjectUserAuthzn _LogAccMObjectUserAuthzn
_LogAccMObjSecureIDAssgmt _LogAccMObjSecureIDAssgmt
_ChangeMasterLogAccMActive _ChangeMasterLogAccMActive
_ChgMstrLogAccMSecureIDAssgmt _ChgMstrLogAccMSecureIDAssgmt
_ChangeMstrLogAccMUserAuthzn _ChangeMstrLogAccMUserAuthzn
@AccessControl.authorizationCheck: #MANDATORY

@ObjectModel.representativeKey: 'ChangeNumber'
@ObjectModel.sapObjectNodeType.name: 'ChangeMaster'
@ObjectModel.semanticKey: [ 'ChangeNumber' ]
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.dataClass: #MASTER

@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type:#SAP_INTERNAL_API

@EndUserText.label: 'Change Number (Transactional Processsing)'
define root view entity I_ChangeMasterTP
  as select from I_ChangeMaster

  composition [1..*] of I_ChangeMasterAltDateTP        as _AlternativeDate
  composition [1..*] of I_ChangeMasterObjTypeAssgmtTP  as _ObjTypeAssignment
  composition [1..*] of I_ChangeMstrObjectMgmtRecordTP as _ChangeMstrObjectMgmtRecord
  composition [1..*] of I_ChangeMstrObMgReMaterialTP   as _ChangeMstrObMgReMaterial
  composition [1..*] of I_ChangeMstrObMgReMatlBOMTP    as _ChangeMstrObMgReMatlBOM
  composition [1..*] of I_ChgMstrObMgReDocInfoRecdTP   as _ChangeMstrObMgReDocInfoRecd
{
  key ChangeNumber,

      ChangeNumberStatus,

      AuthorizationGroup,

      ChangeNumberFunction,
      IsTechnicallyReleased,

      ChangeNumberReleaseKey,
      ReasonForChangeText,
      ChangeNumberDescription,
      ChangeNumberValidFromDate,

      ChangeNumberCreationDate,

      ChangeNumberCreatedByUser,

      ChangeNumberLastChangedDate,

      ChangeNumberLastChangedByUser,

      IsUsedForDataDefinition,

      ChangeNumberIsMrkdForDeletion,

      case
        when ChangeNumberLastChgdDateTime = fltp_to_dec( 0.0 as timestampl )
        then fltp_to_dec( 19720401000000.0 as timestampl )
        else ChangeNumberLastChgdDateTime
      end as ChangeNumberLastChgdDateTime,

      _ChangeNumberStatus,
      _AlternativeDate,
      _ObjTypeAssignment,
      _ChangeMstrObjectMgmtRecord,
      _ChangeMstrObMgReMaterial,
      _ChangeMstrObMgReMatlBOM,
      _ChangeMstrObMgReDocInfoRecd,

      // Access Control Management non C1 released, not used in DCL anymore

      @Consumption.hidden:true
      _LogAccMObjectTypeActive,
      @Consumption.hidden:true
      _LogAccMObjectUserAuthzn,
      @Consumption.hidden:true
      _LogAccMObjSecureIDAssgmt,

      // Access Control Management C1 released, used in DCL

      @Consumption.hidden:true
      _ChangeMasterLogAccMActive,
      @Consumption.hidden:true
      _ChgMstrLogAccMSecureIDAssgmt,
      @Consumption.hidden:true
      _ChangeMstrLogAccMUserAuthzn
}