P_PMPositionResponsibleBasic

DDL: P_PMPOSITIONRESPONSIBLEBASIC Type: view_entity BASIC
10 Fields 3 Data Sources

P_PMPositionResponsibleBasic is a Basic CDS View in SAP S/4HANA. It reads from 3 data sources (hrp1000, plogi, t77s0) and exposes 10 fields with key fields HCMPlanVersion, HCMObjectType, PositionResponsible, HCMPlanningStatus, StartDate.

Data Sources (3)

SourceAliasJoin Type
hrp1000 _hrp1000 inner
plogi _PLOGI from
t77s0 _t77s0 inner

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
VDM.private true view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY HCMPlanVersion hrp1000 plvar Plan version
KEY HCMObjectType hrp1000 otype Type of Val.
KEY PositionResponsible
KEY HCMPlanningStatus hrp1000 istat System status
KEY StartDate hrp1000 begda Valid From
KEY EndDate hrp1000 endda Valid To
KEY Language hrp1000 langu Primary lang.
HCMEmployeePositionText hrp1000 short Shortened form
HCMEmployeePositionLongText hrp1000 stext Text
HCMOrganizationalUnitText hrp1000_orgtext short Shortened form

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_PMPositionResponsibleBasic.
-- 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.

CREATE VIEW P_PMPositionResponsibleBasic AS
SELECT
  _hrp1000.plvar AS HCMPlanVersion,
  _hrp1000.otype AS HCMObjectType,
  cast(_hrp1000.objid as i_parnr ) AS PositionResponsible,
  _hrp1000.istat AS HCMPlanningStatus,
  _hrp1000.begda AS StartDate,
  _hrp1000.endda AS EndDate,
  _hrp1000.langu AS Language,
  _hrp1000.short AS HCMEmployeePositionText,
  _hrp1000.stext AS HCMEmployeePositionLongText,
  hrp1000_orgtext.short AS HCMOrganizationalUnitText
FROM plogi AS _PLOGI
INNER JOIN t77s0 AS _t77s0 ON /* join condition not captured in parsed metadata */
INNER JOIN hrp1000 AS _hrp1000 ON /* join condition not captured in parsed metadata */
;

Learn More