Sap Tables1

SAP Account Payable Table

Post Series: SAP Financial Tables

SAP Account Payable table list

  • Payment Transactions
  • Account Payable Table – others

Payment Transactions

Application table (master and transaction data)
BANKA_CUP_IT – Bank Account Number maintenance for CUP/CIG Number
CRACC – Payment Cards: Account Assignments in Card Master Record
CRFILEHD – Payment Card File: Header
CRFILEPOS – Payment Card File: Individual Records
CRFILESTAT – Payment Card File: Status Information for Individual Records
CRNUM – Payment cards: Card master record
CUP_DOC_IT – Document relevant for CUP/CIG Number
FIPAY_TROBJ_GTS – Trigger Objects for Supplementary Information to SAP GTS
FPCL_DETECT_CO – Garnishments for a Payment Document
FPCR_CESS – Garnishment Register Attributes
FPCR_LINK_OBJ – Linked Objects for Garnishment
FPCR_REDUCTION – Reduction Data for Garnishment
FPIN_T_POSTEN – Database for Penalty Interest (Chorus)
FPRL_HEADER – List Header Data
FPRL_ITEM – Item Data
FPRL_LOG – List Log
FPRL_WARNINGS – System Warning Messages
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
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
REGUHO – REGUH version before the ‘n’th change
REGUPO – Line item status before the ‘n’th change
REGUS – Acounts blocked by payment proposal
REGUS_SEPA – SEPA Mandate Lock: Applications To Be Retrieved
REGUV – Control records for the payment program
SMFIAP – Spec. FI-SL Data in Monitor (See Schedman_specific_fisl)

Control table, SAP and customer have separate key areas
FPRL_ACTION_TAB – Assign Actions to Tabs
FPRL_ACTIONS – Action Attributes
FPRL_ACTIONST – Define Actions
FPRL_APPLIC – Application
FPRL_APPLICT – Application Attributes
FPRL_TAB_ASSIG – Set Tab Positions
FPRL_TABS – Tab Attributes
FPRL_TABST – Define Tabs
T042OFI – Events for MT100 and other DME Formats
T042OFIT – Events for MT100 and other DME Formats

Customizing table, maintenance only by cust., not SAP import
CUP_T012K_IT – House bank details for CUP/CIG
FEDIWF1 – FI EDI: Person with signing authority
FIPAY_T042_GTS – SAP GTS Check – Activation in FI
FPCL_ACC_PARA – Parameter for the Posting
FPCR_ACC – Garnishment Register Accountant
FPCR_ACC_BUKRS – Assignment of Company Code to Accountant
FPCR_ACC_GSBER – Assignment Business Area to Accountant
FPCR_ACCT – Garnishment Register Accountant Description
FPCR_NR_ACC – Accountant Number Range
FPCR_RDC_REASON – Reduction Reason
FPCR_RDC_REASONT – Reduction Reason Description
FPCR_SRCH_ATTR – Search Fields for Garnishment
FPCR_USER_ACC – Assignment of User to Accountant
FPCR_WAITREASON – Waiting Reason for Garnishment
FPCR_WAITREASONT – Description of Wait Reason
FPIN_T_ADMIN – Administrator – Penalty Interest
FPIN_T_ADMINT – Administrator – Penalty Interest: Description
FPIN_T_REASON – Interruption Reason
FPIN_T_REASONT – Interruption Reason Description
FPRL_ACTION_DI – Actions for Approval Level
FPRL_APPLIC_ACT – Activate Application
FPRL_CLEAR_DI – Disable Clearing/Reverse for Approval Levels
FPRL_DOC_DI – Disable Document Changes for Approval Levels
FPRL_LEVELS – Approval Levels
FPRL_LEVELST – Define Approval Levels
T005_IT_UIC – UIC Code
T005_IT_UICREG – UIC Code based on region and country key
T042C – Technical Settings For The Payment Program
T042JB – Customizing table for Japan Bank Mergers
T042JB1 – Customizing table for Japan Bank/Branch Mergers
T042R – Name of account holder (ref.specifications on bk.details)
T045T – User ID for bank transactions
T079M – Vendor master data screen selection (purch.org.)
T110_ACT – Activation for changes in F110 accord. to Israel legislation
TCRCOBLFL – Payment Cards: Field Control
TCRIN – Payment Cards: Card Types
TCRINT – Payment Cards: Texts for Card Types
TCRSCODE – Payment Cards: Selection Code
TCRSCODET – Payment Cards: Texts for Selection Code
TFAGS – Definition of FI clearing rules
TFAGT – Texts on FI clearing rules

Customizing table, protected against SAP Upd., only INS all.
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

System table, maint. only by SAP, change = modification
FPCL_CO_STATUS – Status of Garnishment
FPCL_CO_STATUST – Description of Garnishment Status
FPCRATTRPROTECT – Attributes may not be changed by the user direct
FPRL_ITEM_STAT – Item Status
FPRL_ITEM_STATT – Item Status Attributes

Table for storing temporary data, delivered empty
T042FSL – Last additional selections used
T042U – Block Entries for Debit Customers/Credit Vendors

SAP Account Payable Table s – Others

