on 2011 Mar 04 7:37 AM
HI,
I want last GR date and last GI date to be developed in the report. I wl take the data from CKM3N.
Is there any easy way how to go about it?
Regards,
Request clarification before answering.
Hi there
1. Last GR date,If the material is a Batch amanged material you can get the last Gr date from the Table: MCHA-(Field) LWEDT..
if the material is not batch manged,, Hope we can ref the MSEG based on the Movement types( Inward )/Material/Plant/Location for the last GR..
2. For the last GI date- Same we can ref the MSEG based on the Movement types( Outward )/Material/Plant/Location for the last GI..
Hope it helps,,
Thanks
Senthil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Its batch managed and you have maintained characteristics and class for the same. You need to activate batch classification for Goods Movement in IM under lotictics --> batch management node. Make characteristics with table name MCH1 and field as LEWDT for last GR date. Assign this characteritics to class and this class to batch determination and batch check. When you go goods receipt this date will get automatically updated in the classification view and you can use any of the report like BMBC to get the details.
REgards
Sangeeta
User | Count |
---|---|
94 | |
39 | |
7 | |
5 | |
5 | |
5 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.