‎2006 Jul 25 11:52 PM
Hi,
I am a fi/co person and i need some help regarding WM tables
I need a report which gives me
Username
total items pulled
Quantity of items pulled
Quantity Lbs pulled
qty ft pulled
Total movements
Total time on logged gun
Can someone please help me find the tables where all these fields sit? We dont have any WM guy here to help
Thanks,
Azam
‎2006 Jul 26 10:09 PM
the WM tables are ::
<b>Transfer requirement</b>
LTBK Transfer requirement - header
LTBP Transfer requirement - item
<b>Transfer order</b>
LTAK Transfer order - header
LTAP Transfer order - item
<b>Master data - stock positions</b>
LQUA Quants
<b>Inventory documents in WM</b>
LINK Inventory document header
LINP Inventory document item
LINV Inventory data per quant
Regards
Ashok P
‎2006 Jul 26 12:47 AM
hi Mohammed,
The easiest way to determine all WM tables is via the data dictionary.
Transaction SE11
Press F4 in field tables.
On the popup for the table search, enter LVS in field developement class and execute.
Regards,
Naveen
‎2006 Jul 26 1:45 PM
Hi,
You can check for the tables starting with LA* from se11 transaction,
Rgds,
‎2006 Jul 26 10:09 PM
the WM tables are ::
<b>Transfer requirement</b>
LTBK Transfer requirement - header
LTBP Transfer requirement - item
<b>Transfer order</b>
LTAK Transfer order - header
LTAP Transfer order - item
<b>Master data - stock positions</b>
LQUA Quants
<b>Inventory documents in WM</b>
LINK Inventory document header
LINP Inventory document item
LINV Inventory data per quant
Regards
Ashok P
‎2006 Aug 02 4:51 PM
‎2006 Aug 03 5:26 AM
Hi !
You may also have a look to the "statistic" data in the tables S090 and S091 and to the Transactions for this:
MCL1, MCL5, MCL9, MCLD and MCLH.
These transactions give you cummulatd, statistic data of the WM.
Regards
Rainer
Some points would be nice if that helped a bit.