SAP ABAP Table /BEV3/CHBPAOBJS (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	/BEV3/CHBPAOBJS	Table Relationship Diagram
Short Description	Generated Table for View

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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	YVWDNR	☑	/BEV3/CHDTWDNR	/BEV3/CHDOWDNR	NUMC	13	0	CHD Contract Number
3	VBKL	☑	/BEV3/CHBKL	/BEV3/CHBKL	CHAR	4	0	Agreement Class
4	RI	☑	/BEV3/CHDTRI	/BEV3/CHDORI	NUMC	6	0	Rule Identifier
5	VBIN	☑	/BEV3/CHBIN	/BEV3/CHBIN	NUMC	4	0	Agreement Entity
6	VBNR	☑	/BEV3/CHBNR	/BEV3/CHLFN9	NUMC	9	0	Agreement Number in Sequential Time Order
7	VBDTA	☑	/BEV3/CHBDTAV	/BEV3/CHJJJJMMTT	DATS	8	0	Period Visible from
8	YVOBJNR	☑	/BEV3/CHOBJNR	/BEV3/CHOBJNR	NUMC	14	0	Key for Objects
9	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number
10	KUNNR_RG	☐	/BEV3/CHKUNNR_RG	KUNNR	CHAR	10	0	Customer Number of Payer	KNA1
11	VKORG_RG	☐	/BEV3/CHKORG_RG	VKORG	CHAR	4	0	Post Sales Organzation	TVKO
12	VTWEG_RG	☐	/BEV3/CHTWEG_RG	VTWEG	CHAR	2	0	Distribution Channel Post	TVTW
13	SPART_RG	☐	/BEV3/CHSPART_RG	SPART	CHAR	2	0	Division Post	TSPA
14	KUNNR_WE	☐	/BEV3/CHKUNNR_WE	KUNNR	CHAR	10	0	Customer Number of Ship-to Party	KNA1
15	VKORG_WE	☐	/BEV3/CHKORG_WE	VKORG	CHAR	4	0	Sales Organization Performance	TVKO
16	VTWEG_WE	☐	/BEV3/CHTWEG_WE	VTWEG	CHAR	2	0	Distribution Channel Performance	TVTW
17	SPART_WE	☐	/BEV3/CHSPART_WE	SPART	CHAR	2	0	Division Performance	TSPA
18	KUNNR_FI	☐	/BEV3/CHKUNNR_FI	KUNNR	CHAR	10	0	Customer	KNA1
19	BUKRS_FI	☐	/BEV3/CHBUKRS	BUKRS	CHAR	4	0	Company Code	T001
20	KUNNR_AG	☐	/BEV3/CHKUNNR_AG	KUNNR	CHAR	10	0	Customer Number of Sold-to Party	KNA1
21	KUNNR_RE	☐	/BEV3/CHKUNNR_RE	KUNNR	CHAR	10	0	Customer Number of Bill-to Party	KNA1
22	ADRNR	☐	ADRNR	ADRNR	CHAR	10	0	Address
23	ANRED	☐	ANRED	TEXT15	CHAR	15	0	Title
24	AUFSD	☐	AUFSD_X	KAUFS	CHAR	2	0	Central order block for customer	TVAST
25	BAHNE	☐	BAHNE	BAHNH	CHAR	25	0	Express train station
26	BAHNS	☐	BAHNS	BAHNH	CHAR	25	0	Train station
27	BBBNR	☐	BBBNR	NUM07	NUMC	7	0	International location number (part 1)
28	BBSNR	☐	BBSNR	NUM05	NUMC	5	0	International location number (Part 2)
29	BEGRU	☐	BRGRU	BRGRU	CHAR	4	0	Authorization Group
30	BRSCH	☐	BRSCH	BRSCH	CHAR	4	0	Industry key	T016
31	BUBKZ	☐	BUBKZ	NUM01	NUMC	1	0	Check digit for the international location number
32	DATLT	☐	DATLT	TEXT14	CHAR	14	0	Data communication line no.
33	ERDAT	☐	ERDAT_RF	DATUM	DATS	8	0	Date on which the Record Was Created
34	ERNAM	☐	ERNAM_RF	USNAM	CHAR	12	0	Name of Person who Created the Object
35	EXABL	☐	EXABL	XFELD	CHAR	1	0	Indicator: Unloading points exist
36	FAKSD	☐	FAKSD_X	FAKSP	CHAR	2	0	Central billing block for customer	TVFS
37	FISKN	☐	FISKN_D	KUNNR	CHAR	10	0	Account number of the master record with the fiscal address	KNA1
38	KNAZK	☐	KNAZK	WFCID	CHAR	2	0	Working Time Calendar	TFACD
39	KNRZA	☐	KNRZA	KUNNR	CHAR	10	0	Account number of an alternative payer	KNA1
40	KONZS	☐	KONZS	KONZS	CHAR	10	0	Group key
41	KTOKD	☐	KTOKD	KTOKD	CHAR	4	0	Customer Account Group	T077D
42	KUKLA	☐	KUKLA	KUKLA	CHAR	2	0	Customer classification	TKUKL
43	LAND1	☐	LAND1_GP	LAND1	CHAR	3	0	Country Key	T005
44	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
45	LIFSD	☐	LIFSD_X	LIFSP	CHAR	2	0	Central delivery block for the customer	TVLS
46	LOCCO	☐	LOCCO	LOCCO	CHAR	10	0	City Coordinates
47	LOEVM	☐	LOEVM_X	XFELD	CHAR	1	0	Central Deletion Flag for Master Record
48	NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
49	NAME2	☐	NAME2_GP	NAME	CHAR	35	0	Name 2
50	NAME3	☐	NAME3_GP	NAME	CHAR	35	0	Name 3
51	NAME4	☐	NAME4_GP	NAME	CHAR	35	0	Name 4
52	NIELS	☐	NIELS	NIELS	CHAR	2	0	Nielsen ID	TNLS
53	ORT01	☐	ORT01_GP	TEXT35	CHAR	35	0	City
54	ORT02	☐	ORT02_GP	TEXT35	CHAR	35	0	District
55	PFACH	☐	PFACH	PFACH	CHAR	10	0	PO Box
56	PSTL2	☐	PSTL2	PSTLZ	CHAR	10	0	P.O. Box Postal Code
57	PSTLZ	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
58	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
59	COUNC	☐	COUNC	COUNC	CHAR	3	0	County Code	T005E
60	CITYC	☐	CITYC	CITYC	CHAR	4	0	City Code	T005G
61	RPMKR	☐	RPMKR	RPMKR	CHAR	5	0	Regional market
62	SORTL	☐	SORTL	CHAR10	CHAR	10	0	Sort field
63	SPERR	☐	SPERB_X	XFELD	CHAR	1	0	Central posting block
64	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
65	STCD1	☐	STCD1	STCD1	CHAR	16	0	Tax Number 1
66	STCD2	☐	STCD2	STCD2	CHAR	11	0	Tax Number 2
67	STKZA	☐	STKZA	STKZA	CHAR	1	0	Indicator: Business Partner Subject to Equalization Tax?
68	STKZU	☐	STKZU	XFELD	CHAR	1	0	Liable for VAT
69	STRAS	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
70	TELBX	☐	TELBX	TEXT15	CHAR	15	0	Telebox number
71	TELF1	☐	TELF1	TEXT16	CHAR	16	0	First telephone number
72	TELF2	☐	TELF2	TEXT16	CHAR	16	0	Second telephone number
73	TELFX	☐	TELFX	TEXT31	CHAR	31	0	Fax Number
74	TELTX	☐	TELTX	TEXT30	CHAR	30	0	Teletex number
75	TELX1	☐	TELX1	TEXT30	CHAR	30	0	Telex number
76	LZONE	☐	LZONE	ZONE	CHAR	10	0	Transportation zone to or from which the goods are delivered	TZONE
77	XCPDK	☐	XCPDK	XFELD	CHAR	1	0	Indicator: Is the account a one-time account?
78	XZEMP	☐	XREGU	XFELD	CHAR	1	0	Indicator: Is an alternative payer allowed in document?
79	VBUND	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	T880
80	STCEG	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
81	DEAR1	☐	DEAR1	XFELD	CHAR	1	0	Indicator: Competitor
82	DEAR2	☐	DEAR2	XFELD	CHAR	1	0	Indicator: Sales partner
83	DEAR3	☐	DEAR3	DEAR3	CHAR	1	0	Indicator: Sales prospect
84	DEAR4	☐	DEAR4	XFELD	CHAR	1	0	Indicator for customer type 4
85	DEAR5	☐	DEAR5	XFELD	CHAR	1	0	ID for default sold-to party
86	GFORM	☐	GFORM	GFORM	CHAR	2	0	Legal status	TVGF
87	BRAN1	☐	BRAN1_D	BRACO	CHAR	10	0	Industry code 1	TBRC
88	BRAN2	☐	BRAN2	BRACO	CHAR	10	0	Industry code 2	TBRC
89	BRAN3	☐	BRAN3	BRACO	CHAR	10	0	Industry code 3	TBRC
90	BRAN4	☐	BRAN4	BRACO	CHAR	10	0	Industry code 4	TBRC
91	BRAN5	☐	BRAN5	BRACO	CHAR	10	0	Industry code 5	TBRC
92	EKONT	☐	EKONT	VBELN	CHAR	10	0	Initial contact	VBUK
93	UMSAT	☐	UMSAT	UMSAT	CURR	8	2	Annual sales
94	UMJAH	☐	UMJAH	JAHR	NUMC	4	0	Year For Which Sales are Given
95	UWAER	☐	UWAER	WAERS	CUKY	5	0	Currency of Sales Volume	TCURC
96	JMZAH	☐	JMZAH	JMZAH	NUMC	6	0	Yearly number of employees
97	JMJAH	☐	JMJAH	JAHR	NUMC	4	0	Year for which the number of employees is given
98	KATR1	☐	KATR1	ATTR1	CHAR	2	0	Attribute 1	TVK1
99	KATR2	☐	KATR2	ATTR2	CHAR	2	0	Attribute 2	TVK2
100	KATR3	☐	KATR3	ATTR3	CHAR	2	0	Attribute 3	TVK3
101	KATR4	☐	KATR4	ATTR4	CHAR	2	0	Attribute 4	TVK4
102	KATR5	☐	KATR5	ATTR5	CHAR	2	0	Attribute 5	TVK5
103	KATR6	☐	KATR6	ATTR6	CHAR	3	0	Attribute 6	TVK6
104	KATR7	☐	KATR7	ATTR7	CHAR	3	0	Attribute 7	TVK7
105	KATR8	☐	KATR8	ATTR8	CHAR	3	0	Attribute 8	TVK8
106	KATR9	☐	KATR9	ATTR9	CHAR	3	0	Attribute 9	TVK9
107	KATR10	☐	KATR10	ATTR10	CHAR	3	0	Attribute 10	TVK0
108	STKZN	☐	STKZN	STKZN	CHAR	1	0	Natural Person
109	UMSA1	☐	UMSA1	UMSA1	CURR	15	2	Annual sales
110	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	TTXJ
111	MCOD1	☐	MCDD1	CHAR25	CHAR	25	0	Search term for matchcode search
112	MCOD2	☐	MCDD2	CHAR25	CHAR	25	0	Search Term for Matchcode Search
113	MCOD3	☐	MCDD3	CHAR25	CHAR	25	0	Search term for matchcode search
114	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	T009
115	ABRVW	☐	ABRVW	ABRVW	CHAR	3	0	Usage Indicator	TVLV
116	INSPBYDEBI	☐	QINSPBYDEB	QKZ	CHAR	1	0	Inspection Carried Out By Customer (No Inspection Lot)
117	INSPATDEBI	☐	QINSPATDEB	QKZ	CHAR	1	0	Inspection for a Delivery Note After Outbound Delivery
118	KTOCD	☐	KTOCD	KTOKD	CHAR	4	0	Reference Account Group for One-Time Account (Customer)	T077D
119	PFORT	☐	PFORT_GP	TEXT35	CHAR	35	0	PO Box city
120	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
121	DTAMS	☐	DTAMS	DTAMS	CHAR	1	0	Report key for data medium exchange
122	DTAWS	☐	DTAWS	DTAWS	CHAR	2	0	Instruction key for data medium exchange
123	DUEFL	☐	DUEFL_BKPF	DUEFL_BKPF	CHAR	1	0	Status of Data Transfer into Subsequent Release
124	HZUOR	☐	HZUOR	HZUOR	NUMC	2	0	Assignment to Hierarchy
125	SPERZ	☐	SPERZ	XFELD	CHAR	1	0	Payment Block
126	ETIKG	☐	ETIKG	ETIKG	CHAR	10	0	IS-R Labeling: customer/plant group	TWEK
127	CIVVE	☐	CIVVE	XFELD	CHAR	1	0	ID for mainly non-military use
128	MILVE	☐	MILVE	XFELD	CHAR	1	0	ID for mainly military use
129	KDKG1	☐	KDKG1	KDKGR	CHAR	2	0	Customer condition group 1	TVKGG
130	KDKG2	☐	KDKG2	KDKGR	CHAR	2	0	Customer condition group 2	TVKGG
131	KDKG3	☐	KDKG3	KDKGR	CHAR	2	0	Customer condition group 3	TVKGG
132	KDKG4	☐	KDKG4	KDKGR	CHAR	2	0	Customer condition group 4	TVKGG
133	KDKG5	☐	KDKG5	KDKGR	CHAR	2	0	Customer condition group 5	TVKGG
134	XKNZA	☐	XKNZA	XFELD	CHAR	1	0	Indicator: Alternative payer using account number
135	FITYP	☐	J_1AFITP_D	J_1AFITP	CHAR	2	0	Tax type	J_1AFITP
136	STCDT	☐	J_1ATOID	J_1ATOID	CHAR	2	0	Tax Number Type	J_1ATODC
137	STCD3	☐	STCD3	CHAR18	CHAR	18	0	Tax Number 3
138	STCD4	☐	STCD4	CHAR18	CHAR	18	0	Tax Number 4
139	XICMS	☐	J_1BTCICMS	XFELD	CHAR	1	0	Customer is ICMS-exempt
140	XXIPI	☐	J_1BTCIPI	XFELD	CHAR	1	0	Customer is IPI-exempt
141	XSUBT	☐	J_1BTCST	J_1BTCST1	CHAR	3	0	Customer group for Substituiçao Tributária calculation	J_1BTXSTG
142	CFOPC	☐	J_1BINDUS1	J_1BINDUS1	CHAR	2	0	Customer's CFOP category
143	TXLW1	☐	J_1BTAXLW1	J_1BTAXLW1	CHAR	3	0	Tax law: ICMS	J_1BATL1
144	TXLW2	☐	J_1BTAXLW2	J_1BTAXLW2	CHAR	3	0	Tax law: IPI	J_1BATL2
145	CCC01	☐	CCC01	XFELD	CHAR	1	0	Indicator for biochemical warfare for legal control
146	CCC02	☐	CCC02	XFELD	CHAR	1	0	Indicator for nuclear nonproliferation for legal control
147	CCC03	☐	CCC03	XFELD	CHAR	1	0	Indicator for national security for legal control
148	CCC04	☐	CCC04	XFELD	CHAR	1	0	Indicator for missile technology for legal control
149	CASSD	☐	CASSD_X	CASSP	CHAR	2	0	Central sales block for customer
150	KNURL	☐	URL	TEXT132	CHAR	132	0	Uniform resource locator
151	VBDTB	☐	/BEV3/CHBDTBV	/BEV3/CHJJJJMMTT	DATS	8	0	Date Visible to
152	ANZVBNR	☐	/BEV3/CHANZVBNR	/BEV3/CHANZ4	DEC	4	0	Number of Visible AGNO for an Entity
153	ANZWIND	☐	/BEV3/CHANZWIND	/BEV3/CHANZ4	DEC	4	0	Number of Time Windows for an AGNO
154	YVOSNR	☐	/BEV3/CHOSNR	/BEV3/CHOSNR	NUMC	4	0	Object type	/BEV3/CHTOS
155	YVOBJBEZ	☐	/BEV3/CHOBJBEZ	/BEV3/CHCHAR50	CHAR	50	0	Description of Object
156	YVOBJBZKZ	☐	/BEV3/CHBEZKURZ	/BEV3/CHCHAR15	CHAR	15	0	Short Description
157	YVLOEVM	☐	/BEV3/CHLOEVM	/BEV3/CHLOEVM	CHAR	1	0	Deletion Flag
158	YVLOEKZ	☐	/BEV3/CHLOEKZ	/BEV3/CHLOEKZ	CHAR	1	0	Deletion Indicator

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	/BEV3/CHBPAOBJS	ABRVW	TVLV	ABRVW	REF	C	CN
2	/BEV3/CHBPAOBJS	AUFSD	TVAST	AUFSP	REF	C	CN
3	/BEV3/CHBPAOBJS	BRAN1	TBRC	BRACO	KEY	1	CN
4	/BEV3/CHBPAOBJS	BRAN2	TBRC	BRACO	KEY	1	CN
5	/BEV3/CHBPAOBJS	BRAN3	TBRC	BRACO	KEY	1	CN
6	/BEV3/CHBPAOBJS	BRAN4	TBRC	BRACO	KEY	1	CN
7	/BEV3/CHBPAOBJS	BRAN5	TBRC	BRACO	KEY	1	CN
8	/BEV3/CHBPAOBJS	BRSCH	T016	BRSCH	REF	C	CN
9	/BEV3/CHBPAOBJS	BUKRS_FI	T001	BUKRS
10	/BEV3/CHBPAOBJS	CITYC	T005G	CITYC	REF	C	CN
11	/BEV3/CHBPAOBJS	COUNC	T005E	COUNC	REF	C	CN
12	/BEV3/CHBPAOBJS	EKONT	VBUK	VBELN	REF	1	C
13	/BEV3/CHBPAOBJS	ETIKG	TWEK	KUNGR	REF	1	CN
14	/BEV3/CHBPAOBJS	FAKSD	TVFS	FAKSP	REF	C	CN
15	/BEV3/CHBPAOBJS	FISKN	KNA1	KUNNR	REF	C	CN
16	/BEV3/CHBPAOBJS	FITYP	J_1AFITP	J_1AFITP		1	CN
17	/BEV3/CHBPAOBJS	GFORM	TVGF	GFORM	KEY	1	CN
18	/BEV3/CHBPAOBJS	KATR1	TVK1	KATR1	KEY	1	CN
19	/BEV3/CHBPAOBJS	KATR10	TVK0	KATR10	KEY	1	CN
20	/BEV3/CHBPAOBJS	KATR2	TVK2	KATR2	KEY	1	CN
21	/BEV3/CHBPAOBJS	KATR3	TVK3	KATR3	KEY	1	CN
22	/BEV3/CHBPAOBJS	KATR4	TVK4	KATR4	KEY	1	CN
23	/BEV3/CHBPAOBJS	KATR5	TVK5	KATR5	KEY	1	CN
24	/BEV3/CHBPAOBJS	KATR6	TVK6	KATR6	KEY	1	CN
25	/BEV3/CHBPAOBJS	KATR7	TVK7	KATR7	KEY	1	CN
26	/BEV3/CHBPAOBJS	KATR8	TVK8	KATR8	KEY	1	CN
27	/BEV3/CHBPAOBJS	KATR9	TVK9	KATR9	KEY	1	CN
28	/BEV3/CHBPAOBJS	KDKG1	TVKGG	KDKGR	REF	1	CN
29	/BEV3/CHBPAOBJS	KDKG2	TVKGG	KDKGR	REF	1	CN
30	/BEV3/CHBPAOBJS	KDKG3	TVKGG	KDKGR	REF	1	CN
31	/BEV3/CHBPAOBJS	KDKG4	TVKGG	KDKGR	REF	1	CN
32	/BEV3/CHBPAOBJS	KDKG5	TVKGG	KDKGR	REF	1	CN
33	/BEV3/CHBPAOBJS	KNAZK	TFACD	IDENT	REF	C	CN
34	/BEV3/CHBPAOBJS	KNRZA	KNA1	KUNNR	REF	C	CN
35	/BEV3/CHBPAOBJS	KTOCD	T077D	KTOKD	REF	C	CN
36	/BEV3/CHBPAOBJS	KTOKD	T077D	KTOKD	REF	1	CN
37	/BEV3/CHBPAOBJS	KUKLA	TKUKL	KUKLA	REF	C	CN
38	/BEV3/CHBPAOBJS	KUNNR_AG	KNA1	KUNNR
39	/BEV3/CHBPAOBJS	KUNNR_FI	KNA1	KUNNR
40	/BEV3/CHBPAOBJS	KUNNR_RE	KNA1	KUNNR
41	/BEV3/CHBPAOBJS	KUNNR_RG	KNA1	KUNNR
42	/BEV3/CHBPAOBJS	KUNNR_WE	KNA1	KUNNR
43	/BEV3/CHBPAOBJS	LAND1	T005	LAND1	REF	C	CN
44	/BEV3/CHBPAOBJS	LIFNR	LFA1	LIFNR	REF	C	CN
45	/BEV3/CHBPAOBJS	LIFSD	TVLS	LIFSP	REF	C	CN
46	/BEV3/CHBPAOBJS	LZONE	TZONE	ZONE1	REF	C	CN
47	/BEV3/CHBPAOBJS	MANDT	T000	MANDT
48	/BEV3/CHBPAOBJS	NIELS	TNLS	NIELS	REF	C	CN
49	/BEV3/CHBPAOBJS	PERIV	T009	PERIV	REF	C	CN
50	/BEV3/CHBPAOBJS	REGIO	T005S	BLAND	REF	C	CN
51	/BEV3/CHBPAOBJS	SPART_RG	TSPA	SPART		1	CN
52	/BEV3/CHBPAOBJS	SPART_WE	TSPA	SPART
53	/BEV3/CHBPAOBJS	SPRAS	T002	SPRAS	REF	1	CN
54	/BEV3/CHBPAOBJS	STCDT	J_1ATODC	J_1ATODC		1	CN
55	/BEV3/CHBPAOBJS	TXJCD	TTXJ	TXJCD	REF	C	CN
56	/BEV3/CHBPAOBJS	TXLW1	J_1BATL1	TAXLAW		1	CN
57	/BEV3/CHBPAOBJS	TXLW2	J_1BATL2	TAXLAW		1	CN
58	/BEV3/CHBPAOBJS	UWAER	TCURC	WAERS	REF	1	C
59	/BEV3/CHBPAOBJS	VBUND	T880	RCOMP	REF	C	CN
60	/BEV3/CHBPAOBJS	VKORG_RG	TVKO	VKORG
61	/BEV3/CHBPAOBJS	VKORG_WE	TVKO	VKORG
62	/BEV3/CHBPAOBJS	VTWEG_RG	TVTW	VTWEG
63	/BEV3/CHBPAOBJS	VTWEG_WE	TVTW	VTWEG
64	/BEV3/CHBPAOBJS	WERKS	T001W	WERKS	REF	C	CN
65	/BEV3/CHBPAOBJS	XSUBT	J_1BTXSTG	STGRP		1	CN
66	/BEV3/CHBPAOBJS	YVOSNR	/BEV3/CHTOS	YVOSNR		1	CN

History

Last changed by/on	SAP	20131127
SAP Release Created in