topic about tables in Application Development and Automation Discussions

about tables

Former Member — Wed, 07 May 2008 13:20:09 GMT

hai , i am a beginner .please tell me of what tables are generally used for different modules.

Re: about tables

Former Member — Wed, 07 May 2008 13:24:13 GMT

For HR generally tables(infotypes) which start with PA... are

used ..

PA0000 .. PA0999

HRP1000 ... HRP1999

PA2000 .. PA8999 ..

PA9000 .. PA9999 <-- custom infotypes .. needs to be created

based on the requirement ...

Re: about tables

Former Member — Wed, 07 May 2008 13:28:09 GMT

Hi,

Check this link ,it is usefull for u.

http://www.erpgenie.com/abap/tables.htm

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

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

Give reward if useful.

Regards,

Narasimha

Re: about tables

Former Member — Wed, 07 May 2008 13:37:49 GMT

Hi ...

Tables Present in SAP are:-

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,

Pari

Note: Reward Me Points

Re: about tables

Former Member — Wed, 07 May 2008 13:54:01 GMT

Hi,

Please refer the link below:

http://www.erpgenie.com/abap/tables.htm

Thanks,

Sriram Ponna.

Re: about tables

Former Member — Wed, 07 May 2008 14:57:14 GMT

thank you everybody...i really appreciate u'r help