SAP ABAP Table KNB1_MEM (Customer Master: Company Code Data + Status Information)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BF (Application Component) Basic Functions
     ⤷ VSCORE (Package) B2R: BAPI Structures

Basic Data

Table Category	INTTAB	Structure
Structure	KNB1_MEM	Table Relationship Diagram
Short Description	Customer Master: Company Code Data + Status Information

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	.INCLUDE	☐				0	0	Customer Master (Company Code)
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
4	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
5	PERNR	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
6	.INCLUDE	☐				0	0	Customer Master (Company Code)
7	ERDAT	☐	ERDAT_RF	DATUM	DATS	8	0	Date on which the Record Was Created
8	ERNAM	☐	ERNAM_RF	USNAM	CHAR	12	0	Name of Person who Created the Object
9	SPERR	☐	SPERB_B	XFELD	CHAR	1	0	Posting block for company code
10	LOEVM	☐	LOEVM_B	XFELD	CHAR	1	0	Deletion Flag for Master Record (Company Code Level)
11	ZUAWA	☐	DZUAWA	ZUAWA	CHAR	3	0	Key for sorting according to assignment numbers	TZUN
12	BUSAB	☐	BUSAB	BUSAB	CHAR	2	0	Accounting clerk	T001S
13	AKONT	☐	AKONT	SAKNR	CHAR	10	0	Reconciliation Account in General Ledger	SKB1
14	BEGRU	☐	BRGRU	BRGRU	CHAR	4	0	Authorization Group	*
15	KNRZE	☐	KNRZE	KUNNR	CHAR	10	0	Head office account number (in branch accounts)	KNA1
16	KNRZB	☐	KNRZB	KUNNR	CHAR	10	0	Account number of an alternative payer	KNA1
17	ZAMIM	☐	DZAMIM	XFELD	CHAR	1	0	Indicator: Payment notice to customer (with cleared items)?
18	ZAMIV	☐	DZAMIV	XFELD	CHAR	1	0	Indicator: payment notice to sales department?
19	ZAMIR	☐	DZAMIR	XFELD	CHAR	1	0	Indicator: payment notice to legal department?
20	ZAMIB	☐	DZAMIB	XFELD	CHAR	1	0	Indicator: Payment notice to the accounting department ?
21	ZAMIO	☐	DZAMIO	XFELD	CHAR	1	0	Indicator: payment notice to customer (w/o cleared items)?
22	ZWELS	☐	DZWELS	ZWELS	CHAR	10	0	List of the Payment Methods to be Considered
23	XVERR	☐	XVERR_KNB1	XFELD	CHAR	1	0	Indicator: Clearing between customer and vendor ?
24	ZAHLS	☐	DZAHLS	ZAHLS	CHAR	1	0	Block Key for Payment	T008
25	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
26	WAKON	☐	WAKON	ZTERM	CHAR	4	0	Terms of payment key for bill of exchange charges
27	VZSKZ	☐	VZSKZ	VZSKZ	CHAR	2	0	Interest calculation indicator	T056
28	ZINDT	☐	DZINDT	DATUM	DATS	8	0	Key date of the last interest calculation
29	ZINRT	☐	DZINRT	ZINRT	NUMC	2	0	Interest calculation frequency in months
30	EIKTO	☐	EIKTO_D	CHAR12	CHAR	12	0	Our account number at customer
31	ZSABE	☐	DZSABE_D	TEXT15	CHAR	15	0	User at customer
32	KVERM	☐	KVERM	TEXT30	CHAR	30	0	Memo
33	FDGRV	☐	FDGRV	FDGRP	CHAR	10	0	Planning group	T035
34	VRBKZ	☐	VRBKZ	VRBKZ	CHAR	2	0	Export credit insurance institution number
35	VLIBB	☐	VLIBB	WERT7	CURR	13	2	Amount Insured
36	VRSZL	☐	VRSZL	PACK2	DEC	3	0	Insurance lead months
37	VRSPR	☐	VRSPR	PACK2	DEC	3	0	Deductible percentage rate
38	VRSNR	☐	VRSNR	CHAR10	CHAR	10	0	Insurance number
39	VERDT	☐	VERDT	DATUM	DATS	8	0	Insurance validity date
40	PERKZ	☐	PERKZ_KNB1	PERKZ_KNB1	CHAR	1	0	Collective invoice variant
41	XDEZV	☐	XDEZV	XFELD	CHAR	1	0	Indicator: Local processing?
42	XAUSZ	☐	XAUSZ	AUSZG	CHAR	1	0	Indicator for periodic account statements	T048K
43	WEBTR	☐	WEBTR	WERT7	CURR	13	2	Bill of exchange limit (in local currency)
44	REMIT	☐	REMIT	KUNNR	CHAR	10	0	Next payee	KNA1
45	DATLZ	☐	DATLZ	DATUM	DATS	8	0	Date of the last interest calculation run
46	XZVER	☐	XZVER	XFELD	CHAR	1	0	Indicator: Record Payment History ?
47	TOGRU	☐	TOGRU	TOGRU	CHAR	4	0	Tolerance group for the business partner/G/L account	T043G
48	KULTG	☐	KULTG	PACK2	DEC	3	0	Probable time until check is paid
49	HBKID	☐	HBKID	HBKID	CHAR	5	0	Short key for a house bank	T012
50	XPORE	☐	XPORE	XFELD	CHAR	1	0	Indicator: Pay all items separately ?
51	BLNKZ	☐	BLNKZ	BLNKZ	CHAR	2	0	Subsidy Indicator for Determining the Reduction Rates	*
52	ALTKN	☐	ALTKN	CHAR10	CHAR	10	0	Previous Master Record Number
53	ZGRUP	☐	DZGRUP	ZGRUP	CHAR	2	0	Key for Payment Grouping	TZGR
54	URLID	☐	URLID	URLID	CHAR	4	0	Short Key for Known/Negotiated Leave	T052A
55	MGRUP	☐	MGRUP	MGRUP	CHAR	2	0	Key for dunning notice grouping	T047R
56	LOCKB	☐	LOCKB	LCKID	CHAR	7	0	Key of the Lockbox to Which the Customer Is To Pay	T049L
57	UZAWE	☐	UZAWE	UZAWE	CHAR	2	0	Payment method supplement	T042F
58	EKVBD	☐	EKVBD	KUNNR	CHAR	10	0	Account Number of Buying Group	KNA1
59	SREGL	☐	SREGL	SREGL	CHAR	3	0	Selection Rule for Payment Advices	T053A
60	XEDIP	☐	XEDIP	XFELD	CHAR	1	0	Indicator: Send Payment Advices by EDI
61	FRGRP	☐	FRGRP	FRGRP	CHAR	4	0	Release Approval Group	VBWF08
62	VRSDG	☐	VRSDG	VRSDG	CHAR	3	0	Reason Code Conversion Version	T053V
63	TLFXS	☐	TLFXS	TEXT31	CHAR	31	0	Accounting clerk's fax number at the customer/vendor
64	INTAD	☐	INTAD	TXT130	CHAR	130	0	Internet address of partner company clerk
65	XKNZB	☐	XKNZB	XFELD	CHAR	1	0	Indicator: Alternative payer using account number
66	GUZTE	☐	GUZTE	ZTERM	CHAR	4	0	Payment Terms Key for Credit Memos
67	GRICD	☐	J_1AGICD_D	J_1AGICD2	CHAR	2	0	Activity Code for Gross Income Tax	J_1AGICD
68	GRIDT	☐	J_1ADTYP_D	J_1ADTYP	CHAR	2	0	Distribution Type for Employment Tax	J_1ADTYP
69	WBRSL	☐	WBRSL	WBRSL	CHAR	2	0	Value Adjustment Key	T044G
70	CONFS	☐	CONFS_B	CHAR1	CHAR	1	0	Status of Change Authorization (Company Code Level)
71	UPDAT	☐	UPDAT_RF	DATUM	DATS	8	0	Date on Which the Changes Were Confirmed
72	UPTIM	☐	UPTIM_RF	AS4TIME	TIMS	6	0	Time of Last Change Confirmation
73	NODEL	☐	NODEL_B	XFELD	CHAR	1	0	Deletion bock for master record (company code level)
74	TLFNS	☐	TLFNS	CHAR30	CHAR	30	0	Accounting clerk's telephone number at business partner
75	CESSION_KZ	☐	CESSION_KZ	CESSION_KZ	CHAR	2	0	Accounts Receivable Pledging Indicator	TCESSION
76	AVSND	☐	AVSND	AVSND	CHAR	1	0	Indicator: Send Payment Advice by XML
77	AD_HASH	☐	ADHASH	ADHASH	CHAR	10	0	E-Mail Address for Avis: Hash Value
78	QLAND	☐	QLAND	QLAND	CHAR	3	0	Withholding Tax Country Key	T005Q
79	.INCLU--AP	☐				0	0	IS-PS: Customer Master Record, Additional Data (Co.Code)
80	GMVKZD	☐	GMVKZD	XFELD	CHAR	1	0	Customer is in execution
81	KZ	☐	CDCHNGIND	CDCHNGIND	CHAR	1	0	Change type (U, I, E, D)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	KNB1_MEM	AKONT	SKB1	SAKNR	REF	1	CN
2	KNB1_MEM	BUKRS	T001	BUKRS	KEY	1	CN
3	KNB1_MEM	BUSAB	T001S	BUSAB	REF	C	CN
4	KNB1_MEM	CESSION_KZ	TCESSION	CESSION_KZ		1	CN
5	KNB1_MEM	EKVBD	KNA1	KUNNR	REF	C	CN
6	KNB1_MEM	FDGRV	T035	GRUPP	REF	C	CN
7	KNB1_MEM	FRGRP	VBWF08	FRGRP	REF	C	CN
8	KNB1_MEM	GRICD	J_1AGICD	J_1AGICD		1	CN
9	KNB1_MEM	GRIDT	J_1ADTYP	J_1ADTYP		1	CN
10	KNB1_MEM	HBKID	T012	HBKID	REF	C	CN
11	KNB1_MEM	KNRZB	KNA1	KUNNR	REF	C	CN
12	KNB1_MEM	KNRZE	KNA1	KUNNR	REF	C	CN
13	KNB1_MEM	KUNNR	KNA1	KUNNR	KEY	1	CN
14	KNB1_MEM	LOCKB	T049L	LOCKB	REF	C	CN
15	KNB1_MEM	MANDT	T000	MANDT	KEY	1	CN
16	KNB1_MEM	MGRUP	T047R	MGRUP	REF	C	CN
17	KNB1_MEM	QLAND	T005Q	QLAND
18	KNB1_MEM	REMIT	KNA1	KUNNR	REF	C	CN
19	KNB1_MEM	SREGL	T053A	SREGL	REF	C	CN
20	KNB1_MEM	TOGRU	T043G	TOGRU	REF	C	CN
21	KNB1_MEM	URLID	T052A	URLID	REF	C	CN
22	KNB1_MEM	UZAWE	T042F	UZAWE	REF	C	CN
23	KNB1_MEM	VRSDG	T053V	VRSDG	REF	C	CN
24	KNB1_MEM	VZSKZ	T056	VZSKZ	REF	C	CN
25	KNB1_MEM	WBRSL	T044G	WBRSL	REF	C	CN
26	KNB1_MEM	XAUSZ	T048K	XAUSZ	REF	C	CN
27	KNB1_MEM	ZAHLS	T008	ZAHLS	REF	C	CN
28	KNB1_MEM	ZGRUP	TZGR	ZGRUP	REF	C	CN
29	KNB1_MEM	ZUAWA	TZUN	ZUAWA	REF	C	CN

History

Last changed by/on	SAP	20131127
SAP Release Created in