Help to get values from table EABL ,

[Former Member]

Hi all,

I will have only one input parameter VKONT contract account.(Table DFKKOP)

I will get MENGE from table DFKKOPK based on fields OPBEL,OPUPK.

and also some values from table EABL.

-

---

NEED HELP to get fields ADATTATS and V-ZWSTAND and ABLESTYP from table EABL .

Thanks in advance.

Edited by: Sona on Feb 14, 2008 4:10 AM

Edited by: Sona on Feb 14, 2008 4:52 AM

Edited by: Sona on Feb 14, 2008 4:53 AM

Edited by: Sona on Feb 14, 2008 4:51 PM

Edited by: Sona on Feb 15, 2008 12:54 AM

[Former Member · Accepted solution]

Hi ,

please follow the path : its long one , try if you can shorten it.

VKONT->VKONTO( EVER ) Now from Table EVER get field ANLAGE .

ANLAGE ->ANLAGE( EABLE G ) and get the field ABLBELNR

ABLBELNR -> EABL , now you can access you field ADATTATS , V-ZWSTAND and ABLESTYP .

thanks and regards

Deepak.

[Former Member]

thanks.will try and let you know.

will award points.thanks again.

Hey,I tried this.But,

For an Installation (ANLAGE ) there are many values for ABLBELNR - Internal ID for meter reading document..in table EABLEG.

Can you clear this pls?

Edited by: Sona on Feb 14, 2008 4:18 PM

Edited by: Sona on Feb 15, 2008 12:57 AM

[Former Member]

Hi ,

for each Installation there is multiple MR document so you

can store these values in internal table and then for each value fetch the desired field from table EABL .

using keyword FOR ALL ENTRIES in SELECT statement.

pls revert back for any query.

regards

Deepak.

[Former Member]

But i want to display only current read date ,meter reading etc., from EABL for a particular contract account..with current consumption from dfkkopk/menge.

can u elaborate this installation and MR docs.

how to achieve this?

[Former Member]

sort the table according to date and pick the latest one ABLBELNR .

[Former Member]

Thankyou so much..will award full points at end.

Edited by: Sona on Feb 20, 2008 5:39 PM

Edited by: Sona on Feb 20, 2008 8:41 PM

[kevin_dewilde]

Also, don't forget that whenever you pass a select statement through table EVER, you'll get ALL contracts (current, old and possibly future) for a contract account.

If you're interested in the current state of affaires, select on move-in date <= keydate <= move-out date.

Kind regards.

[Former Member]

kevin

i'm not sure of what u hv mentioned.whats the exact syntax for that?

But my query works for what i want.i need current bill readings and previous few bills.( records).Done this.

Thanks deepak.

[kevin_dewilde]

Sona, I'll try to clarify.

Say customer X moves to a new house on March 1st 2007. In table EVER, you'll find for this customer and matching contract account two entries:

OLD_CONTRACT - move-in date 01-01-2000 - move-out date 28-02-2007

NEW_CONTRACT - move-in date 01-03-2007 - move-out date 31-12-9999

When you simply join all tables BUT000-FKKVKP-EVER-EANL-EABLG-EABL you'll get alle meter reading for the old and new contract (and hence other devices).

The combination of meter readings of both locations into one table is not always relevant and can be misleading. That's why I proposed to add a selection to your query limiting the move-in and move-out date to the current contract.

The syntax to use is just standard SQL...

HTH

[Former Member]

I'm getting only installation no. ANLAGE from table EVER for a particular contract account and division.

do u think there will be many installation no.s for a particular contract account ?

[Former Member]

I have opened another thread for the below question..please post answer for below question there.Thanks in advance.

Hi all,

I have selction criteria to query EABL.

After select ,i have to sort to get latest 10 records from EABL .

I was told if the value of ADATTATS is null ,i should use ADAT.

But to select latest 10 records i have need to sort based upon date field..IF date field is null i will not get sort in proper descending order......

Any suggestions and help ?

display :

Current meter reading date 1

previous meter reading date 2

previous meter reading date 3

Thanks in advance...

[kevin_dewilde]

Sona,

About the multiple installations: in the example of a customer moving houses, you can get two installations for one contract account. This depends on the business process defined by your organisation. In any case, checking for active contracts by limiting the move-in and move-out date is a best practise.

About the sorting of dates: in your report, why don't you "merge" the two dates into one field first (with the simple rule: if one is empty; take the other; else take the first) and sort that new field?

Regards,

Kevin

[Former Member]

I'm done with a simple sort using both fileds and if i go for merge it will be little complicated, anyhow i will consider this in future.

Now talking about EVER,

In ur case, where to get move-in and move out date before quering EVER while vkont being the only input,we hv division no. also to query.