SAP Payment Transactions Tables

Are you looking for the right table related to SAP Payment Transactions Tables to query in an ABAP Program, Class, Function Module and OData API?

There are number of standard tables in SAP S/4HANA system. The data of an application is distributed across several database fields. Finding the right table is important, in this post we'll look at list of all the tables in Payment Transactions (FI-BL-PT) module.

Top 10 tables in Payment Transactions

TableDescription
TFIBLORIGINCOrigin Settings
T042FPayment method supplements
TCJ_POSITIONSCash Journal Document Items
TCJ_PRINTCash Journal Print Parameters
TCJ_MAX_AMOUNTCash Journal: Amount Limit
T042WFMaintenance of Prop. Run: Activate Workflow per Company Code
TFIBLHBG1Group of House Bank Accounts: Details
T015W1TInstructions (explanatory text)
TFIBLHBGGroup of House Bank Accounts
PCECPrenumbered Checks

List of tables in Payment Transactions

TableDescription
TFIBLORIGINCOrigin Settings
T042FPayment method supplements
TCJ_POSITIONSCash Journal Document Items
TCJ_PRINTCash Journal Print Parameters
TCJ_MAX_AMOUNTCash Journal: Amount Limit
T042WFMaintenance of Prop. Run: Activate Workflow per Company Code
TFIBLHBG1Group of House Bank Accounts: Details
T015W1TInstructions (explanatory text)
TFIBLHBGGroup of House Bank Accounts
PCECPrenumbered Checks
HBNK_LOGADR_FIEBAssignment of House Bank to Logical Address
FIEB_STATUS_LOCKDummy to Block Status According to Non-Primary Key Fields
T042QPermitted Destination Lands for Payment Method
T042ZTTexts of Payment Methods for Automatic Payment
T015W0Allocate application areas to instruction fields
TVOITCheck void reason code texts
FIBL_RPCODE_GROUGroups of Repetitive Codes
T015WTExplanation of Instruction Key
OFX_BP_MSGS_FIEBCustomizing of OFX Message Sets for Business Processes
TCJ_TRANSACTIONSCash Journal Business Transactions
ACRELATIONRelationships in Accounting
FIBL_RPCODEMaster Data for Repetitive Code
FIEB_OID_LOCKUsed to Lock any Given Objects Using Their OID
FIEB_STATUSVStatus Values for Internet Messages
BUSPROC_FCT_FIEBFIEB: Function Modules for Business Process
T015LSCB Ratios
FIEBLOPRFIEB: Attribute Values of Logical Documents
TCJ_CJ_NAMESCash Journal Names
FIEBREFIEB: Instances of Relationships
PAYRPayment Medium File
T042WPermitted currency keys for payment method
T015VApplication Area for Instructions in Payment Transactions
TFIBLORIGINOrigin Indicator
FIEBLORIFIEB: Incoming Relationships of Physical Documents
T042ECompany Code-Specific Specifications for Payment Methods
FIEB_BUSPROBusiness Processes in Applications
TCJ_NUMB_GROUPTNumbering Group for Cash Documents (Text)
REGUH_WFRMaintenance of Proposal Run: Workflow Rules per Proposal Run
TCJ_NUMB_GROUPNumbering Group for Cash Documents
FIEBCHKOFIEB: Check-Out Data on a Physical Document
FIEBPHHRFIEB: Outgoing Hyperlinks From Physical Documents
TCJ_TRANS_NAMESCash Journal Business Transaction Names
T042BDetails on the company codes that must pay
FIEBCHKFFIEB: File Name of Last Check-Out
FIBL_CLRG_RGSTRYRegistry for bank ledger clearing service
REGUHMPayment Data for Cross-Payment Run Payment Medium
REGUVM_HDecision for Cross-Payment-Run Payment Media (BAdI)
T042YPAccount Determination for HR Payments
OFX_VERSION_FIEBAttributes for a DTD Version of OFX
FIEBPHIOFIEB: Instances of Physical Documents
REGUH_WFSMaintenance of Proposal Run: Workflow Sts per Work Package
FIEBPHPRFIEB: Physical document attributes
TFIBLOPAYSTEPOnline Payments: Determine Process Steps
FIEBPHRIFIEB: Incoming Relationships of Physical Documents
FIEB_PASSWORDPasswords (stored in encrypted form)
TFIBLOPVAROnline Payment: Administration of Variants
TCJ_WTAX_ITEMSWithholding Tax Items for Cash Journal Document Items
FIEB_STATUSVTNames of Status Values for Internet Messages
OFX_LA_MSGS_FIEBMessage Sets per Business Process
FIBL_RPCODE_GRTXGroup Names of Repetitive Code
REGUVMPayment Data for Cross-Payment Run Payment Medium
TFIBLHBGTName of the House Bank Groups
TFIBLMPAYBLOCKReservation for Cross-Payment Run Payment Media
TFIBLOPAYOrigin of Online Payments
FIEBPHFFIEB: Physical document files
TFIBLFFPVAROnline Payment: Variants
TFIBLMPVAROnline Payment: Variants
TFIBLORIGINTMeaning of an Origin Indicator
FIEBPHNMFIEB: Use of Target Anchors in Physical Documents
REGUP_COREProcessed Items from Payment Program
FIEBLOIOTFIEB: Descriptions of Logical Documents
T042HText table for additional payment methods
TFIBLORIGINDAssignment of Origin to Overriding Origin
LOGADR_PHAD_FIEBPhysical Address for a Logical Address
TFIBLOPDOCTYPEDocument Types for Online Payments
PAYR_XBANC_HRTemporary Storage in FI for Cashed HR Checks
T015VTLong text for application areas
FIEBPHREFIEB: Outgoing Relationships of Physical Documents
LOGADR_ATTR_FIEBAttributes of Logical Addresses
FIBL_RPCODE_GRELAssign Repetitive Codes/Groups
FIEBCONT1FIEB: Table for Document Contents (Import/Export)
FIEB_BUSPROTNames of Application Business Processes
FIEBLOIOFIEB: Instances of Logical Documents
TCJ_CHECK_STACKSCheck Lists in Cash Journal
REGUH_WFAMaintenance of Proposal Run: Workflow Package per Account
FIEBLOREFIEB: Outgoing Relationships of Logical Documents
TCJ_C_JOURNALSCash Journals
T042ZPayment Methods for Automatic Payment
FIBL_RPCODE_TDEFDefault Values for Repetitive Codes
TFIBLMPAYBLOCKIDRun Identification for Cross-Payment Run Payment Medium
FIEBREPRFIEB: Attributes of Relationships
T042WFRMaintenance of Proposal Run: Workflow Rules
TFIBLAPARPVAROnline Payment: Variants
T015WInstruction keys
TCJ_DOCUMENTSCash Journal Documents (Header Data)
T012DParameters for DMEs and foreign pmnt transactions
FIEB_STATUSFIEB: Status Management, Save Status
GENERAL_EB_FIEBGeneral Customizing Table for Electronic Banking
TVOIDCheck void reason codes
T015W1Instructions
TCJ_CPDFBCJ: One-Time Account Data of Cash Journal Document Items