SAP ABAP Table JVTZAEM2 (Sales Order Header Data)

Hierarchy

☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M (Application Component) SAP Media
     ⤷ JSD (Package) Appl. dev. R/3 Publishing Sales and Distribution System

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	JVTZAEM2	Table Relationship Diagram
Short Description	Sales Order Header Data

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	VERSANDDAT	☑	VRSNDDATUM	DATUM	DATS	8	0	IS-M: Shipping Date
3	ZAEHLER	☑	ISPZAEHLER	INT4	INT4	10	0	IS-M: Internal Counter for Carrier Change Notification
4	VBELN	☐	AVNR	AVNR	CHAR	10	0	IS-M/SD: Publishing Sales Order	*
5	GPAG	☐	GPAG	GPNR	CHAR	10	0	Business Partner: Sold-to Party	JGTGPNR
6	JPARVWGPAG	☐	JPARVWGPAG	JPARVWGPAG	CHAR	1	0	IS-M: Partner usage of sold-to party
7	ANGDT	☐	ANGDT_V	DATUM	DATS	8	0	Quotation/Inquiry is valid from
8	BNDDT	☐	BNDDT	DATUM	DATS	8	0	Date until which bid/quotation is binding (valid-to date)
9	VBTYP	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
10	TRVOG	☐	TRVOG_ISP	TRVOG_ISP	CHAR	1	0	Transaction Group for IS-M Order Processing
11	AUART	☐	AUART_ISP	AUART_ISP	CHAR	4	0	IS-M/SD: Sales Document Types	TJAK
12	AUARTGRP	☐	JAUARTGRP	JAUARTGRP	CHAR	1	0	IS-M/SD: Sales document type grouping
13	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
14	NETWR	☐	NETWR_AK	WERTV8	CURR	15	2	Net Value of the Sales Order in Document Currency
15	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
16	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVKOV
17	SPART	☐	SPART_AK	SPART	CHAR	2	0	Division for order header	TVTA
18	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVBVK
19	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVKBZ
20	EXEMPLART	☐	EXEMPLART	EXEMPLART	CHAR	1	0	IS-M: Copy Type
21	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
22	GSKST	☐	GSKST	GSBER	CHAR	4	0	Business area from cost center	TGSB
23	KNUMV	☐	KNUMV	KNUMV	CHAR	10	0	Number of the document condition
24	FAKSP	☐	FAKTSPERRE	FAKSP	CHAR	2	0	Billing Block	TVFS
25	KALSM	☐	KALSMASD	KALSM	CHAR	6	0	Sales and Distribution: Pricing Procedure in Pricing	T683
26	KURST	☐	KURST	KURST	CHAR	4	0	Exchange Rate Type	TCURV
27	BSTNK	☐	BSTNK	BSTNK	CHAR	20	0	Customer purchase order number
28	BSARK	☐	BSARK	BSARK	CHAR	4	0	Customer Order Type	T176
29	BSTDK	☐	BSTDK	DATUM	DATS	8	0	Customer purchase order date
30	BSTZD	☐	BSTZD	BSTZD	CHAR	4	0	Customer purchase order number supplement
31	IHREZ	☐	IHREZ	TEXT12	CHAR	12	0	Your Reference
32	BNAME	☐	BNAME_V	NAME	CHAR	35	0	Name of orderer
33	TELF1	☐	TELF1_VP	TELF1	CHAR	16	0	Telephone Number
34	STAFO	☐	STAFO	STAFO	CHAR	6	0	Update group for statistics update	TMCB
35	STWAE	☐	STWAE	WAERS	CUKY	5	0	Statistics currency	TCURC
36	XIMMATRIK	☐	XIMMATRIK	XFELD	CHAR	1	0	Indicator: Proof of matriculation provided
37	IMMATDAT	☐	IMMATDAT	DATUM	DATS	8	0	Matriculation Certificate Valid To
38	XSEPFKKOPF	☐	XSEPFKKOPF	XFELD	CHAR	1	0	Separate billing document for sales order
39	XREMRECHT	☐	XREMRECHT	XFELD	CHAR	1	0	IS-M: Right of Return
40	REMSP	☐	REMSP	XFELD	CHAR	1	0	IS-M: Billing Block for Return Notification
41	KORRGRD	☐	KORRGRD	KORRGRD	CHAR	3	0	IS-M: Reason for correction	TJK81
42	REMVON	☐	REMVON_ISP	DATUM	DATS	8	0	IS-M: Return date from
43	REMBIS	☐	REMBIS_ISP	DATUM	DATS	8	0	IS-M: Return date valid to
44	REFBELEG	☐	REMELD_ISP	CHAR20	CHAR	20	0	IS-M/SD: Reference Document in Legacy System
45	REMDATUM	☐	REMDAT_ISP	DATUM	DATS	8	0	IS-M: Date of return notification
46	REMSCHEIN	☐	RSCHEIN_IS	NUM6	NUMC	6	0	IS-M: Return slip number
47	IVWDATUM	☐	IVWDATUM	DATUM	DATS	8	0	Date of Audit Report for Returns
48	POSNR_LAST	☐	POSNR_LAST	APNR	NUMC	6	0	Last Assigned Item Number	JKAP
49	POSEX_LAST	☐	POSEX_LAST	POSEX_ISP	NUMC	6	0	Last purchase order item number assigned
50	KPOSN_LAST	☐	KPOSN_LAST	NUM6	NUMC	6	0	IS-M: Last condition item number assigned
51	XFKBASAUFT	☐	XFKBASAUFT	XFELD	CHAR	1	0	IS-M: Billing based on order
52	XFKBASLIEF	☐	XFKBASLIEF	XFELD	CHAR	1	0	IS-M: Billing based on delivery
53	XJKSOFAKT	☐	XJKSOFAKT	XFELD	CHAR	1	0	IS-M/SD: Immed.billing for credit memo request (subsc.only)
54	.INCLUDE	☐				0	0	Created-By Data (Medium Scope)
55	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
56	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
57	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
58	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
59	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
60	AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change
61	XWBZABO	☐	XWBZABO	XFELD	CHAR	1	0	IS-M: WBZ subscription
62	XFKVDICHT	☐	XFKVDICHT	XFELD	CHAR	1	0	IS-M: Summarize deliveries according to billing item
63	XSTATARC	☐	XJSTATARC	XFELD	CHAR	1	0	IS-M: Order archived in full (only placed in archive)
64	XNOMESS	☐	XNOMESS	XFELD	CHAR	1	0	IS-M: Indicator - Do Not Perform Output Determination

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JVTZAEM2	AUART	TJAK	AUART	REF	1	CN
2	JVTZAEM2	BSARK	T176	BSARK	REF	C	CN
3	JVTZAEM2	FAKSP	TVFS	FAKSP	REF	C	CN
4	JVTZAEM2	GPAG	JGTGPNR	GPNR	KEY	1	CN
5	JVTZAEM2	GSBER	TGSB	GSBER	REF	C	CN
6	JVTZAEM2	GSKST	TGSB	GSBER	REF	C	CN
7	JVTZAEM2	KALSM	T683	KALSM	REF	C	CN
8	JVTZAEM2	KORRGRD	TJK81	KORRGRD	REF	C	CN
9	JVTZAEM2	KURST	TCURV	KURST	REF	C	CN
10	JVTZAEM2	MANDT	T000	MANDT	KEY	1	CN
11	JVTZAEM2	POSNR_LAST	JKAP	POSNR	REF	1	CN
12	JVTZAEM2	SPART	TVTA	SPART	KEY	1	CN
13	JVTZAEM2	STAFO	TMCB	STAFO	REF	C	CN
14	JVTZAEM2	STWAE	TCURC	WAERS	REF	C	CN
15	JVTZAEM2	VKBUR	TVKBZ	VKBUR	REF	C	CN
16	JVTZAEM2	VKGRP	TVBVK	VKGRP	REF	C	CN
17	JVTZAEM2	VKORG	TVKO	VKORG	KEY	1	CN
18	JVTZAEM2	VTWEG	TVKOV	VTWEG	KEY	1	CN
19	JVTZAEM2	WAERK	TCURC	WAERS	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in