V_WB2_VBRK_VBRP_1A_SB

DDL: V_WB2_VBRK_VBRP_1A_SB Type: view_entity
88 Fields 1 Data Sources

Addl Bus Vol from Billg Doc - Scale Base

V_WB2_VBRK_VBRP_1A_SB is a CDS View that provides data about "Addl Bus Vol from Billg Doc - Scale Base" in SAP S/4HANA. It reads from 1 data source (V_WB2_VBRK_VBRP_1_SB) and exposes 88 fields with key fields vbeln, posnr.

Data Sources (1)

SourceAliasJoin Type
V_WB2_VBRK_VBRP_1_SB V_WB2_VBRK_VBRP_1_SB from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Addl Bus Vol from Billg Doc - Scale Base view
ObjectModel.usageType.serviceQuality #P view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
Metadata.ignorePropagatedAnnotations true view

Fields (88)

KeyFieldSource TableSource FieldDescription
KEY vbeln vbeln SD Sched. Agmt
KEY posnr posnr WBS Element
fkart fkart Ship. cost type
waerk waerk Doc. Currency
vkorg vkorg SD Sales Org.
vtweg vtweg RefDistCh-Cust/Mat.
spart spart Source supplier
kunnr kunnr Stock customer
kunrg kunrg Payer
vbtyp vbtyp TSW Det.Doc typ
bukrs bukrs Value
fkdat fkdat Sett. Date
matnr matnr Vehicle Model
bonus bonus Volume Rebate Group
provg provg Time intvl key
kunwe kunwe Ship-to Party
vkont vkont Tech. CtrAcct
meins meins Valuation Unit
fklmg fklmg Bill.Qty in SKU
netwr netwr Value
mwsbp mwsbp Tax Amount
brtwr brtwr Gross value
kzwi1 kzwi1 Subtotal 1
kzwi2 kzwi2 Subtotal 2
kzwi3 kzwi3 Subtotal 3
kzwi4 kzwi4 Subtotal 4
kzwi5 kzwi5 Subtotal 5
kzwi6 kzwi6 Subtotal 6
bonba bonba Rebate Basis
prctr prctr Profit Centers
mvgr1 mvgr1 MaterialGroup 1
mvgr2 mvgr2 MaterialGroup 2
mvgr3 mvgr3 MaterialGroup 3
mvgr4 mvgr4 MaterialGroup 4
mvgr5 mvgr5 MaterialGroup 5
mwskz mwskz Tax Code
txjcd txjcd Tax Jurisdict.
matkl matkl Product Sold Group
fbuda fbuda Services Rendered Date
shkzg shkzg Returns
fkimg fkimg Invoiced Qty
vrkme vrkme UoM for SubItm CCD
ntgew ntgew Net Weight
brgew brgew Weight
gewei gewei Weight Unit
volum volum Volume
voleh voleh Volume Unit
gsber gsber Business Area
kostl kostl Substitute CC
werks werks Receiving Plant
vkgrp vkgrp Sales Group
vkbur vkbur Sales Office
augru augru Sales Document Reason
txdat_from txdat_from Tax Rate Valid-From
knumv knumv Doc. Condition
land1 land1 Trip Ctry/Reg
regio regio Resident Region
pmatn pmatn Pr. Ref. Matl
ps_psp_pnr ps_psp_pnr WBS Element
pospa pospa Partner Item
aufnr aufnr SettlementOrder
kondm kondm Mat. Price Grp
lftypv lftypv SourceDocCat
bupla bupla Business place
ref_type ref_type SettlmtRefDocCat
aubel aubel Trigger doc
aupos aupos Item
prsdt prsdt Pricing Date
tax_country tax_country Tax Ctry/Rgn
ref_type_2 ref_type_2 SettlmtAddlRefDocCat
ref_doc_nr_2 ref_doc_nr_2 SettlmtAddlRefDoc
stceg stceg VAT Reg. No.
stceg_l stceg_l Tax Dest. Cty/R
kvgr1 kvgr1 Customer Grp 1
kvgr2 kvgr2 Customer Grp 2
kvgr3 kvgr3 Customer Grp 3
kvgr4 kvgr4 Customer Grp 4
kvgr5 kvgr5 Customer Grp 5
kdgrp kdgrp Customer group
kdkg1 kdkg1 Condition grp 1
kdkg2 kdkg2 Condition grp 2
kdkg3 kdkg3 Condition grp 3
kdkg4 kdkg4 Condition grp 4
kdkg5 kdkg5 Condition grp 5
j_1tpbupl j_1tpbupl Branch Code
prodh prodh Prod. Hierarchy
bzirk bzirk Sales District
clrst clrst Clearing Status

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 V_WB2_VBRK_VBRP_1A_SB.
-- 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 V_WB2_VBRK_VBRP_1A_SB AS
SELECT
  vbeln,
  posnr,
  fkart,
  waerk,
  vkorg,
  vtweg,
  spart,
  kunnr,
  kunrg,
  vbtyp,
  bukrs,
  fkdat,
  matnr,
  bonus,
  provg,
  kunwe,
  vkont,
  meins,
  fklmg,
  netwr,
  mwsbp,
  brtwr,
  kzwi1,
  kzwi2,
  kzwi3,
  kzwi4,
  kzwi5,
  kzwi6,
  bonba,
  prctr,
  mvgr1,
  mvgr2,
  mvgr3,
  mvgr4,
  mvgr5,
  mwskz,
  txjcd,
  matkl,
  fbuda,
  shkzg,
  fkimg,
  vrkme,
  ntgew,
  brgew,
  gewei,
  volum,
  voleh,
  gsber,
  kostl,
  werks,
  vkgrp,
  vkbur,
  augru,
  txdat_from,
  knumv,
  land1,
  regio,
  pmatn,
  ps_psp_pnr,
  pospa,
  aufnr,
  kondm,
  lftypv,
  bupla,
  ref_type,
  aubel,
  aupos,
  prsdt,
  tax_country,
  ref_type_2,
  ref_doc_nr_2,
  stceg,
  stceg_l,
  kvgr1,
  kvgr2,
  kvgr3,
  kvgr4,
  kvgr5,
  kdgrp,
  kdkg1,
  kdkg2,
  kdkg3,
  kdkg4,
  kdkg5,
  j_1tpbupl,
  prodh,
  bzirk,
  clrst
FROM V_WB2_VBRK_VBRP_1_SB
;

Learn More