I_TrgtUserData

DDL: I_TRGTUSERDATA Type: view_entity BASIC Package: FTR_GENERAL_CORE

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. It is exposed through 1 OData service (ASQL_F1754). Part of development package FTR_GENERAL_CORE.

Data Sources (1)

SourceAliasJoin Type
trgt_user_data UserData from

Annotations (7)

NameValueLevelField
AbapCatalog.entityBuffer.definitionAllowed false view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label CDS view for Treasury table: TRGT_USER_DATA view

OData Services (1)

ServiceBindingVersionContractRelease
ASQL_F1754 ASQL_F1754 C2 NOT_RELEASED

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.

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
;