Skip to Content
0
Jan 18, 2011 at 11:40 AM

Need a report to show the BILL, DELIVERY, SALES for FOC material.

41 Views

Dear Expert,

I am trying to prepare a data source for Sales, Delivery and Billing for FOC ( Free of Charge ) material. I am pulling data from VBFA,VBAK,VBRK anf LIKP table in R/3.

Now the problem is Delivery doc (1090024042) and Billing Doc (1423044803) these , i will pull data from LIKP and VBRK table. And in both the tables , the two fields have the same name VBELN .

What will I do in such cases, Can I mantain VBELN more than 1 time in the VIEW.

Please suggest, looking for your response.

Thanks,

Sanjana