JVTZAEM2 SAP (Sales Order Header Data) Table details
Dictionary Type: Table
Description: Sales Order Header Data
Description: Sales Order Header Data
Table field list including key, data, relationships and ABAP select examples
JVTZAEM2 is a standard SAP Table which is used to store Sales Order Header Data data and is available within R/3 SAP systems depending on the version and release level.
The JVTZAEM2 table consists of various fields, each holding specific information or linking keys about Sales Order Header Data data available in SAP. These include VERSANDDAT (IS-M: Shipping Date), ZAEHLER (IS-M: Internal Counter for Carrier Change Notification), VBELN (IS-M/SD: Publishing Sales Order), GPAG (Business Partner: Sold-to Party).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP JVTZAEM2 table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
VERSANDDAT | IS-M: Shipping Date | VRSNDDATUM | DATS | 8 | DATUM | RFD | |||
ZAEHLER | IS-M: Internal Counter for Carrier Change Notification | ISPZAEHLER | INT4 | 10 | INT4 | ||||
VBELN | IS-M/SD: Publishing Sales Order | AVNR | CHAR | 10 | Assigned to domain | ALPHA | AVNR | JK1 | MJK1 |
GPAG | Business Partner: Sold-to Party | GPAG | CHAR | 10 | JGTGPNR | ALPHA | GPNR | ||
JPARVWGPAG | IS-M: Partner usage of sold-to party | JPARVWGPAG | CHAR | 1 | JPARVWGPAG | ||||
ANGDT | Quotation/Inquiry is valid from | ANGDT_V | DATS | 8 | DATUM | ||||
BNDDT | Date until which bid/quotation is binding (valid-to date) | BNDDT | DATS | 8 | DATUM | ||||
VBTYP | SD document category | VBTYP | CHAR | 1 | VBTYP | ||||
TRVOG | Transaction Group for IS-M Order Processing | TRVOG_ISP | CHAR | 1 | TRVOG_ISP | ||||
AUART | IS-M/SD: Sales Document Types | AUART_ISP | CHAR | 4 | TJAK | AUART_ISP | JAD | ||
AUARTGRP | IS-M/SD: Sales document type grouping | JAUARTGRP | CHAR | 1 | JAUARTGRP | JKAUARTGRP | |||
WAERK | SD Document Currency | WAERK | CUKY | 5 | TCURC | WAERS | FWS | ||
NETWR | Net Value of the Sales Order in Document Currency | NETWR_AK | CURR | 15(2) | WERTV8 | ||||
VKORG | Sales Organization | VKORG | CHAR | 4 | TVKO | VKORG | VKO | C_VKORG | |
VTWEG | Distribution Channel | VTWEG | CHAR | 2 | TVKOV | VTWEG | VTW | C_VTWEG | |
SPART | Division for order header | SPART_AK | CHAR | 2 | TVTA | SPART | SPA | ||
VKGRP | Sales Group | VKGRP | CHAR | 3 | TVBVK | VKGRP | VKG | ||
VKBUR | Sales Office | VKBUR | CHAR | 4 | TVKBZ | VKBUR | VKB | ||
EXEMPLART | IS-M: Copy Type | EXEMPLART | CHAR | 1 | EXEMPLART | ||||
GSBER | Business Area | GSBER | CHAR | 4 | TGSB | GSBER | GSB | ||
GSKST | Business area from cost center | GSKST | CHAR | 4 | TGSB | GSBER | |||
KNUMV | Number of the document condition | KNUMV | CHAR | 10 | KNUMV | ||||
FAKSP | Billing Block | FAKTSPERRE | CHAR | 2 | TVFS | FAKSP | |||
KALSM | Sales and Distribution: Pricing Procedure in Pricing | KALSMASD | CHAR | 6 | T683 | KALSM | |||
KURST | Exchange Rate Type | KURST | CHAR | 4 | TCURV | KURST | KUT | ||
BSTNK | Customer purchase order number | BSTNK | CHAR | 20 | BSTNK | ||||
BSARK | Customer purchase order type | BSARK | CHAR | 4 | T176 | BSARK | |||
BSTDK | Customer purchase order date | BSTDK | DATS | 8 | DATUM | ||||
BSTZD | Purchase order number supplement | BSTZD | CHAR | 4 | BSTZD | ||||
IHREZ | Your Reference | IHREZ | CHAR | 12 | TEXT12 | ||||
BNAME | Name of orderer | BNAME_V | CHAR | 35 | NAME | ||||
TELF1 | Telephone Number | TELF1_VP | CHAR | 16 | TELF1 | ||||
STAFO | Update group for statistics update | STAFO | CHAR | 6 | TMCB | ALPHA | STAFO | MCF | |
STWAE | Statistics currency | STWAE | CUKY | 5 | TCURC | WAERS | |||
XIMMATRIK | Indicator: Proof of matriculation provided | XIMMATRIK | CHAR | 1 | XFELD | ||||
IMMATDAT | Matriculation Certificate Valid To | IMMATDAT | DATS | 8 | DATUM | ||||
XSEPFKKOPF | Separate billing document for sales order | XSEPFKKOPF | CHAR | 1 | XFELD | ||||
XREMRECHT | IS-M: Right of Return | XREMRECHT | CHAR | 1 | XFELD | ||||
REMSP | IS-M: Billing Block for Return Notification | REMSP | CHAR | 1 | XFELD | ||||
KORRGRD | IS-M: Reason for correction | KORRGRD | CHAR | 3 | TJK81 | KORRGRD | JK7 | ||
REMVON | IS-M: Return date from | REMVON_ISP | DATS | 8 | DATUM | JRV | |||
REMBIS | IS-M: Return date valid to | REMBIS_ISP | DATS | 8 | DATUM | JRB | |||
REFBELEG | IS-M/SD: Reference Document in Legacy System | REMELD_ISP | CHAR | 20 | CHAR20 | ||||
REMDATUM | IS-M: Date of return notification | REMDAT_ISP | DATS | 8 | DATUM | ||||
REMSCHEIN | IS-M: Return slip number | RSCHEIN_IS | NUMC | 6 | NUM6 | ||||
IVWDATUM | Date of Audit Report for Returns | IVWDATUM | DATS | 8 | DATUM | ||||
POSNR_LAST | Last Assigned Item Number | POSNR_LAST | NUMC | 6 | JKAP | APNR | |||
POSEX_LAST | Last purchase order item number assigned | POSEX_LAST | NUMC | 6 | POSEX_ISP | ||||
KPOSN_LAST | IS-M: Last condition item number assigned | KPOSN_LAST | NUMC | 6 | NUM6 | ||||
XFKBASAUFT | IS-M: Billing based on order | XFKBASAUFT | CHAR | 1 | XFELD | ||||
XFKBASLIEF | IS-M: Billing based on delivery | XFKBASLIEF | CHAR | 1 | XFELD | ||||
XJKSOFAKT | IS-M/SD: Immed.billing for credit memo request (subsc.only) | XJKSOFAKT | CHAR | 1 | XFELD | ||||
ERFUSER | Created By | ERFUSER | CHAR | 12 | USNAM | ||||
ERFDATE | Created On | ERFDATE | DATS | 8 | DATUM | ||||
ERFTIME | Time Created | ERFTIME | TIMS | 6 | UZEIT | ||||
AENUSER | Last Changed By | AENUSER | CHAR | 12 | USNAM | ||||
AENDATE | Date of Last Change | AENDATE | DATS | 8 | DATUM | ||||
AENTIME | Time of Last Change | AENTIME | TIMS | 6 | UZEIT | ||||
XWBZABO | IS-M: WBZ subscription | XWBZABO | CHAR | 1 | XFELD | ||||
XFKVDICHT | IS-M: Summarize deliveries according to billing item | XFKVDICHT | CHAR | 1 | XFELD | ||||
XSTATARC | IS-M: Order archived in full (only placed in archive) | XJSTATARC | CHAR | 1 | XFELD | ||||
XNOMESS | IS-M: Indicator - Do Not Perform Output Determination | XNOMESS | CHAR | 1 | XFELD |
Key field | Non-key field |
How do I retrieve data from SAP table JVTZAEM2 using ABAP code
The following ABAP code Example will allow you to do a basic selection on JVTZAEM2 to SELECT all data from the tableDATA: WA_JVTZAEM2 TYPE JVTZAEM2.
SELECT SINGLE *
FROM JVTZAEM2
INTO CORRESPONDING FIELDS OF WA_JVTZAEM2
WHERE...
How to access SAP table JVTZAEM2
Within an ECC or HANA version of SAP you can also view further information about JVTZAEM2 and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects