FINS_MPROJ_STAT

Transparent Table Application Table
19 Fields 5 CDS Views

Mass Data Project: Status Table

FINS_MPROJ_STAT is an SAP database table in S/4HANA. Mass Data Project: Status Table. It contains 19 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
fins_ic_proj view left_outer
FINS_MP_PROJ_STAT view left_outer Project Status (incl. generated)
fins_sif_proj view left_outer
fins_sis_proj view left_outer
FINSCDS_F4_MPROJST view left_outer Mass Data Project with Status

Fields (19)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY project_id fins_mproj_id Project ID
status_release fins_mproj_status_release Prep. Completed
status_start fins_mproj_status_start Started
status_end fins_mproj_status_end Completed
status_finish fins_mproj_status_finish Data Transf. Conf.
status_complete fins_mproj_status_complete Proj. Completed
time_release fins_mproj_release TS Prep. Completed
time_start fins_mproj_start TS DT Started
time_end fins_mproj_end TS DT Completed
time_finish fins_mproj_finish TS DT Conf.
time_complete fins_mproj_complete TS Proj. Completed
uname_release syuname User Name
uname_start syuname User Name
uname_end syuname User Name
uname_finish syuname User Name
uname_complete syuname User Name
driver_jobname btcjob Job Name
driver_jobcount btcjobcnt Job No.

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Mass Data Project: Status Table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FINS_MPROJ_STAT (
    MANDT,            -- Client [mandt]
    PROJECT_ID,       -- Project ID [fins_mproj_id]
    STATUS_RELEASE,   -- Prep. Completed [fins_mproj_status_release]
    STATUS_START,     -- Started [fins_mproj_status_start]
    STATUS_END,       -- Completed [fins_mproj_status_end]
    STATUS_FINISH,    -- Data Transf. Conf. [fins_mproj_status_finish]
    STATUS_COMPLETE,  -- Proj. Completed [fins_mproj_status_complete]
    TIME_RELEASE,     -- TS Prep. Completed [fins_mproj_release]
    TIME_START,       -- TS DT Started [fins_mproj_start]
    TIME_END,         -- TS DT Completed [fins_mproj_end]
    TIME_FINISH,      -- TS DT Conf. [fins_mproj_finish]
    TIME_COMPLETE,    -- TS Proj. Completed [fins_mproj_complete]
    UNAME_RELEASE,    -- User Name [syuname]
    UNAME_START,      -- User Name [syuname]
    UNAME_END,        -- User Name [syuname]
    UNAME_FINISH,     -- User Name [syuname]
    UNAME_COMPLETE,   -- User Name [syuname]
    DRIVER_JOBNAME,   -- Job Name [btcjob]
    DRIVER_JOBCOUNT,  -- Job No. [btcjobcnt]
    PRIMARY KEY (MANDT, PROJECT_ID)
);

Learn More