0MM_PUR_PO_SCL

Purchasing Data (Schedule Line Level) | #TRAN | Extraction method: F1 | Delta: AIE | Component: Materials Management
Tables used: EKPO, EKKO, EKBE, EKET, EINA ... +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
ETENR Delivery Schedule Line Counter
Column Name Description
💲 Purchase order currency (WAERS):
NETPR Net Price
BWBRTWR Gross order value in order currency
BWEFFWR Effective order value
BWGEOO BW: Cost Value in Order Currency
BWKZWI1 Subtotal 1 from Pricing Procedure for Price Element
BWKZWI2 Subtotal 2 from Pricing Procedure for Price Element
BWKZWI3 Subtotal 3 from Pricing Procedure for Price Element
BWKZWI4 Subtotal 4 from Pricing Procedure for Price Element
BWKZWI5 Subtotal 5 from Pricing Procedure for Price Element
BWKZWI6 Subtotal 6 from Pricing Procedure for Price Element
DBWGEO Delta purchase order/goods receipt at cost
💲 Local Currency (HWAER):
BWGEO BW: Cost Value in Local Currency
BWGVO BW: Retail Value in Local Currency
BWGVP BW: Retail Value with Tax in Local Currency
BZGWR Delivery costs for order from invoice in LC
Column Name Description
📏 Purchase Order Unit of Measure (MEINS):
BWMNG BW: Quantity in Order Unit
DBWMNG Delta purchase order/goods receipt quantity in BUn
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
EINDT Item delivery date
SLFDT Statistics-Relevant Delivery Date
UZEIT Time
SCL_BEDAT Schedule line date
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
WEBRE Indicator: GR-Based Invoice Verification Show values
WEPOS Goods Receipt Indicator Show values
XERSY Evaluated Receipt Settlement (ERS) 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
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
LGORT Storage location LGORT
MATKL Material Group MATKL
PEINH Price unit PACK3
PSTYP Item category in purchasing document PSTYP
RESLO Issuing Storage Location for Stock Transport Order LGORT
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
BANFN Purchase Requisition Number BANFN
BNFPO Item number of purchase requisition BNFPO
CHARG Batch Number CHARG
MAHNZ Number of Reminders/Expediters PACK2
PERIV Fiscal Year Variant PERIV
NOSCL Counter for Schedule Agreement Schedule Lines 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
UEBPO Higher-Level Item in Purchasing Documents EBELP
ITMUSE Usage of Higher Level Item
SHIPTO Customer Number KUNNR
TIMESTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS