SAP TABLES | Sales and Distribution | Billing(SD-BIL) SAP SD

VBRK SAP Billing Document: Header Data Table and data







VBRK is a standard SAP Table which is used to store Billing Document: Header Data data and is available within R/3 SAP systems depending on the version and release level.

Below is the standard documentation available and a few details of the fields which make up this Table. You can view further information about SAP VBRK Table and the data within it using relevant transactions such as SE11, SE80 or SE16. Also check out the Comments section below to view or add related contributions and example screen shots.

Delivery Class: A - Application table containing master and transaction data

Display/Maintenance via SM30: Yes but with Restrictions

Enhancement category i: Can be enhanced (character-type or numeric)
See here for more information about this and other SAP enhancement categories

==>View Table relationships


SAP VBRK Table fields within data Dictionary





FieldData ElementData Typelength (Decimals)Check tableDescriptionConversion Routine
MANDTMANDTCLNT3 T000Client
VBELNVBELN_VFCHAR10 VBUKBilling DocumentALPHA
FKARTFKARTCHAR4 TVFKBilling Type
FKTYPFKTYPCHAR1 Billing category
VBTYPVBTYPCHAR1 SD document category
WAERKWAERKCUKY5 TCURCSD Document Currency
VKORGVKORGCHAR4 TVKOSales Organization
VTWEGVTWEGCHAR2 TVTWDistribution Channel
KALSMKALSMASDCHAR6 T683Sales and Distribution: Pricing Procedure in Pricing
KNUMVKNUMVCHAR10 Number of the document condition
VSBEDVSBEDCHAR2 TVSBShipping Conditions
FKDATFKDATDATS8 Billing date for billing index and printout
BELNRBELNR_DCHAR10 Accounting Document NumberALPHA
GJAHRGJAHRNUMC4 Fiscal YearGJAHR
POPERPOPERNUMC3 Posting period
KONDAKONDACHAR2 T188Price group (customer)
KDGRPKDGRPCHAR2 T151Customer group
BZIRKBZIRKCHAR6 T171Sales district
PLTYPPLTYPCHAR2 T189Price list type
INCO1INCO1CHAR3 TINCIncoterms (Part 1)
INCO2INCO2CHAR28 Incoterms (Part 2)
EXPKZEXPKZCHAR1 Export indicator
RFBSKRFBSKCHAR1 Status for transfer to accounting
MRNKZMRNKZCHAR1 Manual invoice maintenance
KURRFKURRFDEC9(5) Exchange rate for FI postingsEXCRT
CPKURCPKURCHAR1 ID:Exchange rate setting (no new rate determ.in bill.doc.)
VALTGVALTGNUMC2 Additional value days
VALDTVALDTDATS8 Fixed value date
ZTERMDZTERMCHAR4 Terms of Payment Key
ZLSCHSCHZW_BSEGCHAR1 T042ZPayment Method
KTGRDKTGRDCHAR2 TVKTAccount assignment group for this customer
LAND1LLANDCHAR3 T005Country of Destination
COUNCCOUNCCHAR3 T005ECounty Code
CITYCCITYCCHAR4 T005GCity Code
BUKRSBUKRSCHAR4 T001Company Code
TAXK1TAXK1CHAR1
*
Tax classification 1 for customer
TAXK2TAXK2CHAR1
*
Tax classification 2 for customer
TAXK3TAXK3CHAR1
*
Tax classification 3 for customer
TAXK4TAXK4CHAR1
*
Tax Classification 4 Customer


