SAP table BAPICMS_VBRP (CMS BAPI structure for Billing Item data from R/3)

Field Description Data Type Length Decimals Checktable Data Element
OPERATION Function CHAR 3 0 MSGFN
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
018 Resend
023 Wait/Adjust: Do not import data
BILL_DOC Billing Document CHAR 10 0 VBELN_VF
BILL_ITEM_NO Billing Item NUMC 6 0 POSNR_VF
HG_LV_ITEM Higher-Level Item in Bill of Material Structures NUMC 6 0 UEPOS
INV_QTY Actual billed quantity QUAN 13 3 FKIMG
SALES_UNIT Sales unit UNIT 3 0 VRKME
ISO_SALES_UNIT Target quantity unit of measure in ISO code CHAR 3 0 ISO_ZIEME
SALES_QTY_NUM Numerator (factor) for conversion of sales quantity into SKU DEC 5 0 UMVKZ
SALES_QTY_DENOM Denominator (divisor) for conversion of sales Qty into SKU DEC 5 0 UMVKN
BASE_UOM Base Unit of Measure UNIT 3 0 MEINS
T_UNIT_ISO Target quantity unit of measure in ISO code CHAR 3 0 ISO_ZIEME
SCALE_QTY_BASE_UOM Scale Quantity in base unit of measure QUAN 13 3 SMENG
INV_QTY_SU Billing quantity in stock keeping unit QUAN 13 3 FKLMG
REQ_QUAN_MAT_MAN_ST_UN Required quantity for mat.management in stockkeeping units QUAN 13 3 LMENG
NET_WEIGHT Net weight QUAN 15 3 NTGEW_15
GROSS_WT Gross weight QUAN 15 3 BRGEW_15
UNIT_OF_WT Weight Unit UNIT 3 0 GEWEI
ISO_WT_UNIT Target quantity unit of measure in ISO code CHAR 3 0 ISO_ZIEME
VOLUME Volume QUAN 15 3 VOLUM_15
VOLUMEUNIT Volume unit UNIT 3 0 VOLEH
ISO_VOL_UNIT Target quantity unit of measure in ISO code CHAR 3 0 ISO_ZIEME
BUS_AREA Business Area CHAR 4 0 GSBER
PRICE_DATE Date for Pricing and Exchange Rate DATS 8 0 PRSDT
SERVICE_DATE Date on which services are rendered DATS 8 0 FBUDA
EXCHG_RATE Exchange Rate for Price Determination DEC 9 5 KURSK
NET_VAL Net Value of Billing item in Document Currency CURR 15 2 NETWR_FP
ORGION_DOC Originating Document CHAR 10 0 VBELV
ORGION_DOC_ITEM Originating Item NUMC 6 0 POSNV
REF_DOC Document number of the reference document CHAR 10 0 VGBEL
REF_DOC_IT Item number of the reference item NUMC 6 0 VGPOS
REF_DOC_CA SD Document Category CHAR 4 0 VBTYPL
# Revenue Recognition (Temporary)
$ (AFS)
& Warehouse Document
* Pick Order
+ Journal Entry (Temporary)
, Shipment Document
- Journal Entry (Temporary)
. Service Notification
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
: Service Order
A Inquiry
a Shipment Costs
b CRM Opportunity
B Quotation
BOS Service Entry Sheet
C Order
c Unverified Delivery
CEM ETM Shipping Document
CMMA Customer Management Master Agreement
CSCO Customer Management Service Confirmation
CSCT Customer Management Service Contract
CSVO Customer Management Service Order
D Item Proposal
d Trading Contract
e Allocation Table
E Scheduling Agreement
EBDR Billing Document Request
F Scheduling Agreement with External Service Agent
f001 Period-End Invoice
f002 Period-End Credit Memo
f003 Period-End Invoice (Intercompany Billing)
f004 Period-End Credit Memo (Intercompany Billing)
G Contract
g Rough Goods Receipt (only IS-Retail)
GBRQ Grants Management Billing Request
h Cancel Goods Issue
H Returns
i Goods Receipt
I Order Without Charge
J Delivery
j JIT Call
K Credit Memo Request
k Settlement Management Document
L Debit Memo Request
M Invoice
N Invoice Cancellation
n Reserved
O Credit Memo
o Reserved
P Debit Memo
p Goods Movement (Documentation)
PBD Preliminary Billing Document
PBDR Billing Document Request for Prof. Serv.
PBRQ Project Billing Request
q Reserved
Q WMS Transfer Order
R Goods Movement
r TD Transport (Only IS-Oil)
S Credit Memo Cancellation
s Load Confirmation, Reposting (Only IS-Oil)
SBRQ Subscription Billing Request
SOLO Solution Order
t Gain / Loss (Only IS-Oil)
T Returns Delivery for Order
TMFO Freight Order
TMFU Freight Unit
U Pro Forma Invoice
u Reentry into Storage (Only IS-Oil)
v Data Collation (Only IS-Oil)
V Purchase Order
W Independent Reqts Plan
w Reservation (Only IS-Oil)
X Handling Unit
x Load Confirmation, Goods Receipt (Only IS-Oil)
Y Rebate Agreement
^ Reserved
| Reserved
~ Revenue Cancellation (Temporary)
ยง Revenue Recognition/New View (Temporary)
DOC_NUMBER Sales Document CHAR 10 0 VBELN_VA
ITM_NUMBER Sales Document Item NUMC 6 0 POSNR_VA
FLAG_SALES_DOC_REF Sales document was created from reference CHAR 1 0 AUREF
MATERIAL Material Number (18 Characters) CHAR 18 0 MATNR18
SHORT_TEXT Short text for sales order item CHAR 40 0 ARKTX
PR_REF_MAT Pricing Reference Material CHAR 18 0 PMATN18
BATCH Batch Number CHAR 10 0 CHARG_D
MATL_GROUP Material Group CHAR 9 0 MATKL
ITEM_CATEG Sales document item category CHAR 4 0 PSTYV
ITEM_TYPE Item Type CHAR 1 0 POSAR
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 CHAR 18 0 PRODH_D
SHIP_POINT Shipping Point / Receiving Point CHAR 4 0 VSTEL
REPLACE_PT Replacement part CHAR 1 0 ATPKZ
No
A Optional substitute part
B Mandatory substitute part
DIVISION Division CHAR 2 0 SPART
ITEM_NUM_PART_SEG Item Number in the Partner Segment NUMC 6 0 POSPA
PLANT Plant CHAR 4 0 WERKS_D
DEPCOUNTRY Departure Country/Region (from which the goods are sent) CHAR 3 0 ALAND
ISO_DEP_COUNTRY ISO Code of the Country/Region CHAR 2 0 INTCA
WKREG Region in which plant is located CHAR 3 0 WKREG
WKCOU County in which plant is located CHAR 3 0 WKCOU
WKCTY City in which plant is located CHAR 4 0 WKCTY
TAXM1 Tax classification material CHAR 1 0 TAXM1
TAXM2 Tax Classification 2 for Material CHAR 1 0 TAXM2
TAXM3 Tax Classification 3 for Material CHAR 1 0 TAXM3
TAXM4 Tax Classification 4 for Material CHAR 1 0 TAXM4
TAXM5 Tax Classification 5 for Material CHAR 1 0 TAXM5
TAXM6 Tax Classification 6 for Material CHAR 1 0 TAXM6
TAXM7 Tax Classification 7 for Material CHAR 1 0 TAXM7
TAXM8 Tax Classification 8 for Material CHAR 1 0 TAXM8
TAXM9 Tax Classification 9 for Material CHAR 1 0 TAXM9
STAT_VAL Statistical Values CHAR 1 0 KOWRR
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 CHAR 1 0 PRSFD
No pricing
A Pricing for empties
B Pricing for free goods (100% discount)
X Pricing standard
CASH_DISC Cash Discount Indicator CHAR 1 0 SKTOF
ELG_AMT_CASH_DISC Amount eligible for cash discount in document currency CURR 13 2 SKFBP
MAT_PR_GRP Material Price Group CHAR 2 0 KONDM
ACCT_ASSGT Account Assignment Group for Material CHAR 2 0 KTGRM
COSTCENTER Cost Center CHAR 10 0 KOSTL
REBATE_GRP Volume rebate group CHAR 2 0 BONUS
COMM_GROUP Commission Group CHAR 2 0 PROVG
EUR_ART_NR European Article Number (EAN) - obsolete!!!!! CHAR 13 0 EANNR
SALES_GRP Sales group CHAR 3 0 VKGRP
SALES_OFF Sales office CHAR 4 0 VKBUR
DIV_ORD_HEADER Division for order header CHAR 2 0 SPART_AK
FLAG_RETURN_ITEM Returns item CHAR 1 0 SHKZG_VF
Outbound Message Processing
A Outbound - document flow negative
B Returns - document flow negative
X Returns
CREATED_BY Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
CR_ON Date on which the record was created DATS 8 0 ERDAT
REC_TIME Entry time TIMS 6 0 ERZET
VAL_TYPE Valuation Type CHAR 10 0 BWTAR_D
STGE_LOC Storage location CHAR 4 0 LGORT_D
UPDATE_GRP Update Group for statistics update CHAR 6 0 STAFO
COST_DOC_CURR Cost in Document Currency CURR 13 2 WAVWR
SUB_TOT_1_PP_COND Subtotal 1 from Pricing Procedure for Price Element CURR 13 2 KZWI1
SUB_TOT_2_PP_COND Subtotal 2 from Pricing Procedure for Price Element CURR 13 2 KZWI2
SUB_TOT_3_PP_COND Subtotal 3 from Pricing Procedure for Price Element CURR 13 2 KZWI3
SUB_TOT_4_PP_COND Subtotal 4 from Pricing Procedure for Price Element CURR 13 2 KZWI4
SUB_TOT_5_PP_COND Subtotal 5 from Pricing Procedure for Price Element CURR 13 2 KZWI5
SUB_TOT_6_PP_COND Subtotal 6 from Pricing Procedure for Price Element CURR 13 2 KZWI6
EXCH_RATE_STAT_CREATE Exchange rate for statistics (Exch.rate at time of creation) DEC 9 5 STCUR_AP
FLAG_INCOMP_PRICE Incomplete with respect to pricing CHAR 1 0 UVPRS
FLAG_INCOMP_GEN Generally incomplete CHAR 1 0 UVALL
EAN_UPC International Article Number (EAN/UPC) CHAR 18 0 EAN11
PROFIT_CTR Profit Center CHAR 10 0 PRCTR
CUST_GRP1 Customer Group 1 CHAR 3 0 KVGR1
CUST_GRP2 Customer Group 2 CHAR 3 0 KVGR2
CUST_GRP3 Customer Group 3 CHAR 3 0 KVGR3
CUST_GRP4 Customer Group 4 CHAR 3 0 KVGR4
CUST_GRP5 Customer Group 5 CHAR 3 0 KVGR5
PRC_GROUP1 Material Group 1 CHAR 3 0 MVGR1
PRC_GROUP2 Material Group 2 CHAR 3 0 MVGR2
PRC_GROUP3 Material Group 3 CHAR 3 0 MVGR3
PRC_GROUP4 Material Group 4 CHAR 3 0 MVGR4
PRC_GROUP5 Material Group 5 CHAR 3 0 MVGR5
MAT_ENTRD Material entered CHAR 18 0 MATWA18
BONBA Rebate Basis 1 CURR 13 2 BONBA
CO_AREA Controlling Area CHAR 4 0 KOKRS
PROFIT_SEGM_NO Profitability Segment Number (CO-PA) NUMC 10 0 RKEOBJNR
WBS_ELEM Work Breakdown Structure Element (WBS Element) NUMC 8 0 PS_PSP_PNR
ORDERID Order Number CHAR 12 0 AUFNR
TAXJURCODE Tax Jurisdiction CHAR 15 0 TXJCD
ITEM_CR_PRICE Item credit price CURR 11 2 CMPRE
ITEM_ID_ACTV_REL_CR ID: Item with active credit function / relevant for credit CHAR 1 0 CMPNT
CONFIGURATION Configuration NUMC 18 0 CUOBJ_VA
INT_OBJ_BATCH_CLASS Internal object number of the batch classification NUMC 18 0 CUOBJ_CH
COND_UPDAT Condition Update CHAR 1 0 KOUPD
HIGH_ITEM_BATCH_SPLIT Higher-Level Item of Batch Split Item NUMC 6 0 UECHA
IND_BTCH Batch management indicator (internal) CHAR 1 0 XCHAR
DLVSCHEDUSE_01 Usage Indicator CHAR 3 0 ABRVW
BOMEXPL_NO BOM explosion number CHAR 8 0 SERNR
SALES_DIST_SO Sales district of sales order CHAR 6 0 BZIRK_AUFT
CUST_GRP_SO Customer group of sales order CHAR 2 0 KDGRP_AUFT
PRICE_GRP_SO Price group of sales order CHAR 2 0 KONDA_AUFT
COUNT_DEST_SO Destination Country/Region of Sales Order CHAR 3 0 LLAND_AUFT
ISO_SO_COUN_DEST ISO Code of the Country/Region CHAR 2 0 INTCA
STAT_MAP_PRICE_CHNG Status manual price change CHAR 1 0 MPROK
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 CHAR 2 0 PLTYP_AUFT
REGION_SO Region of Sales Order CHAR 3 0 REGIO_AUFT
SALE_ORG_SO Sales organization of sales order CHAR 4 0 VKORG_AUFT
DIS_CHANNEL_SO Distribution channel of sales order CHAR 2 0 VTWEG_AUFT
START_DATE_ACC_SET_PER Start of accounting settlement period DATS 8 0 ABRBG
ID_MAT_SEL_ACTIVE ID for material determination CHAR 1 0 PROSA
No product selection
A Replaced item
B Replacement item
ID_HIGH_LEV_ITM_USG ID for higher-level item usage CHAR 1 0 UEPVW
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 CHAR 4 0 VBTYPL
# Revenue Recognition (Temporary)
$ (AFS)
& Warehouse Document
* Pick Order
+ Journal Entry (Temporary)
, Shipment Document
- Journal Entry (Temporary)
. Service Notification
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
: Service Order
A Inquiry
a Shipment Costs
b CRM Opportunity
B Quotation
BOS Service Entry Sheet
C Order
c Unverified Delivery
CEM ETM Shipping Document
CMMA Customer Management Master Agreement
CSCO Customer Management Service Confirmation
CSCT Customer Management Service Contract
CSVO Customer Management Service Order
D Item Proposal
d Trading Contract
e Allocation Table
E Scheduling Agreement
EBDR Billing Document Request
F Scheduling Agreement with External Service Agent
f001 Period-End Invoice
f002 Period-End Credit Memo
f003 Period-End Invoice (Intercompany Billing)
f004 Period-End Credit Memo (Intercompany Billing)
G Contract
g Rough Goods Receipt (only IS-Retail)
GBRQ Grants Management Billing Request
h Cancel Goods Issue
H Returns
i Goods Receipt
I Order Without Charge
J Delivery
j JIT Call
K Credit Memo Request
k Settlement Management Document
L Debit Memo Request
M Invoice
N Invoice Cancellation
n Reserved
O Credit Memo
o Reserved
P Debit Memo
p Goods Movement (Documentation)
PBD Preliminary Billing Document
PBDR Billing Document Request for Prof. Serv.
PBRQ Project Billing Request
q Reserved
Q WMS Transfer Order
R Goods Movement
r TD Transport (Only IS-Oil)
S Credit Memo Cancellation
s Load Confirmation, Reposting (Only IS-Oil)
SBRQ Subscription Billing Request
SOLO Solution Order
t Gain / Loss (Only IS-Oil)
T Returns Delivery for Order
TMFO Freight Order
TMFU Freight Unit
U Pro Forma Invoice
u Reentry into Storage (Only IS-Oil)
v Data Collation (Only IS-Oil)
V Purchase Order
W Independent Reqts Plan
w Reservation (Only IS-Oil)
X Handling Unit
x Load Confirmation, Goods Receipt (Only IS-Oil)
Y Rebate Agreement
^ Reserved
| Reserved
~ Revenue Cancellation (Temporary)
ยง Revenue Recognition/New View (Temporary)
STAT_DATE Statistics date DATS 8 0 STADAT
BILL_PLAN Billing plan number / invoicing plan number CHAR 10 0 FPLNR
BILL_PLAN_ITEM Item for billing plan/invoice plan/payment cards NUMC 6 0 FPLTR
ACTION Promotion CHAR 10 0 WAKTION
PROMOTION Sales Promotion CHAR 10 0 KNUMA_PI
SALES_DEAL Sales Deal CHAR 10 0 KNUMA_AG
IND_PREF_IMP_EXP Customs Preference CHAR 1 0 PREFE
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 CURR 13 2 MWSBP
ORD_REASON Order Reason (Reason for the Business Transaction) CHAR 3 0 AUGRU
RULE_BILL_INV Rule in billing plan/invoice plan CHAR 1 0 FAREG
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 CHAR 18 0 UPMAT18
MAT_PRC_GRP_MAN_ITEM Material pricing group of main item CHAR 2 0 UKONM
ITEM_CR_PRICE_FLT Item Credit Price FLTP 16 16 CMPRE_FLT
FORM_PAY_GUAR Form of payment guarantee CHAR 2 0 ABSFORM_CM
FACTOR_GUAR Guaranteed (factor between 0 and 1) FLTP 16 16 ABGES_CM
REASON_ZERO_VAT Reason for Zero VAT CHAR 1 0 J_1ARFZVAT
REGION Region (State, Province, County) CHAR 3 0 REGIO
ACT_CODE_GROSS_EMP_TAX Activity Code for Gross Income Tax CHAR 2 0 J_1AGICD_D
DIST_TYP_EMP_TAX Distribution Type for Employment Tax CHAR 2 0 J_1ADTYP_D
TAX_REL_CLASS Tax relevant classification CHAR 10 0 J_1ATXREL_
CFOP_CODE_EXTN CHAR 10 0
ICMS_TAX_LAW Tax law: ICMS CHAR 3 0 J_1BTAXLW1
IPI_TAX_LAW Tax law: IPI CHAR 3 0 J_1BTAXLW2
SD_TAX_CODE SD tax code CHAR 2 0 J_1BTXSDC_
GROSS_VAL_BILL_ITEM Gross Value of the Billing Item in Document Currency CURR 15 2 BRTWR_FP
WKTNR Value Contract No. CHAR 10 0 WKTNR
WKTPS Value Contract Item NUMC 6 0 WKTPS
PAY_CARD_PLAN_NO_SD Payment card plan number of sales document CHAR 10 0 RPLNR_AU
TRANS_DATE Translation date DATS 8 0 WWERT_D
MAT_GRP_HIER1 Material group hierarchy 1 CHAR 18 0 WGRU_HIE1
MAT_GRP_HIER2 Material group hierarchy 2 CHAR 18 0 WGRU_HIE2
CUST_COND_GRP1 Customer condition group 1 CHAR 2 0 KDKG1
CUST_COND_GRP2 Customer condition group 2 CHAR 2 0 KDKG2
CUST_COND_GRP3 Customer condition group 3 CHAR 2 0 KDKG3
CUST_COND_GRP4 Customer condition group 4 CHAR 2 0 KDKG4
CUST_COND_GRP5 Customer condition group 5 CHAR 2 0 KDKG5
DLVSCHEDUSE_02 Usage Indicator CHAR 3 0 ABRVW
INFLATION_INDEX Inflation Index CHAR 5 0 J_1AINDXP
INDEX_BASE_DATE Indexing base date DATS 8 0 J_1AIDATES
FLG_LEAD_UNIT ID: Leading unit of measure for completing a transaction CHAR 1 0 KZFME
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 CHAR 2 0 MWSKZ
CONTRACT_TYPE Contract Type CHAR 1 0 RANTYP
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
B Bank Accounts
E Exposures
T Trade Finance
V Contract Management - Consumer Products
X External Accounts
Y Reserved for Customer Enhancements
Z Reserved for Customer Enhancements
CONTRACT_NUM Contract Number CHAR 13 0 RANL
ITEM_TEXT Item Text CHAR 50 0 SGTXT
AGREED_DEL_TIME Agreed Delivery Time CHAR 3 0 DELCO
CALC_MOTIVE Accounting Indicator CHAR 2 0 BEMOT
REVENUE_TYPE CHAR 1 0
EXCH_RATE_LET_CR Exchange rate for letter-of-credit procg in foreign trade DEC 9 5 AKKUR
PRODCAT Product catalog number CHAR 10 0 WMINR
REF_DOC_EX Document number of the reference document CHAR 10 0 VGBEL
REF_DOC_IT_EX Item number of the reference item NUMC 6 0 VGPOS
LOG_SYSTEM Logical system CHAR 10 0 LOGSYS
ACT_ELEM_CAT_EX CHAR 3 0
SD_DOC_TYP Sales Document Type CHAR 4 0 AUART
SD_ITM_CAT Sales document item category CHAR 4 0 PSTYV
MATERIAL_LONG Material No. CHAR 40 0 MATNR40
PR_REF_MAT_LONG Pricing Reference Material CHAR 40 0 PMATN40
MAT_ENTRD_LONG Material entered CHAR 40 0 MATWA40
PRIC_REF_MAT_MAIN_ITEM_LONG Pricing reference material of main item CHAR 40 0 UPMAT40