SAP LIPS EKPO VBAP关系

关系"/>

SAP LIPS EKPO VBAP关系

LIPS和EKPO

• EBELP长度为6，VGPOS长度为5；不能直接关联
• 可用 substring() right()函数转换

  SELECT A~VGBEL,A~VGPOS,I~EBELN,I~EBELPFROM LIPS AS AINNER JOIN EKPO AS ION A~VGBEL = I~EBELN AND SUBSTRING( A~VGPOS,2,5 ) = I~EBELPINTO TABLE @DATA(LT_DATA)UP TO 300 ROWS.CL_DEMO_OUTPUT=>DISPLAY( LT_DATA ).SELECT A~VGBEL,A~VGPOS,I~EBELN,I~EBELP
  FROM LIPS AS A
  INNER JOIN EKPO AS I
  ON A~VGB