topic Re: Problem in creating BDC program for FI TCODEs in Application Development and Automation Discussions

Problem in creating BDC program for FI TCODEs

Former Member — Thu, 02 Apr 2015 10:08:24 GMT

Hi experts,

I am trying to create a BDC program for the finance TCODES: ( FIAPSA_PYMO01, FIAPSA_EXPO ) but I face a problem that I cannot move page down in the control table in the screen even I can't move down in down key. Moreover, I have not found any BAPI function does the functionality of the screen. Can anyone help me.

Is there any way to upload data in batch rather than BDC or BAPI?

Re: Problem in creating BDC program for FI TCODEs

Former Member — Thu, 02 Apr 2015 10:40:32 GMT

Hi Abdel,

First you need find what`s the function code of 'Page down', you can go into related tcode, typing '/H' in command line, then click 'Page down' button, in debugging mode, you will see what function code exactly it is.

Then in your BDC snippet code,

perform bdc_field using 'BDC_OKCODE' '=P+'. "if function code is '=P+'.

regards,

Archer

Re: Problem in creating BDC program for FI TCODEs

Former Member — Thu, 02 Apr 2015 10:48:48 GMT

Thanks Mr. Dengyong for replaying.

actually I tried P+ ,P++,DOWN and /00 but with no luck.

in the recording the down showed as /00 but if I run the recording it does not go down.

Re: Problem in creating BDC program for FI TCODEs

akshatrander1990 — Thu, 02 Apr 2015 10:55:35 GMT

Hi Abder ,

With this code

perform bdc_field using 'BDC_OKCODE' '=P+'. "if function code is '=P+'.

you have to put a condition that after how many lines you want to scroll down.

One more important thing :

Please use CTU_params- Defsize eq 'X'.

What it will do : It will set the same no of displayed lines in the table control for all users.

If you dont use this, the no of lines displayed in the table control may differ user to user .

Regards

Akshat

Re: Problem in creating BDC program for FI TCODEs

Former Member — Thu, 02 Apr 2015 11:00:34 GMT

You need to create two recording.

1st you have to check how may entry fill without down key press. for exp. X entry

In program calculate total entry. (Y)

if Y entry are less or equal to X then go to normal recoding .

else go to down key press recording.

Regards,

Sandeep

Re: Problem in creating BDC program for FI TCODEs

Former Member — Thu, 02 Apr 2015 11:04:15 GMT

Thanks Mr. Aksht for replaying.

actually I did put my code in loop to move to the next page once all lines are filled. but specially for these TCODEs it does not work. I did it for many TCODEs for example MIGO and the pagination is working fine.

these TCODES specially I have no idea why it is behave like this.

thank you for sharing the idea of fixing no of lines for all users.

Re: Problem in creating BDC program for FI TCODEs

Former Member — Thu, 02 Apr 2015 11:07:20 GMT

Dear Mr. Sandeep the problem is in the normal entry you can go down with down-key and the BDC-code will be /00. But when I perform the batch running with BDC-CODE = /00 or P++ OR P+ it does not go down or page down.

Re: Problem in creating BDC program for FI TCODEs

Former Member — Thu, 02 Apr 2015 11:28:54 GMT

you need to put condition.

if normal entry then down-key related code not execute and other case it should be execute.

Re: Problem in creating BDC program for FI TCODEs

Former Member — Thu, 02 Apr 2015 11:37:00 GMT

no you did not get my point. sorry.

I mean when you access the standard transaction FIAPSA_EXPO and start entering data and move down the cursor is moving down and create a new record.

But if I run the program which has the code of recording it does not move down.

Re: Problem in creating BDC program for FI TCODEs

nishantbansal91 — Mon, 06 Apr 2015 06:05:53 GMT

Hi Abdel,

It difficult to understand the exact issue, But while table control please check the cursor position where your cursor is placing. In some transaction that issue might happen please check in your case also.

When you press p++ put the cursor position at the end of the table control Field name.

Suppose you are at line 9. perform the OK CODE '++P' or whatever is it after placing the Field VK01-BUKRS(09).

and Try it.

Thanks and Regards,

Re: Problem in creating BDC program for FI TCODEs

Former Member — Mon, 06 Apr 2015 06:30:27 GMT

Thanks a lot Nishant,

I try to go to the last field in the control table in the screen and it goes down and creating a new record but in recording it gives me the bdc_code /00 and same behavior it does not create a new record in the program.

Re: Problem in creating BDC program for FI TCODEs

nishantbansal91 — Mon, 06 Apr 2015 08:19:36 GMT

Hi,

Abdel can you please do one favour,

Paste a screen shot of your TABLE Control ,

Download the BDCDATA internal table data in debugging mode, attach the code.

Than i think we will give you better solution.

Thanks
Nishant

Re: Problem in creating BDC program for FI TCODEs

Former Member — Mon, 06 Apr 2015 09:30:19 GMT

Please find the attached files:

Re: Problem in creating BDC program for FI TCODEs

Former Member — Mon, 06 Apr 2015 09:34:03 GMT

Here is the excel file need to uploud

Re: Problem in creating BDC program for FI TCODEs

nishantbansal91 — Mon, 06 Apr 2015 09:50:36 GMT

Hi Abdel,

There is an issue with your code.

In BDC table you have to do manually coding.

Your code is working for only 3 items not more than 3 items.

I will give you one example.

One thing i would like to tell you always select DEFAULT Screen Checkbox while doing the BDC Recording.

Suppose your table control contains 3 lines.

1. First items field become FIAPSA _S_ORDER_LT-wrbtr(01).

2. Second item field become FIAPSA _S_ORDER_LT-wrbtr(02).

3. Second item field become FIAPSA _S_ORDER_LT-wrbtr(03)

again if you press p++ then the 4 line that is not shown in the screen by default.

the fourth lines becomes 1st line.

Your code becomes like this

data lv_char type char2

loop at itab.

lv_Count = lv_count + 1.

FIAPSA _S_ORDER_LT-wrbtr(lv_count).

if lv_count = 3.

clear lv_Count.

endif.

endloop

Do one thing send me one test mail on my ID. I will send you some sample code.

Thanks and Regards,

Nishant

Message was edited by: Manish Kumar

Re: Problem in creating BDC program for FI TCODEs

Former Member — Mon, 06 Apr 2015 10:06:32 GMT

Thanks Mr. Nishant,

Maybe this code is the latest change I have made. but for first scenario I have done I was making inside the loop an if statment to check if the counter reach max no record in the screen to reset the counter into second row like this:

DATA COUNTER TYPE N LENGTH 2.

loop at it_data INTO RECORD where BELNR_000 = H_RECORD-BELNR_000.

COUNTER = COUNTER + 1.

perform bdc_field using 'BDC_CURSOR'

'FIAPSA_S_ORDR_LT-WRBTR(03)'.

perform bdc_field using 'BDC_OKCODE'

'/00'.

perform bdc_dynpro using 'SAPMFIAPSA_EXPO' '2001'.

CONCATENATE 'FIAPSA_S_ORDR_LT-SAKNR(' COUNTER ')' INTO TEMP.

perform bdc_field using TEMP record-SAKNR_01_013.

perform bdc_dynpro using 'SAPMFIAPSA_EXPO' '2001'.

perform bdc_field using 'BDC_CURSOR'

'FIAPSA_S_ORDR_LT-WRBTR(03)'.

perform bdc_field using 'BDC_OKCODE'

'/00'.

IF COUNTER = NO_DISPLAYED_RECORD_IN_SCREEN.

perform bdc_dynpro using 'SAPMFIAPSA_EXPO' '2001'.

perform bdc_field using 'BDC_CURSOR'

'FIAPSA_S_ORDR_LT-WRBTR(03)'.

perform bdc_field using 'BDC_OKCODE'

'=P+'.

CLEAR COUNTER.

ENDIF.

endloop.

Please check your email I send an email.

Re: Problem in creating BDC program for FI TCODEs

Former Member — Mon, 06 Apr 2015 10:08:55 GMT

in the prior code I want to mention that I tried for pagination bdc_code different things:

p++

=p+

down

/00

Re: Problem in creating BDC program for FI TCODEs

nishantbansal91 — Mon, 06 Apr 2015 10:44:52 GMT

Hi,

For Pagination do one thing,

Go to actual Transaction, press /H in the command field.

then press Page down option.

then it will go to Debugging mode after that check the value of SY-UCOMM.

There is also some cases where we need to check if press enter that time also it will jump into next line, but good practice as per my personal experience is use Standard one.

Thanks and Regards,

Nishant

Re: Problem in creating BDC program for FI TCODEs

Former Member — Mon, 06 Apr 2015 11:13:35 GMT

the SY-UCOMM = 'DOWN'

but when I change it in the code it behaves the same.

Re: Problem in creating BDC program for FI TCODEs

Former Member — Mon, 06 Apr 2015 13:41:22 GMT

Try an entirely different approach: I don't see these transactions, so I cannot test.

But in many screens, there is something like a "position" button that allows you to bring any item to the top of the screen. If a button like this exists in these transactions, you can use it instead of page down.

Rob