on 03-18-2011 9:28 AM
Hi,
Can anyone help me in getting the logic to fetch SAP component from a ticket.
I want to give ticket number as the input and get the component as output.
Please tell in which table (or tables) SAP component and ticket number are getting stored.
Could you fix this problem? Because I have the same trouble.
Thanks.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Just to add more information to this, I am giving here the logic that we are using now.
****First we need to get the 'Object guid' from the table 'CRMD_ORDERADM_H' by passing the 'ticket no'.
****Then you need to pass this guid in the table 'CRMD_LINK' to get the 'ext ref guid' of the 'object type set 11'.
****Then you can get the ext ref no from the table CRMD_SALES by passing the 'ext ref GUID'.
****Pass the Ext.Reference No. of the ticket in to the table 'DNOD_NOTIF' to get the 'guidh'.
****Finally pass the 'guidh' in to the table 'DNOD_NOTIF_S' to get the SAP component.
This logic is working when the notification number and external refernence number are same.
But when those are not same or the external reference number is blank then this logic is not working.
Please help.
Thanks,
Eliza
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.