I_ShiftNoteReferenceObject

DDL: I_SHIFTNOTEREFERENCEOBJECT Type: view_entity COMPOSITE

Shift Note Reference Object

I_ShiftNoteReferenceObject is a Composite CDS View that provides data about "Shift Note Reference Object" in SAP S/4HANA. It reads from 3 data sources (I_GnrcObjectRelationshipLink, I_GnrcObjectRelationshipRole, I_GnrcObjectRelationshipRole) and exposes 5 fields with key field ShiftNoteID. It has 2 associations to related views.

3 data source(s) 5 fields

Data Sources (3)

SourceAliasJoin Type
I_GnrcObjectRelationshipLink BinRel from
I_GnrcObjectRelationshipRole RelRoles_Ref inner
I_GnrcObjectRelationshipRole RelRoles_ShN inner

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_ShiftNote _ShiftNote $projection.ShiftNoteID = _ShiftNote.ShiftNoteID
[0..*] I_BusinessObjTypeText _Text $projection.ShiftNoteReferenceObjectType = _Text.BusinessObjectType

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Shift Note Reference Object view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #NONE view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #COMPOSITE view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY ShiftNoteID
ShiftNoteReferenceObjectType I_GnrcObjectRelationshipRole GnrcObjRelshpRoleObjectType
ShiftNoteReferenceObjectKey I_GnrcObjectRelationshipRole GnrcObjRelshpRoleObjectKey
Associations_ShiftNote
_Text _Text 
@AccessControl.authorizationCheck: #NOT_REQUIRED //no personal or sensitive data

@EndUserText.label: 'Shift Note Reference Object'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.modelingPattern: #NONE
@ObjectModel.supportedCapabilities: [#CDS_MODELING_DATA_SOURCE, #SQL_DATA_SOURCE]
@ObjectModel.usageType: {serviceQuality: #B, sizeCategory: #XL, dataClass: #TRANSACTIONAL}
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@VDM.viewType: #COMPOSITE

/*+[hideWarning] { "IDS" : [ "CALCULATED_FIELD_CHECK" ]  } */
define view entity I_ShiftNoteReferenceObject
  as select from   I_GnrcObjectRelationshipLink as BinRel
    inner join     I_GnrcObjectRelationshipRole as RelRoles_ShN on RelRoles_ShN.GnrcObjectRelationshipRoleUUID = BinRel.GnrcObjRelationshipLinkRoleA
    inner join     I_GnrcObjectRelationshipRole as RelRoles_Ref on RelRoles_Ref.GnrcObjectRelationshipRoleUUID = BinRel.GnrcObjRelationshipLinkRoleB

    association [1..1] to I_ShiftNote           as _ShiftNote on $projection.ShiftNoteID = _ShiftNote.ShiftNoteID
    association [0..*] to I_BusinessObjTypeText as _Text      on $projection.ShiftNoteReferenceObjectType = _Text.BusinessObjectType

{
      @ObjectModel.text.association: '_Text'
  key cast( substring( RelRoles_ShN.GnrcObjRelshpRoleObjectKey,1,12 ) as cocf_sn_id preserving type) as ShiftNoteID,

      RelRoles_Ref.GnrcObjRelshpRoleObjectType                                                       as ShiftNoteReferenceObjectType,
      RelRoles_Ref.GnrcObjRelshpRoleObjectKey                                                        as ShiftNoteReferenceObjectKey,

      -- Associations
      _ShiftNote,
      _Text
}
where RelRoles_Ref.GnrcObjectRelationshipRoleType = 'SHIFTNOTER';

Learn More