I_IHBMasterDataObjectComposite

DDL: I_IHBMASTERDATAOBJECTCOMPOSITE Type: view_entity COMPOSITE Package: IHB_COMMON

IHB Master Data Object Composite

I_IHBMasterDataObjectComposite is a Composite CDS View that provides data about "IHB Master Data Object Composite" in SAP S/4HANA. It reads from 1 data source (I_IHBMasterDataObject) and exposes 25 fields with key field IHBObjectUUID. It has 10 associations to related views. Part of development package IHB_COMMON.

1 data source(s) 25 fields

Data Sources (1)

SourceAliasJoin Type
I_IHBMasterDataObject I_IHBMasterDataObject from

Associations (10)

CardinalityTargetAliasCondition
[0..1] I_IHBAccountComposite _IHBAccount $projection.IHBObjectKeyUUID = _IHBAccount.IHBAccountUUID with default filter $projection.IHBObjectCategory = '40'
[0..1] I_IHBGroupType _IHBGroupType $projection.IHBObjectKeyUUID = _IHBGroupType.IHBGroupUUID with default filter $projection.IHBObjectCategory = '45' or $projection.IHBObjectCategory = '55'
[0..1] I_IHBObjectCategory _IHBObjectCategory $projection.IHBObjectCategory = _IHBObjectCategory.IHBObjectCategory
[0..1] I_IHBObjectReleaseStatus _IHBObjectReleaseStatus $projection.IHBReleaseStatus = _IHBObjectReleaseStatus.IHBReleaseStatus
[0..1] I_IHBObjectRelStsCriticality _IHBObjectRelStsCriticality $projection.IHBReleaseStatus = _IHBObjectRelStsCriticality.IHBReleaseStatus
[0..1] I_IHBMasterDataObjectComposite _IHBObjectParent $projection.IHBObjectReferenceUUID = _IHBObjectParent.IHBObjectUUID
[0..1] I_IHBMasterDataObjectComposite _IHBObjectChild $projection.IHBObjectUUID = _IHBObjectChild.IHBObjectReferenceUUID and $projection.IHBObjectUUID <> _IHBObjectChild.IHBObjectUUID
[0..1] I_User _CreatedBy $projection.IHBObjectCreatedByUser = _CreatedBy.UserID
[0..1] I_User _OpenedBy $projection.IHBObjectChangedByUser = _OpenedBy.UserID
[0..1] I_User _ReleasedBy $projection.IHBObjectReleasedByUser = _ReleasedBy.UserID

Annotations (4)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label IHB Master Data Object Composite view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY IHBObjectUUID IHBObjectUUID
IHBObjectReferenceUUID IHBObjectReferenceUUID
IHBObjectType IHBObjectType
IHBObjectCategory IHBObjectCategory
IHBObjectKeyUUID IHBObjectKeyUUID
IHBReleaseStatus IHBReleaseStatus
IHBObjectApprovalActivity IHBObjectApprovalActivity
IHBObjectDeadlineDateTime IHBObjectDeadlineDateTime
IHBObjectReleaseDateTime IHBObjectReleaseDateTime
IHBObjectReleasedByUser IHBObjectReleasedByUser
IHBObjectTotalChangedDateTime IHBObjectTotalChangedDateTime
IHBObjectCreatedDateTime IHBObjectCreatedDateTime
IHBObjectCreatedByUser IHBObjectCreatedByUser
IHBObjectChangedDateTime IHBObjectChangedDateTime
IHBObjectChangedByUser IHBObjectChangedByUser
_IHBAccount _IHBAccount
_IHBGroupType _IHBGroupType
_IHBObjectCategory _IHBObjectCategory
_IHBObjectReleaseStatus _IHBObjectReleaseStatus
_IHBObjectRelStsCriticality _IHBObjectRelStsCriticality
_IHBObjectParent _IHBObjectParent
_IHBObjectChild _IHBObjectChild
_CreatedBy _CreatedBy
_OpenedBy _OpenedBy
_ReleasedBy _ReleasedBy 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'IHB Master Data Object Composite'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.
  usageType: {
  serviceQuality: #C,
  sizeCategory: #M,
  dataClass: #MASTER
}
@VDM.viewType: #COMPOSITE

define view entity I_IHBMasterDataObjectComposite
  as select from I_IHBMasterDataObject
  association [0..1] to I_IHBAccountComposite          as _IHBAccount                 on  $projection.IHBObjectKeyUUID = _IHBAccount.IHBAccountUUID
  with default filter $projection.IHBObjectCategory = '40' //Account

  association [0..1] to I_IHBGroupType                 as _IHBGroupType               on  $projection.IHBObjectKeyUUID = _IHBGroupType.IHBGroupUUID
  with default filter $projection.IHBObjectCategory = '45'
               or     $projection.IHBObjectCategory = '55' //Group and Bank Area Group

  association [0..1] to I_IHBObjectCategory            as _IHBObjectCategory          on  $projection.IHBObjectCategory = _IHBObjectCategory.IHBObjectCategory
  association [0..1] to I_IHBObjectReleaseStatus       as _IHBObjectReleaseStatus     on  $projection.IHBReleaseStatus = _IHBObjectReleaseStatus.IHBReleaseStatus
  association [0..1] to I_IHBObjectRelStsCriticality   as _IHBObjectRelStsCriticality on  $projection.IHBReleaseStatus = _IHBObjectRelStsCriticality.IHBReleaseStatus
  association [0..1] to I_IHBMasterDataObjectComposite as _IHBObjectParent            on  $projection.IHBObjectReferenceUUID = _IHBObjectParent.IHBObjectUUID
  association [0..1] to I_IHBMasterDataObjectComposite as _IHBObjectChild             on  $projection.IHBObjectUUID =  _IHBObjectChild.IHBObjectReferenceUUID
                                                                                      and $projection.IHBObjectUUID <> _IHBObjectChild.IHBObjectUUID
  association [0..1] to I_User                         as _CreatedBy                  on  $projection.IHBObjectCreatedByUser = _CreatedBy.UserID
  association [0..1] to I_User                         as _OpenedBy                   on  $projection.IHBObjectChangedByUser = _OpenedBy.UserID
  association [0..1] to I_User                         as _ReleasedBy                 on  $projection.IHBObjectReleasedByUser = _ReleasedBy.UserID

{
  key IHBObjectUUID,

      IHBObjectReferenceUUID,
      IHBObjectType,
      IHBObjectCategory,
      IHBObjectKeyUUID,

      IHBReleaseStatus,
      IHBObjectApprovalActivity,
      IHBObjectDeadlineDateTime,
      IHBObjectReleaseDateTime,
      IHBObjectReleasedByUser,

      IHBObjectTotalChangedDateTime,
      IHBObjectCreatedDateTime,
      IHBObjectCreatedByUser,
      IHBObjectChangedDateTime,
      IHBObjectChangedByUser,
   
      _IHBAccount,
      _IHBGroupType,
      _IHBObjectCategory,
      _IHBObjectReleaseStatus,
      _IHBObjectRelStsCriticality,
      _IHBObjectParent,
      _IHBObjectChild,
      _CreatedBy,
      _OpenedBy,
      _ReleasedBy

}

Learn More