cancel
Showing results for 
Search instead for 
Did you mean: 

Extraction of sales and service orders

Former Member
0 Kudos
164

Hi all,

I have to extract sales and service orders for BW. Can anyone tell me where to find the connection from a service order to a debit memo request in SD (sales order, document category 'L')?

Kind regards,

Simon

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Check in R3 the field AUFNR in the vabp table. If it's blank each time, you have a problem in R3.

for your information, potentialy, for one Service order you can have zero, one or several sales order. And for one sales order you have one or only one service order.

Dimitri

Former Member
0 Kudos

I found a solution myself, the service order number is in table vbak.

Former Member
0 Kudos

Hi Simon,

What is your extractor?

The service order (AUFNR) exist in the vbap table (sales document) and in the vbrp (billing). You can see this field in the 2LIS_11_VAITM and 2LIS_13_VDITM.

The debit memo is the billing type.

I hope this helps

Dimitri

Former Member
0 Kudos

Hi Dimitry,

I use 2LIS_11_VAITM to extract the sales order positions and I get the field AUFNR, but it is blank in a considerable part of the sales orders. Might this be a bug in our R/3?

Does anyone know another solution to get a connection from service order to sales order?

Kind regards,

Simon