P_EngmntProjDmndHdr

DDL: P_ENGMNTPROJDMNDHDR SQL: PENGPROJDMNDHDR Type: view BASIC
11 Fields 1 Data Sources

P_EngmntProjDmndHdr is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (/cpd/demand_hdr) and exposes 11 fields with key field demand_key.

Data Sources (1)

SourceAliasJoin Type
/cpd/demand_hdr /cpd/demand_hdr from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName PENGPROJDMNDHDR view
VDM.private true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY demand_key demand_key Demand Key
fp_key fp_key Financial Plann Key
mp_id mp_id Cust Project ID
wp_id wp_id Plan Item
status status Workflow Status
start_date start_date Valn start date
end_date end_date Valn End date
created_by created_by Version Created By
created_on Variant created on
changed_by changed_by User Name
changed_on Variant Changed on

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_EngmntProjDmndHdr.
-- 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: PENGPROJDMNDHDR

CREATE VIEW P_EngmntProjDmndHdr AS
SELECT
  demand_key,
  fp_key,
  mp_id,
  wp_id,
  status,
  start_date,
  end_date,
  created_by,
  cast( created_on as /cpd/cpm_createdon ) AS created_on,
  changed_by,
  cast( changed_on as /cpd/cpm_changedon ) AS changed_on
FROM /cpd/demand_hdr
;

Learn More