topic Re: SE16H Error in DevOps and System Administration Forum

SE16H Error

vvenkat70gbg — Tue, 16 Nov 2021 16:26:56 GMT

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

Re: SE16H Error

vijay_hariharan — Wed, 17 Nov 2021 05:40:05 GMT

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

Re: SE16H Error

vvenkat70gbg — Wed, 17 Nov 2021 16:41:59 GMT

Sure. Attached are the screenshots.

Re: SE16H Error

amontella96 — Wed, 17 Nov 2021 19:58:23 GMT

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

Re: SE16H Error

vvenkat70gbg — Wed, 23 Mar 2022 21:20:09 GMT

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?

Re: SE16H Error

amontella96 — Wed, 23 Mar 2022 22:01:45 GMT

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

Re: SE16H Error

vvenkat70gbg — Wed, 23 Mar 2022 22:16:25 GMT

Thanks, will do!

Re: SE16H Error

former_member818386 — Tue, 21 Mar 2023 13:28:27 GMT

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