SAP Table S172

Vendor billing document data

The table S172 (Vendor billing document data) is a standard table in SAP ERP. It belongs to the package MCS.

Technical Information

Table	S172
Short Text	Vendor billing document data
Package	MCS
Table Type	Transparent Table

Fields for Table S172

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