S012BIW1

S012BIW1 * Purchasing | #transactional | Component: Data Collection
Column Name Description
MANDT FK Client
SSOUR Statistic(s) origin
VRSIO Version number in the information structure
SPMON Period to analyze - month
SPTAG Period to analyze - current date
SPWOC Period to analyze - week
SPBUP Period to analyze - posting period
EKORG FK Purchasing organization
LIFNR FK Vendor's account number
MATNR FK Material Number
WERKS FK Plant
ESOKZ Purchasing info record category Show values
MATKL FK Material Group
INFNR FK Number of purchasing info record
LAND1 FK Country/Region Key of Supplier
Column Name Description
💲 Local Currency (HWAER):
NETWR Effective order value
REWRT Invoice Amount
REWRT_R Invoice amount: Returns
EFFWR_R Effective order value of returns
WEWRT Value of goods received in local currency
WEWRT_B Goods receipt value as at posting date
REWRT_B Invoice Amount as at Posting Date
REWRT_R_B IR value: Returns as at posting date
WEWRT_R_B GR value: Returns as at posting date
Column Name Description
📏 Base Unit of Measure (BASME):
MENGE Purchase order quantity
WEMNG Quantity of goods received
WEMGM Goods receipt qty in base unit (calculate wtd.delivery time)
REMNG Invoice receipt quantity
LSMNG Target delivery quantity in base unit of measure
MENGE_R Order quantity (returns)
REMNG_R Invoice receipt quantity of returns
WEMNG_R Goods receipt quantity of returns
REMNG_B Invoice receipt quantity as at posting date
REMNG_R_B IR quantity: Returns as at posting date
Column Name Description
SPTAG Period to analyze - current date
Column Name Description
ESOKZ Purchasing info record category Show values
Column Name Description Domain name
PERIV Fiscal Year Variant PERIV
VWDAT Pointer to administrative data VWDAT
ABSTP Number of purchase order items MCZAEHLER
ABSTE Number of purchase order item schedule lines MCZAEHLER
AANFP Number of requests for quotation items MCZAEHLER
AANGP Number of Quotation Items MCZAEHLER
AKONP Number of contract items MCZAEHLER
ALFPP Number of scheduling agreement items MCZAEHLER
ALFPE Number of delivery schedules MCZAEHLER
ALIEF Number of deliveries MCZAEHLER
MABW1 Deviation 1 in the quantity delivered MCZAEHLER
MABW2 Variance 2 in the quantity delivered MCZAEHLER
MABW3 Variance 3 in the quantity delivered MCZAEHLER
MABW4 Variance 4 in the quantity delivered MCZAEHLER
MABW5 Variance 5 in the quantity delivered MCZAEHLER
TABW1 Delivery date variance 1 in days MCZAEHLER
TABW2 Delivery date variance 2 in days MCZAEHLER
TABW3 Delivery date variance 3 in days MCZAEHLER
TABW4 Delivery date variance 4 in days MCZAEHLER
TABW5 Delivery date variance 5 in days MCZAEHLER
LFZTA Total delivery time in days DECV13
LFZTG Weighted total delivery time DECV15_1
Master Data Relations Join Conditions
Base Unit of Measure
  • S012BIW1.MANDT == T006.MANDT
  • S012BIW1.BASME == T006.MSEHI
Purchasing organization
  • S012BIW1.MANDT == T024E.MANDT
  • S012BIW1.EKORG == T024E.EKORG
Local Currency
  • S012BIW1.MANDT == TCURC.MANDT
  • S012BIW1.HWAER == TCURC.WAERS
Number of purchasing info record
  • Number of purchasing info record
  • Client
  • S012BIW1.INFNR == EINA.INFNR
  • S012BIW1.MANDT == EINA.MANDT
Country/Region Key of Supplier
  • Country/Region Key of Supplier
  • Client
  • S012BIW1.LAND1 == T005.LAND1
  • S012BIW1.MANDT == T005.MANDT
Vendor's account number
  • S012BIW1.MANDT == LFA1.MANDT
  • S012BIW1.LIFNR == LFA1.LIFNR
Client S012BIW1.MANDT == T000.MANDT
Material Group
  • S012BIW1.MANDT == T023.MANDT
  • S012BIW1.MATKL == T023.MATKL
Material Number
  • Material Number
  • Client
  • S012BIW1.MATNR == MARA.MATNR
  • S012BIW1.MANDT == MARA.MANDT
Plant
  • S012BIW1.MANDT == T001W.MANDT
  • S012BIW1.WERKS == T001W.WERKS