P_AllocTagObjectAssignment

DDL: P_ALLOCTAGOBJECTASSIGNMENT SQL: PALLOTAGASSIGNPA Type: view COMPOSITE

P_AllocTagObjectAssignment 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.

1 data source(s) 11 fields

Data Sources (1)

SourceAliasJoin Type
I_AllocTagObjectAssignment I_AllocTagObjectAssignment from

Annotations (12)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName PALLOTAGASSIGNPA view
Metadata.ignorePropagatedAnnotations true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.preserveKey true view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.private true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED 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
AllocationCreateDate AllocationCreateDate
AllocationTagChangedByUser AllocationTagChangedByUser
LastChangeDate LastChangeDate
LastChangeDateTime LastChangeDateTime 
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'PALLOTAGASSIGNPA'
@Metadata.ignorePropagatedAnnotations: true
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AbapCatalog.preserveKey:true
@AccessControl.personalData.blocking: #NOT_REQUIRED
@VDM.private: true
@VDM.viewType: #COMPOSITE
@ObjectModel: {
   usageType.serviceQuality: #C,
   usageType.sizeCategory: #S,
   usageType.dataClass: #MIXED
}
define view P_AllocTagObjectAssignment
//  with parameters

//    P_AllocationTagID :fco_tag_id


  as select from I_AllocTagObjectAssignment
{
      //I_AllocTagObjectAssignment

  key AllocationTagID,
  key AllocationType,
  key AllocationCycle,
  key AllocationCycleStartDate,
  key AllocationCycleSegment,
      AllocationTagCreatedByUser,
      CreationDateTime,
      AllocationCreateDate,
      AllocationTagChangedByUser,
      LastChangeDate,
      LastChangeDateTime
}
//where

//  I_AllocTagObjectAssignment.AllocationTagID = $parameters.P_AllocationTagID

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

Learn More