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