‎2006 Oct 25 11:27 AM
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
‎2006 Oct 25 11:29 AM
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.
‎2006 Oct 25 11:33 AM
ztable-field1 = field1..
ztable-field2 = field2.------
modif ztable.
‎2006 Oct 25 11:35 AM
Hi,
if you want to export one field to DB
use update ztable set fld = itab-fld1
where ...
regards
amole
‎2006 Oct 25 11:41 AM
U can use
EXPORT ldate FROM sy-datum TO DATABASE INDX(AR) KEY 'ID'.
‎2006 Oct 25 12:13 PM
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
‎2006 Oct 25 2:15 PM
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