R_TrsyTrdReqActionHistoryTP

DDL: R_TRSYTRDREQACTIONHISTORYTP Type: view_entity TRANSACTIONAL
10 Fields 1 Data Sources 2 Associations

Treasury Trade Request Action History

R_TrsyTrdReqActionHistoryTP is a Transactional CDS View that provides data about "Treasury Trade Request Action History" in SAP S/4HANA. It reads from 1 data source (I_TrsyTrdRequestActionHistory) and exposes 10 fields with key field TrsyTrdRecActHistUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_TrsyTrdRequestActionHistory I_TrsyTrdRequestActionHistory from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_TrsyTrdReqActnHistActnCode _ActionCode _ActionCode.TrsyTrdReqActHistActionCode = $projection.TrsyTrdReqActHistActionCode
[0..1] I_UserContactCard _ChangedBy _ChangedBy.ContactCardID = $projection.TrsyTrdReqActHistLastChangedBy

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Treasury Trade Request Action History view
VDM.viewType #TRANSACTIONAL view
ObjectModel.sapObjectNodeType.name TrsyTradeRequestActionHistory view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY TrsyTrdRecActHistUUID TrsyTrdRecActHistUUID UUID
TreasuryTradeRequestUUID TreasuryTradeRequestUUID Trade Request GUID
TreasuryTradeRequest TreasuryTradeRequest Trade Request ID
TrsyTrdReqActHistEntrDteTme TrsyTrdReqActHistEntrDteTme UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
TrsyTrdReqActHistActionCode TrsyTrdReqActHistActionCode User action
TrsyTrdReqActHistLastChangedBy TrsyTrdReqActHistLastChangedBy User Name
TrsyTrdReqActHistVersion TrsyTrdReqActHistVersion XML Vers.
_TradeRequest _TradeRequest
_ActionCode _ActionCode
_ChangedBy _ChangedBy

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 R_TrsyTrdReqActionHistoryTP.
-- 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 R_TrsyTrdReqActionHistoryTP AS
SELECT
  TrsyTrdRecActHistUUID,
  TreasuryTradeRequestUUID,
  TreasuryTradeRequest,
  TrsyTrdReqActHistEntrDteTme,
  TrsyTrdReqActHistActionCode,
  TrsyTrdReqActHistLastChangedBy,
  TrsyTrdReqActHistVersion
FROM I_TrsyTrdRequestActionHistory
LEFT OUTER JOIN I_TrsyTrdReqActnHistActnCode AS _ActionCode ON _ActionCode.TrsyTrdReqActHistActionCode = TrsyTrdReqActHistActionCode  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _ChangedBy ON _ChangedBy.ContactCardID = TrsyTrdReqActHistLastChangedBy  -- association [0..1]
;

Learn More