Contract Account and Portion

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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