I_PlanSkillTags

DDL: I_PLANSKILLTAGS SQL: IPLANSKILLTAG Type: view BASIC Package: CPD_CDS

Planned Skill Tags

I_PlanSkillTags is a Basic CDS View that provides data about "Planned Skill Tags" in SAP S/4HANA. It reads from 1 data source (/cpd/pln_skiltag) and exposes 6 fields with key field PlanSkillTagUUID. It has 1 association to related views. Part of development package CPD_CDS.

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
/cpd/pln_skiltag PlanSkillTags from

Associations (1)

CardinalityTargetAliasCondition
[1] I_EngmntProjDmndHdr _EngmntProjDmndHdr _EngmntProjDmndHdr.ResourceDemandUUID = $projection.ResourceDemandUUID

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IPLANSKILLTAG view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Planned Skill Tags view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY PlanSkillTagUUID /cpd/pln_skiltag skilltag_key
ResourceDemandUUID /cpd/pln_skiltag demand_key
PlanSkillTagType /cpd/pln_skiltag skilltag_type
PlanSkillTagDescription /cpd/pln_skiltag skilltag_desc
EngagementProject _EngmntProjDmndHdr EngagementProject
_EngagementProject _EngmntProjDmndHdr _EngagementProject 
@AbapCatalog.sqlViewName: 'IPLANSKILLTAG'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Planned Skill Tags'
@ObjectModel.alternativeKey: [{ id: 'ResourceDemandUUID' }]
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L

define view I_PlanSkillTags
  as select from /cpd/pln_skiltag as PlanSkillTags

  association [1] to I_EngmntProjDmndHdr as _EngmntProjDmndHdr on _EngmntProjDmndHdr.ResourceDemandUUID = $projection.ResourceDemandUUID
{

  key  PlanSkillTags.skilltag_key            as PlanSkillTagUUID,
       PlanSkillTags.demand_key              as ResourceDemandUUID,

       PlanSkillTags.skilltag_type           as PlanSkillTagType,
       PlanSkillTags.skilltag_desc           as PlanSkillTagDescription,

       @Consumption.hidden: true
       _EngmntProjDmndHdr.EngagementProject  as EngagementProject,
                
       // Association for DCL 

       _EngmntProjDmndHdr._EngagementProject as _EngagementProject
}

Learn More