To recover data of two tables ORACLE and to create IDOC Finsta

[Former Member]

Hello expert:

I have the following scene:

SAPR/3 <----

---

XI <----

-

---

ORACLE

(To process Idoc) (CREAR IDOC PAYEXT) (Table: Header and Table: Detail).

i need to recover the information of ORACLE of two tables (Headed and it details), to take the data to XI

and to create the IDOC(PAYEXT), finally to give it to SAPR/3.

my problems are two:

• Not like recovering the information of the two tables at the same time related by the field key.

• In addition I need to create in IDOC (Finsta) to SAPR/3.

I hope that they can help me

thanks

Raúl.

[nisarkhan_n · Accepted solution]

will Join stament in retriving the data from two tables not help for you?

[Former Member · Accepted solution]

Help me please!

Example one:

select H.ID_TRANSAC H.FEC_PAGO H.HOR_PAGO D.NUM_REFERENCIA D.IMPTE_PAGO

FROM PPQ_PAGO_CENTRA_H AS H INNER JOIN PPQ_PAGO_CENTRA_d AS D ON H.ID_TRANSAC = D.ID_TRANSAC where H.ID_TRANSAC = '5686496'

Example two:

SELECT PPQ_PAGO_CENTRA_H.ID_TRANSAC PPQ_PAGO_CENTRA_H.FEC_PAGO PPQ_PAGO_CENTRA_D.ID_TRANSAC PPQ_PAGO_CENTRA_D.NUM_REFERENCIA

FROM PPQ_PAGO_CENTRA_H INNER JOIN PPQ_PAGO_CENTRA_d ON PPQ_PAGO_CENTRA_H.ID_TRANSAC = PPQ_PAGO_CENTRA_D.ID_TRANSAC

WHERE PPQ_PAGO_CENTRA_H.ID_TRANSAC = '5686496'

It gives errors me of the two forms. You help me with an example of the Join?

[nisarkhan_n · Accepted solution]

Firstly:

Pre Oracle 9i does not support the INNER JOIN, i hope you are on the Oracle 9i + version.

select H.ID_TRANSAC H.FEC_PAGO H.HOR_PAGO D.NUM_REFERENCIA D.IMPTE_PAGO

FROM PPQ_PAGO_CENTRA_H AS H INNER JOIN PPQ_PAGO_CENTRA_d AS D ON H.ID_TRANSAC =

D.ID_TRANSAC where H.ID_TRANSAC = '5686496'

with this stament:

select H.ID_TRANSAC H.FEC_PAGO H.HOR_PAGO D.NUM_REFERENCIA D.IMPTE_PAGO

FROM PPQ_PAGO_CENTRA_H H INNER JOIN PPQ_PAGO_CENTRA_d D ON H.ID_TRANSAC = D.ID_TRANSAC where H.ID_TRANSAC = '5686496'

I am not sure this will work, but the syntat for inner joins should not include AS i think.