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
Post a Comment