SAP Table BAPICMS_VBRK

CMS BAPI str for Billing Header data from R/3

BAPICMS_VBRK (CMS BAPI str for Billing Header data from R/3) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link BAPICMS_VBRK to other SAP tables.

BAPICMS_VBRK table fields

Field Data element Checktable Datatype Length Decimals
OPERATION Function MSGFN CHAR 3 0
003 Delete: Message contains objects to be deleted
004 Change: Message contains changes
005 Replace: This message replaces previous messages
009 Original: First message for process
023 Wait/Adjust: Data should not be imported
018 Resend
BILL_DOC Billing Document VBELN_VF CHAR 10 0
BILL_TYPE Billing Type FKART CHAR 4 0
BILL_CAT Billing category FKTYP CHAR 1 0
A Order-related billing document
B Order-related billing document for rebate settlement
C Order-related billing document for partial rebate settlement
D Periodic billing document
E Periodic billing with active invoice accrual
F Accrual
I Delivery-related billing document for inter-company billing
K Order-related billing document for rebate correction
L Delivery-related billing document
P Down payment request
R Invoice list
U Billing request
W POS billing document
X Billing using general interface
S CRM Billing Document
N Provisional or Differential Billing Document
O Final Billing Document
SD_DOC_CAT SD document category VBTYP CHAR 1 0
A Inquiry
B Quotation
C Order
D Item proposal
E Scheduling agreement
F Scheduling agreement with external service agent
G Contract
H Returns
I Order w/o charge
J Delivery
K Credit memo request
L Debit memo request
M Invoice
N Invoice cancellation
O Credit memo
P Debit memo
Q WMS transfer order
R Goods movement
S Credit memo cancellation
T Returns delivery for order
U Pro forma invoice
V Purchase Order
W Independent reqts plan
X Handling unit
0 Master contract
1 Sales activities (CAS)
2 External transaction
3 Invoice list
4 Credit memo list
5 Intercompany invoice
6 Intercompany credit memo
7 Delivery/shipping notification
8 Shipment
a Shipment costs
b CRM Opportunity
c Unverified delivery
d Trading Contract
e Allocation table
f Additional Billing Documents
g Rough Goods Receipt (only IS-Retail)
h Cancel Goods Issue
i Goods receipt
j JIT call
n Reserved
o Reserved
p Goods Movement (Documentation)
q Reserved
r TD Transport (only IS-Oil)
s Load Confirmation, Reposting (Only IS-Oil)
t Gain / Loss (Only IS-Oil)
u Reentry into Storage (Only IS-Oil)
v Data Collation (only IS-Oil)
w Reservation (Only IS-Oil)
x Load Confirmation, Goods Receipt (Only IS-Oil)
$ (AFS)
+ Accounting Document (Temporary)
- Accounting Document (Temporary)
# Revenue Recognition (Temporary)
~ Revenue Cancellation (Temporary)
Revenue Recognition/New View (Temporary)
NULL Revenue Cancellation/New View (Temporary)
: Service Order
. Service Notification
& Warehouse Document
* Pick Order
, Shipment Document
^ Reserved
| Reserved
k Agency Document
CURRENCY SD Document Currency WAERK CUKY 5 0
CURRENCY_ISO ISO code currency WAERS_ISO CHAR 3 0
SALESORG Sales Organization VKORG CHAR 4 0
DISTR_CHAN Distribution Channel VTWEG CHAR 2 0
SD_PRICE_PROD Sales and Distribution: Pricing Procedure in Pricing KALSMASD CHAR 6 0
NO_DOC_COND Number of the document condition KNUMV CHAR 10 0
SHIP_COND Shipping Conditions VSBED CHAR 2 0
BILL_DATE Billing date for billing index and printout FKDAT DATS 8 0
AC_DOC_NO Accounting Document Number BELNR_D CHAR 10 0
FISC_YEAR Fiscal Year GJAHR NUMC 4 0
POSTING_PERIOD Posting period POPER NUMC 3 0
PRICE_GRP Price group (customer) KONDA CHAR 2 0
CUST_GROUP Customer group KDGRP CHAR 2 0
SALES_DIST Sales district BZIRK CHAR 6 0
PRICE_LIST Price list type PLTYP CHAR 2 0
INCOTERMS1 Incoterms (Part 1) INCO1 CHAR 3 0
INCOTERMS2 Incoterms (Part 2) INCO2 CHAR 28 0
EXP_IND Export indicator EXPKZ CHAR 1 0
STAT_ACC_TRAN Status for transfer to accounting RFBSK CHAR 1 0
NULL Error in Accounting Interface
A Billing document blocked for forwarding to FI
B Posting document not created (account determ.error)
C Posting document has been created
D Billing document is not relevant for accounting
E Billing Document Canceled
F Posting document not created (pricing error)
G Posting document not created (export data missing)
H Posted via invoice list
I Posted via invoice list (account determination error)
K Accounting document not created (no authorization)
L Billing doc. blocked for transfer to manager (only IS-OIL)
M Analyst Approval refused (only IS-OIL)
N No posting document due to fund management (only IS-PS)
MN_INVOICE Manual invoice maintenance MRNKZ CHAR 1 0
X Yes
NULL No
EX_RATE_FI_POS Exchange rate for FI postings KURRF DEC 9 5
EX_RATE_SET ID:Exchange rate setting (no new rate determ.in bill.doc.) CPKUR CHAR 1 0
NULL No exchange rate setting
X Exchange rate setting
ADD_VAL_DY Additional value days VALTG NUMC 2 0
FIX_VAL_DY Fixed value date VALDT DATS 8 0
PMNTTRMS CHAR 4 0
PAY_METHOD Payment Method SCHZW_BSEG CHAR 1 0
ACCNT_ASGN Account assignment group for this customer KTGRD CHAR 2 0
DEST_CNTRY Country of Destination LLAND CHAR 3 0
ISO_DEST_CNTRY Country ISO code INTCA CHAR 2 0
REGION Region (State, Province, County) REGIO CHAR 3 0
COUNTY_CDE County Code COUNC CHAR 3 0
CITY_CODE City Code CITYC CHAR 4 0
COMP_CODE Company Code BUKRS CHAR 4 0
TAX_CLASS1 Tax classification 1 for customer TAXK1 CHAR 1 0
TAX_CLASS2 Tax classification 2 for customer TAXK2 CHAR 1 0
TAX_CLASS3 Tax classification 3 for customer TAXK3 CHAR 1 0
TAX_CLASS4 Tax Classification 4 Customer TAXK4 CHAR 1 0
TAX_CLASS5 Tax classification 5 for customer TAXK5 CHAR 1 0
TAX_CLASS6 Tax classification 6 for customer TAXK6 CHAR 1 0
TAX_CLASS7 Tax classification 7 for customer TAXK7 CHAR 1 0
TAX_CLASS8 Tax classification 8 for customer TAXK8 CHAR 1 0
TAX_CLASS9 Tax classification 9 for customer TAXK9 CHAR 1 0
NET_VALUE Net Value in Document Currency NETWR CURR 15 2
COMB_CRITERIA CHAR 40 0
CREATED_BY Name of Person who Created the Object ERNAM CHAR 12 0
REC_TIME Entry time ERZET TIMS 6 0
CR_ON Date on Which Record Was Created ERDAT DATS 8 0
UPDATE_GRP Update group for statistics update STAFO CHAR 6 0
PAYER Payer KUNRG CHAR 10 0
SOLD_TO Sold-to party KUNAG CHAR 10 0
DUNN_AREA Dunning Area MABER CHAR 2 0
STAT_CURR Statistics currency STWAE CUKY 5 0
ISO_STAT_CURR ISO code currency WAERS_ISO CHAR 3 0
EXPORT_NO Number of foreign trade data in MM and SD documents EXNUM CHAR 10 0
VAT_REG_NO VAT Registration Number STCEG CHAR 20 0
CH_ON Changed On AEDAT DATS 8 0
CANC_BILL_DOC_NO Cancelled billing document number SFAKN CHAR 10 0
AGG_COND_GRP Agreement (various conditions grouped together) KNUMA CHAR 10 0
BILL_DATE_INV_LIST Invoice list type FKART_RL CHAR 4 0
EXCHG_RATE_TYPE Billing date for the invoice list FKDAT_RL DATS 8 0
EXCHG_RATE Exchange Rate Type KURST CHAR 4 0
DUNN_KEY Dunning key MSCHL CHAR 1 0
DUNN_BLOCK Dunning block MANSP CHAR 1 0
DIVISION Division SPART CHAR 2 0
C_CTR_AREA Credit control area KKBER CHAR 4 0
CRED_ACCNT Customer's account number with credit limit reference KNKLI CHAR 10 0
CURR_KEY_CC_AREA Currency key of credit control area WAERS_CM CUKY 5 0
ISO_CC_AREA_CURR ISO code currency WAERS_ISO CHAR 3 0
CR_EXC_RATE_BILL_DOC_RATE Credit data exchange rate at billing document rate CMKUF DEC 9 5
HIER_TYP_PRIC Hierarchy type for pricing HITYP_PR CHAR 1 0
PURCH_NO_C Customer purchase order number BSTKD CHAR 35 0
TRADE_ID Company ID of trading partner RASSC CHAR 6 0
ACC_BILL_TYPE Accrual billing type FKART_AB CHAR 4 0
APPL_COND Application KAPPL CHAR 2 0
TAX_DEPART_CTY Tax departure country LANDTX CHAR 3 0
ISO_TAX_DEPA Country ISO code INTCA CHAR 2 0
ORG_SALES_TAX_ID Region (State, Province, County) REGIO CHAR 3 0
SALES_TAX_CNTRY Country of Sales Tax ID Number STCEG_L CHAR 3 0
ISO_SALES_TAX_CNTRY Country ISO code INTCA CHAR 2 0
REF_DOC_L Reference Document Number XBLNR_V CHAR 16 0
ASS_NUMBER Assignment number ORDNR_V CHAR 18 0
TAX_AMT_DOC_CURR Tax amount in document currency MWSBP CURR 13 2
LOG_SYSTEM Logical system LOGSYS CHAR 10 0
FLAG_BILL_DOC_CANC Billing document is cancelled FKSTO CHAR 1 0
X Yes
NULL No
EU_TRIANG_DEAL Indicator: Triangular deal within the EU ? XEGDR CHAR 1 0
X Yes
NULL No
NUM_PAY_CARD_PLAN Number of payment card plan type RPLNR CHAR 10 0
INT_FIN_DOC_NO Financial doc. processing: Internal financial doc. number LCNUM CHAR 10 0
TAX_TYPE Tax type J_1AFITP_D CHAR 2 0
TRANS_DATE Translation Date WWERT_D DATS 8 0
CURR_KEY_LET_CR_FT Currency key for letter-of-credit procg in foreign trade AKWAE CUKY 5 0
ISO_LET_CR_FT_CURR ISO code currency WAERS_ISO CHAR 3 0
EXCH_KEY_LET_CR_FT Exchange rate for letter-of-credit procg in foreign trade AKKUR DEC 9 5
PAYMENT_REF Payment Reference KIDNO CHAR 30 0
PARTNER_BK Partner Bank Type BVTYP CHAR 4 0
NUM_PG_INVOICE Number of pages of invoice J_1ANOPG NUMC 3 0
BUSS_PLACE CHAR 4 0
VKONT CHAR 12 0
DOC_STAT_ACC_TRAN CHAR 1 0
NRZAS CHAR 12 0