Log history data

With the following parameters, you can determine if, when, and how history data must be logged in Procurement:

Purchase requisitions
FieldSession
Log Requisition HistoryPurchase Requisition Parameters (tdpur0100m200)
Purchase contracts
Log Contract TransactionsPurchase Contract Parameters (tdpur0100m300)
Log Contract Line TransactionsPurchase Contract Parameters (tdpur0100m300)
Purchase schedules
Log Schedule HistoryPurchase Contract Parameters (tdpur0100m300)
Level of Intake LoggingPurchase Contract Parameters (tdpur0100m300)
Log Actual Schedule Receipt HistoryPurchase Contract Parameters (tdpur0100m300)
Purchase orders
Log Order HistoryPurchase Order Parameters (tdpur0100m400)
Start Logging History atPurchase Order Parameters (tdpur0100m400)
Level of Intake LoggingPurchase Order Parameters (tdpur0100m400)
Log Actual Order Receipt HistoryPurchase Order Parameters (tdpur0100m400)

 

With the following parameters, you can determine if, when, and how history data must be logged in Sales:

Sales quotations
FieldSession
Log Quotation HistorySales Quotation Parameters (tdsls0100s100)
Sales contracts
Log Contract Header TransactionsSales Contract Parameters (tdsls0100s300)
Log Contract Line TransactionsSales Contract Parameters (tdsls0100s300)
Sales schedules
Log Schedule HistorySales Contract Parameters (tdsls0100s300)
Level of Intake LoggingSales Contract Parameters (tdsls0100s300)
Log Actual Schedule Delivery HistorySales Contract Parameters (tdsls0100s300)
Sales orders
Log Order HistorySales Order Parameters (tdsls0100s400)
Log EDI Order HistorySales Order Parameters (tdsls0100s400)
Start Logging History atSales Order Parameters (tdsls0100s400)
Level of Intake LoggingSales Order Parameters (tdsls0100s400)
Log Actual Order Delivery HistorySales Order Parameters (tdsls0100s400)
Log Component HistorySales Order Parameters (tdsls0100s400)
Sales order installments
FieldRetrieved from session
Log Order HistorySales Order Parameters (tdsls0100s400)
Log EDI Order HistorySales Order Parameters (tdsls0100s400)
Start Logging History atSales Order Parameters (tdsls0100s400)
Level of Intake LoggingSales Order Parameters (tdsls0100s400)

 

Logging history data decreases performance and increases data growth. Therefore, the following applies to logging history data:

  • Only log history if required.
  • Regularly archive and delete history data.
Note

Purchase order and sales order/schedule history are not only used for future analysis, but also for reconciliation, retrobilling, commissions and rebates, and statistics. To increase performance and decrease data growth, after the history records are processed for commissions, rebates, and statistics, and after the reconciliation period is closed, archive and delete the relevant purchase orders and sales orders.

Performance aspects
  • Effect on CPU: Yes
  • Effect on database growth: Yes