Maintenance of Selection Variables in the
TVARV Table
You need to specify variants with parameters for a report. This is required because the report is provided with these parameters while it is running. However, parameters can change within a chain or at the start of different chains. An example of this is the selection date. You cannot specify a fixed date because of the daily change.
Define the parameters or the variants as selection variables whose value is taken from the TVARV table. The value of a variable is automatically read from the TVARV table if the Selection Variable attribute is set for the variable in the variant. Then choose the selection option and specify which entry is to be used from the TVARV table to fill the variable value. You need to enter the data in this table yourself.
You can see if a variable is a parameter or a selection option when you save the settings as a variant. Each variable is based on a P (parameter) or an S (selection option). SAP recommends that you gain an overview of the variables to be created, and then create the variables by using the SM32 transaction, and then using these in the variant. You need to enter date variables with the YYYYMMDD format.
The following table lists the most important variables that are needed in the reports:
Job Name |
Field Name in the Report |
Variable Type |
RFBKPDT2 |
Bank Area |
Parameter |
RFBKPDT4 |
Bank Area |
Parameter |
RFBKKC20 |
Bank Area |
Selection option |
RFBKKC20 |
On |
Parameter |
RFBKCONC |
Bank Area |
Selection option |
RFBKCONC |
Balancing Selection Date |
Parameter |
RFBKBSST |
Bank Area |
Selection option |
RFBKBSST |
Statement Date |
Parameter |
RFBKCLEB |
Bank Area |
Parameter |
RFBKCLEB |
Balancing Posting Date |
Parameter |
RFBKCHACCUR |
Bank Area |
Parameter |
RFBKSOCR (obsolete from EA-FINSERV 200) |
Bank Area |
Parameter |
RFBKSOCRPAR (new from EA-FINSERV 200) |
Bank Area |
Parameter |
RFBKACCL |
Bank Area |
Parameter |
RFBKACCL |
Closure Date |
Parameter |
RFBKCONA |
Bank Area |
Parameter |
RFBKCONA |
Accrual/Deferral Key Date |
Parameter |
RFBKGLBSPREP |
Bank Area |
Selection option |
RFBKGLBSPREP |
To-Date for GL Transfer |
Parameter |
RFBKGL02 |
Bank Area |
Selection option |
RFBKGL02 |
To-Date for Balance Sheet Preparation |
Parameter |
RFBKGL_VA_CALC_POST |
Bank Area |
Selection option |
RFBKGL_VA_CALC_POST |
Account Number |
Selection option |
RFBKGL_VA_CALC_POST |
Posting Date |
Parameter |
RFBKGL_VA_CALC_POST |
Valuation Date |
Parameter |
RFBKTTERMCONTROL (changed for EA-FINSERV 500) |
Bank Area |
Selection option |
RFBKTTERMCONTROL (changed for EA-FINSERV 500) |
Product |
Selection option |
RFBKTTERMCONTROL (changed for EA-FINSERV 500) |
Account Number |
Selection option |
RFBKTTTERMMATURE (new for EA-FINSERV 500) |
Bank Area |
Selection option |
RFBKTTTERMMATURE (new for EA-FINSERV 500) |
Product |
Selection option |
RFBKTTTERMMATURE (new for EA-FINSERV 500) |
Account Number |
Selection option |
RFBKTMP1_PO |
Bank Area |
Parameter |
In the most simple case (where there is one bank area only), the TVARV table requires only two variables:
· One parameter variable for the old payment transaction date.
· One parameter variable for the new payment transaction date.
You can specify all the other values directly in the variant. You need to enter the date variables daily.
There are two options:
1. The work preparation must adjust the variables on every working day.
2. You write a report that supplies the variables. Both date variables are in the BKK01D table. PDAT_ACT contains the current payment transaction date and CDAT_ACT contains the current posting closing date. The values are exported from these variables and imported to the TVARV table.
The report must be defined in such a way that it can be entered in a chain. The report uses the same logic as that from the reports delivered by SAP. The general logic is in the Online Self Service in note no. 123217.
You then need to enter the report in the list of reports that are to be chained.