SHSM_V_PRPMA

DDL: SHSM_V_PRPMA SQL: SHSMVPRPMA Type: view

cds view for search help PRPMA

SHSM_V_PRPMA is a CDS View that provides data about "cds view for search help PRPMA" in SAP S/4HANA. It reads from 2 data sources (I_WBSElement, prps) and exposes 17 fields.

2 data source(s) 17 fields

Data Sources (2)

SourceAliasJoin Type
I_WBSElement I_WBSElement from
prps prps inner

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName SHSMVPRPMA 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 #L view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.dataCategory #VALUE_HELP view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label cds view for search help PRPMA view

Fields (17)

KeyFieldSource TableSource FieldDescription
posid WBSElement
post1 WBSDescription
postu prps postu
belkz WBSIsAccountAssignmentElement
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: 'SHSMVPRPMA'
@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: #L
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.dataCategory: #VALUE_HELP
@Metadata.ignorePropagatedAnnotations: true
@EndUserText.label: 'cds view for search help PRPMA'
define view SHSM_V_PRPMA as select from I_WBSElement 
inner join   prps on prps.pspnr = WBSElementInternalID
{
  WBSElement                     as posid,
  WBSDescription                 as post1,
  prps.postu                     as postu,
  WBSIsAccountAssignmentElement as belkz,
  
  @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 
}
where WBSIsAccountAssignmentElement <> ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_WBSELEMENT",
"PRPS"
],
"ASSOCIATED":
[
"I_PROJECTAPPLICANT",
"I_PROJECTBYINTERNALKEY",
"I_PROJECTRESPONSIBLEPERSON"
],
"BASE":
[
"I_WBSELEMENT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More