SHSM_V_PRSSW

DDL: SHSM_V_PRSSW SQL: SHSMVPRSSW Type: view

cds view for search help PRSSW

SHSM_V_PRSSW is a CDS View that provides data about "cds view for search help PRSSW" in SAP S/4HANA. It reads from 2 data sources (I_Standardproject, projs) and exposes 13 fields.

2 data source(s) 13 fields

Data Sources (2)

SourceAliasJoin Type
I_Standardproject I_Standardproject from
projs projs inner

Annotations (11)

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

Fields (13)

KeyFieldSource TableSource FieldDescription
pspid I_Standardproject Project
post1 I_Standardproject ProjectDescription
vernr I_Standardproject ResponsiblePerson
verna I_Standardproject ResponsiblePersonName
pspid_edit I_Standardproject ProjectWithCodingMask
postu projs postu
pspnr I_Standardproject ProjectInternalID
ControllingArea I_Standardproject ControllingArea
ProfitCenter I_Standardproject ProfitCenter
ApplicantCode I_Standardproject ApplicantCode
_ProjectApplicant I_Standardproject _ProjectApplicant
ResponsiblePerson I_Standardproject ResponsiblePerson
_ResponsiblePerson I_Standardproject _ResponsiblePerson 
@AbapCatalog.sqlViewName: 'SHSMVPRSSW'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'cds view for search help PRSSW'
@AccessControl.personalData.blocking: #REQUIRED
@ClientHandling.algorithm : #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.dataCategory: #VALUE_HELP
@Metadata.ignorePropagatedAnnotations: true

define view SHSM_V_PRSSW
  as select from I_Standardproject
    inner join   projs on I_Standardproject.ProjectInternalID = projs.pspnr
{
  I_Standardproject.Project               as pspid,
  I_Standardproject.ProjectDescription    as post1,
  I_Standardproject.ResponsiblePerson     as vernr,
  I_Standardproject.ResponsiblePersonName as verna,
  I_Standardproject.ProjectWithCodingMask as pspid_edit,
  projs.postu,
  I_Standardproject.ProjectInternalID     as pspnr,
  @Consumption.hidden: true
  I_Standardproject.ControllingArea,
  @Consumption.hidden: true
  I_Standardproject.ProfitCenter,
  @Consumption.hidden: true
  I_Standardproject.ApplicantCode,
  @Consumption.hidden: true
  I_Standardproject._ProjectApplicant,
  @Consumption.hidden: true
  I_Standardproject.ResponsiblePerson,
  @Consumption.hidden: true
  I_Standardproject._ResponsiblePerson

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

Learn More