topic Re: Error message from specifications in Application Development and Automation Discussions

Error message from specifications

Former Member — Mon, 11 Jan 2021 06:32:28 GMT

There's a field called 'ZYEAR_MONTH' on selection screen, and its type is S031-Spmon, because I'd like to lay this files out as 'MM.YYYY',

1)confused about which type of 'ZYEAR_MONTH' should be.

2)and in the SQL , I'd select ~ from MSEG where BUDAT_MKPF In @S_ZYEAR, but there issues an error : the type of 'MSEG-Budat_MkPF' and the type of 'S_ZYEAR' is not compatible.

How to deal with it?

Thank you.

Re: Error message from specifications

FredericGirod — Mon, 11 Jan 2021 07:01:59 GMT

It is difficult to help you, as we do not know your requierment.

for the S_YEAR, you have to create a ranges and use the value of S_YEAR to convert it in S_BUDAT. The convertion could be difficult, it depends if you allow the Intervals & the Extension

Re: Error message from specifications

former_member717457 — Mon, 11 Jan 2021 07:24:28 GMT

Hello,

parameters:  p_lfmon   like mbewh-lfmon. " Month
parameters:  p_lfgja   like mbewh-lfgja. " Year

BUDAT_MKPF - not possible to pass only month & year (MM.YYYY), in that case 
apply along with date example if the month is October and the year is 2020--> 
01.10.2020 to 30.10.2020.

Thanks

Sathish Kumar Sidhaiyan

Re: Error message from specifications

Former Member — Mon, 11 Jan 2021 07:34:35 GMT

Hi, thanks for your answering.

Is it possible to convert 'YYYYMM' to 'MM.YYYY'?

Re: Error message from specifications

FredericGirod — Mon, 11 Jan 2021 07:37:25 GMT

You should check if there is conversion exit function based on period.

I know this kind of field exist in CO (and CO-PA)

Re: Error message from specifications

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

Hi, Competely understand your suggeation, as what I'm confused about,

I wonder if it's possible to select~ where month of MSEG-BUDAT_MKPF = @S_ZYAER ?

Thank you!

Re: Error message from specifications

Former Member — Mon, 11 Jan 2021 07:45:17 GMT

OK, and may I ask if it's possible to select~ where the month of MSEG-BUDAT_MKPF = @S_ZYEAR?

(the type of S_ZYEAR type char7)

Re: Error message from specifications

Former Member — Mon, 11 Jan 2021 07:50:17 GMT

and I don't know how to show the field ZYEAR_MONTH as the format 'MM.YYYY'. Is the type wrong?

Re: Error message from specifications

former_member717457 — Mon, 11 Jan 2021 10:38:49 GMT

you cannot filter date field as MM.YYYY. So only said if you know month and year specify 01 to 31st along with month and year. this is only the possible way.

Otherwise raise OSS note to SAP.

Thanks

Sathish Kumar Sidhaiyan

Re: Error message from specifications

FredericGirod — Mon, 11 Jan 2021 10:43:30 GMT

WRITE |{ zyear_month+4(2) }.{ zyear_month+0(4) }|.

Re: Error message from specifications

RaymondGiuseppi — Mon, 11 Jan 2021 14:40:00 GMT

Check for the many data elements associated to a domain with a type of ACCP and carrying a conversion exit similar to BCVMN (convert according to user settings as MM.YYYY)

But you won't be able to use it in the WHERE clause on a database table without such field, you must convert it to a selection of year GYEAR and period POPER or to a range of posting dates BUDAT with a FM such as FIRST/LAST_DAY_IN_PERIOD_GET.

NB: You will require the Fiscal Year Variant associated to the company code for any special period.

Re: Error message from specifications

Former Member — Tue, 12 Jan 2021 05:34:59 GMT

Thanks for your answering!

As your suggestion , if I convert the S_ZYEAR to a RANGE type, what should I fill into the LOW value and the HIGH value ?