topic Re: table link in Application Development and Automation Discussions

table link

Former Member — Wed, 07 May 2008 05:24:11 GMT

Hi all.

I am working with delivery note sap script. I need to fetch “term of delivery “ from TINC-BEZEI (based on LIKP-VBELN),so how can make link between those table?

Pls help me.

Reward for all helpful answers.

Regards.

jay

Re: table link

Former Member — Wed, 07 May 2008 05:39:56 GMT

LIKP-INCO1 = TINC-INCO1 Check below query for better understanding:

SELECT a~vbeln a~inco1 b~beizei
  INTO TABLE i_inco
  FROM likp AS a
  INNER JOIN tinc AS b
  ON a~inco1 = b~inco1
  WHERE a~vbeln = p_vbeln
  AND   b~spras = sy-langu.

Re: table link

Former Member — Wed, 07 May 2008 05:42:03 GMT

Hi,

Relatioship between those two tables is likp-inco1 = tinc-inco1

these relationship you can write in program.

*reward points

Re: table link

Former Member — Wed, 07 May 2008 05:45:14 GMT

Hi,

Link both the table with INCO1 field...this is common in both...

Select BEZEI from TINC into table t_tinc

FOR ALL ENTRIES IN t_likp

where INCO1 = t_likp-INCO1

and ur other where condition....

Reward points if helpful...

Re: table link

Former Member — Wed, 07 May 2008 06:47:08 GMT

Hi Eswar.

Thanks for your reply, I need to fetch field BEZEI,its not available in the table TINC,but am getting field BEZEI while seeing the content of table TINC .

How s happening?

How can I fetch BEZEI from TINC?

Is it possible? If No which table I need to refer?

What is relation between field BEZEI and table TINC?

Please help me to resolve this problem.

Regards,

Jay

Re: table link

Former Member — Wed, 07 May 2008 06:52:18 GMT

You can see table TINC has a text table i.e TINCT, so change the above query and replace table TINC with TINCT. Rest remains the same.

SELECT a~vbeln a~inco1 b~beizei
  INTO TABLE i_inco
  FROM likp AS a
  INNER JOIN tinct AS b
  ON a~inco1 = b~inco1
  WHERE a~vbeln = p_vbeln
  AND   b~spras = sy-langu.

Re: table link

Former Member — Wed, 07 May 2008 06:53:03 GMT

hI,

The Field BEZEI Is maintained in the text table TINCT(Click on GOTO-->Text table Here u will find the field).

use of the text table:let say you have A table where Material and material description are present in english and your user asked you to display in french,

so all the material descriptions are stored in different languages in the text table of that table.

Regards

Kiran Sure

Re: table link

Former Member — Wed, 07 May 2008 08:52:05 GMT

Hi Eswar.

thanks for reply ,stilll i have doubt,as per ur select quary what is p_vbeln? (how ur giving link between LIKP and TINCT? pls explain)

how this field getting value?

pls reply me.

to be reward u if u slove my issue.

Regards.

jay

Re: table link

Former Member — Wed, 07 May 2008 08:58:03 GMT

Hi Machi.

Help me da ,stilll i have doubt,as per ur reply ,how ur giving link between LIKP and TINCT? pls explain

pls reply me.

Regards.

Nagarajan jayaraman .

Re: table link

Former Member — Wed, 07 May 2008 09:03:17 GMT

Your query is to find the link between LIKP and TINC-BEZEI. So the query i gave you is to establish the link in finding the text of Delivery Incoterms. P_VBELN is the delivery number. I have taken that as PARAMETER from selection-screen. Depending on your criteria you can alter the source of delivery number.