VBKD is a standard Sales Transparent Table in SAP SD application, which stores Sales Document: Business Data data. On this page, you can view the Table Structure, Columns(Fields), links to SAP Documentation, Wiki & Help Pages, Q&A, similar/related TCodes, Tables, FMs, ABAP Reports, BW Datasources, and Authorization Objects for VBKD. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition.
- SD (Sales and Distribution)
- SD-SLS (Sales)
- VBKD - Sales Document: Business Data
- SD-SLS (Sales)
VBKD — Table Structure, Fields(Columns) and Definitions
Position | Column Name | Description | Data Element | Primary Key | Data Type | Length | Check Table |
---|---|---|---|---|---|---|---|
1 | MANDT | Client | MANDT | X | CLNT | 3 | T000 |
2 | VBELN | Sales Document | VBELN | X | CHAR | 10 | |
3 | POSNR | Item | POSNR | X | NUMC | 6 | |
4 | KONDA | Updated information in related user data field | KONDA | CHAR | 2 | T188 | |
5 | KDGRP | Customer group | KDGRP | CHAR | 2 | T151 | |
6 | BZIRK | Sales district | BZIRK | CHAR | 6 | T171 | |
7 | PLTYP | Benefit plan type | PLTYP | CHAR | 2 | T189 | |
8 | INCO1 | Incoterms | INCO1 | CHAR | 3 | TINC | |
9 | INCO2 | Incoterms 2 | INCO2 | CHAR | 28 | ||
10 | KZAZU | Order Combination Indicator | KZAZU_D | CHAR | 1 | ||
11 | PERFK | Invoice dates (calendar identification) | PERFK | CHAR | 2 | TFACD | |
12 | PERRL | Updated information in related user data field | PERRL | CHAR | 2 | TFACD | |
13 | MRNKZ | Updated information in related user data field | MRNKZ | CHAR | 1 | ||
14 | KURRF | Exch.rate-acct. | KURRF | DEC | 9 | ||
15 | VALTG | Updated information in related user data field | VALTG | NUMC | 2 | ||
16 | VALDT | License Validity | VALDT | DATS | 8 | ||
17 | ZTERM | Payt terms | DZTERM | CHAR | 4 | ||
18 | ZLSCH | Pymt method | SCHZW_BSEG | CHAR | 1 | T042Z | |
19 | KTGRD | AcctAssgGr | KTGRD | CHAR | 2 | TVKT | |
20 | KURSK | Exchange Rate | KURSK | DEC | 9 | ||
21 | PRSDT | Pricing date | PRSDT | DATS | 8 | ||
22 | FKDAT | Billing Date | FKDAT | DATS | 8 | ||
23 | FBUDA | Serv.rendered | FBUDA | DATS | 8 | ||
24 | GJAHR | Fiscal Year | GJAHR | NUMC | 4 | ||
25 | POPER | Posting period | POPER | NUMC | 3 | ||
26 | STCUR | Exch.rate stats | STCUR | DEC | 9 | ||
27 | MSCHL | Dunning key | MSCHL | CHAR | 1 | T040 | |
28 | MANSP | Dunn. block | MANSP | CHAR | 1 | T040S | |
29 | FPLNR | Billing plan number / invoicing plan number | FPLNR | CHAR | 10 | FPLA | |
30 | WAKTION | Promotion | WAKTION | CHAR | 10 | WAKH | |
31 | ABSSC | Payment guarantee procedure | ABSSCHE_CM | CHAR | 6 | T691M | |
32 | LCNUM | Financial doc. processing: Internal financial doc. number | LCNUM | CHAR | 10 | ||
33 | J_1AFITP | Tax type | J_1AFITP_D | CHAR | 2 | J_1AFITP | |
34 | J_1ARFZ | Single-Character Flag | J_1ARFZVAT | CHAR | 1 | J_1ARFZ | |
35 | J_1AREGIO | Region (State | REGIO | CHAR | 3 | T005S | |
36 | J_1AGICD | Single-Character Flag | J_1AGICD_D | CHAR | 2 | J_1AGICD | |
37 | J_1ADTYP | Single-Character Flag | J_1ADTYP_D | CHAR | 2 | J_1ADTYP | |
38 | J_1ATXREL | Single-Character Flag | J_1ATXREL_ | CHAR | 10 | J_1ATXREL | |
39 | ABTNR | Department number | ABTNR | CHAR | 4 | TSAB | |
40 | EMPST | Receiving point | EMPST | CHAR | 25 | ||
41 | BSTKD | Updated information in related user data field | BSTKD | CHAR | 35 | ||
42 | BSTDK | Customer purchase order date | BSTDK | DATS | 8 | ||
43 | BSARK | Customer purchase order type | BSARK | CHAR | 4 | T176 | |
44 | IHREZ | Your Reference | IHREZ | CHAR | 12 | ||
45 | BSTKD_E | Updated information in related user data field | BSTKD_E | CHAR | 35 | ||
46 | BSTDK_E | Updated information in related user data field | BSTDK_E | DATS | 8 | ||
47 | BSARK_E | Single-Character Flag | BSARK_E | CHAR | 4 | T176 | |
48 | IHREZ_E | Single-Character Flag | IHREZ_E | CHAR | 12 | ||
49 | POSEX_E | Updated information in related user data field | POSEX_E | CHAR | 6 | ||
50 | KURSK_DAT | Translatn Date | WWERT_D | DATS | 8 | ||
51 | KURRF_DAT | Translation date | WWERT_D | DATS | 8 | ||
52 | KDKG1 | Single-Character Flag | KDKG1 | CHAR | 2 | TVKGG | |
53 | KDKG2 | Single-Character Flag | KDKG2 | CHAR | 2 | TVKGG | |
54 | KDKG3 | Single-Character Flag | KDKG3 | CHAR | 2 | TVKGG | |
55 | KDKG4 | Single-Character Flag | KDKG4 | CHAR | 2 | TVKGG | |
56 | KDKG5 | Single-Character Flag | KDKG5 | CHAR | 2 | TVKGG | |
57 | WKWAE | Single-Character Flag | WKWAE | CUKY | 5 | TCURC | |
58 | WKKUR | Single-Character Flag | WKKUR | DEC | 9 | ||
59 | AKWAE | Currency key for letter-of-credit procg in foreign trade | AKWAE | CUKY | 5 | TCURC | |
60 | AKKUR | Exchange rate for letter-of-credit procg in foreign trade | AKKUR | DEC | 9 | ||
61 | AKPRZ | Depreciation percentage for financial document processing | AKPRZ | DEC | 5 | ||
62 | J_1AINDXP | Updated information in related user data field | J_1AINDXP | CHAR | 5 | J_1AINFT20 | |
63 | J_1AIDATEP | Updated information in related user data field | J_1AIDATES | DATS | 8 | ||
64 | BSTKD_M | Single-Character Flag | BSTKD_M | CHAR | 35 | ||
65 | DELCO | Checkbox | DELCO | CHAR | 3 | TVDC | |
66 | FFPRF | Single-Character Flag | AD01PROFNR | CHAR | 8 | AD01C_PROF | |
67 | BEMOT | Accounting Indicator | BEMOT | CHAR | 2 | TBMOT | |
68 | FAKTF | Single-Character Flag | FAKTF | CHAR | 2 | ||
69 | RRREL | Revenue recognition category | RR_RELTYP | CHAR | 1 | ||
70 | ACDATV | Single-Character Flag | RR_ACDATV | CHAR | 1 | ||
71 | VSART | Shipping type | VSARTTR | CHAR | 2 | T173 | |
72 | TRATY | Means-of-Transport Type | TRATY | CHAR | 4 | TVTY | |
73 | TRMTYP | Means of Transport | TRMTYP | CHAR | 40 | MARA | |
74 | SDABW | Special processing indicator | SDABW | CHAR | 4 | TVSAK | |
75 | WMINR | Catalog | WMINR | CHAR | 10 | WWMI | |
76 | FKBER | Functional Area | FKBER | CHAR | 16 | TFKB | |
77 | PODKZ | Updated information in related user data field | PODKZ | CHAR | 1 | ||
78 | CAMPAIGN | Updated information in related user data field | CGPL_GUID16_R3 | RAW | 16 | ||
79 | VKONT | Contract Account | CORR_VKONT_KK | CHAR | 12 | ||
80 | DPBP_REF_FPLNR | Billing plan number / invoicing plan number | FPLNR | CHAR | 10 | ||
81 | DPBP_REF_FPLTR | Item for billing plan/invoice plan/payment cards | FPLTR | NUMC | 6 | ||
82 | REVSP | Revenue Distribution Type | RR_REVSP | CHAR | 1 | ||
83 | REVEVTYP | Revenue Event Type (Customizing) | RR_REVEVTYP_CUST | CHAR | 1 | ||
84 | FARR_RELTYPE | Relevance Type for Revenue Accounting | FARR_RELTYPE | CHAR | 10 | ||
85 | VTREF | FI-CA: Reference Specifications from Contract | CORR_VTREF_KK | CHAR | 20 | ||
86 | _DATAAGING | Data Filter Value for Data Aging | DATA_TEMPERATURE | DATS | 8 | ||
87 | .INCLUDE | 0 | |||||
88 | J_1TPBUPL | Branch Code | BCODE | CHAR | 5 | ||
89 | .INCLUDE | 0 | |||||
90 | INCOV | Incoterms Version | INCOV | CHAR | 4 | TINCV | |
91 | INCO2_L | Incoterms Location 1 | INCO2_L | CHAR | 70 | ||
92 | INCO3_L | Incoterms Location 2 | INCO3_L | CHAR | 70 | ||
93 | .INCLU--AP | 0 | |||||
94 | PACKNO | Package number | PACKNO | NUMC | 10 | ESLH | |
95 | .INCLU--AP | 0 | |||||
96 | PEROP_BEG | Billing Period of Performance Start Date | FM_PEROP_SD_LOW | DATS | 8 | ||
97 | PEROP_END | Billing Period of Performance End Date | FM_PEROP_SD_HIGH | DATS | 8 | ||
98 | .INCLU--AP | 0 | |||||
99 | STCODE | LST CST applicability code | J_1ISTCODE | CHAR | 3 | * | |
100 | FORMC1 | Form Type | J_1IFORTYP | CHAR | 3 | * | |
101 | FORMC2 | Form Type | J_1IFORTYP | CHAR | 3 | * | |
102 | STEUC | Checkbox | STEUC | CHAR | 16 | ||
103 | .INCLU--AP | 0 | |||||
104 | OIC_TIME | Single-Character Flag | OIC_TIME | TIMS | 6 | ||
105 | OITITLE | Location of title transfer for Incoterms purposes | OIC_TITLE | CHAR | 1 | ||
106 | OIPTRM1 | Payment terms for invoice cycle X | OIA_PTRM | CHAR | 4 | ||
107 | OIPTRM2 | Payment terms for invoice cycle X | OIA_PTRM | CHAR | 4 | ||
108 | OIPTRM3 | Payment terms for invoice cycle X | OIA_PTRM | CHAR | 4 | ||
109 | OIPTRM4 | Payment terms for invoice cycle X | OIA_PTRM | CHAR | 4 | ||
110 | OIPTRM5 | Payment terms for invoice cycle X | OIA_PTRM | CHAR | 4 | ||
111 | OIPTRM6 | Payment terms for invoice cycle X | OIA_PTRM | CHAR | 4 | ||
112 | OIPTRM7 | Payment terms for invoice cycle X | OIA_PTRM | CHAR | 4 | ||
113 | OIPTRM8 | Payment terms for invoice cycle X | OIA_PTRM | CHAR | 4 | ||
114 | OIPTRM9 | Payment terms for invoice cycle X | OIA_PTRM | CHAR | 4 | ||
115 | OIPFLIC | Updated information in related user data field | OIH_PFLIC | CHAR | 2 | TPAR | |
116 | .INCLU--AP | 0 | |||||
117 | COMPREAS | Abbreviation for Complaints Reason | CMP_COMPREAS_COPY | CHAR | 4 | ||
118 | .INCLU--AP | 0 | |||||
119 | .INCLUDE | 0 | |||||
120 | MNDID | SEPA Mandate: Unique Reference to Mandate per Creditor | SEPA_MNDID | CHAR | 35 | ||
121 | PAY_TYPE | Type of payroll, R = regular or S = special | SEPA_PAY_TYPE | CHAR | 1 | ||
122 | SEPON | Single-Character Flag | SD_SEPA_FLAG | CHAR | 1 | ||
123 | MNDVG | SEPA-Relevance | SD_SEPA_FLAG | CHAR | 1 |
Most searched SAP Sales and Distribution Tables
- Sales Order Tables
- Plant Tables
- Document Type Tables
- Delivery Tables
- Billing Document Tables
- Pricing Tables
- Sales Organization Tables
- Outbound Delivery Tables
- Pricing Conditions Tables
- Contract Tables
- Internal Order Tables
- Item Category Tables
- Pricing Procedure Tables
- Condition Types Tables
- Billing Tables
- Customer Group Tables
- Output Type Tables
- Condition Record Tables
- Price List Tables
- Order Type Tables
- Info Record Tables
- Sales Order Type Tables