SAP

Easy way to remember table in SAP

The easiest way to remember the table in SAP is:

Just try to remember the SAP terminology of representing the business or business objects... such as

Particular

Starts with

Example

Vendor

L

LFA1

Customer

K

KNA1, KONV

Sales

V

VBAK, VBAP

Bank

B

BKNF, BKPF

Purchasing

E

EKKO, EKPO

Material

M

MARA, MAKT, MARC

Master

T

T001, T001W

 

Particular

Header Table - contains

Example

Item Table - contains

Example

Sales,
Delivery,
Billing,
Purchasing …

K

VBAK, LIKP, VBRK, EKKO

P

VBAP, LIPS, VBRP, EKKO

Finance Tables:

Contains

Meaning

Example

I

Open Item

BSID

A

Closed Item

BSAD

 

Ends

Meaning

Example

S

G/L Master Open Item

BSIS, BSAS

D

Customer related

BSID

K

Vendor related

BSIK

By: Shailesh Singh | 07 Aug 2009 1:35 am ( Thanks To Him )

 

 

Details showing important Tables in SAP

 

Table Name

Description

Important Fields

Financial Accounting

 

 

FBAS

Financial Accounting “Basis”

 

BKPF

Accounting Document Header

MANDT / BUKRS / BELNR / GJAHR

BSEG

Accounting Document Segment

MANDT / BUKRS / BELNR / GJAHR / BUZEI

BSIP

Index for Vendor Validation of Double Documents

MANDT / BUKRS / LIFNR / WAERS / BLDAT / XBLNR / WRBTR / BELNR / GJAHR / BUZEI

BVOR

Inter Company Posting Procedure

MANDT / BVORG / BUKRS / GJAHR / BELNR

EBKPF

Accounting Document Header (docs from External Systems)

MANDT / GLSBK / BELNR / GJHAR / GLEBK

FRUN

Run Date of a Program

MANDT / PRGID

KLPA

Customer / Vendor Linking

MANDT / NKULI / NBUKR / NKOAR / PNTYP / VKULI / VBUKR / VKOAR

KNB4

Customer Payment History

MANDT / KUNNR / BUKRS

KNB5

Customer Master Dunning Data

MANDT / KUNNR / BUKRS / MABER

KNBK

Customer Master Bank Details

MANDT / KUNNR / BANKS / BANKL / BANKN

KNC1

Customer Master Transaction Figures

MANDT / KUNNR / BUKRS / GJHAR

KNC3

Customer Master Special GL Transactions Figures

MANDT / KUNNR / BUKRS / GJAHR / SHBKZ

LFB5

Vendor Master Dunning Data

MANDT / LIFNR / BUKRS / MABER

LFBK

Vendor Master Bank Details

MANDT / LIFNR / BANKS / BANKL / BANKN

LFC1

Vendor Master Transaction Figures

MANDT / LIFNR / BUKRS / GJHAR

LFC3

Vendor Master Special GL Transactions Figures

MANDT / LIFNR / BUKRS / GJHAR / SHBKZ

VBKPF

Document Header for Document Parking

MANDT / AUSBK / BUKRS / BELNR / GJHAR

FBASCORE

Financial Accounting General Services “Basis”

 

KNB1

Customer Master (Company Code)

MANDT / KUNNR / BUKRS

LFA1

Vendor Master (General Section)

MANDT / LIFNR

LFB1

Vendor Master (company Code Section)

MANDT / LIFNR / BUKRS

SKA1

G/L Account Master (Chart of Accounts)

MANDT / KTOPL / SAKNR

SKAT

G/L Account Master (Chart of Accounts – Description)

MANDT / SPRAS / KTOPL / SAKNR

MAHNS

Accounts Blocked by Dunning Selection

MANDT / KOART / BUKRS / KONKO / MABER

MHNK

Dunning Data (Account Entries)

MANDT / 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 – Key Word list)

MANDT / SPRAS / KTOPL / SAKNR / SCHLW

SKB1

G/L Account Master (Company Code)

MANDT / 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

MANDT / BUKRS / SAKNR

FI-GL-GL (FFE)

General Ledger Accounting: Basic Functions - Fast Data Entry

 

KOMU

Account Assignment Templates for G/L Account items

MANDT / KMNAM / KMZEI

FI-AR-AR (FBD)

Accounts Receivable: Basic Functions - Customers

 

KNKA

Customer Master Credit Management : Central Data

MANDT / KUNNR

KNKK

Customer Master Credit Management : Control Area Data

MANDT / KUNNR / KKBER

KNKKF1

Credit Management : FI Status data

MANDT / LOGSYS / KUNNR / KKBER / REGUL

RFRR

Accounting Data – A/R and A/P Information System

MANDT / RELID / SRTFD / SRTF2

FI-BL-PT (BFIBL_CHECK_D)

Bank Accounting: Payment Transactions – General Sections

 

PAYR

Payment Medium File

MANDT / ZBUKR / HBKID / HKTID / RZAWE / CHECT

PCEC

Pre-numbered Check

MANDT / ZBUKR / HBKID / HKTID / STAPL

