V_VLKPA_LI

DDL: V_VLKPA_LI SQL: V_VLKPA_LI_CDS Type: view
15 Fields

supplier sub view for V_VLKPA

V_VLKPA_LI is a CDS View that provides data about "supplier sub view for V_VLKPA" in SAP S/4HANA.

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName V_VLKPA_LI_CDS view
EndUserText.label supplier sub view for V_VLKPA view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view

Fields (15)

KeyFieldSource TableSource FieldDescription
mandt likp mandt Editing Client
kunde vbpa lifnr Vendor no.
parvw vbpa parvw Task Processor
vstel likp vstel ShpPtDeparture
lfdat likp lfdat Delivery Date
vkorg likp vkorg SD Sales Org.
lfart likp lfart Settl Doc Type
kunnr vbpa_we kunnr Stock customer
kunag likp kunag Sold-to Party
ernam likp ernam User Name
vbeln likp vbeln SD Sched. Agmt
adrnr vbpa adrnr Sold-To Address
adrnr_we vbpa_we adrnr Sold-To Address
oid_extbol likp oid_extbol Extern.BOL no.
oid_miscdl likp oid_miscdl Miscell.del.no.

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_VLKPA_LI.
-- 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_VLKPA_LI_CDS

CREATE VIEW V_VLKPA_LI AS
SELECT
  likp.mandt AS mandt,
  vbpa.lifnr AS kunde,
  vbpa.parvw AS parvw,
  likp.vstel AS vstel,
  likp.lfdat AS lfdat,
  likp.vkorg AS vkorg,
  likp.lfart AS lfart,
  vbpa_we.kunnr AS kunnr,
  likp.kunag AS kunag,
  likp.ernam AS ernam,
  likp.vbeln AS vbeln,
  vbpa.adrnr AS adrnr,
  vbpa_we.adrnr AS adrnr_we,
  likp.oid_extbol AS oid_extbol,
  likp.oid_miscdl AS oid_miscdl
;

Learn More