P_AllocationTagToCycle

DDL: P_ALLOCATIONTAGTOCYCLE SQL: PTAGTOCYCLE Type: view COMPOSITE

P_AllocationTagToCycle is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_AllocTagObjectAssignment) and exposes 11 fields with key fields AllocationTagID, AllocationType, AllocationCycle, AllocationCycleStartDate, AllocationCycleSegment. It has 2 associations to related views.

1 data source(s) 11 fields

Data Sources (1)

SourceAliasJoin Type
I_AllocTagObjectAssignment I_AllocTagObjectAssignment 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] I_UniversalAllocationTag _Tag $projection.AllocationTagID = _Tag.AllocationTagID

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PTAGTOCYCLE 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
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #COMPOSITE view
VDM.private 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
_Tag _Tag 
@AbapCatalog.sqlViewName: 'PTAGTOCYCLE'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

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

@ClientHandling.algorithm: #SESSION_VARIABLE

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

@VDM.viewType: #COMPOSITE
//@EndUserText.label: 'Allocation Tag To Cycle'

@VDM.private: true
define view P_AllocationTagToCycle
  as select from I_AllocTagObjectAssignment
  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 I_UniversalAllocationTag as _Tag   on  $projection.AllocationTagID = _Tag.AllocationTagID

{
      //I_AllocTagObjectAssignment     

  key AllocationTagID,
  key AllocationType,
  key AllocationCycle,
  key AllocationCycleStartDate,
  key AllocationCycleSegment,
      AllocationTagCreatedByUser,
      CreationDateTime,
      AllocationTagChangedByUser,
      LastChangeDateTime,
      //_Tag.AllocationTagDescription,

      _Cycle,
      _Tag
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ALLOCTAGOBJECTASSIGNMENT"
],
"ASSOCIATED":
[
"C_ALLOCATIONCYCLETP",
"I_UNIVERSALALLOCATIONTAG"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More