Fill Internal Header Table for Table VBUK corrupted

[Former Member]

Hi all

I had Cluster on each table ( VBUK, VBFCL... )

SP13 all need notes are implemented,

Parameter P_ROLL = 'X'

P_CUST = 'Y'

but system dumpt all 6 hours Remote error

one question does für VBUK fill also gave a Paramter p_full ?

thanks for feedback or other inputs

L

[suman_pr · Accepted solution]

Hi,

@Sri: In case of Lou, it is indeed not possible to create an index on VBFA since it is a cluster table. This in turn leads to access of the VBFCL cluster which was known to have performance issues. This is the reason VBFA was shipped as a transparent table later on.

@Lou: If possible, you can convert the cluster table to a transparent table on which indexes can be built to speedup the process. But yes, this takes quite some time. You can refer to note 77282 for the conversion process. So once you have converted VBFA to a transparent table, it would be possible to create the secondary indices and hence bring about considerable improvement in the performance of the activity.

Best Regards,

Suman

[sunny_pahuja2]

Hi,

Have you executed below settings as per operation guide ?

When you start working in the phase u2018Data Transferu2019 (which means that this phase

is the technically active phase), set parameter u2018P_CLUu2019 to u2018Yu2019 in the following

activities before you start the activities for filling internal header tables:

􀂃 TD05X_FILL_BKPF

􀂃 TD05X_FILL_CE

􀂃 TD05X_FILL_EKKO

􀂃 TD05X_FILL_VBUK

􀂃 TD05X_FILL_VBUK_1

􀂃 TD05X_FILL_VBUK_2

􀂃 TD05X_FILL_VSRESB

􀂃 TD05X_FILL_WBRK_1

You can do so by placing the cursor on each of these activities, then using the

Troubleshooting button and executing activity 'Adjust parameter for excution in

Troubleshooting treeu2019. Then you get a list of possible parameters for the

activity. Set P_CLU to Selection value low = Y

Thanks

Sunny

[Former Member]

Hi Sunny

Thank you for answering

i had done P_CLU = 'Y'

for follows steps

TD05X_FILL_VBUK -> works

TD05X_FILL_VBUK_1 -> works

TD05X_FILL_VBUK_2 -> Error

way do i need the others they run perfectly?

Problem is TD05X_FILL_VBUK_2 -> run on Cluster table VBFCL ( 40M data record ) -> full table scan time 6 hours

Batch job wait with status ARFC if Central system will check the status of Job the job dump ...

What could i do?

[sunny_pahuja2]

Hi,

check SAP note 1054584 and 1256679.

Thanks

Sunny

[Former Member]

Hi Sunny

1054584 is implemented

1256679 -> VBFA is a cluster table, i can't create a Index ...

regards

L

[Former Member]

Are you sure that you can NOT create the index for VBFA?

I did create the index per that OSS note without any problem.

Please clarify. Thanks!

[Former Member]

TDMS experts:

I remember that I indeed created an index for VBFA per that famous OSS note.

However because I have changed to a different project so that I cannot verify.

Additionally, this link also almost explicitly says that index on VBFA is feasible:

So why in the previous posting Lou says:

1256679 -> VBFA is a cluster table, i can't create a Index ...

I appreciate if you experts can share your experience on this.

Regards!