topic Re: Table field empty in Application Development and Automation Discussions

Table field empty

Former Member — Tue, 09 Jul 2013 20:33:26 GMT

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

Re: Table field empty

Former Member — Wed, 10 Jul 2013 07:09:25 GMT

Can you try table IFLOT instead of view IFLO?

Re: Table field empty

Former Member — Wed, 10 Jul 2013 07:14:50 GMT

Hi Mehdi,

Can you please paste your code here?

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

Regards,

Dipesh

Re: Table field empty

Former Member — Wed, 10 Jul 2013 07:27:04 GMT

hi mehdi,

check this relationship between the table,

Refer the attachment,

Naga

Re: Table field empty

Former Member — Wed, 10 Jul 2013 08:59:36 GMT

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

Re: Table field empty

Former Member — Wed, 10 Jul 2013 09:03:23 GMT

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

Re: Table field empty

RaymondGiuseppi — Mon, 15 Jul 2013 14:31:31 GMT

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

Re: Table field empty

Former Member — Tue, 06 Aug 2013 14:00:05 GMT

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