SAP CRM資料庫表CRMD_SRV_REFOBJ和CRMD_SRV_OSSET
It is allowed to create several reference objects per header or item of a given business document.
The related database tables to maintain the relationship between a business document and its referenced object are listed below:
You can run the following report to get a list of all business document which have been assigned with at least one product as reference object:
REPORT order_display_has_ref_obj.SELECT * INTO TABLE @DATA(lt_refobj) FROM crmd_srv_refobj WHERE type_object = 'A'. " productCHECK sy-subrc = 0.SELECT * INTO TABLE @DATA(lt_osset) FROM crmd_srv_osset FOR ALL ENTRIES IN @lt_refobj
WHERE guid = @lt_refobj-guid_ref.CHECK sy-subrc = 0.SELECT * INTO TABLE @DATA(lt_link) FROM crmd_link FOR ALL ENTRIES IN @lt_osset
WHERE guid_set = @lt_osset-guid_set.CHECK sy-subrc = 0.SELECT * INTO TABLE @DATA(lt_order) FROM crmd_orderadm_h FOR ALL ENTRIES IN @lt_link
WHERE guid = @lt_link-guid_hi.LOOP AT lt_order ASSIGNING FIELD-SYMBOL(<order>).
WRITE:/ |Order ID: { <order>-object_id }, type: { <order>-process_type }, Description: { <order>-description }| COLOR COL_GROUP.ENDLOOP.SELECT * INTO TABLE @DATA(lt_item) FROM crmd_orderadm_i FOR ALL ENTRIES IN @lt_link
WHERE guid = @lt_link-guid_hi.CLEAR: lt_order.SELECT * INTO TABLE lt_order FROM crmd_orderadm_h FOR ALL ENTRIES IN lt_item
WHERE guid = lt_item-header.LOOP AT lt_item ASSIGNING FIELD-SYMBOL(<item>).
READ TABLE lt_order ASSIGNING <order> WITH KEY guid = <item>-header.
ASSERT sy-subrc = 0.
WRITE:/ |Item: { <item>-description }, Order id: { <order>-object_id } | COLOR COL_NEGATIVE.ENDLOOP.
On the other hand, if you know the ID of order and you would like to check whether it has been assigned with reference product or not, you can execute this report:
REPORT ORDER_DISPLAY_REFERENCE_PROD.PARAMETERS: id TYPE crmd_orderadm_h-object_id OBLIGATORY DEFAULT '8000002271',
ptype TYPE crmd_orderadm_h-process_type OBLIGATORY DEFAULT 'SRVO'.SELECT SINGLE guid INTO @DATA(guid) FROM crmd_orderadm_h WHERE object_id = @id
AND process_type = @ptype.IF sy-subrc <> 0.
WRITE:/ |document not found for id: { id }| COLOR COL_NEGATIVE.
RETURN.ENDIF.SELECT SINGLE guid_set INTO @DATA(setguid) FROM crmd_link
WHERE guid_hi = @guid AND objtype_set = '29'.CHECK sy-subrc = 0.SELECT * INTO TABLE @DATA(lt_osset) FROM crmd_srv_osset
WHERE guid_set = @setguid.CHECK sy-subrc = 0.SELECT * INTO TABLE @DATA(lt_refobj) FROM crmd_srv_refobj FOR ALL ENTRIES IN @lt_osset
WHERE guid_ref = @lt_osset-guid.LOOP AT lt_refobj ASSIGNING FIELD-SYMBOL(<obj>).
cl_crm_1order_set_print_tool=>print_structure( <obj> ).ENDLOOP.
Specify the order ID and type:
If this order has reference product assigned, the product information will be printed out:
You may observe that every time you create a new Service Order with transaction type SRVO, there will automatically be two entries generated in table CRMD_SRV_OSSET, one for subject_profile SERVICE and the other for ACT00001.
The two profiles are configured via the following customizing:
要獲取更多Jerry的原創文章,請關注公眾號"汪子熙":
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/24475491/viewspace-2715903/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- SAP CRM資料庫表CRMD_CUMULAT_H的設計原理資料庫
- SAP CRM訂單資料庫表CRMD_SHIPPING的填充原理資料庫
- CRM, C4C和SAP Hybris的資料庫層設計資料庫
- SAP CRM One Order header資料庫表幾個和時間戳相關的欄位Header資料庫時間戳
- SAP中的資料庫表索引資料庫索引
- SAP CRM中介軟體下載時資料庫表CRMATAB為空的處理方法資料庫
- Salesforce和SAP Netweaver裡資料庫表的後設資料設計Salesforce資料庫
- SAP CRM和C4C資料同步的兩種方式概述:SAP PI和HCI
- CRM資料庫表COM_TA_R3_ID的資料來源資料庫
- 在SAP HANA Express Edition裡建立資料庫表Express資料庫
- SAP Hybris Commerce裡的資料庫表資料庫
- SQL建立資料庫和表SQL資料庫
- 8使用資料庫和表資料庫
- SAP CRM銷售訂單UI上的欄位對應的資料庫表儲存欄位:requested start date和end dateUI資料庫
- 【SAP HANA】新建賬戶和資料庫(2)資料庫
- SAP Netweaver和Hybris的資料庫層資料庫
- 資料庫和表空間資料移動資料庫
- 如何使用程式碼建立和讀取 SAP CRM 訂單的 Text 資料
- SAP CRM和C4C的產品主資料price維護
- SAP資料庫的分析資料庫
- SAP ABAP資料表的操作
- SAP CRM Fiori應用和SAP JAM的整合配置
- 【資料庫資料恢復】SAP資料庫資料恢復案例資料庫資料恢復
- SAP CRM和Cloud for Customer的擴充套件欄位後設資料Cloud套件
- SAP HANA Cloud 學習教程之二: 如何往SAP BTP 上 HANA Cloud 資料庫表裡插入資料Cloud資料庫
- 織夢資料庫表結構_Dedecms資料庫表和欄位詳細介紹資料庫
- MyBatis Java 和 資料庫 資料型別對應表MyBatisJava資料庫資料型別
- SAP資料庫的劃分資料庫
- 「SAP技術」SAP MM MB5M報表不顯示特殊庫存資料
- SAP供應商主資料表
- SAP CRM產品主資料應用裡value node和model node的轉換
- 如何自行查詢出 SAP ABAP 標準的 OData 服務返回資料的後臺資料庫表和表欄位名稱資料庫
- 如何建立自己的SAP CRM產品主資料search scenario
- CRM資料分析的目的和作用
- SAP ABAP裡資料庫表的Storage Parameters從哪裡來的資料庫
- 建立資料庫表資料庫
- 資料庫分庫分表資料庫
- SAP SE16N 修改表資料