Community
Application Development and Automation 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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

need table relation

Former Member

‎2008 Apr 10 11:51 AM

0 Likes
720

hi ,

i need table relation for crhd and any of the three tables mara or blpk. i have fields arbpl and stand to be taken from crhd.

hi ,

i need table relation for crhd and any of the three tables mara or blpk. i have fields arbpl and stand to be taken from crhd.

Reply
2 REPLIES 2
Read only

Former Member

‎2008 Apr 10 12:11 PM

0 Likes
606

BLPK table contains matnr and werks fields with these two fields u can join these three tables

BLPK-matnr = MARA-matnr and

BLPK-werks = CRHD-werks

Read only

Former Member

‎2008 Apr 10 12:20 PM

0 Likes
606

hi,

go to TCODE sqvi , using this transaction you can find relation between any tables

follow the procedure

go t code >sqvi->write in quick view as any word->create->give title ->table join--->table view then execute

now go to 2nd icon above write the table name everytime

Rward points if helpful

pankaj