topic Re: Validations : in Application Development and Automation Discussions

Validations :

Former Member — Mon, 10 Mar 2008 09:04:26 GMT

hello everyone,

How to validate FISCAL YEAR -- VBRK-GJAHR.

POSTING PERIOD -- VBRK-POPER.

will be rewarded ..

Re: Validations :

Former Member — Mon, 10 Mar 2008 09:12:54 GMT

Can you plz explain it clearly?

regards,

Kannan

Re: Validations :

Former Member — Mon, 10 Mar 2008 09:17:24 GMT

Hi,

check the table T009B


data:
period like t009b-poper,
year like bkpf-gjahr.

parameters: p_datum type sy-datum.
parameters: p_bukrs type t001-bukrs.

call function 'FI_PERIOD_DETERMINE'
exporting
i_budat = p_datum
i_bukrs = p_bukrs
importing
e_gjahr = year
e_poper = period.

write:/ period, year.

Regards,

Omkaram.

Re: Validations :

Former Member — Mon, 10 Mar 2008 09:17:55 GMT

i have fiscal year and posting period fields in my selection screen.

I have to do validations to the fields on the selection-screen.

so, how to validate these fields ?

to check whether user has entered correct values or not ???

Re: Validations :

Former Member — Mon, 10 Mar 2008 09:25:19 GMT

Hi,

Use FM BAPI_COMPANYCODE_GET_PERIOD. It will give you the Fiscal year and Fiscal period corresponding to the company code and date.

Example:

Parameter : P_BUKRS type t001-bukrs.

Call FM to get the Posting Period

CALL FUNCTION 'BAPI_COMPANYCODE_GET_PERIOD'

EXPORTING

companycodeid = p_bukrs

posting_date = sy-datum

IMPORTING

FISCAL_YEAR = v_fiscal_yr

fiscal_period = v_monat

RETURN =

Re: Validations :

Former Member — Mon, 10 Mar 2008 09:27:10 GMT

Hi,

Check the following code.

*validation

AT SELECTION-SCREEN ON P_GJAHR .

SELECT

SINGLE GJAHR

FROM VBRK INTO WA_GJAHR

WHERE GJAHR = P_GJAHR .

IF SY-SUBRC <> 0 .

MESSAGE ' Invalild entry in field GJAHR' TYPE 'E' .

ENDIF .

AT SELECTION-SCREEN ON P_POPER .

SELECT

SINGLE POPER

FROM T009B INTO WA_POPER

WHERE POPER = P_POPER .

IF SY-SUBRC <> 0 .

MESSAGE ' Invalid entry in field POPER' TYPE 'E' .

ENDIF .

end of validation

Rewward if helpful.

Regards.

Edited by: Akshay Raj on Mar 10, 2008 10:28 AM

Edited by: Akshay Raj on Mar 10, 2008 10:32 AM