Skip to Content
author's profile photo Former Member
Former Member

TABLES

COULD U PLZ TELL ME SOME LIST OF TABLES THAT WE USE IN REPORTS IN REAL TIME.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

6 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 03, 2007 at 11:58 AM

    BUT000

    BSEG

    MARA

    And about 18,000 others.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 03, 2007 at 11:59 AM

    Hi,

    Goto DD02L table, u will get the list of tables used in realtime.

    Regards,

    Vani

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 04, 2007 at 06:51 AM

    hi srinath,

    the following site would show u the list of tables used in real time.

    http://www.sapmaterial.com/tables.html

    in the above site, tables are classified as per their appliaction as

    sales and distribution tables, material management and so on.

    srinath i have material with me which will deffinetly help u in knowing about tables used.

    so give me ur mail id and i will forward the material to u.

    my mail id is : sumasailaja_pvn@infosys.com

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 04, 2007 at 07:18 AM

    Hi,

    <b>In SD:</b>

    KONV, KONP, KNA1, LIKP, LIPS, VBAK, VBAP, VBBE, VBEH, VBEP, VBFA, VBLB, VBLK, VBPA, VBRK, VBRP, VBUK, VBUP, VEKP, VEPO.

    <b>In MM:</b>

    EINA, EINE, MAKT, MARA, MARC, MARD, MAST, MBEW, MKPF, MSEG, MVER, MVKE, RKPF, LFA1.

    <b>In FI:</b>

    BKDF, BKORM, BKPF, BLPK, BLPP, BLPR, BNKA, BP000, BPBK, BPEG, BPEJ, BPEP, BPGE, BPJA, BSAD, BSAK, BSAS, BSEC, BSEG, BSID, BSIK, BSIM, BSIS.

    Regards,

    Bhaskar

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 04, 2007 at 07:20 AM

    Hi,

    It depends on report requirement but u can see all the table in Table DD02L

    Regards,

    Prashant

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 04, 2007 at 07:29 AM

    Hi Srinath,

    Below is list of tables for each module in SAP.

    Please do reward if useful.

    Thankx.

    Sales and Distribution Tables

    VBBE Sales Requirements: Individual Records

    VBEH Schedule line history

    VBEP Sales Document: Schedule Line Data

    VBFA Sales Document Flow

    VBLB Sales document: Release order data

    Materials Management Tables

    MBEW Material Valuation

    MKPF Header- Material Document

    MSEG Document Segment- Material

    MVER Material Consumption

    MVKE Sales Data for materials

    EINA Purchasing Info Record- General Data

    EINE Purchasing Info Record- Purchasing

    Organization Data

    MAKT Material Descriptions

    MARA General Material Data

    MARC Plant Data for Material

    MARD Storage Location Data for Material

    MAST Material to BOM Link

    RKPF Document Header- Reservation

    T023 Mat. groups

    T024 Purchasing Groups

    T156 Movement Type

    T157H Help Texts for Movement Types

    All of the product names here are trademarks of their respective companies. The site

    www.allsaplinks.com no way affiliated with SAP AG. We have made every effort for the content

    integrity. Information used on this site is at your own risk.

    AllSapLinks.com

    Purchasing Tables

    EKPO Purchasing Document Item

    IKPF Header- Physical Inventory Document

    ISEG Physical Inventory Document Items

    A501 Plant/Material

    EBAN Purchase Requisition

    EBKN Purchase Requisition Account Assignment

    EKAB Release Documentation

    EKBE History per Purchasing Document

    EKET Scheduling Agreement Schedule Lines

    EKKN Account Assignment in Purchasing Document

    EKKO Purchasing Document Header

    LFA1 Vendor Master (General section)

    LFB1 Vendor Master (Company Code)

    NRIV Number range intervals

    RESB Reservation/dependent requirements

    T161T Texts for Purchasing Document Types

    All of the product names here are trademarks of their respective companies. The site

    www.allsaplinks.com no way affiliated with SAP AG. We have made every effort for the content

    integrity. Information used on this site is at your own risk.

    AllSapLinks.com

    Production Planning tables

    PLKO Routing Group Header

    PLSO Routing Group Sequence

    PLPO Routing Group Operations

    AFKO Production Order Header

    STKO BOM Header

    STPO BOM Positions (detail)

    MAPL Assignment fo Task Lists to Materials

    AFPO Production Order Position (details)

    All of the product names here are trademarks of their respective companies. The site

    www.allsaplinks.com no way affiliated with SAP AG. We have made every effort for the content

    integrity. Information used on this site is at your own risk.

    AllSapLinks.com

    KONV Conditions for Transaction Data

    KONP Conditions for Items

    LIKP Delivery Header Data

    LIPS Delivery: Item data

    VBAK Sales Document: Header Data

    VBAP Sales Document: Item Data

    VBLK SD Document: Delivery Note Header

    VBPA Sales Document: Partner

    VBRK Billing: Header Data

    VBRP Billing: Item Data

    VBUK Sales Document: Header Status and

    Administrative Data

    VBUP Sales Document: Item Status

    VEKP Handling Unit - Header Table

    VEPO Packing: Handling Unit Item (Contents)

    VEPVG Delivery Due Index

    All of the product names here are trademarks of their respective companies. The site

    www.allsaplinks.com no way affiliated with SAP AG. We have made every effort for the content

    integrity. Information used on this site is at your own risk.

    AllSapLinks.com

    Finance Tables

    AGKO Cleared Accounts

    ANAR Asset Types

    ANAT Asset type text

    ANEK Document Header Asset Posting

    ANEP Asset Line Items

    ANEV Asset downpymt settlement

    ANKT Asset classes- Description

    ANLA Asset Master Record Segment

    ANLB Depreciation terms

    ANLC Asset Value Fields

    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 Doc.Header Controlling Obj.

    BPEG Line Item Total Values Controlling Obj.

    BPEJ Line Item Annual Values Controlling Obj.

    BPEP Line Item Period Values Controlling Obj.

    BPGE Totals Record for Total Value Controlling obj.

    BPJA Totals Record for Annual Total Controlling Obj.

    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 Order Settlement

    COBRB Distribution Rules Settlement Rule Order Settlement

    COKA CO Object- Control Data for Cost Elements

    COSP CO Object- Cost Totals for External Postings

    COSS CO Object- Cost Totals for Internal Postings

    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 Communication Header

    MAHNV Management Records for the Dunning Program

    REGUT TemSe - Administration Data

    SKA1 G/L Account 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

    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 Document Segment for G/L Accounts Document Parking

    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 Options Additional Data

    VWPANLA Asset master for securities

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.