P_WBRL_ValueHelp
P_WBRL_ValueHelp is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (P_WBRK_Begru_Values, wbrl) and exposes 18 fields with key fields wbeln, posnr.
Data Sources (2)
| Source | Alias | Join Type |
|---|---|---|
| P_WBRK_Begru_Values | P_WBRK_Begru_Values | inner |
| wbrl | wbrl | from |
Annotations (11)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | PWBRLVH | 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | wbeln | wbrl | wbeln | Sett. Doc. List |
| KEY | posnr | wbrl | posnr | WBS Element |
| wbeln_lf | wbrl | wbeln_lf | Document | |
| lifre | wbrl | lifre | Location Alias | |
| lnrzb | wbrl | lnrzb | Payee | |
| kunre | wbrl | kunre | Bill-to Party | |
| kunrg | wbrl | kunrg | Payer | |
| ekorg | P_WBRK_Begru_Values | ekorg | Purchasing Org. | |
| ekgrp | P_WBRK_Begru_Values | ekgrp | Sub. purchasing grp | |
| vkorg | P_WBRK_Begru_Values | vkorg | SD Sales Org. | |
| vtweg | P_WBRK_Begru_Values | vtweg | RefDistCh-Cust/Mat. | |
| spart | P_WBRK_Begru_Values | spart | Source supplier | |
| bukrs | P_WBRK_Begru_Values | bukrs | Value | |
| lfart | P_WBRK_Begru_Values | lfart | Settl Doc Type | |
| lifre_begru | P_WBRK_Begru_Values | lifre_begru | ||
| lnrzb_begru | P_WBRK_Begru_Values | lnrzb_begru | ||
| kunre_begru | P_WBRK_Begru_Values | kunre_begru | ||
| kunrg_begru | P_WBRK_Begru_Values | kunrg_begru |
Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.
-- Derived SQL interpretation of CDS view P_WBRL_ValueHelp.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: PWBRLVH
CREATE VIEW P_WBRL_ValueHelp AS
SELECT
wbrl.wbeln AS wbeln,
wbrl.posnr AS posnr,
wbrl.wbeln_lf AS wbeln_lf,
wbrl.lifre AS lifre,
wbrl.lnrzb AS lnrzb,
wbrl.kunre AS kunre,
wbrl.kunrg AS kunrg,
P_WBRK_Begru_Values.ekorg AS ekorg,
P_WBRK_Begru_Values.ekgrp AS ekgrp,
P_WBRK_Begru_Values.vkorg AS vkorg,
P_WBRK_Begru_Values.vtweg AS vtweg,
P_WBRK_Begru_Values.spart AS spart,
P_WBRK_Begru_Values.bukrs AS bukrs,
P_WBRK_Begru_Values.lfart AS lfart,
P_WBRK_Begru_Values.lifre_begru AS lifre_begru,
P_WBRK_Begru_Values.lnrzb_begru AS lnrzb_begru,
P_WBRK_Begru_Values.kunre_begru AS kunre_begru,
P_WBRK_Begru_Values.kunrg_begru AS kunrg_begru
FROM wbrl
INNER JOIN P_WBRK_Begru_Values ON /* join condition not captured in parsed metadata */
;
Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- 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
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA