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.

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

SAP Help, Wiki, Q&A and other resources for VBKD

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

  • Extraktion SD-Verkauf: Belegeinteilung | SAP Help Portal

    Die Struktur Extraktion SD-Verkauf: Belegeinteilung dient dazu, Einteilungsinformationen von SD-Aufträgen und Angeboten (nicht jedoch Anfragen) in ein BI-System zu extrahieren.

    https://help.sap.com/docs/BI_CONTENT_757/05535c1b453c4901acc0e53ca0191744/dddb9e759d4f453a8e081ad7df5f7770.html?locale=de-DE

  • Extraktion SD-Verkauf: Auftragskonditionen | SAP Help Portal

    Mit der Struktur Extraktion SD-Verkauf: Auftragskonditionen kann man die aktiven Konditionszeilen, die zum Preisfindungsergebnis einer Auftragsposition beitragen, in ein BW-System extrahieren.

    https://help.sap.com/docs/BI_CONTENT_757/05535c1b453c4901acc0e53ca0191744/6310306b99904f3d897c50667e2e1d10.html?locale=de-DE

  • Extraktion SD-Verkauf: Belegposition | SAP Help Portal

    Die Struktur Extraktion SD-Verkauf: Belegposition dient dazu, Positionsinformationen von SD-Aufträgen und Angeboten (nicht jedoch Anfragen) in ein BI-System zu extrahieren.

    https://help.sap.com/docs/BI_CONTENT_757/05535c1b453c4901acc0e53ca0191744/3a27b6962129448ebe71fd945cfa8823.html?locale=de-DE

  • Extraktion SD-Verkauf: Belegposition-Verrechnung | SAP Help Portal

    Die Struktur Extraktion SD-Verkauf: Belegposition-Verrechnung dient dazu, offene Auftragswerte von SD-Auftragspositionen in ein BI-System zu extrahieren

    https://help.sap.com/docs/BI_CONTENT_757/05535c1b453c4901acc0e53ca0191744/945780aeec7d43d9be78b05fd4b3212e.html?locale=de-DE

  • Extraktion SD-Verkauf: Belegeinteilung-Verrechnung | SAP Help Portal

    Die Struktur Extraktion SD-Verkauf: Belegeinteilung-Verrechnung dient dazu offene zu liefernde Mengen von SD-Auftragseinteilungen in ein BI-System zu extrahieren

    https://help.sap.com/docs/BI_CONTENT_757/05535c1b453c4901acc0e53ca0191744/41938d9c476c4ed6a9eed87b59ae19ac.html?locale=de-DE

  • Extraktion SD-Verkauf: Fakturapositionsdaten | SAP Help Portal

    Sie verwenden die Fakturapositionsdaten, um Positionsinformationen aus Fakturabelegen in ein BI-System zu extrahieren.

    https://help.sap.com/docs/BI_CONTENT_757/05535c1b453c4901acc0e53ca0191744/429a54a7a7e541b1b5f8036979540339.html?locale=de-DE

  • Extraktion SD-Verkauf: Lieferposition | SAP Help Portal

    Sie verwenden die Struktur Lieferposition, um Positionsinformationen aus Lieferbelegen in ein BI-System zu extrahieren.

    https://help.sap.com/docs/BI_CONTENT_757/05535c1b453c4901acc0e53ca0191744/b06a0e5b95e34fc890a515daa03d4b75.html?locale=de-DE

  • Extraction SD Sales: Document Schedule Line | SAP Help Portal

    The structure Extraction SD Sales: Document Schedule Line is used to extract schedule line information from SD orders and quotations (but not requests) to a BI system.

    https://help.sap.com/docs/BI_CONTENT_757/05535c1b453c4901acc0e53ca0191744/dddb9e759d4f453a8e081ad7df5f7770.html

  • Extraction SD Sales: Order Conditions | SAP Help Portal

    Using the Extraction SD Sales: Order Conditions structure, you can extract to a BW system the active condition lines that contribute to the pricing result for an order item.

    https://help.sap.com/docs/BI_CONTENT_757/05535c1b453c4901acc0e53ca0191744/6310306b99904f3d897c50667e2e1d10.html

  • Extraction SD Sales: Document Item | SAP Help Portal

    The Extraction SD-Sales: Document Item structure is used to extract item information from SD orders and quotations (but not requests) to a BI system.

    https://help.sap.com/docs/BI_CONTENT_757/05535c1b453c4901acc0e53ca0191744/3a27b6962129448ebe71fd945cfa8823.html

  • View the full list of resources, SAP Help/Wiki pages and Q&A for VBKD


Related Tables

TABLE Description Functional Area
VBAK Sales Document: Header Data SD - Sales
VBAP Sales Document: Item Data SD - Sales
VBPA Sales Document: Partner SD - Basic Functions
VBRK Billing Document: Header Data SD - Billing
VBEP Sales Document: Schedule Line Data SD - Sales

Transaction Codes for SAP Table VBKD

TCODE Description Functional Area
VA01 Create Sales Order SD - Sales
VA02 Change Sales Order SD - Sales
VA03 Display Sales Order SD - Sales
VF01 Create Billing Document SD - Billing
VTFA Order to bill copying control SD - Basic Functions

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
REUSE_ALV_EVENTS_GET Returns table of possible events for a list type BC - SAP List Viewer

ABAP Reports for SAP Table VBKD

ABAP REPORT Description Functional Area
SAPMV45A Sales Order Processing SD - Sales
MV45AFZZ Billing SD - Material Maintenance
MV45AFZB User Exits SD - Material Maintenance
BDCRECX1 Include f Basis - UI Services, Screen, Batch Input
SAPMSSY0 System Exits Basis - Syntax, Compiler, Runtime
RSCONN01 SAPconnect: Start Send Process Basis - Communication Services: Mail, Fax, SMS, Telephony

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

Authorization Objects for SAP Table VBKD

AUTHORIZATION OBJECT Description Functional Area
P_PERNR HR: Master Data - Personnel Number Check
L_TCODE Transaction Codes in the Warehouse Management System
V_VBAK_VKO Sales Document: Authorization for Sales Areas
P_TCODE HR: Transaction codes
E_GRID Authorization Object for Grid

Most searched SAP Sales and Distribution Tables