将KNKK select查询迁移到S/4HANA？

Question

我在我的一个程序中有以下选择，由于迁移到SAP S/4HANA，我需要修改它。

SELECT kunnr klimk 
  FROM knkk UP TO 1 ROWS 
  INTO (knkk-kunnr,knkk-klimk) 
 WHERE kunnr = p_kunnr.

如何修改才能使其在S4HANA中生效？

使用UKMBP_CMS_SGM-CREDIT_LIMIT的KNKK-KLIMK I can replace，但是KNKK-KUNNR呢？

提前感谢！

Answer 1

旧编码：

 CLEAR knkk.
SELECT kunnr klimk 
  FROM knkk UP TO 1 ROWS 
  INTO (knkk-kunnr,knkk-klimk) 
 WHERE kunnr = p_kunnr.

新编码：

DATA: z_bp TYPE bu_partner_guid.
SELECT partner_guid 
  FROM cvi_cust_link UP TO 1 ROWS 
  INTO z_bp 
 WHERE customer = p_kunnr.
ENDSELECT.

IF z_bp NE ukmbp_cms_sgm-partner.
 CLEAR ukmbp_cms_sgm.
SELECT partner credit_sgmnt 
  FROM ukmbp_cms_sgm UP TO 1 ROWS 
  INTO ( ukmbp_cms_sgm-partner, ukmbp_cms_sgm-credit_sgmnt )                                                        
 WHERE partner = z_bp.
ENDIF.