Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

HOW TO JOIN CABN CABNT AND CAWN

Former Member
0 Kudos

DEAR EXPERTS,

CAN ANY ONE SUGGEST ME HOW TO JOIN TABLES CABN CABNT AND CAWN

THANX IN ADVANCE

4 REPLIES 4

Former Member
0 Kudos

Short example.

SELECT SINGLE cawnt~atwtb INTO it_table FROM cabn

INNER JOIN cawn ON cawnatinn = cabnatinn

INNER JOIN cawnt ON cawntatinn = cawnatinn AND cawnt~atzhl =

cawn~atzhl

WHERE ....

.

p291102
Active Contributor
0 Kudos

HI,

Through ATINN -Internal characteristic number u can join those tables

Thanks,

Shankar

christian_wohlfahrt
Active Contributor
0 Kudos

Hi!

cabn-atinn = cabnt-atinn = cawn-atinn

cabn-adzhl = cabnt-adzhl = cawn-adzhl

What's the problem?

Regards,

Christian

Former Member
0 Kudos

Ramesh,

SELECT CABNATINN CABNTADZHL CABNTATINN CABNTSPRAS CAWN~ADZHL

CAWNATINN CAWNSPRAS

INTO (CABN-ATINN , CABNT-ADZHL , CABNT-ATINN , CABNT-SPRAS , CAWN-ADZHL

, CAWN-ATINN , CAWN-SPRAS )

FROM ( CABN

INNER JOIN CABNT

ON CABNTATINN = CABNATINN

INNER JOIN CAWN

ON CAWNADZHL = CABNTADZHL

AND CAWNATINN = CABNTATINN

AND CAWNSPRAS = CABNTSPRAS ).

Pls. mark if useful