Standard PreBilt Reports

PreBilt usage report

Transaction PB2_ANALYTICS_PB_001 is used to monitor information gathered in the PreBilt App Usage Report.

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

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.

Tile description	Intended use	RAG limits	SAP transaction
Transfer Orders – Open for confirmation	There is a count of unconfirmed transfer orders (TO). This data is presented in charts, as the number of unconfirmed TOs by movement type. Source data can display TO number, TO item, movement type, source storage type and destination storage type.	Green: <49 Amber: 49-99 Red: >99	LL01
Posting Change Notices – Open	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. Source data can display posting change number, movement type and the date and time that the posting change was refreshed.	Green: <99 Amber: 79-199 Red: >199	LL01
Critical Deliveries – Open	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. (A = ‘Not yet processed’, B = ‘Partially processed’). Source data can display delivery number and status.	Green: <4 Amber: 4-9 Red: >9	LL01
Negative Stocks - Existing	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. Source data can display quant and storage type.	Green: <4 Amber: 4-9 Red: >9	LL01
Interim Storage Stock – Without Movement	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. Source data can display the quant number in the storage type.	Green: <9 Amber: 9-19 Red: >19	LL01
Transfer Reqs – Open	This tile displays open transfer requirements. This data is presented in charts, as the number of open transfer requirements by movement type. Source data can display open TRs by movement type.	Green: <399 Amber: 399-699 Red: >699	LL01
Production Supply – Critical supply	This tile displays a count of quants for production supply. Data is presented in charts, as the number of quants by storage type. Source data can display quant and storage type.	Green: <9 Amber: 4-9 Red: >9	LL01

Transfer order report

Transaction PB2_ANALYTICS_WM_002 is used to monitor open picks and open putaways.

Tile description	Intended use	RAG limits	SAP transaction
Open Picks – Movement Type 601	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. Source data can display destination storage type, destination storage bin, TO number, item, material, source storage type, source storage bin and source target quantity.	Green: <50 Amber: 50-100 Red: >100	LT23
Open Putaways – Movement Type 101	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. Source data can display material, destination storage type, destination storage bin, TO number, item, source storage type, source storage bin and source target quantity.	Green: <50 Amber: 50-100 Red: >100	LT23

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.

Tile description	Intended use	RAG limits	SAP transaction
WM Inventory IA Docs – IA PI Documents	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. Source data can display inventory record, storage type and count date.	Green: <10 Amber: 10-50 Red: >50	LX22
WM Inventory Inactive Docs – Inactive Documents	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. Source data can display inventory record, storage type, count date and inventory status.	Green: 0 Red: >0	LX22
WM Inventory Active Items – IA Items by Bin	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. Source data can display inventory record, inventory item, storage type, count date bin section and the number of storage units.	Green: <10 Amber: 10-50 Red: >50	LX03

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.

Tile description	Intended use	RAG limits	SAP transaction
Confirmed by Me	This tile displays all transfer order picks confirmed by the current logged in user on the device.	Green: <30 Amber: 30-100 Red: >100	LT23
Confirmed by Everyone Else	This tile displays all transfer order picks confirmed by all users in the current active warehouse on the device.	Green: <300 Amber: 300-1000 Red: >1000	LT23

Outbound deliveries

Transaction PB2_ANALYTICS_SD_001 is used to monitor open transactions for both Inbound and Outbound deliveries.

Tile description	Intended use	RAG limits	SAP transaction
Outbound Deliveries – For Confirmation	This tile displays outbound deliveries for confirmation. Data is presented in charts, as a count of deliveries by customer and delivery date. Source data can display the delivery number, ship-to party and total goods movement status.	Green: <10 Amber: 10-50 Red: >50	VL06
Outbound Deliveries – Pallets Picked, <30 days	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. Source data can display the delivery number, ship-to party and number of packages.	Red: <10 Amber: 10-150 Green: >150	VL06F
Inbound Deliveries – For Confirmation, next 7 days.	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. Source data can display delivery number and delivery date.	Green: <3 Amber: 3-5 Red: >5	VL06IF
Inbound Deliveries – Last 3 months	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. Source data can display document number, delivery date and number of packages.	Red: <10 Amber: 10-50 Green: >50	VL06IF
Deliveries for Goods Issue - Open	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. Source data can display outbound delivery, date and the name of the ship-to party.	Green: <10 Amber: 10-50 Red: >50	VL06G

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.

Tile description	Intended use	RAG limits	SAP transaction
Vendor Receipts – 101 – Receipts in last 7 days	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. 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.	Red: <10 Amber: 10-30 Green: >30	MB51
Issue to Order – 261 – Issues in last 7 days	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. 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.	Red: <10 Amber: 10-30 Green: >30	MB51
Issue to Cost Centre – 201 – Issues in last 7 days	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. 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.	Red: <10 Amber: 10-30 Green: >30	MB51
Storage Location Moves – 311 – Moves in last 7 days	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. 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.	Green: 0 Amber: 0-10 Red: >10	MB51
Scrapping – In last 7 days	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. 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.	Green: 0 Amber: 0-5 Red: >5	MB51
IM PI Documents – Open PI Items by Document	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. Source data can display physical inventory document, plant, storage location, material and planned count date.	Green: <10 Amber: 10-200 Red: >200	MI22
IM PI Materials – Open PI Items by Material	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. Source data can display physical inventory document, plant, storage location, material, batch and planned count date.	Green: <10 Amber: 10-200 Red: >200	MI22
Outbound Deliveries – Pallets Picked	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. Source data can display the delivery number, ship-to party and number of packages.	Red: <10 Amber: 10-50 Green: >50	VL06F
Damaged Stock – In Quarantine Storage Loc	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. Source data can display the material and quantity in the relevant unit of measure.	Green: <4 Amber: 4-20 Red: >20	MB52

IM physical inventory

Transaction PB2_ANALYTICS_IM_002 is used to monitor the number of open inventory items by PI document and by material.

Tile description	Intended use	RAG limits	SAP transaction
IM PI Documents – Open PI Items by Document	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. Source data can display physical inventory document, plant, storage location, material and planned count date.	Green: <10 Amber: 10-200 Red: >200	MI22
IM PI Materials – Open PI Items by Material	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. Source data can display physical inventory document, plant, storage location, material and planned count date.	Green: <10 Amber: 10-200 Red: >200	MI22

IMMB movements

Transaction PB2_ANALYTICS_IMMB01 is used to monitor open picks and putaways when using the IM Multi Bin PreBilt functionality.

Tile description	Intended use	RAG limits	SAP transaction
Open Putaways – Today	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. Source data can display purchase order number, material, quantity and unit of measure.	Green: 0 Amber: 1-5 Red: >5	/TCTM/IMB_STK
For Goods Issue - Today	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. Source data can display delivery number, material, quantity and unit of measure.	Green: 0 Amber: 1-5 Red: >5	/TCTM/IMB_LQUA