QBEWHJoinQBEW

DDL: QBEWHJOINQBEW Type: view Package: MBV_DB
16 Fields 1 Data Sources

QBEWH join QBEW

QBEWHJoinQBEW is a CDS View that provides data about "QBEWH join QBEW" in SAP S/4HANA. It reads from 1 data source (qbewh) and exposes 16 fields with key fields mandt, matnr, bwkey, bwtar, sobkz. Part of development package MBV_DB.

Data Sources (1)

SourceAliasJoin Type
qbewh qbewh from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName QBEWHJQBEW view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
EndUserText.label QBEWH join QBEW view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #AUTOMATED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XL view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY mandt qbewh mandt Editing Client
KEY matnr qbewh matnr Vehicle Model
KEY bwkey qbewh bwkey Valuation Area
KEY bwtar qbewh bwtar Valuation Type
KEY sobkz qbewh sobkz Special Stock
KEY pspnr qbewh pspnr WBS Element
KEY lfgja qbewh lfgja Year Cur.Period
KEY lfmon qbewh lfmon Current Period
poper
kaln1 qbew kaln1 ProdCostEst.No.
fiscyearper
vprsv qbewh vprsv Price control
verpr qbewh verpr Moving price
stprs qbewh stprs Standard price
peinh qbewh peinh Unit of measure
bklas qbewh bklas Valuation Class

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 QBEWHJoinQBEW.
-- 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 QBEWHJoinQBEW AS
SELECT
  qbewh.mandt AS mandt,
  qbewh.matnr AS matnr,
  qbewh.bwkey AS bwkey,
  qbewh.bwtar AS bwtar,
  qbewh.sobkz AS sobkz,
  qbewh.pspnr AS pspnr,
  qbewh.lfgja AS lfgja,
  qbewh.lfmon AS lfmon,
  concat( '0', qbewh.lfmon) AS poper,
  qbew.kaln1 AS kaln1,
  concat( qbewh.lfgja, concat( '0', qbewh.lfmon ) ) AS fiscyearper,
  qbewh.vprsv AS vprsv,
  qbewh.verpr AS verpr,
  qbewh.stprs AS stprs,
  qbewh.peinh AS peinh,
  qbewh.bklas AS bklas
FROM qbewh
;

Learn More