topic Re: Internal table fields. in Application Development and Automation Discussions

Internal table fields.

Former Member — Wed, 12 Sep 2007 06:24:10 GMT

Hi ALL ,

I want to take the fields from tables vbak ,kna1, vbkd, zspers and display its fields into 1 single output without using inner join . If U know help me.

The required fields are :

erdat LIKE vbak-erdat, " Date on Which Record Was Created

ernam LIKE vbak-ernam, " Name of Person who Created the Object

auart LIKE vbak-auart, " Sales Document Type

kunnr LIKE vbak-kunnr, " Sold-to party

ps_psp_pnr LIKE vbak-ps_psp_pnr, " Work Breakdown Structure Element

KDGRP LIKE vbkd-KDGRP, " Customer group

ZSSIDC LIKE zspers-ZSSIDC , " Salesman ID

PSTLZ LIKE kna1-PSTLZ , " Postal Code

Re: Internal table fields.

ashwin_bhat — Wed, 12 Sep 2007 06:27:13 GMT

If you do not want to code explicitely in the program, create a view with these tables.

Re: Internal table fields.

Former Member — Wed, 12 Sep 2007 06:33:55 GMT

try using SELECT FOR ALL ENTRIES....its a better alternative to inner join

Regards,

Ravikanth

Re: Internal table fields.

Former Member — Wed, 12 Sep 2007 06:35:31 GMT

Hello Vinoth,

you can fetch data from the tables VBAK ,LNA1,VBKD,ZSPERS.

by using the for all entries .

get the entries from VBAK based on your requirement.

if not it_VBAK[] is initial.

select * from vbkd into table it_vbkd for all entries in it_vbak

where vbeln = it_vbak-vbeln.

endif.

use the same logic for KNA1 table aslo and get the data.

The relation between VBAK & KNA1 is the customer number.

in the same way check the relation for your custom table ZSEPRS and get the data.

loop the it_vbak and use the read statement and move the data from it_vbkd, from kna1 table & ZSPERS into it_vbak.

if your final table is it_vbak modify it_vbap else append the data into your new final table.

Reward if useful.

Regards,

Phani.

Re: Internal table fields.

Former Member — Wed, 12 Sep 2007 06:49:36 GMT

hi,

check this one.

select-options: s_kunnr like kna1-kunnr.

select a~erdat

a~ernam

a~auart

a~kunnr

a~ps_psp_pnr

b~kdgrp

c~zssidc

d~pstlz

into table itab

from vbak as a

inner join vdkd as b on a_{kunnr = b}kunnr

inner join zspers as c on b_{kunnr = c}kunnr

inner join kna1 as d on c_{kunnr =d}kunnr

where a~kunnr in s_kunnr.

in the above join st

iused kunnr as common field in all tables and u canchange according to our wish and i taken a s_kunnr as a select option..

REWARD ALL USEFUL ANSWERS.

WITH REGARDS,

SURESH ALURI.