What is FINSCDS_F4_MPROJST in SAP S/4HANA?

FINSCDS_F4_MPROJST is a cds CDS view in SAP S/4HANA. Mass Data Project with Status It contains 6 fields.

Which tables does FINSCDS_F4_MPROJST read from?

FINSCDS_F4_MPROJST reads data from: fins_mproj_stat, fins_mproj_typet, fins_mproject, fins_mprojectt.

FINSCDS_F4_MPROJST

DDL: FINSVD_F4_MPROJECT_ID_W_STATUS SQL: FINSV_F4_MPROJST Type: view

6 Fields 4 Data Sources

Mass Data Project with Status

FINSCDS_F4_MPROJST is a CDS View that provides data about "Mass Data Project with Status" in SAP S/4HANA. It reads from 4 data sources (fins_mproj_stat, fins_mproj_typet, fins_mproject, fins_mprojectt) and exposes 6 fields with key fields mandt, project_id.

Data Sources (4)

Source	Alias	Join Type
fins_mproj_stat	fins_mproj_stat	left_outer
fins_mproj_typet	fins_mproj_typet	left_outer
fins_mproject	fins_mproject	from
fins_mprojectt	fins_mprojectt	left_outer

Annotations (7)

Name	Value	Level
AbapCatalog.sqlViewName	FINSV_F4_MPROJST	view
ClientDependent	true	view
AbapCatalog.compiler.compareFilter	true	view
EndUserText.label	Mass Data Project with Status	view
ObjectModel.usageType.sizeCategory	#S	view
ObjectModel.usageType.dataClass	#MASTER	view
ObjectModel.usageType.serviceQuality	#C	view

Fields (6)

Key	Field	Source Table	Source Field	Description
KEY	mandt	fins_mproject	mandt	Editing Client
KEY	project_id	fins_mproject	project_id	Project UUID
	project_type	fins_mproject	project_type	Projecttype
	description	fins_mprojectt	description	Well Code Des.
	mandtNULLelseendascpudt
	mandtNULLelseendascputm

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 FINSCDS_F4_MPROJST.
-- 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: FINSV_F4_MPROJST

CREATE VIEW FINSCDS_F4_MPROJST AS
SELECT
  fins_mproject.mandt AS mandt,
  fins_mproject.project_id AS project_id,
  fins_mproject.project_type AS project_type,
  fins_mprojectt.description AS description,
  case when fins_mproj_stat.status_complete = 'X' then TSTMP_TO_DATS( fins_mproj_stat.time_complete, ABAP_SYSTEM_TIMEZONE( fins_mproj_stat.mandt, 'NULL' ), fins_mproj_stat.mandt, 'NULL' ) when fins_mproj_stat.status_finish = 'X' then TSTMP_TO_DATS( fins_mproj_stat.time_finish, ABAP_SYSTEM_TIMEZONE( fins_mproj_stat.mandt, 'NULL' ), fins_mproj_stat.mandt, 'NULL' ) when fins_mproj_stat.status_end = 'X' then TSTMP_TO_DATS( fins_mproj_stat.time_end, ABAP_SYSTEM_TIMEZONE( fins_mproj_stat.mandt, 'NULL' ), fins_mproj_stat.mandt, 'NULL' ) when fins_mproj_stat.status_start = 'X' then TSTMP_TO_DATS( fins_mproj_stat.time_start, ABAP_SYSTEM_TIMEZONE( fins_mproj_stat.mandt, 'NULL' ), fins_mproj_stat.mandt, 'NULL' ) when fins_mproj_stat.status_release = 'X' then TSTMP_TO_DATS( fins_mproj_stat.time_release, ABAP_SYSTEM_TIMEZONE( fins_mproj_stat.mandt, 'NULL' ), fins_mproj_stat.mandt, 'NULL' ) else '' end as cpudt AS mandtNULLelseendascpudt,
  case when fins_mproj_stat.status_complete = 'X' then TSTMP_TO_TIMS( fins_mproj_stat.time_complete, ABAP_SYSTEM_TIMEZONE( fins_mproj_stat.mandt, 'NULL' ), fins_mproj_stat.mandt, 'NULL' ) when fins_mproj_stat.status_finish = 'X' then TSTMP_TO_TIMS( fins_mproj_stat.time_finish, ABAP_SYSTEM_TIMEZONE( fins_mproj_stat.mandt, 'NULL' ), fins_mproj_stat.mandt, 'NULL' ) when fins_mproj_stat.status_end = 'X' then TSTMP_TO_TIMS( fins_mproj_stat.time_end, ABAP_SYSTEM_TIMEZONE( fins_mproj_stat.mandt, 'NULL' ), fins_mproj_stat.mandt, 'NULL' ) when fins_mproj_stat.status_start = 'X' then TSTMP_TO_TIMS( fins_mproj_stat.time_start, ABAP_SYSTEM_TIMEZONE( fins_mproj_stat.mandt, 'NULL' ), fins_mproj_stat.mandt, 'NULL' ) when fins_mproj_stat.status_release = 'X' then TSTMP_TO_TIMS( fins_mproj_stat.time_release, ABAP_SYSTEM_TIMEZONE( fins_mproj_stat.mandt, 'NULL' ), fins_mproj_stat.mandt, 'NULL' ) else '' end as cputm AS mandtNULLelseendascputm
FROM fins_mproject
LEFT OUTER JOIN fins_mproj_stat ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN fins_mproj_typet ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN fins_mprojectt ON /* join condition not captured in parsed metadata */
;

Depth:

FINSCDS_F4_MPROJST view