Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

How to Extract sales document from r/3 ?

Former Member
0 Kudos
77

hi,

How to extract sales data from SAP R/3 considering all fields of data in different tables?

Thanks & regards,

Gopi.

3 REPLIES 3

Former Member
0 Kudos
36

Hi Gopi,

It depends what data you need to extract but most of the data would be available in following tables :

Sales

VBAK - Header

VBAP - Item

VBPA - Sales Document Partner

Shipment

VTTK - Shipment Header

VTTP - Shipment Item

Delivery

LIKP - Delivery Header

LIPS - Delivery item

Customer

KNA1 - Customer Master

KNB1 - Customer Master (Company Code)

Cheers,

Vikram

Pls reward for helpful replies!!

0 Kudos
36

Former Member
0 Kudos
36

Hi Gopi,

Take a loook at sap provided std reports

Transaction code <b>VA05 and VA08</b>

Cheers

VJ