SAP ABAP Table QCERT_TS_BATCH (Quality Certificate Data at Batch Level)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ QC (Package) QM quality certificate

Basic Data

Table Category	INTTAB	Structure
Structure	QCERT_TS_BATCH	Table Relationship Diagram
Short Description	Quality Certificate Data at Batch Level

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	KZBATCH	☐	QKZ	QKZ	CHAR	1	0	X and Blank (Indicator)
2	VBDPL	☐	VBDPL		STRU	0	0
3	VBELN	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number
4	POSNR	☐	POSNR	POSNR	NUMC	6	0	Item number of the SD document
5	POSEX	☐	POSEX	POSEX	CHAR	6	0	Item Number of the Underlying Purchase Order
6	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number
7	MATWA	☐	MATWA	MATNR	CHAR	18	0	Material entered
8	IDNKD	☐	MATNR_KU	IDNEX	CHAR	35	0	Customer Material Number
9	ARKTX	☐	ARKTX	TEXT40	CHAR	40	0	Short text for sales order item
10	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant
11	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location
12	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel
13	SPART	☐	SPART	SPART	CHAR	2	0	Division
14	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office
15	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number
16	SERNR	☐	SERNR	SERNR	CHAR	8	0	BOM explosion number
17	HERKL	☐	HERKL	LAND1	CHAR	3	0	Country of origin of the material
18	HERKR	☐	HERKR	REGIO	CHAR	3	0	Region of origin of material (non-preferential origin)
19	STAWN	☐	STAWN	STAWN	CHAR	17	0	Commodity Code/Import Code Number for Foreign Trade
20	BRGEW	☐	BRGEW_15	MENG15	QUAN	15	3	Gross weight
21	NTGEW	☐	NTGEW_15	MENG15	QUAN	15	3	Net weight
22	GEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit
23	LFIMG	☐	LFIMG	MENG13	QUAN	13	3	Actual quantity delivered (in sales units)
24	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit
25	MBDAT	☐	MBDAT	DATUM	DATS	8	0	Material Staging/Availability Date
26	VBELN_VAUF	☐	VBELN_VAUF	VBELN	CHAR	10	0	Order
27	POSNR_VAUF	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item
28	AUDAT_VAUF	☐	AUDAT_VAUF	DATUM	DATS	8	0	Sales order date
29	BSTDK	☐	BSTDK	DATUM	DATS	8	0	Customer purchase order date
30	BSTNK	☐	BSTNK	BSTNK	CHAR	20	0	Customer purchase order number
31	BSTZD	☐	BSTZD	BSTZD	CHAR	4	0	Customer purchase order number supplement
32	IHREZ	☐	IHREZ	TEXT12	CHAR	12	0	Your Reference
33	INCO1	☐	INCO1	INCO1	CHAR	3	0	Incoterms (part 1)
34	INCO2	☐	INCO2	INCO2	CHAR	28	0	Incoterms (part 2)
35	INCO1_BEZ	☐	INCO1_BEZ	TEXT30	CHAR	30	0	Incoterm description
36	TDNAME	☐	TDOBNAME	TDOBNAME	CHAR	70	0	Name
37	UEPOS	☐	UEPOS	POSNR	NUMC	6	0	Higher-level item in bill of material structures
38	VOLUM	☐	VOLUM_15	MENG15	QUAN	15	3	Volume
39	VOLEH	☐	VOLEH	MEINS	UNIT	3	0	Volume unit
40	EAN11	☐	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
41	EXART	☐	EXART	EXART	CHAR	2	0	Business Transaction Type for Foreign Trade
42	EXART_BEZ	☐	BEZEI20	TEXT20	CHAR	20	0	Description
43	GRWRT	☐	GRWRT	GRWRT	CURR	13	2	Statistical value for foreign trade
44	VGBEL	☐	VGBEL	VBELN	CHAR	10	0	Document number of the reference document
45	VGPOS	☐	VGPOS	POSNR	NUMC	6	0	Item number of the reference item
46	VGTYP	☐	VGTYP	VORG_TYP	CHAR	3	0	Activity or element category
47	SORTKRI	☐	SORTKRI	CHAR20	CHAR	20	0	Sort Criterion
48	LGMNG	☐	LGMNG	MENG13	QUAN	13	3	Actual quantity delivered in stockkeeping units
49	KCMENG	☐	KCMENG	MENG15	QUAN	15	3	Cumulative batch quantity of all split items (in StckUnit)
50	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure
51	UECHA	☐	UECHA	POSNR	NUMC	6	0	Higher-Level Item of Batch Split Item
52	KCBRGEW	☐	KCBRGEW	MENG15	QUAN	15	3	Cumulative gross weight of all batch split items
53	KCNTGEW	☐	KCNTGEW	MENG15	QUAN	15	3	Cumulative net weight of all batch split items
54	KCGEWEI	☐	KCGEWEI	MEINS	UNIT	3	0	Weight unit for weight of all batch split items
55	KCVOLUM	☐	KCVOLUM	MENG15	QUAN	15	3	Cumulative volume of all batch split items
56	KCVOLEH	☐	KCVOLEH	MEINS	UNIT	3	0	Volume Unit for Volume of all Batch Split Items
57	KNUMH_CH	☐	KNUMH_CH	KNUMB	CHAR	10	0	Number of condition record from batch determination
58	UMVKZ	☐	UMVKZ	UMBSZ	DEC	5	0	Numerator (factor) for conversion of sales quantity into SKU
59	UMVKN	☐	UMVKN	UMBSN	DEC	5	0	Denominator (divisor) for conversion of sales qty. into SKU
60	CUOBJ	☐	CUOBJ_VA	CUOBJ	NUMC	18	0	Configuration
61	CUOBJ_CH	☐	CUOBJ_CH	CUOBJ	NUMC	18	0	Internal object number of the batch classification
62	SHKZG	☐	SHKZG_VA	XFELD	CHAR	1	0	Returns Item
63	PCKPF	☐	PCKPF	PCKPF	CHAR	1	0	Packing control
64	ABRVW	☐	ABRVW	ABRVW	CHAR	3	0	Usage Indicator
65	ABART	☐	ABART	ABART	CHAR	1	0	Release type
66	ABRLI	☐	ABRLI	ABRLI	NUMC	4	0	Internal delivery schedule number
67	AESKD	☐	AESKD	AESKD	CHAR	17	0	Customer Engineering Change Status
68	EMPST	☐	EMPST	TEXT25	CHAR	25	0	Receiving point
69	ABTNR	☐	ABTNR	ABTNR	CHAR	4	0	Department number
70	POSAR	☐	POSAR	POSAR	CHAR	1	0	Item type
71	PSTYV	☐	PSTYV_VL	PSTYV	CHAR	4	0	Delivery item category
72	TPREL	☐	TPREL	XFELD	CHAR	1	0	Indicator: Relevance for transport of deliv. item categories
73	KZWI1	☐	KZWI1	WERTV7	CURR	13	2	Subtotal 1 from pricing procedure for condition
74	KPEIN	☐	KPEIN	KPEIN	DEC	5	0	Condition pricing unit
75	KMEIN	☐	KMEIN	MEINS	UNIT	3	0	Condition Unit
76	NETPR	☐	NETPR	WERTV6	CURR	11	2	Net price
77	NETWR	☐	NETWR	WERTV8	CURR	15	2	Net Value in Document Currency
78	ANZSN	☐	ANZSN	INT4	INT4	10	0	Number of serial numbers
79	AKTNR	☐	WAKTION	WAKTION	CHAR	10	0	Promotion
80	SUGRD	☐	SUGRD	SUGRD	CHAR	4	0	Reason for material substitution
81	SUDRU	☐	SUDRU	XFELD	CHAR	1	0	Original entry will be printed
82	VBRST	☐	VBRST	CHAR14	CHAR	14	0	Customer point of consumption
83	USR01_VBLB	☐	USR01_D	TEXT35	CHAR	35	0	Additional data field 1 for delivery schedules
84	USR02_VBLB	☐	USR02_D	TEXT35	CHAR	35	0	Additional data field 2 for delivery schedules
85	USR03_VBLB	☐	USR03_D	TEXT35	CHAR	35	0	Additional data field 3 for delivery schedules
86	USR04_VBLB	☐	USR04_D	CHAR10	CHAR	10	0	Additional data field 4 for delivery schedules
87	USR05_VBLB	☐	USR05_D	CHAR10	CHAR	10	0	Additional data field 5 for delivery schedules
88	PREFE	☐	PREFE	PREFE	CHAR	1	0	Preference indicator in export/import
89	LABNK	☐	LABNK	TEXT17	CHAR	17	0	Customer number for forecast / JIT dlv. sched.
90	ABRDT	☐	ABRDT	DATUM	DATS	8	0	Delivery Schedule Date
91	KZUMW	☐	KZUMW	XFELD	CHAR	1	0	Indicator: Environmentally relevant
92	PROFL	☐	ADGE_PROFL	ADGD_PROFL	CHAR	3	0	Dangerous goods indicator profile
93	IDGPA	☐	ADGE_IDGPA	X	CHAR	1	0	Relevant for Dangerous Goods Documents
94	IDGCH	☐	ADGE_IDGCH	X	CHAR	1	0	Relevant for Dangerous Goods Checks
95	DGNTGEW	☐	ADGE_NTGEW	MENG15	QUAN	15	3	Dangerous goods - net weight
96	DGBRGEW	☐	ADGE_BRGEW	MENG15	QUAN	15	3	Dangerous Goods - Gross Weight
97	DGGEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit
98	DGVOLUM	☐	ADGE_VOLUM	MENG15	QUAN	15	3	Dangerous goods - volume
99	DGVOLEH	☐	VOLEH	MEINS	UNIT	3	0	Volume unit
100	DGARAND	☐	ADGE_KARN	X	CHAR	1	0	Exemption
101	DGREPQU	☐	ADGE_IRQA	X	CHAR	1	0	Indicator: Reportable quantity
102	DGPULIM	☐	ADGE_IPUL	X	CHAR	1	0	Packed Under 450 l
103	DGPAS	☐	ADGE_PAS	X	CHAR	1	0	Listed Goods
104	DGMDDAT	☐	ADGE_MDDAT	DATUM	DATS	8	0	Selection date dangerous goods master data
105	BSTKD	☐	BSTKD	BSTKD	CHAR	35	0	Customer purchase order number
106	BSARK	☐	BSARK	BSARK	CHAR	4	0	Customer Order Type
107	BSTKD_E	☐	BSTKD_E	BSTKD	CHAR	35	0	Ship-to Party's Purchase Order Number
108	BSTDK_E	☐	BSTDK_E	DATUM	DATS	8	0	Ship-to party's PO date
109	BSARK_E	☐	BSARK_E	BSARK	CHAR	4	0	Ship-to party purchase order type
110	IHREZ_E	☐	IHREZ_E	TEXT12	CHAR	12	0	Ship-to party character
111	POSEX_E	☐	POSEX_E	POSEX	CHAR	6	0	Item Number of the Underlying Purchase Order
112	VBKLT	☐	VBKLT	VBKLT	CHAR	1	0	SD document indicator
113	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group
114	MTART	☐	MTART	MTART	CHAR	4	0	Material type
115	PRODH	☐	PRODH_D	PRODH	CHAR	18	0	Product Hierarchy
116	QMNUM	☐	QMNUM	QMNUM	CHAR	12	0	Message Number
117	QMDAT	☐	QMDAT	DATUM	DATS	8	0	Date of Notification
118	.INCLUDE	☐				0	0	Multistep Returns - Item Data for Printing
119	MSR_ID	☐	MSR_PROCESS_ID	MSR_PROCESS_ID	CHAR	10	0	Process Identification Number
120	MSR_ITEM	☐	MSR_PROCESS_ITEM	MSR_PROCESS_ITEM	NUMC	6	0	Item Number
121	RMA_CUSTOMER	☐	MSR_CRMA_NR	MSR_RMA_NR	CHAR	20	0	Customer RMA Number
122	MSR_RET_REASON	☐	MSR_RETURNS_REASON	MSR_RETURNS_REASON	CHAR	3	0	Return Reason
123	MSR_RET_REASON_TEXT	☐	MSR_RET_REASON_TEXT	TEXT60	CHAR	60	0	Return Reason Description
124	MSR_MAT_RECEIVED	☐	MSR_MATERIAL_RECEIVED	XFELD	CHAR	1	0	Material Received
125	MSR_FU_CODE	☐	MSR_FU_CODE	MSR_FU_CODE	CHAR	4	0	Follow-Up Activity Code
126	MSR_FU_CODE_TEXT	☐	MSR_FU_CODE_TEXT	TEXT60	CHAR	60	0	Follow-Up Activity Description
127	MSR_FORW_VENDOR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor
128	MSR_FWV_TITLE	☐	AD_TITLE	AD_TITLE	CHAR	4	0	Form-of-Address Key
129	MSR_FWV_ADDRNUM	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number
130	MSR_FWV_NAME1	☐	AD_NAME1	TEXT40	CHAR	40	0	Name 1
131	MSR_FWV_NAME2	☐	AD_NAME2	TEXT40	CHAR	40	0	Name 2
132	MSR_FWV_NAME3	☐	AD_NAME3	TEXT40	CHAR	40	0	Name 3
133	MSR_FWV_NAME4	☐	AD_NAME4	TEXT40	CHAR	40	0	Name 4
134	MSR_FWV_STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
135	MSR_FWV_PO_BOX	☐	AD_POBX	CHAR10	CHAR	10	0	PO Box
136	MSR_FWV_PO_BOX_LOC	☐	AD_POBXLOC	TEXT40	CHAR	40	0	PO Box city
137	MSR_FWV_CITY_CODE2	☐	AD_CIT2NUM	CITY_CODE	CHAR	12	0	City PO box code (City file)
138	MSR_FWV_COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key
139	MSR_FWV_LANGU	☐	SPRAS	SPRAS	LANG	1	0	Language Key
140	MSR_FWV_POST_CODE1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
141	MSR_FWV_CITY1	☐	AD_CITY1	TEXT40	CHAR	40	0	City
142	MSR_FWV_CITY2	☐	AD_CITY2	TEXT40	CHAR	40	0	District
143	MSR_FWV_REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)
144	RMA_VENDOR	☐	MSR_VRMA_NR	MSR_RMA_NR	CHAR	20	0	Vendor RMA Number
145	MSR_REFUND_CODE	☐	MSR_RETURNS_REFUND_CODE	MSR_RETURNS_REFUND_CODE	CHAR	3	0	Returns Refund Code
146	MSR_REFUND_CODE_TEXT	☐	MSR_REFUND_CODE_TEXT	TEXT60	CHAR	60	0	Refund Code Description
147	MSR_FORW_PLANT1	☐	WERKS_D	WERKS	CHAR	4	0	Plant
148	MSR_PLANT1_TXT	☐	NAME1	TEXT30	CHAR	30	0	Name
149	MSR_FORW_PLANT2	☐	WERKS_D	WERKS	CHAR	4	0	Plant
150	MSR_PLANT2_TXT	☐	NAME1	TEXT30	CHAR	30	0	Name
151	MSR_FORW_PLANT3	☐	WERKS_D	WERKS	CHAR	4	0	Plant
152	MSR_PLANT3_TXT	☐	NAME1	TEXT30	CHAR	30	0	Name
153	.INCLUDE	☐				0	0	Doc.Item View Delivery Note: Customer Modification
154	DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
155	.INCLU--AP	☐				0	0	Fields for Material Sorting VBDPL
156	.INCLUDE	☐				0	0	Doc.Item View Delivery Note: Customer Modification
157	/BEV1/EMMVGR1	☐	MVGR1	MVGR1	CHAR	3	0	Material group 1
158	/BEV1/EMMVGR2	☐	MVGR2	MVGR2	CHAR	3	0	Material group 2
159	/BEV1/EMMVGR3	☐	MVGR3	MVGR3	CHAR	3	0	Material group 3
160	/BEV1/EMMVGR4	☐	MVGR4	MVGR4	CHAR	3	0	Material group 4
161	/BEV1/EMMVGR5	☐	MVGR5	MVGR5	CHAR	3	0	Material group 5
162	/BEV1/EMNEUPOS	☐	POSNR	POSNR	NUMC	6	0	Item number of the SD document
163	MCHAR	☐	MCHAR		STRU	0	0
164	.INCLUDE	☐				0	0	Transfer Table to SAPLMBIN for Batch/Stock Selection
165	ZEILC	☐	DZEILE	ZEILE	NUMC	3	0	Line Number
166	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number
167	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant
168	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location
169	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number
170	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type
171	CLABS	☐	LABST	MENG13V	QUAN	13	3	Valuated Unrestricted-Use Stock
172	MENGE	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
173	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure
174	ERFMG	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
175	ERFME	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure
176	ZUSTD	☐	DZUSTD	XFELD	CHAR	1	0	Batch in Restricted-Use Stock
177	ZUSCH	☐	DZUSCH	ZUSCH	CHAR	1	0	Batch status key
178	BSTAR	☐	BSTAR	BSTAR	CHAR	1	0	Stock type
179	SPERC	☐	SPERR	SPERR	CHAR	1	0	Physical inventory blocking indicator
180	XSELK	☐	XSELP	XFELD	CHAR	1	0	Item selected (selected, chosen, ...)
181	KZICL	☐	KZILL	INVKZ	CHAR	3	0	Physical inventory indicator for whse stock in current year
182	KZVCL	☐	KZILL	INVKZ	CHAR	3	0	Physical inventory indicator for whse stock in current year
183	KZICQ	☐	KZILL	INVKZ	CHAR	3	0	Physical inventory indicator for whse stock in current year
184	KZVCQ	☐	KZILL	INVKZ	CHAR	3	0	Physical inventory indicator for whse stock in current year
185	KZICS	☐	KZILL	INVKZ	CHAR	3	0	Physical inventory indicator for whse stock in current year
186	KZVCS	☐	KZILL	INVKZ	CHAR	3	0	Physical inventory indicator for whse stock in current year
187	VERAB	☐	VERAB	DATUM	DATS	8	0	Availability date
188	VFDAT	☐	VFDAT	DATUM	DATS	8	0	Shelf Life Expiration or Best-Before Date
189	LVOCA	☐	LVOCA	XFELD	CHAR	1	0	Deletion Flag for All Data on a Batch at a Plant
190	HERKR	☐	HERKR	REGIO	CHAR	3	0	Region of origin of material (non-preferential origin)
191	HERKL	☐	HERKL	LAND1	CHAR	3	0	Country of origin of the material
192	MTVER	☐	MTVER	MTVER	CHAR	4	0	Export/import material group
193	LIFCH	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number
194	LICHA	☐	LICHN	LICHN	CHAR	15	0	Vendor Batch Number
195	QNDAT	☐	QNPDAT	DATUM	DATS	8	0	Next Inspection Date
196	ZAEDT	☐	DZAEDT	DATUM	DATS	8	0	Date of last status change
197	FVDT1	☐	FVDAT	DATUM	DATS	8	0	Date for unrestricted use
198	FVDT2	☐	FVDAT	DATUM	DATS	8	0	Date for unrestricted use
199	FVDT3	☐	FVDAT	DATUM	DATS	8	0	Date for unrestricted use
200	FVDT4	☐	FVDAT	DATUM	DATS	8	0	Date for unrestricted use
201	FVDT5	☐	FVDAT	DATUM	DATS	8	0	Date for unrestricted use
202	FVDT6	☐	FVDAT	DATUM	DATS	8	0	Date for unrestricted use
203	LVOCB	☐	LVOCB	XFELD	CHAR	1	0	Deletion Flag for All Data on a Batch Stock
204	HSDAT	☐	HSDAT	DATUM	DATS	8	0	Date of Manufacture
205	LWEDT	☐	LWEDT	DATUM	DATS	8	0	Date of last goods receipt
206	ERSDA	☐	ERSDA	DATUM	DATS	8	0	Created On
207	LOT_TAB	☐	QCERT_TT_LOT		TTYP	0	0

History

Last changed by/on	SAP	20130529
SAP Release Created in	700