topic Re: Function module:G_Period_Get error exception1 in Application Development and Automation Discussions

Function module:G_Period_Get error exception1

Former Member — Mon, 18 Jan 2021 06:14:13 GMT

Select - options:

s_zyear for s031-spmon.(MM.YYYY)

I need to convert the year and month to the fiscal year. And the coding is like this:

With debug, the exception 1 was issued, and I don't know why, Can anyone here help me??

please,thank you.

Data:
  LDF_DATUM TYPE SY_DATLO. 

LDF_DATUM+0(4) = S_ZYEAR-LOW+0(4).
LDF_DATUM+4(2) = S_ZYEAR-LOW+4(2).
LDF_DATUM+6(2) = '01'.

Call function 'G_Period_get'.
  Exporting
    company = p_bukrs
    date    = LDF_DATUM
    ledger  = 'LEDGER'
  Importing
    Period = GDF_Period
    Year   = Gdf_year
  Exception
    Lendger_not_assigned_to_company
= 1

Re: Function module:G_Period_Get error exception1

Former Member — Mon, 18 Jan 2021 06:17:03 GMT

I've tried to set a range table of s_zyear, but I don't know how to use the range table in a Call function. Date could be a scope???

Re: Function module:G_Period_Get error exception1

FredericGirod — Mon, 18 Jan 2021 06:28:38 GMT

You should provide the error returned by SAP.

at first, ledger could not be 'LEDGER' it is a CHAR2

Re: Function module:G_Period_Get error exception1

Former Member — Mon, 18 Jan 2021 06:47:44 GMT

Hi,Girod!

The error returned by SAP may be 'Get finance period error'.

SY-SUBRC = 1…

About ledger, it's my miss.It is 'Ol'

Re: Function module:G_Period_Get error exception1

FredericGirod — Mon, 18 Jan 2021 06:48:54 GMT

Do you have retest with the good ledger value ?

Re: Function module:G_Period_Get error exception1

Former Member — Mon, 18 Jan 2021 06:51:06 GMT

Yes, test by ledger = 'ol' , there's also the exception error issued..

Re: Function module:G_Period_Get error exception1

FredericGirod — Mon, 18 Jan 2021 06:52:42 GMT

(the lowercase value is strange)

Use transaction ST05 to check witch tables are read by the FM, and whitch one is returning 0 record. You will see the WHERE condition criteria and maybe understand what is missing

Re: Function module:G_Period_Get error exception1

Former Member — Mon, 18 Jan 2021 06:54:07 GMT

I wonder how to set value of the date with select-options? Should I call function twice with date of S_ZYEAR-LOW and S_ZYEAR-HIGH?

Re: Function module:G_Period_Get error exception1

FredericGirod — Mon, 18 Jan 2021 06:56:12 GMT

FUNCTION g_period_get.
*"----------------------------------------------------------------------
*"*"Lokale Schnittstelle:
*"  IMPORTING
*"     VALUE(COMPANY) LIKE  T001-BUKRS DEFAULT SPACE
*"     VALUE(DATE) LIKE  SY-DATUM DEFAULT SY-DATLO
*"     VALUE(GLOBAL_COMPANY) LIKE  T880-RCOMP DEFAULT SPACE
*"     VALUE(LEDGER) LIKE  T881-RLDNR DEFAULT SPACE
*"     VALUE(VARIANT) LIKE  T882-PERIV DEFAULT SPACE

Company is type BUKRS, simple field

Date is type SYDATUM, simple field

Global Company is type RCOMP, simple field

Ledger is type RLDNR, simple field

....

where do you want to put a SELECT OPTION or a RANGE ?

Re: Function module:G_Period_Get error exception1

Former Member — Mon, 18 Jan 2021 07:04:58 GMT

DO you actually mean that there's nothing with a Select option or a Range?

And it's alright to type SY-DATUM?

Don't I need to concatenate the year and month into DATE?

Re: Function module:G_Period_Get error exception1

Former Member — Mon, 18 Jan 2021 07:07:23 GMT

Because I need to convert the select option into fiscal year... (maybe wrong)

Re: Function module:G_Period_Get error exception1

FredericGirod — Mon, 18 Jan 2021 07:08:36 GMT

There is nothing to do with Select Option nor Range

I don't know if your concatenation is right, because I don't know the internal format of the field S_YEAR

You could describe a date field as TYPE SY-DATUM or TYPE SYDATUM

and if you want to test simply the FM before playing with your code, you could use in transaction SE37 the test mode (F8), it will generate a Selection screen where you will be able to test the value without doing a program

Re: Function module:G_Period_Get error exception1

Former Member — Mon, 18 Jan 2021 07:11:13 GMT

The value of date is gotten from select option, isn't it?

Re: Function module:G_Period_Get error exception1

FredericGirod — Mon, 18 Jan 2021 07:14:35 GMT

You have a problem with SELECT OPTION ? 🙂

For the value 01 01 2021

Parameters : 20210101

Select-Options: I EQ 20210101

Do you think you could enter the I EQ 20210101 into a simple field DATE ?

A Select-option is a table with a structure : Sign, Option, Low, Value it is very specific

Re: Function module:G_Period_Get error exception1

Former Member — Mon, 18 Jan 2021 07:23:28 GMT

OK,I see.

Oh,I just now used SE37 to test with value that is used in SE38, there's also the same exception issued

Re: Function module:G_Period_Get error exception1

Former Member — Mon, 18 Jan 2021 07:25:47 GMT

why the exception'ledger_not_assigned_to_company' issued? Omg

Re: Function module:G_Period_Get error exception1

Former Member — Mon, 18 Jan 2021 07:31:26 GMT

No, it actually couldn't be entered into the date value..

So how I define the value of date??

I definitely think that the concatenation is wrong

Re: Function module:G_Period_Get error exception1

FredericGirod — Mon, 18 Jan 2021 07:34:12 GMT

TRY

SE37 ... G_PERIOD_GET (in uper case in your code please)

and try like this

Re: Function module:G_Period_Get error exception1

Sandra_Rossi — Mon, 18 Jan 2021 07:45:08 GMT

王雅昕 What are you using G_PERIOD_GET for? Maybe you should use another function module?

Re: Function module:G_Period_Get error exception1

Former Member — Mon, 18 Jan 2021 07:49:40 GMT

Hi!

For getting fiscal period data.

another function module is like what?