A_IntrstRateInstrAddlAttrib

DDL: A_INTRSTRATEINSTRADDLATTRIB Type: view_entity CONSUMPTION

Additional Attribute

A_IntrstRateInstrAddlAttrib is a Consumption CDS View that provides data about "Additional Attribute" in SAP S/4HANA. It reads from 1 data source (R_FinTransAddlAttributeTP) and exposes 25 fields with key fields CompanyCode, FinancialTransaction.

Data Sources (1)

SourceAliasJoin Type
R_FinTransAddlAttributeTP R_FinTransAddlAttributeTP projection

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Additional Attribute view
OData.entityType.name IntrstRateInstrAddlAttrib_Type view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY FinancialTransaction FinancialTransaction Transaction
FinTransGeneralValuationClass FinTransGeneralValuationClass
Portfolio Portfolio Portfolio
TreasuryFinanceProject TreasuryFinanceProject
FinancialInstrumentAssignment FinancialInstrumentAssignment
FinancialInstrumentReference FinancialInstrumentReference
FinancialInstrCharacteristic FinancialInstrCharacteristic Characteristics
Fund Fund Sender Fund
GrantID GrantID Sender Grant
FinTransIsRiskMitigating FinTransIsRiskMitigating
FinancialInstrumentGuarantor FinancialInstrumentGuarantor
TreasuryFacility TreasuryFacility
TreasuryFacilityCompanyCode TreasuryFacilityCompanyCode
FinTransAuthorizationGroup FinTransAuthorizationGroup
BusinessPlace BusinessPlace Business place
CostCenter CostCenter Cost Center
ProfitCenter ProfitCenter Profit Center
FunctionalArea FunctionalArea Sendr Fctl Area
WBSElementInternalID WBSElementInternalID WBS Internal ID
TrsyPosCustomDiffntnTerm1 TrsyPosCustomDiffntnTerm1
TrsyPosCustomDiffntnTerm2 TrsyPosCustomDiffntnTerm2
TrsyPosCustomDiffntnTerm3 TrsyPosCustomDiffntnTerm3
TrsyPosCustomDiffntnTerm4 TrsyPosCustomDiffntnTerm4
TrsyPosCustomDiffntnTerm5 TrsyPosCustomDiffntnTerm5

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_IntrstRateInstrAddlAttrib.
-- 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_IntrstRateInstrAddlAttrib AS
SELECT
  CompanyCode,
  FinancialTransaction,
  FinTransGeneralValuationClass,
  Portfolio,
  TreasuryFinanceProject,
  FinancialInstrumentAssignment,
  FinancialInstrumentReference,
  FinancialInstrCharacteristic,
  Fund,
  GrantID,
  FinTransIsRiskMitigating,
  FinancialInstrumentGuarantor,
  TreasuryFacility,
  TreasuryFacilityCompanyCode,
  FinTransAuthorizationGroup,
  BusinessPlace,
  CostCenter,
  ProfitCenter,
  FunctionalArea,
  WBSElementInternalID,
  TrsyPosCustomDiffntnTerm1,
  TrsyPosCustomDiffntnTerm2,
  TrsyPosCustomDiffntnTerm3,
  TrsyPosCustomDiffntnTerm4,
  TrsyPosCustomDiffntnTerm5
FROM R_FinTransAddlAttributeTP
;