P_RMSEmployeeDS

DDL: P_RMSEMPLOYEEDS SQL: PRMSEMPLOYEEDS Type: view BASIC
31 Fields 1 Data Sources

P_RMSEmployeeDS is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (pa0001) and exposes 31 fields with key field peras.

Data Sources (1)

SourceAliasJoin Type
pa0001 pa0001 from

Parameters (2)

NameTypeDefault
P_Date dats
P_Language sylangu

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PRMSEMPLOYEEDS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_ALLOWED view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view
VDM.viewType #BASIC view
VDM.private true view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY peras pa0001 pernr Personnel no.
bukrs pa0001 bukrs Value
bukrs_text t001 butxt Posting Text
werks pa0001 werks Receiving Plant
werks_text t500p name1 PA text
orgeh pa0001 orgeh Org. Unit
orgeh_text t527x orgtx Org.Unit Short Text
plans pa0001 plans Position
plans_text t528t plstx Position Short Text
stell pa0001 stell Job
stell_text t513s stltx Job Title
persg pa0001 persg EE group
persg_text t501t ptext Text for ItCat.
persk pa0001 persk EE subgroup
persk_text t503t ptext Text for ItCat.
vdsk1 pa0001 vdsk1 Org.key
gsber pa0001 gsber Business Area
gsber_text tgsbt gtext Description
btrtl pa0001 btrtl Pers. subarea
btrtl_text t001p btext Stock type
juper pa0001 juper Legal person
abkrs pa0001 abkrs Process. group
abkrs_text t549t atext Title
ansvh pa0001 ansvh Work contract
kostl pa0001 kostl Substitute CC
sname pa0001 sname User Name
ename pa0001 ename User Name
fistl pa0001 fistl Funds Center
geber pa0001 geber Fund
fkber pa0001 fkber Functional Area
sgmnt pa0001 sgmnt Segment

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 P_RMSEmployeeDS.
-- 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: PRMSEMPLOYEEDS
-- Parameters: P_Date : dats, P_Language : sylangu

CREATE VIEW P_RMSEmployeeDS AS
SELECT
  pa0001.pernr AS peras,
  pa0001.bukrs AS bukrs,
  t001.butxt AS bukrs_text,
  pa0001.werks AS werks,
  t500p.name1 AS werks_text,
  pa0001.orgeh AS orgeh,
  t527x.orgtx AS orgeh_text,
  pa0001.plans AS plans,
  t528t.plstx AS plans_text,
  pa0001.stell AS stell,
  t513s.stltx AS stell_text,
  pa0001.persg AS persg,
  t501t.ptext AS persg_text,
  pa0001.persk AS persk,
  t503t.ptext AS persk_text,
  pa0001.vdsk1 AS vdsk1,
  pa0001.gsber AS gsber,
  tgsbt.gtext AS gsber_text,
  pa0001.btrtl AS btrtl,
  t001p.btext AS btrtl_text,
  pa0001.juper AS juper,
  pa0001.abkrs AS abkrs,
  t549t.atext AS abkrs_text,
  pa0001.ansvh AS ansvh,
  pa0001.kostl AS kostl,
  pa0001.sname AS sname,
  pa0001.ename AS ename,
  pa0001.fistl AS fistl,
  pa0001.geber AS geber,
  pa0001.fkber AS fkber,
  pa0001.sgmnt AS sgmnt
FROM pa0001
;

Learn More