topic Re: please help. in Application Development and Automation Discussions

please help.

Former Member — Mon, 19 Nov 2007 19:58:17 GMT

friends , please help.

i am supposed to a conversion of FI documents,

where an excel sheet is given which contains the data extracted form 4.7

now the names of the old G/L accounts and comp codes have changed, so first i have to change all the G/L accoutns, cost centers, internalorders to new ones,

then i have to upload all the data in ECC 6.0

before uploading i should do a validation program with the help of selection screen program to make sure, the cost centers etc, in the transaction data to be uploaded has the same cost centers available in ECC 6.

they have suggested me to use RFBIBL00 program.

has anyone done this previously, how to convert this file to be uploaded to be converted to required format.

thank you.

Re: please help.

Former Member — Mon, 19 Nov 2007 20:00:47 GMT

Hi Sanjana,

There are plenty of posts available for GL Upload using RFBIBL00 program. Please use search forum.

Regards,

Satish

Re: please help.

naimesh_patel — Mon, 19 Nov 2007 20:03:46 GMT

Check the program:

RFBIBLT0

This program can create a test data for RFBIBL00.

Regards,

Naimesh Patel

Re: please help.

Former Member — Mon, 19 Nov 2007 21:13:20 GMT

hi satish and naimesh

thank you for the replies,

satish, i tried searching through, but could not find, matching my requirement,

naimesh, as you told , i executed the program, it says executed successfully, but i could not find the file, it will be great if any one gives a format of how it should be.

can any one of you, please walk me through the process, as i never did this, it is little urgent.

thnak you.

Re: please help.

naimesh_patel — Mon, 19 Nov 2007 21:19:14 GMT

The file should be on the application server.

Please note that you have to give the server file name with the full path.

If your server runs on LINUX than /usr/system/.....

Once the RFBIBLT0 has run successfully, you can provide that file to RFBIBL00 to see how it works.

Regards,

Naimesh Patel

Re: please help.

Former Member — Mon, 19 Nov 2007 21:46:51 GMT

hi naimesh,

i had given the file name

C:\trial99.txt

there is no file trial99 in C drive.

plz help

Re: please help.

naimesh_patel — Mon, 19 Nov 2007 21:51:06 GMT

that was the mistake .. you have to create a file on the application server.

Talk with your BASIS guys, they will provide you one directory in which you can create your file.

Use that directory and file name instead of the "C:\trial99.txt"

Regards,

Naimesh Patel

Re: please help.

Former Member — Mon, 19 Nov 2007 22:00:17 GMT

hi naimesh,

thank you for the reply,

should i be asking the basis guys to create a directory in the

application server or UNIX server.

Re: please help.

naimesh_patel — Mon, 19 Nov 2007 22:15:12 GMT

On Application server on which SAP is running.

Regards,

Naimesh Patel

Re: please help.

Former Member — Mon, 19 Nov 2007 22:16:42 GMT

Sanjana,

no need to ask the basis guys....

go to AL11 tcode and check the existing paths.....

some path you will get to the application server corresponding to your development environment like.....

/usr/sap/intf/......... like that u will find the path.... take the path and and give the file name it will download the file in that directory

~~Guduri

Re: please help.

Former Member — Mon, 19 Nov 2007 23:05:12 GMT

thank you friends, i could get the format of the file needed to input , by executing the program RFBIBLT0, the following was the format,

can someone plz tell how to convert my excel file to this format.

0DOCUMENT1 100PSANJANA 00000000 /

1FB01 191107 AB0001191107 / DEM / / Batch-Input-Doc. 00000001/

2BBSEG 01/ // 11600,00 / /

2BBSEG 50/ // 10000,00 / / / A1/

2BBTAX 1600,00 A150/

Re: please help.

Former Member — Mon, 19 Nov 2007 23:11:32 GMT

Sanjana,

First of all check your excel data. Whether you are getting in the same format or not like....

0 indicates header level data

1 indiacates item level data at the beggining of the record.

Otherwise are you getting the seperate files for the different levels of data....

Ask the legacy guys to give the data in that format... that would be adivasable method rather than you convert the data into that format

Re: please help.

naimesh_patel — Mon, 19 Nov 2007 23:16:29 GMT

You have to use this generated file as the raw data for RFBIBL00.

Now how to convert your file to this format

Load your file to IT_FILE

CALL GUI_UPLOAD

If you look at the RFBIBLT0, you will realize that this report will process like that..

OPEN DATASET DS_NAME FOR OUTPUT IN TEXT MODE ENCODING DEFAULT.

Initlaize strctures BGR00, BBKPF, BBSEG with C_NODATA.

Check the form

PERFORM INIT_STRUKTUREN_ERZEUGEN(RFBIBLI0) USING C_NODATA.

Than loop at your internal table which was uploaded by GUI_UPLOAD from EXCEL file.


* To create session:
  PERFORM BGR00_DATEN.

LOOP AT IT_FILE.
  case record-type... " << field to identify header or item
  when header
*    fill relevent data to BBKPF
            PERFORM BBKPF_DATEN_FB01.

  when ITEM
*   fiell relevent data to BBSEG
            PERFORM BBSEG_DATEN_DEBI.
*    fill relevent data to BBTAX
endloop.

CLOSE DATASET DS_NAME.

SUBMIT RFBIBL00 with DS_NAME = DS_NAME
                          WITH CALLMODE = 'B'
AND RETRUN.

Regards,

Naimesh Patel