1. Home
  2. Resources
  3. SAP Tables
  4. BAPICMS_VBRP - CMS BAPI structure for Billing Item data from R/3

SAP Table BAPICMS_VBRP

CMS BAPI structure for Billing Item data from R/3

BAPICMS_VBRP (CMS BAPI structure for Billing Item 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_VBRP to other SAP tables.

BAPICMS_VBRP 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_ITEM_NO Billing item POSNR_VF NUMC 6 0
HG_LV_ITEM Higher-level item in bill of material structures UEPOS NUMC 6 0
INV_QTY Actual Invoiced Quantity FKIMG QUAN 13 3
SALES_UNIT Sales unit VRKME UNIT 3 0
ISO_SALES_UNIT Target quantity unit of measure in ISO code ISO_ZIEME CHAR 3 0
SALES_QTY_NUM Numerator (factor) for conversion of sales quantity into SKU UMVKZ DEC 5 0
SALES_QTY_DENOM Denominator (Divisor) for Conversion of Sales Qty into SKU UMVKN DEC 5 0
BASE_UOM Base Unit of Measure MEINS UNIT 3 0
T_UNIT_ISO Target quantity unit of measure in ISO code ISO_ZIEME CHAR 3 0
SCALE_QTY_BASE_UOM Scale quantity in base unit of measure SMENG QUAN 13 3
INV_QTY_SU Billing quantity in stockkeeping unit FKLMG QUAN 13 3
REQ_QUAN_MAT_MAN_ST_UN Required quantity for mat.management in stockkeeping units LMENG QUAN 13 3
NET_WEIGHT Net weight NTGEW_15 QUAN 15 3
GROSS_WT Gross weight BRGEW_15 QUAN 15 3
UNIT_OF_WT Weight Unit GEWEI UNIT 3 0
ISO_WT_UNIT Target quantity unit of measure in ISO code ISO_ZIEME CHAR 3 0
VOLUME Volume VOLUM_15 QUAN 15 3
VOLUMEUNIT Volume unit VOLEH UNIT 3 0
ISO_VOL_UNIT Target quantity unit of measure in ISO code ISO_ZIEME CHAR 3 0
BUS_AREA Business Area GSBER CHAR 4 0
PRICE_DATE Date for pricing and exchange rate PRSDT DATS 8 0
SERVICE_DATE Date on which services rendered FBUDA DATS 8 0
EXCHG_RATE Exchange Rate for Price Determination KURSK DEC 9 5
NET_VAL Net value of the billing item in document currency NETWR_FP CURR 15 2
ORGION_DOC Originating document VBELV CHAR 10 0
ORGION_DOC_ITEM Originating item POSNV NUMC 6 0
REF_DOC Document number of the reference document VGBEL CHAR 10 0
REF_DOC_IT Item number of the reference item VGPOS NUMC 6 0
REF_DOC_CA Document category of preceding SD document VBTYP_V 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
DOC_NUMBER Sales Document VBELN_VA CHAR 10 0
ITM_NUMBER Sales Document Item POSNR_VA NUMC 6 0
FLAG_SALES_DOC_REF Sales document was created from reference AUREF CHAR 1 0
X Yes
NULL No
MATERIAL Material Number MATNR CHAR 18 0
SHORT_TEXT Short text for sales order item ARKTX CHAR 40 0
PR_REF_MAT Pricing Reference Material PMATN CHAR 18 0
BATCH Batch Number CHARG_D CHAR 10 0
MATL_GROUP Material Group MATKL CHAR 9 0
ITEM_CATEG Sales document item category PSTYV CHAR 4 0
ITEM_TYPE Item type POSAR CHAR 1 0
NULL Standard Item
A Value Item
B Text item
C Packing item (will be generated)
D Material not relevant
E Packaging Item (External)
PROD_HIER Product hierarchy PRODH_D CHAR 18 0
SHIP_POINT Shipping Point/Receiving Point VSTEL CHAR 4 0
REPLACE_PT Replacement part ATPKZ CHAR 1 0
NULL No
A Optional substitute part
B Mandatory substitute part
DIVISION Division SPART CHAR 2 0
ITEM_NUM_PART_SEG Item number in the partner segment POSPA NUMC 6 0
PLANT Plant WERKS_D CHAR 4 0
DEPCOUNTRY Departure country (country from which the goods are sent) ALAND CHAR 3 0
ISO_DEP_COUNTRY Country ISO code INTCA CHAR 2 0
WKREG Region in which plant is located WKREG CHAR 3 0
WKCOU County in which plant is located WKCOU CHAR 3 0
WKCTY City in which plant is located WKCTY CHAR 4 0
TAXM1 Tax classification material TAXM1 CHAR 1 0
TAXM2 Tax classification 2 for material TAXM2 CHAR 1 0
TAXM3 Tax classification 3 for material TAXM3 CHAR 1 0
TAXM4 Tax Classification 4 Material TAXM4 CHAR 1 0
TAXM5 Tax classification 5 for material TAXM5 CHAR 1 0
TAXM6 Tax classification 6 for material TAXM6 CHAR 1 0
TAXM7 Tax classification 7 for material TAXM7 CHAR 1 0
TAXM8 Tax Classification 8 Material TAXM8 CHAR 1 0
TAXM9 Tax Classification 9 Material TAXM9 CHAR 1 0
STAT_VAL Statistical values KOWRR CHAR 1 0
NULL System will copy item to header totals
X No cumulation - Values cannot be used statistically
Y No cumulation - Values can be used statistically
FLAG_CARRY_PRICE Carry out pricing PRSFD CHAR 1 0
NULL No pricing
X Pricing standard
A Pricing for empties
B Pricing for free goods (100% discount)
CASH_DISC Cash discount indicator SKTOF CHAR 1 0
X Yes
NULL No
ELG_AMT_CASH_DISC Amount eligible for cash discount in document currency SKFBP CURR 13 2
MAT_PR_GRP Material Pricing Group KONDM CHAR 2 0
ACCT_ASSGT Account assignment group for this material KTGRM CHAR 2 0
COSTCENTER Cost Center KOSTL CHAR 10 0
REBATE_GRP Volume rebate group BONUS CHAR 2 0
COMM_GROUP Commission group PROVG CHAR 2 0
EUR_ART_NR European Article Number (EAN) - obsolete!!!!! EANNR CHAR 13 0
SALES_GRP Sales Group VKGRP CHAR 3 0
SALES_OFF Sales Office VKBUR CHAR 4 0
DIV_ORD_HEADER Division for order header SPART_AK CHAR 2 0
FLAG_RETURN_ITEM Returns item SHKZG_VF CHAR 1 0
NULL Outbound Message Processing
A Outbound - document flow negative
B Returns - document flow negative
X Returns
CREATED_BY Name of Person who Created the Object ERNAM CHAR 12 0
CR_ON Date on Which Record Was Created ERDAT DATS 8 0
REC_TIME Entry time ERZET TIMS 6 0
VAL_TYPE Valuation Type BWTAR_D CHAR 10 0
STGE_LOC Storage Location LGORT_D CHAR 4 0
UPDATE_GRP Update group for statistics update STAFO CHAR 6 0
COST_DOC_CURR Cost in document currency WAVWR CURR 13 2
SUB_TOT_1_PP_COND Subtotal 1 from pricing procedure for condition KZWI1 CURR 13 2
SUB_TOT_2_PP_COND Subtotal 2 from pricing procedure for condition KZWI2 CURR 13 2
SUB_TOT_3_PP_COND Subtotal 3 from pricing procedure for condition KZWI3 CURR 13 2
SUB_TOT_4_PP_COND Subtotal 4 from pricing procedure for condition KZWI4 CURR 13 2
SUB_TOT_5_PP_COND Subtotal 5 from pricing procedure for condition KZWI5 CURR 13 2
SUB_TOT_6_PP_COND Subtotal 6 from pricing procedure for condition KZWI6 CURR 13 2
EXCH_RATE_STAT_CREATE Exchange rate for statistics (Exch.rate at time of creation) STCUR_AP DEC 9 5
FLAG_INCOMP_PRICE Incomplete with respect to pricing UVPRS CHAR 1 0
X Yes
NULL No
FLAG_INCOMP_GEN Generally incomplete UVALL CHAR 1 0
X Yes
NULL No
EAN_UPC International Article Number (EAN/UPC) EAN11 CHAR 18 0
PROFIT_CTR Profit Center PRCTR CHAR 10 0
CUST_GRP1 Customer group 1 KVGR1 CHAR 3 0
CUST_GRP2 Customer group 2 KVGR2 CHAR 3 0
CUST_GRP3 Customer group 3 KVGR3 CHAR 3 0
CUST_GRP4 Customer group 4 KVGR4 CHAR 3 0
CUST_GRP5 Customer group 5 KVGR5 CHAR 3 0
PRC_GROUP1 Material group 1 MVGR1 CHAR 3 0
PRC_GROUP2 Material group 2 MVGR2 CHAR 3 0
PRC_GROUP3 Material group 3 MVGR3 CHAR 3 0
PRC_GROUP4 Material group 4 MVGR4 CHAR 3 0
PRC_GROUP5 Material group 5 MVGR5 CHAR 3 0
MAT_ENTRD Material entered MATWA CHAR 18 0
BONBA Rebate basis 1 BONBA CURR 13 2
CO_AREA Controlling Area KOKRS CHAR 4 0
PROFIT_SEGM_NO Profitability Segment Number (CO-PA) RKEOBJNR NUMC 10 0
WBS_ELEM Work Breakdown Structure Element (WBS Element) PS_PSP_PNR NUMC 8 0
ORDERID Order Number AUFNR CHAR 12 0
TAXJURCODE Tax Jurisdiction TXJCD CHAR 15 0
ITEM_CR_PRICE Item credit price CMPRE CURR 11 2
ITEM_ID_ACTV_REL_CR ID: Item with active credit function / relevant for credit CMPNT CHAR 1 0
X Yes
NULL No
CONFIGURATION Configuration CUOBJ_VA NUMC 18 0
INT_OBJ_BATCH_CLASS Internal object number of the batch classification CUOBJ_CH NUMC 18 0
COND_UPDAT Condition update KOUPD CHAR 1 0
X Yes
NULL No
HIGH_ITEM_BATCH_SPLIT Higher-Level Item of Batch Split Item UECHA NUMC 6 0
IND_BTCH Batch management indicator (internal) XCHAR CHAR 1 0
X Yes
NULL No
DLVSCHEDUSE_01 Usage Indicator ABRVW CHAR 3 0
BOMEXPL_NO BOM explosion number SERNR CHAR 8 0
SALES_DIST_SO Sales district of sales order BZIRK_AUFT CHAR 6 0
CUST_GRP_SO Customer group of sales order KDGRP_AUFT CHAR 2 0
PRICE_GRP_SO Price group of sales order KONDA_AUFT CHAR 2 0
COUNT_DEST_SO Country of destination of sales order LLAND_AUFT CHAR 3 0
ISO_SO_COUN_DEST Country ISO code INTCA CHAR 2 0
STAT_MAP_PRICE_CHNG Status manual price change MPROK CHAR 1 0
NULL No manual price change
A Manual price change carried out
B Condition manually deleted
C Manual price change released
PRICE_LIST_TYPE_SO Price list type of sales order PLTYP_AUFT CHAR 2 0
REGION_SO Region of sales order REGIO_AUFT CHAR 3 0
SALE_ORG_SO Sales organization of sales order VKORG_AUFT CHAR 4 0
DIS_CHANNEL_SO Distribution channel of sales order VTWEG_AUFT CHAR 2 0
START_DATE_ACC_SET_PER Start of accounting settlement period ABRBG DATS 8 0
ID_MAT_SEL_ACTIVE ID for material determination PROSA CHAR 1 0
NULL No product selection
A Replaced item
B Replacement item
ID_HIGH_LEV_ITM_USG ID for higher-level item usage UEPVW CHAR 1 0
A Product selection
B Free goods (inclusive bonus)
C Free goods (on-top bonus)
D Repairs
E ** unused **
F Cross selling
G Complete goods (purchase order)
H Automotive (subitem)
I CRM Repairs
K Kit Component
R Replacement Kit Component
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
STAT_DATE Statistics date STADAT DATS 8 0
BILL_PLAN Billing plan number / invoicing plan number FPLNR CHAR 10 0
BILL_PLAN_ITEM Item for billing plan/invoice plan/payment cards FPLTR NUMC 6 0
ACTION Promotion WAKTION CHAR 10 0
PROMOTION Promotion KNUMA_PI CHAR 10 0
SALES_DEAL Sales deal KNUMA_AG CHAR 10 0
IND_PREF_IMP_EXP Preference indicator in export/import PREFE CHAR 1 0
A Not checked
B Checked - price influenced
C Generally allowed
D Generally not allowed
E Authorized for preference: set manually
F Not authorized for preference: component of mixed origins
TAX_AMT_DOC_CURR Tax amount in document currency MWSBP CURR 13 2
ORD_REASON Order reason (reason for the business transaction) AUGRU CHAR 3 0
RULE_BILL_INV Rule in billing plan/invoice plan FAREG CHAR 1 0
1 Milestone billing on a percentage basis
2 Milestone billing on a value basis
3 Closing invoice in milestone billing
4 Down payment in milestone billing on percentage basis
5 Down payment in milestone billing on a value basis
6 Periodic billing (rent)
PRIC_REF_MAT_MAIN_ITEM Pricing reference material of main item UPMAT CHAR 18 0
MAT_PRC_GRP_MAN_ITEM Material pricing group of main item UKONM CHAR 2 0
ITEM_CR_PRICE_FLT Item credit price CMPRE_FLT FLTP 16 16
FORM_PAY_GUAR Form of payment guarantee ABSFORM_CM CHAR 2 0
FACTOR_GUAR Guaranteed (factor between 0 and 1) ABGES_CM FLTP 16 16
REASON_ZERO_VAT Reason for zero VAT J_1ARFZVAT CHAR 1 0
REGION Region (State, Province, County) REGIO CHAR 3 0
ACT_CODE_GROSS_EMP_TAX Activity Code for Gross Income Tax J_1AGICD_D CHAR 2 0
DIST_TYP_EMP_TAX Distribution Type for Employment Tax J_1ADTYP_D CHAR 2 0
TAX_REL_CLASS Tax relevant classification J_1ATXREL_ CHAR 10 0
CFOP_CODE_EXTN CHAR 10 0
ICMS_TAX_LAW Tax law: ICMS J_1BTAXLW1 CHAR 3 0
IPI_TAX_LAW Tax law: IPI J_1BTAXLW2 CHAR 3 0
SD_TAX_CODE SD tax code J_1BTXSDC_ CHAR 2 0
GROSS_VAL_BILL_ITEM Gross value of the billing item in document currency BRTWR_FP CURR 15 2
WKTNR Value contract no. WKTNR CHAR 10 0
WKTPS Value contract item WKTPS NUMC 6 0
PAY_CARD_PLAN_NO_SD Payment card plan number of sales document RPLNR_AU CHAR 10 0
TRANS_DATE Translation Date WWERT_D DATS 8 0
MAT_GRP_HIER1 Material group hierarchy 1 WGRU_HIE1 CHAR 18 0
MAT_GRP_HIER2 Material group hierarchy 2 WGRU_HIE2 CHAR 18 0
CUST_COND_GRP1 Customer condition group 1 KDKG1 CHAR 2 0
CUST_COND_GRP2 Customer condition group 2 KDKG2 CHAR 2 0
CUST_COND_GRP3 Customer condition group 3 KDKG3 CHAR 2 0
CUST_COND_GRP4 Customer condition group 4 KDKG4 CHAR 2 0
CUST_COND_GRP5 Customer condition group 5 KDKG5 CHAR 2 0
DLVSCHEDUSE_02 Usage Indicator ABRVW CHAR 3 0
INFLATION_INDEX Inflation Index J_1AINDXP CHAR 5 0
INDEX_BASE_DATE Indexing base date J_1AIDATES DATS 8 0
FLG_LEAD_UNIT ID: Leading unit of measure for completing a transaction KZFME CHAR 1 0
NULL Base Unit of Measure has Priority
A Proportional Unit has Priority (Active Ingredient)
B Product Unit of Measure has Priority (Steel)
TAX_CODE Tax on sales/purchases code MWSKZ CHAR 2 0
CONTRACT_TYPE Contract Type RANTYP CHAR 1 0
1 Loans
2 Securities
3 Lease-Out - Real Estate
4 Foreign Exchange
5 Money Market
6 Derivatives
7 Open Item Transactions
8 Administration Contract - Real Estate
9 General Contract - Real Estate
A Internal use only
Y Reserved for Customer Enhancements
Z Reserved for Customer Enhancements
V Contract Management - Consumer Products
X External Accounts
E Exposure Position
CONTRACT_NUM Contract Number RANL CHAR 13 0
ITEM_TEXT Item Text SGTXT CHAR 50 0
AGREED_DEL_TIME Agreed delivery time DELCO CHAR 3 0
CALC_MOTIVE Accounting Indicator BEMOT CHAR 2 0
REVENUE_TYPE CHAR 1 0
EXCH_RATE_LET_CR Exchange rate for letter-of-credit procg in foreign trade AKKUR DEC 9 5
PRODCAT Product catalog number WMINR CHAR 10 0
REF_DOC_EX Document number of the reference document VGBEL CHAR 10 0
REF_DOC_IT_EX Item number of the reference item VGPOS NUMC 6 0
LOG_SYSTEM Logical system LOGSYS CHAR 10 0
ACT_ELEM_CAT_EX CHAR 3 0
SD_DOC_TYP Sales Document Type AUART CHAR 4 0
SD_ITM_CAT Sales document item category PSTYV CHAR 4 0