Internal Table in XI

[Former Member]

Hi,

I am making an RFC call from sap. I want to have an internal table in XI, after that I want to map it to jdbc structure. How can I do that without BPM?.

Here is how my RFC structure looks:

Z_PA_DINERS_TXN 1..1

-

---

-

---

IT_ZDINERS 1...1

ITEM 0...UNBOUNDED

MANDT 0..1

EMP_NO 0..1

DATE 0..1

My question is I am assuming item 0..unbounded is an internal table. Is it right?, Please tell me how to do, if it is not right?

Thanks-in-advance.

Raj.

[MichalKrawczyk · Accepted solution]

hi,

>>>>My question is I am assuming item 0..unbounded is an internal table. Is it right?,

yes if you import into repository

this will be your :internal table" from r3

but in the RFC it has to be a normal table of course

(tables parameter)

Regards,

michal

[Former Member · Accepted solution]

Thanks Michal.

I appreciate your prompt reply. So it care of multiple records!!.

Can you please tell me how did you master XI?. May be we can also contribute like you to the community.

Thanks,

Raj.

[MichalKrawczyk · Accepted solution]

just have a look at this weblog:

/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30

it shows how you can map a "table type" - structure (in this case data_filesender section) to a jdbc call

>>>>Can you please tell me how did you master XI?

practice, practice, practice

Regards,

michal

-

---

<a href="/people/michal.krawczyk2/blog/2005/06/28/xipi-faq-frequently-asked-questions">XI FAQ - Frequently Asked Questions</a>

[Former Member · Accepted solution]

Michal,

Please check my database table structure I created. I just want to make sure, bcoz I m getting xi system error at the jdbc adapter. In the web log u sent I still dont understand what is 'access'.

Zdiners complex type

Insert element 1

zdiners element 1

action attribute optional

table element 1

emp_no element 1

date element 1.

thanks,

Raj.

[MichalKrawczyk · Accepted solution]

hi Raj,

have a look at this page:

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

it shows how <b>MUST</b> the jdbc call message type look like

in order for a jdbc call to work

Regards,

michal

-

---

<a href="/people/michal.krawczyk2/blog/2005/06/28/xipi-faq-frequently-asked-questions">XI FAQ - Frequently Asked Questions</a>

[Former Member · Accepted solution]

Hi Michal,

I checked my database table structure, it is according to the document. I am suspecting do we need to define the database table structure also as an Internal table or do we need to anything extra, since we are mapping from Internal Table.

This is what the error I get:

no_messaging_url_found: Unable to find URL for Adapter Engine af.xis.gles3001.

Error when reading the access data (URL, user, password) for the Adapter Engine af.xis.gles3001

Can you please help me.

Thanks,

Raj.

[MichalKrawczyk · Accepted solution]

hi,

>>>Error when reading the access data (URL, user, password) for the Adapter Engine af.xis.gles3001

do you have any local adapter engine?

if not during the communication channel

configuration use Intergration server

and not af.xis.gles3001 as your adapter engine

Regards,

michal

[Former Member · Accepted solution]

Michal,

Thanks for your support.

I didnt understand you exactly. As far as I know there should be only one adapter engine on XI, I dont know about other Adapter Engine.

During Comm Channel configuration, for both sender and reciever, i didnt select any af.xis.gles3001.

In Message monitor, Audit Log, It showed that RFC is successfull in receiving message and even placing it in the queue, when it communicates, I think, its failing.

Thanks-a-lot.

Best Regards,

Raj.

[MichalKrawczyk · Accepted solution]

check jdbc channel

if it doesn't have af.xis.gles3001

as the adapter engine

Regards,

michal

[Former Member · Accepted solution]

I checked the JDBC comm channel. There also I have only Integration server available as Adapter Engine. I dont have anything else. Gles3001 is my XI server only.

Thanks,

Raj.

Message was edited by: Raj Peddisetty

[MichalKrawczyk · Accepted solution]

hi,

then check the XI's exchange profile

(adapter framework user and pass)

more tomorrow:)

Regards,

michal

[Former Member · Accepted solution]

Michal,

I changed the exchange profile adapter framework parameters to mu username and password, and tested it. Same result, suggest me next steps.

Thanks

Raj.

Message was edited by: Raj Peddisetty

[MichalKrawczyk · Accepted solution]

Hi,

If I have any more info on this error

I'll update your new thread:

messaging URL not found for Adapter Engine

but nothing more comes to my mind without having a

look into the system

try checking visual admin logs:

/people/michal.krawczyk2/blog/2005/09/07/xi-why-dont-start-searching-for-all-errors-from-one-place

maybe you'll find some more info over there

Regards,

michal