# Standard PreBilt Reports

## PreBilt usage report

Transaction _PB2\_ANALYTICS\_PB\_001_ is used to monitor information gathered in the PreBilt App Usage Report.

<table data-header-hidden><thead><tr><th>Tile Description</th><th>Intended Use</th><th>RAG Limits</th><th valign="top">SAP transaction</th></tr></thead><tbody><tr><td><strong>Tile description</strong></td><td><strong>Intended use</strong></td><td><strong>RAG limits</strong></td><td valign="top"><strong>SAP transaction</strong></td></tr><tr><td>Number of Users Logged in</td><td><p>This tile counts the number of unique SAP usernames that have logged using PreBilt.</p><p>The chart displays counts for all usernames logged in and the source data displays usernames and date/time of login.</p></td><td><p>Green: &#x3C;30</p><p>Amber: 30-100</p><p>Red: >100</p></td><td valign="top">/TCTM/WM_APP_USAGE</td></tr><tr><td>Total Logins by Date</td><td><p>This tile shows a count of total number of logins using PreBilt.</p><p>The chart displays a breakdown of those logins by date.</p><p>The source data displays usernames and date/time of login.</p></td><td><p>Red: &#x3C;50</p><p>Amber: 50-100</p><p>Green: >100</p></td><td valign="top">/TCTM/WM_APP_USAGE</td></tr><tr><td>Transactions Started</td><td><p>The tile displays a count of all PreBilt transactions started by all users.</p><p>The chart displays a breakdown of the counts by transaction.</p><p>The source data displays the transaction, username, date and time.</p></td><td><p>Red: &#x3C;500</p><p>Amber: 500-5000</p><p>Green: >5000</p></td><td valign="top">/TCTM/WM_APP_USAGE</td></tr><tr><td>IM Picks Completed</td><td><p>The tile shows all IM pick confirmations completed.</p><p>The chart displays the number of picks completed by username.</p><p>The source data then shows pick date and time for each user.</p></td><td><p>Red: &#x3C;30</p><p>Amber: 30-100</p><p>Green: >100</p></td><td valign="top">/TCTM/WM_APP_USAGE</td></tr><tr><td>WM Picks Completed</td><td><p>The tile shows all WM Stock Movements completed in a Picking transaction in PreBilt.</p><p>The chart displays the number of picks completed by date.</p><p>The source data then shows the transaction, username, date and time of each stock movement.</p></td><td><p>Red: &#x3C;30</p><p>Amber: 30-100</p><p>Green: >100</p></td><td valign="top">/TCTM/WM_APP_USAGE</td></tr><tr><td>WM Transfer Order Confirmations</td><td><p>The tile shows all WM Stock Movements confirmed excluding those completed in the picking transactions in PreBilt.</p><p>The chart displays the number of picks completed by date.</p><p>The source data then shows the transaction, username, date and time of each stock movement.</p></td><td><p>Red: &#x3C;30</p><p>Amber: 30-100</p><p>Green: >100</p></td><td valign="top">/TCTM/WM_APP_USAGE</td></tr><tr><td>PI Items Counted</td><td><p>The tile shows a total of PI item counts completed.</p><p>The chart displays the total number of counts by date.</p><p>The source data displays the transaction used, username, date and time of the count.</p></td><td><p>Red: &#x3C;30</p><p>Amber: 30-100</p><p>Green: >100</p></td><td valign="top">/TCTM/WM_APP_USAGE</td></tr></tbody></table>

## Warehouse Activity Monitor

Transaction _PB2\_ANALYTICS\_WM\_001_ is used to monitor activities in the warehouse. These tiles use standard SAP transaction _LL01_ functionality to display warehouse transactions that need to be completed.

