SHSM_M_PRSTS

DDL: SHSM_M_PRSTS SQL: SHSMMPRSTS Type: view

Generated view for matchcode ID PRST-S

SHSM_M_PRSTS is a CDS View that provides data about "Generated view for matchcode ID PRST-S" in SAP S/4HANA. It reads from 2 data sources (I_Standardwbselement, plpo) and exposes 13 fields.

2 data source(s) 13 fields

Data Sources (2)

SourceAliasJoin Type
I_Standardwbselement I_Standardwbselement from
plpo plpo inner

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName SHSMMPRSTS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Generated view for matchcode ID PRST-S 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
posid I_Standardwbselement WBSElement
plnty plpo plnty
plnnr plpo plnnr
plnkn plpo plnkn
zaehl plpo zaehl
vornr plpo vornr
ltxa1 plpo ltxa1
ControllingArea I_Standardwbselement ControllingArea
ProfitCenter I_Standardwbselement ProfitCenter
ApplicantCode I_Standardwbselement ApplicantCode
_ProjectApplicant I_Standardwbselement _ProjectApplicant
ResponsiblePerson I_Standardwbselement ResponsiblePerson
_ResponsiblePerson I_Standardwbselement _ResponsiblePerson 
@AbapCatalog.sqlViewName: 'SHSMMPRSTS'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Generated view for matchcode ID PRST-S'
@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_M_PRSTS
  as select from I_Standardwbselement
    inner join   plpo on I_Standardwbselement.WBSElementInternalID = plpo.pspnr
{
  I_Standardwbselement.WBSElement            as posid,
  plpo.plnty,
  plpo.plnnr,
  plpo.plnkn,
  plpo.zaehl,
  plpo.vornr,
  plpo.ltxa1,

  @Consumption.hidden: true
  I_Standardwbselement.ControllingArea,
  @Consumption.hidden: true
  I_Standardwbselement.ProfitCenter,
  @Consumption.hidden: true
  I_Standardwbselement.ApplicantCode,
  @Consumption.hidden: true
  I_Standardwbselement._ProjectApplicant,
  @Consumption.hidden: true
  I_Standardwbselement.ResponsiblePerson,
  @Consumption.hidden: true
  I_Standardwbselement._ResponsiblePerson
}
where
  plpo.plnty = '0'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_STANDARDWBSELEMENT",
"PLPO"
],
"ASSOCIATED":
[
"I_PROJECTAPPLICANT",
"I_PROJECTRESPONSIBLEPERSON"
],
"BASE":
[
"I_STANDARDWBSELEMENT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More