Show TOC

  Sales for Sales-Side Trading Contracts at Document Level

Technical name: 0GT_DS01_Q001

Use

This query shows you the most important sales key figures for each sales-side trading contract at document level.

Filter

InfoObject

Description of InfoObject (and restriction or calculation formula)

0SALESORG

Sales organization restricted to selection variable 0SALEORG ( sales organization )

0DISTR_CHAN

Distribution channel restricted to selection variable 0DISCHAN (distribution channel)

0SOLD_TO

Sold-to party restricted to selection variable 0S_CUSTO ( sold-to party ( entry optional ))

0RES_DEL

Deletion indicator restricted to value “-” (blank)

Free Characteristics

InfoObject

Description

0MATERIAL

Material restricted to selection variable 0S_MAT ( material ( selection options, optional )

0SALES_OFF

Sales office restricted to the selection variable 0P_SLSOF ( sales office )

0GT_TKSACHB

TC processor restricted to selection variable 0_TCSACH ( trading contract processor )

0DOC_DATE

Document date restricted to selection variable 0S_BELDT ( document date ( optional selection ))

0SHIP_TO

Ship-to party

0BILLTOPRTY

Bill-to party

0PAYER

Payer

0MATL_GROUP

Material group

0PLANT

Plant

0GT_RET_I

Returns indicator restricted to selection variable 0GT_RET ( returns with default value “-” (blank))

Rows

InfoObject

Description of InfoObject (and restriction or calculation formula)

0GT_TKONN

TC document number restricted to selection variable 0_TKONN (TC document number)

0GT_TPOSN

TC item number

0GT_TEINN

TC schedule line number

0GT_BTBSTA

TC application status restricted to selection variable 0GT_STAT ( application status )

Columns

InfoObject

Description of InfoObject (and restriction or calculation formula)

0GT_NTWP_SD

Net value in sales currency

0GT_NETP_SD

Net price

0GT_MENGESD

Quantity in sales unit

0GT_NTWS_TK

Net value in TC currency

0GT_SUBT_1D

Subtotal 1 SD

0GT_SUBT_2D

Subtotal 2 SD

0GT_SUBT_3D

Subtotal 3 SD

0GT_SUBT_4D

Subtotal 4 SD

0GT_SUBT_5D

Subtotal 5 SD

0GT_SUBT_6D

Subtotal 6 SD

0GT_REF_MSD

Referenced quantity SD

0GROSS_WGT

Gross weight order item

0GT_NTWGTSD

Net weight order item

0VOLUME_AP

Volume of order item