SAP ABAP Table S170 (Payment 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	S170	Table Relationship Diagram
Short Description	Payment 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	VKORG	☑	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
11	VTWEG	☑	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
12	SPART	☑	SPART	SPART	CHAR	2	0	Division	TSPA
13	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
14	LNRZB	☑	W_LIFZE	LIFNR	CHAR	10	0	Agency business: Payee	LFA1
15	KUNRG	☑	KUNRG	KUNNR	CHAR	10	0	Payer	KNA1
16	LFTYP	☑	WFTYP	WFTYP	CHAR	2	0	Agency business: Billing category
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_RG	☐	MC_BRTWRRG	WERTV9	CURR	17	2	Key figure: Gross value of payment request (vendor)
21	NETWR_RG	☐	MC_NETWRRG	WERTV9	CURR	17	2	Key figure: Net value of payment request to vendor
22	BRTWR_RGRL	☐	MC_BRTRGRL	WERTV9	CURR	17	2	Key Fig.: Final Amt of Remuneration List, Payment: Customer
23	NETWR_RGRL	☐	MC_NETRGRL	WERTV9	CURR	17	2	Key Figure: Net Value of Remuneration List, Payment: Vendor
24	KZWI2_P_RG	☐	MC_DELKRRG	WERTV9	CURR	17	2	Key Figure: Payment based on Remuneration List Conditions
25	KWERT_RGRL	☐	MC_KWERTRG	WERTV9	CURR	17	2	Key figure: Value of Remuneration List Conditions, Payment
26	MWSRL_RGRL	☐	MC_MWSRLRG	WERTV9	CURR	17	2	Key figure: Tax invoice list cond. (del credere), payment
27	MWSBP_RGRL	☐	MC_MWSBPRG	WERTV9	CURR	17	2	Key Figure: Tax Amount Remuneration List, Payment
28	KZWI1_P_RG	☐	MC_KZWI1RG	WERTV9	CURR	17	2	Key figure: condition subtotal 1, payment: vendor
29	KZWI3_P_RG	☐	MC_KZWI3RG	WERTV9	CURR	17	2	Key figure: condition subtotal 3, payment
30	KZWI4_P_RG	☐	MC_KZWI4RG	WERTV9	CURR	17	2	Key figure: condition subtotal 4, payment
31	KZWI5_P_RG	☐	MC_KZWI5RG	WERTV9	CURR	17	2	Key figure: condition subtotal 5, payment
32	KZWI6_P_RG	☐	MC_KZWI6RG	WERTV9	CURR	17	2	Key figure: Condition subtotal 6, payment
33	BONBA_P_RG	☐	MC_BONBARG	WERTV9	CURR	17	2	Key fig: Rebate basis (condition subtotal 7), payt: vendor
34	KZWIS_P_RG	☐	MC_EFFEKRG	WERTV9	CURR	17	2	Key figure: Effective value of payment (vendor)
35	AWBRK_RG	☐	MC_AWBRKRG	MCZAEHLER	DEC	9	0	Key figure: Number of payment requests
36	AWBRP_RG	☐	MC_AWBRPRG	MCZAEHLER	DEC	9	0	Key figure: Number of payment request items
37	AWBRK_RLRG	☐	MC_ARLRKRG	MCZAEHLER	DEC	9	0	Key Figure: Number of Remuneration Lists (Payment)
38	AWBRL_RLRG	☐	MC_ARLRPRG	MCZAEHLER	DEC	9	0	Key Figure: No. of Documents in Remuneration Lists (Payment)

Foreign Keys

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

History

Last changed by/on	SAP	20050411
SAP Release Created in