Entering content frame

Query Query MultiCube: Subsidiaries Comparison Locate the document in its SAP Library structure

Technical Name: 0SBO_MC01_Q

Use

This query enables you to analyze the sales activities per sales organization both from SAP Business One systems as well as from SAP R/3 systems. You can compare the following key figures for each sales organization:

·        Sales Order Value

·        Invoiced Value

·        Sales Order Quantity

·        Delivery Quantity

·        Invoiced Quantity

 

Free Characteristics

InfoObject

Description

0SOLD_TO 

Sold to Party

0SALESEMPLY

Sales Employee

0CALMONTH

Calendar Year/Month

 

Rows

InfoObject

Description of the InfoObject (and restriction or calculation formula)

0SALESORG

Sales Organization

0MATERIAL

Material

 

Columns

InfoObject

Description of the InfoObject (and restriction or calculation formula)

0ORDER_VALQ

Incoming Orders Value

0ORDER_QTY

Incoming Orders Quantity

0ORDER_COST

Incoming Orders Cost

0DEL_QTY

Delivery Quantity

0INV_QTYQ

Billed Quantity

0INV_VALUE

Billing Value

 

 

Leaving content frame