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

[Former Member]

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.

Regards

Dibyendu

[Former Member]

Hi

For Materila Plant and Batch fields data might be updating to different tables, please check for standard DS available at necessary Applications it may suit your requirement

Dhanu