Skip to Content

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

Stock Transfer Report after Invoice

Hello Experts

Please spend one minute's time to read this. It may be long but its the exact scenario.

I have got a requirement to generate a Stock Transfer Report for the bills passed (invoice receipt) for a particular date range. Note that the delivery against the PO can be for partial quantities too.

I am using RBKP table to get all the invoice numbers falling in the certain date range selection. Against these Invoices I am retrieving the PO number and other report relevant data from the RSEG Table. And using the PO I need to get into the MSEG table to retrieve Mat Doc numbers so that I can drill into the excise tables to get Excise No.

Now the problem is:

Suppose the PO <b>4900000337 </b>contains various items

item no  | material  | qty
----------------------------
10       | mat1      | 1050
20       | mat2      | 2670
30       | mat3      | 450

Now one partial delivery is made as

item no  | material  | qty
---------------------------
10       | mat1      | 100
20       | mat2      | 250

<i>mat doc 4900012713, mov type 641</i>

and the against this delivery an invoice receipt is created using MIRO, <b>5105600790</b>

another partial delivery is made as

item no  | material  | qty
---------------------------
20       | mat1      | 350
30       | mat2      | 50

<i>mat doc 4900012714, mov type 641</i>

against this delivery an invoice receipt is created using MIRO, <b>5105600791</b>

How do I link the invoice no to the material documents to know the quantity of the particular item of the PO... as we see item no 20 is common in both the case.

RSEG
Document Number Fiscal Year Item   Purchasing Doc. Item

5105600790      2007        000007 4900000337      00020
5105600791      2007        000007 4900000337      00020

MSEG
Material Doc. Mat. Doc. Year Item Line ID Parent ID Movement Type Material     Quantity          Purchase Order Item

4900012713    2007           0004 000005  000002    641           90050106            250.000  4900000337     00020
4900012714    2007           0002 000003  000001    641           90050106            350.000  4900000337     00020

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