SHSM_SHP_VIEW_GDSI

DDL: SHSM_SHP_VIEW_GDSI SQL: SHSMSHPVIEWGDSI Type: view Package: LE_SHP_DB_INTERFACE

CDS-based Value Help Selection Method SHP_VIEW_GDSI

SHSM_SHP_VIEW_GDSI is a CDS View that provides data about "CDS-based Value Help Selection Method SHP_VIEW_GDSI" in SAP S/4HANA. It reads from 2 data sources (I_Customer, shp_idx_gdsi) and exposes 16 fields with key field vbeln. Part of development package LE_SHP_DB_INTERFACE.

2 data source(s) 16 fields

Data Sources (2)

SourceAliasJoin Type
I_Customer Customer inner
shp_idx_gdsi PostedGoodsIssue from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName SHSMSHPVIEWGDSI view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED 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-based Value Help Selection Method SHP_VIEW_GDSI view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY vbeln shp_idx_gdsi vbeln
vstel shp_idx_gdsi vstel
route shp_idx_gdsi route
kodat shp_idx_gdsi kodat
tddat shp_idx_gdsi tddat
lddat shp_idx_gdsi lddat
wadat shp_idx_gdsi wadat
lfdat shp_idx_gdsi lfdat
lifsk shp_idx_gdsi lifsk
lstel shp_idx_gdsi lstel
kunnr shp_idx_gdsi kunnr
anzpk shp_idx_gdsi anzpk
kostk shp_idx_gdsi kostk
lvstk shp_idx_gdsi lvstk
vbtyp shp_idx_gdsi vbtyp
BEGRU I_Customer AuthorizationGroup 
@AbapCatalog.sqlViewName: 'SHSMSHPVIEWGDSI'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #MANDATORY 
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@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-based Value Help Selection Method SHP_VIEW_GDSI'
define view SHSM_SHP_VIEW_GDSI
  as select from shp_idx_gdsi as PostedGoodsIssue
    inner join   I_Customer   as Customer on PostedGoodsIssue.kunnr = Customer.Customer
{
  key PostedGoodsIssue.vbeln,
      PostedGoodsIssue.vstel,
      PostedGoodsIssue.route,
      PostedGoodsIssue.kodat,
      PostedGoodsIssue.tddat,
      PostedGoodsIssue.lddat,
      PostedGoodsIssue.wadat,
      PostedGoodsIssue.lfdat,
      PostedGoodsIssue.lifsk,
      PostedGoodsIssue.lstel,
      PostedGoodsIssue.kunnr,
      PostedGoodsIssue.anzpk,
      PostedGoodsIssue.kostk,
      PostedGoodsIssue.lvstk,
      PostedGoodsIssue.vbtyp,
      Customer.AuthorizationGroup as BEGRU
}

Learn More