S011BIW2

S011BIW2 * PURCHIS: Purchasing Group Statistics | #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
EKGRP FK Purchasing Group
LIFNR FK Vendor's account number
Column Name Description
💲 Local Currency (HWAER):
NETWR Effective order value
REWRT Invoice Amount
Column Name Description
Column Name Description
SPTAG Period to analyze - current date
Column Name Description
Column Name Description Domain name
VWDAT Pointer to administrative data VWDAT
ABEST No. of purchase orders MCZAEHLER
ABSTP Number of purchase order items MCZAEHLER
ABSTE Number of purchase order item schedule lines MCZAEHLER
AANFR Number of requests for quotations MCZAEHLER
AANFP Number of requests for quotation items MCZAEHLER
AANGP Number of Quotation Items MCZAEHLER
AKONT Number of contracts MCZAEHLER
AKONP Number of contract items MCZAEHLER
ALFPL Number of scheduling agreements MCZAEHLER
ALFPP Number of scheduling agreement items MCZAEHLER
ALFPE Number of delivery schedules MCZAEHLER
ALIEF Number of deliveries MCZAEHLER
Master Data Relations Join Conditions
Purchasing Group
  • Purchasing Group
  • Client
  • S011BIW2.EKGRP == T024.EKGRP
  • S011BIW2.MANDT == T024.MANDT
Purchasing organization
  • S011BIW2.MANDT == T024E.MANDT
  • S011BIW2.EKORG == T024E.EKORG
Local Currency
  • S011BIW2.MANDT == TCURC.MANDT
  • S011BIW2.HWAER == TCURC.WAERS
Vendor's account number
  • S011BIW2.MANDT == LFA1.MANDT
  • S011BIW2.LIFNR == LFA1.LIFNR
Client S011BIW2.MANDT == T000.MANDT
Period variant (fiscal year variant)
  • Fiscal Year Variant
  • Client
  • S011BIW2.PERIV == T009.PERIV
  • S011BIW2.MANDT == T009.MANDT