I_AllocTagObjectAssignmentTP

DDL: I_ALLOCTAGOBJECTASSIGNMENTTP SQL: ALLOCTAGOBJASTP Type: view TRANSACTIONAL

Allocation Tag Object Assignment - TP

I_AllocTagObjectAssignmentTP is a Transactional CDS View that provides data about "Allocation Tag Object Assignment - TP" in SAP S/4HANA. It reads from 1 data source (I_AllocTagObjectAssignment) and exposes 12 fields with key fields AllocationTagID, AllocationType, AllocationCycle, AllocationCycleStartDate, AllocationCycleSegment. It has 1 association to related views.

1 data source(s) 12 fields

Data Sources (1)

SourceAliasJoin Type
I_AllocTagObjectAssignment I_AllocTagObjectAssignment from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_AllocationCycleTP _Cycle $projection.AllocationType = _Cycle.AllocationType and $projection.AllocationCycle = _Cycle.AllocationCycle and $projection.AllocationCycleStartDate = _Cycle.AllocationCycleStartDate

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName ALLOCTAGOBJASTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Allocation Tag Object Assignment - TP view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #TRANSACTIONAL view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.writeDraftPersistence ALLOCTAGOJATPD view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY AllocationTagID AllocationTagID
KEY AllocationType AllocationType
KEY AllocationCycle AllocationCycle
KEY AllocationCycleStartDate AllocationCycleStartDate
KEY AllocationCycleSegment AllocationCycleSegment
AllocationTagCreatedByUser AllocationTagCreatedByUser
CreationDateTime CreationDateTime
AllocationCreateDate AllocationCreateDate
AllocationTagChangedByUser AllocationTagChangedByUser
LastChangeDateTime LastChangeDateTime
LastChangeDate LastChangeDate
_Cycle _Cycle 
@AbapCatalog.sqlViewName: 'ALLOCTAGOBJASTP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

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

@ClientHandling.algorithm: #SESSION_VARIABLE

@EndUserText.label: 'Allocation Tag Object Assignment - TP'

@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #M

@VDM.viewType: #TRANSACTIONAL
@ObjectModel:
{
  transactionalProcessingEnabled:true,
  writeDraftPersistence: 'ALLOCTAGOJATPD',
  semanticKey: ['AllocationTagID','AllocationType', 'AllocationCycle', 'AllocationCycleStartDate', 'AllocationCycleSegment'],
  createEnabled: true,
  updateEnabled: true,
  deleteEnabled: true
}
define view I_AllocTagObjectAssignmentTP 
  as select from I_AllocTagObjectAssignment 
  
  association [1..1] to I_AllocationCycleTP as _Cycle on  $projection.AllocationType           = _Cycle.AllocationType
                                                      and $projection.AllocationCycle          = _Cycle.AllocationCycle
                                                      and $projection.AllocationCycleStartDate = _Cycle.AllocationCycleStartDate
{
  key AllocationTagID,
  key AllocationType,
  key AllocationCycle,
  key AllocationCycleStartDate,
  key AllocationCycleSegment,
  AllocationTagCreatedByUser,
  CreationDateTime,
  AllocationCreateDate,
  AllocationTagChangedByUser,
  LastChangeDateTime,
  LastChangeDate,
  
  @ObjectModel.association.type:  [ #TO_COMPOSITION_ROOT, #TO_COMPOSITION_PARENT ]
  _Cycle
// Had to add this where clause due to FXUBRQ21-8608, as this CDS is used as CycleTag but without this, it contains segment entries

// That are not updated as segment tags are in different draft table

} where AllocationCycleSegment = '0000'

Learn More