P_WBRK_L_ValueHelp

DDL: P_WBRK_L_VALUEHELP SQL: PWBRKLVH Type: view BASIC

P_WBRK_L_ValueHelp is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (P_WBRK_Begru_Values, wbrk) and exposes 21 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 PWBRKLVH 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 (21)

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
wrart wbrk wrart
rfbsk wbrk rfbsk
bukrs wbrk bukrs
vkorg wbrk vkorg
vtweg wbrk vtweg
spart wbrk spart
process_type wbrk process_type
lifre_begru P_WBRK_Begru_Values lifre_begru
lnrzb_begru P_WBRK_Begru_Values lnrzb_begru
@AbapCatalog.sqlViewName: 'PWBRKLVH'
@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 Settlements (Settlement Document Category 'L')

define view P_WBRK_L_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.wrart                         as wrart,
     wbrk.rfbsk                         as rfbsk,
     wbrk.bukrs                         as bukrs,
     wbrk.vkorg                         as vkorg,
     wbrk.vtweg                         as vtweg,
     wbrk.spart                         as spart,
     wbrk.process_type                  as process_type,
     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 = 'L'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_WBRK_BEGRU_VALUES",
"WBRK"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/