topic Re: Transfer document header text from billing document to FI document in Application Development and Automation Discussions

Transfer document header text from billing document to FI document

Former Member — Thu, 30 Jul 2009 06:24:33 GMT

Dear all,

Where do I specify that the document header text out of the billing document should be transferred to the corresponding FI document?

Currently, the FI document header text (BKPF-BKTXT) remeans blank after transfer from billing document. We need this field to be filled in, but I haven't found how to have this filled in.

In copy control from sales doc to billing doc, there is the possibility to transfer the Reference number & Assignment, but nothing about document header texts.

Some say that it would only be possible via coding, but anybody has any idea if it might be possible via standard SAP?

Many thanks!

Best regards

Re: Transfer document header text from billing document to FI document

Former Member — Tue, 04 Aug 2009 08:30:03 GMT

Hi,

We also had a bit same requirement, which is to copy the billing header text to FI item text (BSEG-SGTXT). The solution we took is to use FI Substitution (t-code GGB1), so that every time a FI document created from SD... the substitution reads the billing header text and put it in the FI item text. I think the same method could be used for FI header text (BKPF-BKTXT). Below is the solution for your reference.

Prerequisite:

Document Type = 'RV' AND Reference <> '' AND

( Transaction code = 'VF01' OR Transaction code = 'VF02' OR

Transaction code = 'VF03' )

Substitution:

Using exit which coding is as below.

&----

*& Form u900

&----

Copy Billing Header Text to SGTXT

----

-->P_SGTXT FI Item Text

----

FORM u900 USING p_sgtxt TYPE bseg-sgtxt.

DATA: lv_name TYPE thead-tdname,

lt_line TYPE STANDARD TABLE OF tline,

lw_line TYPE tline.

lv_name = bkpf-xblnr.

CALL FUNCTION 'READ_TEXT'

EXPORTING

id = 'Z001'

language = sy-langu

name = lv_name

object = 'VBBK'

TABLES

lines = lt_line[]

EXCEPTIONS

id = 1

language = 2

name = 3

not_found = 4

object = 5

reference_check = 6

wrong_access_to_archive = 7

OTHERS = 8.

IF sy-subrc EQ 0.

READ TABLE lt_line

INTO lw_line

INDEX 1.

In Billing Header Text, the sign '&' (ampersand) is automatically
added some characters so it becomes '<(>&<)>'.
The logic below is to fix that issue.

REPLACE ALL OCCURRENCES OF '<(>' IN lw_line-tdline WITH space.

REPLACE ALL OCCURRENCES OF '<)>' IN lw_line-tdline WITH space.

p_sgtxt = lw_line-tdline.

ENDIF.

ENDFORM.

Regards,

Teddy Kurniawan

Re: Transfer document header text from billing document to FI document

Former Member — Tue, 04 Aug 2009 08:43:47 GMT

U can try to use a substituion just as Teddy suggests or u can try to implement the exit EXIT_SAPLV60B_008, in this case u should append the field BKTXT in structure ACCIT

Max

Re: Transfer document header text from billing document to FI document

former_member404244 — Tue, 04 Aug 2009 08:54:43 GMT

Hi,

Use the BTE event 1120 ....Goto FIBF tcode and in the menu Environmnet ->Process->execute and u will find BTE 001120

IN SE37 u2013 Function Builder. This is the function module (SAMPLE_PROCESS_00001120) you will need to copy into a "Z" or u201CYu201D name function module for your coding

In Function Builder (transaction SE37), enter the new "Z" or u201CYu201D function module. Click on the Change button.

enter the code and then Save and activate the function module

Create a product in BF24 specify as Z...

Now assign the function module u201CZ_SAMPLE_PROCESS_00001120u201D TO product in BF44 TCODE ..Save it..

else

use the FM exit EXIT_SAPLV60B_008, there is no BKTXT field but u can appned it to structure accit...and try

Regards,

Nagaraj

Re: Transfer document header text from billing document to FI document

Former Member — Wed, 09 Sep 2009 07:17:14 GMT

hi teddy,

Can you guide me on ur given suggestion.

1 , In which user exit should i implement this coding and also tell after which sentacnes should i do this.

My problem is that I want to Transfer billing document header text to FI Accouting document.

Thanks & Regards,

Kaushal Shah

Re: Transfer document header text from billing document to FI document

Former Member — Wed, 09 Sep 2009 09:18:57 GMT

Dear Kaushal,

User exit which could be used: LXVVFU01 in SAPLV60B (SD-FI interface)

Update XACCHD-BKTXT

Best regards!

Re: Transfer document header text from billing document to FI document

Former Member — Fri, 29 Jul 2011 05:43:45 GMT

Hi Teddy,

Can you please explain the complete step to implement the same basiscally i m getting the same requirement. please help

Regards

vivek

Re: Transfer document header text from billing document to FI document

Former Member — Tue, 10 May 2016 17:53:33 GMT

This message was moderated.