Additional Fields in Selection Screen of VF04 - Billing Due List

[shinjiin]

Hi,

Does anyone know how I can add additional fields into the selection screen of VF04 ?

My client wants ship-to party to be a search criteria as well

Can this be done through this IMG Path

SPRO [IMG] -> Sales and Distribution -> Billing -> Lists -> Define Selection Criteria

?

If yes, how?

Thanks.

[claudia_neudeck]

Hello,

Only the fields available in VKDFS are avaialble for selection screen

and output.

The selection criteria fields for VF04 are hard-coded.

This cannot be done, the fields in the billing due list index are the

the fields in the billing due list (VKDFS) -> these are the only ones

that can be read and available to be added to the billing due list.

The nature of your request indicates that is is rather a consulting

issue.

Nevertheless :

A solution for this requirement can look like this (example with

sales office and sales group for RV60SBAT):

add with an append the new field(s) on table VKDFS

(take care about the customer name space ZZ*)

fill the fields ZZVKBUR and ZZVKGRP with userexit LV05IF0V

• for Orders

FORM USEREXIT_VKDFS_SORTKRI_SALES.

VKDFS-ZZVKBUR = LVBAK-VKBUR.

VKDFS-ZZVKGRP = LVBAK-VKGRP.

ENDFORM.

• for Deliveries

FORM USEREXIT_VKDFS_SORTKRI_DEL.

VKDFS-ZZVKBUR = LLIKP-VKBUR.

VKDFS-ZZVKGRP = LLIKP-VKGRP.

ENDFORM.

copy the report RV60SBAT in the customer name space and add

the new fields as selection criteria

• get all customer numbers wich orders to be invoiced

SELECT * FROM VKDFS WHERE FKTYP IN X_FKTYP

AND VKORG = VKOR1

AND FKDAT BETWEEN FKDAT AND FKDAB

AND KUNNR IN X_KUNNR

AND FKART IN X_FKART

AND LLAND IN X_LLAND

AND VBELN IN X_VBELN

AND SORTKRI IN X_SORTK

> ins and zzvkbur in vkbur

> ins and zzvkgrp in vkgrp .

I hope this information helps so far.

*PLEASE CONSIDER: THIS IS A MODIFICATION AND WE DO NOT RECOMMEND THIS MODIFICATION*

regards

Claudia

[shinjiin]

-nil-

[shinjiin]

Thanks for the clarification, Claudia

Thanks, Ravi, for helping to answer the question.

[Former Member]

Hi,

We are currently having issues by having too many commercial organizations in our system.

Thus we generate an incredible number of variants for RV60SBAT, which will make really difficult to organize in our scheduling program.

Does anybody ever had this issue ?

We are thinking of creating a program that would be executed by our scheduling program and would generate all the variant.

Any idea ?

Many thanks in advance

[Former Member]

Hello Claudia

How could I add a multiple selection for sales organisation (VKORG) in VF04 transaction?

The fied is hardcoded in the transaction program and looking for SU3 default parameter which is irrelevant in my case - we have a person who works for two sales organisations, but has to create invoices simultaniously for both with the same selection variant.

I tried EXIT_SAPLV60P_008 to sort to my own

requirements in VF04 (include ZXV6PU08) but the field VKORG already exists in the select, hence could not be appended in any other structure , i.e. for VKDFS-SORTKRI

Any ideas are welcome with thanks in advance.

[amit_manchanda2]

Hi Claudia,

I have a similar kind of requirement from my user. He wants to use the sales order number as selection criteria instead of delivery number which is present by default in VF04. Although I can give him the option of using the filtering the records using sales order number within the output but that field is not working because no value is being passed to that field by default.

So, I have two question, Is there any user exit available where we can add additional field "sales order number" in the selection criteria for VF04?

Thanks in Advance

Amit

[former_member184555]

Hi

This is the procedure to add partner function to VF05 (List of Billing documents)

VF04 is Billing Due List and is related to Payer only. You cannot create billing document for a SH.

Thanks,

Ravi

[shinjiin]

Hi Ravi,

I do not want to create a billing document for the Ship-To Party.

I just want to be able to search for the billing documents by Ship-To Party. I've tried what you said earlier, but the field doesn't seem to appear in the selection screen of VF04.

Thanks.

[former_member184555]

Hi

Please follow the following path..

IMG - Sales and Dist - Sales - Lists - Set Updating of Partner Index - Execute

Goto New enteries - and give Transaction Group as 7 and Partner Function SH and save. Now check VF04.

Tanks,

Ravi

[shinjiin]

Hi Ravi,

I did as you said but there's no difference to my screen in VF04.

Is there any additional configuration that I should be paying attention to?

Please advise.

Thanks in advance.