2008 Dec 30 9:08 AM
Hello Experts,
Can anyone please tell me how to find inactive accounts i.e. which are moved out.
following logic has been given but i am not able to find the inactive accounts.
The inactive accounts can be identified by the Move-In/Out dunning procedure.
is there any table where i can find out?
Thanks,
Sarang
Edited by: sarang gujrati on Dec 30, 2008 10:26 AM
2008 Dec 30 11:49 AM
HI,
You may querry the Table EAUS or EVER table to see the move out docs & corresponding contracts.
regards
sagar
2008 Dec 30 11:49 AM
HI,
You may querry the Table EAUS or EVER table to see the move out docs & corresponding contracts.
regards
sagar
2008 Dec 30 11:56 AM
Query on table : EVER.
select vertrag from ever where auszdat(move-out) = sy-datum.
EVER table
EINZDAT ( Move-in date)
AUSZDAT( Move-out-date)
EAUS :: Move-in Doc. for Cont Account.
EAUSV :: Move-in Doc. for Cont.
You can query on these tables also.
Let me know if you need more information on this.
Regards,
Shiva Kumar