Skip to Content
avatar image
Former Member

MRBR Query for Records Since Last Run

I have a requirement to pull all the blocked invoices since the last programs run.

The main table in MRBR is RBKP_BLOCKED. I'm needing to pull all of the records in that table since the program last run.

The main tables I know I need are RBKP_BLOCKED, RSEG, EKKO

How is RBKP_BLOCKED filled? How can I know when something was changed so I can pull the correct records?

RSEG holds the blocking types like SPGRS etc, but where do those get set?

Thanks for your help.

Points will be rewarded for helpful answers.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Oct 30, 2007 at 03:37 PM

    Best to check if the tables are structures or tables.

    I presume the tables are calculated, as blocks can come off automatically.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      All of those tables I listed are actual tables. I'm just wondering where they are filled.

      From a functional standpoint, how do those blocks get put on. Is there a transaction. MIRO has payment blocks, but are they the same thing?