P_BSBW

DDL: P_BSBW SQL: PFIBSBW Type: view BASIC
12 Fields 2 Data Sources

P_BSBW is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (bsbw, t001) and exposes 12 fields with key fields bukrs, belnr, gjahr, buzei, curtp.

Data Sources (2)

SourceAliasJoin Type
bsbw bsbw from
t001 t001 inner

Annotations (8)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName PFIBSBW view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.buffering.status #NOT_ALLOWED view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY bukrs
KEY belnr SD Document
KEY gjahr Settlement Year
KEY buzei Posting View Item
KEY curtp Valuation Area
KEY bwber Valuation Area
KEY methd methd Val. Method
datum Valid to
waers
bwshb bwshb Valuation Diff.
kunnr Stock customer
koart Account type

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_BSBW.
-- 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: PFIBSBW

CREATE VIEW P_BSBW AS
SELECT
  cast( bsbw.bukrs as fis_bukrs preserving type ) AS bukrs,
  cast( belnr as farp_belnr_d preserving type ) AS belnr,
  cast( gjahr as fis_gjahr_no_conv preserving type ) AS gjahr,
  cast( buzei as fis_buzei preserving type ) AS buzei,
  cast( curtp as fins_curtype preserving type ) AS curtp,
  cast( bwber as fis_bwber preserving type ) AS bwber,
  methd,
  cast( datum as fis_valdate preserving type ) AS datum,
  cast( t001.waers as fis_hwaer preserving type ) AS waers,
  bwshb,
  cast( kunnr as fis_kunnr preserving type ) AS kunnr,
  cast( koart as fis_koart preserving type ) AS koart
FROM bsbw
INNER JOIN t001 ON /* join condition not captured in parsed metadata */
;

Learn More