This query displays purchase order values per product category for the last 12 months that occurred either on the basis of contracts or without contracts. The query is restricted to the top 5 purchase order values with contracts and the top 5 purchase order values without contracts (via product categories).
Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| Third-party purchase order flag |
0BBP_TPFLAG |
Object Type | Name | Technical Name |
|---|---|---|
| Calendar year/month |
0CALMONTH |
| Calendar year/month |
0CALMONTH |
| Requester |
0BBP_REQSTR |
| Vendor |
0GN_VENDOR |
| Purchasing group |
0BBP_PURGRP |
| Purchasing organization |
0BBP_PURORG |
| Catalog |
0BBP_CAT_ID |
Object Type | Name | Technical Name |
|---|---|---|
| Last 12 months including the current month |
0CYEAR |
| Category |
0S_GNCGO |
Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| Purchasing category |
0GN_CAT_PUR |
— |
Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| Purchase order value with contracts |
0_RK020 |
— |
| Purchase order value without contracts |
0RK021 |