I_DFS_StatusProfile

DDL: I_DFS_STATUSPROFILE SQL: IDFSSTSMA Type: view BASIC
2 Fields 1 Data Sources

Intf. View for Status Profiles

I_DFS_StatusProfile is a Basic CDS View that provides data about "Intf. View for Status Profiles" in SAP S/4HANA. It reads from 1 data source (tj21) and exposes 2 fields with key fields StatusProfile, StatusObjectCategory.

Data Sources (1)

SourceAliasJoin Type
tj21 tj21 from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IDFSSTSMA view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Intf. View for Status Profiles view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.resultSet.sizeCategory #XS view
ObjectModel.representativeKey StatusProfile view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY StatusProfile stsma Status Profile
KEY StatusObjectCategory obtyp Picking area

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_DFS_StatusProfile.
-- 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: IDFSSTSMA

CREATE VIEW I_DFS_StatusProfile AS
SELECT
  stsma AS StatusProfile,
  obtyp AS StatusObjectCategory
FROM tj21
;

Learn More