topic Re: Update TVARVC Table Dynamically in Application Development and Automation Discussions

Update TVARVC Table Dynamically

Former Member — Mon, 26 Oct 2009 13:46:34 GMT

Hi,

I am having 2 parameters in TVARVC Table.

1. Fiscal year - "SAP_SCMA_FISC_YEAR"

2. Period - "SAP_SCMA_PERIOD"

Do we have any program to update these 2 parameters with system defaults.

Today's date is 26/10/2009

Ex : Fiscal Year should be 2009

Period 09

It should be update on starting of every month?

Thanks

Bhuvana

Re: Update TVARVC Table Dynamically

Former Member — Tue, 27 Oct 2009 02:49:55 GMT

Try creating a program which does BDC for SM30 of the table and you can update the values in the table.

Thanks,

Aravind

Re: Update TVARVC Table Dynamically

Former Member — Tue, 27 Oct 2009 10:55:50 GMT

Hi,

Use FM 'RS_VARIANT_CHANGE',

The varaints related function modules can be found in Function group: SVAR.

Regards,

Praveen

Re: Update TVARVC Table Dynamically

Former Member — Wed, 28 Oct 2009 06:34:12 GMT

Hi ,

You can use function module 'RS_CHANGE_CREATED_VARIANT' .

Regards

Satish

Re: Update TVARVC Table Dynamically

Former Member — Wed, 28 Oct 2009 06:36:36 GMT

Hi,

Try using the Fm "RS_CREATE_VARIANT".

please close the thread, if solved

Regards,

Aditya

Re: Update TVARVC Table Dynamically

Former Member — Tue, 10 Nov 2009 15:47:08 GMT

Hello,

You can wrote a progam like this exemple

SELECT * FROM TVARVC WHERE NAME = 'SAP_SCMA_FISC_YEAR'.

TVARV-LOW = new_value .

UPDATE TVARV.

ENDSELECT.

And you create a job wich start at the beginin of the month

Thierry

Re: Update TVARVC Table Dynamically

Former Member — Wed, 11 Nov 2009 13:32:12 GMT

Hi,

Updating of table TVARVC Dynamically can be done by writing a program and scheduling the same as batch job to run at fixed interval as starting of the month.

Thanks,

Vengal Rao.

Re: Update TVARVC Table Dynamically

Former Member — Fri, 13 Nov 2009 12:19:03 GMT

Resolved

Re: Update TVARVC Table Dynamically

Former Member — Fri, 22 Jan 2010 06:42:43 GMT

Hi Bhuvaneswari ,

Could you please post how you resolved the issue to update TVARVC table with system defaults.

As I have a similar reqt. where I wud be passing values from selection screen to update the TVARVC values.

Regards,

Gaurav

Re: Update TVARVC Table Dynamically

Former Member — Fri, 22 Jan 2010 10:07:42 GMT

Hi,

Please check the below code.

INITIALIZATION.

p_date = sy-datum.

START-OF-SELECTION.

PERFORM fiscal_period_determine.

PERFORM update_tvarvc_table.

FORM fiscal_period_determine .

CALL FUNCTION 'FI_PERIOD_DETERMINE'

EXPORTING

i_budat = p_date

i_bukrs = gc_bukrs

IMPORTING

e_gjahr = gv_year

e_poper = gv_period.

ENDFORM.

UPDATE tvarvc SET sign = gc_i opti = gc_eq low = gv_year WHERE name = 'SAP_SCMA_FISC_YEAR'.

IF sy-subrc = 0.

gv_flag1 = gc_x.

ENDIF.

UPDATE tvarvc SET sign = gc_i opti = gc_eq low = gv_period WHERE name = 'SAP_SCMA_PERIOD'.

IF sy-subrc = 0.

gv_flag2 = gc_x.

ENDIF.

IF gv_flag1 = gc_x AND gv_flag2 = gc_x.

MESSAGE 'TVARVC Table is Successfully Updated'(002) TYPE 'S'.

ELSE.

MESSAGE 'Error in Updating TVARVC Table'(003) TYPE 'E'.

ENDIF.

Thanks

Bhuvana

Re: Update TVARVC Table Dynamically

Former Member — Thu, 18 Nov 2010 21:48:26 GMT

Hi Bhuvana

Where did you put above code?