Regarding upload of a G/L account posting header data

[Former Member]

Hi all,

Please tell me how to upload of a G/L account posting header data.

Please tell the procedure.

Please specify the bapi if it is there.

thanks & regards

venkatr

[Former Member]

I Would rather recommend SCAT(Tcode is SCAT only) its more or less like a BDC but very easy to use.

Assign points if useful

Archit

[Former Member]

Very Good suggestion by Archit. SCAT is a great tool to use. Which version are you working on. If it is ECC 6.0, then SAP does not support SCAT. There u will have to use ECATT (T code: SECATT)

Regards,

Ajay

[Former Member]

HI

I recommend using LSMW.

Step 1

Give create Project/Subproject/Object.

Eexcute

Select Object attributes radio button

execute

Step 2

in object type and import method

Select object "0100"

Method as "0000"

program will be defaulted as 'RFBILB00"

and program type "D" is greyed and will be displayed.

Save.

Go back.

Step 3

Create source structures

Here you will be creating a Header structure by name "XXXXXX" litem and under "XXXXXX" you create Linitem structure, "YYYYYY".

Save

Go back

Step 4

Maintain Source feilds.

You are mainataing the Header Feilds that are applicable under header "XXXXX" (yopu need to have one of the feild as XBLNR) and line item feilds under "YYYYYY" by giving the name, feild type, length and description. ALso create another feild by name refernce "XBLNR" in line item.

Refernce XBLNR as the reference for lineitem reference. Like Lineitem-Xblnr=Header.XBLNR

Save

Go back.

Step 5.

Maintain Feild mapping and conversion rules.

Map the feilds here in this step by selecting "Auto feild mapping".

Now Create an exccel file with sheet1 as header and put all the feilds here.

Create sheet 2 as Line items. Here if you have one header with say 100 line items you are refrring all the 100 line items XBLNR feild to one XBLNR of Header.

Fill up th exccel sheet.

Save header as header.txt Save line item sheet as Line items.txt

Assign files and execute Read/convert and execute batch input.

Hope you understood.

Reward points if useful.

sarma

[Former Member]

Dear Venkat,

You will have to sit with ABABer to write the BDC. where in during recoring mark the fileds that u want to upload. These fileds would be mapped by ABAPer in BDC. Prepare a xl format to feed in the data. This file in txt format have to be uploaded thru BDC.

Let me know if u have any more doubts

Regards,

Ajay

[Former Member]

Hi,

can you tell me any bapi is there?

vvvv