去掉字符串中所有空格
CONDENSE STREET NO-GAPS.
去掉字符串中左边或右边的空格:
SHIFT string LEFT DELETING LEADING SPACE.
SHIFT string right DELETING LEADING SPACE.
ABAP新语法 ABAP去空格(JOIN时 )
注意: ltrim rtrim 在其他语言是去空,这里可以去空格,还可去a 去B ,因此要多一个参数告诉去什么
另外 replace( bseg~zuonr ,'a','b') 语法也可用,把A替换成B ,问题是 B不能用空白
SELECT
bseg~sgtxt , "票据号
ztfi005~zpjdh ,
ztfi005~zpjfl ,
ztfi005~zbb , "币别
ztfi005~zpjlx , "票据类型
ztfi005~zpmje , "票面金额
ztfi005~zpjdqr , "到期日
ztfi005~zkprq , "开票日期
ztfi005~zcpr , "出票人
ztfi005~zcdyh , "承兑银行
ztfi005~zkplx ,
ztfi005~zcnzt,
bkpf~budat , "收票日期
bkpf~bldat , "收票日期
bseg~belnr , "凭证编号
bseg~umskz , "特别总账标识
bseg~kunnr , "客户代码
bseg~lifnr , "收票人
lfa1~name1 , "收票人名称
bseg~wrbtr , "凭证金额
bkpf~waers , "凭证币别
bseg~zuonr "票据状态
FROM bseg
INNER JOIN bkpf ON bseg~bukrs = bkpf~bukrs AND bseg~gjahr = bkpf~gjahr
AND bseg~belnr = bkpf~belnr
INNER JOIN ztfi005 ON bseg~sgtxt = ztfi005~zpjdh AND ztfi005~zpjfl = 'F'
INNER JOIN lfa1 ON lfa1~lifnr = bseg~lifnr
* WHERE BSEG~SHKZG = 'S'
WHERE ltrim( rtrim( bseg~zuonr,' ' ),' ' ) = '已开票'
AND bseg~bukrs = @p_bukrs
AND bkpf~xreversal = '' "20200509新增逻辑
AND bseg~gjahr = @p_gjahr
AND ztfi005~zpjdh IN @s_zpjdh
AND bkpf~budat IN @s_budat
AND ztfi005~zpjdqr IN @s_zpjdqr
AND ztfi005~zkprq IN @s_zkprq
INTO CORRESPONDING FIELDS OF TABLE @gt_alv1 .
网友评论