SAP ABAP View /BEV3/CHBPARTOBJ (Objects in Partner Agreement)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ SD-SLS-PLL-OBS (Application Component) Remaining Beverage - Obsolete Objects
     ⤷ /BEV3/CH (Package) Contract Handling

Basic Data

View Type	D	Database View
Database View	/BEV3/CHBPARTOBJ
Short Description	Objects in Partner Agreement
Root table	/BEV3/CHBPART	Agreement Partner SD

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	/BEV3/CHBPART	/BEV3/CHBPART
2	KNA1
3	/BEV3/CHTOBJ

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	/BEV3/CHBPART	KUNNR_WE	JL	EQ				0	0
2	KNA1	KUNNR	JR	EQ			AND	0	0
3	/BEV3/CHBPART	MANDT	JL	EQ				0	0
4	KNA1	MANDT	JR	EQ			AND	0	0
5	/BEV3/CHTOBJ	MANDT	JL	EQ				0	0
6	KNA1	MANDT	JR	EQ			AND	0	0
7	/BEV3/CHTOBJ	ADRNR	JL	EQ				0	0
8	KNA1	KUNNR	JR	EQ				0	0

View Fields

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

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20131127
SAP Release Created in