RE-FX: How to get the condition guid associated with the invoice item ?

[Former Member]

Hi,

We have scenario to display the condition purpose associated with the  condition line item of the contract in the invoice form generated in the RERAIV.

Getting the condition type associated with the invoice item is not difficult, but getting the condition purpose present in the condition line item of the contract is not being possible so far.

Experts in this group, could please help us on this?

More details:

Contracts have the conditions along with the condition purpose. This also means that we have one condition type, but different condition purposes. The line itesm of the contract conditions are comprising of the condition type and condition purpose.

Unfortunitely, the accouting documents of hte SAP do contain the condition type, not the condition purpose which is very specific to RE-FX. Now, for us to get the condition purpose seems to be possible only through the condition guid.  So, we trying to see, how we can we establish the relation between the invoice item and appropriate condition(in table VICDCOND), so that we can get the condition purpose.

Please help with your inputs, let me know if you need some more details..

Thanks,

Muttanna

[Former Member · Accepted solution]

Dear Muttanna,

REFGUID can be linked accounting header table (BKPF) and RE-FX cashflow table (VICDCFPAY).

VICDCFPAY-REFGUID = VIRADOC-DOCGUID

VIRADOC-REFDOCID   =  BKPF-AWKEY

Thanks and Regards,

Chandra

[franz_posch · Accepted solution]

Dear Muttanna,

when you have identified the entry in table VICDCFPAY you can use internal key for the condition item that generated the cashflow item stored in field CONDGUID. With this key you can find the entry for the condition item in table VICDCOND and there in field CONDPURPOSEEXT the condition purpose is stored.

Hope this information is helpful.

Regards, Franz