Joins: Concept of joining 2 or more than 2 tables with the help of a common 
primary key and collecting the required information from them.

Difference arises only when selecting the data from the database table by 
using a select statement as below.

*SELECT** EKKO~BUKRS
EKKO~EBELN
EKKO~BSART
EKKO~AEDAT
EKKO~LIFNR
T001~BUTXT
T161T~BATXT **INTO** **TABLE** IT_EKKO
**FROM** ( ( EKKO INNER **JOIN** T001 **ON** EKKO~BUKRS = T001~BUKRS )
INNER **JOIN** T161T **ON** EKKO~BSART = T161T~BSART )
**WHERE** EKKO~BUKRS **IN** S_BUKRS.*

Find the below code, which explains on how the tables has to be joined with 
the help of ~ ( tilt ) symbol.

For more details How to use inner join in sap 
abap<http://atechlad.com/about-inner-join-in-abap/>

-- 
You received this message because you are subscribed to the Google Groups "SAP 
ABAP" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/sap-abap?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.


Reply via email to