‎2007 Mar 02 6:24 AM
Hi All,
Can anyone tell me where cud i find these fields ...
FIELD KEY TYPE
Accept Indicator, Y Char 1
Financial Document number, Y Char 10
Selection date for audit, N date
Auditor User ID, N Char 12
Processor User ID ( Who created the Document), N Char 12
Vendor Number, N Char 10
Date of Audit, N Date
Time of Audit, N Time
Selection Reason, N Char 1
Selection table, N Char 1
Additional Text. N Char 40
As am creating a ZZ_Audit_rec table with these following fields, am not able to collect all these fields from existing table in database.
Regards,
Parvez.
‎2007 Mar 02 6:35 AM
Hi,
it is better to create your own fields individuvally,by creating dataelements and domains for example for creating field you need to creating dataelement and and
assign domain of ?(char1) which are already existing.after that create table with
that elements.
Thanks
Sarala.
‎2007 Mar 02 6:35 AM
Hi Md,
Just Give Char1 in Dataelement of the Field.It's data Type will be determined automatically.So as for rest of your Char type filds.
For Date field give <b>DATUM</b> as data element and for
Time field give <b>UZEIT</b> as dataelement.
Rgds,
Jothi.P
*Pl ward and close the thread if you got the ans.