本文介绍了是否选择ON子句中的WITH SUBSTRING?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我在ABAP中有以下SELECT语句:
SELECT munic~mandt VREFER BIS AB ZZELECDATE ZZCERTDATE CONSYEAR ZDIMO ZZONE_M ZZONE_T USAGE_M USAGE_T M2MC M2MT M2RET EXEMPTMCMT EXEMPRET CHARGEMCMT INTO corresponding fields of table GT_INSTMUNIC_F FROM ZCI00_INSTMUNIC AS MUNIC INNER JOIN EVER AS EV on MUNIC~POD = EV~VREFER(9). "where EV~BSTATUS = '14' or EV~BSTATUS = '32'. 上面语句的问题是无法识别‘on’子句上的子字符串/偏移量操作。如果我去掉‘(9),那么 它识别该字段,否则将显示错误:字段ev~refer未知。它既不在指定表中,也不在指定表中 也不是由"数据"语句定义的。我还尝试在‘WHERE’子句中执行类似的操作,收到类似的错误:
LOOP AT gt_instmunic. clear wa_gt_instmunic_f. wa_gt_instmunic_f-mandt = gt_instmunic-mandt. wa_gt_instmunic_f-bis = gt_instmunic-bis. wa_gt_instmunic_f-ab = gt_instmunic-ab. wa_gt_instmunic_f-zzelecdate = gt_instmunic-zzelecdate. wa_gt_instmunic_f-ZZCERTDATE = gt_instmunic-ZZCERTDATE. wa_gt_instmunic_f-CONSYEAR = gt_instmunic-CONSYEAR. wa_gt_instmunic_f-ZDIMO = gt_instmunic-ZDIMO. wa_gt_instmunic_f-ZZONE_M = gt_instmunic-ZZONE_M. wa_gt_instmunic_f-ZZONE_T = gt_instmunic-ZZONE_T. wa_gt_instmunic_f-USAGE_M = gt_instmunic-USAGE_M. wa_gt_instmunic_f-USAGE_T = gt_instmunic-USAGE_T. temp_pod = gt_instmunic-pod. SELECT vrefer FROM ever INTO wa_gt_instmunic_f-vrefer WHERE ( vrefer(9) LIKE temp_pod ). " PROBLEM WITH SUBSTRING "AND ( BSTATUS = '14' OR BSTATUS = '32' ). ENDSELECT. WRITE: / sy-dbcnt. WRITE: / 'wa is: ', wa_gt_instmunic_f. WRITE: / 'wa-ever is: ', wa_gt_instmunic_f-vrefer. APPEND wa_gt_instmunic_f TO gt_instmunic_f. WRITE: / wa_gt_instmunic_f-vrefer. ENDLOOP. itab_size = lines( gt_instmunic_f ). WRITE: / 'Internal table populated with', itab_size, ' lines'. 我要实现的基本任务是修改一个表上的特定字段, 从另一个值中提取值。它们有一个公共字段(pod=vrefer(9))。提前感谢您抽出时间。 abapfield(9)是由推荐答案环境处理的子集操作,不能转换为数据库级别的SQL语句(至少目前不能转换,但如果将来会转换,我会感到惊讶)。最好的方法是分别选择数据集并手动合并(如果两者的大小大致相同),或者预先选择一个数据集并使用FAE/IN子句。
更多推荐
是否选择ON子句中的WITH SUBSTRING?
发布评论