VBRK is a standard Billing Transparent Table in SAP SD application, which stores Billing Document: Header Data data. Below you can view the Table Structure, columns(fields), SAP Wiki pages, discussion threads, related TCodes, FMs, ABAP Reports, BW Datasources, and Authorization Objects for VBRK. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition.
VBRK — Meta Data
Description: | Billing Document: Header Data |
Main Category: | SD |
Sub Category: | Billing |
Table type: | Transparent Table (TRANSP) |
VBRK — Table Structure, Fields(Columns) and Definitions
Position | Column Name | Description | Primary Key | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
1 | MANDT | Client | X | CLNT | 3 | T000 |
2 | VBELN | Sales Document | X | CHAR | 10 | |
3 | FKART | Billing Type | CHAR | 4 | TVFK | |
4 | FKTYP | BillingCategory | CHAR | 1 | ||
5 | VBTYP | Document cat. | CHAR | 4 | ||
6 | WAERK | Doc. Currency | CUKY | 5 | TCURC | |
7 | VKORG | Sales Org. | CHAR | 4 | TVKO | |
8 | VTWEG | Distr. Channel | CHAR | 2 | TVTW | |
9 | KALSM | Procedure (Pricing | CHAR | 6 | T683 | |
10 | KNUMV | Number of the document condition | CHAR | 10 | ||
11 | VSBED | Shipping Cond. | CHAR | 2 | TVSB | |
12 | FKDAT | Billing Date | DATS | 8 | ||
13 | BELNR | Document Number | CHAR | 10 | ||
14 | GJAHR | Fiscal Year | NUMC | 4 | ||
15 | POPER | Posting period | NUMC | 3 | ||
16 | KONDA | Updated information in related user data field | CHAR | 2 | T188 | |
17 | KDGRP | Customer group | CHAR | 2 | T151 | |
18 | BZIRK | Sales district | CHAR | 6 | T171 | |
19 | PLTYP | Benefit plan type | CHAR | 2 | T189 | |
20 | INCO1 | Incoterms | CHAR | 3 | TINC | |
21 | INCO2 | Incoterms 2 | CHAR | 28 | ||
22 | RFBSK | Updated information in related user data field | CHAR | 1 | ||
23 | MRNKZ | Updated information in related user data field | CHAR | 1 | ||
24 | KURRF | Exch.rate-acct. | DEC | 9 | ||
25 | CPKUR | ID:Exchange rate setting (no new rate determ.in bill.doc.) | CHAR | 1 | ||
26 | VALTG | Updated information in related user data field | NUMC | 2 | ||
27 | VALDT | License Validity | DATS | 8 | ||
28 | ZTERM | Payt terms | CHAR | 4 | ||
29 | ZLSCH | Pymt method | CHAR | 1 | T042Z | |
30 | KTGRD | AcctAssgGr | CHAR | 2 | TVKT | |
31 | LAND1 | Country | CHAR | 3 | T005 | |
32 | REGIO | Region (State | CHAR | 3 | T005S | |
33 | COUNC | County code | CHAR | 3 | T005E | |
34 | CITYC | City Code | CHAR | 4 | T005G | |
35 | BUKRS | Company Code | CHAR | 4 | T001 | |
36 | TAXK1 | Alternative tax classification | CHAR | 1 | ||
37 | TAXK2 | Tax classification 2 for customer | CHAR | 1 | ||
38 | TAXK3 | Tax classification 3 for customer | CHAR | 1 | ||
39 | TAXK4 | Tax Classification 4 Customer | CHAR | 1 | ||
40 | TAXK5 | Tax classification 5 for customer | CHAR | 1 | ||
41 | TAXK6 | Tax classification 6 for customer | CHAR | 1 | ||
42 | TAXK7 | Tax classification 7 for customer | CHAR | 1 | ||
43 | TAXK8 | Tax classification 8 for customer | CHAR | 1 | ||
44 | TAXK9 | Tax classification 9 for customer | CHAR | 1 | ||
45 | NETWR | Net value | CURR | 15 | ||
46 | ZUKRI | Combination criteria in the billing document | CHAR | 40 | ||
47 | ERNAM | Created by | CHAR | 12 | ||
48 | ERZET | Time | TIMS | 6 | ||
49 | ERDAT | Created on | DATS | 8 | ||
50 | STAFO | Update group for statistics update | CHAR | 6 | ||
51 | KUNRG | Payer | CHAR | 10 | KNA1 | |
52 | KUNAG | Sold-to party | CHAR | 10 | KNA1 | |
53 | MABER | Dunning Area | CHAR | 2 | T047M | |
54 | STWAE | Stats Currency | CUKY | 5 | TCURC | |
55 | STCEG | VAT registration number | CHAR | 20 | ||
56 | AEDAT | Changed on | DATS | 8 | ||
57 | SFAKN | Cancelled billing document number | CHAR | 10 | VBRK | |
58 | KNUMA | Agreement (various conditions grouped together) | CHAR | 10 | KONA | |
59 | FKART_RL | Invoice list type | CHAR | 4 | TVFK | |
60 | FKDAT_RL | Billing date for the invoice list | DATS | 8 | ||
61 | KURST | Exch. Rate Type | CHAR | 4 | TCURV | |
62 | MSCHL | Dunning key | CHAR | 1 | T040 | |
63 | MANSP | Dunn. block | CHAR | 1 | T040S | |
64 | SPART | Division | CHAR | 2 | TSPA | |
65 | KKBER | Cred.contr.area | CHAR | 4 | T014 | |
66 | KNKLI | Customer's account number with credit limit reference | CHAR | 10 | KNA1 | |
67 | CMWAE | Currency key of credit control area | CUKY | 5 | TCURC | |
68 | CMKUF | Data Element Length 11 | DEC | 9 | ||
69 | HITYP_PR | Hierarchy type for pricing | CHAR | 1 | THIT | |
70 | BSTNK_VF | Customer purchase order number | CHAR | 35 | ||
71 | VBUND | Trading Partner | CHAR | 6 | T880 | |
72 | FKART_AB | Accrual billing type | CHAR | 4 | ||
73 | KAPPL | Application | CHAR | 2 | ||
74 | LANDTX | Tax departure country | CHAR | 3 | ||
75 | STCEG_H | Origin of sales tax ID number | CHAR | 1 | ||
76 | STCEG_L | Country of Sales Tax ID Number | CHAR | 3 | ||
77 | XBLNR | Reference | CHAR | 16 | ||
78 | ZUONR | Assignment | CHAR | 18 | ||
79 | MWSBK | Tax amount in document currency | CURR | 13 | ||
80 | LOGSYS | Logical system | CHAR | 10 | ||
81 | FKSTO | Billing document is cancelled | CHAR | 1 | ||
82 | XEGDR | Indicator: Triangular deal within the EU ? | CHAR | 1 | ||
83 | RPLNR | Number of payment card plan type | CHAR | 10 | FPLA | |
84 | J_1AFITP | Tax type | CHAR | 2 | J_1AFITP | |
85 | KURRF_DAT | Translation date | DATS | 8 | ||
86 | KIDNO | Payment Ref. | CHAR | 30 | ||
87 | BVTYP | Partner bank type | CHAR | 4 | ||
88 | NUMPG | Number of pages of invoice | NUMC | 3 | ||
89 | BUPLA | Business Place | CHAR | 4 | J_1BBRANCH | |
90 | VKONT | Contract Account | CHAR | 12 | ||
91 | FKK_DOCSTAT | Additional Status Transfer to Fin. Accounting (Res. RFBSK) | CHAR | 1 | ||
92 | NRZAS | Character Field of Length 12 | CHAR | 12 | ||
93 | SPE_BILLING_IND | EWM Billing Indicator | CHAR | 1 | ||
94 | VTREF | FI-CA: Reference Specifications from Contract | CHAR | 20 | ||
95 | FK_SOURCE_SYS | Source System | CHAR | 10 | ||
96 | FKTYP_CRM | Billing Category in CRM | CHAR | 1 | ||
97 | STGRD | Reason for Reversal | CHAR | 2 | T041C | |
98 | CHANGED_ON | External Date for BAPI Interface | DEC | 21 | ||
99 | EXPKZ | Export indicator | CHAR | 1 | ||
100 | EXNUM | Number of foreign trade data in MM and SD documents | CHAR | 10 | ||
101 | AKWAE | Currency key for letter-of-credit procg in foreign trade | CUKY | 5 | ||
102 | AKKUR | Exchange rate for letter-of-credit procg in foreign trade | DEC | 9 | ||
103 | LCNUM | Financial doc. processing: Internal financial doc. number | CHAR | 10 | ||
104 | _DATAAGING | Data Filter Value for Data Aging | DATS | 8 | ||
105 | .INCLUDE | 0 | ||||
106 | BUCHK | Posting Status | CHAR | 1 | ||
107 | GBSTK | Overall status | CHAR | 1 | ||
108 | RELIK | Invoice list status of billing document | CHAR | 1 | ||
109 | UVALS | Total incompletion status of all items in general | CHAR | 1 | ||
110 | UVPRS | Pricing | CHAR | 1 | ||
111 | FKSAK | Billing status (order-related billing document) | CHAR | 1 | ||
112 | FKARA | Proposed billing type for an order-related billing document | CHAR | 4 | ||
113 | VF_STATUS | Single-Character Flag | CHAR | 1 | ||
114 | VF_TODO | Single-Character Flag | CHAR | 1 | ||
115 | BDR_STATUS | CHAR | 1 | |||
116 | BDR_REF | CHAR | 10 | |||
117 | BDR_REF_LOGSYS | CHAR | 10 | |||
118 | BDR_REF_VBTYP | CHAR | 4 | |||
119 | PBD_STATUS | CHAR | 1 | |||
120 | ABSTK | Rejection stat. | CHAR | 1 | ||
121 | DRAFT | Processing status DRAFT | CHAR | 1 | ||
122 | ACTIVEDOCUMENT | Sales and Distribution Document Number | CHAR | 10 | ||
123 | GRWCU | Updated information in related user data field | CUKY | 5 | ||
124 | BLART | Document Type | CHAR | 2 | ||
125 | .INCLUDE | 0 | ||||
126 | INTRA_REL | Updated information in related user data field | CHAR | 1 | ||
127 | INTRA_EXCL | Updated information in related user data field | CHAR | 1 | ||
128 | ACCRREL | Single-Character Flag | CHAR | 1 | ||
129 | .INCLUDE | 0 | ||||
130 | J_1TPBUPL | Branch Code | CHAR | 5 | ||
131 | .INCLUDE | 0 | ||||
132 | INCOV | Incoterms Version | CHAR | 4 | TINCV | |
133 | INCO2_L | Incoterms Location 1 | CHAR | 70 | ||
134 | INCO3_L | Incoterms Location 2 | CHAR | 70 | ||
135 | .INCLUDE | 0 | ||||
136 | DUMMY_BILLINGDOC_INCL_EEW_PS | Dummy function in length 1 | CHAR | 1 | ||
137 | .INCLU--AP | 0 | ||||
138 | ZAPCGKH | NUMC | 4 | /ILE/TV01 | ||
139 | APCGK_EXTENDH | NUMC | 10 | |||
140 | ZABDATH | DATS | 8 | |||
141 | .INCLU--AP | 0 | ||||
142 | DPC_REL | Flag: DPC relevant | CHAR | 1 | ||
143 | .INCLU--AP | 0 | ||||
144 | AD01BASDOC | Initial document | CHAR | 10 | ||
145 | AD01FAREG | Rule for billing | CHAR | 1 | ||
146 | .INCLU--AP | 0 | ||||
147 | VCHRNMBR | Voucher Number | NUMC | 8 | ||
148 | .INCLU--AP | 0 | ||||
149 | .INCLUDE | 0 | ||||
150 | J_3GKBAUL | ETM-Relevant Indicator | CHAR | 1 | ||
151 | J_3GKENIE | Indicator for I(nternal) or E(xternal) Posting | CHAR | 1 | ||
152 | KUNWE | Ship-to party | CHAR | 10 | * | |
153 | .INCLU--AP | 0 | ||||
154 | OICHEADOFF | Head office account number (in branch accounts) | CHAR | 10 | * | |
155 | OIC_INPD | Invoice pricing date rule | CHAR | 1 | ||
156 | OINETCYC | Netting cycle (FI blocking indicator) | CHAR | 1 | T008 | |
157 | OIEXGNUM | Exchange agreement number | CHAR | 10 | ||
158 | OIEXGTYP | Exchange type | CHAR | 4 | * | |
159 | OIFEEPD | Fee pricing date | CHAR | 1 | ||
160 | .INCLUDE | 0 | ||||
161 | OIRIINVDOC | SSR invoicing - invoicing document type | CHAR | 3 | ||
162 | OIRIPBLNR | Business location identifier (IS-Oil MRN) | CHAR | 10 | ||
163 | OIRICOMMCAL | Calendar for monthly commission recalculation | CHAR | 2 | * | |
164 | OIRIDCLAIM | Daily claim document | CHAR | 1 | ||
165 | OIRIPCTOT | Payment card total | CURR | 15 | ||
166 | OIRICHIND | Clearing house document indicator | CHAR | 1 | ||
167 | OIRMATHANDGRP | Material handling group (IS-Oil SSR) | CHAR | 2 | * | |
168 | OIR_CHOBJ | SSR PC: Clearing house | CHAR | 6 | * | |
169 | OICSDPORGINV | Original billing document | CHAR | 10 | ||
170 | OICSDPVERNO | Version number sequence | CHAR | 2 | ||
171 | .INCLU--AP | 0 | ||||
172 | OIU_DN_NO | was OIU_DN_NO | CHAR | 20 | ||
173 | OIU_WL_NO | was OIU_WL_NO | CHAR | 15 | ||
174 | OIU_WC_NO | was OIU_WC_NO | CHAR | 5 | ||
175 | OIU_MP_NO | was OIU_MP_NO | CHAR | 20 | ||
176 | OIU_MAJPD_CD | was OIU_MAJPD_CD | CHAR | 1 | ||
177 | OIU_VNAME | was JV_NAME | CHAR | 6 | ||
178 | OIU_DOI_NO | was OIU_DOI_NO | CHAR | 5 | ||
179 | OIU_VBELN | was OIU_CT_NO | CHAR | 10 | ||
180 | OIU_PPA_RSN_CD | was OIU_PPA_RSN_CD | CHAR | 2 | ||
181 | OIU_PRCS_DT | was OIU_PRCS_DT | DATS | 8 | ||
182 | OIU_FREQ_CD | was OIU_FREQ_CD | CHAR | 1 | ||
183 | .INCLU--AP | 0 | ||||
184 | .INCLUDE | 0 | ||||
185 | MNDID | SEPA Mandate: Unique Reference to Mandate per Creditor | CHAR | 35 | ||
186 | PAY_TYPE | Type of payroll, R = regular or S = special | CHAR | 1 | ||
187 | SEPON | Single-Character Flag | CHAR | 1 | ||
188 | MNDVG | SEPA-Relevance | CHAR | 1 | ||
189 | .INCLU--AP | 0 | ||||
190 | SPPAYM | Single-Character Flag | CHAR | 2 | ||
191 | SPPORD | Sales Order for Special Payment Method | CHAR | 10 |
SAP Help, Wiki Resources, and Forum Discussions on VBRK
Click the above link for the full list of resources and help pages, only the first few are posted below
-
Need pointers to improve performance of a select query to table VBRK
The total execution time for this query for the afore given data is 72,983 ms with the average time/record being ~ 9,471 ms which is too high.
http://scn.sap.com/message/6365725
-
Joining VBRK, VBRP, VBAK, VBAP, LIKP, LIPS | SCN
I just wanted to ask how to join the above subject in one table? Or it isnt possible?
http://scn.sap.com/thread/493171
-
Field "ZUONR" is not updating in VBRK table | SCN
We are maintaining the customer cheque no in field "ZUONR" of "VBAK"(Sale order header in accounting TAB in assignment fiel) at the time of sale order creation but while making the bill of this sale order it is not updating the filed "ZUONR" of "VBRK" table with sale order value. Can anyone please inform me what customization is required for updating this field in Billing table.
http://scn.sap.com/message/6372507
-
Insert data to table VBRK | SCN
HALLOW
how i insert data to table in se11 like table VBRK.
Regards
http://scn.sap.com/message/3908694
-
Join between VBRK and BSID to get all cust open items
I have requirement to get all customer open items.When partial payments done we wont mention invoice hence i am unable to get those records in customer open item list.
http://scn.sap.com/message/10482485
-
Relation betwen VBRK AND BSEG | SCN
can anyone help me in finding relationship between VBRK and BSEG. I want to find out BSEG-BELNR using VBRK-VBELN.
http://scn.sap.com/message/3519836
-
Select on VBRK | SCN
very simple, following query takes long time.......pls suggest alternative.
http://scn.sap.com/message/5763780
-
Performance issue with join VBRK & VBRP & KNVV
i wrote a select statement with 2 joins on 3 tables... & also 1 join on VBRK & VBRP and For all entries on KNVV...
http://scn.sap.com/message/8417895
-
Need Bidirectional Sales Order Invoice BAPI to update the fields in VBRK
Hi Experts, Actually we have a requiement like to implement BAPI for Getting the data for Sales order Invoice so that the other system will call this bapi and they will fill the 'z' fields in the BAPI. Again the same bapi has to update these 'z' fields into the VBRK Table. Please guide me how can i achive it. I searched for the Standard BAPI but it is not having the fields which i need. Can any bod...
http://scn.sap.com/message/13136133
-
Relation field between table VBRK/VBRP and BSEG | SCN
Can any body guide on the common fields between VBRK/ VBRP and BSEG, except field "assignment".
http://scn.sap.com/message/6670731
-
How to connect VBRK,vttk,vbrp | SCN
could you tell me how would I connect VBRK ,vttk, vbrp ..i am very new to sap..i dont know how would I connect them in my where clause and which field do I need to select. I need to show all these fields: in VBRK i need the fkdat,vbeln vttk i need the tknum,exti1,exti2 vbrp i need the fkimg in my selection-screen fields are from VBRK ,vbrp and kna1. i have to make a report based on bill...
http://scn.sap.com/message/13232837
Related Tables
TABLE | Description | Functional Area |
---|---|---|
VBRP | Billing Document: Item Data | SD - Billing |
VBAK | Sales Document: Header Data | SD - Sales |
LIKP | SD Document: Delivery Header Data | Logistics Execution - Shipping |
LIPS | SD document: Delivery: Item data | Logistics Execution - Shipping |
VBFA | Sales Document Flow | SD - Basic Functions |
KONV | Conditions (Transaction Data) | SD - Conditions |
VBPA | Sales Document: Partner | SD - Basic Functions |
Transaction Codes for SAP Table VBRK
TCODE | Description | Functional Area |
---|---|---|
VF01 | Create Billing Document | SD - Billing |
SPRO | Customizing - Edit Project | Basis - Customizing Project Management (IMG) |
VTFL | Delivery to bill copying control | SD - Basic Functions |
VA01 | Create Sales Order | SD - Sales |
SE16 | Data Browser | Basis - Workbench Utilities |
VF02 | Change Billing Document | SD - Billing |
SE38 | ABAP Editor | Basis - ABAP Editor |
SE11 | ABAP Dictionary Maintenance | Basis - Dictionary Maintenance |
FMs for SAP Table VBRK
FM | Description | Functional Area |
---|---|---|
REUSE_ALV_GRID_DISPLAY | Output of a simple list (single-line) | Basis - SAP List Viewer |
REUSE_ALV_COMMENTARY_WRITE | List body comment block output | BC - SAP List Viewer |
REUSE_ALV_EVENTS_GET | Returns table of possible events for a list type | BC - SAP List Viewer |
REUSE_ALV_LIST_DISPLAY | Output a simple list (single line or several lines) | BC - SAP List Viewer |
REUSE_ALV_FIELDCATALOG_MERGE | Create field catalog from dictionary structure or internal table | BC - SAP List Viewer |
SSF_FUNCTION_MODULE_NAME | Basis - Smart Forms | |
F4_FILENAME | F4 for filename / Filemanager support to locate file in a directory | PM - Plant Maintenance |
READ_TEXT | SAPscript: Read text | BC - SAPscript |
ABAP Reports for SAP Table VBRK
ABAP REPORT | Description | Functional Area |
---|---|---|
RV60AFZC | User Exit for Billing | SD - Material Maintenance |
SAPMV60A | Processing Billing Documents | SD - Billing |
SAPMV45A | Sales Order Processing | SD - Sales |
MV45AFZB | User Exits | SD - Material Maintenance |
SPRSL | TEXT | 630 - Workbench Tools: Editors |
RV60AFZD | Billing doc. user exits for partner functions in invoice lists | SD - Material Maintenance |
RV61AFZB | Modifications | SD - Material Maintenance |
RLB_INVOICE | Invoice print program | SD - Basic Functions |
BW Datasources for SAP Table VBRK
BW DATASOURCE | Description | Functional Area |
---|---|---|
2LIS_13_VDITM | Billing Document Item Data | SD - Sales and Distribution |
2LIS_13_VDHDR | Billing Doc. Header Data | SD - Sales and Distribution |
2LIS_11_VAITM | Sales Document Item Data | SD - Sales and Distribution |
2LIS_13_VDKON | Billing Document Condition | SD - Sales and Distribution |
2LIS_11_VAHDR | Sales Document Header Data | SD - Sales and Distribution |
2LIS_12_VCITM | Delivery Item Data | SD - Sales and Distribution |
0FI_AR_4 | Customers: Line Items with Delta Extraction | FI - Accounts Receivable |
2LIS_11_VASCL | Sales Document Schedule Line | SD - Sales and Distribution |
Authorization Objects for SAP Table VBRK
AUTHORIZATION OBJECT | Description | Functional Area |
---|---|---|
V_VBAK_VKO | Sales Document: Authorization for Sales Areas | |
P_PERNR | HR: Master Data - Personnel Number Check | |
S_CARRID | Authorization Object for Airlines | |
P_TCODE | HR: Transaction codes | |
E_GRID | Authorization Object for Grid | |
I_TCODE | PM: Transaction Code | |
V_VBRK_VKO | Billing: Authorization for Sales Organizations |
Most searched SAP Sales and Distribution Tables
- Sales Order Tables
- Plant Tables
- Document Type Tables
- Delivery Tables
- Pricing Tables
- Billing Document 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
- Output Type Tables
- Customer Group Tables
- Price List Tables
- Condition Record Tables
- Order Type Tables
- Sales Order Type Tables
- Info Record Tables