SAP Payment Progam / Payment transfer (DE, JP, US) Tables

Are you looking for the right table related to SAP Payment Progam / Payment transfer (DE, JP, US) 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 Progam / Payment transfer (DE, JP, US) (FI-AP-AP-B) module.

Top 10 tables in Payment Progam / Payment transfer (DE, JP, US)

TableDescription
FIPAY_TROBJ_GTSTrigger Objects for Supplementary Information to SAP GTS
FPCL_CO_STATUSStatus of Garnishment
CRFILEHDPayment Card File: Header
FPRL_HEADERList Header Data
FIPAY_T042_GTSSAP GTS Check - Activation in FI
FPRL_CCODE_ACTActivation per paying company code
FIAPPTD_KUKEYID administration
CUP_DOC_ITDocument relevant for CUP/CIG Number
FPIN_T_REASONInterruption Reason
FIAPITD_PAYM_BLKStore the payment block for Italy based on Law 83/2013

List of tables in Payment Progam / Payment transfer (DE, JP, US)

TableDescription
FIPAY_TROBJ_GTSTrigger Objects for Supplementary Information to SAP GTS
FPCL_CO_STATUSStatus of Garnishment
CRFILEHDPayment Card File: Header
FPRL_HEADERList Header Data
FIPAY_T042_GTSSAP GTS Check - Activation in FI
FPRL_CCODE_ACTActivation per paying company code
FIAPPTD_KUKEYID administration
CUP_DOC_ITDocument relevant for CUP/CIG Number
FPIN_T_REASONInterruption Reason
FIAPITD_PAYM_BLKStore the payment block for Italy based on Law 83/2013
FPRL_LEVELSTDefine Approval Levels
FPRL_ITEM_STATTItem Status Attributes
FPRL_APPLICTApplication Attributes
FFO_OM_ACCOM_SHTOM Buffer: Payment Medium Accompanying Sheet
FPRL_LOGList Log
FPIN_T_ADMINTAdministrator - Penalty Interest: Description
FPRL_ACTIONSTDefine Actions
FPRL_ITEMItem Data
FPCR_USER_ACCAssignment of User to Accountant
BANK_CUP_ITBank Account Number related to CUP/CIG/MGO(new)
FPIN_T_POSTENDatabase for Penalty Interest (Chorus)
FPRL_TABSTab Attributes
FPCR_RDC_REASONTReduction Reason Description
FIPYXXD_INSTMTBank Statement File Identification Table
CRFILESTATPayment Card File: Status Information for Individual Records
CRACCPayment Cards: Account Assignments in Card Master Record
FPCR_ACC_BUKRSAssignment of Company Code to Accountant
FPIN_T_REASONTInterruption Reason Description
FPCR_WAITREASONTDescription of Wait Reason
FPCR_LINK_OBJLinked Objects for Garnishment
FPCL_ACC_PARAParameter for the Posting
TCRCOBLFLPayment Cards: Field Control
PYONUMKRAuxiliary structure for lock object EPYONUMKR
OPN_J1Japanese DME Foreign Payment Accounting Data (Open FI)
FPRL_DOC_DIDisable Document Changes for Approval Levels
T042Parameters for payment transactions
TCRSCODETPayment Cards: Texts for Selection Code
FPRL_APPLICApplication
TZGRGrouping rules for automatic payments
T042NBank transaction codes
FPRL_ACTION_DIActions for Approval Level
REGUVControl records for the payment program
FPCR_CESSGarnishment Register Attributes
T042OFIEvents for MT100 and other DME Formats
FPIN_T_ADMINAdministrator - Penalty Interest
FPCRATTRPROTECTAttributes may not be changed by the user direct
FPRL_LEVELSApproval Levels
CRNUMPayment cards: Card master record
TCRSCODEPayment Cards: Selection Code
REGUAChange of payment proposals: user and time
T042JBank charges determination
FPCR_RDC_REASONReduction Reason
FPCR_REDUCTIONReduction Data for Garnishment
T042ABank selection for payment program
FPRL_TABSTDefine Tabs
BANKA_CUP_ITBank Account Number maintenance for CUP/CIG Number
FPCR_NR_ACCAccountant Number Range
PYORDHPayment order header data
CRFILEPOSPayment Card File: Individual Records
FPRL_ITEM_STATItem Status
T042FSLLast additional selections used
FEDIWF1FI EDI: Person with signing authority
FPRL_TAB_ASSIGSet Tab Positions
T045TUser ID for bank transactions
T042UBlock Entries for Debit Customers/Credit Vendors
FPCR_WAITREASONWaiting Reason for Garnishment
TFAGSDefinition of FI clearing rules
DET_EXT_CATEGORYDetermine Exchange Rate Category
FPCL_CO_STATUSTDescription of Garnishment Status
PYORDPPayment order item data
FPRL_ACTIONSAction Attributes
FPCL_DETECT_COGarnishments for a Payment Document
TFAGTTexts on FI clearing rules
FPCR_ACCGarnishment Register Accountant
T042LBank transaction code names
CUP_T012K_ITHouse bank details for CUP/CIG
FPCR_ACC_GSBERAssignment Business Area to Accountant
FPCR_SRCH_ATTRSearch Fields for Garnishment
FPRL_CLEAR_DIDisable Clearing/Reverse for Approval Levels
FPCR_ACCTGarnishment Register Accountant Description
FPRL_ACTION_TABAssign Actions to Tabs
T005_IT_UICUIC Code
T042OFITEvents for MT100 and other DME Formats
T042SCharges/expenses for automatic pmnt transactions
REGUPProcessed items from payment program
TZGRTName of grouping rules
T042IAccount determination for payment program
REGUPOLine item status before the 'n'th change
T042RName of account holder (ref.specifications on bk.details)
REGUS_SEPASEPA Mandate Lock: Applications To Be Retrieved
T042MUser Numbers At The Bank
PNBKPrenotification: New bank data from master records
TBACNBank EDI file version numbers
TBSLPosting Key
REGUHHREGUH version before the 'n'th change
REGUSAcounts blocked by payment proposal
T042IYAccount Determination for Payment Programs
TCRINPayment Cards: Card Types
T004FField status definition groups
T005_IT_UICREGUIC Code based on region and country key
SMFIAPSpec. FI-SL Data in Monitor (See Schedman_specific_fisl)
TCRINTPayment Cards: Texts for Card Types
T042VValue date for automatic payments
REGUHOREGUH version before the 'n'th change
T042PBank selection by postal code
REGUHSettlement data from payment program
FPRL_WARNINGSSystem Warning Messages
T042DAvailable amounts for payment program
T042AAAddnl Acct Assgmnts for Down Payments with Purch. Order Ref.
T042JBCustomizing table for Japan Bank Mergers
T042JB1Customizing table for Japan Bank/Branch Mergers
T042Z_ADAssign Payment method to Acct Symbol
T042KAccounts for bank charges
PNHDPrenotification: Files created in ACH format
T042CTechnical Settings For The Payment Program
T042GGroups of company codes ( payment program )
T110_ACTActivation for changes in F110 accord. to Israel legislation
FPRL_APPLIC_ACTActivate Application