SAP tables

[Former Member]

Hi all,

What are tables in SAP? What is their use and when to use them?

Roopak bhargava

[Former Member · Accepted solution]

The statement TABLES is required for exchanging data between screen fields that were defined in a program screen when transferring from the ABAP Dictionary and the ABAP program. For the screen event PBO, the content of the table work area is transferred to identically named screen fields; for PAI, the system adopts the data from identically named screen fields.

In executable programs, flat table work areas can be used for adopting data that were provided for the event GET table_wa from a linked logical database. TABLES is synonymous with the statement NODES for this purpose.

[Former Member]

answered

[Former Member]

Hi,

Also take a look at

http://abap4.tripod.com/SAP_Tables.html

click on the module, then you will find the most important and commonly used tables.

There are different types of tables in SAP. take a look at the below link.

http://www.sap-img.com/abap/the-different-types-of-sap-tables.htm

Br, Sats.

[Former Member]

Hii Roopak,

For more Information,Visit th link given below

http://www.sap-img.com/general/sap-r3-tables.htm

Regards

MT

Edited by: M T on Feb 23, 2010 5:53 PM

[Former Member]

In SAP, all data is stored in tables. Tables have multiple fields to store the data.

For Example, when Customer Master is created, data are stored in following tables:

General Data in Customer Master - KNA1

Customer Master (Company Code) - KNB1

Assign customer-credit card - VCKUN

Customer Master Contact Partner - MASSKNVK

Customer master record sales request form - MASSKNVD

Customer Master Sales Data - KNVV

Customer Master Partner Functions - KNVP

Customer Master Licenses - KNVL

Customer Master Tax Indicator - KNVI

Customer Master Unloading Points - KNVA

Customer master credit management: Control area data - KNKK

Customer master credit management: Central data - KNKA

Customer Master: Legal Control - Sanctioned Party List - KNEX

Customer Master (Bank Details) - KNBK

Customer master (dunning data) - KNB5

Customer master (VAT registration numbers general section) - KNAS

Similarly, some of the relevant tables furing Sales Order to Billing cycle are:

VBFA - Document flow (alg.)

VTFA - Flow shipping documents

Sales order :

VBAK - Header data

VBAP - Item data

VBPA - Partners in sales order

VBKD - Sales district data

VBEP - Data related to line items, delivery lines

Billing document :

VBRK - header data

VBRP - Item data

Shipping :

VTTK - Shipment header

VTTP - Shipment item

VTTS - Stage in transport

VTSP - Stage in transport per shipment item

VTPA - Shipment partners

VEKP - Handling Unit - Header Table

VEPO - Packing: Handling Unit Item (Contents)

Delivery :

LIKP - Delivery header

LIPS - Delivery item

Pricing :

KONH - Conditions header

KONP - Conditions items

KONV - Procedure ( billing doc or sales order)

KOND

Hope the above is helpful in gaining a breif understanding of tables in SAP.

Regards,

Rajesh Banka

[former_member222859]

i want know the tables for material master