Application table (master and transaction data)
/PTGWFI/F_SMIMTR – SMI Process Monitor
KNBW – Customer master record (withholding tax types) X
LFAT – Vendor master record (tax groupings)
LFBW – Vendor master record (withholding tax types) X
LFSSTN – Sustainability details for Vendor
LFSSTN_CERT – Vendor sustainability certificates
REGUPW – W/tax information per w/tax type/FI line item in pmnt run
TRFKREDEB_SYNC – Synchronization of Customer Master Data
WITH_ITEM – Witholding tax info per W/tax type and FI line item
WITH_ITEM_EXCL – Withholding Tax Info per WTax Type (Exclusion)
WTAD – Cumulative values for accounts receivable
WTADP – Cumulative values for accounts receivable (payment proposal)
WTADPN – Cumulative values for accounts receivable (payment proposal)
WTAK – Cumulative values for accounts payable
WTAKP – Cumulative values for accounts payable (payment proposal)
WTAKPN – Cumulative values for accounts payable (payment proposal)
WTMIG_PROT1 – Withholding Tax Changeover: Global Log Data
WTMIG_PROT2 – Withholding Tax Changeover: Detailed Log Data
WTMIG_TABKEY – Withholding Tax Changeover: Keys of Table Entries Added
WTMIGBK – Withholding Tax Changeover – Selected Company Codes
WTMIGCOUNT – Current Number Level of Withholding Tax Conversion Runs
WTMIGGJAHR – Withholding Tax Changeover: Year-Dependent Document Convers.
WTMIGIF – Withholding Tax Changeover: Commands Executed by Tool
WTMIGJOB – Withholding Tax Changeover: Last Job Started
WTMIGMATCH – Withholding Tax Changeover: Creation of Code -> Type/Code
WTMIGMESS – Messages Logged for Withholding Tax Changeover
WTMIGRUN – Withholding Tax Conversion Run
WTMIGSTEP – Steps in Conversion Run
WTMIGTEXT – Text for Withholding Tax Changeover Run
WTMIGTYP – W/Tax Changeover: Number of W/Tax Types in Master Record

Control table, SAP and customer have separate key areas
QSTRLST – List Configuration for Reporting Extended Withholding Tax
QSTRLST_CRIT – Group.Criteria for List Config. for Ext.W/holding Tax Report
QSTRVAR – Reporting Variants RFWTINT10
QSTRVARF – Free Selection for Generic Withholding Tax Reporting
QSTRVART – Report Variants RFWTINT10 Texts
TVENDCUST_SCGR – Definition of Screen Groups for Customers and Vendors
TVENDCUST_SCGRT – Texts for Screen Groups for Customer and Vendor Master Data

Customizing table, maintenance only by cust., not SAP import
/PTGWFI/F_SMIBDC – BDC Table for Creating Document
/PTGWFI/F_SMIRSN – Suspend reason definition table
/PTGWFI/F_SMIRST – Supsension Reson Description
RF07 – Withholding tax in Italy : Modello 770 – additional data
T001RWT – Rounding rules for company code, withhold.tax type and curr.
T001WT – Company code-specific information per withholding tax type
T007C – Groupings for tax codes
T007D – Texts for Tax Groups
T046R – Texts for the exceptions from cashed bills/exch.fr.vendors
T046S – Exceptions from cashed bills of exchange paid to vendors
T059C – Types of Recipient: Vendors per Withholding Tax Type
T059D – Types of Recipient: Vendors per Withholding Tax Type
T059FB – Formulae for calculating withholding tax (new functions)
T059FBH – W/tax formulae: Header
T059K – Withholding tax code and processing key
T059MINMAX – Minimum and maximum amounts for withholding tax
T059O – Official withholding tax key – Descriptions
T059OT – Text table: Official withholding tax key descriptions
T059P – Withholding tax types
T059REXT – Reporting key (new withholding tax)
T059U – Text Table: Withholding Tax Types
T059V – Reasons for exemption per withholding tax type
T059W – Reasons for exemption per withholding tax type
T059Z – Withholding tax code (enhanced functions)
T059Z_WITHCD2 – Entity Table: Additional Official Withholding Tax Code
T059Z_WITHCD2T – Text Table: Additional Official Withholding Tax Code
T059ZT – Text table: Withholding tax codes
T059ZZINS – Withholding tax code for interest calculation
WITH_CTNCL – Numbering class for withholding tax certificate numbers
WITH_CTNCLT – Numbering class text table for withholding tax certificate
WITH_CTNCO1 – Withholding tax certificate numbering concept 1
WITH_CTNCO2 – Withholding tax certificate numbering concept 2
WITH_CTNCO3 – Withholding tax certificate numbering concept 3
WITH_CTNGR – Numbering group for withholding tax certificate numbers
WITH_CTNGRT – Numbering group text table for withholding tax certificate
WITH_CTNUM – Allocation of numbering group to numbering class
WITH_EXCL_STR_HD – Derivation Strategies for Exclusion of Lines in Withhold.Tax
WITH_EXCL_STR_T – Derivation Strategies for Exclusion (Texts)
WITH_EXCL_WITHT – Assignment to Withholding Tax Type
WTMIGMESSEXC – Withholding Tax Changeover: Alternative Message Types

Customizing table, protected against SAP Upd., only INS all.
/PTGWFI/F_SMIMSG – Message Code for each transaction that carries the object

System table, maint. only by SAP, change = modification
QSTRCRIT – Grouping Criteria for List Output for W/holding Tax Report.
QSTRDSR – Data Source for Reporting Extended Withholding Tax
QSTRDSRT – Texts for Data Sources for Reporting Ext. Withholding Tax
WITH_CTNCOKEY – Withholding tax certificate numbering: Concepts
WITH_CTNCOKEYTXT – Texts: Withholding tax certificate numbering concepts

Table for storing temporary data, delivered empty
WTMIGTC – Changeover – Assgt of Classic W/Tax Code to Ext.Type/Code

Leave a Reply

Your email address will not be published. Required fields are marked *