0MM_PUR_PURCH_DATA

Purchasing Data | #TRAN | Extraction method: F1 | Delta: AIE | Component: Materials Management
Tables used: EKPOEINAELBMMARAEKBE ... +13 more
Column Name Description
Column Name Description
💲 Local Currency (LOC_CURRCY):
IR_VAL_RET Invoiced Amount: Returns
EFF_VAL_RE Effective Order Value of Returns
GR_VAL Value of Goods Received
GR_VAL_PD Goods Receipt Value at Posting Date
INV_RC_VAL Invoice Amount as Posting Date
GR_VAL_R_P GR Value: Returns at Posting Date
INVCD_AMNT Invoiced Amount
IR_VAL_R_P IR Value: Returns at Posting Date
ORDER_VAL Effective Purchase Order Value
Column Name Description
📏 Base Unit of Measure (BASE_UOM):
INV_RC_QTY Invoice Receipt Quantity at Posting Date
GR_QTY Actual Goods Receipt Quantity
GR_QTY_RET Goods Receipt Quantity of Returns
GR_QTY_WDT GR Qty in Base Unit (Calculate Weighted Delivery Time)
IR_QTY_RET Invoice Receipt Quantity of Returns
IR_QTY_R_P IR Quantity: Returns at Posting Date
IV_REC_QTY Invoice Receipt Quantity
TAR_DL_QTY Target Delivery Quantity
PO_QTY_RET Order Quantity (Returns)
PO_QTY Order Quantity
Column Name Description
CALDAY Calendar day
DOC_DATE Purchase Order Date
Column Name Description
INFO_TYPE Purchasing info record category Show values
REVERSEDOC Purchasing info: General data flagged for deletion Show values
GR_RE_IND Goods Receipt Indicator Show values
Column Name Description Domain name
CALMONTH Calendar year / month RSCALMONTH
CALWEEK Calendar year / week RSCALWEEK
FISCPER Fiscal year / period RSFISCPER
FISCVARNT Fiscal year variant RSFISCVAR
COUNTRY Country/Region Key LAND1
INFO_REC Number of purchasing info record INFNR
MATERIAL Material Number MATNR
MATL_GROUP Material Group MATKL
PURCH_ORG Purchasing organization EKORG
VENDOR Account Number of Supplier LIFNR
VERSION Version COVERSI
VTYPE Value type for Reporting RSVTYPE
CT_FLG Boolean type CHAR1
PLANT Plant WERKS
DELIVERIES Number of Deliveries
DEL_DT_VR1 Delivery Date Variance
DEL_DT_VR2 Delivery Date Variance
DEL_DT_VR3 Delivery Date Variance
DEL_DT_VR4 Delivery Date Variance
DEL_DT_VR5 Delivery Date Variance
QTY_DEV_1 Delivery Quantity Variance
QTY_DEV_2 Delivery Quantity Variance
QTY_DEV_3 Delivery Quantity Variance
QTY_DEV_4 Delivery Quantity Variance
QTY_DEV_5 Delivery Quantity Variance
WTDDELTIME Weighted Total Delivery Time
CONTR_ITEM Number of Contract Items
DEL_SCHEDS Number of Scheduling Agreement Schedule Lines
PO_ITEMLNS Number of Purchase Order Schedule Lines
PO_ITEMS Number of Purchase Order Items
QUOT_ITEMS Number of Quotation Items
RFQ_ITEMS Number of Request for Quotation Items
SCH_AGR_IT Number of Scheduling Agreement Items
TOTDELTIME Total Delivery Time in Days
TIMESTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS