Skip to Content
-2
Jun 25, 2020 at 11:49 AM

Select join

253 Views

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