2012 Nov 03 4:29 AM
Hi, frnds.. i have to upload date from excel sheet to tcode vf02.
my fields are Billing document(vbeln) and there is a header text tab in that i have to upload text GRN no and GRN DATE
through excel sheet
HOw to do this using FM SAVE_TEXT.
KINDLY HELP AND and provide code if possible.
thanx u
Hi, frnds.. i have to upload date from excel sheet to tcode vf02.
my fields are Billing document(vbeln) and there is a header text tab in that i have to upload text GRN no and GRN DATE
through excel sheet
HOw to do this using FM SAVE_TEXT.
KINDLY HELP AND and provide code if possible.
thanx u
2012 Nov 03 6:18 AM
Try using this in your BDC program before calling transaction VF02
THEAD-TDOBJECT = ‘VBBK’.
THEAD-TDID = ’0002′.
THEAD-TDSPRAS = SY-LANGU.
THEAD-TDNAME = ’your vbeln′.
* Lines
TLINE-TDFORMAT = ‘*’.
TLINE-TDLINE = ‘data from the excel’.
APPEND TLINE.
CALL FUNCTION ‘SAVE_TEXT’
EXPORTING
HEADER = THEAD
SAVEMODE_DIRECT = ‘X’
TABLES
LINES = TLINE
EXCEPTIONS
ID = 1
LANGUAGE = 2
NAME = 3
OBJECT = 4
OTHERS = 5.
IF SY-SUBRC = 0.
WRITE: / ‘Successful’.
COMMIT WORK.
ENDIF.
2012 Nov 08 11:28 AM
2012 Nov 08 12:51 PM