Show TOC

Summary reporting on DGP/IoA data Locate this document in the navigation structure

Query Query: 0PPS_PRTIM_RLDOC_GRP_0001

 

This query shows line items of documents corresponding to document numbers in queries 0PPS_PRTIM_RLDOC_0002 and 0PPS_PRTIM_SE_RLDOC_0003 grouped by fiscal year, fund and fund center (without hierarchy decomposition). Besides debit/credit and cash discount amounts in local and document currency, each line item contains references to purchasing documents, vendor, subtype and status of the document, assignments to FI organizations (company code, business area) and PSM organization (fund, fund center, measure and commitment item).

Selection

InfoObject

Description

0FM_AREA

FM Area

0PPS_BUSARE

Business Area

0FSICVARNT

Fiscal year variant

0FISCPER

Fiscal year period (from / to)

Structure

Filters

Object Type

Name

Technical Name

Value Restriction / Calculation

Business area

0PPS_BUSARE

Document deleted

0PPS_DGDOCN__0PPS_DOCDEL

Excluding 'X’

FM area

0FM_AREA

Fiscal year variant

0FISCVARNT

Fiscal year period (from / to)

0FISCPER

Free Characteristics

Object Type

Name

Technical Name

Purchasing document

0PPS_DGDOCN__0OI_EBELLN

Interest document exists

0PPS_DGDOCN__0PPS_INTDEX

Reference Doc. No.

0REF_DOC_NR

Rows

Object Type

Name

Technical Name

Value Restriction / Calculation

FM area

0FM_AREA

Fiscal year

0FISCYEAR

Fund

0FUND

Fund Center

0FUNDS_CTR

Business area

0PPS_BUSARE

DGP Document No.

0PPS_DGDOCN

DGP Line Number

0PPS_DGLITM

DGP Doc. Subtype

0PPS_DGDOCN__0PPS_DOCSTY

DGP Doc. Status

0PPS_DGDOCN__0PPS_DOCSTA

Clearing date

0CLEAR_DATE

Clearing document

0FC_AUGBL

Interest Calc. Key

0PPS_DGDOCN__0PPS_INTKEY

MM Document No.

0PPS_MMDOCN

Vendor

0VENDOR

Purch. Doc. Long No.

0PPS_DGDOCN__0PPS_EBELLN

Cash discount 1

0DSCT_DATE1

Cash discount 2

0DSCT_DATE2

Columns

Object Type

Name

Technical Name

Value Restriction / Calculation

Cash Discount Days 1

0PPS_CDSCD1

Cash Discount Days 2

0PPS_CDSCD2

Net Payment Terms Period

0PPS_CDSCD3

Cash Discount 1

0DSCT_PCT1

Cash Discount 2

0DSCT_PCT2

Debit/Credit Amount (LC)

0DEB_CRE_LC

Cash Discount Amount (LC)

0DSC_AMT_LC

Debit/Credit Amount (DC)

0DEB_CRE_DC

Cash Discount Amount (DC)

0DSC_AMT_DC