SE16H Error

[vvenkat70gbg]

I am simply trying to connect MARC with MARA (just getting the material type and UOM from MARA). When I run, I get this error. What does it mean and how can this be fixed?

The parser produced the error: The input text for this dynamic specification is incomplete.

Exception of class CX_SY_DYNAMIC_OSQL_SYNTAX

[vijay_hariharan]

Hello,

Could you please provide the steps that you used to create the connection.. Maybe screens could help get you a suitable response..

Regards.
Vijay

[vvenkat70gbg]

Sure. Attached are the screenshots.

[amontella96 · Accepted solution]

Hi vvenkat70gbg

although its not exactly clear, the message means you have missed a piece of configuration

How can this be fixed? The answer is adding the input for secondary table in the Outer Join Conditions, see below

Please flag this as answered (if it works) for your for future research of this type of error

Thanks!A

[vvenkat70gbg]

Sorry for not responding earlier. Thanks for your tip. That helped in taking out the error, but my output shows the plant as blank. What am I doing wrong?

[amontella96]

Hi vvenkat70gbg

wow! it's a coincidence that I saw this update, if you wish to tag somebody you need to place @ account ..

back to business, i repeated same steps in an erp and it workd!

Can you please mark this as answer then open a new question (for example SE16H return empty output?) and screenshot the steps with the correction for the error?

thanks!A

[vvenkat70gbg]

Thanks, will do!

[former_member818386]

Hello

There are some standard DB-views for MARA-MARC-inner-join, e.g. MA61V "Material Master: DB View for MRP" which may be used instead to get the columns you need.

Regards R.Jensen