AFS Overview Purchasing/Vendor

Technical name: 0AFMM_C01_Q0002

Based on InfoCube: 0AFMM_C01

Use

This query gives you an overview of the vendor business volumes and the percentage of credit memos and returns based on data from the previous year. It also calculates the average procurement quantity in order to enable a realistic price comparison.

Note Note

The values at schedule line level are not exact if there are different prices for the various stock keeping units (approximation through average prices).

End of the note.

Filters

InfoObject	Description of the InfoObject (and Restriction or Calculation Formula)
0CALYEAR	Restricted to the Previous Year

Free Characteristics

InfoObject	Description
0AF_SIZE	AFS Elementary Field Size
0AF_COLOR	AFS Elementary Field Color
0AF_COUN	AFS Elementary Field Country
0AF_SQUAL	AFS Elementary Field Quality (Stock)
0AF_RQUAL	AFS Elementary Field Quality (Requirement)
0MATERIAL	Material
0PURCH_ORG	Purchasing Organization
0PLANT	Plant
0MATERIAL__0MATL_TYPE	Material Type
0MATERIAL__0DIVISION	Division

Rows

InfoObject	Description of the InfoObject (and Restriction or Calculation Formula)
0VENDOR	Vendor

Columns

InfoObject	Description of the InfoObject (and Restriction or Calculation Formula)
0CPPODDVPV	Value of Purchase Order
0CPGRPDVPV	Value of Goods Receipt
0CPRETPDVPV	Value of Returns
0CPCRMPDVPV	Value of Credit Memos
0AFMM_C01_CK005	The average purchase order quantity is calculated as follows: Purchase order (on delivery date) divided by number of purchase order delivery schedule lines (on delivery date).
0AFMM_C01_CK006	The average purchase price is calculated from the quotients of the net cost value (= cost value minus credit memo value) and the net purchase quantity (= purchase quantity minus credit memo quantity).
Formula Variable Percentage of Returns	Returns in Percent from Goods Receipt
Formula Variable Percentage of Credit Memos	Credit Memos in Percent from Goods Receipt