FI-BL-PT-AP(FMZA)

Bank Accounting: Payment Transactions – Automatic Payments

 

F111G

Global Settings for Payment Program for Payment Requests

MANDT

FDZA

Cash Management Line Items in Payment Requests

MANDT / KEYNO

PAYRQ

Payment Requests

MANDT / KEYNO

FI-AA-AA (AA)

Asset Accounting: Basic Functions – Master Data

 

ANKA

Asset Classes: General Data

MANDT / ANLKL

ANKP

Asset Classes: Fld Cont Dpndnt on Chart of Depreciation

MANDT / ANLKL / AFAPL

ANKT

Asset Classes: Description

MANDT / SPRAS / ANLKL

ANKV

Asset Classes: Insurance Types

MANDT / ANLKL / VRSLFD

ANLA

Asset Master Record Segment

MANDT / BUKRS / ANLN1 / ANLN2

ANLB

Depreciation Terms

MANDT / BUKRS / ANLN1 / ANLN2 / AFABE / BDATU

ANLT

Asset Texts

MANDT / SPRAS / BUKRS / ANLN1 / ANLN2

 

 

 

ANLU

Asset Master Record User Fields

.INCLUDE / MANDT / BUKRS / ANLN1 /  ANLN2

ANLW

Insurable Values (Year Dependent)

MANDT / BUKRS / ANLN1 / ANLN2 / VRSLFD / GJAHR

ANLX

Asset Master Record Segment

MANDT / BUKRS / ANLN1 / ANLN2

ANLZ

Time Dependent Asset Allocations

MANDT / BUKRS / ANLN1 / ANLN2 / BDATU

FI-AA-AA (AA2)

Asset Accounting: Basic Functions – Master Data 2.0

 

ANAR

Asset Types

MANDT / ANLAR

ANAT

Asset Type Text

MANDT / SPRAS / ANLAR

FI-AA-AA (AB)

Asset Accounting: Basic Functions – Asset Accounting

 

ANEK

Document Header Asset Posting

MANDT / BUKRS / ANLN1 / ANLN2 / GJAHR / LNRAN

ANEP

Asset Line Items

MANDT / BUKRS / ANLN1 / ANLN2 / GJAHR / LNRAN / AFABE

ANEV

Asset Downpymt Settlement

MANDT / BUKRS / ANLN1 / ANLN2 / GJAHR / LNRANS

ANKB

Asset Class: Depreciation Area

MANDT / ANLKL / AFAPL / AFABE / BDATU

ANLC

Asset value Fields

MANDT / BUKRS / ANLN1 / ANLN2 / GJAHR / AFABE

ANLH

Main Asset Number

MANDT / BUKRS / ANLN1

ANLP

Asset Periodic Values

MANDT / BUKRS / GJAHR / PERAF / AFBNR / ANLN1 / ANLN2 / AFABER

FI-SL-VSR (GVAL)

Special Purpose Ledger: Validation, Substitution and Rules

 

GB03

Validation / Substitution User

VALUSER

GB92

Substitutions

MANDT / SUBSTID

GB93

Validation

MANDT / VALID

Controlling

 

 

AUSP

Characteristic Values

MANDT / OBJEK / ATINN / ATZHL / MAFID / KLART / ADZHL

CO-KBAS

Overhead Cost Controlling

 

A132

Price per Cost Center

MANDT / KAPPL / KSCHL / KOKRS / VERSN / RESRC / KOSTL / DATBI

A136

Price per Controlling Area

MANDT / KAPPL / KSCHL / KOKRS / VERSN / RESRC / DATBI

A137

Price per Country / Region

MANDT / KAPPL / KSCHL / KOKRS / VERSN / RESRC / LAND1 / REGIO / DATBI

COSC

CO Objects: Assignment of Original Costing Sheets

MANDT / OBJNR / SCTYP / VERSN / GJAHR

CSSK

Cost Center / Cost Element

MANDT / VERSN / KOKRS / GJAHR / KOSTL / KSTAR

CSSL

Cost Center / Activity Type

MANDT / KOKRS / KOSTL / LSTAR / GJAHR

KAPS

CO Period Locks

MANDT / KOKRS / GJAHR / VERSN / VRGNG / PERBL

 

 

 

CO-KBASCORE

Overhead Cost Controlling: General Services

 

CSKA

Cost Elements (Data Dependent on Chart of Accounts)

MANDT / KTOPL / KSTAR

CSKB

Cost Elements (Data Dependent on Controlling Area)

MANDT / KOKRS / KSTAR / DATBI

CSKS

Cost Center Master Data

MANDT / KOKRS / KOSTL / DATBI

CSLA

Activity Master

MANDT / KOKRS / LSTAR / DATBI

CO-OM (KACC)

Overhead Cost Controlling

 

COBK

CO Object: Document Header

MANDT / KOKRS / BELNR

COEJ

CO Object: Line Items (by Fiscal Year)

MANDT / KOKRS / BELNR / BUZEI / PERBL

COEJL

CO Object: Line Items for Activity Types (by Fiscal Yr)

MANDT / KOKRS / BELNR / BUZEI / PERBL

