Skip to Content
0
Jun 06, 2018 at 09:22 AM

ETL: Shopping Cart Approvers - base tables and logic required to populate SC approver

77 Views

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.