Create table indices

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)