Vfs_Activation_State

DDL: VFS_ACTIVATION_STATE SQL: VFS8 Type: view

Activation state for virtual folders

Vfs_Activation_State is a CDS View that provides data about "Activation state for virtual folders" in SAP S/4HANA. It reads from 3 data sources (dwinactiv, dwinactiv, euobjedit) and exposes 12 fields.

Data Sources (3)

SourceAliasJoin Type
dwinactiv dwinactiv left_outer
dwinactiv dwinactiv left_outer
euobjedit euobjedit left_outer

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName VFS8 view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Activation state for virtual folders view

Fields (12)

KeyFieldSource TableSource FieldDescription
object_type object TRFM Object
object_name Sel.Type: Funct.Name
uname uname User Name
delet_flag delet_flag Single-Character Flag
inactive
object_name funcname Sel.Type: Funct.Name
uname uname User Name
delet_flag delet_flag Single-Character Flag
obj_nameFUGRasobject_type
uname uname User Name
delet_flag delet_flag Single-Character Flag
maintype

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 Vfs_Activation_State.
-- 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: VFS8

CREATE VIEW Vfs_Activation_State AS
SELECT
  object AS object_type,
  rtrim(left(obj_name, 30), '=') AS object_name,
  uname,
  delet_flag,
  'X' AS inactive,
  'FUNC' as maintype AS obj_nameFUGRasobject_type,
  'FUGR' AS maintype
LEFT OUTER JOIN euobjedit ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN dwinactiv ON /* join condition not captured in parsed metadata */
;