2018 Apr 19 2:56 PM
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?
2018 Apr 20 7:18 AM
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
2018 Apr 19 4:44 PM
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.
2018 Apr 19 5:36 PM
Hi William,
I have modified the question, hope it is understandable now.
Regards!
Mukesh Gusain
2018 Apr 20 7:18 AM
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
2018 Apr 20 7:29 AM
Thanks Amlan! This is what I was looking for, You save my day!!
Regards!
Mukesh Gusian