S170

Payment document data | #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
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
Column Name Description
💲 Statistics Currency (WSTWAE):
BRTWR_RG Key figure: Gross value of payment request (vendor)
NETWR_RG Key figure: Net value of payment request to vendor
BRTWR_RGRL Key Fig.: Final Amt of Remuneration List, Payment: Customer
NETWR_RGRL Key Figure: Net Value of Remuneration List, Payment: Vendor
KZWI2_P_RG Key Figure: Payment based on Remuneration List Conditions
KWERT_RGRL Key figure: Value of Remuneration List Conditions, Payment
MWSRL_RGRL Key figure: Tax invoice list cond. (del credere), payment
MWSBP_RGRL Key Figure: Tax Amount Remuneration List, Payment
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
AWBRK_RG Key figure: Number of payment requests MCZAEHLER
AWBRP_RG Key figure: Number of payment request items MCZAEHLER
AWBRK_RLRG Key Figure: Number of Remuneration Lists (Payment) MCZAEHLER
AWBRL_RLRG Key Figure: No. of Documents in Remuneration Lists (Payment) MCZAEHLER
Master Data Relations Join Conditions
Company Code
  • S170.MANDT == T001.MANDT
  • S170.BUKRS == T001.BUKRS
Purchasing Group
  • Purchasing Group
  • Client
  • S170.EKGRP == T024.EKGRP
  • S170.MANDT == T024.MANDT
Purchasing organization
  • S170.MANDT == T024E.MANDT
  • S170.EKORG == T024E.EKORG
Payer
  • S170.MANDT == KNA1.MANDT
  • S170.KUNRG == KNA1.KUNNR
Payee
  • S170.MANDT == LFA1.MANDT
  • S170.LNRZB == LFA1.LIFNR
Client S170.MANDT == T000.MANDT
Division
  • S170.MANDT == TSPA.MANDT
  • S170.SPART == TSPA.SPART
Sales Organization
  • S170.MANDT == TVKO.MANDT
  • S170.VKORG == TVKO.VKORG
Distribution Channel
  • Distribution Channel
  • Client
  • S170.VTWEG == TVTW.VTWEG
  • S170.MANDT == TVTW.MANDT
Statistics Currency
  • S170.MANDT == TCURC.MANDT
  • S170.WSTWAE == TCURC.WAERS