cancel
Showing results for 
Search instead for 
Did you mean: 

Automatic Customer block

Former Member
0 Kudos
624

Hi

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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
0 Kudos

Dear Ashish

Thanks for the solution

Former Member
0 Kudos

Dear Rohan,

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

Thanking you!

Ashish Mishra

Former Member
0 Kudos

Thanks Ashish

Former Member
0 Kudos

HI  ASIHSH,

what is KNA value.

warm regards,

Jagadiish

Former Member
0 Kudos

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
0 Kudos

Dear Ashish,

thanking you for your concern and reply.

warm regards,

Jagadeesh

Answers (1)

Answers (1)

Former Member
0 Kudos

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
0 Kudos

Dear Vinu

Thanks for the solution