topic Re: Re: T-code FB03 in Application Development and Automation Discussions

Re: T-code FB03

hitesh2 — Tue, 09 Aug 2005 19:47:48 GMT

Hi,

When you execute t-code FB03 i see item text as

" Spcfy in p.adv: Document number 0090554911 " on each line item. How can i modify this text. Is there any user exit that will help me do this task.

Thanks,

Hitesh

Re: Re: T-code FB03

Former Member — Tue, 09 Aug 2005 19:57:18 GMT

If you want to change the text for a document manually, you can just select the document, press change, select a line item and then select the header. It will let you change the header text.

Or do you want to make the same change to all of the transactions?

Rob

Re: Re: T-code FB03

hitesh2 — Tue, 09 Aug 2005 20:37:07 GMT

Rob,

Thanks for your response.

We get payment advice from the customer electronically which we convert it to IDOC file for further processing. This IDOC file we use it for Incoming payment through transaction F-28 selecting this file under payment advice number. After posting this transaction when we display this document following text appears in FB03 for each line of item.

" Spcfy in p.adv: Document number 0090554911 "

I want to change this Item text programmatically.

Thanks,

Hitesh

Re: Re: T-code FB03

Former Member — Tue, 09 Aug 2005 20:55:06 GMT

Hi Hitesh,

Looks like this is a configuration task. Check entries in table T053. If you find this text in there (0090554911 is a runtime value for some variable in that text), then follow the config path IMG~~>Financial Accounting~~>Financial Accounting Global Settings~~>Document~~> Line Item--> Define Texts For Line Items.

Hope this helps,

Srinivas

Re: Re: T-code FB03

Former Member — Tue, 09 Aug 2005 20:55:16 GMT

I'm not sure if this will help, but you can give it a try:

Assuming this is a customer account, go to transaction FBL5N and enter the customer number and other criteria to select the documents you want; press execute and you'll get back a list. Select all or just the ones you want to change. Then:

Environment->Mass change->New values

You'll be presented with a popup where you can enter a new text. Enter the text and press "Execute Changes".

This will change the line item text for all of the items, but it won't be visible until you re-execute the transaction.

Rob

Re: Re: T-code FB03

hitesh2 — Tue, 09 Aug 2005 21:19:16 GMT

Srinivas,

Thanks for your response, You clearly understood my issue and i checked the table T053. The said text is not there

" Spcfy in p.adv: Document number 9999999999 "

I think program is pulling this text from somewhere else.

Let me know if you have any further information.

Thanks,

Hitesh

Re: Re: T-code FB03

andreas_mann3 — Wed, 10 Aug 2005 05:34:42 GMT

Hi,

so check further possibilities:

1) substitution - TA: OBBH

2) field exit - report RSMODPRF

3) user exit - for your idoc process (FIPAYM)

regards Andreas

Re: Re: T-code FB03

Former Member — Wed, 10 Aug 2005 20:12:59 GMT

Can you tell us what is the IDOC and message type for this?

Srinivas

Re: Re: T-code FB03

hitesh2 — Wed, 10 Aug 2005 20:24:21 GMT

Srinivas,

Basic type : PEXR2002 ( Payment/payment advice note .. )

Message type : REMADV

Thanks,

Hitesh

Re: Re: T-code FB03

Former Member — Wed, 10 Aug 2005 20:52:47 GMT

In the include LIEDPF79, there is a user exit call


CALL CUSTOMER-FUNCTION '101'
                    EXPORTING  IDOC_CONTROL_INDEX  = IDOC_CONTRL_INDEX
                               IDOC_DATA_INDEX     = IDOC_DATA_INDEX
                               AVIK_IN             = IDOC_AVIK
                               AVIP_IN             = IDOC_AVIP
                               AVIR_IN             = IDOC_AVIR
                    IMPORTING  I_FIMSG             = USER_MSG
                               AVIK_OUT            = IDOC_AVIK
                               AVIP_OUT            = IDOC_AVIP
                               AVIR_OUT            = IDOC_AVIR
                       TABLES  IDOC_CONTROL        = IDOC_CONTRL
                               IDOC_DATA           = IDOC_DATA
                    EXCEPTIONS OTHERS              = 01.

And then there is another user exit call

CALL CUSTOMER-FUNCTION '102'.

They both change the table IDOC_AVIP which has the item texts. My guess is that you may be using one of the user exits to change the text.

Let me know if that is not the case.

Srinivas

Re: Re: T-code FB03

hitesh2 — Thu, 11 Aug 2005 17:25:03 GMT

Srinivas,

I tried to debug Idoc using WE19 in foreground it calls user exit CALL CUSTOMER-FUNCTION '101' and CALL CUSTOMER-FUNCTION '102' but IDOC_AVIP doesn't contain such text.

Even if i display Payment Advice using t-code: FBE3 and go to Line Item data it doesn't have that text.

But when i execute t-code: F-28 with Payment Advice no. and see the Line item data specified text exists.

Thanks,

Hitesh

Message was edited by: Hitesh

Re: Re: T-code FB03

Former Member — Thu, 11 Aug 2005 20:25:15 GMT

Without debugging, do you see any code in those user exits?

In F-28, where are you entering the Payment Advice no.? After you enter all the fields on the initial screen of F-28(Post Incoming Payments:Header Data), exatly what do you do and when do you see the texts? Do you see them after you save it or before itself?

Also, go to tables AVIK and AVIP and see if you can find the texts there.

One more question, are you seeing this text evertime you run F-28 or is it only happening on some? If it is happenning for some, then is there any pattern in those advises?

Srinivas

Message was edited by: Srinivas Adavi

Re: Re: T-code FB03

hitesh2 — Thu, 11 Aug 2005 21:05:28 GMT

Srinivas,

I don't see any code in the user exit FEDI002

Functiion Module EXIT_SAPLIEDP_101

EXIT_SAPLIEDP_102

FYI : User Exit is included in the custom project ZPYMNT

In F-28, I enter the Payment Advice # in the lower portion of the screen where it is mentioned for payment advice #. After posting the incoming payment and when I display document (FB03) the said TEXT is appearing in the last column of the document. I see this text only when I process the incoming payment thru payment advice and not when I do it otherwise.

There are no texts in the tables AVIK and AVIP.

I am seeing this text only when I process the incoming payment thru payment advice generated by IDOC file.

can I have your email id to forward the screen shots.

Thanks a lot

Hitesh

Re: Re: T-code FB03

Former Member — Thu, 11 Aug 2005 21:15:38 GMT

This message was moderated.

Re: Re: T-code FB03

Former Member — Fri, 12 Aug 2005 18:10:47 GMT

Hi Hitesh,

Looked at the screen shots. Looks like it is pulling the text from either the tables t053, T053S, REGUP or it may be coming from the substitution rules.

Run transaction OBBH and see if you have any Z substitutions there. If there, then double click on it and that should take you to a screen where you will see some steps in the substitution. If you click on each step, you will see what pre-requisite is being checked and what substitution is being made(if the prerequisite is met) on the right side.

Let me know how it goes.

Regards,

Srinivas

You mentioned that you have a Z project activated with those user exits. Is there any code in any of the user exits 101 and 102?

Re: Re: T-code FB03

hitesh2 — Fri, 12 Aug 2005 18:50:53 GMT

Srinivas,

I looked all the entries into tables T053, T053S and REGUP no such entry is found.

I don't find any single entry for substitution when i run t-code OBBH.

There is no code in user exit 101 and 102. I had break point on include when i was debuging in foreground using t-code WE19.

Even if i display the payment advice using t-code: FBE3. I don't see such text on Line item.

Thanks,

Hitesh

Re: Re: T-code FB03

Former Member — Fri, 12 Aug 2005 20:15:51 GMT

I almost ready to give up. Let us try this last thing. Go to SE16 and enter table name STXL. Give 'TX' for RELID, 'BELEG' for TDOBJECT, 'EN' for TDSPRAS and your payment advise number for TDNAME. See if you get any records. If you get, make a note of the TDID value. Now go to SE37 and test the function module READ_TEXT. Enter the values from above for the function module.

Let me know if that leads you to anything.

Srinivas

Re: Re: T-code FB03

Former Member — Fri, 12 Aug 2005 20:30:13 GMT

Did you check if there is anything under the 'Rules' in OBBH transaction?

Also check OB28.

Re: Re: T-code FB03

hitesh2 — Wed, 31 Aug 2005 15:51:14 GMT

Srinivas,

I took help of OSS, and this what they replied.

1) The source of the text is the posting program itself (f-28/fb05)sapmf05a(include mf04afa0). Search for :bseg-sgtxt(15) = 'Angabe im Avis:'(072).the program puts in the customer account line item field SGTXT:'specfy in pmt advice: Check 079787 pmt advice 001234343 (or some-thing like that.)

2) The BSEG-SGTXT is typically filled with some text from the AVIP-SWERT(selection value). This normally provides cash-application clerks with additional reference data they may use in further clearingof 'partially applied' items.

Thanks,

Hitesh.

Re: Re: T-code FB03

Former Member — Wed, 31 Aug 2005 15:55:34 GMT

So does this answer your question or you still need help? Please let me know.

I did check(before you asked OSS) the first part of their reply already but didn't find anything useful there. I will check the second one now and will let you know my findings.

Srinivas