首页 > 其他 > 详细

DDLS报错数据类型冲突:data type conflict in a selection 解决办法

时间:2019-12-25 19:20:49      阅读:79      评论:0      收藏:0      [点我收藏+]
@AbapCatalog.sqlViewName: ZCDSV_FCS
@AbapCatalog.compiler.CompareFilter: true
@ACCESSCONTROL.AUTHORIZATIONCHECK: #CHECK
@EndUserText.label: 
define view Z_DDLS_FCS as select from pbim as A
inner join pbed as B on A.bdzei = B.bdzei 
inner join mara as C on A.matnr = C.matnr
left outer join marc as D on A.matnr = D.matnr and A.werks = D.werks
left outer join makt as E on A.matnr = E.matnr and E.spras = 1
{      A.matnr,
       A.werks,
       C.mtart,
       C.mstae,
       D.maabc,
       D.plifz,
       D.rgekz,
       D.dispo,
       D.ekgrp,
       B.plnmg,
       B.perxx,
       E.maktx   
} 

上面代码报错

技术分享图片

 

 解决办法:1后面放空格

left outer join makt as E on A.matnr = E.matnr and E.spras = ‘1 ‘

DDLS报错数据类型冲突:data type conflict in a selection 解决办法

原文:https://www.cnblogs.com/mingdashu/p/12098349.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!