fsh_atp_vbbe_sel

DDL: FSH_ATP_VBBE_SEL SQL: FSH_V_ATP_VBBE_S Type: view

View for ATP_VBBE fields

fsh_atp_vbbe_sel is a CDS View that provides data about "View for ATP_VBBE fields" in SAP S/4HANA. It reads from 7 data sources and exposes 40 fields.

Data Sources (7)

SourceAliasJoin Type
fret f left_outer
fret f left_outer
atp_vbbe v from
atp_vbbe v union_all
vbup vb left_outer
vbup vb left_outer
vbfa vf left_outer

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName FSH_V_ATP_VBBE_S view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
EndUserText.label View for ATP_VBBE fields view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view

Fields (40)

KeyFieldSource TableSource FieldDescription
mandt atp_vbbe mandt Editing Client
vbeln atp_vbbe vbeln SD Sched. Agmt
posnr atp_vbbe posnr WBS Element
etenr atp_vbbe etenr Schedule Line
matnr atp_vbbe matnr Vehicle Model
werks atp_vbbe werks Receiving Plant
berid atp_vbbe berid Single-Character Flag
mbdat atp_vbbe mbdat Mat.Avail.Date
lgort atp_vbbe lgort Sublocation
charg atp_vbbe charg Chargeable Proc.
vbtyp atp_vbbe vbtyp TSW Det.Doc typ
omeng atp_vbbe omeng Open Quantity
vmeng atp_vbbe vmeng Received
meins atp_vbbe meins Valuation Unit
vbele atp_vbbe vbele Business docum.
posne atp_vbbe posne Items
kunnr atp_vbbe kunnr Stock customer
sobkz atp_vbbe sobkz Special Stock
pspel atp_vbbe pspel WBS Element
sgt_rcat atp_vbbe sgt_rcat Req. Segment
mandt Editing Client
vbeln atp_vbbe vbeln SD Sched. Agmt
posnr atp_vbbe posnr WBS Element
etenr atp_vbbe etenr Schedule Line
matnr atp_vbbe matnr Vehicle Model
werks atp_vbbe werks Receiving Plant
berid atp_vbbe berid Single-Character Flag
mbdat atp_vbbe mbdat Mat.Avail.Date
lgort atp_vbbe lgort Sublocation
charg atp_vbbe charg Chargeable Proc.
vbtyp atp_vbbe vbtyp TSW Det.Doc typ
omeng atp_vbbe omeng Open Quantity
vmeng atp_vbbe vmeng Received
meins atp_vbbe meins Valuation Unit
vbele atp_vbbe vbele Business docum.
posne atp_vbbe posne Items
kunnr atp_vbbe kunnr Stock customer
sobkz atp_vbbe sobkz Special Stock
pspel atp_vbbe pspel WBS Element
sgt_rcat atp_vbbe sgt_rcat Req. Segment

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 fsh_atp_vbbe_sel.
-- 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: FSH_V_ATP_VBBE_S

CREATE VIEW fsh_atp_vbbe_sel AS
SELECT
  v.mandt AS mandt,
  v.vbeln AS vbeln,
  v.posnr AS posnr,
  v.etenr AS etenr,
  v.matnr AS matnr,
  v.werks AS werks,
  v.berid AS berid,
  v.mbdat AS mbdat,
  v.lgort AS lgort,
  v.charg AS charg,
  v.vbtyp AS vbtyp,
  v.omeng AS omeng,
  v.vmeng AS vmeng,
  v.meins AS meins,
  v.vbele AS vbele,
  v.posne AS posne,
  v.kunnr AS kunnr,
  v.sobkz AS sobkz,
  v.pspel AS pspel,
  v.sgt_rcat AS sgt_rcat
FROM atp_vbbe AS v
LEFT OUTER JOIN fret AS f ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN vbup AS vb ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN vbfa AS vf ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): atp_vbbe
;