I_UniversalAllocationTag

DDL: I_UNIVERSALALLOCATIONTAG SQL: IUNIALLOCTAG Type: view BASIC

Universal Allocation Tag

I_UniversalAllocationTag is a Basic CDS View that provides data about "Universal Allocation Tag" in SAP S/4HANA. It reads from 1 data source (allotag) and exposes 10 fields with key field AllocationTagUUID. It has 1 association to related views.

1 data source(s) 10 fields

Data Sources (1)

SourceAliasJoin Type
allotag allotag from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_AllocationTagText _AllocationTagText $projection.AllocationTagUUID = _AllocationTagText.AllocationTagUUID and _AllocationTagText.Language = $session.system_language

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IUNIALLOCTAG view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Universal Allocation Tag view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #BASIC view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY AllocationTagUUID allocationtaguuid
AllocationTagID allocationtagid
AllocationTagDescription allocationtagdescription
AllocationTagNote allocationtagnote
AllocationTagCreatedByUser allocationtagcreatedbyuser
CreationDateTime creationdatetime
AllocationTagChangedByUser allocationtagchangedbyuser
LastChangeDateTime lastchangedatetime
AllocTagLastChangeDateTime
_AllocationTagText _AllocationTagText 
@AbapCatalog.sqlViewName: 'IUNIALLOCTAG'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking:#NOT_REQUIRED

@ClientHandling.algorithm: #SESSION_VARIABLE

@EndUserText.label: 'Universal Allocation Tag'

@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #M

@VDM.viewType: #BASIC
define view I_UniversalAllocationTag
  as select from allotag
  association [0..1] to I_AllocationTagText as _AllocationTagText on  $projection.AllocationTagUUID = _AllocationTagText.AllocationTagUUID
                                                                  and _AllocationTagText.Language   = $session.system_language
{
      //allotag

      @ObjectModel.text.association: '_AllocationTagText'
  key allocationtaguuid          as AllocationTagUUID,
      @ObjectModel.text.association: '_AllocationTagText'
      allocationtagid            as AllocationTagID,
      allocationtagdescription   as AllocationTagDescription,
      allocationtagnote          as AllocationTagNote,
      @Semantics.user.createdBy: true
      allocationtagcreatedbyuser as AllocationTagCreatedByUser,
      @Semantics.systemDateTime.createdAt: true
      creationdatetime           as CreationDateTime,
        
      case
        when allocationcreatedate is initial
          then cast( tstmp_to_dats( creationdatetime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as erfdt )
          else allocationcreatedate
      end                        as AllocationCreateDate,

      //      allocationcreatedate       as AllocationCreateDate,

      @Semantics.user.lastChangedBy: true
      allocationtagchangedbyuser as AllocationTagChangedByUser,
      @Semantics.systemDateTime.lastChangedAt: true
      lastchangedatetime         as LastChangeDateTime,
      cast( lastchangedatetime as fco_tag_changed_at_short )                          
                                 as AllocTagLastChangeDateTime,
      case
        when lastchangedate is initial
          then cast( tstmp_to_dats( creationdatetime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as aendt )
          else lastchangedate
      end                        as LastChangeDate,
      //      lastchangedate             as LastChangeDate,


      _AllocationTagText

}

Learn More