SAP Note 25026 - VF04: Selection by payer

Symptom:

In the "Maintain Billing Due List" program (VF04), it is not currently possible to select by payer.

Other terms

SAPMV60S, SE11, SE51

Reason and Prerequisites

Up to now, the required functions have not been provided by SAP.
The modifications can be used as of Release 3.0.

Take the following restrictions into account for the following modification proposals:

• A selection by payer works with documents but not document items.

• If several sales orders with different payers are combined in one delivery, the delivery header contains the payer of the first sales order as payer. A billing index is not created for the different payers of the combined sales orders.
  

Solution
Only a modification solves this problem. Contact
Consulting for this purpose. See also the attached Note 170183.

The source code corrections described below provide a possible solution.

1.) Enhance structure VBCO7 <-- Only in releases lower than 4.0*
2.) Enhance SAPMV60S: screen 2100 <-- Only in releases lower than 4.0*
3.) Enhance SAPLV05H: LV05HTOP <-- Only in releases lower than 4.0*
4.) Enhance SAPLV05H: LV05HFIN <-- Only in releases lower than 4.0*
5.) Enhance SAPLV05H: LV05HFDL <-- Only in releases lower than 4.0*
6.) Enhance SAPLV05I: LV05IEXIT
7.) Enhance the partner determination procedures for deliveries in Customizing
8.) Rebuild the billing index

1.) Enhance structure VBCO7 (transaction SE11)
MANDT MANDT CLNT 3 T000
: : : : :
ALLEI ALLEI CHAR 1
SORTKRI SORTKRI CHAR 20 <-- new

2.) :Enhance screen SAPMV60S:2100 (transaction SE51, element list)
:
VBCO7-LLAND 8 2 20 3
VBCO7-LLAND 8 23 3 CHAR X
T005T-LANDX 8 43 15 CHAR X
VBCO7-SORTKRI 9 2 20 0 X <-- new
VBCO7-SORTKRI 9 23 10 CHAR X <-- new

Here, the frame is to be increased downwards by one line.
You should change the description "Sort criterion" of the field VBCO7-SORTKRI to "Payer".

3.) Enhance SAPLV05H: LV05HTOP
:
DATA: FKART_HIGH LIKE VKDFS-FKART.
DATA: LLAND_HIGH LIKE VKDFS-LLAND.
DATA: SORTKRI_HIGH LIKE VKDFS-SORTKRI. <-- new
DATA: VBTYP_HIGH LIKE VKDFS-VBTYP.
:

4.) Enhance SAPLV05H: LV05HFIN
:
*---------------------------------------------------------------------*
* FORM VKDFS_INIT *
*---------------------------------------------------------------------*
* ........ *
*---------------------------------------------------------------------*
FORM VKDFS_INIT.
:
IF VBCO7-KUNNR CO '0'.
KUNNR_HIGH = CHAR_HIGH(10).
ELSE.
KUNNR_HIGH = VBCO7-KUNNR.
ENDIF.

IF VBCO7-SORTKRI CO '0'. <-- new
SORTKRI_HIGH = CHAR_HIGH(20). <-- new
ELSE. <-- new
SORTKRI_HIGH = VBCO7-SORTKRI. <-- new
ENDIF. <-- new
:

5.) Enhance SAPLV05H: LV05HFDL

*---------------------------------------------------------------------*
* FORM READ_VKDFS_VKDFI_VF_01 *
*---------------------------------------------------------------------*
* Database access billing trigger *
*---------------------------------------------------------------------*
FORM READ_VKDFS_VKDFI_VF_01.
:
SELECT *
INTO VKDFS
FROM VKDFS
WHERE ( FKTYP IN (VBCO7-ALLEF,VBCO7-ALLEL,VBCO7-ALLEA,
VBCO7-ALLEI,VBCO7-ALLEB) )
:
AND (LLAND BETWEEN VBCO7-LLAND AND LLAND_HIGH)
AND (VBELN BETWEEN VBCO7-VBELN AND VBCO7-VBELN_BIS)
AND (SORTKRI BETWEEN VBCO7-SORTKRI AND SORTKRI_HIGH) <-- new
AND (VBTYP BETWEEN VBCO7-VBTYP AND VBTYP_HIGH).
PERFORM MOVE_VKDFS_TO_LVKDFI.
APPEND LVKDFI.
ENDSELECT.
ENDFORM.

6.) Enhance SAPLV05I: LV05IEXIT
Implement the attached corrections.

7.) Enhance the partner determination procedures for deliveries in Customizing
To ensure that delivery-related documents can also be selected when selecting the billing due list according to payer, you must add the partner PY to the corresponding partner role in Customizing for the delivery type to be used. This partner must be flagged as a partner that cannot be changed.

8.) Rebuild the billing index.
To rebuild the billing index for existing documents, you must start the program RVV05IVB.