P_WBRK_D_ValueHelp
P_WBRK_D_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.
Data Sources (2)
| Source | Alias | Join Type |
|---|---|---|
| P_WBRK_Begru_Values | P_WBRK_Begru_Values | inner |
| wbrk | wbrk | from |
Annotations (11)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | PWBRKDVH | 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | wbeln | wbrk | wbeln | |
| wrart | wbrk | wrart | ||
| wfdat | wbrk | wfdat | ||
| lnrzb | wbrk | lnrzb | ||
| ekorg | wbrk | ekorg | ||
| ekgrp | wbrk | ekgrp | ||
| vkorg | wbrk | vkorg | ||
| vtweg | wbrk | vtweg | ||
| spart | wbrk | spart | ||
| bukrs | wbrk | bukrs | ||
| erdat | wbrk | erdat | ||
| ernam | wbrk | ernam | ||
| lifre | wbrk | lifre | ||
| xblnr | wbrk | xblnr | ||
| lfart | wbrk | lfart | ||
| rfbsk | wbrk | rfbsk | ||
| process_type | wbrk | process_type | ||
| lifre_begru | P_WBRK_Begru_Values | lifre_begru | ||
| lnrzb_begru | P_WBRK_Begru_Values | lnrzb_begru |
@AbapCatalog.sqlViewName: 'PWBRKDVH'
@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 Settlement List (Settlement Document Category 'D')
define view P_WBRK_D_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.wfdat as wfdat,
wbrk.lnrzb as lnrzb,
wbrk.ekorg as ekorg,
wbrk.ekgrp as ekgrp,
wbrk.vkorg as vkorg,
wbrk.vtweg as vtweg,
wbrk.spart as spart,
wbrk.bukrs as bukrs,
wbrk.erdat as erdat,
wbrk.ernam as ernam,
wbrk.lifre as lifre,
wbrk.xblnr as xblnr,
wbrk.lfart as lfart,
wbrk.rfbsk as rfbsk,
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 = 'D'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_WBRK_BEGRU_VALUES",
"WBRK"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA