SAP Infoset: Illegal Join Conditions IFLOT.TPLNR= AUSP.OBJEK

Hello,

I am trying to create an SAP Infoset that links IFLOT.TPLNR= AUSP.OBJEK. However, the fields have a different definition (different number of characters) and SAP will not allow me to create the join.

Instead, I get a message stating "Illegal Join Conditions"

How can I overcome this problem? I guess I will need to use some kind of ABAP in the infoset.

Any help would be appreciated.
thumbcastAsked:
Who is Participating?
 
thumbcastAuthor Commented:
Thanks for your response Ron.

I am actually looking to build a suite of data extraction reports to be used in the context of data migration i.e. to provide post load validation and sign off.

As I suspected, SAP Query is not without it quirks and often requires some ABAP. Instead I will go down the route of pulling the SAP tables into my staging area and then develop these reports using my ETL tool.

Reegards
0
 
BuckaCommented:
Hi,

Would you be able to provide a quick scope of what you are trying to achieve?
What are select-options?
What are the ouput requiements?
How frequently would the report be executed?

My intial thought would be for a developer to write a report for you from scratch...

If you give me some further details I would be perhaps able to give you a time estimate to build a report.

ABAP Query can be a useful tool for one off reports but the subsequent generated program may not be optimised for performance.

Regards,

Ron


Regards,


Ron



0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.