The data selected for a given vendor is compared to the data selected for the other vendors.
The following fields are compared:
Name: LFA1- NAME1
Address ID: LFA1 – ADRNR
Street: LFA1 – STRAS
City: LFA1 - ORT01
VAT reg number: LFA1 – STCEG
Phone number: ADR2 - TEL_NUMBER
Bank account: LFBK – BANKN
If any field matches to another vendor in the selected data, the vendor is added to the output dataset.
how can i, select and join the Records when they are Same, From Table (lfba1, lfb1,adr2 and lfbk) to a new table? in ABAP