v_vapma

DDL: V_VAPMA SQL: V_VAPMA_CDS Type: view
18 Fields 2 Data Sources

v_vapma is a CDS View in SAP S/4HANA. It reads from 2 data sources (vbak, vbpa) and exposes 18 fields.

Data Sources (2)

SourceAliasJoin Type
vbak vbak from
vbpa vbpa left_outer

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName V_VAPMA_CDS view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (18)

KeyFieldSource TableSource FieldDescription
mandt vbak mandt Editing Client
matnr vbap matnr Vehicle Model
vkorg vbak vkorg SD Sales Org.
trvog vbak trvog Transact.Group
audat vbak audat Trans. Period End
vtweg vbak vtweg RefDistCh-Cust/Mat.
spart vbak spart Source supplier
auart vbak auart Sales Doc. Type
kunnr vbak kunnr Stock customer
vkbur vbak vkbur Sales Office
vkgrp vbak vkgrp Sales Group
bstnk vbak bstnk Cust. Reference
ernam vbak ernam User Name
vbeln vbak vbeln SD Sched. Agmt
posnr vbap posnr WBS Element
werks vbap werks Receiving Plant
adrnr vbpa adrnr Sold-To Address
oipbl vbak oipbl Location ID

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_vapma.
-- 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: V_VAPMA_CDS

CREATE VIEW v_vapma AS
SELECT
  vbak.mandt AS mandt,
  vbap.matnr AS matnr,
  vbak.vkorg AS vkorg,
  vbak.trvog AS trvog,
  vbak.audat AS audat,
  vbak.vtweg AS vtweg,
  vbak.spart AS spart,
  vbak.auart AS auart,
  vbak.kunnr AS kunnr,
  vbak.vkbur AS vkbur,
  vbak.vkgrp AS vkgrp,
  vbak.bstnk AS bstnk,
  vbak.ernam AS ernam,
  vbak.vbeln AS vbeln,
  vbap.posnr AS posnr,
  vbap.werks AS werks,
  vbpa.adrnr AS adrnr,
  vbak.oipbl AS oipbl
FROM vbak
LEFT OUTER JOIN vbpa ON /* join condition not captured in parsed metadata */
;

Learn More