S173

Vendor billing document item | #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
WERKS FK Plant
MATKL FK Material Group
LTSNR FK Supplier Subrange
MATNR FK Material Number
LFTYP Settlement Document Category Show values
Column Name Description
💲 Statistics Currency (WSTWAE):
BRTWR_P_LF Key figure: Gross value of vendor billing document (item)
NETWR_P_LF Key figure: net value of vendor billing document (item)
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
📏 Unit of Measure of Settlement Management Doc Item Quantity (WFKME):
MENGE_P_LF Key figure: Vendor billing document quantity
📏 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
AWBRP_LF Key figure: No. of vendor billing document items MCZAEHLER
Master Data Relations Join Conditions
Company Code
  • S173.MANDT == T001.MANDT
  • S173.BUKRS == T001.BUKRS
Purchasing Group
  • Purchasing Group
  • Client
  • S173.EKGRP == T024.EKGRP
  • S173.MANDT == T024.MANDT
Purchasing organization
  • S173.MANDT == T024E.MANDT
  • S173.EKORG == T024E.EKORG
Weight Unit
  • S173.MANDT == T006.MANDT
  • S173.GEWEI == T006.MSEHI
Payee
  • S173.MANDT == LFA1.MANDT
  • S173.LNRZB == LFA1.LIFNR
Supplier Subrange
  • Supplier Subrange
  • Payee
  • Client
  • S173.LTSNR == WYT1.LTSNR
  • S173.LNRZB == WYT1.LIFNR
  • S173.MANDT == WYT1.MANDT
Client S173.MANDT == T000.MANDT
Material Group
  • S173.MANDT == T023.MANDT
  • S173.MATKL == T023.MATKL
Material Number
  • Material Number
  • Client
  • S173.MATNR == MARA.MATNR
  • S173.MANDT == MARA.MANDT
Points Unit
  • S173.MANDT == T006.MANDT
  • S173.PUNEI == T006.MSEHI
Volume unit
  • S173.MANDT == T006.MANDT
  • S173.VOLEH == T006.MSEHI
Plant
  • S173.MANDT == T001W.MANDT
  • S173.WERKS == T001W.WERKS
Unit of Measure of Settlement Management Doc Item Quantity
  • S173.MANDT == T006.MANDT
  • S173.WFKME == T006.MSEHI
Statistics Currency
  • S173.MANDT == TCURC.MANDT
  • S173.WSTWAE == TCURC.WAERS