I_GhoFcProjName_Db

DDL: I_GHOFCPROJNAME_DB SQL: IGHOFCPRJNAMEDB Type: view BASIC

Forecast Project Name

I_GhoFcProjName_Db is a Basic CDS View (Dimension) that provides data about "Forecast Project Name" in SAP S/4HANA. It reads from 1 data source (gho_fc_project) and exposes 11 fields with key field UpstreamProjectID.

Data Sources (1)

SourceAliasJoin Type
gho_fc_project gho_fc_project from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IGHOFCPRJNAMEDB view
Analytics.dataExtraction.enabled true view
Analytics.dataCategory #DIMENSION view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.representativeKey UpstreamProjectID view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Forecast Project Name view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY UpstreamProjectID project_id Project UUID
ProjectName project_name Project Name
AllocationFrequencyCode frequency_code Frequency ID
UpstreamProjEffctvStartDate eff_date_from Link Eff Date From
UpstreamProjEffctvEndDate eff_date_to Nw Link Eff Date To
StatusProfile status_profile User Status Profile
UpstreamProfileID profile_id Text Profile
ProjectDescription project_description Short Description
DisplayTimeZone time_zone TimeZone
StatusObjectNumber status_object_no Object Number
UpstreamUserGroupID fc_user_group_id User Group ID

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 I_GhoFcProjName_Db.
-- 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: IGHOFCPRJNAMEDB

CREATE VIEW I_GhoFcProjName_Db AS
SELECT
  project_id AS UpstreamProjectID,
  project_name AS ProjectName,
  frequency_code AS AllocationFrequencyCode,
  eff_date_from AS UpstreamProjEffctvStartDate,
  eff_date_to AS UpstreamProjEffctvEndDate,
  status_profile AS StatusProfile,
  profile_id AS UpstreamProfileID,
  project_description AS ProjectDescription,
  time_zone AS DisplayTimeZone,
  status_object_no AS StatusObjectNumber,
  fc_user_group_id AS UpstreamUserGroupID
FROM gho_fc_project
;