<table data-header-hidden><thead><tr><th>Tile description</th><th>Intended use</th><th>RAG limits</th><th valign="top">SAP transaction</th></tr></thead><tbody><tr><td><strong>Tile description</strong></td><td><strong>Intended use</strong></td><td><strong>RAG limits</strong></td><td valign="top"><strong>SAP transaction</strong></td></tr><tr><td>Transfer Orders – Open for confirmation</td><td><p>There is a count of unconfirmed transfer orders (TO). This data is presented in charts, as the number of unconfirmed TOs by movement type.</p><p>Source data can display TO number, TO item, movement type, source storage type and destination storage type.</p></td><td><p>Green: &#x3C;49</p><p>Amber: 49-99</p><p>Red: >99</p></td><td valign="top">LL01</td></tr><tr><td>Posting Change Notices – Open</td><td><p>This tile displays a count of open posting change notices. This data is presented in charts, as the number of open posting change notices by movement type.</p><p>Source data can display posting change number, movement type and the date and time that the posting change was refreshed.</p></td><td><p>Green: &#x3C;99</p><p>Amber: 79-199</p><p>Red: >199</p></td><td valign="top">LL01</td></tr><tr><td>Critical Deliveries – Open</td><td><p>This tile displays a count of critical deliveries that need to be goods issued. This data is presented in charts, as the number of open deliveries by status.</p><p>(A = ‘Not yet processed’, B = ‘Partially processed’).</p><p>Source data can display delivery number and status.</p><p> </p><p> </p></td><td><p>Green: &#x3C;4</p><p>Amber: 4-9</p><p>Red: >9</p></td><td valign="top">LL01</td></tr><tr><td>Negative Stocks - Existing</td><td><p>This tile displays a count of the number of negative quants in interim storage types. This data is presented in charts, as the number of quants with negative stock by storage type.</p><p>Source data can display quant and storage type.</p></td><td><p>Green: &#x3C;4</p><p>Amber: 4-9</p><p>Red: >9</p></td><td valign="top">LL01</td></tr><tr><td>Interim Storage Stock – Without Movement</td><td><p>This tile displays a count of quants of stock in interim storage types. This data is presented in charts, as the number of quants by storage type.</p><p>Source data can display the quant number in the storage type.</p></td><td><p>Green: &#x3C;9</p><p>Amber: 9-19</p><p>Red: >19</p></td><td valign="top">LL01</td></tr><tr><td>Transfer Reqs – Open</td><td><p>This tile displays open transfer requirements. This data is presented in charts, as the number of open transfer requirements by movement type.</p><p>Source data can display open TRs by movement type.</p></td><td><p>Green: &#x3C;399</p><p>Amber: 399-699</p><p>Red: >699</p></td><td valign="top">LL01</td></tr><tr><td>Production Supply – Critical supply</td><td><p>This tile displays a count of quants for production supply. Data is presented in charts, as the number of quants by storage type.</p><p>Source data can display quant and storage type.</p></td><td><p>Green: &#x3C;9</p><p>Amber: 4-9</p><p>Red: >9</p></td><td valign="top">LL01</td></tr></tbody></table>

## Transfer order report

Transaction _PB2\_ANALYTICS\_WM\_002_ is used to monitor open picks and open putaways.

<table data-header-hidden><thead><tr><th>Tile description</th><th>Intended use</th><th>RAG limits</th><th valign="top">SAP transaction</th></tr></thead><tbody><tr><td><strong>Tile description</strong></td><td><strong>Intended use</strong></td><td><strong>RAG limits</strong></td><td valign="top"><strong>SAP transaction</strong></td></tr><tr><td>Open Picks – Movement Type 601</td><td><p>This tile displays unconfirmed transfer orders (TO) with movement type 601 – GI to delivery note. Data is presented in charts, as the number of picks by source storage type.</p><p>Source data can display destination storage type, destination storage bin, TO number, item, material, source storage type, source storage bin and source target quantity.</p></td><td><p>Green: &#x3C;50</p><p>Amber: 50-100</p><p>Red: >100</p></td><td valign="top">LT23</td></tr><tr><td>Open Putaways – Movement Type 101</td><td><p>This tile displays unconfirmed transfer orders (TO) with source storage type 902 – GR Area External Receipts. Data is presented in charts, as the number of putaways by destination storage type.</p><p>Source data can display material, destination storage type, destination storage bin, TO number, item, source storage type, source storage bin and source target quantity.</p></td><td><p>Green: &#x3C;50</p><p>Amber: 50-100</p><p>Red: >100</p></td><td valign="top">LT23</td></tr></tbody></table>

## WM physical inventory

Transaction _PB2\_ANALYTICS\_WM\_003_ is used to monitor open PI documents that are inventory active and inactive, as well as inventory active quants.

