topic Re: GL Upload program through FB01 in Application Development and Automation Discussions

GL Upload program through FB01

Former Member — Thu, 19 Dec 2013 22:50:47 GMT

Hello Experts,

We have a requirement in which we upload the GL posting data from Legacy to SAP. We are not allowed to use LSMW.

So, we wrote a program which uploads the data from Excel and transfers data to BBKPF and BBSEG.

The posting date and document date in BBKPF structure (BBKPF-BLDAT (Char 😎 and BBKPF-BUDAT) takes value from excel as YYYYMMDD and I am just writing this user value to the BBKPF-BLDAT using WRITE ITAB-BLDAT TO BBKPF-BLDAT.

After successful transfer we submit the standard program RFBIBL00 and execute the session through SM35.

Here in FB01, I could see the date to be as YYYYMMDD instead converting to DD/MM/YYYY. So it says Invalid date and cannot process further.

Any help on this issue?

Appreciate for any useful inputs.

Thanks.

Sandy

Re: GL Upload program through FB01

former_member219762 — Thu, 19 Dec 2013 23:06:58 GMT

Hi,

Use WRITE ITAB-BLDAT TO BBKPF-BLDAT DD/MM/YYYY.

or chnage time format in user mater record to DD/MM/YYYY.

Regards,

Sreenivas.

Re: GL Upload program through FB01

Former Member — Thu, 19 Dec 2013 23:14:15 GMT

Hi Sreenivas,

Thanks for responding!

But the field BBKPF-BLDAT is a Char8 field. So I don't think we can convert to DD/MM/YYYY instead can we do as DDMMYYYY?

Thanks

Sandy.

Re: GL Upload program through FB01

former_member219762 — Thu, 19 Dec 2013 23:40:27 GMT

Hi ,

simply use Concatanate ITAB-BLDAT+6(2) ITAB-BLDAT+4(2) ITAB-BLDAT+0(4) into BBKPF-BLDAT

Use fm CONVERT_DATE_FORMAT'.

Refer this link FUNCTION MODULE FOR CONVERTING DATE INTO THE GIVEN FORMAT - Code Gallery - SCN Wiki

Regards,

Sreenivas.

Re: GL Upload program through FB01

atul_mohanty — Fri, 20 Dec 2013 07:47:28 GMT

Hi Sandy -

Use CONCATENATE statement, we are using the same .

Example -

DAta : lv_date TYPE char8.

CONCATENATE lv_date+6(2) lv_date+4(2) lv_date+0(4) INTO lv_date.

BBKPF-BLDAT = lv_date.

Let us know, in case any further help.

Regards,

Atul Mohanty

Re: GL Upload program through FB01

RaymondGiuseppi — Fri, 20 Dec 2013 08:50:01 GMT

WRITE ITAB-BLDAT TO BBKPF-BLDAT.

Will only perform well if the field ITAB-BLDAT is defined as a date field (DATS), also BBKPF-BLDAT is only 8 character long so forget the "" separators.

Regards,

Raymond

Re: GL Upload program through FB01

Former Member — Mon, 23 Dec 2013 02:43:30 GMT

Hi,

Thanks for your inputs.

In FB01, even if we provide as DDMMYYYY, it takes as the valid date. So we need not bother about the seperators.

Regards,

Sandy

Re: GL Upload program through FB01

Former Member — Mon, 23 Dec 2013 02:43:45 GMT

Thanks Raymond.

Regards,

Sandy

Re: GL Upload program through FB01

clinton_jones2 — Sat, 28 Dec 2013 00:37:48 GMT

seems you had to go through a lot of hoops to do this, what was the business reason for deciding against LSMW?