SAP CRM銷售訂單UI上的欄位對應的資料庫表儲存欄位:requested start date和end date
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:
REPORT zdisplay_request_date.PARAMETERS: guid TYPE crmt_object_guid OBLIGATORY DEFAULT '00163EA720041EE19BB780506245F081'.DATA: lt_dates TYPE STANDARD TABLE OF scapptseg,
lv_link TYPE crmd_link-guid_set.START-OF-SELECTION.
SELECT SINGLE guid_set INTO lv_link FROM crmd_link WHERE guid_hi = guid AND objtype_set = '30'.
IF sy-subrc <> 0.
WRITE: / 'no requested data maintained'.
RETURN.
ENDIF.
SELECT * INTO TABLE lt_dates FROM scapptseg WHERE appl_guid = lv_link.
READ TABLE lt_dates ASSIGNING FIELD-SYMBOL(<start>) WITH KEY appt_type = 'SRV_CUST_BEG'.
IF sy-subrc = 0.
WRITE: / 'requested start: ' , <start>-tst_from.
ENDIF.
READ TABLE lt_dates ASSIGNING FIELD-SYMBOL(<end>) WITH KEY appt_type = 'SRV_CUST_END'.
IF sy-subrc = 0.
WRITE: / 'requested end: ' , <end>-tst_from.
ENDIF.
Note: “30” means object name “APPOINTMENT”, you can find the relationship from this table CRMC_OBJECTS:
要獲取更多Jerry的原創文章,請關注公眾號"汪子熙":
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/24475491/viewspace-2722160/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- mysql-資料庫欄位date datetimeMySql資料庫
- 如何查詢SAP Fiori UI上某個欄位對應的底層資料庫表UI資料庫
- SAP MM ‘Pricing Date Control‘欄位的理解
- date、timestamp欄位型別型別
- 如何查詢BAPI SD_SALESDOCUMENT_CHANGE裡欄位對應的資料庫儲存表API資料庫
- 如何查詢 SAPGUI 螢幕上某個欄位對應的資料庫表儲存的試讀版GUI資料庫
- 解決生產庫date欄位顯示不正確
- 查詢表上的索引及對應的欄位索引
- SAP WM中階儲存型別裡的Full stk rmvl 欄位和Return Storage type欄位型別
- SAP CRM One Order header資料庫表幾個和時間戳相關的欄位Header資料庫時間戳
- 在 SAP MM 物料顯示介面上看到一個欄位,如何查詢哪張資料庫表的哪個欄位進行的儲存資料庫
- 如何把SAP CRM WebClient UI上某個欄位高亮加粗顯示WebclientUI
- 對資料庫中的表或欄位重新命名資料庫
- ASP獲取資料庫表名,欄位名以及對欄位的一些操作 (轉)資料庫
- SAP SD微觀研究之銷售訂單型別配置裡有關PO的幾個欄位型別
- oracle 資料庫設定表和欄位的別名Oracle資料庫
- jackson 中JsonFormat date型別欄位的使用JSONORM型別
- SAP CRM和Cloud for Customer的擴充套件欄位後設資料Cloud套件
- 資料庫表欄位命名規範資料庫
- Mysql資料庫建立儲存過程實現往資料表中新增欄位的方法MySql資料庫儲存過程
- varchar or blob:欄位型別的儲存和溢位條件型別
- MySQL 如何儲存長度很長的資料欄位MySql
- 在SQL Server中修改欄位型別和欄位名稱的儲存過程SQLServer型別儲存過程
- oracle刪除表欄位和oracle表增加欄位Oracle
- abap學習筆記-SAP欄位與表的對應關係筆記
- SAP CRM calculated欄位的實現原理講解
- SQL Server中獲取資料庫名、表名、欄位名和欄位註釋的SQL語句SQLServer資料庫
- mysql資料庫新增和修改欄位MySql資料庫
- 更新大表中某個欄位的儲存過程儲存過程
- postgresSQL 實現資料修改後,自動更新updated_date/ts等欄位SQL
- 小議lob欄位結構和儲存
- PHP表單-必需欄位PHP
- 查詢/刪除重複的資料(單個欄位和多個欄位條件)
- 動態為10g資料庫的表新增欄位,到256個欄位,hung住了?資料庫
- 位運算-設計資料庫表的多選狀態欄位資料庫
- mssql sqlserver 可以儲存二進位制資料的欄位型別詳解SQLServer型別
- 資料庫int欄位超限資料庫
- 資料庫欄位問題資料庫