2LIS_02_ITM

Purchasing Data (Item Level) | #TRAN | Extraction method: F1 | Delta: ABR | Component: Materials Management
Tables used: EKPO, EKKO, LIPS, QALS, VBAP ... +188 more
Column Name Description
EBELN FK Purchasing Document Number
EKGRP FK Purchasing Group
EKORG FK Purchasing organization
LIFNR FK Vendor's account number
STATU Status of Purchasing Document Show values
EBELP FK Item Number of Purchasing Document
MATNR FK Material Number
WERKS FK Plant
UZEIT Time
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
LOGSY Logical System LOGSYS
ORGLOGSY Logical System LOGSYS
WKURS Exchange Rate KURSP
AFNAM Name of requisitioner/requester AFNAM
ALAV Points score: Shipping notif. GR date - notified date DEC3
ALIEF Number of deliveries MCZAEHLER
BWAPPLNM Application Component RSAPPLNM
BWVORG SAP BW transaction key NUM3
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
MABW Variance in the quantity delivered as % PRZ32V
PEINH Price unit PACK3
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
Master Data Relations Join Conditions
Promotion
  • Client
  • Promotion
  • 2LIS_02_ITM.MANDT == WAKH.MANDT
  • 2LIS_02_ITM.AKTNR == WAKH.AKTNR
Purchasing Document Type
  • ?
  • Client
  • Purchasing Document Type
  • 2LIS_02_ITM.[column in domain "BSTYP"] == T161.BSTYP
  • 2LIS_02_ITM.MANDT == T161.MANDT
  • 2LIS_02_ITM.BSART == T161.BSART
Reason for Ordering
  • Client
  • Reason for Ordering
  • 2LIS_02_ITM.MANDT == TBSG.MANDT
  • 2LIS_02_ITM.BSGRU == TBSG.BSGRU
Purchasing Group
  • Client
  • Purchasing Group
  • 2LIS_02_ITM.MANDT == T024.MANDT
  • 2LIS_02_ITM.EKGRP == T024.EKGRP
Purchasing organization
  • Client
  • Purchasing organization
  • 2LIS_02_ITM.MANDT == T024E.MANDT
  • 2LIS_02_ITM.EKORG == T024E.EKORG
Material number
  • Client
  • Material number
  • 2LIS_02_ITM.MANDT == MARA.MANDT
  • 2LIS_02_ITM.EMATN == MARA.MATNR
Field not used
  • Client
  • Field not used
  • 2LIS_02_ITM.MANDT == LFA1.MANDT
  • 2LIS_02_ITM.LBLIF == LFA1.LIFNR
Storage location
  • Client
  • Storage location
  • Plant
  • 2LIS_02_ITM.MANDT == T001L.MANDT
  • 2LIS_02_ITM.LGORT == T001L.LGORT
  • 2LIS_02_ITM.WERKS == T001L.WERKS
Vendor's account number
  • Client
  • Vendor's account number
  • 2LIS_02_ITM.MANDT == LFA1.MANDT
  • 2LIS_02_ITM.LIFNR == LFA1.LIFNR
Different Invoicing Party
  • Client
  • Different Invoicing Party
  • 2LIS_02_ITM.MANDT == LFA1.MANDT
  • 2LIS_02_ITM.LIFRE == LFA1.LIFNR
Goods Supplier
  • Client
  • Goods Supplier
  • 2LIS_02_ITM.MANDT == LFA1.MANDT
  • 2LIS_02_ITM.LLIEF == LFA1.LIFNR
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • 2LIS_02_ITM.MANDT == T006.MANDT
  • 2LIS_02_ITM.LMEIN == T006.MSEHI
Material Group
  • Client
  • Material Group
  • 2LIS_02_ITM.MANDT == T023.MANDT
  • 2LIS_02_ITM.MATKL == T023.MATKL
Material Number
  • Client
  • Material Number
  • 2LIS_02_ITM.MANDT == MARA.MANDT
  • 2LIS_02_ITM.MATNR == MARA.MATNR
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • 2LIS_02_ITM.MANDT == T006.MANDT
  • 2LIS_02_ITM.MEINS == T006.MSEHI
Item category in purchasing document
  • Client
  • Item category in purchasing document
  • 2LIS_02_ITM.MANDT == T163.MANDT
  • 2LIS_02_ITM.PSTYP == T163.PSTYP
Supplying (issuing) plant in case of stock transport order
  • Client
  • Supplying (issuing) plant in case of stock transport order
  • 2LIS_02_ITM.MANDT == T001W.MANDT
  • 2LIS_02_ITM.RESWK == T001W.WERKS
Plant
  • Client
  • Plant
  • 2LIS_02_ITM.MANDT == T001W.MANDT
  • 2LIS_02_ITM.WERKS == T001W.WERKS