<table data-header-hidden><thead><tr><th>Tile description</th><th>Intended use</th><th>RAG limits</th><th valign="top">SAP transaction</th></tr></thead><tbody><tr><td><strong>Tile description</strong></td><td><strong>Intended use</strong></td><td><strong>RAG limits</strong></td><td valign="top"><strong>SAP transaction</strong></td></tr><tr><td>WM Inventory IA Docs – IA PI Documents</td><td><p>This tile displays inventory active documents, which are not counted or partially counted. Data is presented in charts, as open PI counts by storage type.</p><p>Source data can display inventory record, storage type and count date.</p></td><td><p>Green: &#x3C;10</p><p>Amber: 10-50</p><p>Red: >50</p></td><td valign="top">LX22</td></tr><tr><td>WM Inventory Inactive Docs – Inactive Documents</td><td><p>This tile displays only non-activated inventory documents, which are not counted or partially counted. Data is presented in charts, as inactive PI counts by storage type and status.</p><p>Source data can display inventory record, storage type, count date and inventory status.</p></td><td><p>Green: 0</p><p>Red: >0</p></td><td valign="top">LX22</td></tr><tr><td>WM Inventory Active Items – IA Items by Bin</td><td><p>This tile displays inventory active quants in all storage types and within inventory method PZ to ST. Data is presented in charts, as active quants counts by storage type and status.</p><p>Source data can display inventory record, inventory item, storage type, count date bin section and the number of storage units.</p></td><td><p>Green: &#x3C;10</p><p>Amber: 10-50</p><p>Red: >50</p></td><td valign="top">LX03</td></tr></tbody></table>

## Analytics by user

Transaction _PB2\_ANALYTICS\_WM\_004_ is used to compare transfer orders that have been confirmed by all SAP users in the warehouse and the SAP user account currently logged in to the device.

<table data-header-hidden><thead><tr><th>Tile description</th><th>Intended use</th><th>RAG limits</th><th valign="top">SAP transaction</th></tr></thead><tbody><tr><td><strong>Tile description</strong></td><td><strong>Intended use</strong></td><td><strong>RAG limits</strong></td><td valign="top"><strong>SAP transaction</strong></td></tr><tr><td>Confirmed by Me</td><td><p>This tile displays all transfer order picks confirmed by the current logged in user on the device.</p><p> </p></td><td><p>Green: &#x3C;30</p><p>Amber: 30-100</p><p>Red: >100</p></td><td valign="top">LT23</td></tr><tr><td>Confirmed by Everyone Else</td><td><p>This tile displays all transfer order picks confirmed by all users in the current active warehouse on the device.</p><p> </p></td><td><p>Green: &#x3C;300</p><p>Amber: 300-1000</p><p>Red: >1000</p></td><td valign="top">LT23</td></tr></tbody></table>

## Outbound deliveries

Transaction _PB2\_ANALYTICS\_SD\_001_ is used to monitor open transactions for both Inbound and Outbound deliveries.

<table data-header-hidden><thead><tr><th>Tile description</th><th>Intended use</th><th>RAG limits</th><th valign="top">SAP transaction</th></tr></thead><tbody><tr><td><strong>Tile description</strong></td><td><strong>Intended use</strong></td><td><strong>RAG limits</strong></td><td valign="top"><strong>SAP transaction</strong></td></tr><tr><td>Outbound Deliveries – For Confirmation</td><td><p>This tile displays outbound deliveries for confirmation. Data is presented in charts, as a count of deliveries by customer and delivery date.</p><p>Source data can display the delivery number, ship-to party and total goods movement status.</p></td><td><p>Green: &#x3C;10</p><p>Amber: 10-50</p><p>Red: >50</p></td><td valign="top">VL06</td></tr><tr><td>Outbound Deliveries – Pallets Picked, &#x3C;30 days</td><td><p>This tile displays pallets picked in the last 30 days for the relevant shipping point. Data is presented in charts, as a count of pallets picked by customer and delivery date.</p><p>Source data can display the delivery number, ship-to party and number of packages.</p></td><td><p>Red: &#x3C;10</p><p>Amber: 10-150</p><p>Green: >150</p></td><td valign="top">VL06F</td></tr><tr><td>Inbound Deliveries – For Confirmation, next 7 days.</td><td><p>This tile displays inbound deliveries in the next seven days. The putaway information in the SAP source data is checked at header level and a shipping point/receiving point is required.  Data is presented in charts, as the count of deliveries by vendor/delivery date.</p><p>Source data can display delivery number and delivery date.</p></td><td><p>Green: &#x3C;3</p><p>Amber: 3-5</p><p>Red: >5</p></td><td valign="top">VL06IF</td></tr><tr><td>Inbound Deliveries – Last 3 months</td><td><p>This tile displays inbound deliveries in the last three months. The putaway information in the SAP source data is checked at header level for the relevant shipping point/receiving point.  Data is presented in charts, as the count of deliveries by vendor.</p><p>Source data can display document number, delivery date and number of packages.</p></td><td><p>Red: &#x3C;10</p><p>Amber: 10-50</p><p>Green: >50</p></td><td valign="top">VL06IF</td></tr><tr><td>Deliveries for Goods Issue - Open</td><td><p>This tile displays open deliveries for goods issue for the relevant shipping point. Data is presented in charts, as the count of deliveries by goods issue date.</p><p>Source data can display outbound delivery, date and the name of the ship-to party.</p></td><td><p>Green: &#x3C;10</p><p>Amber: 10-50</p><p>Red: >50</p></td><td valign="top">VL06G</td></tr></tbody></table>

## IM activity monitor

Transaction _PB2\_ANALYTICS\_IM\_001_ is used to monitor activity in or out of inventory managed storage locations, where appropriate, within a defined time period.

<table data-header-hidden><thead><tr><th>Tile description</th><th>Intended use</th><th>RAG limits</th><th valign="top">SAP transaction</th></tr></thead><tbody><tr><td><strong>Tile description</strong></td><td><strong>Intended use</strong></td><td><strong>RAG limits</strong></td><td valign="top"><strong>SAP transaction</strong></td></tr><tr><td>Vendor Receipts – 101 – Receipts in last 7 days</td><td><p>This tile displays vendor receipts with a movement type of 101, in the last seven days. Data is presented in charts, as count of documents processed by materials received.</p><p>Source data can display material, posting date, the username of the user who posted the receipt, quantity of the material receipted in the relevant unit of measure and the purchasing document number.</p></td><td><p>Red: &#x3C;10</p><p>Amber: 10-30</p><p>Green: >30</p></td><td valign="top">MB51</td></tr><tr><td>Issue to Order – 261 – Issues in last 7 days</td><td><p>This tile displays goods issue for order with a movement type 261, in the last 7 days. Data is presented in charts, as count of documents posted by materials issued.</p><p>Source data can display material, posting date, the username of the user who posted the receipt, quantity of the material receipted and its unit of measure and movement type.</p></td><td><p>Red: &#x3C;10</p><p>Amber: 10-30</p><p>Green: >30</p></td><td valign="top">MB51</td></tr><tr><td>Issue to Cost Centre – 201 – Issues in last 7 days</td><td><p>This tile displays goods issued to cost centres with a movement type 201, in the last seven days. Data is presented in charts, as count of documents posted by posting date.</p><p>Source data can display material, posting date, the username of the user who posted the receipt, quantity of the material receipted in the relevant unit of measure and movement type.</p></td><td><p>Red: &#x3C;10</p><p>Amber: 10-30</p><p>Green: >30</p></td><td valign="top">MB51</td></tr><tr><td>Storage Location Moves – 311 – Moves in last 7 days</td><td><p>This tile displays transfers within the plant with a movement type 311, in the last seven days. Data is presented in charts, as count of documents posted by posting date.</p><p>Source data can display material, posting date, the username of the user who posted the receipt, quantity of the material receipted and its unit of measure, storage location and movement type.</p></td><td><p>Green: 0</p><p>Amber: 0-10</p><p>Red: >10</p></td><td valign="top">MB51</td></tr><tr><td>Scrapping – In last 7 days</td><td><p>This tile displays transfers to scrapping with movement types 551, 553 or 555, (write offs of unrestricted, quality or blocked stock respectively) in the last seven days. Data is presented in charts, as count of documents posted by posting date and movement type.</p><p>Source data can display material document, material, posting date, the user who posted the document, quantity of the material scrapped and its unit of measure, storage location and movement type.</p></td><td><p>Green: 0</p><p>Amber: 0-5</p><p>Red: >5</p></td><td valign="top">MB51</td></tr><tr><td>IM PI Documents – Open PI Items by Document</td><td><p>This tile displays PI documents where the item is not yet counted. Data is presented in charts, as count of PI items per document by planned count date and PI document.</p><p>Source data can display physical inventory document, plant, storage location, material and planned count date.</p></td><td><p>Green: &#x3C;10</p><p>Amber: 10-200</p><p>Red: >200</p></td><td valign="top">MI22</td></tr><tr><td>IM PI Materials – Open PI Items by Material</td><td><p>This tile displays PI documents where the item is not yet counted in storage locations 1000 - 1002. Data is presented in charts, as count of open PI items per materials.</p><p>Source data can display physical inventory document, plant, storage location, material, batch and planned count date.</p></td><td><p>Green: &#x3C;10</p><p>Amber: 10-200</p><p>Red: >200</p></td><td valign="top">MI22</td></tr><tr><td>Outbound Deliveries – Pallets Picked</td><td><p>This tile displays pallets picked in the last 30 days. The report requires a shipping point.  Data is presented in charts, as a sum of pallets picked by customer and delivery date.</p><p>Source data can display the delivery number, ship-to party and number of packages.</p><p> </p><p> </p><p> </p></td><td><p>Red: &#x3C;10</p><p>Amber: 10-50</p><p>Green: >50</p></td><td valign="top">VL06F</td></tr><tr><td>Damaged Stock – In Quarantine Storage Loc</td><td><p>This tile displays stock in a storage location designated for damaged stock. Data is presented in charts, as a count of material/batches by storage location, plant and material.</p><p>Source data can display the material and quantity in the relevant unit of measure.</p></td><td><p>Green: &#x3C;4</p><p>Amber: 4-20</p><p>Red: >20</p></td><td valign="top">MB52</td></tr></tbody></table>

