Start of Content Area

Query Open Sales-Side Material Quantity  Locate the document in its SAP Library structure

Technical name: 0GT_IS01_Q0002

Use

This query provides an overview of the quantity still open for each material on the sales side. It displays materials for which customer orders already exist but for which no equivalent items are assigned (associated) on the purchasing side. For this reason, associations are subtracted from the item quantities from the documents on the sales side and the quantity transferred from the relevant item to its successor is added.

Filters

InfoObject

Description of InfoObject (or constraint or calculation formula)

0CALMONTH

Calendar year/month

0CALYEAR

Calendar year

0CALWEEK

Calendar year/week

0CALQUARTER

Calendar year/quarter

0GT_OPENQUAN

Open quantity still available?

0GT_POSQUAN

Active item?

0GT_RETITEM

Returns item

Free characteristics

InfoObject

Description

0GT_PORTFOL

Portfolio

0CREATED_BY

Created by

0SOLD_TO

Sold-to party

0SALES_ORG

Sales organization

0DISTR_CHAIN

Distribution channel

0DIVISION

Divisions

0COMP_CODE

Company code

0MATL_GROUP

Material group

0SALES_OFF

Sales office

Rows

InfoObject

Description of InfoObject (or constraint or calculation formula)

0MATERIAL

Material

Columns

InfoObject

Description of InfoObject (or constraint or calculation formula)

0GT_OQUAN_AU

Current item quantity in association unit

0GT_AA_QUAN

Actual quantity associated in association unit

0GT_OPEN_QUAN

Open quantity

Report-report interface

Query

Description

0GT_IS01_Q0001

Open sales items

0GT_MC03_Q0001

Association report

 

 

End of Content Area