OBEWHJoinOBEW

DDL: OBEWHJOINOBEW Type: view
16 Fields 1 Data Sources

OBEWH join OBEW

OBEWHJoinOBEW is a CDS View that provides data about "OBEWH join OBEW" in SAP S/4HANA. It reads from 1 data source (obewh) and exposes 16 fields with key fields mandt, matnr, bwkey, bwtar, sobkz.

Data Sources (1)

SourceAliasJoin Type
obewh obewh from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName OBEWHJOBEW view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
EndUserText.label OBEWH join OBEW 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 obewh mandt Editing Client
KEY matnr obewh matnr Vehicle Model
KEY bwkey obewh bwkey Valuation Area
KEY bwtar obewh bwtar Valuation Type
KEY sobkz obewh sobkz Special Stock
KEY lifnr obewh lifnr Vendor no.
KEY lfgja obewh lfgja Year Cur.Period
KEY lfmon obewh lfmon Current Period
poper
kaln1 obew kaln1 ProdCostEst.No.
fiscyearper
vprsv obewh vprsv Price control
verpr obewh verpr Moving price
stprs obewh stprs Standard price
peinh obewh peinh Unit of measure
bklas obewh 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 OBEWHJoinOBEW.
-- 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 OBEWHJoinOBEW AS
SELECT
  obewh.mandt AS mandt,
  obewh.matnr AS matnr,
  obewh.bwkey AS bwkey,
  obewh.bwtar AS bwtar,
  obewh.sobkz AS sobkz,
  obewh.lifnr AS lifnr,
  obewh.lfgja AS lfgja,
  obewh.lfmon AS lfmon,
  concat( '0', obewh.lfmon) AS poper,
  obew.kaln1 AS kaln1,
  concat( obewh.lfgja, concat( '0', obewh.lfmon ) ) AS fiscyearper,
  obewh.vprsv AS vprsv,
  obewh.verpr AS verpr,
  obewh.stprs AS stprs,
  obewh.peinh AS peinh,
  obewh.bklas AS bklas
FROM obewh
;

Learn More