SHSM_SHP_VIEW_ROGR

DDL: SHSM_SHP_VIEW_ROGR SQL: SHSMSHPVIEWROGR Type: view Package: LE_SHP_DB_INTERFACE

CDS-based Value Help Selection Method SHP_VIEW_ROGR

SHSM_SHP_VIEW_ROGR is a CDS View that provides data about "CDS-based Value Help Selection Method SHP_VIEW_ROGR" in SAP S/4HANA. It reads from 2 data sources (shp_idx_rogr, I_Supplier) and exposes 7 fields with key field vbeln. It has 1 association to related views. Part of development package LE_SHP_DB_INTERFACE.

2 data source(s) 7 fields

Data Sources (2)

SourceAliasJoin Type
shp_idx_rogr RoughGoodsReceipt from
I_Supplier Supplier inner

Associations (1)

CardinalityTargetAliasCondition
[1] likp _Delivery _Delivery.vbeln = RoughGoodsReceipt.vbeln

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName SHSMSHPVIEWROGR view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S 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_ROGR view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY vbeln shp_idx_rogr vbeln
lifnr shp_idx_rogr lifnr
lfdat shp_idx_rogr lfdat
werks shp_idx_rogr werks
verur shp_idx_rogr verur
BEGRU I_Supplier AuthorizationGroup
vstel _Delivery vstel 
@AbapCatalog.sqlViewName: 'SHSMSHPVIEWROGR'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@ClientHandling.algorithm : #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.dataCategory: #VALUE_HELP
@Metadata.ignorePropagatedAnnotations: true

@EndUserText.label: 'CDS-based Value Help Selection Method SHP_VIEW_ROGR'
define view SHSM_SHP_VIEW_ROGR
  as select from shp_idx_rogr as RoughGoodsReceipt
    inner join   I_Supplier   as Supplier on RoughGoodsReceipt.lifnr = Supplier.Supplier
  association [1] to likp as _Delivery on _Delivery.vbeln = RoughGoodsReceipt.vbeln
{
  key RoughGoodsReceipt.vbeln,
      RoughGoodsReceipt.lifnr,
      RoughGoodsReceipt.lfdat,
      RoughGoodsReceipt.werks,
      RoughGoodsReceipt.verur,
      Supplier.AuthorizationGroup as BEGRU,

      @Consumption.hidden: true
      _Delivery.vstel
}

Learn More