SP FOR MAKING PROFIT CENTER MANDATORY

[Former Member]

Hi Experts

Anybody have the SP for making Profit Centers mandatory for all Marketing documents including passing manual Journals

regards

KARTHIK

[Former Member · Accepted solution]

Hi

This is for A/R invoice Document.. by the way you can proceed by changing object type

If @object_type = '13' and (@transaction_type = 'A')
begin
IF EXISTS (SELECT T0.DOCENTRY FROM OINV T0 Inner join inv1 T1 on T0.DocEntry=T1.DocEntry WHERE (T1.ocrcode is null 
) AND T0.DOCENTRY = @list_of_cols_val_tab_del)
begin
set @error = 1
set @error_message = 'Choose Profit Center'
end
end

Regards,

Sudhir B.

[Former Member]

Hi Sudhir

Thanks a Lot. It's working fine.

regards

KARTHIK

[former_member206488]

Hi ,

To make profit centre mandatory in 2007 and 8.8 versions, look at http://wiki.sdn.sap.com/wiki/display/B1/SAPB1SQLZ-TSSettingMandatoryField , change T0.Project to To.OcrCode in query.

It will set profit centre as mandatory field on all marketing documents.

In 8.81 , go to general settings and set profit centre as mandatory field.

Thanks,

Neetu

[Former Member]

Hi,

What is your SAP Version and Patch Level ?

In prior to 8.81 you use the Stored Procedure

If You have in 8.81 then default option is there to make a mandatory in procit center.

*Close the thread if issue solved.

Regards

Jambulingam.P

[Former Member]

Hi!

In SAP 8.81, this feature has come as a default setting under General settings.