Skip to Content
Former Member
Nov 21, 2007 at 11:23 AM

Populate Custom Data Source from Transaction Code Output in R/3


Hi Gurus,

In our R/3 side, I have a transaction MB52, which shows Inventory & Stock Related Breakup Data for Material and Plant with Storage Locations.

Actually, I have to build a data source in BW which gives the same output as in MB52. For this, I have to know from which database tables it pulls the data to populate the output of MB52. I would like to know the field mapping for each corresponding output fields with DB tables so that I can map the same in my BW data source.

Required Charcteristics in Custom Data Source are:

(1) Material

(2) Plant

(3) Storage Location

(4) Batch

Required Key figures in Custom Data Source are:

(1) Storage location

(2) DF stor. loc. level

(3) Unrestr.-use stock

(4) Base Unit of Measure

(5) Stock in transfer

(6) In quality insp.

(7) Blocked

(8) Returns

(9) Restricted-use stock

I have to give a selection criteria on Plant which I have to enable on Data source also.

Please help me here to build the data source from the TCode.