P_J_PDOBJECT

DDL: P_J_PDOBJECT SQL: PJPDOBJECT Type: view BASIC Package: VDM_WFD_WORK_FORCE
8 Fields 1 Data Sources

PD Object

P_J_PDOBJECT is a Basic CDS View that provides data about "PD Object" in SAP S/4HANA. It reads from 1 data source (wfd_d_jobcodet) and exposes 8 fields with key fields PlanVersion, ObjectType, ObjectID. Part of development package VDM_WFD_WORK_FORCE.

Data Sources (1)

SourceAliasJoin Type
wfd_d_jobcodet new from

Annotations (6)

NameValueLevelField
VDM.private true view
AbapCatalog.sqlViewName PJPDOBJECT view
VDM.viewType #BASIC view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY PlanVersion
KEY ObjectType
KEY ObjectID Job Code
ObjectStatus
StartDate start_date Valn start date
EndDate end_date Valn End date
Name Job Title
Language

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_J_PDOBJECT.
-- 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: PJPDOBJECT

CREATE VIEW P_J_PDOBJECT AS
SELECT
  '' AS PlanVersion,
  'C' AS ObjectType,
  cast( job_code as abap.numc( 8 ) ) AS ObjectID,
  '' AS ObjectStatus,
  start_date AS StartDate,
  end_date AS EndDate,
  cast( job_title as abap.char( 12 ) ) AS Name,
  coalesce( cast ($session.system_language as langu ), language ) AS Language
FROM wfd_d_jobcodet AS new
;

Learn More