Where are payment run parameters stored?

[former_member287500]

Dear all,

I need to read the variant for payment advice creation (program RFFOAVIS_FPAYM) which is maintained in the tab PRINTOUT/DATA MEDIUM of transaction F110.

F1 does not help since it only provides the structure but not the table.

Does anyone know the table or a way how I could find out about it?

Thanks a lot,

Tobias

[claudio_carrara]

Hi

I looked for a solution, because I had to undestand what report and what varaint was used during Pproposal and Payment phase. Using BADI FI_F110_SCHEDULE_JOB you can get all info you need and you can check the submit of the phaes. Just the program and the variant are not available, but it can retrieved using a simple ABAP like this one with IMPORT instruction.

DATA F110VERSIONPAR(2) TYPE C.

     TYPES: BEGIN OF DRUTAB,

           PROGN(40)        TYPE C,

           VARIA(14)        TYPE C,

           XPRUF(1)         TYPE C,

           XVARI(1)         TYPE C,

           END OF DRUTAB.

     DATA: T_DRUTAB TYPE TABLE OF DRUTAB.

     DATA: HL_DRUTAB TYPE DRUTAB.

*

     DATA: BEGIN OF F110ID,

           PROGR(4)          TYPE C VALUE 'F110',

           LAUFD             LIKE I_F110V-LAUFD,

           LAUFI             LIKE I_F110V-LAUFI,

           OBJKT(4)          TYPE C,

           END OF F110ID.

*

     DATA: L_F110ID      LIKE F110ID,

           L_SUBRC       LIKE SY-SUBRC,

           L_F110VERSION LIKE F110VERSIONPAR.

     CLEAR: T_DRUTAB, HL_DRUTAB.

     REFRESH T_DRUTAB.

     L_F110ID-PROGR = 'F110'.

     L_F110ID-LAUFD = I_F110V-LAUFD.

     L_F110ID-LAUFI = I_F110V-LAUFI.

     L_F110ID-OBJKT = 'PARM'.

    IMPORT DRUTAB TO T_DRUTAB FROM DATABASE RFDT(FB) ID L_F110ID.

[raymond_giuseppi]

This is the correct answer

[former_member799154]

try table: REGUV

[Former Member]

Hi Tobias,  I am also looking for the answer similar to your question.  Did you find a method?  Ideally I am looking to generate an extract that can show me Payment Run Date, Run ID, Program, Variant.

Any help greatly appreciated.

Matt

[Former Member]

Hi ,

Payment run related tables .Hope this will help you.

FEDIWF1     FI EDI: Person with signing authority

OPN_J1      Japanese DME Foreign Payment Accounting Data (Open FI)

PNBK        Prenotification: New bank data from master records

PNHD        Prenotification: Files created in ACH format

PYONUMKR    Auxiliary structure for lock object EPYONUMKR

PYORDH      Payment order header data

PYORDP      Payment order item data

REGUA       Change of payment proposals: user and time

REGUH       Settlement data from payment program

REGUHH      REGUH version before the 'n'th change

REGUHM      Payment Data for Cross-Payment Run Payment Medium

REGUHO      REGUH version before the 'n'th change

REGUP       Processed items from payment program

REGUP_CORE  Processed Items from Payment Program

REGUPO      Line item status before the 'n'th change

REGUPW      W/tax information per w/tax type/FI line item in pmnt run

REGUS       Acounts blocked by payment proposal

REGUS_SEPA  SEPA Mandate Lock:  Applications To Be Retrieved

REGUT       TemSe - Administration Data

REGUTA      Paying Company Codes for DME Files

REGUV       Control records for the payment program

REGUVM      Payment Data for Cross-Payment Run Payment Medium

SMFIAP      Spec. FI-SL Data in Monitor (See Schedman_specific_fisl)

T004F       Field status definition groups

T012E       EDI-compatible house banks and payment methods

T042        Parameters for payment transactions

T042A       Bank selection for payment program

T042C       Technical Settings For The Payment Program

T042D       Available amounts for payment program

T042FSL     Last additional selections used

T042G       Groups of company codes ( payment program )

T042I       Account determination for payment program

T042J       Bank charges determination

T042JB      Customizing table for Japan Bank Mergers

T042JB1     Customizing table for Japan Bank/Branch Mergers

T042K       Accounts for bank charges

T042L       Bank transaction code names

T042M       User Numbers At The Bank

T042N       Bank transaction codes

T042OFI     Events for MT100 and other DME Formats

T042OFIT    Events for MT100 and other DME Formats

T042P       Bank selection by postal code

T042R       Name of account holder (ref.specifications on bk.details

T042S       Charges/expenses for automatic pmnt transactions

T042U       Block Entries for Debit Customers/Credit Vendors

T042V       Value date for automatic payments

T045T       User ID for bank transactions

T077D       Customer account groups

T077K       Vendor account groups

T078D       Trans.-dependent screen selection for cust.master

T078K       Transaction-dependent screen selection for vendor master

T079D       Company code-dependent screen sel.for cust.master

T079K       Company code-dependent screen sel.for vend.master

T079M       Vendor master data screen selection (purch.org.)

TBACN       Bank EDI file version numbers

TBSL        Posting Key

TFAGS       Definition of FI clearing rules

TFAGT       Texts on FI clearing rules

TZGR        Grouping rules for automatic payments

TZGRT       Name of grouping rules

TBTCO       Job Status Overview Table

TFBUF       Table for FI Data Puffers

TRDIR       Generated Table for View TRDIR 

VARID       Variant directory

VARIT       Variant Texts

[former_member287500]

Thanks everybody for trying to help me. Unfortunately it seems I did not express my question clearly.

To be more clear I am not interested in the parameters maintained in the variant of the report RFFOAVIS_FPAYM. I only need to get the name of the variant which is maintained in F110 for this report for a specific payment run.

Of course I do know how to do it manually, but for my needs I would need to have a report/funtion module which extracts that data for further processing. In order to build this report I would appreciate an indication where to find this information.

Technical details reveil table field F110V-VARI1. But this is only a structure table.

I hope this makes my request clearer.

Thanks again!

Tobias

[Former Member]

Hi Tobias,

It is very easy.. Go to F110>Print out/Data Medium and keep your cursor on the variant of which you want to see the details..and then go to Environment>Maintain Variant (or simply press F5).

You will see all that is maintained in that variant..

Alternatively,

Go to SE38, enter your Program name "RFFOAVIS_FPAYM" and select Radio Button Variant and click on display, select the variant from the list, and click on display.. you will get to see the variant..

Hope this helps..

Regards,

SAPFICO

[Former Member]

Hi,

You have to check in SM37 -> Here you have to give program RFFOAVIS_FPAYM.-Execute

Double click on job name

Select Define Steps

Keep the cursor on Program name/command

|

Select Display

Here you can get the all Parameters details

Regards

Hari Prasad

[Former Member]

Dear Tobias,

Check in this tables REGUH,REGUP,REGUS & PAYR IN SE16

This tables will help you

Thankas & Regards

Hari Prasad

[Former Member]

Hi,

Select the variant and select icon "Maintain variant" that should display the parameters entered for the variant.

Regards

K.R

[Former Member]

Call RFFOAVIS_FPAYM in SA38 with variant.