0MM_PUR_PO_ITM

Purchasing Data (Item Level) | #TRAN | Extraction method: F1 | Delta: AIE | Component: Materials Management
Tables used: EKPO, EKKO, EKBE, EINA, EKBZ ... +13 more
Column Name Description
EBELN Purchasing Document Number
EKORG Purchasing organization
LIFNR Vendor's account number
EBELP Item Number of Purchasing Document
MATNR Material Number
WERKS Plant
Column Name Description
💲 Purchase order currency (WAERS):
NETPR Net Price
NETWR Net order value in order currency
ZWERT Target Value for Outline Agreement in Document Currency
Column Name Description
📏 Purchase Order Unit of Measure (MEINS):
AKTWE Current goods receipt quantity in order unit
KTMNG Target Quantity
MENGE Purchase Order Quantity
Column Name Description
BEDAT Purchasing Document Date
BUDAT Posting date of goods received or invoice receipt for order
KDATB Start of Validity Period
KDATE End of Validity Period
SYDAT Date on which the purchasing document was entered
UZEIT Time
Column Name Description
ROCANCEL Indicator: Cancel Data Record Show values
BSTYP Purchasing Document Category Show values
STATU Status of Purchasing Document Show values
ELIKZ "Delivery Completed" Indicator Show values
EREKZ Final Invoice Indicator Show values
KZPOS Indicator: item counter relevant (R/2->R/3 link, schd.agmt) Show values
REPOS Invoice receipt indicator Show values
WEBRE Indicator: GR-Based Invoice Verification Show values
WEPOS Goods Receipt Indicator Show values
XERSY Evaluated Receipt Settlement (ERS) Show values
MGABW Smoothing Factor: Quantity Variance Show values
LFABW Smoothing Factor: Date Variance Show values
VVABW Smoothing Factor: Compliance with Shipping Instructions Show values
MCEX_UEBTK Unlimited Overdelivery Allowed Show values
Column Name Description Domain name
BSART Purchasing Document Type BSART
EKGRP Purchasing Group EKGRP
LBLIF Field not used LIFNR
LIFRE Different Invoicing Party LIFNR
LLIEF Goods Supplier LIFNR
LOGSY Logical System LOGSYS
ORGLOGSY Logical System LOGSYS
RESWK Supplying (issuing) plant in case of stock transport order WERKS
WKURS Exchange Rate KURSP
AFNAM Name of requisitioner/requester AFNAM
AKTNR Promotion WAKTION
ALAV Points score: Shipping notif. GR date - notified date DEC3
ALIEF Number of deliveries MCZAEHLER
BSGRU Reason for Ordering BSGRU
BWAPPLNM Application Component RSAPPLNM
BWVORG SAP BW transaction key NUM3
EMATN Material number MATNR
KONNR Number of principal purchase agreement EBELN
KTPNR Item number of principal purchase agreement EBELP
KZMAB Indicator: relevant quantity deviation CHAR1
KZTAB Indicator: relevant schedule deviation CHAR1
LAVI Points score: Shipping notification DEC3
LFZTA Total delivery time in days DECV13
LGORT Storage location LGORT
MABW Variance in the quantity delivered as % PRZ32V
MATKL Material Group MATKL
PEINH Price unit PACK3
PSTYP Item category in purchasing document PSTYP
PWEV Points score for compliance with shipping instructions DEC3
PWFR Points score for on-time delivery DEC3
PWMT Points score for quantity reliability DEC3
PWTT Points score for on-time delivery performance DEC3
PWWE Points score for quality of services DEC3
TABW Delivery Date Variance in Days PL2
TXZ01 Short Text TEXT40
UMREN Denominator for Conversion of Order Unit to Base Unit UMBSN
UMREZ Numerator for Conversion of Order Unit to Base Unit UMBSZ
PERIV Fiscal Year Variant PERIV
QUAN_INT Interval for Quantity Interval PL2
TIME_INT Interval for Date Split PL2
NOTIME Counter for Date Split PL2
NOQUAN Counter for Quantity Interval PL2
NOPOS Counter for Items PL2
PWLIF Goods supplier LIFNR
PREST Invoicing party LIFNR
PLIWK Supplying plant to which partner roles have been assigned LIFNR
PLIEF Supplier to whom Partner Roles have been Assigned LIFNR
PBEST Ordering address LIFNR
MAXBW Best Score BEWER
MCEX_UEBTO Overdelivery Tolerance PRZ21
MCEX_UNTTO Underdelivery Tolerance PRZ21
TIMESTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS