topic Re: Issue in BDC using table control for fb60 in Application Development and Automation Discussions

Issue in BDC using table control for fb60

Former Member — Fri, 13 Aug 2010 09:58:09 GMT

Hi all,

I am trying to upload expenses thru TCode FB60. Since several line items need to be uploaded as a single document we r using Table control . The line items are not uploaded. I am getting a message ACGL_ITEM-WERKS(01) does not occur in screen SAPMF05A 1100.

Can anyone guide me in this issue pls.

Thanks & Regards,

Neela

Re: Issue in BDC using table control for fb60

Former Member — Fri, 13 Aug 2010 10:02:54 GMT

Hi,

Use 01 in single quotes like below

ACGL_ITEM-WERKS( '01').

It might help you.

Re: Issue in BDC using table control for fb60

Former Member — Fri, 13 Aug 2010 10:13:10 GMT

Hi Neela,

Please confirm using the TCODE: FB60 that for the company code you are getting the error whether the column WERKS (PLANT) is visible or not.

Regards,

Selva K.

Re: Issue in BDC using table control for fb60

Former Member — Fri, 13 Aug 2010 10:14:46 GMT

Hi,

Can you please elaborate your error and code...

Thanks,

Arun.

Re: Issue in BDC using table control for fb60

Former Member — Fri, 13 Aug 2010 11:05:59 GMT

Hi all,

Can anyone guide me in this issue pls.

Thanks & Regards,

Hi Neela,

I noticed that in transaction FB60 to enter the value to the plant column, we have to navigate using scroll bar. To fix this issue, In the program execute with the parameters chosen during recording.

DATA : opt TYPE ctu_params.

opt-dismode = 'E'.

opt-defsize = 'X'.

CALL TRANSACTION 'FB60' USING bdcdata OPTIONS FROM opt.

Hope it helps.

Cheers

Sujay

Re: Issue in BDC using table control for fb60

Former Member — Fri, 13 Aug 2010 11:47:54 GMT

Hi Neela,

It would be better to upload using BDC for FB01 instead of FB60 for expenses. BDC's pose to have problems when we have table control.

Regards,

Aparna Alashe.

Re: Issue in BDC using table control for fb60

RaymondGiuseppi — Fri, 13 Aug 2010 12:01:42 GMT

As FB60 is (at least partially) an enjoy transaction, there are problems with batch input, try to use a old-school transaction like FB01 (or report/FM that generates the Batch Input for ths transaction)

(ref: [Note 310485 - Enjoy transactions in FI and previous posting transactions|https://service.sap.com/sap/support/notes/310485])

Regards,

Raymond

Re: Issue in BDC using table control for fb60

Former Member — Sat, 14 Aug 2010 07:18:30 GMT

Hi all,

Thank u for the suggestions. Solved by self.

Thanks & Regards,

Neela