Sales order number?

[Former Member]

Hi all,

How to get the sales order number based on customer number?

Kishi.

[RichHeilman]

You can simply do a select against VBAK. You would use the field KUNNR.

Data: ivbak type table of vbak with header line.

select * into table ivbak from vbak
          where KUNNR  = '0000100498'.

loop at ivbak.   
   write:/ ivbak-vbeln.
endloop.

Regards,

Rich Heilman

[Former Member]

Hi,

From table VBAK itself u can get all the sales orders for a particular Customer.

Based on partners u can fetch from VAKPA - Sales Index: Orders by Partner Function.

Reward if helpful.

[Former Member]

Hi,

enter the customer number in field KUNNR of table VBAK.

Regards

Nicola

[ferry_lianto]

Hi,

You can use BAPI BAPI_SALESORDER_GETLIST to get all sales orders based on customer number.

Regards,

Ferry Lianto