S174BIW2

S174BIW2 * Activities | #other | 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
SRVPOS FK Activity Number
LIFNR FK Vendor's account number
MATKL FK Material Group
EKORG FK Purchasing organization
WERKS FK Plant
MEINS FK Base Unit of Measure
Column Name Description
💲 Purchase order currency (BSTWA):
VAL Order value in document currency
💲 Local Currency (HWAER):
VAL_ACC Accepted value in local currency
VAL_ACCUP Unplanned portion of accepted value
VAL_ACCUP2 Unplanned portion (w/o ref. to contract) of accepted value
VAL_IV Invoice value in local currency
Column Name Description
📏 Base unit of measure (BASME):
QUAN Purchase order quantity
QUAN_ACC Accepted quantity
QUAN_IV Invoice receipt quantity
Column Name Description
SPTAG Period to analyze - current date
Column Name Description
Column Name Description Domain name
PERIV Fiscal Year Variant PERIV
VWDAT Pointer to administrative data VWDAT
Master Data Relations Join Conditions
Base unit of measure
  • S174BIW2.MANDT == T006.MANDT
  • S174BIW2.BASME == T006.MSEHI
Purchase order currency
  • S174BIW2.MANDT == TCURC.MANDT
  • S174BIW2.BSTWA == TCURC.WAERS
Purchasing organization
  • S174BIW2.MANDT == T024E.MANDT
  • S174BIW2.EKORG == T024E.EKORG
Local Currency
  • S174BIW2.MANDT == TCURC.MANDT
  • S174BIW2.HWAER == TCURC.WAERS
Vendor's account number
  • S174BIW2.MANDT == LFA1.MANDT
  • S174BIW2.LIFNR == LFA1.LIFNR
Client S174BIW2.MANDT == T000.MANDT
Material Group
  • S174BIW2.MANDT == T023.MANDT
  • S174BIW2.MATKL == T023.MATKL
Base Unit of Measure
  • S174BIW2.MANDT == T006.MANDT
  • S174BIW2.MEINS == T006.MSEHI
Activity Number
  • S174BIW2.MANDT == ASMD.MANDT
  • S174BIW2.SRVPOS == ASMD.ASNUM
Plant
  • S174BIW2.MANDT == T001W.MANDT
  • S174BIW2.WERKS == T001W.WERKS