topic Re: tables in Application Development and Automation Discussions

tables

Former Member — Thu, 13 Oct 2005 10:10:39 GMT

hi,

I am not getting the data from table ISEG because of no entries but other talbes which contains the data...with similar fields in ISEG...so now i wanted to transfer or update the table ..

what is the procedure and advice me..

raju

Re: tables

Former Member — Thu, 13 Oct 2005 10:20:18 GMT

Hi,

I don't understood your problem?

can you explain me better?

bye

enzo

Re: tables

Former Member — Thu, 13 Oct 2005 10:31:16 GMT

i am not getting the data from ISEG table because table entires foud '0'.

i want to wirte a reposrt using with particular talbe ...

for exapmle matnr is there in mara and some other talbe but not updating data in ISEG....

I THINK U GOT MY POINT

Re: tables

Former Member — Thu, 13 Oct 2005 10:42:58 GMT

Hi,

I think u can create a report to update ur table ISEG

1.First move the DBtable that contains the entries into

a internal table ITAB

2.Then use UPDATE DBTABLE FROM TABLE ITAB

TABLE ISEG

DATA: ITAB TYPE TABLE OF DBTABLE

WA LIKE LINE OF ITAB.

SELECT * FROM DBTABLE INTO ITAB.

UPDATE ISEG FROM TABLE ITAB.

Hope i have understood ur question.

Thanks&Regards,

Ruthra

Re: tables

Former Member — Thu, 13 Oct 2005 11:15:39 GMT

Ruthra,

it is showing me the error

The type "DBTABLE" is unknown, but there is a type with the similar name "TABLE".

RAJU

Re: tables

Former Member — Thu, 13 Oct 2005 11:29:06 GMT

Hi,

DBTABLE is nothing but the name of a table that contains the entries.Like it can be MARA OR ISEG.

Hope u r clear,

Thanks,

Ruthra

Re: tables

jayanthi_jayaraman — Thu, 13 Oct 2005 11:34:09 GMT

Hi,

I assumed that you have matnr and maktx fields in iseg.

data : itab type standard table of iseg,

wa type iseg.

select mara_{matnr makt}maktx from ( mara inner join makt

on mara_{matnr = makt}maktx ) into corresponding fields of itab.

insert iseg from table itab.

Kindly reward points if it helps.

Re: tables

Former Member — Thu, 13 Oct 2005 11:48:04 GMT

ERROR:

You cannot use an internal table as a work area.

Re: tables

jayanthi_jayaraman — Thu, 13 Oct 2005 11:53:21 GMT

Hi,

select mara_{matnr makt}maktx from ( mara inner join makt

on mara_{matnr = makt}maktx ) into corresponding fields of <b>table</b> itab.

Re: tables

RichHeilman — Thu, 13 Oct 2005 12:29:59 GMT

Hey guys, since when is it a good idea to directly update a sap standard table?



insert iseg from table itab.

Regards,

Rich Heilman

Re: tables

RichHeilman — Thu, 13 Oct 2005 12:31:20 GMT

This table, ISEG, is filled by the physical inventory processing of standard SAP, you should not be adding entries directly. Use the standard SAP transactions.

Regards,

Rich Heilman