Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

sales order status

Hi,

My requirement is to show sales order by its status against billed amount.

i.e.

if the net value and billed amount of the sales order is same then it's full order...

Header 1Header 2Header 3Header 4
Sales orderNet valueBilled amountStatus
123456100.00100.00Full
456789100.0050.00Partial
789012100.000Open

How do I achieve this status? At the moment, i export data to exel and doing Vlookup against COPA datasource billed amount data to achieve these statuses but I want to find out the status of sales orders in bex query.

I am using following data sources

2LIS_11_VAHDR

2LIS_11_VAITM

Shall I be using difference datasource to achive this in bex query itself rather then doing vlookup?

Thank you

Darsh

Not what you were looking for? View more on this topic or Ask a question