ATP Pegging Info in custom Report

Hello VCP Experts,

We have a requirement to create a custom Report for pegging information.

To be exact, following fields should be present in my report.

• Pegged Supply 1:  This represents the first supply pegged to the sales order
  • Pegged Supply 1

First supply that can fulfil request quantity e.g. On-hand; Purchase Order; Internal Requisition

• Pegged Supply (1) Number

First Supply Reference Number. If On-hand = blank, if Purchase Order = Purchase Order number.

• Pegged Supply (1) Quantity

First supply quantity that can fulfil request quantity

• Available Date

Date when the first supply quantity is available. If On-hand the date will be the Request Date and if Purchase order, the date will be promise date of Purchase order