FIBL_RPCODE
Master Data for Repetitive Code
FIBL_RPCODE is an SAP database table in S/4HANA. Master Data for Repetitive Code. It contains 27 fields. 8 CDS views read from this table.
CDS Views using this table (8)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| Fclm_Bam_Acc_Cashpool | view | left_outer | Accounts in Cash Pool | |
| I_BankAccCashPoolTP | view | left_outer | TRANSACTIONAL | Bank Account Cash Pool |
| I_CashPool | view | inner | BASIC | Cash Pool Bank Account Relationship |
| I_RepetitiveCode | view | from | BASIC | Basic View for Repetitive Code |
| P_MakeBankTransferTemplate | view | from | BASIC | |
| P_PaytTransRepetitiveCode | view | from | BASIC | |
| P_RepetitiveCode | view | from | BASIC | |
| P_RepetitiveCodeBasic | view | from | BASIC |
Fields (27)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | bukrs | PRQ_ZBUKR | Paying CoCd | |||
| KEY | hbkid | HBKID | House Bank | |||
| KEY | rpcode | RPCODE | Repetitive Code | |||
| hktid | HKTID | Account ID | ||||
| chain | CHAINID | Bank Chain ID | ||||
| banks | BANKS | Bank Ctry/Reg. | ||||
| bankl | BANKK | Bank Key | ||||
| bankn | BANKN | Bank Account | ||||
| bkont | BKONT | Control Key | ||||
| bkref | BKREF | Reference | ||||
| koinh | KOINH_FI | Account holder | ||||
| ptype | GPA1T_CFM | BP Category | ||||
| partn | GPA1R_CFM | BP Reference | ||||
| parta | PARTAC | Bank Details | ||||
| pbukr | FI_PBUKR | Target Company Code | ||||
| zlsch | DZLSCH | Pymt Meth. | ||||
| waers | WAERS | Currency | ||||
| dcrea | ERDAT_BF | Created On | ||||
| ucrea | ERNAM_BF | Created By | ||||
| drele | REPETITIVE_REL_DAT | Release Date | ||||
| urele | REPETITIVE_REL_USER | Released By | ||||
| drel1 | REPETITIVE_REL_DAT | Release Date | ||||
| urel1 | REPETITIVE_REL_USER | Released By | ||||
| zpayment_system | PAYEE_PAYMENT_SYSTEM | Payee Payment System | ||||
| zalias_type | PAYEE_ALIAS_TYPE | Payee Alias Type | ||||
| zbank_alias | PAYEE_BANK_ALIAS | Payee Alias |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Master Data for Repetitive Code
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FIBL_RPCODE (
MANDT, -- Client [MANDT]
BUKRS, -- Paying CoCd [PRQ_ZBUKR]
HBKID, -- House Bank [HBKID]
RPCODE, -- Repetitive Code [RPCODE]
HKTID, -- Account ID [HKTID]
CHAIN, -- Bank Chain ID [CHAINID]
BANKS, -- Bank Ctry/Reg. [BANKS]
BANKL, -- Bank Key [BANKK]
BANKN, -- Bank Account [BANKN]
BKONT, -- Control Key [BKONT]
BKREF, -- Reference [BKREF]
KOINH, -- Account holder [KOINH_FI]
PTYPE, -- BP Category [GPA1T_CFM]
PARTN, -- BP Reference [GPA1R_CFM]
PARTA, -- Bank Details [PARTAC]
PBUKR, -- Target Company Code [FI_PBUKR]
ZLSCH, -- Pymt Meth. [DZLSCH]
WAERS, -- Currency [WAERS]
DCREA, -- Created On [ERDAT_BF]
UCREA, -- Created By [ERNAM_BF]
DRELE, -- Release Date [REPETITIVE_REL_DAT]
URELE, -- Released By [REPETITIVE_REL_USER]
DREL1, -- Release Date [REPETITIVE_REL_DAT]
UREL1, -- Released By [REPETITIVE_REL_USER]
ZPAYMENT_SYSTEM, -- Payee Payment System [PAYEE_PAYMENT_SYSTEM]
ZALIAS_TYPE, -- Payee Alias Type [PAYEE_ALIAS_TYPE]
ZBANK_ALIAS, -- Payee Alias [PAYEE_BANK_ALIAS]
PRIMARY KEY (MANDT, BUKRS, HBKID, RPCODE)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA