VBKD is a standard Sales Transparent Table in SAP SD application, which stores Sales Document: Business 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 VBKD. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition.

VBKD — Meta Data

Description: Sales Document: Business Data
Main Category: SD
Sub Category: Sales
Table type: Transparent Table (TRANSP)

VBKD — 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 POSNR Item X NUMC 6
    4 KONDA Updated information in related user data field CHAR 2 T188
    5 KDGRP Customer group CHAR 2 T151
    6 BZIRK Sales district CHAR 6 T171
    7 PLTYP Benefit plan type CHAR 2 T189
    8 INCO1 Incoterms CHAR 3 TINC
    9 INCO2 Incoterms 2 CHAR 28
    10 KZAZU Order Combination Indicator CHAR 1
    11 PERFK Invoice dates (calendar identification) CHAR 2 TFACD
    12 PERRL Updated information in related user data field CHAR 2 TFACD
    13 MRNKZ Updated information in related user data field CHAR 1
    14 KURRF Exch.rate-acct. DEC 9
    15 VALTG Updated information in related user data field NUMC 2
    16 VALDT License Validity DATS 8
    17 ZTERM Payt terms CHAR 4
    18 ZLSCH Pymt method CHAR 1 T042Z
    19 KTGRD AcctAssgGr CHAR 2 TVKT
    20 KURSK Exchange Rate DEC 9
    21 PRSDT Pricing date DATS 8
    22 FKDAT Billing Date DATS 8
    23 FBUDA Serv.rendered DATS 8
    24 GJAHR Fiscal Year NUMC 4
    25 POPER Posting period NUMC 3
    26 STCUR Exch.rate stats DEC 9
    27 MSCHL Dunning key CHAR 1 T040
    28 MANSP Dunn. block CHAR 1 T040S
    29 FPLNR Billing plan number / invoicing plan number CHAR 10 FPLA
    30 WAKTION Promotion CHAR 10 WAKH
    31 ABSSC Payment guarantee procedure CHAR 6 T691M
    32 LCNUM Financial doc. processing: Internal financial doc. number CHAR 10
    33 J_1AFITP Tax type CHAR 2 J_1AFITP
    34 J_1ARFZ Single-Character Flag CHAR 1 J_1ARFZ
    35 J_1AREGIO Region (State CHAR 3 T005S
    36 J_1AGICD Single-Character Flag CHAR 2 J_1AGICD
    37 J_1ADTYP Single-Character Flag CHAR 2 J_1ADTYP
    38 J_1ATXREL Single-Character Flag CHAR 10 J_1ATXREL
    39 ABTNR Department number CHAR 4 TSAB
    40 EMPST Receiving point CHAR 25
    41 BSTKD Updated information in related user data field CHAR 35
    42 BSTDK Customer purchase order date DATS 8
    43 BSARK Customer purchase order type CHAR 4 T176
    44 IHREZ Your Reference CHAR 12
    45 BSTKD_E Updated information in related user data field CHAR 35
    46 BSTDK_E Updated information in related user data field DATS 8
    47 BSARK_E Single-Character Flag CHAR 4 T176
    48 IHREZ_E Single-Character Flag CHAR 12
    49 POSEX_E Updated information in related user data field CHAR 6
    50 KURSK_DAT Translatn Date DATS 8
    51 KURRF_DAT Translation date DATS 8
    52 KDKG1 Single-Character Flag CHAR 2 TVKGG
    53 KDKG2 Single-Character Flag CHAR 2 TVKGG
    54 KDKG3 Single-Character Flag CHAR 2 TVKGG
    55 KDKG4 Single-Character Flag CHAR 2 TVKGG
    56 KDKG5 Single-Character Flag CHAR 2 TVKGG
    57 WKWAE Single-Character Flag CUKY 5 TCURC
    58 WKKUR Single-Character Flag DEC 9
    59 AKWAE Currency key for letter-of-credit procg in foreign trade CUKY 5 TCURC
    60 AKKUR Exchange rate for letter-of-credit procg in foreign trade DEC 9
    61 AKPRZ Depreciation percentage for financial document processing DEC 5
    62 J_1AINDXP Updated information in related user data field CHAR 5 J_1AINFT20
    63 J_1AIDATEP Updated information in related user data field DATS 8
    64 BSTKD_M Single-Character Flag CHAR 35
    65 DELCO Checkbox CHAR 3 TVDC
    66 FFPRF Single-Character Flag CHAR 8 AD01C_PROF
    67 BEMOT Accounting Indicator CHAR 2 TBMOT
    68 FAKTF Single-Character Flag CHAR 2
    69 RRREL Revenue recognition category CHAR 1
    70 ACDATV Single-Character Flag CHAR 1
    71 VSART Shipping type CHAR 2 T173
    72 TRATY Means-of-Transport Type CHAR 4 TVTY
    73 TRMTYP Means of Transport CHAR 40 MARA
    74 SDABW Special processing indicator CHAR 4 TVSAK
    75 WMINR Catalog CHAR 10 WWMI
    76 FKBER Functional Area CHAR 16 TFKB
    77 PODKZ Updated information in related user data field CHAR 1
    78 CAMPAIGN Updated information in related user data field RAW 16
    79 VKONT Contract Account CHAR 12
    80 DPBP_REF_FPLNR Billing plan number / invoicing plan number CHAR 10
    81 DPBP_REF_FPLTR Item for billing plan/invoice plan/payment cards NUMC 6
    82 REVSP Revenue Distribution Type CHAR 1
    83 REVEVTYP Revenue Event Type (Customizing) CHAR 1
    84 FARR_RELTYPE Relevance Type for Revenue Accounting CHAR 10
    85 VTREF FI-CA: Reference Specifications from Contract CHAR 20
    86 _DATAAGING Data Filter Value for Data Aging DATS 8
    87 .INCLUDE 0
    88 J_1TPBUPL Branch Code CHAR 5
    89 .INCLUDE 0
    90 INCOV Incoterms Version CHAR 4 TINCV
    91 INCO2_L Incoterms Location 1 CHAR 70
    92 INCO3_L Incoterms Location 2 CHAR 70
    93 .INCLU--AP 0
    94 PACKNO Package number NUMC 10 ESLH
    95 .INCLU--AP 0
    96 PEROP_BEG Billing Period of Performance Start Date DATS 8
    97 PEROP_END Billing Period of Performance End Date DATS 8
    98 .INCLU--AP 0
    99 STCODE LST CST applicability code CHAR 3 *
    100 FORMC1 Form Type CHAR 3 *
    101 FORMC2 Form Type CHAR 3 *
    102 STEUC Checkbox CHAR 16
    103 .INCLU--AP 0
    104 OIC_TIME Single-Character Flag TIMS 6
    105 OITITLE Location of title transfer for Incoterms purposes CHAR 1
    106 OIPTRM1 Payment terms for invoice cycle X CHAR 4
    107 OIPTRM2 Payment terms for invoice cycle X CHAR 4
    108 OIPTRM3 Payment terms for invoice cycle X CHAR 4
    109 OIPTRM4 Payment terms for invoice cycle X CHAR 4
    110 OIPTRM5 Payment terms for invoice cycle X CHAR 4
    111 OIPTRM6 Payment terms for invoice cycle X CHAR 4
    112 OIPTRM7 Payment terms for invoice cycle X CHAR 4
    113 OIPTRM8 Payment terms for invoice cycle X CHAR 4
    114 OIPTRM9 Payment terms for invoice cycle X CHAR 4
    115 OIPFLIC Updated information in related user data field CHAR 2 TPAR
    116 .INCLU--AP 0
    117 COMPREAS Abbreviation for Complaints Reason CHAR 4
    118 .INCLU--AP 0
    119 .INCLUDE 0
    120 MNDID SEPA Mandate: Unique Reference to Mandate per Creditor CHAR 35
    121 PAY_TYPE Type of payroll, R = regular or S = special CHAR 1
    122 SEPON Single-Character Flag CHAR 1
    123 MNDVG SEPA-Relevance CHAR 1

SAP Help, Wiki Resources, and Forum Discussions on VBKD

Click the above link for the full list of resources and help pages, only the first few are posted below

  • Change the Customer PO Type VBKD-BSARK | SCN

    I have requirement where I need to clear the values entered in the PO Type field in the PO Data tab of VA01/02. So whatever the user enters in this field, if they press the Save button, should not get saved. I tried to clear the values in XVBKD-BSART in the exit : userexit_save_document_prepare, but it did not work.

    http://scn.sap.com/message/3799501

  • Can't search in Table VBKD for some specific SO/SOItem...

    Business data is data the can apply to both the header and the line item of a sales document. Bydefault, the business data assigned to the header fo the document applies to all of the line items. If the line item data is changed and is different from the header data then an entry for that line item will also be made in table VBKD. So, if posnr = '000000' then it is header business data. If posnr > ...

    http://scn.sap.com/message/13266837

  • VBKD update | SCN

    Could you please conform me when the VBKD table is update.I can see all the sales doc in this table with 000 line item and some with line item as 10 so can any one guid me why is it so?

    http://scn.sap.com/thread/1414436

  • Exchange rate VBKD-KURRF | SCN

    The question is about the exchange rate with manual entry field VBKD-KURRF through order sales (Header -> Accounting).

    http://scn.sap.com/message/11156436

  • How to modify VBKD | SCN

    i need to change "Terms of Payment Key", so I'm editing the "userexit_save_document" .

    http://scn.sap.com/message/6335062

  • Need help to understand the relation bw VBKD and VBAP

    I have a requiement to display the incoterms of ship-to-party if Ship-to-party is differnt from sold-to-party.

    http://scn.sap.com/message/9380607

  • VBKD business data table | SCN

       I have one doubt Regarding VBKD table i know by using VBKD table we can find sales document business data like customer group, price group, sales districs, payment terms

    http://scn.sap.com/message/13788259

  • Records in VBKD | SCN

    Are the records stored per line item or are the records stored per header data? This confusion arose because when I create orders in our scenario, so for some orders, VBKD stored records line item wise and for some orders it stored just a header record (for POSNR = 0000).

    http://scn.sap.com/message/5005303

  • Suspect VBKD inconsistency. | SCN

    i have one question to ask . i tried to develop a adhoc report using QUERY and inforset.

    http://scn.sap.com/message/7252547

  • BAPI_SALESORDER_CREATEFROMDAT2  VBKD-traty | SCN

    Hi experts

    Anyone know how to pass the value of Means of Transport(VBKD-TRATY) to

    BAPI BAPI_SALESORDER_CREATEFROMDAT2?

    Thanks in Advance,

    Shichun qing

    http://scn.sap.com/message/9407578

  • Update VBKD-IHREZ field in MV45AFZZ Exit on price redetermination

    I want to update VBKD-IHREZ with a value everytime I do update pricing in a sales order.

    http://scn.sap.com/message/10984473


Related Tables

TABLE Description Functional Area
VBAK Sales Document: Header Data SD - Sales
VBPA Sales Document: Partner SD - Basic Functions
VBRK Billing Document: Header Data SD - Billing
VBRP Billing Document: Item Data SD - Billing
VBEP Sales Document: Schedule Line Data SD - Sales
LIPS SD document: Delivery: Item data Logistics Execution - Shipping
LIKP SD Document: Delivery Header Data Logistics Execution - Shipping

Transaction Codes for SAP Table VBKD

TCODE Description Functional Area
VA01 Create Sales Order SD - Sales
SPRO Customizing - Edit Project Basis - Customizing Project Management (IMG)
VA02 Change Sales Order SD - Sales
SE38 ABAP Editor Basis - ABAP Editor
SE16 Data Browser Basis - Workbench Utilities
SE11 ABAP Dictionary Maintenance Basis - Dictionary Maintenance
MIGO Goods Movement MM - Inventory Management

FMs for SAP Table VBKD

FM Description Functional Area
REUSE_ALV_GRID_DISPLAY Output of a simple list (single-line) Basis - SAP List Viewer
BAPI_SALESORDER_CREATEFROMDAT2 Sales order: Create Sales Order SD - Basic Functions
BAPI_TRANSACTION_COMMIT Execute external Commit when using BAPIs Basis - ALE Integration Technology
BAPI_SALESORDER_CHANGE Sales order: Change Sales Order SD - Basic Functions
REUSE_ALV_COMMENTARY_WRITE List body comment block output BC - SAP List Viewer
GUI_UPLOAD Upload for Data Provider Basis - Graphical User Interface
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 VBKD

ABAP REPORT Description Functional Area
SAPMV45A Sales Order Processing SD - Sales
MV45AFZB User Exits SD - Material Maintenance
BDCRECX1 Include f Basis - UI Services, Screen, Batch Input
SAPMSSY0 System Exits Basis - Syntax, Compiler, Runtime
SPRSL TEXT 630 - Workbench Tools: Editors
SAPMM06E Module Pool: PO History MM - Purchasing
RSCONN01 SAPconnect: Start Send Process Basis - Communication Services: Mail, Fax, SMS, Telephony
SAPLSPO1 ?...

BW Datasources for SAP Table VBKD

BW DATASOURCE Description Functional Area
2LIS_11_VAITM Sales Document Item Data SD - Sales and Distribution
2LIS_11_VAHDR Sales Document Header Data SD - Sales and Distribution
2LIS_13_VDITM Billing Document Item Data SD - Sales and Distribution
2LIS_11_V_ITM Sales-Shipping Allocation Item Data SD - Sales and Distribution
2LIS_11_VASCL Sales Document Schedule Line SD - Sales and Distribution
2LIS_11_V_SCL Sales-Shipping Allocation Schedule Line SD - Sales and Distribution
2LIS_11_VAKON Sales Document Condition SD - Sales and Distribution
2LIS_11_VASTH Sales Document Header Status SD - Sales and Distribution

Authorization Objects for SAP Table VBKD

AUTHORIZATION OBJECT Description Functional Area
V_VBAK_VKO Sales Document: Authorization for Sales Areas
P_PERNR HR: Master Data - Personnel Number Check
P_TCODE HR: Transaction codes
C_VKORG Transfer of Sales Organization Data
L_TCODE Transaction Codes in the Warehouse Management System
M_MSEG_WMB Material Documents: Plant
S_TCODE Transaction Code Check at Transaction Start

Most searched SAP Sales and Distribution Tables