S172 - Vendor billing document data

Vendor billing document data information is stored in SAP table S172.
It is part of development package MCS in software component LO-LIS-DC. This development package consists of objects that can be grouped under "R/3 application development: Logistics Information Warehouse".

Fields for table S172

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6	T000
SSOUR	Statistic(s) origin	X	SSOUR	CHAR	8
VRSIO	Version number in the information structure	X	VRSIO	CHAR	6
SPMON	Period to analyze - month	X	SPMON	NUMC	12
SPTAG	Period to analyze - current date	X	SPTAG	DATS	16
SPWOC	Period to analyze - week	X	SPWOC	NUMC	12
SPBUP	Period to analyze - posting period	X	SPBUP	NUMC	12
EKORG	Purchasing organization	X	EKORG	CHAR	8	T024E
EKGRP	Purchasing Group	X	EKGRP	CHAR	6	T024
BUKRS	Company Code	X	BUKRS	CHAR	8	T001
LNRZB	Payee	X	W_LIFZE	CHAR	20	LFA1
LFTYP	Settlement Document Category	X	WFTYP	CHAR	4
PERIV	Fiscal Year Variant		PERIV	CHAR	4
VWDAT	Pointer to administrative data		VWDAT	NUMC	20
WSTWAE	Statistics Currency		WSTWAE	CUKY	10	TCURC
GEWEI	Weight Unit		GEWEI	UNIT	6	T006
VOLEH	Volume unit		VOLEH	UNIT	6	T006
PUNEI	Points Unit		PUNEI	UNIT	6	T006
BRTWR_LF	Key figure: Gross value of vendor billing document		MC_BRTWRLF	CURR	9
NETWR_LF	Key figure: net value of vendor billing document		MC_NETWRLF	CURR	9
BRTWR_LFRL	Key fig.: Final Amt, Remuneration List (Vendor Billing Doc.)		MC_BRTLFRL	CURR	9
NETWR_LFRL	Key Fig: Net Value of Remuneration List, Vendor Billing Doc.		MC_NETLFRL	CURR	9
KWERT_LFRL	Key figure: Value of Remuneration List Conditions: VBD		MC_KWERTLF	CURR	9
MWSRL_LFRL	Key fig.: Tax Remuneration List Conditions (del credere) VBD		MC_MWSRLLF	CURR	9
MWSBP_LFRL	Key Figure: Tax Amount Remuneratn List, Vendor Billing Doc.		MC_MWSBPLF	CURR	9
NAVNW_LFRL	Key Figure: Non-Deductible Input Tax, Remuneration List VBD		MC_NAVNWLF	CURR	9
BRGEW_P_LF	Key figure: gross weight of vendor billing document		MC_BRGEWLF	QUAN	8
NTGEW_P_LF	Key figure: Net weight of vendor billing document		MC_NTGEWLF	QUAN	8
VOLUM_P_LF	Key figure: volume of vendor billing document		MC_VOLUMLF	QUAN	8
ANZPU_P_LF	Key figure: Points, vendor billing document		MC_PUNKTLF	QUAN	8
KZWI1_P_LF	Key figure: condition subtotal 1, vendor billing document		MC_KZWI1LF	CURR	9
KZWI2_P_LF	Key figure: condition subtotal 2, vendor billing document		MC_KZWI2LF	CURR	9
KZWI3_P_LF	Key figure: condition subtotal 3, vendor billing document		MC_KZWI3LF	CURR	9
KZWI4_P_LF	Key figure: condition subtotal 4, vendor billing document		MC_KZWI4LF	CURR	9
KZWI5_P_LF	Key figure: condition subtotal 5, vendor billing document		MC_KZWI5LF	CURR	9
KZWI6_P_LF	Key figure: condition subtotal 6, vendor billing document		MC_KZWI6LF	CURR	9
BONBA_P_LF	Key figure: Rebate basis (subtotal 7), vendor billing doc.		MC_BONBALF	CURR	9
KZWIS_P_LF	Key figure: effective value of vendor billing document		MC_EFFEKLF	CURR	9
AWBRK_LF	Key figure: Number of vendor billing documents		MC_AWBRKRL	DEC	5
AWBRP_LF	Key figure: No. of vendor billing document items		MC_AWBRPRL	DEC	5
AWBRK_LFRL	Key Figure: No. of Invoice Lists (Vendor Billing Document)		MC_ARLRKRL	DEC	5
AWBRL_LFRL	Key figure: no. of documents in invoice lists (VBD)		MC_ARLRPRL	DEC	5