Start of Content Area

Query Scheduling Agreement Details  Locate the document in its SAP Library structure

Technical name: 0SRCT_DS1_Q009

Use

You can use this query to analyze more precisely the validity period of scheduling agreements that are about to expire or have already expired. You are able to navigate according to scheduling agreement number, purchasing organization, purchasing group, business partner, and goods recipient.

Filter

InfoObject

Description of the InfoObject (and Restriction or Calculation Formula)

0BBP_FLAG

Flag

0BBP_BUYID

Buyer ID

0BBP_SUBTYP

Document characteristics

Free Characteristics

InfoObject

Description

0BBP_PURORG

Purchasing organization

0BBP_PURGRP

Purchasing group

0PROCTYPE

Process type

0BBP_PROCT

Processing status

0VAL_START

Validity start date

0PRODUCT

Product

The InfoObject has the display attribute 0GN_PRO_IDX (local product ID).

Variables Used

Variable

Description

0A_BUYID

Buyer (authorization)

Rows

InfoObject

Description of the InfoObject (and Restriction or Calculation Formula)

0VAL_END

Validity end date

0BBP_CTC_ID

Scheduling agreement

0BBP_CTITEM

Item number

0GN_VENDOR

Vendor

The InfoObject has the display attribute 0GN_PAR_LID (local partner ID).

0GN_CAT_PUR__0CI_SPURCAT

Standard category for reporting

0GN_CAT_PUR

Purchasing category

The InfoObject has the display attribute 0GN_CAT_IDX (local category ID).

Columns

InfoObject

Description of the InfoObject (and Restriction or Calculation Formula)

0OUTAGTARGT

Target value

0TARG_QTY

Target quantity

0SR_VALREL

Released value

0SR_QTYREL

Released quantity

 

Scheduling agreement utilization

Formula: Released value % A target value

Report/Report Interface

Query

Description

 

 

 

End of Content Area