Slow Process More Time Utilize

[Former Member]

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.

[Former Member]

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

[Former Member]

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

[RaymondGiuseppi]

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