v_vlpma

DDL: V_VLPMA SQL: V_VLPMA_CDS Type: view
12 Fields 2 Data Sources

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

Data Sources (2)

SourceAliasJoin Type
likp likp from
vbpa vbpa left_outer

Annotations (4)

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

Fields (12)

KeyFieldSource TableSource FieldDescription
mandt likp mandt Editing Client
matnr lips matnr Vehicle Model
vstel likp vstel ShpPtDeparture
lfdat likp lfdat Delivery Date
vkorg likp vkorg SD Sales Org.
lfart likp lfart Settl Doc Type
kunnr vbpa kunnr Stock customer
kunag likp kunag Sold-to Party
ernam likp ernam User Name
vbeln likp vbeln SD Sched. Agmt
posnr lips posnr WBS Element
adrnr vbpa adrnr Sold-To Address

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_vlpma.
-- 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_VLPMA_CDS

CREATE VIEW v_vlpma AS
SELECT
  likp.mandt AS mandt,
  lips.matnr AS matnr,
  likp.vstel AS vstel,
  likp.lfdat AS lfdat,
  likp.vkorg AS vkorg,
  likp.lfart AS lfart,
  vbpa.kunnr AS kunnr,
  likp.kunag AS kunag,
  likp.ernam AS ernam,
  likp.vbeln AS vbeln,
  lips.posnr AS posnr,
  vbpa.adrnr AS adrnr
FROM likp
LEFT OUTER JOIN vbpa ON /* join condition not captured in parsed metadata */
;

Learn More