topic Re: Export field to database in Application Development and Automation Discussions

Export field to database

Former Member — Wed, 25 Oct 2006 10:27:14 GMT

Hi,

I want to export a field from my program to database table, does any body knows what should be the structure of the database table. I want to export a date field.

Thanks in advance

Anu

Re: Export field to database

Former Member — Wed, 25 Oct 2006 10:29:31 GMT

if there is only one date field in the database table , then the fields in ur database table will be MANDAT and ur date field DATE

then in ur program u can write

ztable-date = date.
insert ztable.

Re: Export field to database

Former Member — Wed, 25 Oct 2006 10:33:36 GMT

ztable-field1 = field1..

ztable-field2 = field2.------

modif ztable.

Re: Export field to database

Former Member — Wed, 25 Oct 2006 10:35:21 GMT

Hi,

if you want to export one field to DB

use update ztable set fld = itab-fld1

where ...

regards

amole

Re: Export field to database

Former Member — Wed, 25 Oct 2006 10:41:21 GMT

U can use

EXPORT ldate FROM sy-datum TO DATABASE INDX(AR) KEY 'ID'.

Re: Export field to database

Former Member — Wed, 25 Oct 2006 11:13:30 GMT

U know hoz the database structure indx should be and whats ar, I have tried using mandt and the field name but its giving error

Re: Export field to database

Former Member — Wed, 25 Oct 2006 13:15:16 GMT

U dont need to populate anything explicitly in INDX database.

EXPORT ldate for sy-datum to database INDX(AR) key 'id'.

ldate ->is the variable you wish to export.

sy-datum ->is the data for ldate

AR -> is the ARea of INDX database

Id -> is the id of the indx database.

U would need the area and id to import the values again.

Regards

Anurag