topic Re: Output data in file in Application Development and Automation Discussions

Output data in file

Former Member — Mon, 30 Nov 2009 12:19:37 GMT

Hello Experts ,

i need to output data in output file.

the file formate should look like this :

Art Sold-to party Sales Order Delivery Doc.

R 1064505 1509026 84846578

i used concatenate statement.

CONCATENATE 'ART'

'SOLD-TO PARTY'

'SALES ORDER'

'DELIVERY DOC'

'BILLING DOC'

INTO LV_STRING SEPARATED BY SPACE RESPECTING BLANKS.

CONCATENATE GT_AUART

GT_DATA-KUNAG

GT_DATA-AUBEL

GT_DATA-VGBEL

INTO gt_string SEPARATED BY SPACE.

i am getting error ".", "IN BYTE MODE", "SEPARATED BY ...", or "IN CHARACTER MODE" expected after "LV_STRING".

i used respecting blanks without separated by space also. than also i am geting same error.

Please let me knw any other statement to output data in file in above formate

Thanks in advance ,

best regards,

sai

Re: Output data in file

former_member209217 — Mon, 30 Nov 2009 12:33:11 GMT

RESPECTING BLANKS ADDITION is not there for older versions.Its available in ECC

Regards,

Lakshman

Re: Output data in file

Former Member — Mon, 30 Nov 2009 12:37:10 GMT

So how we can do this requirement.

Thanks and regards,

Zubera

Re: Output data in file

former_member209217 — Mon, 30 Nov 2009 13:01:48 GMT

which version you are using

Re: Output data in file

former_member209217 — Mon, 30 Nov 2009 13:04:26 GMT


CONCATENATE 'ART'
'SOLD-TO PARTY'
'SALES ORDER'
'DELIVERY DOC'
'BILLING DOC'
INTO LV_STRING SEPARATED BY SPACE .
write lv_string.

On execution you will get the below output.I think this is what you are looking for....

Output :ART SOLD-TO PARTY SALES ORDER DELIVERY DOC BILLING DOC

Regards,

Lakshman.

Re: Output data in file

Former Member — Mon, 30 Nov 2009 13:07:37 GMT

we are using ECC 5.0 only...

i used separated by space option but not working. if i use separaetd by space i am not geting proper formate.

Re: Output data in file

Former Member — Mon, 30 Nov 2009 13:11:24 GMT

Thanks for your reply lakshmikanth. if you give mail id will send file formate.....

field is separated by tabs... and exactly below fieldname field value shoudl display.

Regards,

Sai

Re: Output data in file

former_member209217 — Mon, 30 Nov 2009 13:12:00 GMT

In Which format you are getting the output. which format do u want?

Please post the output you are getting

Re: Output data in file

former_member209217 — Mon, 30 Nov 2009 13:16:32 GMT

If you want tab space in between the values use this value


CONCATENATE 'ART'
'SOLD-TO PARTY'
'SALES ORDER'
'DELIVERY DOC'
'BILLING DOC'
INTO LV_STRING SEPARATED BY  CL_ABAP_CHAR_UTILITIES=>HORIZONTAL_TAB . "----------->Tab Space .

Re: Output data in file

Former Member — Mon, 30 Nov 2009 13:19:01 GMT

lakshimkanth thanks for your reply

i am geting this formate

ART SOLD-TO PARTY SALES ORDER DELIVERY DOC

R 0001004306 0000029033 0080042942 0090023253

R 0001006900 0000029049 0080042957 0090023267

but i need the form field seperated by tab and exatcly below frst character header the first character item should display

it would be great if you give me mail id i can send u file formate.

Thanks in advance,

best regards,

sai

Re: Output data in file

Former Member — Mon, 30 Nov 2009 13:21:48 GMT

INTO LV_STRING SEPARATED BY CL_ABAP_CHAR_UTILITIES=>HORIZONTAL_TAB .

if i use this statement also i am geting same error ".", "IN BYTE MODE", "SEPARATED BY ...", or "IN CHARACTER MODE"

expected after "LV_STRING".

thanks

Re: Output data in file

Former Member — Mon, 30 Nov 2009 13:25:01 GMT

Hi sainath,

why don't you use an structure and export this into your external file?

Regards, Dieter

Re: Output data in file

Former Member — Mon, 30 Nov 2009 13:27:14 GMT

Hi,

You can define workarea of a structure.

The length of fields in the structure should be correctly defined.

Move the header texts to each field.

Now workarea contains the texts at specific positions.

If you are downloading some file, you can declare all fields of that itab as char, and insert these header texts as itab's first line.

Regards,

Nisha Vengal.

Re: Output data in file

Former Member — Mon, 30 Nov 2009 13:28:25 GMT

In ECC versions its mandatory to specify the mode and thats exactly what the error is telling you. There wont be any harm if you add character mode or byte mode


CONCATENATE 'ART'
'SOLD-TO PARTY'
'SALES ORDER'
'DELIVERY DOC'
'BILLING DOC'
INTO LV_STRING SEPARATED BY  CL_ABAP_CHAR_UTILITIES=>HORIZONTAL_TAB IN CHARACTER MODE .

Vikranth

Re: Output data in file

Former Member — Mon, 30 Nov 2009 13:33:07 GMT

i got output but not exact output

ART SOLD-TO PARTY SALES ORDER DELIVERY DOC BILLING DOC

R 0001006900 0000029049 0080042957 0090023267

upto her i got correct but after not geting proper

ACTUAL BILLING DATE SOLD-TO PARTY DESC FILIALE SHIP-TO PARTY CUSTOMER

20090326 REIFF-Reifen-+Auto(KUMHO) 0ruse 0001004306 ss

20090605 DIPROPNEU S.A. Jung 0001006900 SSS 000010

after using

this statement

INTO LV_STRING SEPARATED BY

CL_ABAP_CHAR_UTILITIES=>HORIZONTAL_TAB .

Re: Output data in file

Former Member — Mon, 30 Nov 2009 13:37:23 GMT

this is corect formate i needed

Art Sold-to party Sales Order Delivery Doc. Billing Doc. Actual Billing Date Sold-to party Desc.

R 1064505 1509026 84846578 92895891 19.10.2009 Pit Auto Teile GmbH

Filiale Ship-to Party Customer P/O Billing Doc. Item Material Material Desc. Billing Qty Net Price

0127 1064516 Pit A.T.0127 KHWi09-1000010 1816313 KH 165/70 R14 Q04L 7400 ;EC 4000 3063

Re: Output data in file

Former Member — Mon, 30 Nov 2009 13:44:41 GMT

Hi,

did you try defining a structure?

regards, Dieter

Re: Output data in file

Former Member — Thu, 03 Dec 2009 14:48:34 GMT

Thnaks problem solved