I_TrgtUserData

DDL: I_TRGTUSERDATA SQL: ITRGTUSERDATA Type: view BASIC
9 Fields 1 Data Sources

CDS view for Treasury table: TRGT_USER_DATA

I_TrgtUserData is a Basic CDS View that provides data about "CDS view for Treasury table: TRGT_USER_DATA" in SAP S/4HANA. It reads from 1 data source (trgt_user_data) and exposes 9 fields with key field TreasuryUserStatisticsUUID.

Data Sources (1)

SourceAliasJoin Type
trgt_user_data UserData from

Annotations (9)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
AbapCatalog.buffering.status #NOT_ALLOWED view
AbapCatalog.sqlViewName ITRGTUSERDATA view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label CDS view for Treasury table: TRGT_USER_DATA view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY TreasuryUserStatisticsUUID
CreatedByUser trgt_user_data create_name Last Changed By
CreationDate trgt_user_data create_date Time Stamp
CorrespondenceCreationTime trgt_user_data create_time Time
CreationTransactionCode
LastChangedByUser trgt_user_data change_name Last Changed By
LastChangeDate trgt_user_data change_date Time Stamp
LastChangeTime trgt_user_data change_time Time Stamp
ChangeTransactionCode

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_TrgtUserData.
-- 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: ITRGTUSERDATA

CREATE VIEW I_TrgtUserData AS
SELECT
  cast(UserData.os_guid as ftr_gen_user_statistics_uuid) AS TreasuryUserStatisticsUUID,
  UserData.create_name AS CreatedByUser,
  UserData.create_date AS CreationDate,
  UserData.create_time AS CorrespondenceCreationTime,
  cast(UserData.create_tcode as ftr_gen_tcode_create) AS CreationTransactionCode,
  UserData.change_name AS LastChangedByUser,
  UserData.change_date AS LastChangeDate,
  UserData.change_time AS LastChangeTime,
  cast(UserData.change_tcode as ftr_gen_tcode_change) AS ChangeTransactionCode
FROM trgt_user_data AS UserData
;

Learn More