Start of Content Area

Query Condition Rate Deviation (Sales Order and Billing Document)  Locate the document in its SAP Library structure

Technical name: 0SD_MC01_Q0003

Use

This query shows the deviation of the condition rate of various condition types between a sales order and the associated billing document (if the condition rate in the sales order is different from that in the billing document).

Free Characteristics

InfoObject

Description

0SOLD_TO

Sold-to party

0CALDAY

Calendar day

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 document (optional)

0P_KNART

Condition type (optional)

Lines

InfoObject

Description of the InfoObject (or restriction or authorization formula)

0DOC_NUMBER

Sales and distribution document

0S_ORD_ITEM

Item

0KNART

Condition type

Columns

InfoObject

Description of the InfoObject (or restriction or authorization formula)

0SD_MC01_RK001

Condition amount (order)

 

0SD_MC01_RK002

Condition amount (billing document)

0SD_MC01_CK001

Deviation condition amount = condition amount (order) – condition amount (billing document)

 

 

 

End of Content Area