P_WBRK_A_ValueHelp

DDL: P_WBRK_A_VALUEHELP SQL: PWBRKAVH Type: view BASIC

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

2 data source(s) 19 fields

Data Sources (2)

SourceAliasJoin Type
P_WBRK_Begru_Values P_WBRK_Begru_Values inner
wbrk wbrk from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PWBRKAVH 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 (19)

KeyFieldSource TableSource FieldDescription
KEY wbeln wbrk wbeln
lfart wbrk lfart
lifre wbrk lifre
lnrzb wbrk lnrzb
ekorg wbrk ekorg
ekgrp wbrk ekgrp
wfdat wbrk wfdat
erdat wbrk erdat
ernam wbrk ernam
xblnr wbrk xblnr
zuonr wbrk zuonr
bldat wbrk bldat
rfbsk wbrk rfbsk
bukrs wbrk bukrs
vkorg wbrk vkorg
vtweg wbrk vtweg
spart wbrk spart
lifre_begru P_WBRK_Begru_Values lifre_begru
lnrzb_begru P_WBRK_Begru_Values lnrzb_begru 
@AbapCatalog.sqlViewName: 'PWBRKAVH'
@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 Supplier Billing Documents (Settlement Document Category 'A')

define view P_WBRK_A_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.lfart                           as lfart,
     wbrk.lifre                           as lifre,
     wbrk.lnrzb                           as lnrzb,
     wbrk.ekorg                           as ekorg,
     wbrk.ekgrp                           as ekgrp,
     wbrk.wfdat                           as wfdat,
     wbrk.erdat                           as erdat,
     wbrk.ernam                           as ernam,
     wbrk.xblnr                           as xblnr,
     wbrk.zuonr                           as zuonr,
     wbrk.bldat                           as bldat,
     wbrk.rfbsk                           as rfbsk,
     wbrk.bukrs                           as bukrs,
     wbrk.vkorg                           as vkorg,
     wbrk.vtweg                           as vtweg,
     wbrk.spart                           as spart,
      P_WBRK_Begru_Values.lifre_begru     as lifre_begru,
      P_WBRK_Begru_Values.lifnr_fi_begru  as lifnr_fi_begru,
      P_WBRK_Begru_Values.lnrzb_begru     as lnrzb_begru

}
  where wdtyp = 'A'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_WBRK_BEGRU_VALUES",
"WBRK"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More