Data Comparison Tool for Brfplus tables

[former_member198721]

Hi Experts,

I am looking for some functionality for data comparison in decision tables , before and after uploading the data.

We are in data migration and want to ensure that data is correct.

Is there any tool , any functionality available with BRFplus.

Regards,

Khushbu

[christianlechne · Accepted solution]

Hi Khushbu,

to the best of my knowledge there is no such functionality that is delivered with BRFplus.

If you want to compare the decision tables programmatically you have to implement that by yourself using the BRFplus API.

The document gives you a good insight how this can be achieved.

BR

Christian

[former_member198721 · Accepted solution]

Hi Christian ,

Thank you for quick response.But My requirement is to compare the inserted data in the decision table and the excel which is used to upload.

for example ,

Column_1  is numeric and should have 5 numbers data.

and from excel its uploading 1 so how to validate data consistency.

It should only allow 00001 not 1 , like this.

So do we have anything in BRFplus for checking this consistency.

Regards,

Khushbu

[christianlechne · Accepted solution]

Hi Khushbu,

ok understood. This type of consistency check depends on the concrete requirement.

Checks and (conversions if possible) are implicitly done when the data is uploaded from excel to BRFplus. These checks are the same as the ones when you enter data into the decision table directly.

All check sthat go beyond them have to be implemented by yourself and are not avaiable out-of-the-box.

BR

Christian

[former_member391930 · Accepted solution]

Can you share this document

Automating Rate Updates in DSM and BRFPlus

thanks

[christianlechne · Accepted solution]

Hi Luis,

can you please get in touch with the SAP Community moderators. The link is broken and tehy are the only ones who might know who can fix this.

Best regards,

Christian

[former_member391930]

Is there any good tool to compare BRF table content? thanks

[former_member198721]

We build one tool, using API of brfPlus:

It simply uses the Function modules of excel and compares the data and give error logs or Success logs . for pointing out unique row , we used GUID numbers , they are automatically generated , and served as unique key.