Open SD orders and partner type?

[Former Member]

Hi,

I need to extract 'open sd orders' and 'partner type' i.e all partner types and not only just SP or SH

The transaction VA05 does no allow all partner functions - and I need to sort by all types

is there another way?

If I want to use SQVI . . . what tables can I join?

Thanks,

SM

[Lakshmipathi]

IMG --> Sales and Distribution --> Sales --> Lists --> Set Updating of Partner Index. Here, maintain the following values.

Transaction Group      Partner Function
 
          0                             SP      
          0                             SH
          0                             PY
          0                             BP

Now you can generate VA05 based on any partner functions.

thanks

G. Lakshmipathi

[Former Member]

Hi,

My suggestion is to develop a "Z report which is similar to VA05.

Make a copy of the code of "VA05".

Create a "Z" report.

In this add the fields for other partner functions.Get these values from the table "VBPA".

Ask your ABAPer to develop a "Z" report for this requirement.

Regards,

Krishna.

[Former Member]

Hi SM,

I suggest first extract the open order list from VA05.

Then put that order list in Table VBPA, it will provide you the information of partners.

Hoe this helps.

Regards,

MT

[Former Member]

try the tables VAKPA or VAPMA

Regards

Sai

[Former Member]

VBAK - Order Header

VBAP - Order Item

VBPA - Order Partner info