SHSM_CN_LDST_SH_PT

DDL: SHSM_CN_LDST_SH_PT SQL: SHSMCNLDSTPT Type: view

Search for Standard WBS Elements via External Number

SHSM_CN_LDST_SH_PT is a CDS View that provides data about "Search for Standard WBS Elements via External Number" in SAP S/4HANA. It reads from 3 data sources (cnldst_shorttx, I_Standardwbselement, projs) and exposes 9 fields.

3 data source(s) 9 fields

Data Sources (3)

SourceAliasJoin Type
cnldst_shorttx cnldst_shorttx inner
I_Standardwbselement I_Standardwbselement from
projs projs inner

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName SHSMCNLDSTPT 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 Search for Standard WBS Elements via External Number view

Fields (9)

KeyFieldSource TableSource FieldDescription
PSPID
POSID I_Standardwbselement WBSElement
language cnldst_shorttx language
shorttext cnldst_shorttx shorttext
shorttextu cnldst_shorttx shorttextu
ApplicantCode ApplicantCode
ResponsiblePerson ResponsiblePerson
_ResponsiblePerson _ResponsiblePerson
_ProjectApplicant _ProjectApplicant 
@AbapCatalog.sqlViewName: 'SHSMCNLDSTPT'
@AbapCatalog.compiler.compareFilter: 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: 'Search for Standard WBS Elements via External Number'
define view SHSM_CN_LDST_SH_PT as select from I_Standardwbselement
            inner join cnldst_shorttx on  I_Standardwbselement.WBSElementObject = cnldst_shorttx.objnr
            inner join projs on I_Standardwbselement.ProjectInternalID = projs.pspnr
{
  I_Standardwbselement._Project.Project as PSPID,
  I_Standardwbselement.WBSElement as POSID,
  cnldst_shorttx.language,
  cnldst_shorttx.shorttext,
  cnldst_shorttx.shorttextu,
  @Consumption.hidden: true
  ApplicantCode,
  @Consumption.hidden: true
  ResponsiblePerson,
  @Consumption.hidden: true
  _ResponsiblePerson,
  @Consumption.hidden: true
  _ProjectApplicant
}where projs.inact = ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_STANDARDPROJECT",
"I_STANDARDWBSELEMENT",
"CNLDST_SHORTTX",
"PROJS"
],
"ASSOCIATED":
[
"I_PROJECTAPPLICANT",
"I_PROJECTRESPONSIBLEPERSON"
],
"BASE":
[
"I_STANDARDWBSELEMENT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More