P_FinTransFlowWithTwoDirection

DDL: P_FINTRANSFLOWWITHTWODIRECTION SQL: PFINTRSFLOWTWOD Type: view COMPOSITE Package: FTTR_CORE
6 Fields 2 Data Sources

Flow with Two Direction

P_FinTransFlowWithTwoDirection is a Composite CDS View that provides data about "Flow with Two Direction" in SAP S/4HANA. It reads from 2 data sources (R_FinTransFlow, R_FinTransCashFlowActivity) and exposes 6 fields with key fields CompanyCode, FinancialTransaction. Part of development package FTTR_CORE.

Data Sources (2)

SourceAliasJoin Type
R_FinTransFlow Flow inner
R_FinTransCashFlowActivity Main from

Parameters (1)

NameTypeDefault
P_KeyDate vdm_v_key_date

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PFINTRSFLOWTWOD view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.preserveKey true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #COMPOSITE view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode R_FinTransFlow CompanyCode Receiver Company Code
KEY FinancialTransaction R_FinTransFlow FinancialTransaction Transaction
FinancialInstrProductCategory R_FinTransCashFlowActivity FinancialInstrProductCategory Prod. Category
FinTransFlowNomAmtCrcy R_FinTransFlow FinTransFlowNomAmtCrcy
FinancialTransactionDirection R_FinTransFlow FinancialTransactionDirection Direction
FinTransFlowPaytAmtDirection R_FinTransFlow FinTransFlowPaytAmtDirection

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_FinTransFlowWithTwoDirection.
-- 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: PFINTRSFLOWTWOD
-- Parameters: P_KeyDate : vdm_v_key_date

CREATE VIEW P_FinTransFlowWithTwoDirection AS
SELECT
  Flow.CompanyCode AS CompanyCode,
  Flow.FinancialTransaction AS FinancialTransaction,
  Main.FinancialInstrProductCategory AS FinancialInstrProductCategory,
  Flow.FinTransFlowNomAmtCrcy AS FinTransFlowNomAmtCrcy,
  Flow.FinancialTransactionDirection AS FinancialTransactionDirection,
  Flow.FinTransFlowPaytAmtDirection AS FinTransFlowPaytAmtDirection
FROM R_FinTransCashFlowActivity AS Main
INNER JOIN R_FinTransFlow AS Flow ON /* join condition not captured in parsed metadata */
;

Learn More