cancel
Showing results for 
Search instead for 
Did you mean: 

SO without PO

Former Member
0 Kudos

Hi Experts,

I want to extract all the sales orders which are <b>not</b> used for creating the PO.Can any one tell me what are the related tables for restricting the SOs...!!

Reward guaranteed,

Thanks

kaki

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

HI,

Just check in your code that VBAK-BSTNK field is initial.

Regards,

Akshay Bhagwat

Former Member
0 Kudos

Hi Sai srinivas,

I want to capture the sales orders which are not effected by Purchase orders...

Iam not looking for customer POs(BSTNK)..

kaki

former_member188685
Active Contributor
0 Kudos

Hi Kaki,

Check the table VBAK, where VBAK-BSTNK = ''.

Regards

vijay

Former Member
0 Kudos

Hi vijay,

The process what i understood is , when a sale order is created, system checks the availability. If its not available, system will raise a PR to procure the material. but the BSTNK filed contains customer's purchase order i think.

Kaki: would you please tell me whether you require customer's PO number or PO creted by the system when stock is not availabe?

Regards,

Sai

Former Member
0 Kudos

Hi

In the sales document flow table ( VBFA ) , pass the sales order number , document catagory as sales order ( C ) and subsequent document cat. as purchase order ( V ).

Regards,