I_DevProjRoleEntityLink

DDL: I_DEVPROJROLEENTITYLINK SQL: IROLEENTITY Type: view BASIC

PPM Entity Link Table Details

I_DevProjRoleEntityLink is a Basic CDS View that provides data about "PPM Entity Link Table Details" in SAP S/4HANA. It reads from 1 data source (dpr_entity_link) and exposes 9 fields with key field ReferencedObjectUUIDRaw.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
dpr_entity_link dpr_entity_link from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IROLEENTITY view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.modelingPattern #NONE view
ObjectModel.representativeKey ReferencedObjectUUIDRaw view
Metadata.ignorePropagatedAnnotations true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label PPM Entity Link Table Details view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY ReferencedObjectUUIDRaw guid
DevProjElmntUUID entity_guid
BusinessPartnerUUID participant_guid
DevProjElmntObjectType entity_type
IsBusinessPartnerResponsible responsible
BusinessPartnerShadowRole concrete_role
clientNULLasPlannedStartDate Planned Start Date
PlannedWorkQuantity work_effort
PlannedWorkQuantityUnit work_unit 
@AbapCatalog.sqlViewName: 'IROLEENTITY'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@ObjectModel: {
    usageType: {
      dataClass:       #TRANSACTIONAL,
      serviceQuality:  #A,
      sizeCategory:    #XL
    },
    supportedCapabilities: [#SQL_DATA_SOURCE,
                            #CDS_MODELING_DATA_SOURCE,
                            #CDS_MODELING_ASSOCIATION_TARGET],
    modelingPattern: #NONE,
    representativeKey: 'ReferencedObjectUUIDRaw'
}
@Metadata.ignorePropagatedAnnotations:true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'PPM Entity Link Table Details'
define view I_DevProjRoleEntityLink
  as select from dpr_entity_link
{

  key guid                   as ReferencedObjectUUIDRaw,
      entity_guid            as DevProjElmntUUID,
      participant_guid       as BusinessPartnerUUID,
      entity_type            as DevProjElmntObjectType,
      responsible            as IsBusinessPartnerResponsible,
      concrete_role          as BusinessPartnerShadowRole,

      @EndUserText.label: 'Planned Start Date'
      tstmp_to_dats( beg_tmstmp ,
                    abap_system_timezone( $session.client,'NULL' ),
                    $session.client,
                    'NULL' ) as PlannedStartDate,

      @EndUserText.label: 'Task Assignment Planned Finish Date'
      tstmp_to_dats( end_tmstmp ,
                    abap_system_timezone( $session.client,'NULL' ),
                    $session.client,
                    'NULL' ) as DevRoleTskAssgmtPlndFinishDate,
      @Semantics.quantity.unitOfMeasure: 'PlannedWorkQuantityUnit'
      work_effort            as PlannedWorkQuantity,
      work_unit              as PlannedWorkQuantityUnit

}

Learn More