SAP ABAP Table /BEV3/CHBPR (Print View CH Items)

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

Table Category	INTTAB	Structure
Structure	/BEV3/CHBPR	Table Relationship Diagram
Short Description	Print View CH Items

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	Billing Document: Item Data
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	VBELN	☐	VBELN_VF	VBELN	CHAR	10	0	Billing document	VBUK
4	POSNR	☐	POSNR_VF	POSNR	NUMC	6	0	Billing item	VBUP
5	UEPOS	☐	UEPOS	POSNR	NUMC	6	0	Higher-level item in bill of material structures	VBUP
6	FKIMG	☐	FKIMG	MENG13	QUAN	13	3	Actual billed quantity
7	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	T006
8	UMVKZ	☐	UMVKZ	UMBSZ	DEC	5	0	Numerator (factor) for conversion of sales quantity into SKU
9	UMVKN	☐	UMVKN	UMBSN	DEC	5	0	Denominator (divisor) for conversion of sales qty. into SKU
10	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
11	SMENG	☐	SMENG	MENG13	QUAN	13	3	Scale quantity in base unit of measure
12	FKLMG	☐	FKLMG	MENG13	QUAN	13	3	Billing quantity in stockkeeping unit
13	LMENG	☐	LMENG	MENG13	QUAN	13	3	Required quantity for mat.management in stockkeeping units
14	NTGEW	☐	NTGEW_15	MENG15	QUAN	15	3	Net weight
15	BRGEW	☐	BRGEW_15	MENG15	QUAN	15	3	Gross weight
16	GEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	T006
17	VOLUM	☐	VOLUM_15	MENG15	QUAN	15	3	Volume
18	VOLEH	☐	VOLEH	MEINS	UNIT	3	0	Volume unit	T006
19	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
20	PRSDT	☐	PRSDT	DATUM	DATS	8	0	Date for pricing and exchange rate
21	FBUDA	☐	FBUDA	DATUM	DATS	8	0	Date When Services Rendered
22	KURSK	☐	KURSK	KURRF	DEC	9	5	Exchange Rate for Pricing and Statistics
23	NETWR	☐	NETWR_FP	WERTV8	CURR	15	2	Net value of the billing item in document currency
24	VBELV	☐	VBELV	VBELN	CHAR	10	0	Originating document	VBUK
25	POSNV	☐	POSNV	POSNR	NUMC	6	0	Originating item	VBUP
26	VGBEL	☐	VGBEL	VBELN	CHAR	10	0	Document number of the reference document	VBUK
27	VGPOS	☐	VGPOS	POSNR	NUMC	6	0	Item number of the reference item	VBUP
28	VGTYP	☐	VBTYP_V	VBTYP	CHAR	1	0	Document category of preceding SD document
29	AUBEL	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document	VBUK
30	AUPOS	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	VBUP
31	AUREF	☐	AUREF	XFELD	CHAR	1	0	Sales document was created from reference
32	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
33	ARKTX	☐	ARKTX	TEXT40	CHAR	40	0	Short text for sales order item
34	PMATN	☐	PMATN	MATNR	CHAR	18	0	Pricing Reference Material	MARA
35	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCHA
36	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
37	PSTYV	☐	PSTYV	PSTYV	CHAR	4	0	Sales document item category	*
38	POSAR	☐	POSAR	POSAR	CHAR	1	0	Item type
39	PRODH	☐	PRODH_D	PRODH	CHAR	18	0	Product Hierarchy	T179
40	VSTEL	☐	VSTEL	VSTEL	CHAR	4	0	Shipping Point/Receiving Point	TVST
41	ATPKZ	☐	ATPKZ	ATPKZ	CHAR	1	0	Replacement part
42	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
43	POSPA	☐	POSPA	POSNR	NUMC	6	0	Item number in the partner segment	VBUP
44	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
45	ALAND	☐	ALAND	LAND1	CHAR	3	0	Departure country (country from which the goods are sent)	T005
46	WKREG	☐	WKREG	REGIO	CHAR	3	0	Region in which plant is located	T005S
47	WKCOU	☐	WKCOU	CHAR3	CHAR	3	0	County in which plant is located
48	WKCTY	☐	WKCTY	CHAR4	CHAR	4	0	City in which plant is located
49	TAXM1	☐	TAXM1	TAXKM	CHAR	1	0	Tax classification material	*
50	TAXM2	☐	TAXM2	TAXKM	CHAR	1	0	Tax classification material	*
51	TAXM3	☐	TAXM3	TAXKM	CHAR	1	0	Tax classification material	*
52	TAXM4	☐	TAXM4	TAXKM	CHAR	1	0	Tax Classification 4 Material	*
53	TAXM5	☐	TAXM5	TAXKM	CHAR	1	0	Tax classification 5 for material	*
54	TAXM6	☐	TAXM6	TAXKM	CHAR	1	0	Tax classification 6 for material	*
55	TAXM7	☐	TAXM7	TAXKM	CHAR	1	0	Tax classification 7 for material	*
56	TAXM8	☐	TAXM8	TAXKM	CHAR	1	0	Tax Classification 8 Material	*
57	TAXM9	☐	TAXM9	TAXKM	CHAR	1	0	Tax Classification 9 Material	*
58	KOWRR	☐	KOWRR	KOWRR	CHAR	1	0	Statistical values
59	PRSFD	☐	PRSFD	PRSFD	CHAR	1	0	Carry out pricing
60	SKTOF	☐	SKTOF	XFELD	CHAR	1	0	Cash discount indicator
61	SKFBP	☐	SKFBP	WERTV7	CURR	13	2	Amount eligible for cash discount in document currency
62	KONDM	☐	KONDM	KONDM	CHAR	2	0	Material Pricing Group	T178
63	KTGRM	☐	KTGRM	KTGRM	CHAR	2	0	Account assignment group for this material	TVKM
64	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
65	BONUS	☐	BONUS	BONUS	CHAR	2	0	Volume rebate group	TVBO
66	PROVG	☐	PROVG	PROVG	CHAR	2	0	Commission group	TVPR
67	EANNR	☐	EANNR	CHAR13	CHAR	13	0	European Article Number (EAN) - obsolete!!!!!
68	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVKGR
69	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVBUR
70	SPARA	☐	SPART_AK	SPART	CHAR	2	0	Division for order header	TSPA
71	SHKZG	☐	SHKZG_VF	SHKZG_VF	CHAR	1	0	Returns item
72	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
73	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
74	ERZET	☐	ERZET	UZEIT	TIMS	6	0	Entry time
75	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	T149D
76	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
77	STAFO	☐	STAFO	STAFO	CHAR	6	0	Update group for statistics update	*
78	WAVWR	☐	WAVWR	WERTV7	CURR	13	2	Cost in document currency
79	KZWI1	☐	KZWI1	WERTV7	CURR	13	2	Subtotal 1 from pricing procedure for condition
80	KZWI2	☐	KZWI2	WERTV7	CURR	13	2	Subtotal 2 from pricing procedure for condition
81	KZWI3	☐	KZWI3	WERTV7	CURR	13	2	Subtotal 3 from pricing procedure for condition
82	KZWI4	☐	KZWI4	WERTV7	CURR	13	2	Subtotal 4 from pricing procedure for condition
83	KZWI5	☐	KZWI5	WERTV7	CURR	13	2	Subtotal 5 from pricing procedure for condition
84	KZWI6	☐	KZWI6	WERTV7	CURR	13	2	Subtotal 6 from pricing procedure for condition
85	STCUR	☐	STCUR_AP	KURRF	DEC	9	5	Exchange rate for statistics (Exch.rate at time of creation)
86	UVPRS	☐	UVPRS	XFELD	CHAR	1	0	Incomplete with respect to pricing
87	UVALL	☐	UVALL	XFELD	CHAR	1	0	Generally incomplete
88	EAN11	☐	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
89	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
90	KVGR1	☐	KVGR1	KVGR1	CHAR	3	0	Customer group 1	TVV1
91	KVGR2	☐	KVGR2	KVGR2	CHAR	3	0	Customer group 2	TVV2
92	KVGR3	☐	KVGR3	KVGR3	CHAR	3	0	Customer group 3	TVV3
93	KVGR4	☐	KVGR4	KVGR4	CHAR	3	0	Customer group 4	TVV4
94	KVGR5	☐	KVGR5	KVGR5	CHAR	3	0	Customer group 5	TVV5
95	MVGR1	☐	MVGR1	MVGR1	CHAR	3	0	Material group 1	TVM1
96	MVGR2	☐	MVGR2	MVGR2	CHAR	3	0	Material group 2	TVM2
97	MVGR3	☐	MVGR3	MVGR3	CHAR	3	0	Material group 3	TVM3
98	MVGR4	☐	MVGR4	MVGR4	CHAR	3	0	Material group 4	TVM4
99	MVGR5	☐	MVGR5	MVGR5	CHAR	3	0	Material group 5	TVM5
100	MATWA	☐	MATWA	MATNR	CHAR	18	0	Material entered	MARA
101	BONBA	☐	BONBA	WERTV7	CURR	13	2	Rebate basis 1
102	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
103	PAOBJNR	☐	RKEOBJNR	RKEOBJNR	NUMC	10	0	Profitability Segment Number (CO-PA)
104	PS_PSP_PNR	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	*
105	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
106	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
107	CMPRE	☐	CMPRE	WERTV6	CURR	11	2	Item credit price
108	CMPNT	☐	CMPNT	XFELD	CHAR	1	0	ID: Item with active credit function / relevant for credit
109	CUOBJ	☐	CUOBJ_VA	CUOBJ	NUMC	18	0	Configuration
110	CUOBJ_CH	☐	CUOBJ_CH	CUOBJ	NUMC	18	0	Internal object number of the batch classification
111	KOUPD	☐	KOUPD	XFELD	CHAR	1	0	Condition update
112	UECHA	☐	UECHA	POSNR	NUMC	6	0	Higher-Level Item of Batch Split Item	*
113	XCHAR	☐	XCHAR	XFELD	CHAR	1	0	Batch management indicator (internal)
114	ABRVW	☐	ABRVW	ABRVW	CHAR	3	0	Usage Indicator	TVLV
115	SERNR	☐	SERNR	SERNR	CHAR	8	0	BOM explosion number	SNUM
116	BZIRK_AUFT	☐	BZIRK_AUFT	BZIRK	CHAR	6	0	Sales district of sales order	T171
117	KDGRP_AUFT	☐	KDGRP_AUFT	KDGRP	CHAR	2	0	Customer group of sales order	T151
118	KONDA_AUFT	☐	KONDA_AUFT	KONDA	CHAR	2	0	Price group of sales order	T188
119	LLAND_AUFT	☐	LLAND_AUFT	LAND1	CHAR	3	0	Country of destination of sales order	T005
120	MPROK	☐	MPROK	MPROK	CHAR	1	0	Status manual price change
121	PLTYP_AUFT	☐	PLTYP_AUFT	PLTYP	CHAR	2	0	Price list type of sales order	T189
122	REGIO_AUFT	☐	REGIO_AUFT	REGIO	CHAR	3	0	Region of sales order	T005S
123	VKORG_AUFT	☐	VKORG_AUFT	VKORG	CHAR	4	0	Sales organization of sales order	TVKO
124	VTWEG_AUFT	☐	VTWEG_AUFT	VTWEG	CHAR	2	0	Distribution channel of sales order	TVTW
125	ABRBG	☐	ABRBG	DATUM	DATS	8	0	Start of accounting settlement period
126	PROSA	☐	PROSA	PROSA	CHAR	1	0	ID for material selection - active
127	UEPVW	☐	UEPVW	UEPVW	CHAR	1	0	ID for higher-level item usage
128	AUTYP	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
129	STADAT	☐	STADAT	DATUM	DATS	8	0	Statistics date
130	FPLNR	☐	FPLNR	FPLNR	CHAR	10	0	Billing plan number / invoicing plan number	FPLA
131	FPLTR	☐	FPLTR	FPLTR	NUMC	6	0	Item for billing plan/invoice plan/payment cards	*
132	AKTNR	☐	WAKTION	WAKTION	CHAR	10	0	Promotion	WAKH
133	KNUMA_PI	☐	KNUMA_PI	KNUMA	CHAR	10	0	Promotion	KONA
134	KNUMA_AG	☐	KNUMA_AG	KNUMA	CHAR	10	0	Sales deal	KONA
135	PREFE	☐	PREFE	PREFE	CHAR	1	0	Preference indicator in export/import
136	MWSBP	☐	MWSBP	WERTV7	CURR	13	2	Tax amount in document currency
137	AUGRU_AUFT	☐	AUGRU	AUGRU	CHAR	3	0	Order reason (reason for the business transaction)	TVAU
138	FAREG	☐	FAREG	FAREG	CHAR	1	0	Rule in billing plan/invoice plan
139	UPMAT	☐	UPMAT	MATNR	CHAR	18	0	Pricing reference material of main item	MARA
140	UKONM	☐	UKONM	KONDM	CHAR	2	0	Material pricing group of main item	T178
141	CMPRE_FLT	☐	CMPRE_FLT	FLTP	FLTP	16	16	Item credit price
142	ABFOR	☐	ABSFORM_CM	ABSFORM_CM	CHAR	2	0	Form of payment guarantee	T691K
143	ABGES	☐	ABGES_CM	FLTP	FLTP	16	16	Guaranteed (factor between 0 and 1)
144	J_1ARFZ	☐	J_1ARFZVAT	J_1ARFZVAT	CHAR	1	0	Reason for zero VAT	J_1ARFZ
145	J_1AREGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
146	J_1AGICD	☐	J_1AGICD_D	J_1AGICD2	CHAR	2	0	Activity Code for Gross Income Tax	J_1AGICD
147	J_1ADTYP	☐	J_1ADTYP_D	J_1ADTYP	CHAR	2	0	Distribution Type for Employment Tax	J_1ADTYP
148	J_1ATXREL	☐	J_1ATXREL_	J_1ATXREL	CHAR	10	0	Tax relevant classification	J_1ATXREL
149	J_1BCFOP	☐	J_1BCFOP	J_1BCFOP	CHAR	10	0	CFOP code and extension	J_1BAG
150	J_1BTAXLW1	☐	J_1BTAXLW1	J_1BTAXLW1	CHAR	3	0	Tax law: ICMS	J_1BATL1
151	J_1BTAXLW2	☐	J_1BTAXLW2	J_1BTAXLW2	CHAR	3	0	Tax law: IPI	J_1BATL2
152	J_1BTXSDC	☐	J_1BTXSDC_	J_1BTXSDC	CHAR	2	0	SD tax code	J_1BTXSDC
153	BRTWR	☐	BRTWR_FP	WERTV8	CURR	15	2	Gross value of the billing item in document currency
154	WKTNR	☐	WKTNR	VBELN	CHAR	10	0	Value contract no.	VBUK
155	WKTPS	☐	WKTPS	POSNR	NUMC	6	0	Value contract item	VBUP
156	RPLNR	☐	RPLNR_AU	FPLNR	CHAR	10	0	Payment card plan number of sales document	FPLA
157	KURSK_DAT	☐	WWERT_D	DATUM	DATS	8	0	Translation date
158	WGRU1	☐	WGRU_HIE1	KLASSE	CHAR	18	0	Material group hierarchy 1
159	WGRU2	☐	WGRU_HIE2	KLASSE	CHAR	18	0	Material group hierarchy 2
160	KDKG1	☐	KDKG1	KDKGR	CHAR	2	0	Customer condition group 1	TVKGG
161	KDKG2	☐	KDKG2	KDKGR	CHAR	2	0	Customer condition group 2	TVKGG
162	KDKG3	☐	KDKG3	KDKGR	CHAR	2	0	Customer condition group 3	TVKGG
163	KDKG4	☐	KDKG4	KDKGR	CHAR	2	0	Customer condition group 4	TVKGG
164	KDKG5	☐	KDKG5	KDKGR	CHAR	2	0	Customer condition group 5	TVKGG
165	VKAUS	☐	ABRVW	ABRVW	CHAR	3	0	Usage Indicator	TVLV
166	J_1AINDXP	☐	J_1AINDXP	J_1AINDXP	CHAR	5	0	Inflation Index	J_1AINFT20
167	J_1AIDATEP	☐	J_1AIDATES	J_1AUDATEP	DATS	8	0	Indexing base date
168	KZFME	☐	KZFME	KZFME	CHAR	1	0	ID: Leading unit of measure for completing a transaction
169	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
170	VERTT	☐	RANTYP	RANTYP	CHAR	1	0	Contract Type
171	VERTN	☐	RANL	RANL	CHAR	13	0	Contract Number
172	SGTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
173	DELCO	☐	DELCO	DELCO	CHAR	3	0	Agreed delivery time
174	BEMOT	☐	BEMOT	BEMOT	CHAR	2	0	Accounting Indicator	TBMOT
175	RRREL	☐	RR_RELTYP	RR_RELTYP	CHAR	1	0	Revenue recognition category
176	AKKUR	☐	AKKUR	KURRF	DEC	9	5	Exchange rate for letter-of-credit procg in foreign trade
177	WMINR	☐	WMINR	WMINR	CHAR	10	0	Product catalog number	WWMI
178	VGBEL_EX	☐	VGBEL	VBELN	CHAR	10	0	Document number of the reference document	*
179	VGPOS_EX	☐	VGPOS	POSNR	NUMC	6	0	Item number of the reference item	*
180	LOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	*
181	VGTYP_EX	☐	VGTYP_EX	VORG_TYP	CHAR	3	0	Category of an external transaction or element
182	J_1BTAXLW3	☐	J_1BTAXLW3	J_1BTAXLW3	CHAR	3	0	Tax law: ISS	J_1BATL3
183	J_1BTAXLW4	☐	J_1BTAXLW4	J_1BTAXLW4	CHAR	3	0	COFINS Tax Law	J_1BATL4A
184	J_1BTAXLW5	☐	J_1BTAXLW5	J_1BTAXLW5	CHAR	3	0	PIS Tax Law	J_1BATL5
185	MSR_ID	☐	MSR_PROCESS_ID	MSR_PROCESS_ID	CHAR	10	0	Process Identification Number
186	MSR_REFUND_CODE	☐	MSR_RETURNS_REFUND_CODE	MSR_RETURNS_REFUND_CODE	CHAR	3	0	Returns Refund Code	MSR_C_RET_REFUND
187	MSR_RET_REASON	☐	MSR_RETURNS_REASON	MSR_RETURNS_REASON	CHAR	3	0	Return Reason	MSR_C_RET_REASON
188	NRAB_KNUMH	☐	KNUMH	KNUMB	CHAR	10	0	Condition record number
189	NRAB_VALUE	☐	KWERT	WERTV7	CURR	13	2	Condition Value
190	DISPUTE_CASE	☐	DISPUTE_CASE	SDBIL_RAW16	RAW	16	0	Dispute Case
191	FUND_USAGE_ITEM	☐	FUND_USAGE_ITEM	SDBIL_RAW16	RAW	16	0	Fund Usage Item
192	CLAIMS_TAXATION	☐	CLAIMS_TAXATION	CLAIMS_TAXATION	CHAR	1	0	Claims Taxation
193	KURRF_DAT_ORIG	☐	WWERT_D	DATUM	DATS	8	0	Translation date
194	VGTYP_EXT	☐	TDD_VBTYP_EXT_V	DOM_VBTYP_EXT	CHAR	4	0	Extension of SD document category of preceding document
195	.INCLUDE	☐				0	0
196	.INCLU--AP	☐				0	0	OLC append to VBRP
197	AUFPL	☐	CO_AUFPL	AUFPL	NUMC	10	0	Routing number of operations in the order
198	APLZL	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
199	.INCLU--AP	☐				0	0	VBRP Append for Down Payment Chain
200	DPCNR	☐	/SAPPCE/DPCNR	/SAPPCE/DPCNR	CHAR	10	0	Down Payment Chain Number
201	DCPNR	☐	/SAPPCE/DPCPNR	NUM03	NUMC	3	0	Transaction Number
202	DPNRB	☐	/SAPPCE/DPCPNRB	NUM03	NUMC	3	0	Sequence Number of Accounting Document in Transaction
203	.INCLU--AP	☐				0	0	Period of Performance
204	PEROP_BEG	☐	FM_PEROP_SD_LOW	DATUM	DATS	8	0	Period of Performance Start Date
205	PEROP_END	☐	FM_PEROP_SD_HIGH	DATUM	DATS	8	0	Period of Performance End Date
206	.INCLU--AP	☐				0	0	Grants Mgmt: Additional FM fields to VBRP
207	FONDS	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
208	FISTL	☐	FISTL	FISTL	CHAR	16	0	Funds Center	*
209	FKBER	☐	FKBER	FKBER	CHAR	16	0	Functional Area	*
210	GRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
211	.INCLU--AP	☐				0	0	Commercial Project Inception & Lean Staffing appending VBRP
212	PRS_WORK_PERIOD	☐	PRS_WORK_PERIOD	PRS_WORK_PERIOD	NUMC	7	0	Work Period (Internal Representation)
213	.INCLU--AP	☐				0	0	Enhancements for RRICB / DP93
214	PPRCTR	☐	PPRCTR	PRCTR	CHAR	10	0	Partner Profit Center	*
215	PARGB	☐	PARGB	GSBER	CHAR	4	0	Trading partner's business area	*
216	.INCLU--AP	☐				0	0	VBRP Append for Operation level costing
217	AUFPL_OAA	☐	CO_AUFPL	AUFPL	NUMC	10	0	Routing number of operations in the order
218	APLZL_OAA	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
219	.INCLU--AP	☐				0	0	TPM Campaign Determination: APPEND to VBRP
220	CAMPAIGN	☐	CGPL_GUID16_R3	SYSUUID	RAW	16	0	Generic project planning: GUID from external R/3 system
221	.INCLU--AP	☐				0	0	Complaint Management
222	COMPREAS	☐	CMP_COMPREAS_COPY	CMP_COMPREAS_COPY	CHAR	4	0	Abbreviation for Complaints Reason
223	BLG_NR	☐	/BEV3/CHXBLNR	/BEV3/CHBELNR	CHAR	10	0	CH Reference Document Number
224	POS_NR	☐	/BEV3/CHVPOSNR	/BEV3/CHPOSNR	NUMC	6	0	CH Item Number
225	YVORGE	☐	/BEV3/CHOE	/BEV3/CHDOVORGE	NUMC	4	0	CH Organizational Unit	*
226	ABR_NR	☐	/BEV3/CHABRNR	/BEV3/CHABRNR	NUMC	10	0	Settlement Number
227	YVWDNR	☐	/BEV3/CHDTWDNR	/BEV3/CHDOWDNR	NUMC	13	0	CHD Contract Number
228	VBKL_SUPER	☐	/BEV3/CHBKL_SPR	/BEV3/CHBKL	CHAR	4	0	Agreement Class - Caller	*
229	RI_SUPER	☐	/BEV3/CHRI_SPR	/BEV3/CHDORI	NUMC	6	0	Rule Identifier - Caller	*
230	VBIN_SUPER	☐	/BEV3/CHBIN_SPR	/BEV3/CHBIN	NUMC	4	0	Agreement Entity - Calling Program
231	PART_SUPER	☐	/BEV3/CHBTMPART_SPR	/BEV3/CHBTMPART	CHAR	8	0	Part of the Agreement Date - Caller
232	PTIN_SUPER	☐	/BEV3/CHTMINSTANZ_SPR	/BEV3/CHTMINSTANZ	NUMC	4	0	Identification of the individual date parts - Caller
233	VBKL	☐	/BEV3/CHBKL_SLF	/BEV3/CHBKL	CHAR	4	0	Agreement Class - Contract Called	*
234	RI	☐	/BEV3/CHRI_SLF	/BEV3/CHDORI	NUMC	6	0	Rule Identifier - Contract Called	*
235	VBIN	☐	/BEV3/CHBIN_SLF	/BEV3/CHBIN	NUMC	4	0	Agreement Entity - Contract Called
236	VBNR	☐	/BEV3/CHBNR_SLF	/BEV3/CHLFN9	NUMC	9	0	Agreement Number in Seq. Time Order - Contract Called
237	VBDTA	☐	/BEV3/CHBDTA_SLF	DATUM	DATS	8	0	Date (Valid from) - Contract Called
238	ABR_KZ	☐	/BEV3/CHABRFID	/BEV3/CHABRFID	NUMC	4	0	Settlement Method Identifier
239	VBEWAR	☐	/BEV3/CHBEWAR	/BEV3/CHBEWAR	CHAR	4	0	Contract Movement Type	*
240	STR_VRG	☐	/BEV3/CHSTRVRG	/BEV3/CHSTRVRG	CHAR	1	0	Tax transaction
241	VWD_LAND	☐	/BEV3/CHWD_LAND	LAND1	CHAR	3	0	Country Key of CHD	*
242	VWD_STRKZ	☐	/BEV3/CHWD_STRKZ	TAXKD	CHAR	1	0	Tax Classification of Contract Handling Document	*
243	ERG_NR	☐	/BEV3/CHXBLNR_ERGZ	/BEV3/CHBELNR	CHAR	10	0	CH Reference Document Number of Date Supplement
244	STAT_KZ	☐	/BEV3/CHSTATKZ	/BEV3/CHKZ	CHAR	1	0	Statistics Indicator
245	STAT_BZNR	☐	/BEV3/CHVPOSNR	/BEV3/CHPOSNR	NUMC	6	0	CH Item Number
246	VERD_KZ	☐	/BEV3/CHRDKZ	/BEV3/CHKZ	CHAR	1	0	Compression Indicator
247	SP_TAG	☐	/BEV3/CHERDICHTET_ZUM	DATUM	DATS	8	0	Compression Day
248	VB_STRKZ	☐	/BEV3/CHB_STRKZ	TAXKD	CHAR	1	0	Tax Classification of Agreement	*
249	VERTSI_BCH	☐	/BEV3/CHERTSI_BCH	/BEV3/CHERTSI	CHAR	1	0	Contract View - Post
250	PARTTM_BCH	☐	/BEV3/CHBTMPART_BCH	/BEV3/CHBTMPART	CHAR	8	0	Part of the Agreement Date - Post
251	RI_BCH	☐	/BEV3/CHRI_BCH	/BEV3/CHDORI	NUMC	6	0	Rule Identifier - Post	*
252	VKORG_BCH	☐	/BEV3/CHKORG_BCH	VKORG	CHAR	4	0	Sales Organization - Post	*
253	VTWEG_BCH	☐	/BEV3/CHTWEG_BCH	VTWEG	CHAR	2	0	Distribution Channel - Post	*
254	SPART_BCH	☐	/BEV3/CHSPART_BCH	SPART	CHAR	2	0	Division - Post	*
255	BUKRS_BCH	☐	/BEV3/CHBUKRS_BCH	BUKRS	CHAR	4	0	Company Code - Post	*
256	WERK_BCH	☐	/BEV3/CHWERK_BCH	WERKS	CHAR	4	0	Plant - Post	*
257	VWDNR_BCH	☐	/BEV3/CHWDNR_BCH	/BEV3/CHDOWDNR	NUMC	13	0	CHD Contract Number - Post
258	RG_BCH	☐	/BEV3/CHRG_BCH	KUNNR	CHAR	10	0	Customer Number of Payer - Post	*
259	WE_BCH	☐	/BEV3/CHWE_BCH	KUNNR	CHAR	10	0	Customer Number of Ship-to Party - Post	*
260	AG_BCH	☐	/BEV3/CHAG_BCH	KUNNR	CHAR	10	0	Customer Number of Sold-to Party - Post	*
261	RE_BCH	☐	/BEV3/CHRE_BCH	KUNNR	CHAR	10	0	Customer Number of Bill-to Party - Post	*
262	DE_BCH	☐	/BEV3/CHDE_BCH	KUNNR	CHAR	10	0	Customer Number - Post	*
263	VRL_BCH	☐	/BEV3/CHRL_BCH	KUNNR	CHAR	10	0	Distributor Number - Post	*
264	SPD_BCH	☐	/BEV3/CHSPD_BCH	KUNNR	CHAR	10	0	Forwarding Agent - Post	*
265	RG_STAT	☐	/BEV3/CHRG_STAT	KUNNR	CHAR	10	0	Customer Number of Payer - Statistics	*
266	WE_STAT	☐	/BEV3/CHWE_STAT	KUNNR	CHAR	10	0	Customer Number of Ship-to Party - Statistics	*
267	AG_STAT	☐	/BEV3/CHAG_STAT	KUNNR	CHAR	10	0	Customer Number of Sold-to Party - Statistics	*
268	RE_STAT	☐	/BEV3/CHRE_STAT	KUNNR	CHAR	10	0	Customer Number of Bill-to Party - Statistics	*
269	VB_PERSNO	☐	/BEV3/CHBPERSNO	PERSNO	NUMC	8	0	Personnel Number Sales Representative	*
270	BTRG_BCH	☐	/BEV3/CHBTRG_BCH	CURR16	CURR	16	2	Amount - Post
271	WAERK_BCH	☐	/BEV3/CHWAERK_BCH	WAERS	CUKY	5	0	Currency Indicator - Post	*
272	SPRAS	☐	/BEV3/CHSPRAS_BLG	SPRAS	LANG	1	0	Language Key for Documents	*
273	ZUORDNR	☐	DZUONR	ZUONR	CHAR	18	0	Assignment number
274	BSCHL	☐	BSCHL	BSCHL	CHAR	2	0	Posting Key	*
275	PBANKTYP	☐	BVTYP	BVTYP	CHAR	4	0	Partner bank type
276	ZAHLWEG	☐	DZLSCH	ZLSCH	CHAR	1	0	Payment method	*
277	ZAHLSP	☐	DZAHLS	ZAHLS	CHAR	1	0	Block Key for Payment	*
278	MAHNSP	☐	MANSP	MANSP	CHAR	1	0	Dunning block	*
279	MSCHL	☐	MSCHL	MSCHL	CHAR	1	0	Dunning key	*
280	ZAHLBED	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
281	MAHNBER	☐	MABER	MABER	CHAR	2	0	Dunning Area	*
282	BUCHDT_AB	☐	/BEV3/CHBUCHDAT_AB	DATUM	DATS	8	0	From Date of Settlement Period
283	BUCHDT_BIS	☐	/BEV3/CHBUCHDAT_BIS	DATUM	DATS	8	0	To Date of Settlement Period
284	BRCHDT_AB	☐	/BEV3/CHBRCHDAT_AB	DATUM	DATS	8	0	From Date of Calculation Interval
285	BRCHDT_BIS	☐	/BEV3/CHBRCHDAT_BIS	DATUM	DATS	8	0	To Date of Calculation Interval
286	VKORG_LSTG	☐	/BEV3/CHKORG_LSTG	VKORG	CHAR	4	0	Sales Organization - Performance	*
287	VTWEG_LSTG	☐	/BEV3/CHTWEG_LSTG	VTWEG	CHAR	2	0	Distribution Channel - Performance	*
288	SPART_LSTG	☐	/BEV3/CHSPART_LSTG	SPART	CHAR	2	0	Division - Performance	*
289	BUKRS_LSTG	☐	/BEV3/CHBUKRS_LSTG	BUKRS	CHAR	4	0	Company Code - Payment	*
290	WERK_LSTG	☐	/BEV3/CHWERK_LSTG	WERKS	CHAR	4	0	Plant - Performance	*
291	VWDNR_LSTG	☐	/BEV3/CHWDNR_LSTG	/BEV3/CHDOWDNR	NUMC	13	0	CHD Contract Number - Performance
292	BTRG_LSTG	☐	/BEV3/CHBTRG_LSTG	CURR16	CURR	16	2	Amount - Payment
293	WAERK_LSTG	☐	/BEV3/CHWAERK_LSTG	WAERS	CUKY	5	0	Currency Indicator - Performance	*
294	UKURS	☐	/BEV3/CHUKURS	KURSF	DEC	9	5	Exchange Rate Performance -> Post
295	KURSTYP	☐	/BEV3/CHKURST_CURR	KURST	CHAR	4	0	Exchange Rate Type of Conversion Performance -> Post	*
296	PRZSTZ_ZNS	☐	/BEV3/CHZNSTZ	/BEV3/CHPRZ43	DEC	7	3	Percentage
297	PRZSTZ_MAX	☐	/BEV3/CHZNSTZ_MAX	/BEV3/CHPRZ43	DEC	7	3	Percentage Maximum
298	PRZSTZ_MIN	☐	/BEV3/CHZNSTZ_MIN	/BEV3/CHPRZ43	DEC	7	3	Percentage Minimum
299	PRZSTZ_ABW	☐	/BEV3/CHZNSTZ_ABW	/BEV3/CHPRZ43	DEC	7	3	Percentage Variance
300	BTRG_ZNS	☐	/BEV3/CHBTRG_ZNS	CURR16	CURR	16	2	Amount - Interest Basis
301	WAERK_ZNS	☐	/BEV3/CHWAERK_ZNS	WAERS	CUKY	5	0	Currency Indicator - Interest	*
302	I_ZNSCHL	☐	/BEV3/CHZNSCHL_I	/BEV3/CHZNSCHL	CHAR	6	0	CH - Interest Key (Internal)
303	E_ZNSCHL	☐	/BEV3/CHZNSCHL_E	ZIREFKU	CHAR	10	0	CH - Interest Key (External); Reference Interest Rate	*
304	SZBMETH	☐	SZBMETH	SZBMETH	CHAR	1	0	Interest Calculation Method
305	STGBASIS	☐	VVSTGBASIS	VVSTGBASIS	CHAR	1	0	Base Days Method
306	ABASTAGE	☐	ABASTAGE	INT6	NUMC	6	0	Number of base days in a calculation period
307	ATAGE	☐	TFMATAGE	INT4	INT4	10	0	Number of Days
308	MAT_NR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
309	SORTIMENT	☐	W_SORTK	WSORTK	CHAR	18	0	Assortment Module	*
310	MENGE	☐	/BEV3/CHMNGE	/BEV3/CHMNGE	QUAN	15	5	Minimum Purchase
311	MEINH	☐	/BEV3/CHMEINH_ABN	MEINS	UNIT	3	0	Unit of Measure of Minimum Purchase	*
312	MENGE_LSTG	☐	/BEV3/CHMNGE_LSTG	/BEV3/CHMNGE	QUAN	15	5	Quantity of Purchase Performance
313	MEINH_LSTG	☐	/BEV3/CHMEINH_LSTG	MEINS	UNIT	3	0	Unit of Measure for Performance Quantity	*
314	BTRG_UMS	☐	/BEV3/CHBTRG_UMS	CURR16	CURR	16	2	Amount - Sales
315	WAERK_UMS	☐	/BEV3/CHWAERK_UMS	WAERS	CUKY	5	0	Currency Indicator - Sales	*
316	SACHKTO	☐	SAKNR	SAKNR	CHAR	10	0	G/L Account Number	*
317	KOST_ST	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
318	I_AUFTRG	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
319	PRFTCNTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
320	BTRG_STR	☐	MWSTS	WERT7	CURR	13	2	Tax Amount in Local Currency
321	BTRG_STRBAS	☐	HWBAS	WERT7	CURR	13	2	Tax Base Amount in Local Currency
322	WAERK_STR	☐	/BEV3/CHWAERK_STR	WAERS	CUKY	5	0	Currency Indicator - Tax	*
323	PRT_ID	☐	/BEV3/CHPRTID	/BEV3/CHPRTID	NUMC	4	0	Assignment to a Document Printout
324	DRK	☐	/BEV3/CHDRK	/BEV3/CHDRK	CHAR	1	0	CH Print

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	/BEV3/CHBPR	ABFOR	T691K	ABSFO	REF	C	CN
2	/BEV3/CHBPR	ABRVW	TVLV	ABRVW	REF	C	CN
3	/BEV3/CHBPR	AKTNR	WAKH	AKTNR	REF	C	CN
4	/BEV3/CHBPR	ALAND	T005	LAND1	REF	1	CN
5	/BEV3/CHBPR	AUBEL	VBUK	VBELN	REF	C	CN
6	/BEV3/CHBPR	AUFNR	AUFK	AUFNR	REF	C	CN
7	/BEV3/CHBPR	AUGRU_AUFT	TVAU	AUGRU	REF	C	CN
8	/BEV3/CHBPR	AUPOS	VBUP	POSNR	REF	C	CN
9	/BEV3/CHBPR	BEMOT	TBMOT	BEMOT		C	CN
10	/BEV3/CHBPR	BONUS	TVBO	BONUS	REF	C	CN
11	/BEV3/CHBPR	BWTAR	T149D	BWTAR	REF	C	CN
12	/BEV3/CHBPR	BZIRK_AUFT	T171	BZIRK	REF	C	CN
13	/BEV3/CHBPR	CHARG	MCHA	CHARG	REF	C	CN
14	/BEV3/CHBPR	FPLNR	FPLA	FPLNR	REF	C	CN
15	/BEV3/CHBPR	GEWEI	T006	MSEHI	REF	C	CN
16	/BEV3/CHBPR	GSBER	TGSB	GSBER	REF	C	CN
17	/BEV3/CHBPR	J_1ADTYP	J_1ADTYP	J_1ADTYP	KEY	1	CN
18	/BEV3/CHBPR	J_1AGICD	J_1AGICD	J_1AGICD	KEY	1	CN
19	/BEV3/CHBPR	J_1AINDXP	J_1AINFT20	J_1AINDX	KEY	1	CN
20	/BEV3/CHBPR	J_1AREGIO	T005S	BLAND	KEY	1	CN
21	/BEV3/CHBPR	J_1ARFZ	J_1ARFZ	J_1ARFZ	KEY	1	CN
22	/BEV3/CHBPR	J_1ATXREL	J_1ATXREL	J_1ATXREL	KEY	1	CN
23	/BEV3/CHBPR	J_1BCFOP	J_1BAG	CFOP	KEY	1	CN
24	/BEV3/CHBPR	J_1BTAXLW1	J_1BATL1	TAXLAW	KEY	1	CN
25	/BEV3/CHBPR	J_1BTAXLW2	J_1BATL2	TAXLAW	KEY	1	CN
26	/BEV3/CHBPR	J_1BTAXLW3	J_1BATL3	TAXLAW	KEY	1	CN
27	/BEV3/CHBPR	J_1BTAXLW4	J_1BATL4A	TAXLAW	KEY	1	CN
28	/BEV3/CHBPR	J_1BTAXLW5	J_1BATL5	TAXLAW	KEY	1	CN
29	/BEV3/CHBPR	J_1BTXSDC	J_1BTXSDC	TAXCODE	KEY	1	CN
30	/BEV3/CHBPR	KDGRP_AUFT	T151	KDGRP	REF	C	CN
31	/BEV3/CHBPR	KDKG1	TVKGG	KDKGR		C	CN
32	/BEV3/CHBPR	KDKG2	TVKGG	KDKGR		C	CN
33	/BEV3/CHBPR	KDKG3	TVKGG	KDKGR		C	CN
34	/BEV3/CHBPR	KDKG4	TVKGG	KDKGR		C	CN
35	/BEV3/CHBPR	KDKG5	TVKGG	KDKGR		C	CN
36	/BEV3/CHBPR	KNUMA_AG	KONA	KNUMA	REF	C	CN
37	/BEV3/CHBPR	KNUMA_PI	KONA	KNUMA	REF	C	CN
38	/BEV3/CHBPR	KOKRS	TKA01	KOKRS	REF	C	CN
39	/BEV3/CHBPR	KONDA_AUFT	T188	KONDA	REF	C	CN
40	/BEV3/CHBPR	KONDM	T178	KONDM	REF	C	CN
41	/BEV3/CHBPR	KTGRM	TVKM	KTGRM	REF	C	CN
42	/BEV3/CHBPR	KVGR1	TVV1	KVGR1	REF	C	CN
43	/BEV3/CHBPR	KVGR2	TVV2	KVGR2	REF	C	CN
44	/BEV3/CHBPR	KVGR3	TVV3	KVGR3	REF	C	CN
45	/BEV3/CHBPR	KVGR4	TVV4	KVGR4	REF	C	CN
46	/BEV3/CHBPR	KVGR5	TVV5	KVGR5	REF	C	CN
47	/BEV3/CHBPR	LGORT	T001L	LGORT	REF	C	CN
48	/BEV3/CHBPR	LLAND_AUFT	T005	LAND1	REF	C	CN
49	/BEV3/CHBPR	MANDT	T000	MANDT	KEY	1	CN
50	/BEV3/CHBPR	MATKL	T023	MATKL	REF	C	CN
51	/BEV3/CHBPR	MATNR	MARA	MATNR	REF	C	CN
52	/BEV3/CHBPR	MATWA	MARA	MATNR	REF	C	CN
53	/BEV3/CHBPR	MEINS	T006	MSEHI	REF	C	CN
54	/BEV3/CHBPR	MSR_REFUND_CODE	MSR_C_RET_REFUND	RETURNS_REFUND
55	/BEV3/CHBPR	MSR_RET_REASON	MSR_C_RET_REASON	RET_REASON
56	/BEV3/CHBPR	MVGR1	TVM1	MVGR1	REF	C	CN
57	/BEV3/CHBPR	MVGR2	TVM2	MVGR2	REF	C	CN
58	/BEV3/CHBPR	MVGR3	TVM3	MVGR3	REF	C	CN
59	/BEV3/CHBPR	MVGR4	TVM4	MVGR4	REF	C	CN
60	/BEV3/CHBPR	MVGR5	TVM5	MVGR5	REF	C	CN
61	/BEV3/CHBPR	PLTYP_AUFT	T189	PLTYP	REF	C	CN
62	/BEV3/CHBPR	PMATN	MARA	MATNR	REF	C	CN
63	/BEV3/CHBPR	POSNR	VBUP	POSNR	KEY	1	C
64	/BEV3/CHBPR	POSNV	VBUP	POSNR	REF	C	CN
65	/BEV3/CHBPR	POSPA	VBUP	POSNR	REF	C	CN
66	/BEV3/CHBPR	PRODH	T179	PRODH	REF	C	CN
67	/BEV3/CHBPR	PROVG	TVPR	PROVG	REF	C	CN
68	/BEV3/CHBPR	REGIO_AUFT	T005S	BLAND	REF	C	CN
69	/BEV3/CHBPR	RPLNR	FPLA	FPLNR	REF	C	N
70	/BEV3/CHBPR	SERNR	SNUM	SERNR	REF	C	CN
71	/BEV3/CHBPR	SPARA	TSPA	SPART	REF	C	CN
72	/BEV3/CHBPR	SPART	TSPA	SPART	REF	C	CN
73	/BEV3/CHBPR	UEPOS	VBUP	POSNR	REF	C	CN
74	/BEV3/CHBPR	UKONM	T178	KONDM	REF	C	CN
75	/BEV3/CHBPR	UPMAT	MARA	MATNR	REF	C	CN
76	/BEV3/CHBPR	VBELN	VBUK	VBELN	KEY	1	CN
77	/BEV3/CHBPR	VBELV	VBUK	VBELN	REF	C	CN
78	/BEV3/CHBPR	VGBEL	VBUK	VBELN	REF	1	CN
79	/BEV3/CHBPR	VGPOS	VBUP	POSNR	REF	1	CN
80	/BEV3/CHBPR	VKAUS	TVLV	ABRVW		C	CN
81	/BEV3/CHBPR	VKBUR	TVBUR	VKBUR	REF	C	CN
82	/BEV3/CHBPR	VKGRP	TVKGR	VKGRP	REF	C	CN
83	/BEV3/CHBPR	VKORG_AUFT	TVKO	VKORG	REF	C	CN
84	/BEV3/CHBPR	VOLEH	T006	MSEHI	REF	C	CN
85	/BEV3/CHBPR	VRKME	T006	MSEHI	REF	C	CN
86	/BEV3/CHBPR	VSTEL	TVST	VSTEL	REF	C	CN
87	/BEV3/CHBPR	VTWEG_AUFT	TVTW	VTWEG	REF	C	CN
88	/BEV3/CHBPR	WERKS	T001W	WERKS	REF	C	CN
89	/BEV3/CHBPR	WKREG	T005S	BLAND	REF	C	CN
90	/BEV3/CHBPR	WKTNR	VBUK	VBELN	REF	C	CN
91	/BEV3/CHBPR	WKTPS	VBUP	POSNR	REF	C	CN
92	/BEV3/CHBPR	WMINR	WWMI	WMINR	REF	1	CN

History

Last changed by/on	SAP	20141121
SAP Release Created in