Start of Content Area

Query Reporting Point: Variances of the Last Seven Days Locate the document in its SAP Library structure

Technical name: 0AU_PPC_Q002

Based on InfoCube or ODS object: 0AUPPC_2

Use

This query analyzes the WIP, scrap, and variances of the components and activities based on the actual costs of the component withdrawals and activity consumptions. You can display the data of the last seven calendar days at the level of the line structure and plant, as well as of the material (assembly) and production version for all reporting points of the line structure.

Filter

InfoObject

Description of the InfoObject (and restriction or calculation formula)

0CO_AREA

Controlling area

0CONFLOGSYS

System ID

Free Characteristics

InfoObject

Description

0LINEHEAD

Line structure

0PLANT

Plant

0MATERIAL

Material

0PRODVERSION

Production version

0COMPONENT

Component

0COSTCENTER

Cost center

0ACTTYPE

Activity type

Variables Used

Variable

Description

0P_LNHD

Line structure (single value entry)

0P_PLANT

Plant (single value, required)

0DAT-7

Current calendar day (SAP exit) -7

0DAT-6

Current calendar day (SAP exit) -6

0DAT-5

Current calendar day (SAP exit) -5

0DAT-4

Current calendar day (SAP exit) -4

0DAT-3

Current calendar day (SAP exit) -3

0DAT-2

Current calendar day (SAP exit) -2

0DAT-1

Current calendar day (SAP exit) -1

Rows

InfoObject

Description of the InfoObject (and restriction or calculation formula)

0REPPT_LVL

Reporting point level

0REPPOINT

Reporting point

0CALDAY

Calendar day

Columns

InfoObject

Description of the InfoObject (and restriction or calculation formula)

0ACT_AMOUNT

Actual costs

0SCRAP_AMNT

Scrap

 

Scrap portion of costs

0WIP_AMOUNT

WIP

0VAR_AMOUNT

Variance

 

Percentage variance

 

 

 

End of Content Area