TAXK5TAXK5CHAR1
*
Tax classification 5 for customer
TAXK6TAXK6CHAR1
*
Tax classification 6 for customer
TAXK7TAXK7CHAR1
*
Tax classification 7 for customer
TAXK8TAXK8CHAR1
*
Tax classification 8 for customer
TAXK9TAXK9CHAR1
*
Tax classification 9 for customer
NETWRNETWRCURR15(2) Net Value in Document Currency
ZUKRIDZUKRICHAR40 Combination criteria in the billing document
ERNAMERNAMCHAR12 Name of Person who Created the Object
ERZETERZETTIMS6 Entry time
ERDATERDATDATS8 Date on Which Record Was Created
STAFOSTAFOCHAR6
*
Update group for statistics updateALPHA
KUNRGKUNRGCHAR10 KNA1PayerALPHA
KUNAGKUNAGCHAR10 KNA1Sold-to partyALPHA
MABERMABERCHAR2 T047MDunning Area
STWAESTWAECUKY5 TCURCStatistics currency
EXNUMEXNUMCHAR10 EIKPNumber of foreign trade data in MM and SD documents
STCEGSTCEGCHAR20 VAT Registration Number
AEDATAEDATDATS8 Changed On
SFAKNSFAKNCHAR10 VBUKCancelled billing document numberALPHA
KNUMAKNUMACHAR10 KONAAgreement (various conditions grouped together)ALPHA
FKART_RLFKART_RLCHAR4 TVFKInvoice list type
FKDAT_RLFKDAT_RLDATS8 Billing date for the invoice list
KURSTKURSTCHAR4 TCURVExchange Rate Type
MSCHLMSCHLCHAR1 T040Dunning key
MANSPMANSPCHAR1 T040SDunning block
SPARTSPARTCHAR2 TSPADivision
KKBERKKBERCHAR4 T014Credit control area
KNKLIKNKLICHAR10 KNA1Customer's account number with credit limit referenceALPHA
CMWAEWAERS_CMCUKY5 TCURCCurrency key of credit control area
CMKUFCMKUFDEC9(5) Credit data exchange rate at billing document rateEXCRT
HITYP_PRHITYP_PRCHAR1 THITHierarchy type for pricing
BSTNK_VFBSTKDCHAR35 Customer purchase order number
VBUNDRASSCCHAR6 T880Company ID of trading partnerALPHA
FKART_ABFKART_ABCHAR4
*
Accrual billing type
KAPPLKAPPLCHAR2
*
Application
LANDTXLANDTXCHAR3
*
Tax departure country
STCEG_HSTCEG_HCHAR1 Origin of sales tax ID number
STCEG_LSTCEG_LCHAR3
*
Country of Sales Tax ID Number
XBLNRXBLNR_V1CHAR16 Reference Document Number


ZUONRORDNR_VCHAR18 Assignment number
MWSBKMWSBPCURR13(2) Tax amount in document currency
LOGSYSLOGSYSCHAR10
*
Logical systemALPHA
FKSTOFKSTOCHAR1 Billing document is cancelled
XEGDRXEGDRCHAR1 Indicator: Triangular deal within the EU ?
RPLNRRPLNRCHAR10 FPLANumber of payment card plan type
LCNUMLCNUMCHAR10 AKKPFinancial doc. processing: Internal financial doc. numberALPHA
J_1AFITPJ_1AFITP_DCHAR2 J_1AFITPTax type
KURRF_DATWWERT_DDATS8 Translation Date
AKWAEAKWAECUKY5 TCURCCurrency key for letter-of-credit procg in foreign trade
AKKURAKKURDEC9(5) Exchange rate for letter-of-credit procg in foreign tradeEXCRT
KIDNOKIDNOCHAR30 Payment Reference
BVTYPBVTYPCHAR4 Partner Bank Type
NUMPGJ_1ANOPGNUMC3 Number of pages of invoice
BUPLABUPLACHAR4 J_1BBRANCHBusiness Place
VKONTCORR_VKONT_KKCHAR12 Contract Account NumberALPHA
FKK_DOCSTATDOCSTAT_KKCHAR1 Additional Status Transfer to Fin. Accounting (Res. RFBSK)
NRZASCHAR12CHAR12 Character Field of Length 12
SPE_BILLING_IND/SPE/DE_BILLING_INDCHAR1 EWM Billing Indicator
VTREFCORR_VTREF_KKCHAR20 Reference Specifications from ContractALPHA
FK_SOURCE_SYSFK_SOURCE_SYSCHAR10
*
Source SystemALPHA
FKTYP_CRMFKTYP_CRMCHAR1 Billing Category in CRM
STGRDSTGRDCHAR2 T041CReason for Reversal
VBTYP_EXTTDD_VBTYP_EXTCHAR4 Extension of SD Document Category
.APPEND/SAPPCE/VBRK_FI_DPC VBRK append for Down Payment Chain
DPC_REL/SAPPCE/DPC_RELCHAR1 Flag: DPC relevant
.APPENDAD01VBRK VBRK 的附加
AD01BASDOCAD01BASDOCCHAR10
*
Initial documentALPHA
AD01FAREGAD01FAREGCHAR1 Rule for billing
.APPENDAD04NMC2 Kategorija številk
VCHRNMBRAD04VCHNRNUMC8 Voucher Number
.APPENDHBSVBRK RE-SCM добавить к VBRK
SWENRHB_SWENRCHAR8 VIOB01Business Entity NumberSWENR
SMENRHB_SMENRCHAR8 VIMI01Number of Sales UnitSMENR
PHASEHB_SPHSECHAR11 HBSSPHSales Phase
MTLAURHB_MTLAURCHAR1 CHBSNCMMarker for Low Income Housing
STAGEHB_STAGEINT410 Construction Stage
HB_CONT_REASONHB_CONTCHAR2 Contingency data
HB_EXPDATEHB_EXPDATS8 Expiration date

