topic populating the data in Application Development and Automation Discussions

populating the data

Former Member — Wed, 08 Aug 2007 16:44:07 GMT

populating the data to the data base table .... which i created using only reports ...

can any body tell the approach ....... if possible coding also plz help me out ..

but using only general reports ..

Re: populating the data

marcelo_ramos1 — Wed, 08 Aug 2007 17:08:12 GMT

Hi,

Is It what you need ?

TABLES t005.

*"     INTERNAL TABLE
DATA: t_t005 TYPE TABLE OF t005.

*"     STRUCTURE
DATA: s_t005 TYPE t005.

*"     DATA
DATA: v_landk TYPE landk.

START-OF-SELECTION.

*" POPULATING YOUR INTERNAL TABLE
  SELECT *
  FROM t005
  INTO TABLE t_t005
  WHERE land1 EQ 'PT'.

*" POPULATING YOUR STRUCURE
  SELECT SINGLE *
  FROM t005
  INTO s_t005
  WHERE land1 EQ 'PT'.

*" POPULATING YOUR DATA
  SELECT SINGLE landk
  FROM t005
  INTO v_landk
  WHERE land1 EQ 'PT'.

Regards.

Marcelo Ramos

Re: populating the data

Former Member — Wed, 08 Aug 2007 17:48:43 GMT

Are you talking about loading data to an internal table from a database table or poplulating a database table?

If the former, the previous response is correct.

If you are attempting to load data into a database table, there are a number of approaches, including CATT and BDC.

I have frequently used BDC.

Both approaches have the data initialing in a flat file, such as a tab-delimited file output from Excel with the data to be loaded into the table.

The program then loads the data from the PC and creates a BDC session, which simulates data input into the appropriate transaction for updating the table in question.

You can also use a more straightforward technique if you are loading a Z table that does not require the standard edit checking and control you get with CATT or BDC.

Please clarify your request.

Good luck

Brian