Append Structure in FPLT table

[Former Member]

Hi,

I'm posting this query after going through various posts on the subject.

We are in 4.7 version and would like to add custom fields to table FPLT, to store additional information.

Since there are no customer includes in FPLT table, we intend to add append structure with our new fields.

Want to know if anyone has done similar enhancement? and if there is any negative impact on billing etc?

In some posts the exits RV60FUS1 & RV60FUST has been suggested to use. However,not sure how these can be used to store data in custom fields without modifying FPLT table. Appreciate any suggestion/solution. Thanks

[former_member183879]

Hi Sanjay,

Appending the FPLT table is always possible, but I was really evaluating the necessity for it. I dont think you necessarily need to append FPLT.

If you are appending FPLT, then you have to consider the implications of billing document for each billing plan, the carry over of data from SO to the invoice, the regression on the present functionality etc.

Instead you can weave the process with a new custom table for your purpose and play your process accordingly using user exits and enhancements.

Having said that, if you are very clear about all kinds of billing plan (Periodic, Milestone, advance periodic, arrears periodic etc....) then you can enable this. But my vote will be for Z table based solution

[Former Member]

Thanks Krishnan for your suggestion.

I had thought about z-table but the challenge is to update the z-table everytime changes to billing plan takes place. If the billing plan is deleted, then I need to make sure that the z-table is also updated; Also if a new line is added OR amendments made to billing plan, then the z-table also needs to be updated; Also not sure if there would be any performance issues; Will discuss this with technical team; Thanks Anyway

[former_member183879]

Hi Sanjay,

That is indeed the reason why I wanted you to use a Z table.

You can of course draft the entire set of business processes and how the table needs to be updated in all those scenarios. The scenarios can include

Inclusion of a billing record in the billing plan

Deletion of a billing record

Change of billing percentage, value , date category, billing type, billing block etc on a billing plan

Creation of billing document for a billing plan item etc....

You need to think of all these scenarios and update the Z table. Innovatively, you can also delete the records from this Z table (if that is possible in ur process flow) when the last billing plan item is processed for billing creation. We have such scenarios and we enable the deletion of some Z tables in some our processes

[Former Member]

Hi Sanjoy,

Were you able to resolve this issue ? Can you share the approach used ?

Thanks,

Hema

[Former Member]

Hello Hema,

We have used an apend structure to FPLT table and added the new field.

Regards

sanjoy

[Former Member]

Thank you Sanjay for the reply.

Did u add the fields in the bill plan tab as well ? If yes, can you share the screen exit used ?

I'm having hard time finding a screen exit for bill plan tab.

I have posted the below thread for the same. You can use it to reply.

Thanks,

Hema

[Former Member]

Hi Hema,

No we did not add any new fields to billing plan tab; just used the exit RV60FUS1 to pass the value to the new field added in append structure of FPLT table

Regards