There are standard BADI and configurations that enable us to add the fields in AR tables in the Partner level of the Collections work list but. There is no standard way to add the fields that are not there in the AR and hence this blog.

In our example we will be adding the Customer PO number that is there in the Sales order of the invoice.

Create Append structure for the Structure ‘FDM_COLL_INVOICE’. This structure has the list of fields for the invoice level work list.

    1. Create a append structure with the list of fields that you need to be added in the work list of the invoice level.

Here we have created a append structure ZZINVOICE and added 3 fields.

/wp-content/uploads/2014/02/append_391818.jpg

Enhancement created in the FM ‘FDM_COLL_INVOICES_READ’.

We don’t have any other option here to populate the value to the new field but only to create a enhancement in the FM.

In this FM the table’ t_invoices[]’ already has the newly added fields. Create the enhancement point and the end of the FM as in below screen shot and write logic to populate the new fields with the values.

/wp-content/uploads/2014/02/enhancement_391819.jpg

DATA: BEGIN OF vbfa_tab OCCURS 0,
vbelv
TYPE vbfavbelv,
posnv
TYPE vbfaposnv,
vbeln
TYPE vbfavbeln,
posnn
TYPE vbfaposnn,
vbtyp_n
TYPE vbfavbtyp_n,
vbtyp_v
TYPE vbfavbtyp_v,
“””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””$”$\SE:(4) Function Module FDM_COLL_INVOICES_READ, End, Enhancement ZFSCM_FILL_PONUMB, Struct. VBFA_TAB, End                                                 S
END OF vbfa_tab.

DATA: BEGIN OF vbkd_tab OCCURS 0,
vbeln
TYPE vbkdvbeln,
posnr
TYPE vbkdposnr,
bstkd
TYPE vbkdbstkd,
“””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””$”$\SE:(5) Function Module FDM_COLL_INVOICES_READ, End, Enhancement ZFSCM_FILL_PONUMB, Struct. VBKD_TAB, End                                                 S
END OF vbkd_tab.
data: ld_tabix type sytabix.

if not t_invoices[] is initial.
SELECT vbelv posnv vbeln posnn vbtyp_n vbtyp_v FROM vbfa
INTO TABLE vbfa_tab FOR ALL ENTRIES IN t_invoices
WHERE vbeln = t_invoicesBILLING_DOC
AND vbtyp_n = ‘M’.
IF NOT vbfa_tab[] IS INITIAL.

SELECT vbeln posnr bstkd FROM vbkd INTO TABLE vbkd_tab
FOR ALL ENTRIES IN vbfa_tab WHERE
vbeln
= vbfa_tabvbelv.

endif.
endif.
loop at t_invoices into ls_invoice.
ld_tabix
= sytabix.
read table vbfa_tab with key vbeln = ls_invoicebilling_doc.
if sysubrc = 0.
read table vbkd_tab with key vbeln = vbfa_tabvbelv.
if sysubrc = 0.
ls_invoice
PONUMB = vbkd_tabbstkd.
modify t_invoices from ls_invoice index ld_tabix transporting PONUMB.
endif.
endif.
endloop.

Assuming that you have done all your configurations and then send the data from AR to collections management, you can test as below.

Tcode – UDM_SUPERVISOR

Enter the Details and execute.

/wp-content/uploads/2014/02/udm_391826.jpg

Adding the fields here in the Business partner level work list is simple as per the available documentations.

BP level.jpg

Now double click on the partner to see the invoice level details. Here you can see the customer PO number that we have had in the Sales order.

Invoice level.jpg

Similarly you can build your logic for any field that you need.

To report this post you need to login first.

6 Comments

You must be Logged on to comment or reply to a post.

    1. Kyung-Hun An

      Good posting..

      One addition…

      FM  FDM_COLL_INVOICES_READ_CLOSED should be enhanced with same way if you want to see those fields while checking ‘Cleared Invoices’. 🙂

      (0) 
    2. Kranthi Manchu

      Hi Vijay

      Upon further research, I found that we could also use SAP delivered BADIs for this purpose which will avoid enhancing the standard function module. Do you know if it is possible? In some SCN forum I found that one consultant was able to get the new fields to show in the UDM_COLL_ITEM table but they were not getting displayed in the Process receivables screen.

      Can you please let me know if you have any additional information on this?

      (0) 
      1. Kyung-Hun An

        Hi Kranthi.

        UDM_COLL_ITEM table is used to generate worklist items but AR list of process receivables is real-time transaction and you have to do this to see additional fields

        (0) 

Leave a Reply