Help on EXECUTE PROCEDURE "APS_PEGID_GET_IO1"

[Former Member]

Hello all,

Any help on this would be greatley appriciated.

Iam using the FM - /SAPAPO/OM_PEGID_GET_IO which has the following statement..

    EXECUTE PROCEDURE "APS_PEGID_GET_IO1" (
                         IN  :LS_GEN_COM_PARAMS,
                         OUT :LV_RC,
                         OUT :ET_RC,
                         IN  :IT_PEGAREA,
                         IN  :IT_PEGID_DESC_CHAR,
                         IN  :IT_ORDER_TYPES,
                         IN  :IT_ORDER_STATUS,
                         IN  :IT_CATEGORY,
                         IN  :IT_CHARACT_REQ_OUTNODE,
                         IN  :IT_CHARACT_VAL_INPNODE,
                         IN  :IT_SUPPLY_AREA,
                         IN  :IT_EXT_FIXED,
                         IN  :IT_TOPORDER_EXCLUDES,
                         IN  :IV_IONODE_PEG_SEL,
                         IN  :IV_PEGARC_TYPE_SEL,
                         IN  :IV_START_TIME,
                         IN  :IV_END_TIME,
                         IN  :IT_ORDER_REQTIME,
                         OUT :ET_POSITIONS,
                         OUT :ET_IONODES,
                         OUT :ET_IONODES_CONF,
                         OUT :ET_CONTI_IO,
                         OUT :ET_CHARACT_REQ_INPNODE,
                         OUT :ET_CHARACT_VAL_OUTNODE,
                         OUT :ET_FIXPEG)
     ENDEXEC.

I would like to know what this statement does, is there any way we can debug this ?

This returns the table ET_IONODES and i would like to know how this table getting filled up.

Thanks for help in advance.

[rajkj]

Hi,

This procedure queries liveCache database for orders by PEGID. Based on the query execution, the procedure returns the orders. Probably, you can analyze the procedure execution on liveCache side (similar to explain plan of oracle) with your MaxDB expert or DBA's support.

Thanks,

Rajesh

[Former Member]

thanks Rajesh.

I have 3 entries in IT_PEGAREA before passing it to this procedure and it filtering out 2 entries from them and returns only one entry to ET_IONODES. I would like to know why its filtering out the those two entries.

Is there any way we can analyze the procedure execution from SAP GUI?

[rajkj]

You can use t.code LC10 (LiveCache DBA Cockpit) to activate database trace or other diagnostic tool to check the query execution. The analysis can be carried out from SAP GUI. Probably, your DBA will be great help in analyzing the SQL procedure execution.

[Former Member]

Okay, I was able to activate the database trace from LC10->liveCache:monitoring->tools->database trace-> traceOn

but the results does not show the information i needed.

I wanted to know where the IT_PEGAREA filtering out the entries.