V_VLKPA_PE

DDL: V_VLKPA_PE SQL: V_VLKPA_PE_CDS Type: view Package: VL
15 Fields

employee sub view for V_VLKPA

V_VLKPA_PE is a CDS View that provides data about "employee sub view for V_VLKPA" in SAP S/4HANA. Part of development package VL.

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName V_VLKPA_PE_CDS view
EndUserText.label employee 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
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_PE.
-- 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_PE_CDS

CREATE VIEW V_VLKPA_PE AS
SELECT
  likp.mandt AS mandt,
  concat( '00', vbpa.pernr ) 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