SAP ABAP Table KURGV (Payer's View on Customer Master Record)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ MG (Package) Application development R/3 material master prior to 3.0

Basic Data

Table Category	INTTAB	Structure
Structure	KURGV	Table Relationship Diagram
Short Description	Payer's View on Customer Master Record

Delivery and Maintenance

Pool/cluster
Delivery Class
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	KUNNR	☐	KUNRG	KUNNR	CHAR	10	0	Payer	KNA1
2	NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
3	STRAS	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
4	PFACH	☐	PFACH	PFACH	CHAR	10	0	PO Box
5	PSTLZ	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
6	PSTL2	☐	PSTL2	PSTLZ	CHAR	10	0	P.O. Box Postal Code
7	ORT01	☐	ORT01	TEXT25	CHAR	25	0	City
8	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
9	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
10	TELF1	☐	TELF1	TEXT16	CHAR	16	0	First telephone number
11	KKBER	☐	KKBER	KKBER	CHAR	4	0	Credit control area	T014
12	KNKLI	☐	KNKLI	KUNNR	CHAR	10	0	Customer's account number with credit limit reference	KNA1
13	KLIMK	☐	KLIMK	WERT8	CURR	15	2	Customer's credit limit
14	SAUFT	☐	SAUFT	WRTV8	CURR	15	2	Total of the sales values for the credit limit check
15	SKFOR	☐	SKFOR	WRTV8	CURR	15	2	Total receivables (for credit limit check)
16	SSOBL	☐	SSOBL	WRTV8	CURR	15	2	Relevant special liabilities for credit limit check
17	WAERS	☐	WAERS_KNKK	WAERS	CUKY	5	0	Currency in which the credit limit is to be managed	TCURC
18	MRNKZ	☐	MRNKZ	XFELD	CHAR	1	0	Manual invoice maintenance
19	PERFK	☐	PERFK	WFCID	CHAR	2	0	Invoice dates (calendar identification)	TFACD
20	PERRL	☐	PERRL	WFCID	CHAR	2	0	Invoice list schedule (calendar identification)	*
21	KVAWT	☐	KVAWT	WERT7	CURR	13	2	Value limit for cost estimate (inactive)
22	KTGRD	☐	KTGRD	KTGRD	CHAR	2	0	Account assignment group for this customer	TVKT
23	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
24	VALTG	☐	VALTG	TAGE2	NUMC	2	0	Additional value days
25	VALDT	☐	VALDT	DATUM	DATS	8	0	Fixed value date
26	VSORT	☐	VSORT	VBELN	CHAR	10	0	Item proposal	VBUK
27	FAKSD	☐	FAKSD_V	FAKSP	CHAR	2	0	Billing block for customer (sales and distribution)	TVFS
28	AUFSD	☐	AUFSD	KAUFS	CHAR	2	0	Customer blocked for orders	TVAST
29	STCEG	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
30	STCEG_L	☐	STCEG_L	LAND1	CHAR	3	0	Country of sales tax ID number	*
31	TAXK1	☐	TAXK1	TAXKD	CHAR	1	0	Tax classification 1 for customer	*
32	TAXK2	☐	TAXK2	TAXKD	CHAR	1	0	Tax classification 2 for customer	*
33	TAXK3	☐	TAXK3	TAXKD	CHAR	1	0	Tax classification 3 for customer	*
34	TAXK4	☐	TAXK4	TAXKD	CHAR	1	0	Tax classification 4 for customer	*
35	TAXK5	☐	TAXK5	TAXKD	CHAR	1	0	Tax classification 5 for customer	*
36	TAXK6	☐	TAXK6	TAXKD	CHAR	1	0	Tax classification 6 for customer	*
37	TAXK7	☐	TAXK7	TAXKD	CHAR	1	0	Tax classification 7 for customer	*
38	TAXK8	☐	TAXK8	TAXKD	CHAR	1	0	Tax classification 8 for customer	*
39	TAXK9	☐	TAXK9	TAXKD	CHAR	1	0	Tax classification 9 for customer	*
40	BOKRE	☐	BOKRE	XFELD	CHAR	1	0	ID: Customer is to receive rebates
41	BOIDT	☐	BOIDT	DATUM	DATS	8	0	Start of validity per.for the rebate index for the customer
42	GRUPP	☐	GRUPP_CM	GRUPP_CM	CHAR	4	0	Customer credit group	*
43	SBGRP	☐	SBGRP_CM	SBGRP_CM	CHAR	3	0	Credit Representative Group for Credit Management	*
44	CTLPC	☐	CTLPC_CM	CTLPC_CM	CHAR	3	0	Credit management: Risk category	*
45	VBUND	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	*
46	KABSS	☐	KABSSCH_CM	KABSSCH_CM	CHAR	4	0	Customer payment guarantee procedure
47	TXTPA	☐	TXTPA	TXTPA	CHAR	255	0	Display text for partners (name, city, country, street)
48	.INCLUDE	☐				0	0	Payer view of the customer master: Customer modification
49	DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
50	ADRNR	☐	ADRNR	ADRNR	CHAR	10	0	Address	*
51	ADDRESS_TYPE	☐	AD_ADRTYPE	AD_ADRTYPE	CHAR	1	0	Address type (1=Organization, 2=Person, 3=Contact person)
52	DEAR5	☐	DEAR5	XFELD	CHAR	1	0	ID for default sold-to party

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	KURGV	AUFSD	TVAST	AUFSP
2	KURGV	FAKSD	TVFS	FAKSP
3	KURGV	KKBER	T014	KKBER
4	KURGV	KNKLI	KNA1	KUNNR
5	KURGV	KTGRD	TVKT	KTGRD
6	KURGV	KUNNR	KNA1	KUNNR
7	KURGV	LAND1	T005	LAND1
8	KURGV	PERFK	TFACD	IDENT
9	KURGV	SPRAS	T002	SPRAS
10	KURGV	VSORT	VBUK	VBELN
11	KURGV	WAERS	TCURC	WAERS

History

Last changed by/on	SAP	20130529
SAP Release Created in