Append new field to the billing document report VF05N

At times, business is raise request to add custom fields in the billing documents report (VF05N). This document will provide you an easy to accomplish this request.

In this document, We have considered an example where business requires Customer name to be displayed as standard SAP provides only Customer Code.

Below are the process steps to be followed to accomplish this request.

Step 1 : 

Report layout is displayed with the number of fields containing in the structure - ERPSLS_BILLDOC.

So in this case, We have added Customer name in the mentioned structure.

Step 2 : To populate values in the newly added field in the structure, We have used implicit enhancement as per the below.

Goto Report of VF05N - ERPSLS_BILLDOC_VIEW and then go to include - ERPSLS_BILLDOC_VIEW_DATA_SEF01

Post processing of call function - ERPSLS_BILLDOC_VIEW  Write the below code which is used to populate customer name

IF LRT_DOC[] IS NOT INITIAL.

select KUNNR,name1 from kna1 into table @DATA(LRT_DOC_TEMP) FOR ALL ENTRIES IN @lrt_doc where kunnr = @lrt_doc-KUNRG.

SORT LRT_DOC_TEMP BY KUNNR.

LOOP AT LRT_DOC INTO DATA(WA_LRT_DOC).

READ TABLE LRT_DOC_TEMP INTO DATA(WA_LRT_DOC_TEMP) WITH KEY KUNNR = WA_LRT_DOC-KUNRG.

  IF SY-SUBRC = 0.

   WA_LRT_DOC-CUSTOMERNAME = WA_LRT_DOC_TEMP-NAME1.

    ENDIF.

MODIFY LRT_DOC FROM WA_LRT_DOC TRANSPORTING CUSTOMERNAME .

ENDLOOP.

ENDIF.