GHO_FC_PROJECT

Transparent Table Application Table
23 Fields 1 CDS Views

Project

GHO_FC_PROJECT is an SAP database table in S/4HANA. Project. It contains 23 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_GhoFcProjName_Db view from BASIC Forecast Project Name

Fields (23)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY project_id GHO_FC_PROJECT_ID Project Identity Num
project_name GHO_FC_PROJ_NAME Project Name
forecast_type GHO_FC_FCTYPE Forecast Type
forecast_date GHO_FC_DATE Forecast Date
eff_date_from GHO_FC_PROJ_EFF_DT_FROM Effective Start Date
eff_date_to GHO_FC_PROJ_EFF_DT_TO Effective End Date
status_profile GHO_DE_USER_STATUS_PROFILE User Status Profile
profile_id GHO_FC_PROFILE_ID Profile ID
project_description GHO_FC_PROJ_DESC Project Description
frequency_code GHO_ALLOC_FREQUENCY Frequency ID
time_zone GHO_FC_PROJ_TIME_ZONE Time Zone
status_object_no GHO_DE_OBJECT_NUMBER Object Number
fc_user_group_id GHO_FC_USER_GROUP_ID User Group ID
descript abap.char
stakeholder_group_id GHO_FC_USER_GROUP_ID User Group ID
created_by GHO_CREATED_BY Record Created By
created_tst GHO_DE_CREATED_ON Created On
changed_by GHO_CHANGED_BY Changed By
changed_tst GHO_DE_CHANGED_ON Changed On
basis_id GHO_FC_BASIS_ID Basis ID
project_name_uc GHO_FC_PROJ_NAME Project Name
project_description_uc GHO_FC_PROJ_DESC Project Description

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.

-- Project
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE GHO_FC_PROJECT (
    MANDT,                   -- Client [MANDT]
    PROJECT_ID,              -- Project Identity Num [GHO_FC_PROJECT_ID]
    PROJECT_NAME,            -- Project Name [GHO_FC_PROJ_NAME]
    FORECAST_TYPE,           -- Forecast Type [GHO_FC_FCTYPE]
    FORECAST_DATE,           -- Forecast Date [GHO_FC_DATE]
    EFF_DATE_FROM,           -- Effective Start Date [GHO_FC_PROJ_EFF_DT_FROM]
    EFF_DATE_TO,             -- Effective End Date [GHO_FC_PROJ_EFF_DT_TO]
    STATUS_PROFILE,          -- User Status Profile [GHO_DE_USER_STATUS_PROFILE]
    PROFILE_ID,              -- Profile ID [GHO_FC_PROFILE_ID]
    PROJECT_DESCRIPTION,     -- Project Description [GHO_FC_PROJ_DESC]
    FREQUENCY_CODE,          -- Frequency ID [GHO_ALLOC_FREQUENCY]
    TIME_ZONE,               -- Time Zone [GHO_FC_PROJ_TIME_ZONE]
    STATUS_OBJECT_NO,        -- Object Number [GHO_DE_OBJECT_NUMBER]
    FC_USER_GROUP_ID,        -- User Group ID [GHO_FC_USER_GROUP_ID]
    DESCRIPT,                -- abap.char
    STAKEHOLDER_GROUP_ID,    -- User Group ID [GHO_FC_USER_GROUP_ID]
    CREATED_BY,              -- Record Created By [GHO_CREATED_BY]
    CREATED_TST,             -- Created On [GHO_DE_CREATED_ON]
    CHANGED_BY,              -- Changed By [GHO_CHANGED_BY]
    CHANGED_TST,             -- Changed On [GHO_DE_CHANGED_ON]
    BASIS_ID,                -- Basis ID [GHO_FC_BASIS_ID]
    PROJECT_NAME_UC,         -- Project Name [GHO_FC_PROJ_NAME]
    PROJECT_DESCRIPTION_UC,  -- Project Description [GHO_FC_PROJ_DESC]
    PRIMARY KEY (MANDT, PROJECT_ID)
);

Learn More