REGUH and REGUP Performance issues?

[vsubbakrishna]

Hi all,

I am trying to build a program based on below select query. Will it create performance problem in Production as REGUP is a cluster table.

SELECT

LAUFD

LAUFI

ZBUKR

LIFNR

VBLNR

FROM REGUH

INTO TABLE TYT_REGUH

WHERE LAUFD IN S_LAUFD AND

LAUFI IN S_LAUFI AND

XVORL NE 'X' AND

ZBUKR IN S_ZBUKR.

SELECT

LAUFD

LAUFI

ZBUKR

LIFNR

BUKRS

BELNR

GJAHR

FROM REGUP

INTO TABLE TYT_REGUP

FOR ALL ENTRIES IN TYT_REGUH

WHERE LAUFD EQ TYT_REGUH-LAUFD AND

LAUFI EQ TYT_REGUH-LAUFI AND

XVORL NE 'X' AND

LIFNR EQ TYT_REGUH-LIFNR AND

VBLNR EQ TYT_REGUH-VBLNR AND

ZBUKR EQ TYT_REGUH-ZBUKR.

Thanks,

Subba

[vsubbakrishna]

Hi all,

I am trying to build a program based on below select query. Will it create performance problem in Production as REGUP is a cluster table.

SELECT

LAUFD

LAUFI

ZBUKR

LIFNR

VBLNR

FROM REGUH

INTO TABLE TYT_REGUH

WHERE LAUFD IN S_LAUFD AND

LAUFI IN S_LAUFI AND

XVORL NE 'X' AND

ZBUKR IN S_ZBUKR.

SELECT

LAUFD

LAUFI

ZBUKR

LIFNR

BUKRS

BELNR

GJAHR

FROM REGUP

INTO TABLE TYT_REGUP

FOR ALL ENTRIES IN TYT_REGUH

WHERE LAUFD EQ TYT_REGUH-LAUFD AND

LAUFI EQ TYT_REGUH-LAUFI AND

XVORL NE 'X' AND

LIFNR EQ TYT_REGUH-LIFNR AND

VBLNR EQ TYT_REGUH-VBLNR AND

ZBUKR EQ TYT_REGUH-ZBUKR.

Thanks,

Subba

[Former Member]

Hi Subba Krishna,

As u said, certainlly it will take a lot of time to fetch data from the Cluster table REGUP. It will be better if u give all the Primary key fields in where condition of the select statement.

LAUFD	Date on Which the Program Is to Be Run
LAUFI	Additional Identification
XVORL	Indicator: Only Proposal Run?
ZBUKR	Paying company code
LIFNR	Account Number of Vendor or Creditor
KUNNR	Customer Number 1
EMPFG	Payee code
VBLNR	Document Number of the Payment Document
BUKRS	Company Code
BELNR	Accounting Document Number
GJAHR	Fiscal Year
BUZEI	Number of Line Item Within Accounting Document

These are all the Primary key fields of the table REGUP.

One more thing is to give the where condition fields in order of the table REGUP

LAUFD

LAUFI

XVORL

ZBUKR

LIFNR

VBLNR

Best regards,

raam

[Former Member]

Hi Subba Krishna,

There should not be any performance issue in this select query...

But Try to include as more as possible primary key fields in where condition of both select stmts for better performance.

Also have a look at program RFFOUS_C which is using PYF logical database...

Check if you can use the logical database PYF here...

Or you can create index on REGUH header table...Not sure but might it will improve the performance for your program...

Give a Try once...

Hope it will solve your problem..

Reward points if useful..

Thanks & Regards

ilesh 24x7

[Former Member]

hi,

hello to all of you. i am also looking for the functionality of these tables.

Can i ask u 1 question ?

What is the purpose of the F110 Transaction code? Is it really update these tables REGUP n REGUH ? If it is how it is done through this

transction code?

plzz provide me some guidelines for it.

[vsubbakrishna]

solved on own.

[Former Member]

Hi What is

The solution