基础表之间的联系
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 相同判断.