I_TradeClaimRequestBsc

DDL: I_TRADECLAIMREQUESTBSC Type: view_entity BASIC
39 Fields 1 Data Sources 4 Associations

Trade Claim Request Header Basic

I_TradeClaimRequestBsc is a Basic CDS View that provides data about "Trade Claim Request Header Basic" in SAP S/4HANA. It reads from 1 data source (tcp_creq) and exposes 39 fields with key field TradeClaimRequest. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
tcp_creq tcp_creq from

Associations (4)

CardinalityTargetAliasCondition
[1..*] I_TradeClaimRequestItemBsc _TradeClaimRequestItem $projection.TradeClaimRequest = _TradeClaimRequestItem.TradeClaimRequest
[0..*] I_TradeClaimRequestDocRefBsc _TradeClaimRequestDocRef $projection.TradeClaimRequest = _TradeClaimRequestDocRef.TradeClaimRequest and _TradeClaimRequestDocRef.TradeClaimRequestItem = '000000'
[0..*] I_TradeClaimRequestPartnerBsc _TradeClaimRequestPartner $projection.TradeClaimRequest = _TradeClaimRequestPartner.TradeClaimRequest and _TradeClaimRequestPartner.TradeClaimRequestItem = '000000'
[1..*] I_TradeClaimRequestValdtnBsc _TradeClaimRequestValdtn $projection.TradeClaimRequest = _TradeClaimRequestValdtn.TradeClaimRequest

Annotations (9)

NameValueLevelField
EndUserText.label Trade Claim Request Header Basic view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.representativeKey TradeClaimRequest view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view

Fields (39)

KeyFieldSource TableSource FieldDescription
KEY TradeClaimRequest tradeclaimrequest
TrdClmReqDocumentType trdclmreqdocumenttype
TrdClmReqDocumentCategory trdclmreqdocumentcategory
TradeClaimRequestStatus tradeclaimrequeststatus
DocumentReferenceID documentreferenceid Reference
TrdClmReqExecutionStartDate trdclmreqexecutionstartdate
TrdClmReqExecutionEndDate trdclmreqexecutionenddate
DisputeCaseUUID disputecaseuuid UUID
DisputeCase disputecase Case ID
DisputeCaseType disputecasetype Case Type
CompanyCode companycode Receiver Company Code
SalesOrganization salesorganization Sales Organization
DistributionChannel distributionchannel RefDistCh-Cust/Mat.
Division division Internal Division ID
SalesOffice salesoffice Sales Office
SalesGroup salesgroup Sales Group
PurchasingOrganization purchasingorganization Purchasing Organization
PurchasingGroup purchasinggroup Purchasing Group
PostingDate postingdate Posting Date for GR
TrdClmReqCurrency documentcurrency Document Currency
PaymentMethod paymentmethod Pymt Meth.
Country country Venue: Ctry/Reg
PaymentTerms paymentterms Pyt Terms
PaymentReference paymentreference Payment Reference
TrdClmReqDocumentDate documentdate Journal Entry Date
AssignmentReference assignmentnumber Assignment Reference
BillToParty billtoparty Inv. Recipient
InvoicingParty invoicingparty Supplier
TradeClaimRequestUUID tradeclaimrequestuuid
TradeClaimRequestUUIDHex
CreatedByUser tradeclaimrequestcreatedbyuser Created By
CreationDateTime trdclmreqcreatedbydatetime Created On
LocalLastChangedByUser trdclmreqlocllstchgbyuser Changed By
LoclInstanceLastChangeDateTime trdclmreqlocllstchgdatetime Changed On
LastChangeDateTime trdclmreqlastchangeddatetime Changed On
_TradeClaimRequestItem _TradeClaimRequestItem
_TradeClaimRequestDocRef _TradeClaimRequestDocRef
_TradeClaimRequestPartner _TradeClaimRequestPartner
_TradeClaimRequestValdtn _TradeClaimRequestValdtn

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_TradeClaimRequestBsc.
-- 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_TradeClaimRequestBsc AS
SELECT
  TradeClaimRequest,
  TrdClmReqDocumentType,
  TrdClmReqDocumentCategory,
  TradeClaimRequestStatus,
  DocumentReferenceID,
  TrdClmReqExecutionStartDate,
  TrdClmReqExecutionEndDate,
  DisputeCaseUUID,
  DisputeCase,
  DisputeCaseType,
  CompanyCode,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesOffice,
  SalesGroup,
  PurchasingOrganization,
  PurchasingGroup,
  PostingDate,
  documentcurrency AS TrdClmReqCurrency,
  PaymentMethod,
  Country,
  PaymentTerms,
  PaymentReference,
  documentdate AS TrdClmReqDocumentDate,
  assignmentnumber AS AssignmentReference,
  BillToParty,
  InvoicingParty,
  TradeClaimRequestUUID,
  cast ( bintohex( tradeclaimrequestuuid ) as tcp_uuid_hex preserving type ) AS TradeClaimRequestUUIDHex,
  tradeclaimrequestcreatedbyuser AS CreatedByUser,
  trdclmreqcreatedbydatetime AS CreationDateTime,
  trdclmreqlocllstchgbyuser AS LocalLastChangedByUser,
  trdclmreqlocllstchgdatetime AS LoclInstanceLastChangeDateTime,
  trdclmreqlastchangeddatetime AS LastChangeDateTime
FROM tcp_creq
LEFT OUTER JOIN I_TradeClaimRequestItemBsc AS _TradeClaimRequestItem ON TradeClaimRequest = _TradeClaimRequestItem.TradeClaimRequest  -- association [1..*]
LEFT OUTER JOIN I_TradeClaimRequestDocRefBsc AS _TradeClaimRequestDocRef ON TradeClaimRequest = _TradeClaimRequestDocRef.TradeClaimRequest AND _TradeClaimRequestDocRef.TradeClaimRequestItem = '000000'  -- association [0..*]
LEFT OUTER JOIN I_TradeClaimRequestPartnerBsc AS _TradeClaimRequestPartner ON TradeClaimRequest = _TradeClaimRequestPartner.TradeClaimRequest AND _TradeClaimRequestPartner.TradeClaimRequestItem = '000000'  -- association [0..*]
LEFT OUTER JOIN I_TradeClaimRequestValdtnBsc AS _TradeClaimRequestValdtn ON TradeClaimRequest = _TradeClaimRequestValdtn.TradeClaimRequest  -- association [1..*]
;

Learn More