Purchasing Margins (SAP Library - BW

Purchasing Margins

Technical Name: 0RT_C05_Q0007

Use

Gives the buyer an overview of the order margins with different vendors, as compared to goods receipt margins.

Filter

No characteristics or key figures have been preset as filter criteria for this Query.

Free characteristics

InfoObject	Description
0MATL_PLANT_0PUR_GROUP	Purchasing group
0VENDOR	Vendor
0PLANT_0PLANTCAT	Site category
0PLANT	Site
0MATERIAL_0RT_PRBAND	Price band
0MATERIAL_0RT_SEASON	Season
0MATERIAL_0RT_CONFMAT	Generally configurable article
0MATERIAL	Article
0CALMONTH	Calendar year/month

This Query does not allow you to drill down by calendar week.

Rows

InfoObject	Description of the InfoObject (also: restrictions or calculation formulas)
0MATERIAL_0MATL_GROUP	Merchandise category

Columns

The vendors referred to in the key figures are always external vendors - these are not warehouse orders.

Unless otherwise indicated, the key figures are evaluated using the following dates:

Purchase orders, warehouse orders, scheduling agreements, receipts to/issues from on-order stock: at delivery date

Goods receipts, invoices, credit memos, returns: at posting date

InfoObject	Description of the InfoObject (also: restrictions or calculation formulas)
0RT_C05_CK007	Margin of purchase order with an external vendor, in retail value at purchase order date Key figure calculated using formula 100 x (Purchase order with vendor in retail value - purchase order with vendor in cost value) / order with vendor in retail value
0RT_C05_CK008	Margin of purchase order with an external vendor, in retail value with tax, at purchase order date Key figure calculated using formula 100 x (Purchase order with vendor in retail value with tax - purchase order with vendor in cost value) / purchase order with vendor in retail value
0RT_C05_CK009	Margin of goods receipt from an external vendor, in retail value Key figure calculated using formula 100 x (goods receipt from vendor in retail value - goods receipt from vendor in cost value) / goods receipt from vendor in retail value
0RT_C05_CK010	Margin of goods receipt from an external vendor, in retail value with tax Key figure calculated using formula 100 x (goods receipt from vendor in retail value with tax - goods receipt from vendor in cost value) / goods receipt from vendor in retail value with tax
0CPPORODVPV	Purchase order with an external vendor, in cost value at purchase order date
0RTPORODVSV	Purchase order with an external vendor in retail value at purchase order date
0RTPORODVST	Purchase order with an external vendor, in retail value with tax at purchase order date
0CPGRPDVPV	Goods receipt from an external vendor, in cost value
0CPGRPDVPV	Goods receipt from an external vendor, in retail value
0RTGRPDVST	Goods receipt from an external vendor, in retail value with tax