07-30-2009 7:24 AM
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
08-04-2009 9:30 AM
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
08-04-2009 9:30 AM
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
08-04-2009 9:43 AM
Hi
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
09-09-2009 8:17 AM
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
09-09-2009 10:18 AM
Dear Kaushal,
User exit which could be used: LXVVFU01 in SAPLV60B (SD-FI interface)
Update XACCHD-BKTXT
Best regards!
07-29-2011 6:43 AM
Hi Teddy,
Can you please explain the complete step to implement the same basiscally i m getting the same requirement. please help
Regards
vivek
05-10-2016 6:53 PM
08-04-2009 9:54 AM
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