sql - Creating a SAP master vendor table -


i need create master vendor table containing following tables:

lfa1, lfb1, lfbk, lfm1, lfm2 , wyt3 

...in sql. can please assist me on columns link which? e.g.

lfa1.lifnr = lfb1.lifnr creating lfa1_lfb1    lfa1_lfb1.lifnr = lfbk.lifnr creating lfa1_lfb1_lfbk 

...etc.

relationships between these tables are:

  • lifnr between lfa1, lfb1, lfbk , lfm1
  • lifnr , ekorg between lfm1 , lfm2
  • between lfm2 , wyt3, lifnr, ekorg , werks i'm not sure.

Comments

Popular posts from this blog

Java 3D LWJGL collision -

spring - SubProtocolWebSocketHandler - No handlers -

methods - python can't use function in submodule -