P_WBRK_C_ValueHelp

DDL: P_WBRK_C_VALUEHELP SQL: PWBRKCVH Type: view BASIC

P_WBRK_C_ValueHelp is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (P_WBRK_Begru_Values, wbrk) and exposes 18 fields with key field wbeln.

Data Sources (2)

SourceAliasJoin Type
P_WBRK_Begru_Values P_WBRK_Begru_Values inner
wbrk wbrk from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PWBRKCVH view
VDM.viewType #BASIC view
VDM.private true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XXL view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
AbapCatalog.preserveKey true view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY wbeln wbrk wbeln
wrart wbrk wrart
lfart wbrk lfart
vkorg wbrk vkorg
vtweg wbrk vtweg
spart wbrk spart
bukrs wbrk bukrs
kunre wbrk kunre
kunrg wbrk kunrg
wfdat wbrk wfdat
erdat wbrk erdat
ernam wbrk ernam
xblnr wbrk xblnr
ekorg wbrk ekorg
ekgrp wbrk ekgrp
rfbsk wbrk rfbsk
kunre_begru P_WBRK_Begru_Values kunre_begru
kunrg_begru P_WBRK_Begru_Values kunrg_begru
@AbapCatalog.sqlViewName: 'PWBRKCVH'
@VDM.viewType: #BASIC
@VDM.private: true
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.sizeCategory: #XXL
@ClientHandling.type: #INHERITED
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #MANDATORY
@AbapCatalog.preserveKey:true
// Value help for Customer Settlement List (Settlement Document Category 'C')

define view P_WBRK_C_ValueHelp 

  as select from wbrk
     inner join P_WBRK_Begru_Values on wbrk.wbeln = P_WBRK_Begru_Values.wbeln

{
  key wbrk.wbeln                         as wbeln,
      wbrk.wrart                         as wrart,
      wbrk.lfart                         as lfart,
      wbrk.vkorg                         as vkorg,
      wbrk.vtweg                         as vtweg,
      wbrk.spart                         as spart,
      wbrk.bukrs                         as bukrs,
      wbrk.kunre                         as kunre,
      wbrk.kunrg                         as kunrg,
      wbrk.wfdat                         as wfdat,
      wbrk.erdat                         as erdat,
      wbrk.ernam                         as ernam,
      wbrk.xblnr                         as xblnr,
      wbrk.ekorg                         as ekorg,
      wbrk.ekgrp                         as ekgrp,
      wbrk.rfbsk                         as rfbsk,
      P_WBRK_Begru_Values.kunre_begru    as kunre_begru,
      P_WBRK_Begru_Values.kunrg_begru    as kunrg_begru
}
where  wdtyp = 'C'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_WBRK_BEGRU_VALUES",
"WBRK"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/