Add additional fields in VA05 report

Example: Add RAN number in VA05 report

Adding fields in Selection screen: 

Use enhancement spot in program "SD_SALES_DOCUMENT_VIEW".

enhancement-point sd_sales_document_view_ep_int1 spots es_sd_sales_document_view .
*$*$-Start: SD_SALES_DOCUMENT_VIEW_EP_INT1---------------$*$*
ENHANCEMENT 1  ZENH.    "active version
selection-screen begin of block sch1 with frame title text-SCH.
select-options:  skannr for vbap-kannr.
selection-screen end of block sch1.
ENDENHANCEMENT.

Selection parameter into select list

  enhancement-point sd_sales_document_view_ep_int2 spots es_sd_sales_document_view .
*$*$-Start: SD_SALES_DOCUMENT_VIEW_EP_INT2--------------$*$*
ENHANCEMENT 2  ZENH.    "active version
*INSERT LINES OF skannr INTO TABLE gs_selcrit-kannr.
  transfer_select_option 'VBAP' 'KANNR' SKANNR.
ENDENHANCEMENT.

Adding field in the output list. 

Implement BADI: "BADI_SDOC_WRAPPER"

Use method "ADAPT_RESULT_COMP"

INSERT VALUE # ( table = 'VBAP' field = 'KANNR' name = 'VABP_KANNR' text = 'RAN/MANIFEST' ) INTO TABLE ct_result_comp.

Check SAP note "1780163"

Comments

  1. AnonymousAugust 9, 2022 at 5:51 AM

    Hi,
    Thank you so much for your documantation. But What will we do if we want to 'SUM' field while select data?

    ReplyDelete
  2. AnonymousApril 9, 2023 at 10:23 AM

    after adding the field to ct result comp, only header is visible. fields aren't getting populated

    ReplyDelete

Post a Comment

Popular posts from this blog

Totals table for ACDOCA in S/4 HANA - ACDOCT

In old classical legder SAP provided GLT0 table for totals. In new GL SAP provided FAGLFLEXT table for totals. In S/4 HANA SAP has provided ACDOCT view for totals. (ACDOCT_BCK is a table). ACDOCT is a CDS view not a table. This view will be useful to find out totals per period and with some standard fields. This can be used in Report writer/painter also. But in S/4 Hana SAP not suggesting to use Report Writer/Painter tool. Most of the times SAP customers enhance Accounting document with custom fields. So custom fields can be added into ACDOCA table but it will not added to ACDOCT (Since it is view). what if customer needs total values including custom fields what to do then ? For this purpose either extend ACDOCT view or write sum logic using ACDOCA table. Writing logic with ACDOCA in each program means need to repeat same code many programs and also it is not code-pushdown approach. So better solution is either extend ACDOCT CDS view or create custom CDS view like ACDOCT.
Read more

FAGLL03 / FBL1N / FBL3N / FBL5N not showing custom fields

For T-code: FBL1N/FBL3N/FBL5N Execute the report RFPOSXEXTEND with T-code: SE38 in your system. Table T021S and structure RFPOSXEXT are able to synchronize. For T-code: FAGLL03Call T-code: SE37, enter the function module ITEM_STRUC_EXTENSION and execute it with the following parameters: BASIC_STRUCNAME FAGLPOSY EXT_STRUCNAME FAGLPOSYEXT EXT_FIELDS_TABNAME T021S I_LSTCL D X_TRANSPORT ' ' After you have executed the function module, the related structure FAGLPOSYEXT should be regenerated correctly. In addition, start the BALVBUFDEL report when you enhance the special fields
Read more