I_TradeClaimRequestApplLogBsc

DDL: I_TRADECLAIMREQUESTAPPLLOGBSC Type: view_entity BASIC
9 Fields 1 Data Sources 1 Associations

Trade Claim Request Application Log

I_TradeClaimRequestApplLogBsc is a Basic CDS View that provides data about "Trade Claim Request Application Log" in SAP S/4HANA. It reads from 1 data source (tcp_appl_log) and exposes 9 fields with key fields ApplicationLogHandle, TradeClaimRequest. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
tcp_appl_log tcp_appl_log from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_TradeClaimRequestBsc _TradeClaimRequest $projection.TradeClaimRequest = _TradeClaimRequest.TradeClaimRequest

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Trade Claim Request Application Log view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #BASIC view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY ApplicationLogHandle applicationloghandle Log Handle
KEY TradeClaimRequest tradeclaimrequest
ApplicationJobDescription applicationjobdescription External ID
CreatedByUser tradeclaimrequestcreatedbyuser Created By
CreationDateTime trdclmreqcreatedbydatetime Created On
LocalLastChangedByUser trdclmreqlocllstchgbyuser Changed By
LoclInstanceLastChangeDateTime trdclmreqlocllstchgdatetime Changed On
LastChangeDateTime trdclmreqlastchangeddatetime Changed On
_TradeClaimRequest _TradeClaimRequest

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_TradeClaimRequestApplLogBsc.
-- 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_TradeClaimRequestApplLogBsc AS
SELECT
  ApplicationLogHandle,
  TradeClaimRequest,
  ApplicationJobDescription,
  tradeclaimrequestcreatedbyuser AS CreatedByUser,
  trdclmreqcreatedbydatetime AS CreationDateTime,
  trdclmreqlocllstchgbyuser AS LocalLastChangedByUser,
  trdclmreqlocllstchgdatetime AS LoclInstanceLastChangeDateTime,
  trdclmreqlastchangeddatetime AS LastChangeDateTime
FROM tcp_appl_log
LEFT OUTER JOIN I_TradeClaimRequestBsc AS _TradeClaimRequest ON TradeClaimRequest = _TradeClaimRequest.TradeClaimRequest  -- association [1..1]
;

Learn More