topic Re: need table relation in Application Development and Automation Discussions

need table relation

Former Member — Thu, 10 Apr 2008 10:51:56 GMT

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.

Former Member — Thu, 10 Apr 2008 11:11:07 GMT

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

Former Member — Thu, 10 Apr 2008 11:20:38 GMT

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