/CFG/WEBGUI_MAIN_INFO

DDL: /CFG/WEBGUI_MAIN_INFO SQL: /CFG/V_WGUI_INFO Type: view

Get Webguis for preset phase

/CFG/WEBGUI_MAIN_INFO is a CDS View that provides data about "Get Webguis for preset phase" in SAP S/4HANA. It reads from 4 data sources (/CFG/V_FILE_SOL_MIN_SEQ_VIEW, /cfg/webgui_h, /cfg/webgui_i, /smb/bb_img_sobj) and exposes 18 fields.

Data Sources (4)

SourceAliasJoin Type
/CFG/V_FILE_SOL_MIN_SEQ_VIEW /CFG/V_FILE_SOL_MIN_SEQ_VIEW inner
/cfg/webgui_h header from
/cfg/webgui_i Item inner
/smb/bb_img_sobj sobj inner

Parameters (1)

NameTypeDefault
p_mandt mandt

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName /CFG/V_WGUI_INFO view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality D view
ObjectModel.usageType.sizeCategory L view
ObjectModel.usageType.dataClass MIXED view
EndUserText.label Get Webguis for preset phase view

Fields (18)

KeyFieldSource TableSource FieldDescription
guid /cfg/webgui_h webgui_guid Internal GUID
solution_Id
activity_id /cfg/webgui_h activity_id IMG Activity
cust_obj /cfg/webgui_h cust_obj_name Customizing object
filename /smb/bb_img_sobj filename URL or Filenam Path
subobjname /smb/bb_img_sobj subobjname Table/View Name
preset /cfg/webgui_h preset Preset
explore /cfg/webgui_h explore Evaluate
realize /cfg/webgui_h realize Realize
deploy /cfg/webgui_h deploy Serialized JSON
run_phase /cfg/webgui_h run_phase Run Phase
availability /cfg/webgui_h cust_available Availabilty to Cust
mand_type /cfg/webgui_h is_required Required?
country_dep /cfg/webgui_h global_act Cntry/Reg. Dependent
external_id /cfg/webgui_h extrnal_id WEBGUI External ID
bbid /smb/bb_img_sobj bbid Building Block
objid /smb/bb_img_sobj objid Work Center
objty /smb/bb_img_sobj objty Prj. Obj. Type

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 /CFG/WEBGUI_MAIN_INFO.
-- 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: /CFG/V_WGUI_INFO
-- Parameters: p_mandt : mandt

CREATE VIEW /CFG/WEBGUI_MAIN_INFO AS
SELECT
  header.webgui_guid AS guid,
  :p_solution AS solution_Id,
  header.activity_id AS activity_id,
  header.cust_obj_name AS cust_obj,
  sobj.filename AS filename,
  sobj.subobjname AS subobjname,
  header.preset AS preset,
  header.explore AS explore,
  header.realize AS realize,
  header.deploy AS deploy,
  header.run_phase AS run_phase,
  header.cust_available AS availability,
  header.is_required AS mand_type,
  header.global_act AS country_dep,
  header.extrnal_id AS external_id,
  sobj.bbid AS bbid,
  sobj.objid AS objid,
  sobj.objty AS objty
FROM /cfg/webgui_h AS header
INNER JOIN /cfg/webgui_i AS Item ON /* join condition not captured in parsed metadata */
INNER JOIN /smb/bb_img_sobj AS sobj ON /* join condition not captured in parsed metadata */
INNER JOIN /CFG/V_FILE_SOL_MIN_SEQ_VIEW ON /* join condition not captured in parsed metadata */
;