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.

Data Sources (1)

SourceAliasJoin Type
dpr_entity_link dpr_entity_link from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IROLEENTITY view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey 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
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.representativeKey ReferencedObjectUUIDRaw 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
PlannedWorkQuantity work_effort
PlannedWorkQuantityUnit work_unit
@AbapCatalog.sqlViewName: 'IROLEENTITY'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@ObjectModel.usageType: { dataClass: #TRANSACTIONAL, serviceQuality: #A, sizeCategory: #XL }
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #MANDATORY
@ObjectModel.representativeKey: 'ReferencedObjectUUIDRaw'
@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,

      tstmp_to_dats( beg_tmstmp ,
                    abap_system_timezone( $session.client,'NULL' ),
                    $session.client,
                    'NULL' ) as PlannedStartDate,

      tstmp_to_dats( end_tmstmp ,
                    abap_system_timezone( $session.client,'NULL' ),
                    $session.client,
                    'NULL' ) as DevRoleTskAssgmtPlndFinishDate,
      work_effort            as PlannedWorkQuantity,
      work_unit              as PlannedWorkQuantityUnit

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