VBDKA SAP (Document Header View for Inquiry,Quotation,Order) Structure details
Description: Document Header View for Inquiry,Quotation,Order
Structure field list including key, data, relationships and ABAP select examples
VBDKA is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Document Header View for Inquiry,Quotation,Order" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_VBDKA TYPE VBDKA.
The VBDKA table consists of various fields, each holding specific information or linking keys about Document Header View for Inquiry,Quotation,Order data available in SAP. These include ADRNR (Address number), ADRNP (Person number), ADDRESS_TYPE (Address type (1=Organization, 2=Person, 3=Contact person)), NAME1 (Name 1).. 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:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP VBDKA structure 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 |
ANRED | Title | ANRED | CHAR | 15 | TEXT15 | ||||
ADRNR | Address number | AD_ADDRNUM | CHAR | 10 | Assigned to domain | ALPHA | AD_ADDRNUM | ADR | |
ADRNP | Person number | AD_PERSNUM | CHAR | 10 | Assigned to domain | ALPHA | AD_PERSNUM | CDT | ADDRESS |
ADDRESS_TYPE | Address type (1=Organization, 2=Person, 3=Contact person) | AD_ADRTYPE | CHAR | 1 | AD_ADRTYPE | ||||
NAME1 | Name 1 | NAME1_GP | CHAR | 35 | NAME | ||||
NAME2 | Name 2 | NAME2_GP | CHAR | 35 | NAME | ||||
NAME3 | Name 3 | NAME3_GP | CHAR | 35 | NAME | ||||
NAME4 | Name 4 | NAME4_GP | CHAR | 35 | NAME | ||||
STRAS | House number and street | STRAS_GP | CHAR | 35 | TEXT35 | ||||
PFACH | PO Box | PFACH | CHAR | 10 | PFACH | ||||
PFORT | PO Box city | PFORT_GP | CHAR | 35 | TEXT35 | ||||
PSTL2 | P.O. Box Postal Code | PSTL2 | CHAR | 10 | PSTLZ | ||||
LAND1 | Country Key | LAND1 | CHAR | 3 | T005 | LAND1 | LND | ||
SPRAS | Language Key | SPRAS | LANG | 1 | T002 | ISOLA | SPRAS | SPR | H_T002 |
PSTLZ | Postal Code | PSTLZ | CHAR | 10 | PSTLZ | ||||
ORT01 | City | ORT01_GP | CHAR | 35 | TEXT35 | ||||
ORT02 | District | ORT02_GP | CHAR | 35 | TEXT35 | ||||
REGIO | STATE (State, Province, County) | REGIO | CHAR | 3 | T005S | REGIO | |||
KUNNR | Customer Numbers | KUNNR | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | KUN | C_KUNNR |
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 | |
SPRAS_VKO | Language Key | SPRAS | LANG | 1 | T002 | ISOLA | SPRAS | SPR | H_T002 |
VKBUR | Sales Office | VKBUR | CHAR | 4 | TVBUR | VKBUR | VKB | ||
SPRAS_VBUR | Language Key | SPRAS | LANG | 1 | T002 | ISOLA | SPRAS | SPR | H_T002 |
VBELN | Sales and Distribution Document Number | VBELN | CHAR | 10 | VBUK | ALPHA | VBELN | AUN | |
AUDAT | Document Date (Date Received/Sent) | AUDAT | DATS | 8 | DATUM | ||||
BSTNK | Customer purchase order number | BSTNK | CHAR | 20 | BSTNK | ||||
BSTDK | Customer purchase order date | BSTDK | DATS | 8 | DATUM | ||||
BSARK | Customer purchase order type | BSARK | CHAR | 4 | Assigned to domain | BSARK | |||
BSARK_BEZ | Description of purchase order type | BSARK_BEZ | CHAR | 20 | TEXT20 | ||||
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 | ||||
VBELN_VANG | Preceding sales and distribution document | VBELN_VON | CHAR | 10 | VBUK | ALPHA | VBELN | AUF | |
VBTYP_VANG | Document category of preceding SD document | VBTYP_V | CHAR | 1 | VBTYP | ||||
AUDAT_VANG | Quotation Date | AUDAT_VANG | DATS | 8 | DATUM | ||||
HERKL | Three-digit character field for IDocs | CHAR03 | CHAR | 3 | CHAR3 | ||||
LLAND | Country of Destination | LLAND | CHAR | 3 | T005 | LAND1 | VLL | ||
ALAND | Departure country (country from which the goods are sent) | ALAND | CHAR | 3 | T005 | LAND1 | VAL | ||
SLAND | Sending country for processing address | SLAND | CHAR | 3 | T005 | LAND1 | |||
ANRED_WE | Title | ANRED | CHAR | 15 | TEXT15 | ||||
ADRNR_WE | Address number | AD_ADDRNUM | CHAR | 10 | Assigned to domain | ALPHA | AD_ADDRNUM | ADR | |
ADRNP_WE | Person number | AD_PERSNUM | CHAR | 10 | Assigned to domain | ALPHA | AD_PERSNUM | CDT | ADDRESS |
ADDRESS_TYPE_WE | Address type (1=Organization, 2=Person, 3=Contact person) | AD_ADRTYPE | CHAR | 1 | AD_ADRTYPE | ||||
NAME1_WE | Name 1 | NAME1_GP | CHAR | 35 | NAME | ||||
NAME2_WE | Name 2 | NAME2_GP | CHAR | 35 | NAME | ||||
NAME3_WE | Name 3 | NAME3_GP | CHAR | 35 | NAME | ||||
NAME4_WE | Name 4 | NAME4_GP | CHAR | 35 | NAME | ||||
STRAS_WE | House number and street | STRAS_GP | CHAR | 35 | TEXT35 | ||||
PFACH_WE | PO Box | PFACH | CHAR | 10 | PFACH | ||||
PFORT_WE | PO Box city | PFORT_GP | CHAR | 35 | TEXT35 | ||||
PSTL2_WE | P.O. Box Postal Code | PSTL2 | CHAR | 10 | PSTLZ | ||||
LAND1_WE | Country Key | LAND1 | CHAR | 3 | T005 | LAND1 | LND | ||
SPRAS_WE | Language Key | SPRAS | LANG | 1 | T002 | ISOLA | SPRAS | SPR | H_T002 |
PSTLZ_WE | Postal Code | PSTLZ | CHAR | 10 | PSTLZ | ||||
ORT01_WE | City | ORT01_GP | CHAR | 35 | TEXT35 | ||||
ORT02_WE | District | ORT02_GP | CHAR | 35 | TEXT35 | ||||
REGIO_WE | STATE (State, Province, County) | REGIO | CHAR | 3 | T005S | REGIO | |||
VSBED | Shipping Conditions | VSBED | CHAR | 2 | TVSB | VSBED | |||
VSBED_BEZ | Description of the shipping conditions | VSBED_BEZ | CHAR | 20 | TEXT20 | ||||
BUKRS_VF | Company code to be billed | BUKRS_VF | CHAR | 4 | T001 | BUKRS | BUK | ||
INCO1 | Incoterms (Part 1) | INCO1 | CHAR | 3 | TINC | INCO1 | |||
INCO2 | Incoterms (Part 2) | INCO2 | CHAR | 28 | INCO2 | ||||
INCO1_BEZ | Incoterm description | INCO1_BEZ | CHAR | 30 | TEXT30 | ||||
ZTERM | Terms of Payment Key | DZTERM | CHAR | 4 | ZTERM | ||||
ZTERM_BEZ | Description of terms of payment | DZTERM_BEZ | CHAR | 30 | TEXT30 | ||||
ZTERM_TX1 | Text (80 Characters) | TEXT80 | CHAR | 80 | TEXT80UEB | ||||
ZTERM_TX2 | Text (80 Characters) | TEXT80 | CHAR | 80 | TEXT80UEB | ||||
ZTERM_TX3 | Text (80 Characters) | TEXT80 | CHAR | 80 | TEXT80UEB | ||||
ZTERM_TX4 | Text (80 Characters) | TEXT80 | CHAR | 80 | TEXT80UEB | ||||
LFDAT | Delivery date | LFDAT_EXT | CHAR | 10 | CHAR10 | ||||
DATBEZ | Description of the date format (day, week, month) | DATBEZ | CHAR | 8 | TEXT8 | ||||
BRGEW | Gross weight | BRGEW_15 | QUAN | 15(3) | MENG15 | ||||
NTGEW | Net weight | NTGEW_15 | QUAN | 15(3) | MENG15 | ||||
GEWEI | Weight Unit | GEWEI | UNIT | 3 | T006 | CUNIT | MEINS | ||
VOLUM | Volume | VOLUM_15 | QUAN | 15(3) | MENG15 | ||||
VOLEH | Volume unit | VOLEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
WAERS | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
WAERK | SD Document Currency | WAERK | CUKY | 5 | TCURC | WAERS | FWS | ||
KURST | Exchange Rate Type | KURST | CHAR | 4 | TCURV | KURST | KUT | ||
KURRF | Exchange rate for FI postings | KURRF | DEC | 9(5) | KURRF | ||||
KURRF_DAT | Translation Date | WWERT_D | DATS | 8 | DATUM | ||||
NETWR | Net Value of the Sales Order in Document Currency | NETWR_AK | CURR | 15(2) | WERTV8 | ||||
TDNAME | Name | TDOBNAME | CHAR | 70 | TDOBNAME | ||||
KALSM | Procedure (Pricing, Output Control, Acct. Det., Costing,...) | KALSM_D | CHAR | 6 | T683 | KALSM | |||
KNUMV | Number of the document condition | KNUMV | CHAR | 10 | KNUMV | ||||
KNUMA | Agreement (various conditions grouped together) | KNUMA | CHAR | 10 | KONA | ALPHA | KNUMA | VMBO | |
VBTYP | SD document category | VBTYP | CHAR | 1 | VBTYP | ||||
ANGDT | Quotation Validity Date | ANGDT | DATS | 8 | DATUM | ||||
BNDDT | Date until which bid/quotation is binding (valid-to date) | BNDDT | DATS | 8 | DATUM | ||||
GUEBG | Valid-from date (outline agreements, product proposals) | GUEBG | DATS | 8 | DATUM | ||||
GUEEN | Valid-to date (outline agreements, product proposals) | GUEEN | DATS | 8 | DATUM | ||||
KDGRP | Customer group | KDGRP | CHAR | 2 | Assigned to domain | KDGRP | VKD | ||
KDGRP_BEZ | Description of customer group | KDGRP_BEZ | CHAR | 20 | TEXT20 | ||||
BZIRK | Sales district | BZIRK | CHAR | 6 | Assigned to domain | BZIRK | BZI | ||
BZIRK_BEZ | Name of the district | BZTXT | CHAR | 20 | TEXT20 | ||||
VALTG | Additional value days | VALTG | NUMC | 2 | TAGE2 | ||||
VALDT | Fixed value date | VALDT | DATS | 8 | DATUM | ||||
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 | ||||
AUART | Sales Document Type | AUART | CHAR | 4 | Assigned to domain | AUART | AUART | AAT | |
AUART_BEZ | Description of sales order type | AUART_BEZ | CHAR | 20 | TEXT20 | ||||
AUGRU | Order reason (reason for the business transaction) | AUGRU | CHAR | 3 | Assigned to domain | AUGRU | |||
AUGRU_BEZ | Description of sales order reason | AUGRU_BEZ | CHAR | 40 | TEXT40 | ||||
GWLDT | Warranty Date | GWLDT | DATS | 8 | DATUM | ||||
SUBMI | Collective Number | SUBMI | CHAR | 10 | CHAR10 | ||||
LIFSK | Delivery block (document header) | LIFSK | CHAR | 2 | Assigned to domain | LIFSP | |||
FAKSK | Billing block in SD document | FAKSK | CHAR | 2 | Assigned to domain | FAKSP | |||
VKGRP | Sales Group | VKGRP | CHAR | 3 | Assigned to domain | VKGRP | VKG | ||
VKGRP_BEZ | Description of Sales Group | VKGRP_BEZ | CHAR | 20 | TEXT20 | ||||
KOSTL | Cost Center | KOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KOS | |
GSBER | Business Area | GSBER | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
GSKST | Business area from cost center | GSKST | CHAR | 4 | Assigned to domain | GSBER | |||
AUTLF | Complete delivery defined for each sales order? | AUTLF | CHAR | 1 | XFELD | ||||
P_SPLIT | Split terms of payment | P_SPLIT | CHAR | 1 | CHAR1 | ||||
TEXT | Char 80 | CHAR80 | CHAR | 80 | CHAR80 | ||||
VBKLT | SD document indicator | VBKLT | CHAR | 1 | VBKLT | ||||
DELCO | Agreed delivery time | DELCO | CHAR | 3 | DELCO | ||||
DELCO_BEZ | Description | BEZEI20 | CHAR | 20 | TEXT20 | ||||
BSTKD | Customer purchase order number | BSTKD | CHAR | 35 | BSTKD | ||||
BSTKD_E | Ship-to Party's Purchase Order Number | BSTKD_E | CHAR | 35 | BSTKD | ||||
BSTDK_E | Ship-to party's PO date | BSTDK_E | DATS | 8 | DATUM | ||||
BSARK_E | Ship-to party purchase order type | BSARK_E | CHAR | 4 | Assigned to domain | BSARK | |||
BSARK_BEZE | Description of purchase order type | BSARK_BEZ | CHAR | 20 | TEXT20 | ||||
IHREZ_E | Ship-to party character | IHREZ_E | CHAR | 12 | TEXT12 | ||||
MSR_ID | Process Identification Number | MSR_PROCESS_ID | CHAR | 10 | ALPHA | MSR_PROCESS_ID | |||
DUMMY | Dummy function in length 1 | DUMMY | CHAR | 1 | DUMMY |
Key field | Non-key field |
How do I retrieve data from SAP structure VBDKA using ABAP code?
As VBDKA is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on VBDKA as there is no data to select.How to access SAP table VBDKA
Within an ECC or HANA version of SAP you can also view further information about VBDKA 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