abap基础表之间的联系

基础表之间的联系
VBAK 销售订单抬头
VBAP 销售订单行项目
KNA1 客户主文件一般数据
vbak和vbap通过vbeln关联
vbak和kna1通过kunnr关联

LIPS 交货单明细
VBRP 发票行项目
VBFA 销售凭证流

vbap和vbfa通过 vbfa~vbelv = vbap~vbeln
vbfa~posnv = vbap~posnr
lips和vbfa通过 lips~vbeln = vbfa~vbeln
lips~posnv = vbfa~posnv
vbrp和vbfa通过 vbrp~vbeln = vbfa~vbeln
vbrp~posnr = vbfa~posnn
lips和vbap通过 lips~vgbel = vbap~vbeln
lips~vgpos = vbap-posnr

LIKP_VBELN-> LIPS_VBELN到LIPS_VBELN＆POSNR-> VBRP_VGBEL＆POSNR到VBRP_VBELN-> VBRK_VBELN <> 最后
LIPS_VGBEL＆POSNR-> VBAP_VBELN＆POSNR到VBAP_VBELN-> VBAK_VBELN

SELECT *
FROM knvp AS k
INNER JOIN knvv AS v
ON v~kunnr = k~kunnr
AND v~vkorg = k~vkorg
AND v~vtweg = k~vtweg
AND v~spart = k~spart

• INNER JOIN knb1 AS b
• ON b~kunnr = k~kunnr
  INNER JOIN kna1 AS a
  ON a~kunnr = k~kunnr
  INNER JOIN but000 AS t
  ON t~partner = k~kunnr
  INTO CORRESPONDING FIELDS OF TABLE i_data
  knvp knb1 kna1 之间链接通过 子弹 kunnr
  but000 通过 t~partner = k~kunnr

knvp knvv 通过 kunnr vkorg vtweg spart 相同判断.