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 for MANDT, CPUDT (ACCOUNTING, BILLING_ACCOUNTING_HIER)
Index for MANDT, AEDAT (ACCOUNTING, BILLING_ACCOUNTING_HIER)
Index for MANDT, UPDDT (ACCOUNTING, BILLING_ACCOUNTING_HIER)
Index for MANDT, AWTYP (ACCOUNTING, BILLING_ACCOUNTING_HIER)
BSAD table
Index for MANDT, CPUDT (CLEARING)
CDHDR table
Index on MANDT, UDATE (SALES_ITEM_DELETED)
LIPS table
Index for MANDT, ERDAT (DELIVERY, PURCHASE_ORDER_DELIVERY)
Index for MANDT, AEDAT (DELIVERY, PURCHASE_ORDER_DELIVERY)
Index for MANDT, VGBEL (PURCHASE_ORDER_DELIVERY)
LTAK table
Index for MANDT, BDATU (WM_TRANSFER_ORDER)
MKPF table
Index for MANDT, CPUDT (GOODS_RECEIPT_PO)
VBAP table
Index for MANDT, ERDAT (SALES)
Index for MANDT, AEDAT (SALES)
VBAK table
Index for MANDT, AEDAT (SALES_HEADER, SALES_ITEM_HEADER_CHANGES)
VBFA table
Index for MANDT, ERDAT (MATERIAL_DOCUMENT, PICK_ORDER, SERVICE_CONFIRMATION)
Index for MANDT, AEDAT (MATERIAL_DOCUMENT, PICK_ORDER, SERVICE_CONFIRMATION)
Index for MANDT, VBTYP_N (MATERIAL_DOCUMENT, PICK_ORDER, SERVICE_CONFIRMATION)
Index for MANDT, VBELN (MATERIAL_DOCUMENT)
VBRK table
Index for MANDT, ERDAT (BILLING)
Index for MANDT, AEDAT (BILLING)
VTTP table
Index for MANDT, ERDAT (DELIVERY_SHIPMENT_HIER, SHIPMENT)