P_FinTransHistlFcstFeeFlow

DDL: P_FINTRANSHISTLFCSTFEEFLOW SQL: PHISTLFCSTFEE Type: view COMPOSITE
45 Fields 2 Data Sources

P_FinTransHistlFcstFeeFlow is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (P_FinTransFeeFlow, P_FinTransFeeFlow) and exposes 45 fields with key fields CompanyCode, FinancialTransaction, FinancialInstrumentActivity, FinTransFlowCreationDate, FinTransFlowCreationTime.

Data Sources (2)

SourceAliasJoin Type
P_FinTransFeeFlow FeeFlow from
P_FinTransFeeFlow FeeFlow union_all

Parameters (4)

NameTypeDefault
P_HistlStartDate vdm_v_start_date
P_HistlEndDate vdm_v_end_date
P_FcstStartDate vdm_v_start_date
P_FcstEndDate vdm_v_end_date

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PHISTLFCSTFEE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.private true view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (45)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode P_FinTransFeeFlow CompanyCode Receiver Company Code
KEY FinancialTransaction P_FinTransFeeFlow FinancialTransaction Transaction
KEY FinancialInstrumentActivity P_FinTransFeeFlow FinancialInstrumentActivity
KEY FinTransFlowCreationDate P_FinTransFeeFlow FinTransFlowCreationDate
KEY FinTransFlowCreationTime P_FinTransFeeFlow FinTransFlowCreationTime
KEY FinTransFlowNumber P_FinTransFeeFlow FinTransFlowNumber
KEY FinTransFeeDataSource
FinTransFlowPaymentDate P_FinTransFeeFlow FinTransFlowPaymentDate
FinTransFlowType P_FinTransFeeFlow FinTransFlowType Flow Type
TreasuryContractType P_FinTransFeeFlow TreasuryContractType Treasury Contract Type
FinTransFlowPostingStatus P_FinTransFeeFlow FinTransFlowPostingStatus
TransactionCurrency P_FinTransFeeFlow TransactionCurrency Transaction Currency
FinTransFlowPaytAmt P_FinTransFeeFlow FinTransFlowPaytAmt
FinTransFlowPaytAmtCrcy P_FinTransFeeFlow FinTransFlowPaytAmtCrcy
BankGroup BankGroup BankGroup
Counterparty P_FinTransFeeFlow Counterparty Supplier
FinancialInstrumentProductType P_FinTransFeeFlow FinancialInstrumentProductType
Portfolio P_FinTransFeeFlow Portfolio Portfolio
SecurityAccount P_FinTransFeeFlow SecurityAccount
FinancialInstrTransactionType P_FinTransFeeFlow FinancialInstrTransactionType
YearMonth P_FinTransFeeFlow YearMonth Year Month
YearQuarter P_FinTransFeeFlow YearQuarter Year Quarter
CompanyCode Receiver Company Code
KEY FinancialTransaction P_FinTransFeeFlow FinancialTransaction Transaction
KEY FinancialInstrumentActivity P_FinTransFeeFlow FinancialInstrumentActivity
KEY FinTransFlowCreationDate P_FinTransFeeFlow FinTransFlowCreationDate
KEY FinTransFlowCreationTime P_FinTransFeeFlow FinTransFlowCreationTime
KEY FinTransFlowNumber P_FinTransFeeFlow FinTransFlowNumber
KEY FinTransFeeDataSource
FinTransFlowPaymentDate P_FinTransFeeFlow FinTransFlowPaymentDate
FinTransFlowType P_FinTransFeeFlow FinTransFlowType Flow Type
TreasuryContractType P_FinTransFeeFlow TreasuryContractType Treasury Contract Type
FinTransFlowPostingStatus P_FinTransFeeFlow FinTransFlowPostingStatus
TransactionCurrency P_FinTransFeeFlow TransactionCurrency Transaction Currency
FinTransFlowPaytAmt P_FinTransFeeFlow FinTransFlowPaytAmt
FinTransFlowPaytAmtCrcy P_FinTransFeeFlow FinTransFlowPaytAmtCrcy
BankGroup BankGroup BankGroup
Counterparty P_FinTransFeeFlow Counterparty Supplier
FinancialInstrumentProductType P_FinTransFeeFlow FinancialInstrumentProductType
Portfolio P_FinTransFeeFlow Portfolio Portfolio
SecurityAccount P_FinTransFeeFlow SecurityAccount
FinancialInstrTransactionType P_FinTransFeeFlow FinancialInstrTransactionType
YearMonth P_FinTransFeeFlow YearMonth Year Month
YearQuarter P_FinTransFeeFlow YearQuarter Year Quarter
CalendarYear P_FinTransFeeFlow CalendarYear Year

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 P_FinTransHistlFcstFeeFlow.
-- 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.
-- SQL view name: PHISTLFCSTFEE
-- Parameters: P_HistlStartDate : vdm_v_start_date, P_HistlEndDate : vdm_v_end_date, P_FcstStartDate : vdm_v_start_date, P_FcstEndDate : vdm_v_end_date

CREATE VIEW P_FinTransHistlFcstFeeFlow AS
SELECT
  FeeFlow.CompanyCode AS CompanyCode,
  FeeFlow.FinancialTransaction AS FinancialTransaction,
  FeeFlow.FinancialInstrumentActivity AS FinancialInstrumentActivity,
  FeeFlow.FinTransFlowCreationDate AS FinTransFlowCreationDate,
  FeeFlow.FinTransFlowCreationTime AS FinTransFlowCreationTime,
  FeeFlow.FinTransFlowNumber AS FinTransFlowNumber,
  cast('HISTL' as ftr_fintransfee_ds) AS FinTransFeeDataSource,
  FeeFlow.FinTransFlowPaymentDate AS FinTransFlowPaymentDate,
  FeeFlow.FinTransFlowType AS FinTransFlowType,
  FeeFlow.TreasuryContractType AS TreasuryContractType,
  FeeFlow.FinTransFlowPostingStatus AS FinTransFlowPostingStatus,
  FeeFlow.TransactionCurrency AS TransactionCurrency,
  FeeFlow.FinTransFlowPaytAmt AS FinTransFlowPaytAmt,
  FeeFlow.FinTransFlowPaytAmtCrcy AS FinTransFlowPaytAmtCrcy,
  BankGroup.BankGroup AS BankGroup,
  FeeFlow.Counterparty AS Counterparty,
  FeeFlow.FinancialInstrumentProductType AS FinancialInstrumentProductType,
  FeeFlow.Portfolio AS Portfolio,
  FeeFlow.SecurityAccount AS SecurityAccount,
  FeeFlow.FinancialInstrTransactionType AS FinancialInstrTransactionType,
  FeeFlow.YearMonth AS YearMonth,
  FeeFlow.YearQuarter AS YearQuarter,
  FeeFlow.CalendarYear AS CalendarYear
FROM P_FinTransFeeFlow AS FeeFlow
-- UNION ALL with additional select branch(es): P_FinTransFeeFlow
;

Learn More