topic Re: tables....................... in Application Development and Automation Discussions

tables.......................

Former Member — Mon, 04 Sep 2006 11:23:04 GMT

hi everybody

can anybody send me the tables names which we come across in our daily work life.

Re: tables.......................

Former Member — Mon, 04 Sep 2006 11:29:52 GMT

Hi,

It hugely depends upon which module you are working. Here are some of them.

Please ask your FC for more details.

Tables in SAP

Just a list of tables that come in handy.

Sales orders Name Description Uses

LIKP Shipped Lines header

LIPS Shipped Lines detail

VBAK Order header Every order (unless archiving)

VBAP Table fields Every line item (unless archiving)

VBBE Open sales order line items Great file, but be careful. Contents don't reflect orders that do not affect purchasing (go figure).

VBEP Schedule line item

VBFA Document flow Let's you move from order to shipping document to invoice.

VBUK Order status

VBUP Line item detail status

VBFK Invoicing header

VBFP Invoicing detail

Material Management Name Description Uses

MARA Inventory Master

MARC Plant Data

MARD Current Inventory

MAKT Descriptions

MBEW Material Valuation

T179 Product Hierarchy

MVKE Sales data (materials)

MKPF Material document Status code 'R' in VBFA

Purchasing Name Description Uses

EINA Purchasing inforecord by MATNR/LIFNR contains things like vendor material number and access key for EINE

EINE Purchasing inforecord detail Contains minimum purchase, group, currency

EKPO Purchase orders

EKET Scheduled lines

EKES Vendor confirmed lines

Forecasting Name Description Uses

MAPR

PROP

PROW

Classification Name Description Uses

KSSK Material number to class

KLAS Class description

KSML Characteristic name

CABN/CABNT Characteristic name description

CAWN/CAWNT Characteristic name

AUSP Numeric values

Name Description Uses

CAUFV Service order header

AFPO Service order line Holds items that will create "reservations"

RESB SM Reservations Materials needed for line

Customer Data

KNA1 Customer Master

KNVV Sales information

KNVP Partners (ship-to, etc)

System tables Name Description Uses

DD02T Table texts

DD03L Table fields Lists the fields in a table

DD04T Data element texts

USR02 Valid user names

Config tables (normally begin with "T") Name Description Uses

T001 Client table

T002 Languages

T005 Region (Country)

TCURR Currency and exchange rates

TVAK Order type

TVSB Shipping condition

TVAGT Rejected reason for order line

Other tables Name Description Uses

STXH Text header

STXL Text detail

Regards,

Sumit

Re: tables.......................

Former Member — Mon, 04 Sep 2006 11:30:01 GMT

Hi,

SD TAbles:

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

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

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

MM Tables:

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

MBEW Material Valuation

MKPF Header- Material Document

MSEG Document Segment- Material

MVER Material Consumption

MVKE Sales Data for materials

RKPF Document Header- Reservation

T023 Mat. Groups

T024 Purchasing Groups

T156 Movement Type

T157H Help Texts for Movement Types

Purchasing:

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

EKPO Purchasing Document Item

IKPF Header- Physical Inventory Document

ISEG Physical Inventory Document Items

LFA1 Vendor Master (General section)

LFB1 Vendor Master (Company Code)

NRIV Number range intervals

RESB Reservation/dependent requirements

T161T Texts for Purchasing Document Types

FI 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

Thanks and Regards,

Bharat Kumar Reddy.V

Re: tables.......................

suresh_datti — Mon, 04 Sep 2006 11:32:52 GMT

Pl check this <a href="http://goldenink.com/abap/files_in_sap.html">Link</a>

~Suresh

Re: tables.......................

Former Member — Mon, 04 Sep 2006 11:39:40 GMT

http://www.sap-basis-abap.com/

Try the above site..it gives you very good overview about many function/technical areas.

As for the tables, it would depend on which function are you are working in...

VBAK / VBAP...VB* for Order related information

MARA / MARB ... for material related information

LIKP / LIPS for delivery notes.

TSTC ..for transactions.

Regards

Anurag

Re: tables.......................

Former Member — Mon, 04 Sep 2006 11:49:50 GMT

good

there is nothing like daily work life table, its all depents upon your requirement, the tables are vary accoring to your requirement , if you r working with MM module than you need table related to mm like MARA, if you r working with SD module than you definitely ll come across the table like VBAK AND VBAP, similarly tables vary from module to module.

thanks

mrutyun^