FNDEI__cpd_d_mp_hdr_FILTER

DDL: FNDEI__CPD_D_MP_HDR_FILTER SQL: FNDEIFCPDD_MP_HD Type: view

Filter View for table /CPD/D_MP_HDR

FNDEI__cpd_d_mp_hdr_FILTER is a CDS View that provides data about "Filter View for table /CPD/D_MP_HDR" in SAP S/4HANA. It reads from 2 data sources (/cpd/d_mp_hdr, FNDEI__cpd_d_mp_hdr_BLOCKINGIN) and exposes 31 fields with key fields mandt, db_key.

Data Sources (2)

SourceAliasJoin Type
/cpd/d_mp_hdr /cpd/d_mp_hdr from
FNDEI__cpd_d_mp_hdr_BLOCKINGIN FNDEI__cpd_d_mp_hdr_BLOCKINGIN inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName FNDEIFCPDD_MP_HD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #AUTOMATED view
EndUserText.label Filter View for table /CPD/D_MP_HDR view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #B view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY mandt /cpd/d_mp_hdr mandt Editing Client
KEY db_key /cpd/d_mp_hdr db_key UUID
mp_id mp_id Cust Project ID
mp_type mp_type Mass Processing Type
mp_stage mp_stage Stage
start_date start_date Valn start date
end_date end_date Valn End date
customer customer Sold-to Party
org_id org_id Service Org.
confidential confidential Confidential
project_type project_type Projecttype
created_by created_by Version Created By
created_on created_on Variant created on
changed_by changed_by User Name
changed_on changed_on Variant Changed on
country country Venue: Ctry/Reg
region region Venue Region
active active Usage Active
work_type work_type Type of Work
industry industry Industry Sector
proj_risk proj_risk Project Risk
fin_risk fin_risk Financial Risk
tech_risk tech_risk Technical Risk
indic indic Progress
cr_relevant cr_relevant CR Planning
overall_risk overall_risk Project Risk
ey ey Proj.type
cost_center cost_center Posted Cost Center
template template TRUE
pm_bupa_id pm_bupa_id Business Partner
pm_bupa_name pm_bupa_name

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 FNDEI__cpd_d_mp_hdr_FILTER.
-- 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: FNDEIFCPDD_MP_HD

CREATE VIEW FNDEI__cpd_d_mp_hdr_FILTER AS
SELECT
  /cpd/d_mp_hdr.mandt AS mandt,
  /cpd/d_mp_hdr.db_key AS db_key,
  mp_id,
  mp_type,
  mp_stage,
  start_date,
  end_date,
  customer,
  org_id,
  confidential,
  project_type,
  created_by,
  created_on,
  changed_by,
  changed_on,
  country,
  region,
  active,
  work_type,
  industry,
  proj_risk,
  fin_risk,
  tech_risk,
  indic,
  cr_relevant,
  overall_risk,
  ey,
  cost_center,
  template,
  pm_bupa_id,
  pm_bupa_name
FROM /cpd/d_mp_hdr
INNER JOIN FNDEI__cpd_d_mp_hdr_BLOCKINGIN ON /* join condition not captured in parsed metadata */
;