Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Issue in BDC using table control for fb60

Former Member
0 Likes
1,298

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

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
1,083

Hi,

Use 01 in single quotes like below

ACGL_ITEM-WERKS( '01').

It might help you.

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

7 REPLIES 7
Read only

Former Member
0 Likes
1,084

Hi,

Use 01 in single quotes like below

ACGL_ITEM-WERKS( '01').

It might help you.

Read only

Former Member
0 Likes
1,083

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.

Read only

Former Member
0 Likes
1,083

Hi,

Can you please elaborate your error and code...

Thanks,

Arun.

Read only

Former Member
0 Likes
1,083

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,

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

Read only

Former Member
0 Likes
1,083

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.

Read only

0 Likes
1,083

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

Read only

0 Likes
1,083

Hi all,

Thank u for the suggestions. Solved by self.

Thanks & Regards,

Neela