04-04-2008 10:20 AM
Hello All,
I have requirement where in I need to obtain all Contract Accounts that are associated with a specific portion.
Consider this example....
Contract Account Portion
1000000098 P1
1000000099 P2
1000000100 P4
1000000111 P1
1000000112 P8
1000000114 P9
1000000115 P1
Question is how will i figure out that which all Contract Account fall under P1?
I need information at table and field level.
One option i have is to check in the installation table which all portions come under P1 and then select the associated contracts and then extract the associated contract accounts.This is a bottom-up approach as Contract Account is at Business Master Data level and Portion is at Techincal Master Data Level
I am looking at more simpler approach as this is very complex and involves table hit.. might be an performance issue.
If anybody has already encountered this type of requirement and had found out a solution.. pls provide it.
Regards,
Vinay
04-04-2008 10:29 AM
Contract Account Header table :: FKKVK
Contract Account Header table :: FKKVKP
Portion is not there in this table.
Where you are getting this field in transaction?
In CAA1 you are getting this field....
or any other transaction you are having this field?
Regards,
Shiva Kumar
04-04-2008 10:48 AM
Hi Shiva,
Take any contract account in your system.(CAA3)
Menu path:
Environment--> Contracts-> Double click on any selected contract in the displayed box---->
Click on Move In Out Tab----> Double click on the Installation...
Double click on MR Unit on Time-Dependant data..
and viola!!!!... one will find the Portion on the General section.
Regards,
Vinay
04-04-2008 11:55 AM
U can see this field in portion in TE422 table.
First find out the MRU :: TERMSCHL field...
U can find this data in EANLH table....
Regards,
Siva Kumar