A_TrsyTrdReqAddlAttribInternal

DDL: A_TRSYTRDREQADDLATTRIBINTERNAL Type: view_entity CONSUMPTION
26 Fields 1 Data Sources

Trsy Trade Request Additional Attributes

A_TrsyTrdReqAddlAttribInternal is a Consumption CDS View that provides data about "Trsy Trade Request Additional Attributes" in SAP S/4HANA. It reads from 1 data source (R_TrsyTrdReqAddlAttributesTP) and exposes 26 fields with key field TreasuryTradeRequestUUID.

Data Sources (1)

SourceAliasJoin Type
R_TrsyTrdReqAddlAttributesTP R_TrsyTrdReqAddlAttributesTP projection

Annotations (10)

NameValueLevelField
EndUserText.label Trsy Trade Request Additional Attributes view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
Metadata.ignorePropagatedAnnotations true view
OData.entityType.name TrsyTrdReqAddlAttribInternal view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY TreasuryTradeRequestUUID TreasuryTradeRequestUUID
FinancialTransactionPortfolio FinancialTransactionPortfolio
PortfolioNamelocalized
FinTransHedgingClassification FinTransHedgingClassification
HedgingClassificationNamelocalized
TrsyTrdReqExternalReference TrsyTrdReqExternalReference
FinancialTransactionAssignment FinancialTransactionAssignment
FinancialInstrAssignmentDesclocalized
FinTransInternalReference FinTransInternalReference
FinancialInstrReferenceDesclocalized
FinTransactionCharacteristics FinTransactionCharacteristics
FinancialInstrCharcDesclocalized
ProfitCenter ProfitCenter Profit Center
ProfitCenterName
CostCenter CostCenter Cost Center
CostCenterName
WBSElementInternalID WBSElementInternalID WBS Internal ID
WBSElementName _WBSElementText WBSDescription WBS Element Name
OnBehalfOfCompany OnBehalfOfCompany
OnBehalfOfCompanyName _BehalfOfCoCodeText CompanyCodeName Company Name
Country Country Venue: Ctry/Reg
CountryNamelocalized
Segment Segment Segment number
SegmentNamelocalized
BusinessArea BusinessArea Business Area
BusinessAreaName

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 A_TrsyTrdReqAddlAttribInternal.
-- 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 A_TrsyTrdReqAddlAttribInternal AS
SELECT
  TreasuryTradeRequestUUID,
  FinancialTransactionPortfolio,
  _PortfolioText.PortfolioName : localized AS PortfolioNamelocalized,
  FinTransHedgingClassification,
  _HedgeClassText.HedgingClassificationName : localized AS HedgingClassificationNamelocalized,
  TrsyTrdReqExternalReference,
  FinancialTransactionAssignment,
  _AssignmentText.FinancialInstrAssignmentDesc : localized AS FinancialInstrAssignmentDesclocalized,
  FinTransInternalReference,
  _InternalReferenceText.FinancialInstrReferenceDesc : localized AS FinancialInstrReferenceDesclocalized,
  FinTransactionCharacteristics,
  _CharacteristicText.FinancialInstrCharcDesc : localized AS FinancialInstrCharcDesclocalized,
  ProfitCenter,
  _ProfitCenterText[1:Language=$session.system_language].ProfitCenterName AS ProfitCenterName,
  CostCenter,
  _CostCenterText[1:Language=$session.system_language].CostCenterName AS CostCenterName,
  WBSElementInternalID,
  _WBSElementText.WBSDescription AS WBSElementName,
  OnBehalfOfCompany,
  _BehalfOfCoCodeText.CompanyCodeName AS OnBehalfOfCompanyName,
  Country,
  _CountryText.CountryName : localized AS CountryNamelocalized,
  Segment,
  _SegmentText.SegmentName : localized AS SegmentNamelocalized,
  BusinessArea,
  _BusinessArea._Text[1:Language=$session.system_language].BusinessAreaName AS BusinessAreaName
FROM R_TrsyTrdReqAddlAttributesTP
;

Learn More