HB_RESDATEHB_RESDATS8 Resolution date
.APPENDJ_3GVBRKA ETM: VBRK tablosu için ek
.INCLUDEJ_3GVBRKI CEM: Include for Table VBRK
J_3GKBAULJ_3GKBAULCHAR1 ETM-Relevant Indicator
J_3GKENIEJ_3GKENIECHAR1 Indicator for I(nternal) or E(xternal) Posting
KUNWEKUNWECHAR10
*
Ship-to partyALPHA
.APPENDVBRK_SD_SEPA VBRK_SEPA
.INCLUDESDSEPA SEPA SD Struktur
MNDIDSEPA_MNDIDCHAR35 Unique Referene to Mandate per Payment Recipient
PAY_TYPESEPA_PAY_TYPECHAR1 SEPA: Transaction Type
SEPONSD_SEPA_FLAGCHAR1 SEPA-Relevance
MNDVGSD_SEPA_FLAGCHAR1 SEPA-Relevance
.APPENDVBRK_SPPAYM Append Structure for Special Paymenents
SPPAYMSPPAYMCHAR2 Payment Form for Special Payment Method
SPPORDSPPORDCHAR10
*
Sales Order for Special Payment MethodALPHA



Key field
Non-key field

VBRK relationships with other tables


PAKET_RRLREC-Remuneration List Recipient
     DOCUMENTS-Documents for Remuneration List Recipient
     DYNSEL-Selektionsdaten
          FOREIGNKEY_SEL-Selection on foreign key
          V_RRLE_REL-Relevant Documents
          V_RRLEE_REL-Relevant External Docs
               VBRK-Relevant SD Billing Docs
               BKPF-Relevant AC Document Headers
                    BSEG-Relevant AC Document Lines


ADMIX-Help structure for reading via ADK in LDB(SD)
     VBUK-Sales Document: Header Status and Admin. Data
          VBRK-Billing Document: Header Data
               NAST-Message status
               VBFA-Sales Document Flow
               VBRP-Billing Document: Item Data
               KONV-Conditions (Transaction Data)
               VBPA-Sales Document: Partner
               SADR-Address Management: Company data
               VBSSSK-Table Generated for View VBSSSK
               EIKP-Foreign Trade: Export/Import Header Data
               EIPO-Foreign Trade: Export/Import: Item Data
               STXH-STXD SAPscript text file header
               STXL-STXD SAPscript text file lines
               VBRL-Sales Document: Invoice List


VBRK-Billing Document: Header Data
     VBUK-Sales Doc.: Header Status and Administrative Data
     VBPA-Sales Document: Partner
     VBRP-Billing Document: Item Data
          VBFA-Sales Document Flow
          VBFAVG-Sales document: Cumulative records,followed by doc
          VBPAPO-Item partner of sales document (for LDB)
          KONV-Conditions (Transaction Data)