SAP FTR_READ_DEALDATA_FROM_DB Function Module for Read Transaction Data from Database









FTR_READ_DEALDATA_FROM_DB is a standard ftr read dealdata from db SAP function module available within SAP R/3 or S/4 Hana systems, depending on your version and release level. It is used for Read Transaction Data from Database processing and below is the pattern details for this FM, showing its interface including any import and export parameters, exceptions etc. there is also a full "cut and paste" ABAP pattern code example, along with implementation ABAP coding, documentation and contribution comments specific to this or related objects.


See here to view full function module documentation and code listing for ftr read dealdata from db FM, simply by entering the name FTR_READ_DEALDATA_FROM_DB into the relevant SAP transaction such as SE37 or SE38.

Function Group: FTR_02
Program Name: SAPLFTR_02
Main Program: SAPLFTR_02
Appliation area:
Release date: N/A
Mode(Normal, Remote etc): Normal Function Module
Update:



Function FTR_READ_DEALDATA_FROM_DB pattern details

In-order to call this FM within your sap programs, simply using the below ABAP pattern details to trigger the function call...or see the full ABAP code listing at the end of this article. You can simply cut and paste this code into your ABAP progrom as it is, including variable declarations.
CALL FUNCTION 'FTR_READ_DEALDATA_FROM_DB'"Read Transaction Data from Database
  EXPORTING
   IM_BUKRS =  "Company Code
   IM_RFHA =  "Financial Transaction

 IMPORTING
   EX_VTBFHA =  "Financial Transaction
   EX_VTBFHAZU =  "Transaction Activity
   EX_TAB_VTBFHAPO =  "Treasury: Table Type for VTBFHAPO
   EX_TAB_VTBFINKO =  "Table Type: VTBfinko
   EX_TAB_VTBFASGT =  "Table Type for VTBFASGT
   EX_TAB_TRADE_ID =  "Table Type Trade Identifier for Financial Transaction

TABLES
*  T_DIVIDEND =  "Dividend Data for Forward Securities Transaction
*  T_ROLLOVER =  "Rollover Periods for Forward Securities Transactions
*  T_VTIOF =  "Additional Option Data
*  T_VTIOFZU =  "Allocation of Option/Future to Underlying
*  T_VTIFHA =  "Underlying Transaction
*  T_VTIFHAZU =  "Underlying Transaction Status Table
*  T_VTIFHAPO =  "Underlyinggeschäftbewegungen
*  T_VTIFINKO =  "Underlying Transaction Conditions

EXCEPTIONS
   DEAL_NOT_FOUND = 1    PROCESSING_ERROR = 2    ERROR_OCCURED = 3
.



IMPORTING Parameters details for FTR_READ_DEALDATA_FROM_DB

IM_BUKRS - Company Code

Data type: BUKRS
Optional: No
Call by Reference: Yes

IM_RFHA - Financial Transaction

Data type: TB_RFHA
Optional: No
Call by Reference: Yes

EXPORTING Parameters details for FTR_READ_DEALDATA_FROM_DB

EX_VTBFHA - Financial Transaction

Data type: VTBFHA
Optional: No
Call by Reference: Yes

EX_VTBFHAZU - Transaction Activity

Data type: VTBFHAZU
Optional: No
Call by Reference: Yes

EX_TAB_VTBFHAPO - Treasury: Table Type for VTBFHAPO

Data type: FTR_FHAPO
Optional: No
Call by Reference: Yes

EX_TAB_VTBFINKO - Table Type: VTBfinko

Data type: TBFINKO
Optional: No
Call by Reference: Yes

EX_TAB_VTBFASGT - Table Type for VTBFASGT

Data type: FTRY_VTBFASGT
Optional: No
Call by Reference: Yes

EX_TAB_TRADE_ID - Table Type Trade Identifier for Financial Transaction

Data type: TLRY_TRADE_ID
Optional: No
Call by Reference: Yes

TABLES Parameters details for FTR_READ_DEALDATA_FROM_DB

T_DIVIDEND - Dividend Data for Forward Securities Transaction

Data type: VTBDIVIDEND
Optional: Yes
Call by Reference: Yes

T_ROLLOVER - Rollover Periods for Forward Securities Transactions

Data type: VTBROLLOVER
Optional: Yes
Call by Reference: Yes

T_VTIOF - Additional Option Data

Data type: VTIOF
Optional: Yes
Call by Reference: Yes

T_VTIOFZU - Allocation of Option/Future to Underlying

Data type: VTIOFZU
Optional: Yes
Call by Reference: Yes

T_VTIFHA - Underlying Transaction

Data type: VTIFHA
Optional: Yes
Call by Reference: Yes

