I_AllocationSegmentNoteTP

DDL: I_ALLOCATIONSEGMENTNOTETP SQL: ALLOSEGNTTP Type: view TRANSACTIONAL

Allocation segment note

I_AllocationSegmentNoteTP is a Transactional CDS View that provides data about "Allocation segment note" in SAP S/4HANA. It reads from 1 data source (I_AllocationSegmentNote) and exposes 7 fields with key fields AllocationType, AllocationCycle, AllocationCycleStartDate, AllocationCycleSegment. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_AllocationSegmentNote I_AllocationSegmentNote from

Associations (2)

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

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName ALLOSEGNTTP 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 segment note 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 ALLOSEGCYCTPD view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY AllocationType AllocationType
KEY AllocationCycle AllocationCycle
KEY AllocationCycleStartDate AllocationCycleStartDate
KEY AllocationCycleSegment AllocationCycleSegment
NoteText NoteText
_Segment _Segment
_Cycle _Cycle
@AbapCatalog.sqlViewName: 'ALLOSEGNTTP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking:#NOT_REQUIRED

@ClientHandling.algorithm: #SESSION_VARIABLE

@EndUserText.label: 'Allocation segment note'

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

@VDM.viewType: #TRANSACTIONAL
@ObjectModel:
{
  transactionalProcessingEnabled:true,
  writeDraftPersistence: 'ALLOSEGCYCTPD',
  semanticKey: ['AllocationType', 'AllocationCycle', 'AllocationCycleStartDate', 'AllocationCycleSegment'],
  createEnabled: true,
  updateEnabled: true,
  deleteEnabled: true
}
define view I_AllocationSegmentNoteTP
  as select from I_AllocationSegmentNote

  association [1..1] to I_AllocationSegmentTP as _Segment on  $projection.AllocationType           = _Segment.AllocationType
                                                          and $projection.AllocationCycle          = _Segment.AllocationCycle
                                                          and $projection.AllocationCycleStartDate = _Segment.AllocationCycleStartDate
                                                          and $projection.AllocationCycleSegment   = _Segment.AllocationCycleSegment

  association [1..1] to I_AllocationCycleTP   as _Cycle   on  $projection.AllocationType           = _Cycle.AllocationType
                                                          and $projection.AllocationCycle          = _Cycle.AllocationCycle
                                                          and $projection.AllocationCycleStartDate = _Cycle.AllocationCycleStartDate
{
      //I_AllocationSegmentNote

  key AllocationType,
  key AllocationCycle,
  key AllocationCycleStartDate,
  key AllocationCycleSegment,
      NoteText,

      @ObjectModel.association.type: #TO_COMPOSITION_PARENT
      _Segment,
      @ObjectModel.association.type: #TO_COMPOSITION_ROOT
      _Cycle
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ALLOCATIONSEGMENTNOTE"
],
"ASSOCIATED":
[
"I_ALLOCATIONCYCLETP",
"I_ALLOCATIONSEGMENTTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/