SHSM_V_PRPMP

DDL: SHSM_V_PRPMP SQL: SHSMVPRPMP Type: view

cds view for search help PRPMP

SHSM_V_PRPMP is a CDS View that provides data about "cds view for search help PRPMP" in SAP S/4HANA. It reads from 3 data sources (I_WBSElement, proj, prps) and exposes 20 fields.

3 data source(s) 20 fields

Data Sources (3)

SourceAliasJoin Type
I_WBSElement I_WBSElement from
proj proj inner
prps prps inner

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName SHSMVPRPMP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.dataCategory #VALUE_HELP view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label cds view for search help PRPMP view

Fields (20)

KeyFieldSource TableSource FieldDescription
postu prps postu
post1 WBSDescription
poski WBSElementShortID
pspnr WBSElementInternalID
posid WBSElement
pspid proj pspid
psphi ProjectInternalID
ProjectType ProjectType
ControllingArea ControllingArea
ResponsibleCostCenter ResponsibleCostCenter
RespCostCenterControllingArea RespCostCenterControllingArea
ProfitCenter ProfitCenter
ApplicantCode ApplicantCode
FreeDefinedIndicator2 FreeDefinedIndicator2
ProjectInternalID ProjectInternalID
ResponsiblePerson ResponsiblePerson
ResponsiblePersonName ResponsiblePersonName
_Project _Project
_ProjectApplicant _ProjectApplicant
_ResponsiblePerson _ResponsiblePerson 
 @AbapCatalog.sqlViewName: 'SHSMVPRPMP'
@AbapCatalog.compiler.compareFilter: true
//@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@ClientHandling.algorithm : #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.dataCategory: #VALUE_HELP
@Metadata.ignorePropagatedAnnotations: true
@EndUserText.label: 'cds view for search help PRPMP'
define view SHSM_V_PRPMP as select from I_WBSElement
inner join   prps on prps.pspnr = WBSElementInternalID
inner join   proj on proj.pspnr = ProjectInternalID

 {
   prps.postu                     as postu,
   WBSDescription                 as post1,
   WBSElementShortID              as poski,
   WBSElementInternalID           as pspnr,
   WBSElement                     as posid,
   proj.pspid                     as pspid,
   ProjectInternalID              as psphi,
   
  @Consumption.hidden:true
  ProjectType,
  @Consumption.hidden:true
  ControllingArea,
  @Consumption.hidden:true
  ResponsibleCostCenter,
  @Consumption.hidden: true
  RespCostCenterControllingArea,
  @Consumption.hidden: true
  ProfitCenter,
  @Consumption.hidden: true
  ApplicantCode,
  @Consumption.hidden: true
  FreeDefinedIndicator2,
  @Consumption.hidden: true
  ProjectInternalID,
    @Consumption.hidden: true
  ResponsiblePerson,
  @Consumption.hidden: true
  ResponsiblePersonName,
  
  @Consumption.hidden: true
  _Project,
  @Consumption.hidden: true
  _ProjectApplicant,
  @Consumption.hidden: true
  _ResponsiblePerson
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_WBSELEMENT",
"PROJ",
"PRPS"
],
"ASSOCIATED":
[
"I_PROJECTAPPLICANT",
"I_PROJECTBYINTERNALKEY",
"I_PROJECTRESPONSIBLEPERSON"
],
"BASE":
[
"I_WBSELEMENT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More