into corresponding fields.

来源：学生作业帮编辑：作业帮分类：综合作业时间：2024/10/02 19:08:47

into corresponding fields.
Hi,When i search on 'Performance' in this forum,i noticed many posts suggest Not to use into Corresponding fields of ..and i have a program with this selection,therefore would apprecieate any good suggestion..select z"kunnr z"VKORG z"erdat z"auart z"vdatu a"vbeln a"posnr a"kwmeng a"klmeng a"netwr a"PSTYV a"werks a"VRKME b"absta b"lfsta a"matnr a"prodh c"bukrs into corresponding fields of table TA_VBAP from VBAK as Z join VBAP as a on Z"vbeln = a"vbeln join vbup as b on a"vbeln = b"vbeln and a"posnr = b"posnr join TVKO as c on Z"vkorg = c"vkorg where z"kunnr in l_kunnr and z"vdatu in l_vdatu and z"auart in l_auart and Z"vkorg in l_vkorg and z"vbeln in l_vbeln.how can this be improved thanks...

Most importantly though, change your WHERE condition so that the keys (VBELN) appear first. Depending on your database this could really mess up thinks if you don't place the keys first. This is good practice regardless of the database being used.Other than that, do as gaurav_anand7 suggested.Oh yeh, and swap the orde rof your ON clause so that:Code: Select allon Z"vbeln = a"vbeln becomes Code: Select allON a"vbeln = z"vbelnThis, depending again on your database, can make a difference.Dr Sidewalk 查看原帖

英语翻译At the corresponding fields of the Options tab you may s fields be corresponding 一道英语首字母填空rainforests have been t_____ into fields for growin corresponding job reference principal corresponding author是什么意思 corresponding editor是什么意思 valder fields fields是什么意思 in the corresponding period last MOVE-CORRESPONDING struc1 TO struc2 MOVE 和 MOVE-CORRESPONDING的区别是什么?