Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Transfer document header text from billing document to FI document

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

Former Member
replied

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

1 View this answer in context
Not what you were looking for? View more on this topic or Ask a question