The following non-unique indices should be created in the database in the SAP system because they considerably speed up the extraction process or, depending on the amount of data, they facilitate extraction within an acceptable time frame. The names of the data sources benefitting from the corresponding index are specified in parentheses.
You may need to create further indices depending on how you want to modify or extend the configurations contained in the Content Package.
BKPF table
Index on MANDT, CPUDT (ACCOUNTING, LOG_INVOICE_ACCOUNTING_HIER)
Index on MANDT, AEDAT (ACCOUNTING, LOG_INVOICE_ACCOUNTING_HIER)
Index on MANDT, UPDDT (ACCOUNTING, LOG_INVOICE_ACCOUNTING_HIER)
Index on MANDT, AWTYP (ACCOUNTING, LOG_INVOICE_ACCOUNTING_HIER)
BSAK table
Index for MANDT, CPUDT (CLEARING)
Index on MANDT, BUKRS, BELNR (CLEARING)
CDHDR table
Index on MANDT, UDATE (CHG_RBKP_BLOCKED)
EBAN table
Index on MANDT, ERDAT (PO_REQUISITION)
EKEK table
Index on MANDT, ERDAT (DELIVERY_SCHEDULE_CALL)
EKPO table
Index on MANDT, AEDAT (PURCHASE_ORDER)
LTAK table
Index for MANDT, BDATU (WM_TRANSFER_ORDER)
LTBK table
Index on MANDT, BDATU (TRANSFER_REQUIREMENT)
LIPS table
Index on MANDT, ERDAT (DELIVERY)
Index on MANDT, AEDAT (DELIVERY)
MKPF table
Index on MANDT, CPUDT (MATERIAL_DOCUMENT)
RBKP table
Index on MANDT, CPUDT (LOGISTIC_INVOICE, LOGISTIC_INVOICE_HEADER)