Automatic Customer block

[Former Member]

Hi

Our requirement is...if sales order is not raised for a customer since last 1 year then system should block the customer automatically.

[Former Member · Accepted solution]

Dear Rohan

With the help of ABAPER use FORM USEREXIT_SAVE_DOCUMENT_PREPARE (MV45AFZZ), where put a logic and with the help of customer check its KNA value is not one year old and  bring the value of VBAK with last 365 days selection from current date and if value found save simply SAVE and if not found then set Billing or Delivery Block.

Thanking you!

Ashish Mishra

[Former Member · Accepted solution]

Dear Ashish

Thanks for the solution

[Former Member · Accepted solution]

Dear Rohan,

If its solved, please close the thread with "Answered".

Thanking you!

Ashish Mishra

[Former Member · Accepted solution]

Thanks Ashish

[Former Member · Accepted solution]

HI  ASIHSH,

what is KNA value.

warm regards,

Jagadiish

[Former Member · Accepted solution]

Dear Jagadeesh

KNA1 (Wrongly typed there KNA) is the table where the data is stored when you create customer, and it has a filed ADRNR with the help of which you can fetch the address details from table ADRC.

ADRC-ADDRNUMBER = KNA1-ADRNR.

Thanking you!

Ashish Mishra

[Former Member · Accepted solution]

Dear Ashish,

thanking you for your concern and reply.

warm regards,

Jagadeesh

[Former Member]

Hi Rohan ,

Not possible in standard SAP. Develop a program with the help to ABAPer which can check for the customer and set the bock.

Execute it as a batch job as per your timelines (daily basis or weekly)

Regards

Vinu

[Former Member]

Dear Vinu

Thanks for the solution