SAP for Utilities Discussions
Connect with fellow SAP users to share best practices, troubleshoot challenges, and collaborate on building a sustainable energy future. Join the discussion.
cancel
Showing results for 
Search instead for 
Did you mean: 

Site ID’s with payment terms

former_member417914
Discoverer
0 Kudos
398

I am looking for all active Gas accounts and site ID’s with payment terms of FX*.

Though, payment term information is available in T052 but how to link it with Site ID's or Contract?

1 ACCEPTED SOLUTION

AmlanBanerjee
Active Contributor
0 Kudos
261

Mukesh,

You have to query EVER table for contracts with gas division along with Payment Terms FX* in FKKVKP table.

The joining link will be Contract Account which is EVER-VKONTO and FKKVKP-VKONT.

Hope it helps

Thanks

Amlan

View solution in original post

4 REPLIES 4

william_eastman
Product and Topic Expert
Product and Topic Expert
0 Kudos
261

Hi Mukesh:

This question is not clear - what does it have to do with the utilities industry solution? If it does not then please change the tag.

regards,

bill.

former_member417914
Discoverer
0 Kudos
261

Hi William,

I have modified the question, hope it is understandable now.

Regards!

Mukesh Gusain

AmlanBanerjee
Active Contributor
0 Kudos
262

Mukesh,

You have to query EVER table for contracts with gas division along with Payment Terms FX* in FKKVKP table.

The joining link will be Contract Account which is EVER-VKONTO and FKKVKP-VKONT.

Hope it helps

Thanks

Amlan

0 Kudos
261

Thanks Amlan! This is what I was looking for, You save my day!!

Regards!

Mukesh Gusian