Structure Of Stored Procedure DT

[Former Member]

Hi Guys,

Can you pls give me the basic structure of the DT that I need to create for Stored Procedure Call?

XIer

Message was edited by:

XIer

[justin_santhanam · Accepted solution]

Hi,

Check here -http://help.sap.com/saphelp_nw70/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

<b>Fyr:</b>

<StatementName5>

<storedProcedureName action=” EXECUTE”>

<table>realStoredProcedureeName</table>

<param1 [isInput=”true”] [isOutput=true] type=SQLDatatype>val1</param1>

</storedProcedureName >

</StatementName5>

Best regards,

raj.

[Former Member · Accepted solution]

Raj, in my scenario, I am inserting the data as it is from source to target. Now the table has 20 fields and each field will receive data. So will I have the structure like this:

<StatementName5>

<storedProcedureName action=” EXECUTE”>

<table>realStoredProcedureeName</table>

<param1 [isInput=”true”] [isOutput=true] type=SQLDatatype>val1</param1>

<param2 [isInput=”true”] [isOutput=true] type=SQLDatatype>val1</param2>

<param3 [isInput=”true”] [isOutput=true] type=SQLDatatype>val1</param3>

.

.

.(20 times)

</storedProcedureName >

</StatementName5>

Also what is 'isInput' and 'isOutput' and how do they work.

Thanks,

XIer

[Former Member · Accepted solution]

where would the table name come?

XIer

[Former Member · Accepted solution]

Hey

its a stored procedure not a simple SQL statement,table name will be in stored proc.

Thanx

Aamir

[Former Member · Accepted solution]

Thanks Aamir, but what about the structure? will it be the way I have put in the previous query?

XIer