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