## IM physical inventory

Transaction _PB2\_ANALYTICS\_IM\_002_ is used to monitor the number of open inventory items by PI document and by material.

<table data-header-hidden><thead><tr><th>Tile description</th><th>Intended use</th><th>RAG limits</th><th valign="top">SAP transaction</th></tr></thead><tbody><tr><td><strong>Tile description</strong></td><td><strong>Intended use</strong></td><td><strong>RAG limits</strong></td><td valign="top"><strong>SAP transaction</strong></td></tr><tr><td>IM PI Documents – Open PI Items by Document</td><td><p>This tile uses transaction MI22 to display PI documents where the item is not yet counted within the relevant plant and storage locations. Data is presented in charts as count of PI items per document by planned count date and PI document.</p><p>Source data can display physical inventory document, plant, storage location, material and planned count date.</p></td><td><p>Green: &#x3C;10</p><p>Amber: 10-200</p><p>Red: >200</p></td><td valign="top">MI22</td></tr><tr><td>IM PI Materials – Open PI Items by Material</td><td><p>This tile uses transaction MI22 to count items not yet counted within the relevant plant and storage locations. Data is presented in charts as a count of open PI items per material.</p><p>Source data can display physical inventory document, plant, storage location, material and planned count date.</p></td><td><p>Green: &#x3C;10</p><p>Amber: 10-200</p><p>Red: >200</p></td><td valign="top">MI22</td></tr></tbody></table>

## IMMB movements

Transaction _PB2\_ANALYTICS\_IMMB01_ is used to monitor open picks and putaways when using the IM Multi Bin PreBilt functionality.

<table data-header-hidden><thead><tr><th>Tile description</th><th>Intended use</th><th>RAG limits</th><th valign="top">SAP transaction</th></tr></thead><tbody><tr><td><strong>Tile description</strong></td><td><strong>Intended use</strong></td><td><strong>RAG limits</strong></td><td valign="top"><strong>SAP transaction</strong></td></tr><tr><td>Open Putaways – Today</td><td><p>This tile displays all stock in a specified plant in dynamic storage bins, which are created from a goods receipt from vendor.  Data is presented in charts, as the count of receipts not putaway by material number.</p><p>Source data can display purchase order number, material, quantity and unit of measure.</p></td><td><p>Green: 0</p><p>Amber: 1-5</p><p>Red: >5</p></td><td valign="top">/TCTM/IMB_STK</td></tr><tr><td>For Goods Issue - Today</td><td><p>This tile displays the number of picks on deliveries that have not been goods issued, with the stock in a dynamic storage bin, which represents the outbound delivery number. Data is presented in charts, as the count of outbound deliveries by material number.</p><p>Source data can display delivery number, material, quantity and unit of measure.</p></td><td><p>Green: 0</p><p>Amber: 1-5</p><p>Red: >5</p></td><td valign="top">/TCTM/IMB_LQUA</td></tr></tbody></table>
