Getting the validity from and validity to in Customer master

[Former Member]

Hi Experts,

I have a requirement in my company, to get validity from and validity to field in customer master?

[Former Member · Accepted solution]

Hi Rakesh

what is the business requirement? what happens if validity expire? What happens to open Invoices and Open Deliveries if Validity expires?

Can you please throw some light on it ?

Regards

[shashi_thakur]

Hi Rakesh,

What Jignesh mentions is a good option. You can use MASS transaction to create a BDC recording and use it to setup all the Blocks like Order Block, Billing Block, etc in the customers and then add it in a custom Report where it can be executed for the selected set of customers based on the criteria.

Alternatively you can set a Delivery Block for such Customers so that the Deliveries can be created only after removal of the Block. A process to release the Delivery blocks can be added and when they have passed the threshold after 6 months you can remove those blocks permanently from the Customer Master.

Regards,

Shashi

[Former Member]

Dear Rakesh,

You can maintain the validity period while creating the customer in XD01 under 'Sales Area Data' Sales tab but you can't change the same in XD02, check out below mentioned snapshot. In addition to this, you can create customer hierarchy and maintain their levels in VDH1N if its suitable for you based on your requirement and you will get the same maintained data for customer hierarchy in KNVH table. Hope it helps, revert in case you need more assistance. Rgds.

http://scn.sap.com/message/6321125

[siva_vasireddy2]

Hope this is Applicable only when customer Hierarchy is activated

[eduardo_hinojosa]

Hi

Set these fields as customer fields and add them to the standard transaction with badi  CUSTOMER_ADD_DATA (see SAP Note 577502 - Enhancements without modification in customer master record). After, with userexits (see  SAP Note 178328 - Problems due to incorrect user exits in SD) check if the customer could make an order.

I hope this helps you

Regards

Eduardo

[Former Member]

Hi Verma

For Customer who are starting business with the company.Company going to check these customers for 6 months.How they are doing the Transaction and credit balances with the company.After 6 months company will check,if they are doing well then make permanent dealers for the company. If not they will cancel the dealership. For this reason they want to maintain valid from and valid to fields in customer master.

Thanks

Rakesh

[Varun_GTS]

This you can do with blocking the customer for sales.

Use Tcode VD05 and you can block customer at different level (order, delivery, billing, sales support)

Then y u need validity for customer master.

[Lakshmipathi]

After 6 months company will check,if they are doing well then make permanent dealers for the company

Make use of the Account Group "CPDA" or "CPD" for this but here also, you dont have validity dates.  For the Business requirement what you had indicated, these are the standard Account Groups SAP have provided.

G. Lakshmipathi

[neeraj_lal]

Looks like you need to design process here using standard SAP with some z development.

One possibility is use of condtion update functionality with target amount and period date range. Once customer reaches target amount update flag activates. You may trigger output in case update flag activate to the business.

To track You can also create report based with selection screen having customer range for which condtion update record maintained, period range, credit situation in FD32,and cumulative value from update condtion.

Regards

[jignesh_mehta3]

Hello Rakesh,

From & To Dates are not available in SAP Standard.

As an alternative, you can get a small ABAP program developed & schedule this ABAP Program as a background job every night at 1 am.

This Program will basically check the date of creation of Customer master (you can also check the first date of Delivery of the Customer) & current date & if it is more than 6 months (180 days) it will automatically set a Order & Delivery Block (like the once we do in XD05) for all the Sales Area the Customer is extended to.

Subsequently the authorized person will review the Customer & if he is to be made permanent dealer, remove the blocks with T-Code XD05, else let the block as it is.

Thanks,

Jignesh Mehta

[Former Member]

Dear Jignesh,

Could you tell me how to do?

Thanks

Rakesh

[jignesh_mehta3]

Hello Rakesh,

Speak to your ABAPer regarding this & he will write a Report based on your requirements.

You will have to just schedule the report to run every day at a fixed time.

Thanks,

Jignesh Mehta

[former_member184065]

Dear,

Please explain your requirement with ABAPer and they will fix .

If you have any issues please let me know.

Thanks,

Naren