Hi Experts,
I got a requirement, in which I hv to develop a report for the Open quantities for sales order items. fine.
I ssue is that, in the report I hv to show at Schedule line level i.e. VBEP.
So, by pulling the records from VBEP depending on the seldction criteria, I hv to pull the MATCHING record from VBFA for Post Goods Issue.
Then, I hv to implememnt the follwoing formula,
Open Quantity = VBEP, say Schedule line 1 quantity -(mnus) first saved corresponding Order, Item Quantitity-RFMNG in VBFA for PGI type
As we know, VBEP is at Schedule line lvel, where as VBFA is ITEM level!!
So, pls. let me know that,
1 - Is really, we can develop the MATCH btwn VBEP and VBFA tbls, I mean, always, the data will be correctly pulled?
2 - If so, Is the folllwoing statement is OK?
LOOP AT IT_VBFA WHERE VBELV = IT_VBEP-VBELN and POSNV = IT_VBEP-POSNR and ERDAT LE IT_VBEP-MBDAT
3 - Any other good statement for my requirement?
Looks like, functional guy is also NOT much idea, here.
Thanx