Suppose you need to investigate which database table stores the value of Requested start date and end date:
You can just activate SQL trace via tcode ST05, make changes on either field, and save the change. Then display trace and search with keyword “update”:
You could find one record whose UPDATE statement contains the changed date you maintained in WebUI, which indicates the table SCAPPTSEG is what we are looking for.
When we browse this table in SE11, we didn’t know the relationship between APPT_GUID or APPL_GUID with the service order guid.
We can click the display source code button in ST05:
And set a breakpoint on the very code where the table is updated. From the callstack we can know the function module CRM_DATES_UPDATE_DU is updating this table.
Perform where used list on CRM_DATES_UPDATE_DU and we can get CRM_DATES_SAVE_OB,
then CRM_DATES_SAVE_EC:
In this function, we can know the relationship between appl_guid and service order guid:
I use a simple report below to illustrate the process how to get requested start and end date starting from Service order guid:
REPORTzdisplay_request_date.PARAMETERS:guidTYPEcrmt_object_guidOBLIGATORYDEFAULT'00163EA71EE19BB780506245F081'.DATA:lt_datesTYPESTANDARDTABLEOFscapptseg,lv_linkTYPEcrmd_link-guid_set.START-OF-SELECTION.SELECTSINGLEguid_setINTOlv_linkFROMcrmd_linkWHEREguid_hi=guidANDobjtype_set='30'.IFsy-subrc<>0.WRITE:/'norequesteddatamaintained'.RETURN.ENDIF.SELECT*INTOTABLElt_datesFROMscapptsegWHEREappl_guid=lv_link.READTABLElt_datesASSIGNINGFIELD-SYMBOL(<start>)WITHKEYappt_type='SRV_CUST_BEG'.IFsy-subrc=0.WRITE:/'requestedstart:',<start>-tst_from.ENDIF.READTABLElt_datesASSIGNINGFIELD-SYMBOL(<end>)WITHKEYappt_type='SRV_CUST_END'.IFsy-subrc=0.WRITE:/'requestedend:',<end>-tst_from.ENDIF.
Note: “30” means object name “APPOINTMENT”, you can find the relationship from this table CRMC_OBJECTS:
如果觉得《SAP CRM销售订单UI上的字段对应的数据库表存储字段：requested start date和end date》对你有帮助，请点赞、收藏，并留下你的观点哦！
