Skip to main content

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.



Comments

  1. I’m not that much of an internet reader to be honest but your blogs really nice, keep it up! I’ll go ahead and bookmark your website to come back down the road sap fico certification in hyderabad

    ReplyDelete
  2. Helpful Information,

    Cargodash a powerful Logistics ERP of the transportation industry. ERP software helps the logistics and warehousing industry in keeping track of every commodity in the industry. Visit us - https://www.cargodash.in/

    ReplyDelete

Post a Comment

Popular posts from this blog

M7021 : Deficit of stock relevant error message during Material Document Cancellation

Issue : When posting a Cancellation for a Material Document in transaction MIGO, you see error 'M7021 Deficit of not stock relevant' although the Purchase Order is setup with an Account assignment. Material / Batch is not managed on Stock Level even though material is valuated. Resolution : The issue is due to program bug and require to implement note - 2502183 - Slog: correction for quantity check. This note is applicable for S/4 HANA 1610 (S4CORE 101) and 1709 (S4CORE 102).

Add Custom fields to sales order screen in Additional Tab B - Header

SAP has provided Additional data Tab A and Tab B for the addition of custom fields to the Standard sales order screen. Screens 8309, 8310 are used for header level and 8459,8460 for item level. Prior to this, we are required to append the custom fields of the Sales order sub screen in VBAK or VBAP. Pass Custom field values in PAI of screen 8309 within Chain statement CHAIN. FIELD: VBAK-<Custom Field 1>         VBAK-<Custom Field 2>         VBAK-<Custom Field 3> ENDCHAIN. Thank you.

Determinations in SAP SD

Plant Determination in Sales Order 1st Preference: System fetches Delivering plant from Customer Material Info Record if Plant is not found at this level then system will look into 2nd Preference:   Delivering plant from Customer Master data if Plant is not found at this level then system will look into 3rd Preference : the Delivering plant for Material Master data If business user overwrites Plant at sales document level then this will be given highest preference. Shipping Point Determination Delivering Plant (Based on above conditions) + Shipping Conditions ( Sales Document Type or  Customer Master Data) + Loading Group ( Material Master ) Storage Location Determination Plant + Shipping Point + Storage Conditions ( Material Master )  ( MALA) Plant + Shipping Point + Situation  ( RETA) Route Determination Departure Zone or Country of the Delivering Plant + Destination Zone or Country of the Ship to Party + Shipping Condition from the Customer Master + Transport