How to pass parameters to Stored Procedure

[Former Member]

Hi,

How to pass a variable from SAP to a SQL Stored Procedure and get the data from SQL Stored Procedure into an internal table. This is more related to Native SQL.

Need the correct syntax.

Thanks & Regards,

Rao

[Former Member]

This message was moderated.

[Former Member]

This message was moderated.

[venkateswarareddy_medam]

Hi,

first create a stucture of the table which u want and then move the data to that stucture's field.

ex:

EXEC SQL PERFORMING ITABORD1_APPEND.

SELECT A.EBELN, A.EBELP, B.AEDAT, A.WERKS, A.MATNR, A.TXZ01,

A.MEINS, A.MENGE, (A.NETPR/A.PEINH)*100,

A.MENGE(A.NETPR/A.PEINH)100, D.EINDT,

A.MENGE-D.WEMNG, A.AFNAM , E.EKNAM, F.CFDAT, F.CFTIM,

F.LTDAT, F.LTTIM, ' ', ' ', ' ', ' '

INTO :ZIT_WEBIF_ORD1

FROM EKPO A, EKKO B, EKET D, T024 E,

ZMEP_06TB F

WHERE A.MANDT= :SY-MANDT

AND A.MANDT = B.MANDT

AND A.EBELN = B.EBELN

AND A.LOEKZ <> 'L'

AND B.LIFNR = :RCV_ORD1_LIFNR

AND B.BEDAT BETWEEN :RCV_ORD1_BEDATF AND :RCV_ORD1_BEDATT

AND B.MANDT = E.MANDT

AND B.EKGRP = E.EKGRP

AND A.MANDT = D.MANDT(+)

AND A.EBELN = D.EBELN(+)

AND A.EBELP = D.EBELP(+)

AND A.MANDT = F.MANDT(+)

AND A.EBELN = F.EBELN(+)

AND A.EBELP = F.EBELP(+)

ENDEXEC.

Regards,

Venkat.