topic Re: covp table in Application Development and Automation Discussions

covp table

Former Member — Mon, 09 Jul 2007 15:46:44 GMT

i have a question on COVP table . How is the data in this table stored, is this based on the fiscal year ?can i select the data based on the posting date ? I have to print the report based on the fiscal year of US(sep-aug) so if i select the data based on posting data may be i will be able to get the required records. I appreciate if anyone can help me on this .

Re: covp table

Former Member — Mon, 09 Jul 2007 15:49:35 GMT

COVP is a view not a table. The tables it includes are COEP and COBK.

Rob

Re: covp table

Former Member — Mon, 09 Jul 2007 15:50:51 GMT

Here you can find the CO items and they are stored on the fycal year or, in generally, FI period.

So if you need to read the items of certain period you can use the posting date.

Max

Re: covp table

Former Member — Mon, 09 Jul 2007 16:09:51 GMT

thanks for your answers . I will give the posting date in where clause but i have a doubt again . Based on fiscal year given in the selection screen i have to select the date say if the fiscal year is 2007 i have to select the data from sep 2006 to aug 2007 . how do i get the dates based on the yr entered in the input .

Re: covp table

Former Member — Mon, 09 Jul 2007 16:21:29 GMT

U need to use the fyscal year (GJAHR) only, u'll get all items u need automatically.

I believe if you see a document posted between sep 2006 and sep 2007, the fyscal year is 2007, so u don't need to do a select based on posting date.

Max

Re: covp table

Former Member — Mon, 09 Jul 2007 16:32:08 GMT

i can give fiscal year but the problem is that for different countries there will be different fiscal years , so i want to select details of different countries based on US fiscal year , so what ever be the country i have to select the records from september to aug and also print periods based on the posting date .

Re: covp table

Former Member — Mon, 09 Jul 2007 16:47:52 GMT

Max ,

can you help me on this ? can anyone else help me on this ?

Re: covp table

Former Member — Wed, 11 Jul 2007 07:13:16 GMT

So you need to use the posting date only.

I believe you need to get the first and the last date of USA fyscal period, so from 01/09/2006 to 31/08/2007 and select all items posted in this period.

The fyscal period should depends on company code, not country, and the system assigns the right period in order of the posting date.

So If the FI periods for the same posting date are differents, you'll see it in the same items selected.

For example:

- if you select the USA items on September 2006, the first period of 2007, you should have item with fyscal year (field GJAHR) 2007 and period (field MONAT) 1,

- if you select the items of another country where the fyscal perido starts on 1 Genuary, you should have an item with fyscal year 2006 and period 09.

So use the posting date only and check the fields GJAHR (fyscal year) and MONAT (FI period) to know which is the FI period.

Max