C_AllocTagSegmentAssignmentTP

DDL: C_ALLOCTAGSEGMENTASSIGNMENTTP SQL: CALLOCTAGSGMTTP Type: view CONSUMPTION Package: ODATA_MANAGE_ALLOCATION

Allocation Tag to Segment

C_AllocTagSegmentAssignmentTP is a Consumption CDS View that provides data about "Allocation Tag to Segment" in SAP S/4HANA. It reads from 1 data source (I_AllocTagSegmentAssignmentTP) and exposes 11 fields with key fields AllocationTagID, AllocationType, AllocationCycle, AllocationCycleStartDate, AllocationCycleSegment. It has 2 associations to related views. Part of development package ODATA_MANAGE_ALLOCATION.

Data Sources (1)

SourceAliasJoin Type
I_AllocTagSegmentAssignmentTP I_AllocTagSegmentAssignmentTP from

Associations (2)

CardinalityTargetAliasCondition
[1..1] C_AllocationCycleTP _Cycle $projection.AllocationType = _Cycle.AllocationType and $projection.AllocationCycle = _Cycle.AllocationCycle and $projection.AllocationCycleStartDate = _Cycle.AllocationCycleStartDate
[1..1] C_AllocationSegmentTP _Segment $projection.AllocationType = _Segment.AllocationType and $projection.AllocationCycle = _Segment.AllocationCycle and $projection.AllocationCycleStartDate = _Segment.AllocationCycleStartDate and $projection.AllocationCycleSegment = _Segment.AllocationCycleSegment

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName CALLOCTAGSGMTTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Allocation Tag to Segment view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #CONSUMPTION view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.draftEnabled true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY AllocationTagID AllocationTagID
KEY AllocationType AllocationType
KEY AllocationCycle AllocationCycle
KEY AllocationCycleStartDate AllocationCycleStartDate
KEY AllocationCycleSegment AllocationCycleSegment
AllocationTagCreatedByUser AllocationTagCreatedByUser
CreationDateTime CreationDateTime
AllocationTagChangedByUser AllocationTagChangedByUser
LastChangeDateTime LastChangeDateTime
_Cycle _Cycle
_Segment _Segment
@AbapCatalog.sqlViewName: 'CALLOCTAGSGMTTP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking:#NOT_REQUIRED

@ClientHandling.algorithm: #SESSION_VARIABLE

@EndUserText.label: 'Allocation Tag to Segment'

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

@VDM.viewType: #CONSUMPTION
@ObjectModel:
{
  transactionalProcessingDelegated: true,
  draftEnabled: true,
  createEnabled: true,
  updateEnabled: true,
  deleteEnabled: true
//  entityChangeStateId: 'LastChangeTime'

}
define view C_AllocTagSegmentAssignmentTP 
  as select from I_AllocTagSegmentAssignmentTP
  
  association [1..1] to C_AllocationCycleTP   as _Cycle           on  $projection.AllocationType           = _Cycle.AllocationType
                                                                  and $projection.AllocationCycle          = _Cycle.AllocationCycle
                                                                  and $projection.AllocationCycleStartDate = _Cycle.AllocationCycleStartDate
  
  association [1..1] to C_AllocationSegmentTP as _Segment          on  $projection.AllocationType           = _Segment.AllocationType
                                                                   and $projection.AllocationCycle          = _Segment.AllocationCycle
                                                                   and $projection.AllocationCycleStartDate = _Segment.AllocationCycleStartDate
                                                                   and $projection.AllocationCycleSegment   = _Segment.AllocationCycleSegment
{
  //I_AllocTagObjectAssignment

      @Consumption.valueHelpDefinition: [ { entity: { name: 'C_UniversalAllocationTagVH', element: 'AllocationTagID'  } } ]
  key AllocationTagID,
  key AllocationType,
  key AllocationCycle,
  key AllocationCycleStartDate,
  key AllocationCycleSegment,
      AllocationTagCreatedByUser,
      CreationDateTime,
      AllocationTagChangedByUser,
      LastChangeDateTime,
      
      //_Tag.AllocationTagDescription,

        
      @ObjectModel.association.type: #TO_COMPOSITION_ROOT
      _Cycle,
      
      @ObjectModel.association.type: #TO_COMPOSITION_PARENT
      _Segment
}