SAP LIPS EKPO VBAP关系

LIPS和EKPO

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

  SELECT A~VGBEL,A~VGPOS,I~EBELN,I~EBELP
    FROM LIPS AS A
    INNER JOIN EKPO AS I
    ON A~VGBEL = I~EBELN AND SUBSTRING( A~VGPOS,2,5 ) = I~EBELP
    INTO 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