VVBAK SAP (Sales Document: Header Data) Table details
Dictionary Type: Table
Description: Sales Document: Header Data
Description: Sales Document: Header Data
Table field list including key, data, relationships and ABAP select examples
VVBAK is a standard SAP Table which is used to store Sales Document: Header Data data and is available within R/3 SAP systems depending on the version and release level.
The VVBAK table consists of various fields, each holding specific information or linking keys about Sales Document: Header Data data available in SAP. These include VBELN (Sales Document), ERDAT (Date on Which Record Was Created), ERZET (Entry time), ERNAM (Name of Person who Created the Object).. 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: Not classified
SAP VVBAK 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 | |||
VBELN | Sales Document | VBELN_VA | CHAR | 10 | VBUK | ALPHA | VBELN | AUN | |
ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | DATUM | ||||
ERZET | Entry time | ERZET | TIMS | 6 | UZEIT | ||||
ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
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 | ||||
AUDAT | Document Date (Date Received/Sent) | AUDAT | DATS | 8 | DATUM | ||||
VBTYP | SD document category | VBTYP | CHAR | 1 | VBTYP | ||||
TRVOG | Transaction group | TRVOG | CHAR | 1 | TRVOG | VTV | |||
AUART | Sales Document Type | AUART | CHAR | 4 | TVAK | AUART | AUART | AAT | |
AUGRU | Order reason (reason for the business transaction) | AUGRU | CHAR | 3 | TVAU | AUGRU | |||
GWLDT | Warranty Date | GWLDT | DATS | 8 | DATUM | ||||
SUBMI | Collective number (SD) | SUBMI_SD | CHAR | 10 | CHAR10 | ||||
LIFSK | Delivery block (document header) | LIFSK | CHAR | 2 | TVLS | LIFSP | |||
FAKSK | Billing block in SD document | FAKSK | CHAR | 2 | TVFS | FAKSP | |||
NETWR | Net Value of the Sales Order in Document Currency | NETWR_AK | CURR | 15(2) | WERTV8 | ||||
WAERK | SD Document Currency | WAERK | CUKY | 5 | TCURC | WAERS | FWS | ||
VKORG | Sales Organization | VKORG | CHAR | 4 | TVKO | VKORG | VKO | C_VKORG | |
VTWEG | Distribution Channel | VTWEG | CHAR | 2 | TVKOV | VTWEG | VTW | C_VTWEG | |
SPART | Division | SPART | CHAR | 2 | TVTA | SPART | SPA | C_SPART | |
VKGRP | Sales Group | VKGRP | CHAR | 3 | TVBVK | VKGRP | VKG | ||
VKBUR | Sales Office | VKBUR | CHAR | 4 | TVKBZ | VKBUR | VKB | ||
GSBER | Business Area | GSBER | CHAR | 4 | TGSB | GSBER | GSB | ||
GSKST | Business area from cost center | GSKST | CHAR | 4 | TGSB | GSBER | |||
GUEBG | Valid-from date (outline agreements, product proposals) | GUEBG | DATS | 8 | DATUM | ||||
GUEEN | Valid-to date (outline agreements, product proposals) | GUEEN | DATS | 8 | DATUM | ||||
KNUMV | Number of the document condition | KNUMV | CHAR | 10 | KNUMV | ||||
VDATU | Requested delivery date | EDATU_VBAK | DATS | 8 | DATUM | ||||
VPRGR | Proposed date type | PRGRS_VBAK | CHAR | 1 | PRGRS | ||||
AUTLF | Complete delivery defined for each sales order? | AUTLF | CHAR | 1 | XFELD | ||||
VBKLA | Original system with release and transaction control | VBKLA | CHAR | 9 | CHAR9 | ||||
VBKLT | SD document indicator | VBKLT | CHAR | 1 | VBKLT | ||||
KALSM | Sales and Distribution: Pricing Procedure in Pricing | KALSMASD | CHAR | 6 | T683 | KALSM | |||
VSBED | Shipping Conditions | VSBED | CHAR | 2 | TVSB | VSBED | |||
FKARA | Proposed billing type for an order-related billing document | FKARA | CHAR | 4 | TVFK | FKART | |||
AWAHR | Sales probability | AWAHR_AK | NUMC | 3 | AWAHR | ||||
KTEXT | Search term for product proposal | KTEXT_V | CHAR | 40 | TEXT40 | ||||
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 | ||||
MAHZA | Number of contacts from the customer | MAHZA | DEC | 3 | PACK2 | ||||
MAHDT | Last customer contact date | MAHDT | DATS | 8 | DATUM | ||||
KUNNR | Sold-to party | KUNAG | CHAR | 10 | KNA1 | ALPHA | KUNNR | VAG | |
KOSTL | Cost Center | KOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KOS | |
STAFO | Update group for statistics update | STAFO | CHAR | 6 | Assigned to domain | ALPHA | STAFO | MCF | |
STWAE | Statistics currency | STWAE | CUKY | 5 | TCURC | WAERS | |||
AEDAT | Changed On | AEDAT | DATS | 8 | DATUM | ||||
KVGR1 | Customer group 1 | KVGR1 | CHAR | 3 | TVV1 | KVGR1 | |||
KVGR2 | Customer group 2 | KVGR2 | CHAR | 3 | TVV2 | KVGR2 | |||
KVGR3 | Customer group 3 | KVGR3 | CHAR | 3 | TVV3 | KVGR3 | |||
KVGR4 | Customer group 4 | KVGR4 | CHAR | 3 | TVV4 | KVGR4 | |||
KVGR5 | Customer group 5 | KVGR5 | CHAR | 3 | TVV5 | KVGR5 | |||
KNUMA | Agreement (various conditions grouped together) | KNUMA | CHAR | 10 | KONA | ALPHA | KNUMA | VMBO | |
KOKRS | Controlling Area | KOKRS | CHAR | 4 | TKA01 | CACCD | CAC | ||
PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 8 | PRPS | KONPR | PS_POSNR | ||
KURST | Exchange Rate Type | KURST | CHAR | 4 | TCURV | KURST | KUT | ||
KKBER | Credit control area | KKBER | CHAR | 4 | T014 | KKBER | KKB | ||
KNKLI | Customer's account number with credit limit reference | KNKLI | CHAR | 10 | KNA1 | ALPHA | KUNNR | ||
GRUPP | Customer Credit Group | GRUPP_CM | CHAR | 4 | Assigned to domain | GRUPP_CM | |||
SBGRP | Credit representative group for credit management | SBGRP_CM | CHAR | 3 | T024B | SBGRP_CM | KBG | ||
CTLPC | Credit management: Risk category | CTLPC_CM | CHAR | 3 | T691A | CTLPC_CM | |||
CMWAE | Currency key of credit control area | WAERS_CM | CUKY | 5 | TCURC | WAERS | |||
CMFRE | Release date of the document determined by credit management | CMFRE | DATS | 8 | DATUM | ||||
CMNUP | Date of next credit check of document | CMNUP | DATS | 8 | DATUM | ||||
CMNGV | Next date | CMNGV | DATS | 8 | DATUM | ||||
AMTBL | Released credit value of the document | AMTBL_CM | CURR | 15(2) | WERTV8 | ||||
HITYP_PR | Hierarchy type for pricing | HITYP_PR | CHAR | 1 | THIT | HITYP | |||
ABRVW | Usage Indicator | ABRVW | CHAR | 3 | TVLV | ABRVW | |||
ABDIS | MRP for delivery schedule types | ABDIS | CHAR | 1 | ABRAB | ||||
VGBEL | Document number of the reference document | VGBEL | CHAR | 10 | VBUK | ALPHA | VBELN | ||
OBJNR | Object number at header level | OBJKO | CHAR | 22 | ONR00 | J_OBJNR | |||
BUKRS_VF | Company code to be billed | BUKRS_VF | CHAR | 4 | T001 | BUKRS | BUK | ||
TAXK1 | Alternative tax classification | TAXK1_AK | CHAR | 1 | Assigned to domain | TAXKD | |||
TAXK2 | Tax classification 2 for customer | TAXK2 | CHAR | 1 | Assigned to domain | TAXKD | |||
TAXK3 | Tax classification 3 for customer | TAXK3 | CHAR | 1 | Assigned to domain | TAXKD | |||
TAXK4 | Tax Classification 4 Customer | TAXK4 | CHAR | 1 | Assigned to domain | TAXKD | |||
TAXK5 | Tax classification 5 for customer | TAXK5 | CHAR | 1 | Assigned to domain | TAXKD | |||
TAXK6 | Tax classification 6 for customer | TAXK6 | CHAR | 1 | Assigned to domain | TAXKD | |||
TAXK7 | Tax classification 7 for customer | TAXK7 | CHAR | 1 | Assigned to domain | TAXKD | |||
TAXK8 | Tax classification 8 for customer | TAXK8 | CHAR | 1 | Assigned to domain | TAXKD | |||
TAXK9 | Tax classification 9 for customer | TAXK9 | CHAR | 1 | Assigned to domain | TAXKD | |||
XBLNR | Reference Document Number | XBLNR_V | CHAR | 16 | XBLNR | ||||
ZUONR | Assignment number | ORDNR_V | CHAR | 18 | ZUONR | ||||
VGTYP | Document category of preceding SD document | VBTYP_V | CHAR | 1 | VBTYP | ||||
KALSM_CH | Search procedure for batch determination | KALSMA_CH | CHAR | 6 | T683 | KALSM | |||
AGRZR | Accrual period for order-related billing docs.to be accrued | AGRZR | NUMC | 2 | NUM2 | ||||
AUFNR | Order Number | AUFNR | CHAR | 12 | AUFK | ALPHA | AUFNR | ANR | |
QMNUM | Notification No | QMNUM | CHAR | 12 | QMEL | ALPHA | QMNUM | IQM | |
VBELN_GRP | Mster contract number | VBELN_GRP | CHAR | 10 | Assigned to domain | ALPHA | VBELN | ||
SCHEME_GRP | Referencing requirement: Procedure | SCHEME_GRP | CHAR | 4 | TVGRPS | SCHEME_GRP | |||
ABRUF_PART | Check partner authorizations | ABRUF_PART | CHAR | 1 | ABRUF_PART | ||||
ABHOD | Pick up date | ABHOD | DATS | 8 | DATUM | ||||
ABHOV | Pick up time | ABHOZ | TIMS | 6 | UZEIT | ||||
ABHOB | Pick up time | ABHOZ | TIMS | 6 | UZEIT | ||||
RPLNR | Number of payment card plan type | RPLNR | CHAR | 10 | FPLA | FPLNR | |||
VZEIT | Proposed schedule line time (local with ref. to sales org.) | EZEIT_VBAK | TIMS | 6 | TIME_SAORG | ||||
STCEG_L | Tax Destination Country | LAND1TX | CHAR | 3 | T005 | LAND1 | LND | ||
LANDTX | Tax departure country | LANDTX | CHAR | 3 | T005 | LAND1 | LND | ||
XEGDR | Indicator: Triangular deal within the EU ? | XEGDR | CHAR | 1 | XFELD | ||||
ENQUEUE_GRP | Block master contr. until all lower level contracts updated | ENQUEUE_GRP | CHAR | 1 | ENQUEUE_GRP | ||||
DAT_FZAU | Cml delivery order qty date | DAT_FZAU | DATS | 8 | DATUM | ||||
FMBDAT | Material Staging/Availability Date | MBDAT | DATS | 8 | DATUM | ||||
VSNMR_V | Sales document version number | VSNMR_V | CHAR | 12 | VSNMR | ||||
HANDLE | International unique key for VBAK-VBELN | TSEGGUID_VBAK | CHAR | 22 | SYSUUID_22 | ||||
PROLI | Dangerous Goods Management Profile in SD Documents | ADGE_PROLI | CHAR | 3 | TDGC5 | ADGD_PROLI | TDGC5_PROLI_01 | ||
CONT_DG | Indicator: Document contains dangerous goods | ADGE_NCDG | CHAR | 1 | X |
Key field | Non-key field |
How do I retrieve data from SAP table VVBAK using ABAP code
The following ABAP code Example will allow you to do a basic selection on VVBAK to SELECT all data from the tableDATA: WA_VVBAK TYPE VVBAK.
SELECT SINGLE *
FROM VVBAK
INTO CORRESPONDING FIELDS OF WA_VVBAK
WHERE...
How to access SAP table VVBAK
Within an ECC or HANA version of SAP you can also view further information about VVBAK 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