Error while creating infoset

[Former Member]

Hi Frdz,

While creating infoset through table join conditions system thrown error such as:

Module : SAPDBxVisual Query.Visual Query

Join : Join already exists

Error No: 91

Error : Object variable or with block variable not set.

Actually I'm traing to give join condition PA0000------>PA9038 (custamized IT).

Kindly give appropriate solution for the same.

Reward points would be awarded for the answers.

Awaiting for your reply.

Thanks,

$Lakshmi

[devika_coelho]

Standard functionalities will not work for custom fields, please add all fields.. vale, text etc. as seperate fields and code accordingly.

[Former Member]

HI Devika,

I did as u said above, now I'm getting only value (ZDESG) as a out put field , even right click on the check box value and text showing in disable mode.

Hence, In this situation how can I get text along with value please let me know asap.

Thank u for ur reply

$Lakshmi

[devika_coelho]

Hi,

The simplest way to do this is as follows:

Create the infoset with PNP database and add all the infotypes required (including custom ones). Add the fields of the custom Z tables as additional fields in the infotypes and write your code to select the data into these fields based on the already existing infotype fields. For example if you want to get designation based on position you will write:

select <designation> from ZDESG

into <custom field>

where PLANS = P0001-PLANS

Creating joins over already existing joins will not be a stable solution.

Devika Coelho.

[Former Member]

Hi, Davika

Thanks for reply.

I'm aware of PNP(LDB), but I have some customized tables like ZDESG (for designation) and ZROLE (Role). Hence I have to create Infoset through table join conditions, the error I got while working on table table joins.

As well as I created one infoset through table join conditions and created query for this but while executing the report system throwing error data was not selected.

I creates as mentioned, came to know that while creating infoset through table join condition one field should be common in all Infotypes, which ever I taken as Infoset BEGDA & ENDA is common field so whether it is ok or need any changes for infoset.

kindly advice it is very urgent for client.

Waiting for your reply.

Thanks,

$Lakshmi

[McF]

> I'm aware of PNP(LDB), but I have some customized

> tables like ZDESG (for designation) and ZROLE (Role).

> Hence I have to create Infoset through table join

> conditions, the error I got while working on table

> table joins.

Even with additional tables I highly recommend to use the LDBs to ensure correct handling of time logic and authorizations!

Xou still can add the needed fields as additional fields or the tables as additional tables in SQ02 to the InfoSet.

Regards,

Michael

[devika_coelho]

Standard joins are already created for PA infotypes, please use logical database PNP and you will find your custom infotype under Further Infotypes.