S171

Payment item data | #itemdata | 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
VKORG FK Sales Organization
VTWEG FK Distribution Channel
SPART FK Division
BUKRS FK Company Code
LNRZB FK Payee
KUNRG FK Payer
LFTYP Settlement Document Category Show values
MATKL FK Material Group
Column Name Description
💲 Statistics Currency (WSTWAE):
BRTWR_P_RG Key figure: Gross value of payment (item) to vendor
NETWR_P_RG Key figure: Net value of payment (item) to vendor
KZWI2_P_RG Key Figure: Payment based on Remuneration List Conditions
KZWI1_P_RG Key figure: condition subtotal 1, payment: vendor
KZWI3_P_RG Key figure: condition subtotal 3, payment
KZWI4_P_RG Key figure: condition subtotal 4, payment
KZWI5_P_RG Key figure: condition subtotal 5, payment
KZWI6_P_RG Key figure: Condition subtotal 6, payment
BONBA_P_RG Key fig: Rebate basis (condition subtotal 7), payt: vendor
KZWIS_P_RG Key figure: Effective value of payment (vendor)
Column Name Description
Column Name Description
SPTAG Period to analyze - current date
Column Name Description
LFTYP Settlement Document Category Show values
Column Name Description Domain name
PERIV Fiscal Year Variant PERIV
VWDAT Pointer to administrative data VWDAT
AWBRP_RG Key figure: Number of payment request items MCZAEHLER
Master Data Relations Join Conditions
Company Code
  • S171.MANDT == T001.MANDT
  • S171.BUKRS == T001.BUKRS
Purchasing organization
  • S171.MANDT == T024E.MANDT
  • S171.EKORG == T024E.EKORG
Payer
  • S171.MANDT == KNA1.MANDT
  • S171.KUNRG == KNA1.KUNNR
Payee
  • S171.MANDT == LFA1.MANDT
  • S171.LNRZB == LFA1.LIFNR
Client S171.MANDT == T000.MANDT
Material Group
  • S171.MANDT == T023.MANDT
  • S171.MATKL == T023.MATKL
Division
  • S171.MANDT == TSPA.MANDT
  • S171.SPART == TSPA.SPART
Sales Organization
  • S171.MANDT == TVKO.MANDT
  • S171.VKORG == TVKO.VKORG
Distribution Channel
  • Distribution Channel
  • Client
  • S171.VTWEG == TVTW.VTWEG
  • S171.MANDT == TVTW.MANDT
Statistics Currency
  • S171.MANDT == TCURC.MANDT
  • S171.WSTWAE == TCURC.WAERS