2011 Nov 22 7:19 PM
Hi Expert,
How can I find out if a deive is technical installed but not billing related?
I've tried to make a querry in SQVI where I use the tables EGERH and EASTL with a left outer join on logical number and a time slice
This doesn't give me the expect result.
Does anyone have an idea?
Edited by: R.L.Groener on Nov 22, 2011 8:39 PM
2011 Nov 23 4:32 AM
Hi,
Please use Left Outer Join ONLY on Logical number and not on timeslice.
Also Use EASTL-BIS and EGERH-BIS fields as selection paramenter. Execute the query where EASTL-BIS <> 31.12.9999 and EASTL-BIS <> 00.00.0000 and EGERH-BIS = 31.12.9999.
Let me know if more information is required.
Thanks and regards,
Ranjit Thakur.
2011 Nov 23 4:32 AM
Hi,
Please use Left Outer Join ONLY on Logical number and not on timeslice.
Also Use EASTL-BIS and EGERH-BIS fields as selection paramenter. Execute the query where EASTL-BIS <> 31.12.9999 and EASTL-BIS <> 00.00.0000 and EGERH-BIS = 31.12.9999.
Let me know if more information is required.
Thanks and regards,
Ranjit Thakur.
2011 Nov 23 8:31 AM
Hi Ranjit,
Why should I give the Bis date for the table EASTL?
Correct me if any wrong but when an device is not installed billing related then it's not in the table EASTL.
Regards
R.L. Groener
2011 Nov 23 10:54 PM
Hi,
EASTL-BIS Not Equal to 31.12.9999 This is to avoid the devices which are Billing related installed as this is left outer join on EGERH and EASTL so this will fetch the records which are present in EGERH and in EASTL; and also the records which are in EGERH and not in EASTL.
EASTL Not Equal to 00.00.0000 This is optional. if you want only the devices which were sometime installed billing related (example-device was billing related removed after few days)
Let me know if more information is required.
Thanks and Regards,
Ranjit Thakur.