on 07-31-2014 7:14 PM
Hi,
I need to find EVT GUID for message. I am extracting data in BW using '0SCEM_1' datasource.
Problem is I have onlly EH_GUID and my requirements required to use EVT guid for other table like evm_HDR.
If I search table eh_evmsg using eh_guid then I will get multiple evt guid..also
I try to use Tracking ID/Codeset field for eh_hdr to search in EVM_HDR but I found multiple entry.
so, extracting data in BW using 0SCEM_1..Is any way I can directly get evt_guid..
Please..help me out.
Thanks
Chan
Thanks You for all answers.
I am extraction 0SCEM_01 Data extractor in BW, so as per line data comes in BW..EH_GUID field is major key..
Question:
in 0SCEM_01 Datasource, Event GUID (NOT EH_GUID) is part of datasource?
if Not then how to assign event guid for this particular eh_guid..
I try evm_hdr table using..different field like event code,partner code etc..but still could not reach to unique or 1 event guid assign to particular eh_guid.
is inbuild event guid for this eh_guid in 0SCEM_01 datasource..
Thanks
chan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Chan,
it depends on your scenario.
Event Code is one of the logical key as Deb already mentioned. The other ones are Location Code Set, Loc Id1 and 2, Partner Code Set and ID, Data Code Set and ID. You should check which of these fields are used in your scenario.
Best regards,
Steffen
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Chandresh,
You should use Event Code to find an unique EVT_GUID related to EH_GUID from table EVM_HDR.
Thanks,
Deb
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
9 | |
4 | |
3 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.