P_TSTC_USOBHASH

DDL: P_TSTC_USOBHASH Type: view_entity Package: STRAN_DT
8 Fields 1 Data Sources

Transaction Service

P_TSTC_USOBHASH is a CDS View that provides data about "Transaction Service" in SAP S/4HANA. It reads from 1 data source (tstc_usobhash) and exposes 8 fields with key fields tcode, name, type. Part of development package STRAN_DT.

Data Sources (1)

SourceAliasJoin Type
tstc_usobhash TSTC_USOBHASH from

Annotations (3)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Transaction Service view
Metadata.ignorePropagatedAnnotations true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY tcode tstc_usobhash tcode Undefined range (can be used for patch levels)
KEY name tstc_usobhash name Zone name
KEY type tstc_usobhash type Worklist Type
pgmid tstc_usobhash pgmid Program Name
object tstc_usobhash object TRFM Object
obj_name tstc_usobhash obj_name Object Name
service_type tstc_usobhash service_type Type of Ext. Service
service tstc_usobhash service Service 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 P_TSTC_USOBHASH.
-- 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 P_TSTC_USOBHASH AS
SELECT
  tstc_usobhash.tcode AS tcode,
  tstc_usobhash.name AS name,
  tstc_usobhash.type AS type,
  tstc_usobhash.pgmid AS pgmid,
  tstc_usobhash.object AS object,
  tstc_usobhash.obj_name AS obj_name,
  tstc_usobhash.service_type AS service_type,
  tstc_usobhash.service AS service
FROM tstc_usobhash AS TSTC_USOBHASH
;

Learn More