T_VTIFHAZU - Underlying Transaction Status Table

Data type: VTIFHAZU
Optional: Yes
Call by Reference: Yes

T_VTIFHAPO - Underlyinggeschäftbewegungen

Data type: VTIFHAPO
Optional: Yes
Call by Reference: Yes

T_VTIFINKO - Underlying Transaction Conditions

Data type: VTIFINKO
Optional: Yes
Call by Reference: Yes

EXCEPTIONS details

DEAL_NOT_FOUND - Transaction does not exist

Data type:
Optional: No
Call by Reference: Yes

PROCESSING_ERROR - Für derartige Geschäfte existiert kein Anwendungsfunktionsbaustein

Data type:
Optional: No
Call by Reference: Yes

ERROR_OCCURED - An Error Has Occurred

Data type:
Optional: No
Call by Reference: Yes

Copy and paste ABAP code example for FTR_READ_DEALDATA_FROM_DB Function Module

The ABAP code below is a full code listing to execute function module POPUP_TO_CONFIRM including all data declarations. The code uses the original data declarations rather than the latest in-line data DECLARATION SYNTAX but I have included an ABAP code snippet at the end to show how declarations would look using the newer method of declaring data variables on the fly. This will allow you to compare and fully understand the new inline method. Please note some of the newer syntax such as the @DATA is not available until a later 4.70 service pack (SP8), which i why i have stuck to the origianl for this example.

DATA:
lv_im_bukrs  TYPE BUKRS, "   
lv_ex_vtbfha  TYPE VTBFHA, "   
lt_t_dividend  TYPE STANDARD TABLE OF VTBDIVIDEND, "   
lv_deal_not_found  TYPE VTBDIVIDEND, "   
lv_im_rfha  TYPE TB_RFHA, "   
lt_t_rollover  TYPE STANDARD TABLE OF VTBROLLOVER, "   
lv_ex_vtbfhazu  TYPE VTBFHAZU, "   
lv_processing_error  TYPE VTBFHAZU, "   
lt_t_vtiof  TYPE STANDARD TABLE OF VTIOF, "   
lv_error_occured  TYPE VTIOF, "   
lv_ex_tab_vtbfhapo  TYPE FTR_FHAPO, "   
lt_t_vtiofzu  TYPE STANDARD TABLE OF VTIOFZU, "   
lv_ex_tab_vtbfinko  TYPE TBFINKO, "   
lt_t_vtifha  TYPE STANDARD TABLE OF VTIFHA, "   
lv_ex_tab_vtbfasgt  TYPE FTRY_VTBFASGT, "   
lt_t_vtifhazu  TYPE STANDARD TABLE OF VTIFHAZU, "   
lv_ex_tab_trade_id  TYPE TLRY_TRADE_ID, "   
lt_t_vtifhapo  TYPE STANDARD TABLE OF VTIFHAPO, "   
lt_t_vtifinko  TYPE STANDARD TABLE OF VTIFINKO. "   

  CALL FUNCTION 'FTR_READ_DEALDATA_FROM_DB'  "Read Transaction Data from Database
    EXPORTING
         IM_BUKRS = lv_im_bukrs
         IM_RFHA = lv_im_rfha
    IMPORTING
         EX_VTBFHA = lv_ex_vtbfha
         EX_VTBFHAZU = lv_ex_vtbfhazu
         EX_TAB_VTBFHAPO = lv_ex_tab_vtbfhapo
         EX_TAB_VTBFINKO = lv_ex_tab_vtbfinko
         EX_TAB_VTBFASGT = lv_ex_tab_vtbfasgt
         EX_TAB_TRADE_ID = lv_ex_tab_trade_id
    TABLES
         T_DIVIDEND = lt_t_dividend
         T_ROLLOVER = lt_t_rollover
         T_VTIOF = lt_t_vtiof
         T_VTIOFZU = lt_t_vtiofzu
         T_VTIFHA = lt_t_vtifha
         T_VTIFHAZU = lt_t_vtifhazu
         T_VTIFHAPO = lt_t_vtifhapo
         T_VTIFINKO = lt_t_vtifinko
    EXCEPTIONS
        DEAL_NOT_FOUND = 1
        PROCESSING_ERROR = 2
        ERROR_OCCURED = 3
. " FTR_READ_DEALDATA_FROM_DB




ABAP code using 7.40 inline data declarations to call FM FTR_READ_DEALDATA_FROM_DB

The below ABAP code uses the newer in-line data declarations. This allows you to see the coding differences/benefits of the later inline syntax. Please note some of the newer syntax below, such as the @DATA is not available until 4.70 EHP 8.

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!