Skip to Content
0
Former Member
Dec 21, 2012 at 12:48 PM

Inventory requirement of a report

23 Views

Hi,

I am working in SAP BI7.3. I have a requirement of report in which i need following fields:

Berthing date of material input

Material

Input Quantity

Input Batch

Berthing date of material output

Output Batch

Output Quantity

I implemented Batch Classification.

Logic of Report: I have data of 2LIS_03_BF, in which material, material document, batch number, bething date, Quantity, movement type are coming.

The data that is coming infront of 101 movement type are Input data and the one that is coming infront of 601 are output data. There is a linking between both movement types which is 309. Batches of 309 and 601 are same. Output data can be in different month. But i want to show Input data as well as output data in same report. Report will execute on basis of output date.

ECC Scenario: For this, if i take batch of 601, match it with 309, take material document infront of the batch coming against 309 and pass it in MSEG table, i get 2 entries. One having batch number of 101 and another of 601. 101 will be differentiate by credit entries and 601 by debit entries.

Please guide me how i can do it in SAP BI.

Regards,

Roma