SAP SQL 表inner join 不同长度字段连接
SELECT B~VBELN,
A~KSCHL
FROM NAST AS a
INNER JOIN VBRK AS B ON LEFT( a~OBJKY,10 ) = B~VBELN
WHERE ( B~VKORG BETWEEN 'A101' AND 'A103' )
AND A~KSCHL = 'ZGPB'
INTO TABLE @DATA(LT_NA).
posted on 2020-07-10 17:16 TorranceZhao 阅读(1658) 评论(0) 收藏 举报
浙公网安备 33010602011771号