Global Spend (Point-to-Point
Connection)
Technical Name: 0BBP_C01
Use
This InfoCube enables you to analyze local procurement data with regard to purchase orders, goods receipts, and invoice receipts on an aggregated level. You can use it to evaluate variances in invoice value to order value.
ODS Objects
0BBP_DS1: Purchase Order Actual Values – Single Documents
0BBP_CON: Goods Receipt/Service Confirmation – Single Documents
0BBP_INV: Invoices – Single Documents
0BBP_SC: Shopping Cart –
Single Documents
Characteristics
|
InfoObject |
Description |
|
Approver |
|
|
Buyer ID |
|
|
Catalog ID |
|
|
Procurement card company |
|
|
Procurement card number |
|
|
Product |
|
|
Purchasing group |
|
|
Purchasing organization |
|
|
Goods recipient from business partner table |
|
|
Requester from business partner table |
|
|
Logical backend system |
|
|
Logical procurement system |
|
|
Original system of the product |
|
|
Original system of the vendor |
|
|
Tax code |
|
|
Product description |
|
|
Vendor from business partner table |
|
|
Flag for contracts |
|
|
eCl@ss |
|
|
Version-independent key of eCl@ss |
|
|
eCL@ss version |
|
|
Logical procurement system |
|
|
Material |
|
|
Material group |
|
|
Plant |
|
|
Product category |
|
|
Product type |
|
|
Purchasing group |
|
|
Purchasing organization |
|
|
Service number |
|
|
0STOR_LOC |
Storage location |
|
UN/SPSC code |
|
|
Version-independent key of UN/SPSC code |
|
|
Version of UN/SPSC code |
|
|
Vendor |
|
|
Service provider |
|
|
Location |
|
|
Customer from third-party purchase order |
|
|
Third-party purchase order flag |
|
|
Technical scenario |
Time Characteristics
|
InfoObject |
Description |
|
Calendar day |
|
|
Calendar year/month |
|
|
Calendar year/quarter |
|
|
0CALWEEK |
Calendar year/week |
|
Calendar year |
|
|
Fiscal year/period |
|
|
Fiscal year variant |
Key Figures
|
InfoObject |
Description |
|
Confirmation quantity in purchase order unit |
|
|
Net confirmation value in order currency |
|
|
Invoice quantity in purchase order unit |
|
|
Net invoice value in order currency |
|
|
Purchase order quantity in purchase order unit |
|
|
Net purchase order value in order currency |
|
|
Number of Invoice Items |
|
|
Number of Invoices |
|
|
Credit memo quantity in invoice quantity unit for order date |
|
|
Credit memo quantity |
|
|
Credit memo value in invoice currency for order date |
|
|
Credit memo value |
|
|
Number of confirmations |
|
|
Confirmation quantity in confirmation unit of measure for order date |
|
|
Net confirmation value in confirmation currency for order date |
|
|
Delivery time variance |
|
|
Number of confirmation items |
|
|
Expected net purchase order value |
|
|
Freight costs |
|
|
Invoice quantity in Invoice unit of measure |
|
|
Net invoice value in invoice currency for order date |
|
|
Number of purchase orders |
|
|
Number of purchase order items |
|
|
Tax amount of purchase order |
|
|
Returned quantity in confirmation unit of measure for order date |
|
|
Returned quantity |
|
|
Returned value in confirmation currency for order date |
|
|
Returned value |
|
|
Approved shopping cart value |
|
|
Number of shopping carts |
|
|
Expected shopping cart value |
|
|
Number of shopping cart items |
|
|
Shopping cart quantity |
|
|
Tax amount of shopping cart |
|
|
Tax amount |
The delivery time variance is calculated in the update from the ODS object 0BBP_DS1: Where the requested delivery date and confirmation date are filled and the requested delivery date precedes the confirmation date, the system updates the number of days between confirmation date and requested delivery date. As 0BBP_DS1 always contains the confirmation date of the most current confirmation, the delivery time variance refers to the most current confirmation.
You should note the following during update of the key figures 0BBP_CMQTY, 0BBP_CMVAL, 0BBP_CMQTYI, and 0BBP_CMVALI from ODS object 0BBP_INV:
In Enterprise Buyer, document categories “CM” for credit memo and “IV” for invoice have been introduced to differentiate between values and quantities in invoices and credit memos. ODS object 0BBP_INV only delivers invoice quantity in order unit of measure (0BBP_ASIQOU) and invoice value in order currency (0BBP_ASIVOC). If we are dealing with the document category “CM”, both values are updated with a negative indicator in the InfoCube 0BBP_C01. With document category “IV” the values are updated in the same way that they are delivered from the invoice ODS object.
Both key figures credit memo amount (0BBP_CMVALI) and credit memo quantity (0BBP_CMQTYI) describe the values and quantities of the credit memo according to the document. So that only values and quantities of the credit memo are updated in both key figures 0BBP_CMVALI and 0BBP_CMQTYI, the system checks again whether both key figures 0BBP_ASIQOU and 0BBP_ASIVOC together with the document category (0BBP_SUBTYP) “CM” are delivered from the invoice ODS object.
Analogous to the credit memos for an invoice, returns for confirmations are also processed. Document category “RT” for returns is queried in the update rules.
ODS object 0BBP_CON only delivers confirmation quantity in order unit of measure (0BBP_ASGQOU) and confirmation value in order currency (0BBP_ASGVOC). With the document category “RT”, both values are updated with a negative indicator in the InfoCube 0BBP_C01. If we are not dealing with the document category “RT” confirmation quantities and values of both key figures 0BBP_ASGQOU and 0BBP_ASGVOC are updated in the same way that they are delivered from the confirmation ODS object.
The key figures returned value (0BBP_RTVALC) and returned quantity (0BBP_RTQTYC) describe the values and quantities of the returned delivery memo according to the document. In order that only the values and quantities of the returned delivery are updated in both key figures 0BBP_RTVALC and 0BBP_RTQTYC, the system checks again whether both key figures 0BBP_ASGQOU and 0BBP_ASGVOC are delivered together with the document type (0BBP_SUBTYP) “RT” from the confirmation ODS object.
Restricted Key Figures
|
InfoObject |
Description |
Formula/Restriction |
|
Order value of current month &0T_CMONT& |
0BBP_C01_CK007 for 0CMONTH |
|
|
Order value for previous month |
0BBP_C01_CK007 for 0CMONTH-1 |
|
|
Order value of month before previous month &0T_CMONT& |
0BBP_C01_CK007 for 0CMONTH-2 |
|
|
Confirmation value of current month &0T_CMONT& |
0BBP_ASGVOC for 0CMONTH |
|
|
Confirmation value of previous month &0T_CMONT& |
0BBP_ASGVOC for 0CMONTH-1 |
|
|
Confirmation value of month before previous month &0T_CMONT& |
0BBP_ASGVOC for 0CMONTH-2 |
|
|
Invoice value of current month &0T_CMONT& |
0BBP_ASIVOC for 0CMONTH |
|
|
Invoice value of previous month &0T_CMONT& |
0BBP_ASIVOC for 0CMONTH-1 |
|
|
Invoice value of month before previous month &0T_CMONT& |
0BBP_ASIVOC for 0CMONTH-2 |
Calculated Key Figures
|
InfoObject |
Description |
Formula/Restriction |
|
0BBP_C01_CK007 /
|
||
|
Average order price |
0BBP_C01_CK007 / 0BBP_ASPQOU |
|
|
Average invoice price |
||
|
Average value per invoice item |
||
|
Average value per confirmation item |
||
|
Items per purchase order |
||
|
Total order value |
||
|
Excessive delivered quantity |
Maximum from 0 or (confirmation quantity for order date – order quantity) |
Units
|
InfoObject |
Description |
|
0ORDER_CURR |
PO currency |
|
0PO_UNIT |
Purchase order unit of measure |
|
0CONF_UNIT |
Confirmation unit of measure |
|
0INV_UNIT |
Invoice unit of measure |
|
0SC_UNIT |
Shopping cart unit of measure |
|
0SC_CURR |
Shopping cart currency |
|
0CONF_CURR |
Currency of product/service confirmation |
|
0INV_CURR |
Currency of invoice |