SAP table FIBL_RPCODE (Master Data for Repetitive Code)

SAP table FIBL_RPCODE has 4 primary key fields being MANDT,BUKRS,HBKID,RPCODE.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
BUKRS Paying Company Code for this Payment Request CHAR 4 0 T001 PRQ_ZBUKR
HBKID Short Key for a House Bank CHAR 5 0 T012 HBKID
RPCODE Repetitive Code CHAR 20 0 RPCODE
HKTID ID for Account Details CHAR 5 0 T012K HKTID
CHAIN ID for Bank Chain CHAR 10 0 TBCHAIN0 CHAINID
BANKS Country/Region Key of Bank CHAR 3 0 T005 BANKS
BANKL Bank Keys CHAR 15 0 BNKA BANKK
BANKN Bank account number CHAR 18 0 BANKN
BKONT Bank Control Key CHAR 2 0 BKONT
BKREF Reference Details for Bank Details CHAR 20 0 BKREF
KOINH Account Holder Name CHAR 60 0 KOINH_FI
PTYPE Category of Business Partner Receiving Payment CHAR 2 0 GPA1T_CFM
01 Central Business Partner
03 Bank
11 Vendor, Creditor
PARTN Reference to Business Partner Receiving Payment CHAR 16 0 GPA1R_CFM
PARTA Short Key for Partner's Bank Details CHAR 6 0 PARTAC
PBUKR Target Company Code CHAR 4 0 T001 FI_PBUKR
ZLSCH Payment Method CHAR 1 0 T042E DZLSCH
WAERS Currency Key CUKY 5 0 TCURC WAERS
DCREA Date on which the record was created DATS 8 0 ERDAT_BF
UCREA Name of person who created the object CHAR 12 0 ERNAM_BF
DRELE Release Date for Repetitive Codes DATS 8 0 REPETITIVE_REL_DAT
URELE Repetitive Codes: Released By CHAR 12 0 REPETITIVE_REL_USER
DREL1 Release Date for Repetitive Codes DATS 8 0 REPETITIVE_REL_DAT
UREL1 Repetitive Codes: Released By CHAR 12 0 REPETITIVE_REL_USER

FIBL_RPCODE foreign key relationships

Table Field Check Table Check Field
0 FIBL_RPCODE BANKL BNKA Bank master record BANKS
1 FIBL_RPCODE BANKS T005 Countries MANDT
1 FIBL_RPCODE BANKS T005 Countries LAND1
0 FIBL_RPCODE BUKRS T001 Company Codes BUKRS
1 FIBL_RPCODE CHAIN TBCHAIN0 Definition bank chains MANDT
1 FIBL_RPCODE CHAIN TBCHAIN0 Definition bank chains CHAINID
0 FIBL_RPCODE HBKID T012 House Banks BUKRS
1 FIBL_RPCODE HKTID T012K House Bank Accounts MANDT
1 FIBL_RPCODE HKTID T012K House Bank Accounts BUKRS
1 FIBL_RPCODE HKTID T012K House Bank Accounts HBKID
1 FIBL_RPCODE HKTID T012K House Bank Accounts HKTID
0 FIBL_RPCODE MANDT T000 Clients MANDT
1 FIBL_RPCODE PBUKR T001 Company Codes BUKRS
0 FIBL_RPCODE WAERS TCURC Currency Codes MANDT
0 FIBL_RPCODE WAERS TCURC Currency Codes WAERS
1 FIBL_RPCODE ZLSCH T042E Company Code-Specific Specifications for Payment Methods MANDT
1 FIBL_RPCODE ZLSCH T042E Company Code-Specific Specifications for Payment Methods ZBUKR
1 FIBL_RPCODE ZLSCH T042E Company Code-Specific Specifications for Payment Methods ZLSCH