S172

Vendor billing 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
BUKRS FK Company Code
LNRZB FK Payee
LFTYP Settlement Document Category Show values
Column Name Description
💲 Statistics Currency (WSTWAE):
BRTWR_LF Key figure: Gross value of vendor billing document
NETWR_LF Key figure: net value of vendor billing document
BRTWR_LFRL Key fig.: Final Amt, Remuneration List (Vendor Billing Doc.)
NETWR_LFRL Key Fig: Net Value of Remuneration List, Vendor Billing Doc.
KWERT_LFRL Key figure: Value of Remuneration List Conditions: VBD
MWSRL_LFRL Key fig.: Tax Remuneration List Conditions (del credere) VBD
MWSBP_LFRL Key Figure: Tax Amount Remuneratn List, Vendor Billing Doc.
NAVNW_LFRL Key Figure: Non-Deductible Input Tax, Remuneration List VBD
KZWI1_P_LF Key figure: condition subtotal 1, vendor billing document
KZWI2_P_LF Key figure: condition subtotal 2, vendor billing document
KZWI3_P_LF Key figure: condition subtotal 3, vendor billing document
KZWI4_P_LF Key figure: condition subtotal 4, vendor billing document
KZWI5_P_LF Key figure: condition subtotal 5, vendor billing document
KZWI6_P_LF Key figure: condition subtotal 6, vendor billing document
BONBA_P_LF Key figure: Rebate basis (subtotal 7), vendor billing doc.
KZWIS_P_LF Key figure: effective value of vendor billing document
Column Name Description
📏 Weight Unit (GEWEI):
BRGEW_P_LF Key figure: gross weight of vendor billing document
NTGEW_P_LF Key figure: Net weight of vendor billing document
📏 Volume unit (VOLEH):
VOLUM_P_LF Key figure: volume of vendor billing document
📏 Points Unit (PUNEI):
ANZPU_P_LF Key figure: Points, vendor billing document
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_LF Key figure: Number of vendor billing documents MCZAEHLER
AWBRP_LF Key figure: No. of vendor billing document items MCZAEHLER
AWBRK_LFRL Key Figure: No. of Invoice Lists (Vendor Billing Document) MCZAEHLER
AWBRL_LFRL Key figure: no. of documents in invoice lists (VBD) MCZAEHLER
Master Data Relations Join Conditions
Company Code
  • S172.MANDT == T001.MANDT
  • S172.BUKRS == T001.BUKRS
Purchasing Group
  • Purchasing Group
  • Client
  • S172.EKGRP == T024.EKGRP
  • S172.MANDT == T024.MANDT
Purchasing organization
  • S172.MANDT == T024E.MANDT
  • S172.EKORG == T024E.EKORG
Weight Unit
  • S172.MANDT == T006.MANDT
  • S172.GEWEI == T006.MSEHI
Payee
  • S172.MANDT == LFA1.MANDT
  • S172.LNRZB == LFA1.LIFNR
Client S172.MANDT == T000.MANDT
Points Unit
  • S172.MANDT == T006.MANDT
  • S172.PUNEI == T006.MSEHI
Volume unit
  • S172.MANDT == T006.MANDT
  • S172.VOLEH == T006.MSEHI
Statistics Currency
  • S172.MANDT == TCURC.MANDT
  • S172.WSTWAE == TCURC.WAERS