A_IntrstRateInstrMainFlow

DDL: A_INTRSTRATEINSTRMAINFLOW Type: view_entity CONSUMPTION
24 Fields 1 Data Sources

Main Flow

A_IntrstRateInstrMainFlow is a Consumption CDS View that provides data about "Main Flow" in SAP S/4HANA. It reads from 1 data source (R_FinTransMainFlowTP) and exposes 24 fields with key fields CompanyCode, FinancialTransaction, FinancialInstrumentActivity, FinTransFlowCreationDate, FinTransFlowCreationTime.

Data Sources (1)

SourceAliasJoin Type
R_FinTransMainFlowTP R_FinTransMainFlowTP projection

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Main Flow view
OData.entityType.name IntrstRateInstrMainFlow_Type view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY FinancialTransaction FinancialTransaction Transaction
KEY FinancialInstrumentActivity FinancialInstrumentActivity
KEY FinTransFlowCreationDate FinTransFlowCreationDate
KEY FinTransFlowCreationTime FinTransFlowCreationTime
KEY FinTransFlowNumber FinTransFlowNumber
FinancialTransactionDirection FinancialTransactionDirection
FinTransFlowType FinTransFlowType Flow Type
FinTransFlowPaytAmtDirection FinTransFlowPaytAmtDirection
FinTransFlowPaymentDate FinTransFlowPaymentDate
FinTransFlowPaytAmt FinTransFlowPaytAmt
FinTransFlowPaytAmtCrcy FinTransFlowPaytAmtCrcy
FinTransFlowInLoclCrcyPaytAmt FinTransFlowInLoclCrcyPaytAmt
LocalCurrency LocalCurrency Local Currency
FinTransFlowLoclCrcyCnvrsnRate FinTransFlowLoclCrcyCnvrsnRate
FinTransFlowNomAmt FinTransFlowNomAmt
FinTransFlowNomAmtCrcy FinTransFlowNomAmtCrcy
AssignmentReference AssignmentReference Assignment Reference
FinTransFlwLoclCrcyAmtCalcType FinTransFlwLoclCrcyAmtCalcType
FinTransFlowCalculationDate FinTransFlowCalculationDate
FlowCalcDateIsExclusive FlowCalcDateIsExclusive
FlowCalcDateIsMonthEnd FlowCalcDateIsMonthEnd
FinTransPaytRateInPercent FinTransPaytRateInPercent
_FinTrans _FinTrans

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_IntrstRateInstrMainFlow.
-- 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_IntrstRateInstrMainFlow AS
SELECT
  CompanyCode,
  FinancialTransaction,
  FinancialInstrumentActivity,
  FinTransFlowCreationDate,
  FinTransFlowCreationTime,
  FinTransFlowNumber,
  FinancialTransactionDirection,
  FinTransFlowType,
  FinTransFlowPaytAmtDirection,
  FinTransFlowPaymentDate,
  FinTransFlowPaytAmt,
  FinTransFlowPaytAmtCrcy,
  FinTransFlowInLoclCrcyPaytAmt,
  LocalCurrency,
  FinTransFlowLoclCrcyCnvrsnRate,
  FinTransFlowNomAmt,
  FinTransFlowNomAmtCrcy,
  AssignmentReference,
  FinTransFlwLoclCrcyAmtCalcType,
  FinTransFlowCalculationDate,
  FlowCalcDateIsExclusive,
  FlowCalcDateIsMonthEnd,
  FinTransPaytRateInPercent
FROM R_FinTransMainFlowTP
;

Learn More