Start of Content Area

Query Condition Amount By Customer  Locate the document in its SAP Library structure

Technical name: 0SD_C15_Q0001

Use

The query shows the cumulated order quantity, condition value and average condition value for each sold-to party and condition type.

Free Characteristics

InfoObject

Description

0CUST_GROUP

Customer group

0CALMONTH

Calendar month

0SALESORG

Sales organization

0MATERIAL

Material

Variables Used

Variable

Description

0S_CUST_TO

Sold-to party (input optional)

0S_EMPLY

Sales representative selection

0I_DAYIN

Day interval

0S_MAT

Material (selection options, optional)

0P_DOCNU

Sales and distribution document (optional)

0P_KNART

Condition type (optional)

Lines

InfoObject

Description of the InfoObject (or restriction or authorization formula)

0SOLD_TO

Sold-to party

0KNART

Condition type

Columns

InfoObject

Description of the InfoObject (or restriction or authorization formula)

0CML_QR_QTY

Cumulated order amount

0KNVAL

Condition value

0SD_C15_CK001

Average condition value = condition value / cumulated order amount

 

 

 

End of Content Area