V_VAKPA_PE

DDL: V_VAKPA_PE SQL: V_VAKPA_PE_CDS Type: view
18 Fields

employee sub view for V_VAKPA

V_VAKPA_PE is a CDS View that provides data about "employee sub view for V_VAKPA" in SAP S/4HANA.

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName V_VAKPA_PE_CDS view
EndUserText.label employee sub view for V_VAKPA view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (18)

KeyFieldSource TableSource FieldDescription
mandt vbak mandt Editing Client
kunde
parvw vbpa parvw Task Processor
vkorg vbak vkorg SD Sales Org.
trvog vbak trvog Transact.Group
audat vbak audat Trans. Period End
vkbur vbak vkbur Sales Office
vkgrp vbak vkgrp Sales Group
vtweg vbak vtweg RefDistCh-Cust/Mat.
spart vbak spart Source supplier
auart vbak auart Sales Doc. Type
bstnk vbak bstnk Cust. Reference
kunnr vbpa_ag kunnr Stock customer
ernam vbak ernam User Name
vbeln vbak vbeln SD Sched. Agmt
adrnr_ag vbpa_ag adrnr Sold-To Address
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_VAKPA_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_VAKPA_PE_CDS

CREATE VIEW V_VAKPA_PE AS
SELECT
  vbak.mandt AS mandt,
  concat( '00', vbpa.pernr ) AS kunde,
  vbpa.parvw AS parvw,
  vbak.vkorg AS vkorg,
  vbak.trvog AS trvog,
  vbak.audat AS audat,
  vbak.vkbur AS vkbur,
  vbak.vkgrp AS vkgrp,
  vbak.vtweg AS vtweg,
  vbak.spart AS spart,
  vbak.auart AS auart,
  vbak.bstnk AS bstnk,
  vbpa_ag.kunnr AS kunnr,
  vbak.ernam AS ernam,
  vbak.vbeln AS vbeln,
  vbpa_ag.adrnr AS adrnr_ag,
  vbpa.adrnr AS adrnr,
  vbak.oipbl AS oipbl
;

Learn More