Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Export field to database

Former Member
0 Likes
786

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

6 REPLIES 6
Read only

Former Member
0 Likes
738

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.

Read only

Former Member
0 Likes
738

ztable-field1 = field1..

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

modif ztable.

Read only

Former Member
0 Likes
738

Hi,

if you want to export one field to DB

use update ztable set fld = itab-fld1

where ...

regards

amole

Read only

Former Member
0 Likes
738

U can use

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

Read only

0 Likes
738

Hi

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

Read only

0 Likes
738

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