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