JVTZAEM2 SAP (Sales Order Header Data) Table details

Dictionary Type: Table
Description: Sales Order Header Data




ABAP Code to SELECT data from JVTZAEM2
Related tables to JVTZAEM2
Access table JVTZAEM2




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
MANDTClient MANDTCLNT3T000MANDT
VERSANDDATIS-M: Shipping Date VRSNDDATUMDATS8DATUMRFD
ZAEHLERIS-M: Internal Counter for Carrier Change Notification ISPZAEHLERINT410INT4
VBELNIS-M/SD: Publishing Sales Order AVNRCHAR10Assigned to domainALPHAAVNRJK1MJK1
GPAGBusiness Partner: Sold-to Party GPAGCHAR10JGTGPNRALPHAGPNR
JPARVWGPAGIS-M: Partner usage of sold-to party JPARVWGPAGCHAR1JPARVWGPAG
ANGDTQuotation/Inquiry is valid from ANGDT_VDATS8DATUM
BNDDTDate until which bid/quotation is binding (valid-to date) BNDDTDATS8DATUM
VBTYPSD document category VBTYPCHAR1VBTYP
TRVOGTransaction Group for IS-M Order Processing TRVOG_ISPCHAR1TRVOG_ISP
AUARTIS-M/SD: Sales Document Types AUART_ISPCHAR4TJAKAUART_ISPJAD
AUARTGRPIS-M/SD: Sales document type grouping JAUARTGRPCHAR1JAUARTGRPJKAUARTGRP
WAERKSD Document Currency WAERKCUKY5TCURCWAERSFWS
NETWRNet Value of the Sales Order in Document Currency NETWR_AKCURR15(2) WERTV8
VKORGSales Organization VKORGCHAR4TVKOVKORGVKOC_VKORG
VTWEGDistribution Channel VTWEGCHAR2TVKOVVTWEGVTWC_VTWEG
SPARTDivision for order header SPART_AKCHAR2TVTASPARTSPA
VKGRPSales Group VKGRPCHAR3TVBVKVKGRPVKG
VKBURSales Office VKBURCHAR4TVKBZVKBURVKB
EXEMPLARTIS-M: Copy Type EXEMPLARTCHAR1EXEMPLART
GSBERBusiness Area GSBERCHAR4TGSBGSBERGSB
GSKSTBusiness area from cost center GSKSTCHAR4TGSBGSBER
KNUMVNumber of the document condition KNUMVCHAR10KNUMV
FAKSPBilling Block FAKTSPERRECHAR2TVFSFAKSP
KALSMSales and Distribution: Pricing Procedure in Pricing KALSMASDCHAR6T683KALSM
KURSTExchange Rate Type KURSTCHAR4TCURVKURSTKUT
BSTNKCustomer purchase order number BSTNKCHAR20BSTNK
BSARKCustomer purchase order type BSARKCHAR4T176BSARK
BSTDKCustomer purchase order date BSTDKDATS8DATUM
BSTZDPurchase order number supplement BSTZDCHAR4BSTZD
IHREZYour Reference IHREZCHAR12TEXT12
BNAMEName of orderer BNAME_VCHAR35NAME
TELF1Telephone Number TELF1_VPCHAR16TELF1
STAFOUpdate group for statistics update STAFOCHAR6TMCBALPHASTAFOMCF
STWAEStatistics currency STWAECUKY5TCURCWAERS
XIMMATRIKIndicator: Proof of matriculation provided XIMMATRIKCHAR1XFELD
IMMATDATMatriculation Certificate Valid To IMMATDATDATS8DATUM
XSEPFKKOPFSeparate billing document for sales order XSEPFKKOPFCHAR1XFELD
XREMRECHTIS-M: Right of Return XREMRECHTCHAR1XFELD
REMSPIS-M: Billing Block for Return Notification REMSPCHAR1XFELD
KORRGRDIS-M: Reason for correction KORRGRDCHAR3TJK81KORRGRDJK7
REMVONIS-M: Return date from REMVON_ISPDATS8DATUMJRV
REMBISIS-M: Return date valid to REMBIS_ISPDATS8DATUMJRB
REFBELEGIS-M/SD: Reference Document in Legacy System REMELD_ISPCHAR20CHAR20
REMDATUMIS-M: Date of return notification REMDAT_ISPDATS8DATUM
REMSCHEINIS-M: Return slip number RSCHEIN_ISNUMC6NUM6
IVWDATUMDate of Audit Report for Returns IVWDATUMDATS8DATUM
POSNR_LASTLast Assigned Item Number POSNR_LASTNUMC6JKAPAPNR
POSEX_LASTLast purchase order item number assigned POSEX_LASTNUMC6POSEX_ISP
KPOSN_LASTIS-M: Last condition item number assigned KPOSN_LASTNUMC6NUM6
XFKBASAUFTIS-M: Billing based on order XFKBASAUFTCHAR1XFELD
XFKBASLIEFIS-M: Billing based on delivery XFKBASLIEFCHAR1XFELD
XJKSOFAKTIS-M/SD: Immed.billing for credit memo request (subsc.only) XJKSOFAKTCHAR1XFELD
ERFUSERCreated By ERFUSERCHAR12USNAM
ERFDATECreated On ERFDATEDATS8DATUM
ERFTIMETime Created ERFTIMETIMS6UZEIT
AENUSERLast Changed By AENUSERCHAR12USNAM
AENDATEDate of Last Change AENDATEDATS8DATUM
AENTIMETime of Last Change AENTIMETIMS6UZEIT
XWBZABOIS-M: WBZ subscription XWBZABOCHAR1XFELD
XFKVDICHTIS-M: Summarize deliveries according to billing item XFKVDICHTCHAR1XFELD
XSTATARCIS-M: Order archived in full (only placed in archive) XJSTATARCCHAR1XFELD
XNOMESSIS-M: Indicator - Do Not Perform Output Determination XNOMESSCHAR1XFELD

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 table
DATA: 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 as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!