P_WBRK_Open_ValueHelp
Value Help for open Settlement Documents of any Category
P_WBRK_Open_ValueHelp is a Basic CDS View that provides data about "Value Help for open Settlement Documents of any Category" in SAP S/4HANA. It reads from 2 data sources (P_WBRK_Begru_Values, wbrk) and exposes 30 fields with key field wbeln. Part of development package WLF_FS_PERS_COMMON.
Data Sources (2)
| Source | Alias | Join Type |
|---|---|---|
| P_WBRK_Begru_Values | P_WBRK_Begru_Values | inner |
| wbrk | wbrk | from |
Annotations (12)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | PWBRKOPENVH | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AccessControl.authorizationCheck | #MANDATORY | view | |
| ObjectModel.usageType.serviceQuality | #A | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ObjectModel.usageType.sizeCategory | #XXL | view | |
| ClientHandling.type | #INHERITED | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| VDM.viewType | #BASIC | view | |
| VDM.private | true | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| Metadata.allowExtensions | false | view |
Fields (30)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | wbeln | wbrk | wbeln | Sett. Doc. List |
| wdtyp | wbrk | wdtyp | Doc. Category | |
| vkorg | wbrk | vkorg | SD Sales Org. | |
| vtweg | wbrk | vtweg | RefDistCh-Cust/Mat. | |
| spart | wbrk | spart | Source supplier | |
| ekorg | wbrk | ekorg | Purchasing Org. | |
| ekgrp | wbrk | ekgrp | Sub. purchasing grp | |
| bukrs | ||||
| lifre | wbrk | lifre | Location Alias | |
| kunre | wbrk | kunre | Bill-to Party | |
| lnrzb | wbrk | lnrzb | Payee | |
| kunrg | wbrk | kunrg | Payer | |
| erdat | ||||
| ernam | ||||
| bldat | wbrk | bldat | Journal Entry Date | |
| wfdat | wbrk | wfdat | Posting Date | |
| lfart | ||||
| wrart | ||||
| xblnr | wbrk | xblnr | Reference | |
| zuonr | wbrk | zuonr | Finance Project | |
| process_type | wbrk | process_type | Type of Data | |
| pernr | wbrk | pernr | Personnel no. | |
| pers_kostl | wbrk | pers_kostl | Worker Cost Center | |
| settl_party | wbrk | settl_party | Settlmt Part Cat | |
| bukrs_deb | wbrk | bukrs_deb | Cust. Company Code | |
| 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 | ||
| pernr_begru | P_WBRK_Begru_Values | pernr_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_WBRK_Open_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.
CREATE VIEW P_WBRK_Open_ValueHelp AS
SELECT
wbrk.wbeln AS wbeln,
wbrk.wdtyp AS wdtyp,
wbrk.vkorg AS vkorg,
wbrk.vtweg AS vtweg,
wbrk.spart AS spart,
wbrk.ekorg AS ekorg,
wbrk.ekgrp AS ekgrp,
cast( wbrk.bukrs as bukrs preserving type ) AS bukrs,
wbrk.lifre AS lifre,
wbrk.kunre AS kunre,
wbrk.lnrzb AS lnrzb,
wbrk.kunrg AS kunrg,
cast( wbrk.erdat as erdat preserving type ) AS erdat,
cast( wbrk.ernam as ernam preserving type ) AS ernam,
wbrk.bldat AS bldat,
wbrk.wfdat AS wfdat,
cast( wbrk.lfart as wfart preserving type ) AS lfart,
cast( wbrk.wrart as wrart preserving type ) AS wrart,
wbrk.xblnr AS xblnr,
wbrk.zuonr AS zuonr,
wbrk.process_type AS process_type,
wbrk.pernr AS pernr,
wbrk.pers_kostl AS pers_kostl,
wbrk.settl_party AS settl_party,
wbrk.bukrs_deb AS bukrs_deb,
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,
P_WBRK_Begru_Values.pernr_begru AS pernr_begru
FROM wbrk
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