Table field empty

[Former Member]

hello ,

i try to make a report. As table im using CATSDB + IFLO.

im using catsdb for the date ; personnal number ; hours ; receiver order and the functional location But the field  functional location in CATSDB is empty

so i use the table IFLO. Unfortunately when i run the report the get the message : No data selected.

I think there is a probleme with the jointure.

Do you have any idea of where that comes from ?

Thank you for ur help

[Former Member]

Can you try table IFLOT instead of view IFLO?

[Former Member]

Hi Mehdi,

Can you please paste your code here?

Did you check the data manually in database table through SE16 ?

Regards,

Dipesh

[Former Member]

hi mehdi,

check this relationship between the table,

Refer the attachment,

Naga

[Former Member]

Hi Mehdi,

The relationship defined for Counter(CATSDB) to STNAM(IFLO) is incorrect.

I presume you are looking to find the function location of an employee and CATSDB is being used to get the employees and time entered in CATS itself.

If employee is in a project (for example) then based on the WBS element/network you mayb e able to get the functional area of an employee.

There are two fields in CATSDB as well i.e. SFA  /  RFA which you can check as well for functional area.

Regards,

Saqib

[Former Member]

Hello everyone ,

Susmitha Susan Thomas ,

i try and it doesnt work. Functional location ( CATSDB ) the technical name is YY TPLNR whereas in IFLO the technical name is TPLNR ( Which is the same in IFLOT ). i think maybe the problem is here.

Dipesh Patil ,

when i look on CATSDB in se16 the field Functional location is empty

naganathan Ramalingame ,

i did what you told me but it is not working

After in SQ01

the list field I select

Date

Personal number

hours

Receiver order

Functional location

in the selection list i take

date

receiver order

Thank you for your help

[RaymondGiuseppi]

The answer of your requirement is tied to the type of receiver for catsdb.

e.g. for a maintenance order :

• AFIH-AUFNR = CATSDB-RAUFNR
• ILOA-ILOAN = AFIH-ILOAN
• IFLOT-TPLNR = ILOA-TPLNR

Regards,

Raymond

[Former Member]

First is it possible to join a table with a structure ?

if yes how i can extract the table from the structure ? 

My Table is CATSDB and table name is  CATSAPPR and it is a structure catagory

Thank you