EKKO EKPO EKET LIKP LIPS 这几张表如何关联?

2025-01-07 06:36:04
推荐回答(1个)
回答1:

select * from ekko
join ekpo on ekko~ebeln = ekpo~ebeln
join eket on ekpo~ebeln = eket~ebeln and ekpo~ponsr = eket~posnr
join lips on ekpo~ebeln = lips~vgbel and ekpo~ponsr = lips~vgpos
join likp on lips~vbeln = likp~vbeln
into table