SAP table VBRP (Billing Document: Item Data)

SAP Table VBRP (Billing Document: Item Data) is part of the Sales and Distribution (SD) module in SAP. It stores detailed information about individual items in billing documents, such as materials, quantities, pricing, taxes, and delivery-related data. Each record in VBRP represents an item within a billing document (linked to header data in table VBRK) and includes fields for item-specific details like material number, billing quantity, and net value. VBRP is essential for invoice processing and serves as a key table for financial reporting and reconciliation in SAP.

SAP table VBRP has 3 primary key fields being MANDT,VBELN,POSNR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
VBELN Billing Document CHAR 10 0 VBRK VBELN_VF
POSNR Billing Item NUMC 6 0 POSNR_VF
UEPOS Higher-Level Item in Bill of Material Structures NUMC 6 0 UEPOS
FKIMG Actual billed quantity QUAN 13 3 FKIMG
VRKME Sales unit UNIT 3 0 T006 VRKME
UMVKZ Numerator (factor) for conversion of sales quantity into SKU DEC 5 0 UMVKZ
UMVKN Denominator (divisor) for conversion of sales Qty into SKU DEC 5 0 UMVKN
MEINS Base Unit of Measure UNIT 3 0 T006 MEINS
SMENG Scale Quantity in base unit of measure QUAN 13 3 SMENG
FKLMG Billing quantity in stock keeping unit QUAN 13 3 FKLMG
LMENG Required quantity for mat.management in stockkeeping units QUAN 13 3 LMENG
NTGEW Net weight QUAN 15 3 NTGEW_15
BRGEW Gross weight QUAN 15 3 BRGEW_15
GEWEI Weight Unit UNIT 3 0 T006 GEWEI
VOLUM Volume QUAN 15 3 VOLUM_15
VOLEH Volume unit UNIT 3 0 T006 VOLEH
GSBER Business Area CHAR 4 0 TGSB GSBER
PRSDT Date for Pricing and Exchange Rate DATS 8 0 PRSDT
FBUDA Date on which services are rendered DATS 8 0 FBUDA
KURSK Exchange Rate for Price Determination DEC 9 5 KURSK
NETWR Net Value of Billing item in Document Currency CURR 15 2 NETWR_FP
VBELV Originating Document CHAR 10 0 VBELV
POSNV Originating Item NUMC 6 0 POSNV
VGBEL Document number of the reference document CHAR 10 0 VGBEL
VGPOS Item number of the reference item NUMC 6 0 VGPOS
VGTYP Document Category of Preceding SD Document CHAR 4 0 VBTYPL_V
AUBEL Sales Document CHAR 10 0 VBAK VBELN_VA
AUPOS Sales Document Item NUMC 6 0 VBAP POSNR_VA
AUREF Sales document was created from reference CHAR 1 0 AUREF
MATNR Material Number CHAR 40 0 MARA MATNR
ARKTX Short text for sales order item CHAR 40 0 ARKTX
PMATN Pricing Reference Material CHAR 40 0 MARA PMATN
CHARG Batch Number CHAR 10 0 MCHA CHARG_D
MATKL Material Group CHAR 9 0 T023 MATKL
PSTYV Sales document item category CHAR 4 0 PSTYV
POSAR 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)
PRODH Product hierarchy CHAR 18 0 T179 PRODH_D
VSTEL Shipping Point / Receiving Point CHAR 4 0 TVST VSTEL
ATPKZ Replacement part CHAR 1 0 ATPKZ
No
A Optional substitute part
B Mandatory substitute part
SPART Division CHAR 2 0 TSPA SPART
POSPA Item Number in the Partner Segment NUMC 6 0 VBRP POSPA
WERKS Plant CHAR 4 0 T001W WERKS_D
ALAND Departure Country/Region (from which the goods are sent) CHAR 3 0 T005 ALAND
WKREG Region in which plant is located CHAR 3 0 T005S 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
KOWRR 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
PRSFD Carry out pricing CHAR 1 0 PRSFD
No pricing
A Pricing for empties
B Pricing for free goods (100% discount)
X Pricing standard
SKTOF Cash Discount Indicator CHAR 1 0 SKTOF
SKFBP Amount eligible for cash discount in document currency CURR 13 2 SKFBP
KONDM Material Price Group CHAR 2 0 T178 KONDM
KTGRM Account Assignment Group for Material CHAR 2 0 TVKM KTGRM
KOSTL Cost Center CHAR 10 0 KOSTL
BONUS Volume rebate group CHAR 2 0 TVBO BONUS
PROVG Commission Group CHAR 2 0 TVPR PROVG
EANNR European Article Number (EAN) - obsolete!!!!! CHAR 13 0 EANNR
VKGRP Sales group CHAR 3 0 TVKGR VKGRP
VKBUR Sales office CHAR 4 0 TVBUR VKBUR
SPARA Division for order header CHAR 2 0 TSPA SPART_AK
SHKZG Returns item CHAR 1 0 SHKZG_VF
Outbound Message Processing
A Outbound - document flow negative
B Returns - document flow negative
X Returns
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
ERDAT Date on which the record was created DATS 8 0 ERDAT
ERZET Entry time TIMS 6 0 ERZET
BWTAR Valuation Type CHAR 10 0 T149D BWTAR_D
LGORT Storage location CHAR 4 0 T001L LGORT_D
STAFO Update Group for statistics update CHAR 6 0 STAFO
WAVWR Cost in Document Currency CURR 13 2 WAVWR
KZWI1 Subtotal 1 from Pricing Procedure for Price Element CURR 13 2 KZWI1
KZWI2 Subtotal 2 from Pricing Procedure for Price Element CURR 13 2 KZWI2
KZWI3 Subtotal 3 from Pricing Procedure for Price Element CURR 13 2 KZWI3
KZWI4 Subtotal 4 from Pricing Procedure for Price Element CURR 13 2 KZWI4
KZWI5 Subtotal 5 from Pricing Procedure for Price Element CURR 13 2 KZWI5
KZWI6 Subtotal 6 from Pricing Procedure for Price Element CURR 13 2 KZWI6
STCUR Exchange rate for statistics (Exch.rate at time of creation) DEC 9 5 STCUR_AP
UVPRS Incomplete with respect to pricing CHAR 1 0 UVPRS
UVALL Generally incomplete CHAR 1 0 UVALL
EAN11 International Article Number (EAN/UPC) CHAR 18 0 EAN11
PRCTR Profit Center CHAR 10 0 PRCTR
KVGR1 Customer Group 1 CHAR 3 0 TVV1 KVGR1
KVGR2 Customer Group 2 CHAR 3 0 TVV2 KVGR2
KVGR3 Customer Group 3 CHAR 3 0 TVV3 KVGR3
KVGR4 Customer Group 4 CHAR 3 0 TVV4 KVGR4
KVGR5 Customer Group 5 CHAR 3 0 TVV5 KVGR5
MVGR1 Material Group 1 CHAR 3 0 TVM1 MVGR1
MVGR2 Material Group 2 CHAR 3 0 TVM2 MVGR2
MVGR3 Material Group 3 CHAR 3 0 TVM3 MVGR3
MVGR4 Material Group 4 CHAR 3 0 TVM4 MVGR4
MVGR5 Material Group 5 CHAR 3 0 TVM5 MVGR5
MATWA Material Entered CHAR 40 0 MARA MATWA
BONBA Rebate Basis 1 CURR 13 2 BONBA
KOKRS Controlling Area CHAR 4 0 TKA01 KOKRS
PAOBJNR Profitability Segment Number (CO-PA) NUMC 10 0 RKEOBJNR
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) NUMC 8 0 PS_PSP_PNR
AUFNR Order Number CHAR 12 0 AUFK AUFNR
TXJCD Tax Jurisdiction CHAR 15 0 TXJCD
CMPRE Item credit price CURR 11 2 CMPRE
CMPNT ID: Item with active credit function / relevant for credit CHAR 1 0 CMPNT
CUOBJ Configuration NUMC 18 0 CUOBJ_VA
CUOBJ_CH Internal object number of the batch classification NUMC 18 0 CUOBJ_CH
KOUPD Condition Update CHAR 1 0 KOUPD
UECHA Higher-Level Item of Batch Split Item NUMC 6 0 UECHA
XCHAR Batch management indicator (internal) CHAR 1 0 XCHAR
ABRVW Usage Indicator CHAR 3 0 TVLV ABRVW
SERNR BOM explosion number CHAR 8 0 SNUM SERNR
BZIRK_AUFT Sales district of sales order CHAR 6 0 T171 BZIRK_AUFT
KDGRP_AUFT Customer group of sales order CHAR 2 0 T151 KDGRP_AUFT
KONDA_AUFT Price group of sales order CHAR 2 0 T188 KONDA_AUFT
LLAND_AUFT Destination Country/Region of Sales Order CHAR 3 0 T005 LLAND_AUFT
MPROK 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
PLTYP_AUFT Price list type of sales order CHAR 2 0 T189 PLTYP_AUFT
REGIO_AUFT Region of Sales Order CHAR 3 0 T005S REGIO_AUFT
VKORG_AUFT Sales organization of sales order CHAR 4 0 TVKO VKORG_AUFT
VTWEG_AUFT Distribution channel of sales order CHAR 2 0 TVTW VTWEG_AUFT
ABRBG Start of accounting settlement period DATS 8 0 ABRBG
PROSA ID for material determination CHAR 1 0 PROSA
No product selection
A Replaced item
B Replacement item
UEPVW 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
AUTYP 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)
STADAT Statistics date DATS 8 0 STADAT
FPLNR Billing plan number / invoicing plan number CHAR 10 0 FPLA FPLNR
FPLTR Item for billing plan/invoice plan/payment cards NUMC 6 0 FPLTR
AKTNR Promotion CHAR 10 0 WAKH WAKTION
KNUMA_PI Sales Promotion CHAR 10 0 KONA KNUMA_PI
KNUMA_AG Sales Deal CHAR 10 0 KONA KNUMA_AG
MWSBP Tax Amount in Document Currency CURR 13 2 MWSBP
AUGRU_AUFT Order Reason (Reason for the Business Transaction) CHAR 3 0 TVAU AUGRU
FAREG 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)
UPMAT Pricing reference material of main item CHAR 40 0 MARA UPMAT
UKONM Material pricing group of main item CHAR 2 0 T178 UKONM
CMPRE_FLT Item Credit Price FLTP 16 16 CMPRE_FLT
ABFOR Form of payment guarantee CHAR 2 0 T691K ABSFORM_CM
ABGES Guaranteed (factor between 0 and 1) FLTP 16 16 ABGES_CM
J_1ARFZ Reason for Zero VAT CHAR 1 0 J_1ARFZ J_1ARFZVAT
J_1AREGIO Region (State, Province, County) CHAR 3 0 T005S REGIO
J_1AGICD Activity Code for Gross Income Tax CHAR 2 0 J_1AGICD J_1AGICD_D
J_1ADTYP Distribution Type for Employment Tax CHAR 2 0 J_1ADTYP J_1ADTYP_D
J_1ATXREL Tax relevant classification CHAR 10 0 J_1ATXREL J_1ATXREL_
J_1BCFOP CFOP Code and Extension CHAR 10 0 J_1BAG J_1BCFOP
J_1BTAXLW1 Tax law: ICMS CHAR 3 0 J_1BATL1 J_1BTAXLW1
J_1BTAXLW2 Tax law: IPI CHAR 3 0 J_1BATL2 J_1BTAXLW2
J_1BTXSDC SD tax code CHAR 2 0 J_1BTXSDC J_1BTXSDC_
BRTWR Gross Value of the Billing Item in Document Currency CURR 15 2 BRTWR_FP
WKTNR Value Contract No. CHAR 10 0 VBAK WKTNR
WKTPS Value Contract Item NUMC 6 0 VBAP WKTPS
RPLNR Payment card plan number of sales document CHAR 10 0 FPLA RPLNR_AU
KURSK_DAT Translation date DATS 8 0 WWERT_D
WGRU1 Material group hierarchy 1 CHAR 18 0 WGRU_HIE1
WGRU2 Material group hierarchy 2 CHAR 18 0 WGRU_HIE2
KDKG1 Customer condition group 1 CHAR 2 0 TVKGG KDKG1
KDKG2 Customer condition group 2 CHAR 2 0 TVKGG KDKG2
KDKG3 Customer condition group 3 CHAR 2 0 TVKGG KDKG3
KDKG4 Customer condition group 4 CHAR 2 0 TVKGG KDKG4
KDKG5 Customer condition group 5 CHAR 2 0 TVKGG KDKG5
VKAUS Usage Indicator CHAR 3 0 TVLV ABRVW
J_1AINDXP Inflation Index CHAR 5 0 J_1AINFT20 J_1AINDXP
J_1AIDATEP Indexing base date DATS 8 0 J_1AIDATES
KZFME 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)
MWSKZ Tax on sales/purchases code CHAR 2 0 MWSKZ
VERTT 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
VERTN Contract Number CHAR 13 0 RANL
SGTXT Item Text CHAR 50 0 SGTXT
DELCO Agreed Delivery Time CHAR 3 0 DELCO
BEMOT Accounting Indicator CHAR 2 0 TBMOT BEMOT
RRREL Revenue recognition category CHAR 1 0 RR_RELTYP
Standard revenue recognition
A Time-related revenue recognition
B Service-related revenue recognition
D Billing-related, time-related revenue recognition
E Billing-related, service-related revenue recognition (IS-M)
F Credit/Debit Memos with reference to predecessor
WMINR Product catalog number CHAR 10 0 WWMI WMINR
VGBEL_EX Document number of the reference document CHAR 10 0 VGBEL
VGPOS_EX Item number of the reference item NUMC 6 0 VGPOS
LOGSYS Logical system CHAR 10 0 LOGSYS
VGTYP_EX Category of an external transaction or element CHAR 3 0 VGTYP_EX
J_1BTAXLW3 ISS Tax Law CHAR 3 0 J_1BATL3 J_1BTAXLW3
J_1BTAXLW4 COFINS Tax Law CHAR 3 0 J_1BATL4A J_1BTAXLW4
J_1BTAXLW5 PIS Tax Law CHAR 3 0 J_1BATL5 J_1BTAXLW5
MSR_ID Process Identification Number CHAR 10 0 MSR_PROCESS_ID
MSR_REFUND_CODE Returns Refund Code CHAR 3 0 MSR_C_RET_REFUND MSR_RETURNS_REFUND_CODE
MSR_RET_REASON Return Reason CHAR 3 0 MSR_C_RET_REASON MSR_RETURNS_REASON
NRAB_KNUMH Number of the Condition Record CHAR 10 0 KNUMH
NRAB_VALUE Condition Value CURR 13 2 KWERT
DISPUTE_CASE Dispute Case RAW 16 0 DISPUTE_CASE
FUND_USAGE_ITEM Fund Usage Item RAW 16 0 FUND_USAGE_ITEM
FARR_RELTYPE Revenue Accounting Type CHAR 10 0 FARR_RELTYPE
Not Relevant
C Call-Off Order with Reference to Contract
G Relevant for Revenue Accounting by Invoice
M Credit/Debit Memo with Reference to Preceding Document
X Relevant for Revenue Accounting
CLAIMS_TAXATION Claims Taxation CHAR 1 0 CLAIMS_TAXATION
Standard Output Tax
0 No Tax Calculation
1 Input Tax Processing
2 Claims with Output Tax and Reference to Prepayments
KURRF_DAT_ORIG Translation date DATS 8 0 WWERT_D
SGT_RCAT Requirement Segment CHAR 40 0 SGT_RCAT
SGT_SCAT Stock Segment CHAR 40 0 SGT_SCAT
PREFE 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
AKKUR Exchange rate for letter-of-credit procg in foreign trade DEC 9 5 AKKUR
WAERK SD Document Currency CUKY 5 0 WAERK
DRAFT Boolean Variable (X = True, - = False, Space = Unknown) CHAR 1 0 BOOLEAN
unknown
- false
X true
ACTIVEDOCUMENT Sales and Distribution Document Number CHAR 10 0 VBELN
GRWRT Statistical value for foreign trade CURR 13 2 GRWRT
FKSAA Order-Related Billing Status (Item) CHAR 1 0 FKSAA
ABSTA Rejection Status for Billing Document Request Item CHAR 1 0 ABSTA_BDR
ABGRU Rejection Reason for Billing Document Request Item CHAR 2 0 ABGRU_BDR
00 Assigned by the System (Internal)
MWSK1 Tax on sales/purchases code CHAR 2 0 MWSKZ
TXDAT_FROM Valid-From Date of the Tax Rate DATS 8 0 FOT_TXDAT_FROM
PBD_ID Preliminary Billing Document CHAR 10 0 PBD_ID
PBD_ITEM_ID Preliminary Billing Document Item NUMC 6 0 PBD_ITEM_ID
CATS_OVERTIME_CATEGORY Overtime Category CHAR 4 0 CATS_OVERTIME_CATEGORY
CONTR_DP_SETTL Settlement of Down Payment from Sales Contract CHAR 1 0 CONTR_DP_SETTL_VF
Not Relevant
X Requested
PRODH_UNIV_SALES_PARNT_NODID Node ID CHAR 40 0 NODID
TRANSIT_PLANT Transit Plant CHAR 4 0 TRANSIT_PLANT
VCM_CHAIN_CATEGORY Value Chain Category CHAR 4 0 VCM_CHAIN_CATEGORY
VCM_CHAIN_UUID GUID in 'CHAR' Format in Uppercase CHAR 32 0 GUID_32
REASON_CODE Reason for Return or Expected Delivery Quantity Change CHAR 3 0 SD_ITEM_REASON_CODE
_DATAAGING Data Filter Value for Data Aging DATS 8 0 DATA_TEMPERATURE
SPE_HERKL Country/Region of Origin of Material (Non-Preferential Ori.) CHAR 3 0 HERKL
SPE_HERKR Region of Origin of Material (Non-Preferential Origin) CHAR 3 0 HERKR
ITM_COMCO Commodity Code CHAR 30 0 /SAPSLL/COMCO
VTKEY Identification of a Provider Contract CHAR 20 0 VTKEY_KK
VTPOS Contract: Item Number NUMC 6 0 VTPOS_KK
SRCDOC_PROCESS_TYPE Internal: Special Source Document Type for Billing CHAR 2 0 SRCDOC_PROCESS_TYPE
PB Project Billing
T2CCODE_CRCY_CONV_FACTOR Factor for calculating Amount in company code currency DEC 31 14 FINS_T2CCODE_CRCY_CONV_FACTOR
T2CNTRY_CRCY_CONV_FACTOR Factor for calculating Tax Amount in reporting currency DEC 31 14 FINS_T2CNTRY_CRCY_CONV_FACTOR
DUMMY_BILLGDOCITEM_INCL_EEW_PS Dummy function in length 1 CHAR 1 0 DUMMY
SERVICE_DOC_TYPE Service Document Type CHAR 4 0 CRMC_PROC_TYPE FCO_SRVDOC_TYPE
SERVICE_DOC_ID Service Document ID CHAR 10 0 FCO_SRVDOC_ID
SERVICE_DOC_ITEM_ID Service Document Item ID NUMC 6 0 FCO_SRVDOC_ITEM_ID
SOLUTION_ORDER_ID Solution Order CHAR 10 0 CRMS4_SOLO_OBJECT_ID
SOLUTION_ORDER_ITEM_ID Solution Order Item NUMC 6 0 CRMS4_SOLO_NUMBER_INT
/CWM/MENGE Quantity in Parallel Unit of Measure QUAN 13 3 /CWM/MENGE
/CWM/MEINS Parallel Unit of Measure UNIT 3 0 * /CWM/MEINS
VBTYP_ANA 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)
FKART_ANA Billing Type CHAR 4 0 * FKART
VKORG_ANA Sales Organization CHAR 4 0 VKORG
VTWEG_ANA Distribution Channel CHAR 2 0 VTWEG
KONDA_ANA Customer Price Group CHAR 2 0 * KONDA
KDGRP_ANA Customer Group CHAR 2 0 * KDGRP
LAND1_ANA Destination Country/Region CHAR 3 0 * LLAND
REGIO_ANA Region (State, Province, County) CHAR 3 0 * REGIO
CITYC_ANA City Code CHAR 4 0 * CITYC
BZIRK_ANA Sales District CHAR 6 0 * BZIRK
GBSTK_ANA Overall Processing Status (Header/All Items) CHAR 1 0 GBSTK
VF_STATUS_ANA SD Billing Status CHAR 1 0 VF_STATUS
Not Relevant
A Completed
B To Be Posted
C Canceled
D Incomplete
KUNAG_ANA Sold-to Party CHAR 10 0 * KUNAG
KUNRG_ANA Payer CHAR 10 0 * KUNRG
FKDAT_ANA Billing Date DATS 8 0 FKDAT
BUKRS_ANA Company Code CHAR 4 0 BUKRS
COUNC_ANA County Code CHAR 3 0 * COUNC
KNUMA_ANA Agreement (various conditions grouped together) CHAR 10 0 KNUMA
FKTYP_ANA Billing Category CHAR 1 0 FKTYP
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
S CRM Billing Document
U Billing request
W POS billing document
X Billing using general interface
KNUMV_ANA Number of the Document Condition CHAR 10 0 KNUMV
SFAKN_ANA Number of canceled billing document CHAR 10 0 SFAKN
KUNWE_ANA Ship-to Party CHAR 10 0 * KUNWE
KUNRE_ANA Bill-to Party CHAR 10 0 * KUNRE
PERVE_ANA Sales Employee NUMC 8 0 SALES_EMPL
PERZM_ANA Employee Responsible NUMC 8 0 RESP_EMPL
GLO_LOG_REF1_IT Commodity Code for Poland CHAR 25 0 GLO_LOG_REF1_IT
TXS_BUSINESS_TRANSACTION Tax Service Business Transaction CHAR 4 0 TXS_BUSINESS_TRANSACTION
TXS_MATERIAL_USAGE Tax Service Material Usage CHAR 1 0 TXS_MATERIAL_USAGE
TXS_USAGE_PURPOSE Tax Service Usage Purpose CHAR 25 0 TXS_USAGE_PURPOSE
ZAPCGKI Annexing package key NUMC 4 0 /ILE/TV01 /ILE/TAPCGK
APCGK_EXTENDI Extended key for annexing package NUMC 10 0 /ILE/TAPCGK_EXT
ZABDATI Annexing base date DATS 8 0 /ILE/TABDAT
AUFPL Routing number of operations in the order NUMC 10 0 CO_AUFPL
APLZL Internal counter NUMC 8 0 CIM_COUNT
DPCNR Down Payment Chain Number CHAR 10 0 /SAPPCE/DPCNR
DCPNR Transaction Number NUMC 3 0 /SAPPCE/DPCPNR
DPNRB Sequence Number of Accounting Document in Transaction NUMC 3 0 /SAPPCE/DPCPNRB
BOSFAR Billing/Invoicing rule (w/o invoicing plan CHAR 1 0 BOSFAR
1 Downpayment
2 Milestone Billing
3 Closing Invoice
DP_BELNR Document Number of an Accounting Document CHAR 10 0 BELNR_D
DP_BUKRS Company Code CHAR 4 0 BUKRS
DP_GJAHR Fiscal Year NUMC 4 0 GJAHR
DP_BUZEI Number of Line Item Within Accounting Document NUMC 3 0 BUZEI
PACKNO Package number NUMC 10 0 ESLH PACKNO
PEROP_BEG Period of Performance Start Date DATS 8 0 FM_PEROP_SD_LOW
PEROP_END Period of Performance End Date DATS 8 0 FM_PEROP_SD_HIGH
FMFGUS_KEY United States Federal Government Fields CHAR 22 0 FMFG_US_KEY
FSH_SEASON_YEAR Season Year CHAR 4 0 FSH_SAISJ
FSH_SEASON Season CHAR 10 0 FSH_SAISO
FSH_COLLECTION Fashion Collection CHAR 10 0 * FSH_COLLECTION
FSH_THEME Fashion Theme CHAR 10 0 FSH_THEME
FONDS Fund CHAR 10 0 * BP_GEBER
FISTL Funds Center CHAR 16 0 * FISTL
FKBER Functional Area CHAR 16 0 * FKBER
GRANT_NBR Grant CHAR 20 0 GM_GRANT_NBR
BUDGET_PD Budget Period CHAR 10 0 * FM_BUDGET_PERIOD
J_3GBELNRI Document Number CHAR 10 0 J_3GBELK J_3GBELNRI
J_3GPMAUFE PM Order Number (Owner) CHAR 12 0 AUFK J_3GPMAUFE
J_3GPMAUFV PM Order Number (Administrator) CHAR 12 0 AUFK J_3GPMAUFV
J_3GETYPA Sending Recipient Type CHAR 2 0 * J_3GETYPA
J_3GETYPE Receiving Recipient Type CHAR 2 0 * J_3GETYPE
J_3GORGUEB Indicator: Across All Organizational Structures CHAR 1 0 J_3GORGUEB
PRS_WORK_PERIOD Work Period (Internal Representation) NUMC 7 0 PRS_WORK_PERIOD
PPRCTR Partner Profit Center CHAR 10 0 * PPRCTR
PARGB Trading partner's business area CHAR 4 0 * PARGB
AUFPL_OAA Routing number of operations in the order NUMC 10 0 CO_AUFPL
APLZL_OAA Internal counter NUMC 8 0 CIM_COUNT
CAMPAIGN Generic project planning: GUID from external R/3 system RAW 16 0 CGPL_GUID16_R3
COMPREAS Abbreviation for Complaints Reason CHAR 4 0 CMP_COMPREAS_COPY
WRF_CHARSTC1 Characteristic Value 1 CHAR 18 0 WRF_CHARSTC1
WRF_CHARSTC2 Characteristic Value 2 CHAR 18 0 WRF_CHARSTC2
WRF_CHARSTC3 Characteristic Value 3 CHAR 18 0 WRF_CHARSTC3

VBRP foreign key relationships

Table Field Check Table Check Field
0 VBRP ABFOR T691K Forms of payment guarantee ABSFO
1 VBRP ABRVW TVLV Check table for release orders: Usage ID ABRVW
0 VBRP AKTNR WAKH Promotion Header Data, IS-R MANDT
0 VBRP AKTNR WAKH Promotion Header Data, IS-R AKTNR
1 VBRP ALAND T005 Countries MANDT
1 VBRP ALAND T005 Countries LAND1
0 VBRP AUBEL VBAK Sales Document: Header Data MANDT
0 VBRP AUBEL VBAK Sales Document: Header Data VBELN
1 VBRP AUFNR AUFK Order master data AUFNR
0 VBRP AUGRU_AUFT TVAU Sales Documents: Order Reasons MANDT
0 VBRP AUGRU_AUFT TVAU Sales Documents: Order Reasons AUGRU
1 VBRP AUPOS VBAP Sales Document: Item Data VBELN
1 VBRP AUPOS VBAP Sales Document: Item Data POSNR
0 VBRP BEMOT TBMOT Accounting indicators MANDT
0 VBRP BEMOT TBMOT Accounting indicators BEMOT
1 VBRP BONUS TVBO Sales Rebate Groups MANDT
1 VBRP BONUS TVBO Sales Rebate Groups BONUS
0 VBRP BWTAR T149D Global Valuation Types MANDT
0 VBRP BWTAR T149D Global Valuation Types BWTAR
1 VBRP BZIRK_AUFT T171 Customers: Sales Districts MANDT
1 VBRP BZIRK_AUFT T171 Customers: Sales Districts BZIRK
0 VBRP CHARG MCHA Batches MANDT
0 VBRP CHARG MCHA Batches WERKS
0 VBRP CHARG MCHA Batches CHARG
1 VBRP FPLNR FPLA Billing Plan FPLNR
0 VBRP GEWEI T006 Units of Measurement MANDT
0 VBRP GEWEI T006 Units of Measurement MSEHI
1 VBRP GSBER TGSB Business Areas MANDT
1 VBRP GSBER TGSB Business Areas GSBER
0 VBRP J_1ADTYP J_1ADTYP Distribution Types for Gross Income Tax MANDT
0 VBRP J_1ADTYP J_1ADTYP Distribution Types for Gross Income Tax BUKRS
1 VBRP J_1AGICD J_1AGICD Activity codes for gross income tax declaration MANDT
1 VBRP J_1AGICD J_1AGICD Activity codes for gross income tax declaration LAND1
0 VBRP J_1AINDXP J_1AINFT20 Inflation: Index Definition MANDT
1 VBRP J_1AREGIO T005S Taxes: Region (Province) Key LAND1
0 VBRP J_1ARFZ J_1ARFZ Definition of reasons for zero VAT MANDT
1 VBRP J_1ATXREL J_1ATXREL Tax relevant classification MANDT
1 VBRP J_1ATXREL J_1ATXREL Tax relevant classification J_1ATXREL
0 VBRP J_1BCFOP J_1BAG CFOP MANDT
1 VBRP J_1BTAXLW4 J_1BATL4A Tax Laws COFINS MANDT
0 VBRP J_1BTAXLW5 J_1BATL5 PIS Tax Law MANDT
1 VBRP J_1BTXSDC J_1BTXSDC SD tax codes MANDT
0 VBRP J_3GBELNRI J_3GBELK Document File - Header Data MANDT
0 VBRP J_3GBELNRI J_3GBELK Document File - Header Data J_3GBELNRI
1 VBRP J_3GPMAUFE AUFK Order master data AUFNR
0 VBRP J_3GPMAUFV AUFK Order master data AUFNR
1 VBRP KDGRP_AUFT T151 Customers: Customer Groups MANDT
1 VBRP KDGRP_AUFT T151 Customers: Customer Groups KDGRP
0 VBRP KDKG1 TVKGG Customer Condition Groups (Customer Master) MANDT
0 VBRP KDKG1 TVKGG Customer Condition Groups (Customer Master) KDKGR
1 VBRP KDKG2 TVKGG Customer Condition Groups (Customer Master) MANDT
1 VBRP KDKG2 TVKGG Customer Condition Groups (Customer Master) KDKGR
0 VBRP KDKG3 TVKGG Customer Condition Groups (Customer Master) MANDT
0 VBRP KDKG3 TVKGG Customer Condition Groups (Customer Master) KDKGR
1 VBRP KDKG4 TVKGG Customer Condition Groups (Customer Master) MANDT
1 VBRP KDKG4 TVKGG Customer Condition Groups (Customer Master) KDKGR
0 VBRP KDKG5 TVKGG Customer Condition Groups (Customer Master) MANDT
0 VBRP KDKG5 TVKGG Customer Condition Groups (Customer Master) KDKGR
1 VBRP KNUMA_AG KONA Agreements MANDT
1 VBRP KNUMA_AG KONA Agreements KNUMA
0 VBRP KNUMA_PI KONA Agreements MANDT
0 VBRP KNUMA_PI KONA Agreements KNUMA
1 VBRP KOKRS TKA01 Controlling Areas MANDT
0 VBRP KONDA_AUFT T188 Conditions: Groups for Customer Classifications MANDT
0 VBRP KONDA_AUFT T188 Conditions: Groups for Customer Classifications KONDA
1 VBRP KONDM T178 Conditions: Groups for Materials MANDT
1 VBRP KONDM T178 Conditions: Groups for Materials KONDM
0 VBRP KTGRM TVKM Materials: Account Assignment Groups MANDT
0 VBRP KTGRM TVKM Materials: Account Assignment Groups KTGRM
1 VBRP KVGR1 TVV1 Customer Group 1 MANDT
1 VBRP KVGR1 TVV1 Customer Group 1 KVGR1
0 VBRP KVGR2 TVV2 Customer Group 2 MANDT
0 VBRP KVGR2 TVV2 Customer Group 2 KVGR2
1 VBRP KVGR3 TVV3 Customer Group 3 KVGR3
0 VBRP KVGR4 TVV4 Customer Group 4 MANDT
0 VBRP KVGR4 TVV4 Customer Group 4 KVGR4
1 VBRP KVGR5 TVV5 Customer Group 5 MANDT
1 VBRP KVGR5 TVV5 Customer Group 5 KVGR5
0 VBRP LGORT T001L Storage Locations MANDT
0 VBRP LGORT T001L Storage Locations WERKS
1 VBRP LLAND_AUFT T005 Countries MANDT
1 VBRP LLAND_AUFT T005 Countries LAND1
0 VBRP MANDT T000 Clients MANDT
1 VBRP MATKL T023 Material Groups MATKL
0 VBRP MATNR MARA General Material Data MANDT
0 VBRP MATNR MARA General Material Data MATNR
1 VBRP MATWA MARA General Material Data MANDT
1 VBRP MATWA MARA General Material Data MATNR
0 VBRP MEINS T006 Units of Measurement MANDT
0 VBRP MEINS T006 Units of Measurement MSEHI
1 VBRP MSR_REFUND_CODE MSR_C_RET_REFUND Returns Refund Codes MANDT
0 VBRP MSR_RET_REASON MSR_C_RET_REASON Multi-step returns - Returns reason MANDT
1 VBRP MVGR1 TVM1 Material Pricing Group 1 MVGR1
0 VBRP MVGR2 TVM2 Material Pricing Group 2 MVGR2
1 VBRP MVGR3 TVM3 Material Pricing Group 3 MVGR3
0 VBRP MVGR4 TVM4 Material Pricing Group 4 MANDT
0 VBRP MVGR4 TVM4 Material Pricing Group 4 MVGR4
1 VBRP MVGR5 TVM5 Material Pricing Group 5 MANDT
1 VBRP MVGR5 TVM5 Material Pricing Group 5 MVGR5
0 VBRP PACKNO ESLH Service Package Header Data PACKNO
1 VBRP PLTYP_AUFT T189 Conditions: Price List Types MANDT
1 VBRP PLTYP_AUFT T189 Conditions: Price List Types PLTYP
0 VBRP PMATN MARA General Material Data MANDT
0 VBRP PMATN MARA General Material Data MATNR
1 VBRP POSPA VBRP Billing Document: Item Data VBELN
1 VBRP POSPA VBRP Billing Document: Item Data POSNR
0 VBRP PRODH T179 Materials: Product Hierarchies PRODH
1 VBRP PROVG TVPR Commission Groups MANDT
1 VBRP PROVG TVPR Commission Groups PROVG
0 VBRP REGIO_AUFT T005S Taxes: Region (Province) Key LAND1
1 VBRP RPLNR FPLA Billing Plan FPLNR
0 VBRP SERNR SNUM BOM explosion number MANDT
1 VBRP SPARA TSPA Organizational Unit: Sales Divisions MANDT
1 VBRP SPARA TSPA Organizational Unit: Sales Divisions SPART
0 VBRP SPART TSPA Organizational Unit: Sales Divisions MANDT
0 VBRP SPART TSPA Organizational Unit: Sales Divisions SPART
1 VBRP UKONM T178 Conditions: Groups for Materials MANDT
1 VBRP UKONM T178 Conditions: Groups for Materials KONDM
0 VBRP UPMAT MARA General Material Data MANDT
0 VBRP UPMAT MARA General Material Data MATNR
1 VBRP VBELN VBRK Billing Document: Header Data VBELN
0 VBRP VKAUS TVLV Check table for release orders: Usage ID ABRVW
1 VBRP VKBUR TVBUR Organizational Unit: Sales Offices MANDT
0 VBRP VKGRP TVKGR Organizational Unit: Sales Groups MANDT
1 VBRP VKORG_AUFT TVKO Organizational Unit: Sales Organizations MANDT
1 VBRP VKORG_AUFT TVKO Organizational Unit: Sales Organizations VKORG
0 VBRP VOLEH T006 Units of Measurement MANDT
0 VBRP VOLEH T006 Units of Measurement MSEHI
1 VBRP VRKME T006 Units of Measurement MANDT
1 VBRP VRKME T006 Units of Measurement MSEHI
0 VBRP VSTEL TVST Organizational Unit: Shipping Points MANDT
0 VBRP VSTEL TVST Organizational Unit: Shipping Points VSTEL
1 VBRP VTWEG_AUFT TVTW Organizational Unit: Distribution Channels MANDT
1 VBRP VTWEG_AUFT TVTW Organizational Unit: Distribution Channels VTWEG
0 VBRP WERKS T001W Plants/Branches WERKS
1 VBRP WKREG T005S Taxes: Region (Province) Key LAND1
0 VBRP WKTNR VBAK Sales Document: Header Data MANDT
0 VBRP WKTNR VBAK Sales Document: Header Data VBELN
1 VBRP WKTPS VBAP Sales Document: Item Data VBELN
1 VBRP WKTPS VBAP Sales Document: Item Data POSNR
0 VBRP WMINR WWMI Product catalog MANDT
0 VBRP WMINR WWMI Product catalog WMINR