ABAP STRING_AGG将一列数据拼接成一个字符串
- 代码
"组合前 "组合前 SELECT MFRNR FROM MARA WHERE MATNR LIKE '10400343%' AND MFRNR IS NOT INITIAL INTO TABLE @DATA(WA_MFRNR1). CL_DEMO_OUTPUT=>DISPLAY( WA_MFRNR1 ). "组合后 SELECT STRING_AGG( MFRNR,'/' ORDER BY MFRNR ASCENDING ) FROM MARA WHERE MATNR LIKE '10400343%' AND MFRNR IS NOT INITIAL INTO @DATA(WA_MFRNR2). CL_DEMO_OUTPUT=>DISPLAY( WA_MFRNR2 ).
- 示例
2.效果
- 组合前
- 组合后
XXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXX
post SAP-Garson
原文链接:https://blog.csdn.net/qq_30797051/article/details/121047428文章来自于网络,如果侵犯了您的权益,请联系站长删除!