Hi Experts,
Please help me to extract SC Approver from SRM.
my requirement is to extract SC Approver from SRM using base tables. I used below refreneced tables to get the report structure.
ORD_ADM_HDR
ORD_ADM_ITM
BBP_PTNR_VIEW
COM_PRODUCT
BUSPARTNER
CRHD_PDBEI
the joins used are
DEL_ORD_HDR.GUID_HDR =DEL_ORD_ITM.HEADER
Query_1.HEADER = DEL_PTNR_VIEW.GUID_HI or Query_1.GUID_ITM = DEL_PTNR_VIEW.GUID_HI
Query_2.ITM_PRODUCT_ID = DEL_PRODUCT.PRODUCT_GUID
Query_3.PARTNER_NO = Query_2.PARTNER_GUID
Query_4.GUID_ITM = DEL_PDBEI.GUID
to populate below Field structure.
SC_NUMBER
PROCESS_TYPE
SC_DATE
DESCRIPTION
CREATED_AT
CREATED_BY
ITM_PRODUCT_ID
ITM_BE_OBJ_TYPE
ITM_REQUEST_EMPNO
APPROVER_EMPNO
ITM_BE_OBJ_ITEM
ITM_BE_OBJECT_ID
The issue here is I dont know how to populate the Approver Id against each shopping cart. so it will be much appreciated if you can help me in populating Approver Id information, and adding to it, I am using SAP Data services to do ETL from SAP SRM system. I came to know about the BBP Function modules but that is not usable here, as w have more custom tables defined for org structure and approval levels. Your thoughs and knowledge will be much appreciated.