topic Re: VBFA Table performance in Application Development and Automation Discussions

VBFA Table performance

Former Member — Thu, 21 May 2015 04:33:29 GMT

Hello All,

This is regarding VBFA table performance,

Iam using VBFA to Get Delivery numbers from Shipment and Invoice numbers from Delivery.

1st Select Statement on VBFA

By using Shipment iam getting Deliveries ,it is taking time to get the data.

here iam using all key fields in select Query.

Average Records is around 10K

2nd Select Statement on VBFA.

By using Deliveries which we get above statement am getting Billing documents.

this is taking too much time almost 30 to 40min .

here also average records around 10+K.

how to resolve this?,Please suggest is there any FM to get data from VBFA or to increase performance of select query.

Regards

Surendra.

Re: VBFA Table performance

Former Member — Thu, 21 May 2015 04:38:05 GMT

Hi,

1. create secondary index on VBFA.

best way to get deliveries and billing numbers as follows.

1. Join LIKP,LIPS get LIKP-VBELN, LIPS-POSNR add your where condition

2. Join VBRK,VBRP and pass LIKP-VBELN to VBRP-VGBEL and LIPS-POSNR to VBRP-VGPOS

and get VBRK-VBELN and VBRP-POSNR .

Regards,

Chandu

Re: VBFA Table performance

Former Member — Thu, 21 May 2015 04:45:38 GMT

Hello Chandra Mohan,

Thanks for Reply.

We cannot create Index as we like ,and to get Deliveries from Shipments we have to use sale flow(VBFA) not LIKP or LIPS .

Re: VBFA Table performance

Former Member — Thu, 21 May 2015 04:56:36 GMT

yes, your correct it is deliveries from shipments.

check the below link : there is a common table for shipment and delivery check this once:

regards

Chandu

Re: VBFA Table performance

RaymondGiuseppi — Thu, 21 May 2015 05:45:57 GMT

Did you read and apply suggestion of 185530 - Performance: Customer developments in SD?


c) Search for invoices with delivery number (preceding document, field VBRP-VGBEL):
Incorrect:    SELECT FROM vbrp WHERE vgbel = ...
Correct:      SELECT FROM vbfa WHERE vbtyp_n = 'M'
                     AND vbelv  = ...
               SELECT FROM vbrp WHERE vbeln = vbfa-vbeln
                     AND posnr = vbfa-posnn

Else can you post SQL actual statement and trace Access plan explanation from ST05?

Regards,
Raymond

Re: VBFA Table performance

Former Member — Thu, 21 May 2015 06:54:06 GMT

Dear Surendra,

Do not use select statements with VBFA table since it is a time consuming query.

Please use function module 'RV_ORDER_FLOW_INFORMATION' to get the document flow (ie: Get Delivery numbers from Shipment and Invoice numbers from Delivery) .

// Result table is 'VBFA_TAB'
// You can identify the relevant document using VBTYP_N and VBTYP_V fields

Regards

Praveen