COEJR

CO Object: Line Items for SKF (by Fiscal Year)

MANDT / KOKRS / BELNR / BUZEI / PERBL

COEJT

CO Object: Line Items for Prices (by Fiscal Year)

MANDT / KOKRS / BELNR / BUZEI / PERBL

COEP

CO Object: Line Items (by Period)

MANDT / KOKRS / BELNR / BUZEI

COEPL

CO Object: Line Items for Activity Types (by Period)

MANDT / KOKRS / BELNR / BUZEI

COEPR

CO Object: Line Items for SKF (by Period)

MANDT / KOKRS / BELNR / BUZEI

COEPT

CO Object: Line Items for Prices (by Period)

MANDT / KOKRS / BELNR / BUZEI

COKA

CO Object: Control Data for Cost Elements

MANDT / OBJNR / GJAHR / KSTAR / HRKFT

COKL

CO Object: Control Data for Activity Types

MANDT / LEDNR / OBJNR / GJAHR / VERSN

COKP

CO Object: Control Data for Primary Planning

MANDT / LEDNR / OBJNR / GJAHR / WRTTP / VERSN / KSTAR / HRKFT / VRGNG / VBUND / PARGB / BEKNZ / TWAER

COKR

CO Object: Control Data for Statistical Key Figures

MANDT / LEDNR / OBJNR / GJAHR / WRTTP / VERSN / STAGR / HRKFT / VRGNG

COKS

CO Object: Control Data for Secondary Planning

MANDT / LEDNR / OBJNR / GJAHR / WRTTP / VERSN / KSTAR / HRKFT / VRGNG / PAROB / USPOB / BEKNZ / TWAER

CO-OM-CEL (KKAL)

Cost Element Accounting (Reconciliation Ledger)

 

COFI01

Object Table for Reconciliation Ledger COFIT

MANDT / OBJNR

COFI02

Transaction Dependent Fields for Reconciliation Ledger

MANDT / OBJNR

COFIP

Single Plan Items for Reconciliation Ledger

RCLNT / GL_SIRID

COFIS

Actual Line Items for Reconciliation Ledger

RCLNT / GL_SIRID

 

 

 

CO-OM-CCA

Cost Center Accounting (Cost Accounting Planning RK-S) – What is RK-S

 

A138

Price per Company Code

MANDT / KAPPL / KSCHL / KOKRS /  VERSN / RESRC / BUKRS / GSBER / DATBI

A139

Price per Profit Center

MANDT / KAPPL / KSCHL / KOKRS /  VERSN / RESRC / PRCTR / DATBI

CO-OM-OPA (KABR)

Overhead Orders: Application Development R/3 Cost Accounting Settlement

 

AUAA

Settlement Document: Receiver Segment

MANDT / BELNR / LFDNR

AUAB

Settlement Document: Distribution Rules

MANDT / BELNR / BUREG / LFDNR

AUAI

Settlement Rules per Depreciation Area

MANDT / BELNR / LFDNR / AFABE

AUAK

Document Header for Settlement

MANDT / BELNR

AUAO

Document Segment: CO Objects to be Settled

MANDT / BELNR / LFDNR

AUAV

Document Segment: Transactions

MANDT / BELNR / LFDNR

COBRA

Settlement Rule for Order Settlement

MANDT / OBJNR

COBRB

Distribution Rules Settlement Rule Order Settlement

MANDT / OBJNR / BUREG / LFDNR

CO-OM-OPA (KAUF)

Overhead Orders: Cost Accounting Orders

 

AUFK

Order Master Data

MANDT / AUFNR

AUFLAY0

Enttity Table: Order Layouts

MANDT / LAYOUT

EC-PCA (KE1)

Profit Center Accounting

 

CEPC

Profit Center Master Data Table

MANDT / PRCTR / DATBI / KOKRS

CEPCT

Texts for Profit Center Master Data

MANDT / SPRAS / PRCTR / DATBI / KOKRS

CEPC_BUKRS

Assignment of Profit Center to a Company Code

MANDT / KOKRS / PRCTR / BUKRS

GLPCA

EC-PCA: Actual Line Items

RCLNT / GL_SIRID

GLPCC

EC-PCA: Transaction Attributes

MANDT / OBJNR

GLPCO

EC-PCA: Object Table for Account Assignment Element

MANDT / OBJNR

GLPCP

EC-PCA: Plan Line Items

RCLNT / GL_SIRID

 

 

 

EC-PCA BS (KE1C)

PCA Basic Settings: Customizing for Profit Center Accounting

 

A141

Dependent on Material and Receiver Profit Center

MANDT / KAPPL / KSCHL / KOKRS / WERKS / MATNR / PPRCTR / DATBI

A142

Dependent on Material

MANDT / KAPPL / KSCHL / WERKS / MATNR / DATBI

A143

Dependent on Material Group

MANDT / KAPPL / KSCHL / WERKS / MATKL / DATBI

Contributed by http://profiles.yahoo.com/sanjaybarnwal1

Yahoogroups: http://groups.yahoo.com/group/sapficoworld

 

 
 
Make a Free Website with Yola.