SAP ABAP Table S172 (Vendor billing document data)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ MCS (Package) R/3 application development: Logistics Information Warehouse

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	S172	Table Relationship Diagram
Short Description	Vendor billing document data

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	SSOUR	☑	SSOUR	SSOUR	CHAR	4	0	Statistic(s) origin
3	VRSIO	☑	VRSIO	VRSIO	CHAR	3	0	Version number in the information structure	*
4	SPMON	☑	SPMON	MCPERIOD	NUMC	6	0	Period to analyze - month
5	SPTAG	☑	SPTAG	DATUM	DATS	8	0	Period to analyze - current date
6	SPWOC	☑	SPWOC	MCPERIOD	NUMC	6	0	Period to analyze - week
7	SPBUP	☑	SPBUP	MCPERIOD	NUMC	6	0	Period to analyze - posting period
8	EKORG	☑	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
9	EKGRP	☑	EKGRP	EKGRP	CHAR	3	0	Purchasing group	T024
10	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
11	LNRZB	☑	W_LIFZE	LIFNR	CHAR	10	0	Agency business: Payee	LFA1
12	LFTYP	☑	WFTYP	WFTYP	CHAR	2	0	Agency business: Billing category
13	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	*
14	VWDAT	☐	VWDAT	VWDAT	NUMC	10	0	Pointer to administrative data
15	WSTWAE	☐	WSTWAE	WAERS	CUKY	5	0	Agency Business: Statistics Currency	TCURC
16	GEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	T006
17	VOLEH	☐	VOLEH	MEINS	UNIT	3	0	Volume unit	T006
18	PUNEI	☐	PUNEI	MEINS	UNIT	3	0	Points unit	T006
19	BRTWR_LF	☐	MC_BRTWRLF	WERTV9	CURR	17	2	Key figure: Gross value of vendor billing document
20	NETWR_LF	☐	MC_NETWRLF	WERTV9	CURR	17	2	Key figure: net value of vendor billing document
21	BRTWR_LFRL	☐	MC_BRTLFRL	WERTV9	CURR	17	2	Key fig.: Final Amt, Remuneration List (Vendor Billing Doc.)
22	NETWR_LFRL	☐	MC_NETLFRL	WERTV9	CURR	17	2	Key Fig: Net Value of Remuneration List, Vendor Billing Doc.
23	KWERT_LFRL	☐	MC_KWERTLF	WERTV9	CURR	17	2	Key figure: Value of Remuneration List Conditions: VBD
24	MWSRL_LFRL	☐	MC_MWSRLLF	WERTV9	CURR	17	2	Key fig.: Tax Remuneration List Conditions (del credere) VBD
25	MWSBP_LFRL	☐	MC_MWSBPLF	WERTV9	CURR	17	2	Key Figure: Tax Amount Remuneratn List, Vendor Billing Doc.
26	NAVNW_LFRL	☐	MC_NAVNWLF	WERTV9	CURR	17	2	Key Figure: Non-Deductible Input Tax, Remuneration List VBD
27	BRGEW_P_LF	☐	MC_BRGEWLF	MENGV15_3	QUAN	15	3	Key figure: gross weight of vendor billing document
28	NTGEW_P_LF	☐	MC_NTGEWLF	MENGV15_3	QUAN	15	3	Key figure: Net weight of vendor billing document
29	VOLUM_P_LF	☐	MC_VOLUMLF	MENGV15_3	QUAN	15	3	Key figure: volume of vendor billing document
30	ANZPU_P_LF	☐	MC_PUNKTLF	MENGV15	QUAN	15	3	Key figure: Points, vendor billing document
31	KZWI1_P_LF	☐	MC_KZWI1LF	WERTV9	CURR	17	2	Key figure: condition subtotal 1, vendor billing document
32	KZWI2_P_LF	☐	MC_KZWI2LF	WERTV9	CURR	17	2	Key figure: condition subtotal 2, vendor billing document
33	KZWI3_P_LF	☐	MC_KZWI3LF	WERTV9	CURR	17	2	Key figure: condition subtotal 3, vendor billing document
34	KZWI4_P_LF	☐	MC_KZWI4LF	WERTV9	CURR	17	2	Key figure: condition subtotal 4, vendor billing document
35	KZWI5_P_LF	☐	MC_KZWI5LF	WERTV9	CURR	17	2	Key figure: condition subtotal 5, vendor billing document
36	KZWI6_P_LF	☐	MC_KZWI6LF	WERTV9	CURR	17	2	Key figure: condition subtotal 6, vendor billing document
37	BONBA_P_LF	☐	MC_BONBALF	WERTV9	CURR	17	2	Key figure: Rebate basis (subtotal 7), vendor billing doc.
38	KZWIS_P_LF	☐	MC_EFFEKLF	WERTV9	CURR	17	2	Key figure: effective value of vendor billing document
39	AWBRK_LF	☐	MC_AWBRKRL	MCZAEHLER	DEC	9	0	Key figure: Number of vendor billing documents
40	AWBRP_LF	☐	MC_AWBRPRL	MCZAEHLER	DEC	9	0	Key figure: No. of vendor billing document items
41	AWBRK_LFRL	☐	MC_ARLRKRL	MCZAEHLER	DEC	9	0	Key Figure: No. of Invoice Lists (Vendor Billing Document)
42	AWBRL_LFRL	☐	MC_ARLRPRL	MCZAEHLER	DEC	9	0	Key figure: no. of documents in invoice lists (VBD)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	S172	BUKRS	T001	BUKRS	KEY	1	CN
2	S172	EKGRP	T024	EKGRP	KEY	1	CN
3	S172	EKORG	T024E	EKORG	KEY	C	CN
4	S172	GEWEI	T006	MSEHI
5	S172	LNRZB	LFA1	LIFNR	KEY	C	CN
6	S172	MANDT	T000	MANDT
7	S172	PUNEI	T006	MSEHI
8	S172	VOLEH	T006	MSEHI
9	S172	WSTWAE	TCURC	WAERS		1	CN

History

Last changed by/on	SAP	20050411
SAP Release Created in