SAPObjectTypeVFSCategoryAll

DDL: SAPOBJECTTYPEVFSCATEGORYALL Type: view_entity

Data Source for VFS with Category

SAPObjectTypeVFSCategoryAll is a CDS View that provides data about "Data Source for VFS with Category" in SAP S/4HANA. It reads from 2 data sources (ront_header, Vfs_All) and exposes 20 fields.

Data Sources (2)

SourceAliasJoin Type
ront_header ront inner
Vfs_All vfs from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Data Source for VFS with Category view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view

Fields (20)

KeyFieldSource TableSource FieldDescription
object_type Vfs_All object_type Type
object_name Vfs_All object_name Technical Name
author Vfs_All author User Name
devclass Vfs_All devclass Package (Obsolete)
created_on Vfs_All created_on Variant created on
creation_day Vfs_All creation_day
masterlang Vfs_All masterlang Single-Character Flag
alias_type Vfs_All alias_type Payee Alias Type
alias_name Vfs_All alias_name Short Description
wb_type Vfs_All wb_type
full_type Vfs_All full_type
version Vfs_All version XML Vers.
fav_list Vfs_All fav_list Value Range ID
docu Vfs_All docu Schema Documentation
package_low Vfs_All package_low Value from
package_high Vfs_All package_high Value up to
ap_component Vfs_All ap_component Applic. Component
sw_component Vfs_All sw_component Softw. Comp.
tr_layer Vfs_All tr_layer Transport Layer
use_alias Vfs_All use_alias

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 SAPObjectTypeVFSCategoryAll.
-- 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.

CREATE VIEW SAPObjectTypeVFSCategoryAll AS
SELECT
  vfs.object_type AS object_type,
  vfs.object_name AS object_name,
  vfs.author AS author,
  vfs.devclass AS devclass,
  vfs.created_on AS created_on,
  vfs.creation_day AS creation_day,
  vfs.masterlang AS masterlang,
  vfs.alias_type AS alias_type,
  vfs.alias_name AS alias_name,
  vfs.wb_type AS wb_type,
  vfs.full_type AS full_type,
  vfs.version AS version,
  vfs.fav_list AS fav_list,
  vfs.docu AS docu,
  vfs.package_low AS package_low,
  vfs.package_high AS package_high,
  vfs.ap_component AS ap_component,
  vfs.sw_component AS sw_component,
  vfs.tr_layer AS tr_layer,
  vfs.use_alias AS use_alias
FROM Vfs_All AS vfs
INNER JOIN ront_header AS ront ON /* join condition not captured in parsed metadata */
;