2019-02-27
Financial Accounting
Table Name Description Important Fields
Financial Accounting
FBAS Financial Accounting “Basis”
BKPF Accounting Document Header BUKRS / BELNR / GJAHR
BSEG Accounting Document Segment BUKRS / BELNR / GJAHR / BUZEI
BSIP Index for Vendor Validation of Double BUKRS / LIFNR / WAERS / BLDAT /
Documents XBLNR / WRBTR / BELNR / GJAHR / BUZEI
BVOR Inter Company Posting Procedure BVORG / BUKRS / GJAHR / BELNR
EBKPF Accounting Document Header (docs from GLSBK / BELNR / GJHAR / GLEBK
External Systems)
FRUN Run Date of a Program PRGID
KLPA Customer / Vendor Linking NKULI / NBUKR / NKOAR / PNTYP
/ VKULI / VBUKR / VKOAR
KNB4 Customer Payment History KUNNR / BUKRS
KNB5 Customer Master Dunning Data KUNNR / BUKRS / MABER
KNBK Customer Master Bank Details KUNNR / BANKS / BANKL / BANKN
KNC1 Customer Master Transaction Figures KUNNR / BUKRS / GJHAR
KNC3 Customer Master Special GL Transactions KUNNR / BUKRS / GJAHR / SHBKZ
Figures
LFB5 Vendor Master Dunning Data LIFNR / BUKRS / MABER
LFBK Vendor Master Bank Details LIFNR / BANKS / BANKL / BANKN
LFC1 Vendor Master Transaction Figures LIFNR / BUKRS / GJHAR
LFC3 Vendor Master Special GL Transactions LIFNR / BUKRS / GJHAR / SHBKZ
Figures
VBKPF Document Header for Document Parking AUSBK / BUKRS / BELNR / GJHAR
FBASCORE Financial Accounting General Services “Basis”
KNB1 Customer Master (Company Code) KUNNR / BUKRS
LFA1 Vendor Master (General Section) LIFNR
LFB1 Vendor Master (company Code Section) LIFNR / BUKRS
SKA1 G/L Account Master (Chart of Accounts) KTOPL / SAKNR
SKAT G/L Account Master (Chart of Accounts – SPRAS / KTOPL / SAKNR
Description)
MAHNS Accounts Blocked by Dunning Selection KOART / BUKRS / KONKO / MABER
MHNK Dunning Data (Account Entries) LAUFD / LAUFI / KOART / BUKRS /
KUNNR / LIFNR / CPDKY / SKNRZE /
SMABER / SMAHSK / BUSAB
FI-GL-GL (FBS) General Ledger Accounting: Basic Functions- G/L Accounts
SKAS G/L Account Master (Chart of Accounts – SPRAS / KTOPL / SAKNR / SCHLW
Key Word list)
SKB1 G/L Account Master (Company Code) BUKRS / SAKNR
FI-GL-GL (FBSC) General Ledger Accounting: Basic
Functions - R/3 Customizing for G/L Accounts
FIGLREP Settings for G/L Posting Reports MANDT
TSAKR Create G/L account with reference BUKRS / SAKNR
FI-GL-GL (FFE) General Ledger Accounting: Basic
Functions - Fast Data Entry
KOMU Account Assignment Templates for G/L KMNAM / KMZEI
Account items
FI-AR-AR (FBD) Accounts Receivable: Basic Functions - Customers
KNKA Customer Master Credit Management : KUNNR
Central Data
KNKK Customer Master Credit Management : KUNNR / KKBER
Control Area Data
KNKKF1 Credit Management : FI Status data LOGSYS / KUNNR / KKBER / REGUL
RFRR Accounting Data – A/R and A/P RELID / SRTFD / SRTF2
Information System
FI-BL-PT Bank Accounting: Payment (BFIBL_CHECK_D) Transactions – General Sections
PAYR Payment Medium File ZBUKR / HBKID / HKTID / RZAWE /
CHECT
PCEC Pre-numbered Check ZBUKR / HBKID / HKTID / STAPL
FI-BL-PT-AP(FMZA)Bank Accounting: Payment Transactions – Automatic Payments
F111G Global Settings for Payment Program for MANDT
Payment Requests
FDZA Cash Management Line Items in Payment KEYNO
Requests
PAYRQ Payment Requests KEYNO
What is the table name for G/L Master data, when we create centrally (T.Code - FS00)?
As far as general ledger master data is concerned, the following tables are involved :
Table name : SKB1 : G/L Account Master ( Company Code)
Fields:
BUKRS : Company Code
SAKNR : G/L Account
Table name : SKA1 : G/L Account Master ( Chart of Accounts )
Fields:
KTOPL : Char of Accounts
SAKNR : G/L Account
Table name : SKAT : G/L Account Master Record ( Chart of Accounts : Description )
Fields:
SPRAS : Language
KTOPL : Char of Accounts
SAKNR : G/L Account
SAP Tables for Master DataWritten by Selva Kumar
Material master :
MARA Material master
MAKT Material text
MARC Material per plant / stock
MVKE Material master, sales data
MARD Storage location / stock
MSKA Sales order stock
MSPR Project stock
MARM Units of measure
MEAN International article number
PGMI Planning material
PROP Forecast parameters
MAPR Link MARC <=> PROP
MBEW Material valuation
MVER Material consumption
MLGN Material / Warehouse number
MLGT Material / Storage type
MPRP Forecast profiles
MDTB MRP table
MDKP Header data for MRP document
MLAN Tax data material master
MTQSS Material master view: QM
Basic data text (sap script)
STXB SAPscript: Texts in non-SAPscript format
STXH STXD SAPscript text file header
STXL STXD SAPscript text file lines
Batches
MCHA Batches
MCH1 Batches
MCHB Stock : batches
Customer master data
KNA1 Customer master
KNB1 Customer / company
KNVV Customer sales data
KNBK Bank details
KNVH Customer hierarchy
KNVP Customer partners
KNVS Shipment data for customer
KNVK Contact persons
KNVI Customer master tax indicator
Vendor
LFA1 Vendor master
LFB1 Vendor per company code
LFB5 Vendor dunning data
LFM1 Purchasing organisation data
LFM2 Purchasing data
LFBK Bank details
Customer – material info record
KNMT Customer material info record
Bank data
BNKA Master bank data
T093A ~ D ASSET DEPRE Control table
T095 ASSET Account Determination table
NUMBER RANGE TABLE:
NRIV Number Range Intervals； FI - OBJECT: RF_BELEG NewGL: FAGL_DOCNR
Subobject value: ON BEHALF OF COMPANY CODE
Materials Management Tables
BSIK Accounting: Secondary index for vendors
EINA Purchasing Info Record: General Data EINE Purchasing Info Record: Purchasing Organization Data MAKT Material Descriptions
MARA Material Master
MARC Material Master Plant segment
MARD Material Master: Storage location
MAST Material to BOM Link
MBEW Material valuation
MKPF Material document header MSEG Material document segment
MVER Material Consumption
RKPF Document Header: Reservation
T023 Material types T024 Purchasing Groups
T156 Movement Type T157H Help Texts for Movement Types
Purchasing Tables A501 Winter Rate- Purch. Org/Material
EBAN Purchase Requisition
EBKN Purchase Requisition Account Assignment
EKAB Release Documentation
EKBE History of Purchasing Document
EKET Scheduling Agreement Delivery Schedules
EKKN Account Assignment in Purchasing Document
EKKO Purchasing document header (PO)
EKPO Purchasing document item
IKPF Header: Physical Inventory Document
ISEG Physical Inventory Document Items
LFA1 Vendor master
LFB1 Vendor master (company code)
NRIV Number range intervals RESB Reservation/dependent requirements
T161T Texts for Purchasing Document Types
PM/SM/SD Tables AFAB Network - Relationships
AFFH PRT assignment data for the work order AFFL Work order sequence
AFFT Order process instructions
AFFV Order process instruction values
AFFW Goods movements with errors from confirmations
AFIH Maintenance order header AFKO Order header data PP orders
AFPO Order item
AFRC Table of planned changes to conf.: Automatic goods receipt
AFRD Default values for collective confirmation
AFRH Header information for confirmation pool
AFRU Order completion confirmations
AFRV Pool of confirmations
AFVC Operation within an order AFVU DB structure of the user fields of the operation
AFVV DB structure of the quantities/dates/values in the operation
AFWI Subsequently posted goods movements for confirmations
AUFK Order master data AUFM Goods movement for order BGMK Master warranty header BGMP Master warranty item
BGMS Text item master warranty
BGMT Master warranty text BGMZ Warranty counter information
CRHD Work Center Header CRTX Text for the Work Center or Production Resource/Tool
EQKT Equipment short texts
EQST Equipment link to BOM
EQUI Equipment master data EQUZ Equipment time segment
HIKO Order master data history
IFLO Functional Location (View)
IFLOT Functional location (TABLE)
IFLOTX Functional location: Short texts
IHGNS Plant maintenance permit segment
IHPA Plant Maintenance: Partners
IHSG Object-related permits in Plant Maintenance
ILOA PM object location and account assignment
IMPTT Measuring point (table)
IMRG Measurement document
KAKO Capacity Header Segment
KONP Conditions (Item)
KONV Conditions (Procedure Data)
OBJK Plant Maintenance Object List
QMEL Quality notification
QMFE Quality notification - items
QMIH Quality message - maintenance data excerpt
QMMA Quality notification - activities
QMSM Notification - Tasks
QMUR Quality notification - causes
STPOA Name is does not have an A at the end; BOM items
T001 Company Codes
T001L Storage Locations
T001W Plants
T077D Customer account groups
T003O Order Types T352R Maintenance revisions
T353I_T Maintenance activity type description
T356 Priorities
T357G Permits
T357G_T Table 357G texts
T370A Activity category for PM lists
TINCT Customers: Incoterms: Texts
TVKO Organizational Unit: Sales Organizations
TVKOS Organizational Unit: Divisions per Sales Organization
TVKOV Org. Unit: Distribution Channels per Sales Organization
TVTA Organizational Unit: Sales Area(s)
VIAUFKST Order selection view
FI Tables
AGKO Cleared accounts
ANAR Asset Types ANAT Asset type text ANEK Asset Document header ANEP Asset document Items
ANEV Asset downpymt settlement
ANKT Asset text ANLA Asset master
ANLB Asset - Depreciation terms
ANLC Asset values
ANLH Main asset number AT02T Transaction Activity Category: Description
AT02A Transaction Code for Menu TIMN
AT10 Transaction type AT10T Name of Transaction Type BKDF Document header supplement for recurring entry
BKORM Accounting correspondence requests
BKPF Accounting document header BLPK Document log header BLPP Document log item
BLPR Document log index and planned order (backflush)
BNKA Bank master record
BP000 Business Partner Master (General Data)
BPBK Budget revision text BPEG Budget revision header BPEJ Budget revision header BPEP Line Item Period Values牋?
BPGE Overall/annual budget
BPJA Overall/annual budget
BSAD Accounting: Secondary index for customers (cleared items)
BSAK Accounting: Secondary index for vendors (cleared items)
BSAS Accounting: Secondary index for G/L accounts (cleared items)
BSEC One-time account data document segment
BSEG Accounting document segment
BSID Accounting: Secondary index for customers
BSIK Accounting: Secondary index for vendors
BSIM Secondary Index, Documents for Material
BSIS Accounting: Secondary index for G/L accounts
CEPC Profit center master data table CEPCT Texts for Profit Center Master Data COBRA Settlement rule for orders
COBRB Distribution settlement rules
COKA CO Object: Cost Element Control Data COSP External actual costs
COSS Internal actual costs
CRCO Assignment of Work Center to Cost Center
CSKA Cost elements (data dependent on chart of accounts)
CSKB Cost elements (data dependent on controlling area)
CSLA Activity master
FEBEP Electronic Bank Statement Line Items
FPLA Billing Plan
FPLT Billing Plan: Dates
GLPCT EC-PCA: Totals Table KNA1 General Data in Customer Master
KOMK Pricing communications
MAHNV Management records for the dunning program REGUT TemSe - administration data SKA1 G/L accounts master (chart of accounts)
SKAT G/L account master record (chart of accounts: description)
SKB1 G/L account master (company code)
T003T Document type texts
T007S Tax Code Names
T087J Text (Investments)
TAPRFT Text tab. for investment profile
TKA01 Controlling areas
TKA09 Basic settings for versions
TKVS CO versions
TZB0T Flow types text table TZPAT Financial Assets Management product type texts
VBSEGS Preliminary posting doc.segment for G/L accts
VTBFHA Transaction VTBFHAPO Transaction Flow
VTBFHAZU Transaction Activity
VTBFINKO Transaction Condition
VTIDERI Master Data Listed Options and Futures
VTIFHA Underlying transaction VTIFHAPO Underlying transaction flows
VTIFHAZU Underlying transaction status table VTIOF Futures and Options
VWPANLA Asset master
Class & Characteristic Tables, & OTHERS AUSP
CABN Characteristics?
CABNT Characteristic Descriptions
JCDS Change Documents for System/User Statuses (Table JEST)
JEST Object status
JSTO Status object information
KLAH Class Header Data KSML Characteristics of a Class KSSK Allocation Table: Object to Class ONR00 General Object Number ONROR Object Number Index, Order SWOR Classification System: Catchwords
TCLA Class Types TCLAT Class Type Texts
TCO09 CIM order: Text IDs of objects in orders
TJ02T System status texts
TJ30T User status texts
Object Part Tables QPCT Code texts
QPGR Inspection catalog code groups
QPGT Code group texts
TQ15 Inspection catalog type index
HR Tables/Infotypes
CATSCO Cross-Application Time Sheet (CATS): Transfer to CO CATSDB CATS: Database for Time Recording Sheet
CATSHR Cross-Application Time Sheet (CATS): Transfer to HR
CATSMM Cross-Application Time Sheet (CATS): Transfer to MM
CATSPM Cross-Application Time Sheet (CATS): Transfer to PM/SM
CATSPS Cross-Application Time Sheet (CATS): Transfer to PS
CSKS Cost center master
CSKT Cost Center Texts
HRP1000 Infotype 1000 DB Table HRP1001 Infotype 1001 DB Table HRP1028 Infotype 1028 DB Table Paxxxx transparent tables for infotypes PCL1 HR Cluster 1 PCL2 HR Cluster 2 PERNR Standard Selections for HR Master Data Reporting (Structure)
T001P Personnel Area/Subarea
T001T Company code-dependent texts
T500L Personnel Country Grouping
T500P Personnel Areas
T502T Marital Status Designators
T503 Employee Groups / Subgroups
T503T Employee Subgroup Names
T508A Work Schedule Rules
T510 Pay Scale Groups
T510A Pay Scale Types T510F Assign pay scale --> Currency
T510W Pay Scale > Period Parameter Assignment
T511 Wage Types T512T Wage type texts
T512W Wage Type Valuation
T512Z Permissibility of Wage Types per Infotype
T527X Organizational Units
T528T Position Texts
T529T Personnel Action Texts
T529U Status Values
T530 Reason for action?
T530T Reason for Action Texts
T549A Payroll Accounting Areas
T549Q Payroll Periods
T550A Daily Work Schedules
T550S Daily Work Schedule Texts
T551S Period Work Schedule Texts
T552A Monthly work schedule
T554C Absence Valuation
T554S Absence and Attendance Types T554T Absence and Attendance Texts
T558B Payroll Account Transfer: Payroll Periods
T569V Payroll Control Records
T5K8C Transfer ext. payroll results into Canadian specific tables T74FA Benefits insurance plan
T74FC Benefits Calculation Rule for Insurance Coverage Formula
Infotypes 0 Actions 1 Org. Assignment 2 Personal Data 3 Payroll status 6 Addresses 7 Planned Working Time 8 Basic pay 9 Bank details 11 Ext.Bank Transfers 14 Recurring Benefits/Deductions 15 Additional Payments 19 Monitoring of Dates 21 Family 22 Education 23 Previous employment 24 Qualifications 41 Date Specifications 57 Membership Fees 167 Health Care Plans 168 Insurance Plans 169 Savings Plans 376 Medical Benefits Data 377 Misc. Plans 416 Time Quota Compensation 2001 Absences 2002 Attendances 2003 Substitutions 2006 Absence Quotas
PS Tables AFAB Network - Relationships
IMAK Appropriation requests
IMAV Appropriation request variants
IMPR Capital Investment Program Positions
IMPU Texts for cap. inv. program positions
IMTP Capital Investment Programs
IMZO CO object assignment
PMCO Cost structure of maintenance order PRHI WBS Hierarchy
PROJ Projects
PRPS Work Breakdown structures
System Tables ADCP Person/Address assignment (central address administration)
ADIRACCESS Table to store keys for TADIR objects
ADR2 Telephone numbers (central address admin.)
ADRP Persons (central address administration)
APQD DATA DEFINITION Queue
APQI Queue info definition D010SINF ABAP/4: Information about ABAP/4 program source code E071 WBO + transport: Object entries of requests/tasks
E07T WBO + transport: Short texts for requests/tasks
ENLFDIR Additional Attributes for Function Modules
INDX System table INDX
NAST Message status
STXH STXD SAPscript text file header T005 Countries
T005S Taxes: Region (Province) Key T005U Taxes: Region Key: Texts
T006 Units of Measurement
T015M Names of the months
T247 Month name and short text T777A Building Addresses
TADIR Catalog of R/3 Repository objects
TBTCO Job status overview table TBTCP Batch job step overview
TFDIR Function Modules
TFTIT Function module short text TSP03L Spool: Long device names
TSTC Transaction codes
TSTCT Transaction Code Texts
TUTYP User types in the R/3 System
TUZUS Special versions
TVARV Table of variables in selection criteria
TVDIR View Directory
US930 Data relevant to measurement for user master record
USR01 User master record (runtime data)
USR02 Logon data USR04 User master authorizations
USR06 Additional data per user
USR14 Surchargeable language versions per user
USR21 Assign user name address key
