Skip to Content
0
Former Member
Jun 01, 2008 at 03:49 AM

Is can we develop MATCH btwn VBEP and VBFA, for data pulling?

84 Views

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

Edited by: Srinivas on Jun 1, 2008 12:15 AM