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:
(3) Storage Location
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.
(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.