on 04-26-2016 9:08 AM
Hi Expert,
We are using Solman 7.1 SP10
I was trying to find the CD with search "implementation date" "later than".
But in my search list one CD was missing.
If I opened that particular CD which was missing the implementation date is there..
After finding the information from table CRMD_CUSTOMER_H.
In this table implementation date was not stored.
My question,
Why in the table, implementation date is not save.
From which table the particular CD pickup the information.
Thanks,
Abhinash
Hi,
This issue is still not solved please advice me.
The implementation date updated into the table SCAPPTSEG that is why some CDs comes under the search list but for the some CDs is implementation date not stored the table CRMD_CUSTOMER_H and those CDs are missing in my search list.
My query why all date information not stored into the table CRMD_CUSTOMER_H.
Thanks,
Abhinash
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Prasath,
The implementation date is stored for some CD and for some CD was blank in CRMD_Customer _H table.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Prasath,
Thank you for the wonderful guidance.
I think we are just near by my query.
My query is why the implementation date is not stored in the table CRMD_CUSTOMER_H.
Thanks,
Abhinash
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Abinash,
I am not sure if Implementation Date is expected to be in this Table. Please check the above link and see if it helps. .
Regards,
Prasath
Hi All,
Please suggest your valuable advice on this issue.
Thanks,
Abhinash
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Abhinash,
As per my knowledge, You can get the data from CRMD LINK and SCAPPTSEG tables. Please note it is not straight forward, you will have to use GUID set from CRMD_LINK and GUID from CRMD_ORDERADM_H. Implementation data can be fetched from field TST_FROM in SCAPPTSET Table.
Regards,
Prasath
Hi Abinash,
Please find below the steps.
1. Search the CRMD_ORDERADM_H table with the Transaction Number, make a note of GUID Field value.
2. Search the CRMD_LINK table with the following criteria:
GUID_HI = GUID (from CRMD_ORDERADM_H)
OBJTYPE_HI = 05
OBJTYPE_SET = 30.
Make a note of GUID_SET value.
3. Search the SCAPPTSEG table with the following Criteria:
APPL_GUID = GUID_SET (fetched from CRMD_LINK)
APPT_TYPE = SRV_RREADY
TST_FROM field value is the Implementation date.
Hope this helps.
Regards,
Prasath
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
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.