Select language:

InfoCube documentation Purchasing Data 

Technical name: 0PUR_C01

Use

With the data of the InfoCube Purchasing Data, you can carry out analyses of material groups, vendors, and materials. This data enables you to find answers to the following questions, for example: "Which materials and how much of each have been ordered from a certain vendor?" "How many PO items are there for a certain material group?"

InfoSources

You can supply this InfoCube with data using either the conventional extraction method or the new one:

  • Conventional method:
Purchasing (2LIS_02_S012)
  • New method:
  • Purchasing Data (Document Item Level) (2LIS_02_ITM) and Purchasing Data (Document Schedule Line Level) (2LIS_02_SCL)

    Note

    If you wish to use the new extraction method, you must make certain settings in Customizing for the OLTP system.

    For more information, refer to the InfoSource documentation.

    Characteristics

    InfoObject

    Description

    0COUNTRY

    Country key

    0MATERIAL

    Material number

    0MATL_GROUP

    Material group

    0PLANT

    Plant

    0PURCH_ORG

    Purchasing organization

    0REVERSEDOC

    Indicator that data must be cancelled (reversed)

    0VENDOR

    Vendor number

    0VERSION

    Version

    0VTYPE

    Value type for reporting

    0INFO_REC

    Number of purchasing info record

    0INFO_TYPE

    Purchasing info record category

    Time Characteristics

    InfoObject

    Description

    0CALDAY

    Calendar day

    0CALMONTH

    Calendar year/month

    0CALWEEK

    Calendar year/week

    0FISCPER

    Fiscal year/period

    0FISCVARNT

    Fiscal year variant

    Key Figures

    InfoObject

    Description

    0DEL_DT_VR1

    Delivery date variance 1

    0DEL_DT_VR2

    Delivery date variance 2

    0DEL_DT_VR3

    Delivery date variance 3

    0DEL_DT_VR4

    Delivery date variance 4

    0DEL_DT_VR5

    Delivery date variance 5

    0QTY_DEV_1

    Delivery quantity variance 1

    0QTY_DEV_2

    Delivery quantity variance 2

    0QTY_DEV_3

    Delivery quantity variance 3

    0QTY_DEV_4

    Delivery quantity variance 4

    0QTY_DEV_5

    Delivery quantity variance 5

    0ORDER_VAL

    Effective order value

    0EFF_VAL_RE

    Effective order value (returns)

    0GR_VAL_R_P

    GR value of returns as at posting date

    0GR_QTY_WDT

    GR quantity in base unit (to calculate weighted delivery time)

    0GR_QTY_RET

    GR quantity (returns)

    0GR_VAL_PD

    GR value as at posting date

    0IR_QTY_R_P

    IR: Quantity of returns as at posting date

    0IR_VAL_R_P

    IR: Value of returns as at posting date

    0INV_RC_VAL

    Invoiced amount as at posting date

    0IR_VAL_RET

    Invoiced amount, returns

    0INV_RC_QTY

    Invoice receipt quantity as at posting date

    0IV_REC_QTY

    Invoice receipt quantity

    0IR_QTY_RET

    Invoice receipt quantity, returns

    0INVCD_AMNT

    Invoiced amount

    0CONTR_ITEM

    Number of contract items

    0DELIVERIES

    Number of deliveries

    0DEL_SCHEDS

    Number of scheduling agreement schedule lines

    0PO_ITEMLNS

    Number of purchase order schedule lines

    0PO_ITEMS

    Number of purchase order items

    0QUOT_ITEMS

    Number of quotation items

    0RFQ_ITEMS

    Number of RFQ items

    0SCH_AGR_IT

    Number of scheduling agreement items

    0PO_QTY_RET

    PO quantity (returns)

    0PO_QTY

    PO quantity

    0GR_QTY

    GR quantity

    0TAR_DL_QTY

    Target delivery quantity

    0TOTDELTIME

    Total delivery time in days

    0GR_VAL

    GR value in local currency

    0WTDDELTIME

    Weighted total delivery time

    To enable the key figures for delivery date and delivery quantity variances to be computed, you must maintain a grid containing windows for on-time delivery performance and quantity reliability in Customizing for the Logistics Information System (LIS) (Logistics Data Warehouse ® Updating ® Updating Control ® Settings for Purchasing).

    Units

    InfoObject

    Description

    0LOC_CURRCY

    Local currency

    0BASE_UOM

    Base unit of measure