Update 'instruction key' field in F110 proposal based on conditions

[Former Member]

Dear Friends

We have a business scenario wherein, we need to update some Hardcoded values in Instruction key field of F110 payment proposal and payment document, based on some conditions in the underlying invoice documents.

I checked various user exits, BTEs and BAdIs. And I believe "FI_F110_SCHEDULE_JOB" is the best solution.

Can someone validate my approach and guide me accordingly.

Thanks

Srini

[Marssel700 · Accepted solution]

Hi

Have you checked the table/view V_T015W1 ? Enter SM30 and verify.

Here you are to add hardcoded values for Instruction key.

You use in F110 assing in OB47.

please comment.

regards

[Former Member · Accepted solution]

Thanks Marssel for quick turnaround.

But what I'm expecting is a conditional hardcoding of Instruction Key. So the OB47 tip would not fit our case.

Our scenario is, for each of the proposal line item, it needs to check the invoices picked, and if any of the invoice has document type RE, then hardcord IK as "HR", else "LR".

Thanks

Srini

[Former Member · Accepted solution]

Hi Srini

I have a suggestion.

Why can't you define two instruction keys with value as HR and LR.

Then during document posting, you define a substitution method based on document type to fill the instruction key accordingly.

Hope it helps.

Regards

Nikhil  Kothari

[Former Member · Accepted solution]

Hi Nikhil

Your option is interesting, but can you please let me know how do I use the substitution method where I need to check the Invoice document type but fill the Instruction Key in Proposal document.

Thanks

Srini

[suma_mani · Accepted solution]

Hi Srini,

You can use mentioned BTE to apply substitution on instruction key

SAMPLE_PROCESS_00001120

Mentioned link guide about customization / development.

http://ramgvsap.wordpress.com/2011/05/27/bte-sample_process_00001120-substituir-valores-en-doc-conta...

Regards

Mani Kumar

[Marssel700 · Accepted solution]

Srinivasan,

Since you want use condition based in document type the substitution rule is the most recomended for this solution:

Please check here a sample here:

Substitution Rule(User Exit) in FI - FB60 for Partner Bank Type

Create 2 steps in your line item rule - OBBH:

1 step:

Prerequisite:

BKPF-BLART = 'RE'

Substitution:

BSEG - DTWS1 = 'HR'

* Check what is the correct IK field: DTWS1 untill DTWS4

2 step:

Prerequisite:

BKPF-BLART <> 'RE'

Substitution:

BSEG - DTWS1 = 'LR'

If DTWS1 field wasn't activated for OBBH go to SE16, table VWTYGB01, class 9, and uncheck 'exclude'.

Best Regards

[Former Member · Accepted solution]

Hi Marssel

Thanks for your detailed response.

But the situation is, F110 need to check the Document Type (BLART) from the Original Invoices in FBL1N and Update the Instruction Key in Payment document.

So I'm not sure if the above solution can be directly used.

Thanks

Srini

[Marssel700 · Accepted solution]

If you want to change Payment document It can't be used so.

You can do a user exit or BTE.

Have a look in the following link:

Substitution for BSEG-SGTXT while doing F110

[Former Member · Accepted solution]

Thanks Marssel & others,

I have collected necessary info. Checking with my ABAP team on the best feasible approach.

Regards

Srini