SAP ABAP SQL CASE 套 CASE

直接上代码

"数据提取SELECT a~bukrs, a~werks, a~matnr, a~blart, a~gjahr, a~poper,    "a表上的年度  期间
         a~racct, c~wadat_ist, a~wsl, a~msl,CASE WHEN d~xchar = 'X' THENCASE WHEN a~msl < 0 THEN d~kcmeng * -1       ELSE d~kcmengENDELSECASE WHEN a~msl < 0 THEN d~lgmng * -1       ELSE d~lgmngENDEND AS fklmg,d~meins ,    CAST( substring( c~wadat_ist, 1, 4 ) AS NUMC ) AS gjahr_dn, CAST( concat( '0', substring( c~wadat_ist, 5, 2 ) ) AS NUMC ) AS poper_dn   "发货单上的年度 期间FROM @lt_acdoca_bkpf_rv AS aINNER JOIN vbrp AS b ON a~awref = b~vbeln AND a~awitem = b~posnrINNER JOIN likp AS c ON b~vgbel = c~vbelnINNER JOIN lips AS d ON b~vgbel = d~vbeln AND b~vgpos = d~posnr INTO TABLE @DATA(lt_rv_sum_t).