topic Re: Slow Process More Time Utilize in Application Development and Automation Discussions

Slow Process More Time Utilize

Former Member — Thu, 22 May 2014 05:28:44 GMT

Hi,

I am Raj.

I Develop one module for Notification direct upload in SAP from Excel sheet and Generate Sales Order.

I have some issue regarding slow process.

i Generate notification for Customer Equipment.

at the time of upload i have to check Sales date for Customer Equipment. in Table vbrk / vbrp / objk / ser01

when i raise query for Equipment invoice date then some time it takes long time to take data .

please give solution.

SELECT VBRK~FKDAT OBJK~EQUNR
        INTO TABLE I_VBRK
        FROM OBJK
        INNER JOIN SER01 ON OBJK~OBKNR = SER01~OBKNR
        INNER JOIN VBRP ON SER01~LIEF_NR = VBRP~VGBEL
        INNER JOIN VBRK ON VBRP~VBELN = VBRK~VBELN
        FOR ALL ENTRIES IN GT_DATA
        WHERE OBJK~EQUNR = GT_DATA-EQUNR
        AND OBJK~TASER = 'SER01'.

Please Check Above Query And Give me Solution.

Regards / Thanks,

Raj Dudharejiya.

Re: Slow Process More Time Utilize

Former Member — Thu, 22 May 2014 08:45:37 GMT

Hi Raj,

I think that line

INNER JOIN VBRP ON SER01~LIEF_NR = VBRP~VGBEL

will cause the performance issue, because there is no secondary index for field VGBEL in table VBRP by default.

Maybe an additional JOIN of table VBFA may solve your issue: SER01 => VBFA => VBRP

Regards,

Klaus

Re: Slow Process More Time Utilize

Former Member — Thu, 22 May 2014 10:09:48 GMT

Dear Sir,

Sorry for late Reply. i was busy on another developement

Thanks for your suggestion. i try this in my coding.

i want to know that sap have any function module or any other that give me invoice document date for given Equipment.

i you knew then please answer me.

Regards,

Raj

Re: Slow Process More Time Utilize

RaymondGiuseppi — Thu, 22 May 2014 10:53:52 GMT

Look also in 185530 - Performance: Customer developments in SD for performance related hints on some of those tables and secondary indexes to use (as VBFA suggested by Klaus Babl)

Regards,

Raymond