SAP ABAP Table S171 (Payment item 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	S171	Table Relationship Diagram
Short Description	Payment item 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	VKORG	☑	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
10	VTWEG	☑	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
11	SPART	☑	SPART	SPART	CHAR	2	0	Division	TSPA
12	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
13	LNRZB	☑	W_LIFZE	LIFNR	CHAR	10	0	Agency business: Payee	LFA1
14	KUNRG	☑	KUNRG	KUNNR	CHAR	10	0	Payer	KNA1
15	LFTYP	☑	WFTYP	WFTYP	CHAR	2	0	Agency business: Billing category
16	MATKL	☑	MATKL	MATKL	CHAR	9	0	Material Group	T023
17	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	*
18	VWDAT	☐	VWDAT	VWDAT	NUMC	10	0	Pointer to administrative data
19	WSTWAE	☐	WSTWAE	WAERS	CUKY	5	0	Agency Business: Statistics Currency	TCURC
20	BRTWR_P_RG	☐	MC_BRTWPRG	WERTV9	CURR	17	2	Key figure: Gross value of payment (item) to vendor
21	NETWR_P_RG	☐	MC_NETWPRG	WERTV9	CURR	17	2	Key figure: Net value of payment (item) to vendor
22	KZWI2_P_RG	☐	MC_DELKRRG	WERTV9	CURR	17	2	Key Figure: Payment based on Remuneration List Conditions
23	KZWI1_P_RG	☐	MC_KZWI1RG	WERTV9	CURR	17	2	Key figure: condition subtotal 1, payment: vendor
24	KZWI3_P_RG	☐	MC_KZWI3RG	WERTV9	CURR	17	2	Key figure: condition subtotal 3, payment
25	KZWI4_P_RG	☐	MC_KZWI4RG	WERTV9	CURR	17	2	Key figure: condition subtotal 4, payment
26	KZWI5_P_RG	☐	MC_KZWI5RG	WERTV9	CURR	17	2	Key figure: condition subtotal 5, payment
27	KZWI6_P_RG	☐	MC_KZWI6RG	WERTV9	CURR	17	2	Key figure: Condition subtotal 6, payment
28	BONBA_P_RG	☐	MC_BONBARG	WERTV9	CURR	17	2	Key fig: Rebate basis (condition subtotal 7), payt: vendor
29	KZWIS_P_RG	☐	MC_EFFEKRG	WERTV9	CURR	17	2	Key figure: Effective value of payment (vendor)
30	AWBRP_RG	☐	MC_AWBRPRG	MCZAEHLER	DEC	9	0	Key figure: Number of payment request items

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	S171	BUKRS	T001	BUKRS	KEY	1	CN
2	S171	EKORG	T024E	EKORG	KEY	C	CN
3	S171	KUNRG	KNA1	KUNNR	KEY	C	CN
4	S171	LNRZB	LFA1	LIFNR	KEY	C	CN
5	S171	MANDT	T000	MANDT
6	S171	MATKL	T023	MATKL		1	CN
7	S171	SPART	TSPA	SPART	KEY	C	CN
8	S171	VKORG	TVKO	VKORG	KEY	C	CN
9	S171	VTWEG	TVTW	VTWEG	KEY	C	CN
10	S171	WSTWAE	TCURC	WAERS		1	CN

History

Last changed by/on	SAP	20050411
SAP Release Created in