1. Home
  2. Resources
  3. SAP Tables
  4. VBDPR - Document Item View for Billing

SAP Table VBDPR

Document Item View for Billing

VBDPR (Document Item View for Billing) 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 VBDPR to other SAP tables.

VBDPR table fields

Field Data element Checktable Datatype Length Decimals
POSNR Item number of the SD document POSNR VBUP NUMC 6 0
POSEX Item Number of the Underlying Purchase Order POSEX CHAR 6 0
POSPA Item number in the partner segment POSPA VBUP NUMC 6 0
MATNR Material Number MATNR MARA CHAR 18 0
MATWA Material entered MATWA MARA CHAR 18 0
IDNKD Material Number Used by Customer MATNR_KU CHAR 35 0
ARKTX Short text for sales order item ARKTX CHAR 40 0
BRGEW Gross weight BRGEW_15 QUAN 15 3
NTGEW Net weight NTGEW_15 QUAN 15 3
GEWEI Weight Unit GEWEI T006 UNIT 3 0
VOLUM Volume VOLUM_15 QUAN 15 3
VOLEH Volume unit VOLEH T006 UNIT 3 0
NETWR Net Value in Document Currency NETWR CURR 15 2
WAERK SD Document Currency WAERK TCURC CUKY 5 0
NETPR Net price NETPR CURR 11 2
KURSK Exchange Rate for Price Determination KURSK DEC 9 5
KURSK_DAT Translation Date WWERT_D DATS 8 0
KPEIN Condition pricing unit KPEIN DEC 5 0
KMEIN Condition unit KMEIN T006 UNIT 3 0
FKIMG Actual Invoiced Quantity FKIMG QUAN 13 3
VRKME Sales unit VRKME T006 UNIT 3 0
KUNWE Ship-to party KUNWE KNA1 CHAR 10 0
ANRED_WE Title ANRED CHAR 15 0
ADRNR_WE Address number AD_ADDRNUM CHAR 10 0
ADRNP_WE Person number AD_PERSNUM CHAR 10 0
ADDRESS_TYPE_WE Address type (1=Organization, 2=Person, 3=Contact person) AD_ADRTYPE CHAR 1 0
1 Organization, Company
2 Private address
3 Contact person (in company)
NAME1_WE Name 1 NAME1_GP CHAR 35 0
NAME2_WE Name 2 NAME2_GP CHAR 35 0
NAME3_WE Name 3 NAME3_GP CHAR 35 0
NAME4_WE Name 4 NAME4_GP CHAR 35 0
STRAS_WE House number and street STRAS_GP CHAR 35 0
PFACH_WE PO Box PFACH CHAR 10 0
PFORT_WE PO Box city PFORT_GP CHAR 35 0
PSTL2_WE P.O. Box Postal Code PSTL2 CHAR 10 0
LAND1_WE Country Key LAND1 T005 CHAR 3 0
SPRAS_WE Language Key SPRAS LANG 1 0
PSTLZ_WE Postal Code PSTLZ CHAR 10 0
ORT01_WE City ORT01_GP CHAR 35 0
ORT02_WE District ORT02_GP CHAR 35 0
REGIO_WE Region (State, Province, County) REGIO T005S CHAR 3 0
TDNAME Name TDOBNAME CHAR 70 0
VBELN_VL Delivery VBELN_VL VBUK CHAR 10 0
POSNR_VL Delivery Item POSNR_VL NUMC 6 0
ABLAD Unloading Point ABLAD CHAR 25 0
LFDAT Delivery date LFDAT DATS 8 0
LEDAT Delivery Creation Date LEDAT DATS 8 0
VBELN_VAUF Order VBELN_VAUF VBUK CHAR 10 0
POSNR_VAUF Sales Document Item POSNR_VA VBUP NUMC 6 0
VGTYP_VAUF 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
AUDAT Sales order date AUDAT_VAUF DATS 8 0
VGBEL Document number of the reference document VGBEL VBUK CHAR 10 0
VGPOS Item number of the reference item VGPOS VBUP NUMC 6 0
BSTNK Customer purchase order number BSTNK CHAR 20 0
BSTDK Customer purchase order date BSTDK DATS 8 0
BSTZD Purchase order number supplement BSTZD CHAR 4 0
IHREZ Your Reference IHREZ CHAR 12 0
VKBUR Sales Office VKBUR CHAR 4 0
VSART Shipping type VERSART CHAR 2 0
VSART_BEZ Description of the Shipping Type VERSARTBEZ CHAR 20 0
SKFBP Amount Eligible for Cash Discount in Document Currency SKFBT CURR 13 2
UEPOS Higher-level item in bill of material structures UEPOS NUMC 6 0
CUOBJ Configuration CUOBJ_VA NUMC 18 0
CUOBJ_CH Internal object number of the batch classification CUOBJ_CH NUMC 18 0
ATTYP Material Category ATTYP CHAR 2 0
NULL Single material (industry)
00 Single material
01 Generic material
02 Variant
10 Sales set
11 Prepack
12 Display
20 Material group material
21 Hierarchy material
22 Group material
30 Material group reference material
PRSDT Date for pricing and exchange rate PRSDT DATS 8 0
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
FBUDA Date on which services rendered FBUDA DATS 8 0
CHARG Batch Number CHARG_D CHAR 10 0
PMATN Pricing Reference Material PMATN CHAR 18 0
EAN11 International Article Number (EAN/UPC) EAN11 CHAR 18 0
UMVKZ Numerator (factor) for conversion of sales quantity into SKU UMVKZ DEC 5 0
UMVKN Denominator (Divisor) for Conversion of Sales Qty into SKU UMVKN DEC 5 0
VBELN_VAG Sales and Distribution Document Number VBELN CHAR 10 0
POSNR_VAG Item number of the SD document POSNR NUMC 6 0
AGDAT Date on Which Record Was Created ERDAT DATS 8 0
VBELN_VKT Sales and Distribution Document Number VBELN CHAR 10 0
POSNR_VKT Item number of the SD document POSNR NUMC 6 0
KTDAT Date on Which Record Was Created ERDAT DATS 8 0
VBELN_VG2 Sales and Distribution Document Number VBELN CHAR 10 0
POSNR_VG2 Item number of the SD document POSNR NUMC 6 0
G2DAT Date on Which Record Was Created ERDAT DATS 8 0
VGTYP 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
SUGRD Reason for material substitution SUGRD CHAR 4 0
SUDRU Original entry will be printed SUDRU CHAR 1 0
X Yes
NULL No
FPLNR Billing plan number / invoicing plan number FPLNR CHAR 10 0
FPLTR Item for billing plan/invoice plan/payment cards FPLTR NUMC 6 0
VBELV Originating document VBELV CHAR 10 0
POSNV Originating item POSNV NUMC 6 0
EXNUM Number of foreign trade data in MM and SD documents EXNUM CHAR 10 0
EXPOS Internal item number for foreign trade data in MM and SD EXPOS NUMC 6 0
STAWN Commodity Code/Import Code Number for Foreign Trade STAWN CHAR 17 0
EXPRF Export/Import Procedure for Foreign Trade EXPRF CHAR 8 0
EXART Business Transaction Type for Foreign Trade EXART CHAR 2 0
HERKL Country of origin of the material HERKL CHAR 3 0
HERKR Region of origin of material (non-preferential origin) HERKR CHAR 3 0
GRWRT Statistical value for foreign trade GRWRT CURR 13 2
HERTI Country Name LANDX CHAR 15 0
HERTA Departure country (country from which the goods are sent) ALAND CHAR 3 0
STXT1 Description of commodity code - First line STXT1 CHAR 40 0
STXT2 Description of commodity code - Second line STXT2 CHAR 40 0
STXT3 Description of commodity code - Third line STXT3 CHAR 40 0
STXT4 Description of commodity code - Fourth line STXT4 CHAR 40 0
STXT5 Description of commodity code - Fifth line STXT5 CHAR 40 0
STXT6 Description of commodity code - Sixth line STXT6 CHAR 40 0
STXT7 Description of commodity code - Seventh line STXT7 CHAR 40 0
BEMAS Supplementary unit BEMEH UNIT 3 0
PREFE 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
BOLNR Bill of lading BOLNR CHAR 35 0
TRATY Means-of-Transport Type TRATY CHAR 4 0
TRAID Means of Transport ID TRAID CHAR 20 0
HERBL State of manufacture HERBL CHAR 2 0
BMGEW Net Weight NTGEW QUAN 13 3
MOWNR CAP: Number of CAP products list MOWNR CHAR 12 0
GPNUM Production statistics: PRODCOM number for foreign trade GPNUM CHAR 9 0
CASNR CAS number for pharmaceutical products in foreign trade CASNR CHAR 15 0
STEUC Control code for consumption taxes in foreign trade STEUC CHAR 16 0
WZOLL Customs val. in doc.currency in imp.procg for foreign trade WZOLL CURR 13 2
VERLD Country of dispatch for Foreign Trade VERLD CHAR 3 0
HANLD Trading country for foreign trade HANLD CHAR 3 0
TEXT1 Description BEZEI40 CHAR 40 0
TEXT2 Description BEZEI40 CHAR 40 0
TEXT3 Description BEZEI40 CHAR 40 0
COKON Customs quota code for import processing in foreign trade COKON CHAR 6 0
COPHA Pharmaceutical products code (Foreign Trade) COPHA CHAR 6 0
COADI Anti-dumping code for import processing in foreign trade COADI CHAR 6 0
PRONU Invoice: Number of invoice document for import processing PRONU CHAR 25 0
PRODA Invoice: Date of invoice document for import processing PRODA DATS 8 0
VORPA Preliminary document: Document type for foreign trade procg VORPA CHAR 10 0
VORNU Preliminary document: No. of preliminary doc.f.import procg VORNU CHAR 25 0
VORDA Preliminary document: Date of preliminary doc.f.import procg VORDA DATS 8 0
BEHOE Issuing authority for relevant Foreign Trade document BEHOE CHAR 10 0
KENNU Preliminary document: Customs office/ID number for import KENNU CHAR 6 0
VOISO Prelim. doc.: ISO code of ctry issuing the preliminary doc. VOISO CHAR 2 0
PREFA Preference: Preference type for foreign trade PREFA CHAR 10 0
PREFN Preference: Official number of preference document - Import PREFN CHAR 25 0
PREDU Preference: Date of preference document for import procg PREDU DATS 8 0
PRISO Preference: ISO code of country issuing the preference doc. PRISO CHAR 2 0
PRHOE Issuing authority for relevant Foreign Trade document BEHOE CHAR 10 0
PRUEL Preference: Validity date of preference document for import PRUEL DATS 8 0
NACAR Verification documents: Type of certificate for import NACAR CHAR 10 0
NACNU Verification docs: Official no. of verific. doc. - Import NACNU CHAR 25 0
NACDA Verification documents: Date of verif.doc. for import procg NACDA DATS 8 0
NAISO Verification doc: ISO code of ctry supplying verific.doc. NAISO CHAR 2 0
NAHOE Issuing authority for relevant Foreign Trade document BEHOE CHAR 10 0
NAUEL Verification docs: Validity date of verific.doc. for import NAUEL DATS 8 0
NACA2 Verification documents: Type of certificate for import NACAR CHAR 10 0
NACN2 Verification docs: Official no. of verific. doc. - Import NACNU CHAR 25 0
NACD2 Verification documents: Date of verif.doc. for import procg NACDA DATS 8 0
NAIS2 Preference: ISO code of country issuing the preference doc. PRISO CHAR 2 0
NAHO2 Issuing authority for relevant Foreign Trade document BEHOE CHAR 10 0
NAUE2 Verification docs: Validity date of verific.doc. for import NAUEL DATS 8 0
NACA3 Verification documents: Type of certificate for import NACAR CHAR 10 0
NACN3 Verification docs: Official no. of verific. doc. - Import NACNU CHAR 25 0
NACD3 Verification documents: Date of verif.doc. for import procg NACDA DATS 8 0
NAIS3 Verification doc: ISO code of ctry supplying verific.doc. NAISO CHAR 2 0
NAHO3 Issuing authority for relevant Foreign Trade document BEHOE CHAR 10 0
NAUE3 Verification docs: Validity date of verific.doc. for import NAUEL DATS 8 0
NACA4 Verification documents: Type of certificate for import NACAR CHAR 10 0
NACN4 Verification docs: Official no. of verific. doc. - Import NACNU CHAR 25 0
NACD4 Verification documents: Date of verif.doc. for import procg NACDA DATS 8 0
NAIS4 Verification doc: ISO code of ctry supplying verific.doc. NAISO CHAR 2 0
NAHO4 Issuing authority for relevant Foreign Trade document BEHOE CHAR 10 0
NAUE4 Verification docs: Validity date of verific.doc. for import NAUEL DATS 8 0
NACA5 Verification documents: Type of certificate for import NACAR CHAR 10 0
NACN5 Verification docs: Official no. of verific. doc. - Import NACNU CHAR 25 0
NACD5 Verification documents: Date of verif.doc. for import procg NACDA DATS 8 0
NAIS5 Verification doc: ISO code of ctry supplying verific.doc. NAISO CHAR 2 0
NAHO5 Issuing authority for relevant Foreign Trade document BEHOE CHAR 10 0
NAUE5 Verification docs: Validity date of verific.doc. for import NAUEL DATS 8 0
EXDAR Export document: Export document type for foreign trade EXDAR CHAR 10 0
EXDAA Export document: Official number of export document EXDAA CHAR 25 0
EXDAB Export document: Valid-to number of export document EXDAB CHAR 25 0
EXDTA T document: Type of T document for foreign trade EXDTA CHAR 10 0
EXDT2 T document: Official number of T document for foreign trade EXDT2 CHAR 25 0
EXDTB T doc.: Official no. for next page of T doc. f.foreign trade EXDTB CHAR 25 0
EXDPA Preference: Preference type for foreign trade EXDPA CHAR 10 0
EXPRE Preference: Official number of preference document - Export EXPRE CHAR 25 0
EXDT5 CAP: Official number of T5 document for foreign trade EXDT5 CHAR 25 0
COIMP Code number for import processing in foreign trade COIMP CHAR 17 0
GBNUM Foreign Trade:Customs declaration list no. for Foreign Trade GB_NR CHAR 20 0
REGNR Registration number for import processing in foreign trade RG_NR CHAR 20 0
PRENC Exemption certificate: Indicator for legal control PRENC CHAR 1 0
NULL Not Relevant
A Applied for
B Accepted
C Request Rejected
PRENO Exemption certificate number for legal control PRENN CHAR 8 0
PREND Exemption certificate: Issue date of exemption certificate PREND DATS 8 0
WKREG Region in which plant is located WKREG CHAR 3 0
IMPMA Second unit of measurement IMPMA UNIT 3 0
IMGEW Net Weight NTGEW QUAN 13 3
DUMMY Dummy function in length 1 DUMMY CHAR 1 0
XCHAR Batch management indicator (internal) XCHAR CHAR 1 0
X Yes
NULL No
UECHA Higher-Level Item of Batch Split Item UECHA NUMC 6 0
KZWI1 Subtotal 1 from pricing procedure for condition KZWI1 CURR 13 2
KZWI2 Subtotal 2 from pricing procedure for condition KZWI2 CURR 13 2
KZWI3 Subtotal 3 from pricing procedure for condition KZWI3 CURR 13 2
KZWI4 Subtotal 4 from pricing procedure for condition KZWI4 CURR 13 2
KZWI5 Subtotal 5 from pricing procedure for condition KZWI5 CURR 13 2
KZWI6 Subtotal 6 from pricing procedure for condition KZWI6 CURR 13 2
KOSTL Cost Center KOSTL CHAR 10 0
PAOBJNR Profitability Segment Number (CO-PA) RKEOBJNR NUMC 10 0
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) PS_PSP_PNR NUMC 8 0
PRCTR Profit Center PRCTR CHAR 10 0
PPRCTR Partner Profit Center PPRCTR CHAR 10 0
GSBER Business Area GSBER CHAR 4 0
PARGB Trading partner's business area PARGB CHAR 4 0
BSTKD Customer purchase order number BSTKD CHAR 35 0
BSARK Customer purchase order type BSARK CHAR 4 0
BSTKD_E Ship-to Party's Purchase Order Number BSTKD_E CHAR 35 0
BSTDK_E Ship-to party's PO date BSTDK_E DATS 8 0
BSARK_E Ship-to party purchase order type BSARK_E CHAR 4 0
IHREZ_E Ship-to party character IHREZ_E CHAR 12 0
POSEX_E Item Number of the Underlying Purchase Order POSEX_E CHAR 6 0
VBKLT SD document indicator VBKLT CHAR 1 0
NULL No classification
A Billing request (line item billing)
B Delivery order
C Scheduling agreement with delivery order
D Invoice correction request
E Delivery order correction
F Repair processing: Leading serviceable material
G Repair processing: Leading service product
H Scheduling agreement with external service agent processing
I Consignment issue by external service agent
K Correct consignment issue by external service agent
R Order for Billing Between Company Codes (RRICB)
SHKZG Returns item SHKZG_VF CHAR 1 0
NULL Outbound Message Processing
A Outbound - document flow negative
B Returns - document flow negative
X Returns
AUTYP 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
FAREG 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)
MWSBP Tax amount in document currency MWSBP CURR 13 2
PSTYV Sales document item category PSTYV CHAR 4 0
TXJCD Tax Jurisdiction TXJCD CHAR 15 0
VKAUS Usage Indicator ABRVW CHAR 3 0
STEUCL Control code for consumption taxes in foreign trade STEUC CHAR 16 0
J_1ARFZ Reason for zero VAT J_1ARFZVAT CHAR 1 0
KBETRL Rate (condition amount or percentage) where no scale exists KBETR_KOND CURR 11 2
MATNR_VG2 Material Number MATNR CHAR 18 0
FKIMG_VG2 Actual Invoiced Quantity FKIMG QUAN 13 3
VRKME_VG2 Sales unit VRKME UNIT 3 0
NETWR_VG2 Net value of the billing item in document currency NETWR_FP CURR 15 2
MWSBP_VG2 Tax amount in document currency MWSBP CURR 13 2
BRTWR_VG2 Gross value of the billing item in document currency BRTWR_FP CURR 15 2
NETPR_VG2 Net price NETPR CURR 11 2
MWSPR_VG2 Rate (condition amount or percentage) KBETR CURR 11 2
J_1ARFZ_VG2 Reason for zero VAT J_1ARFZVAT CHAR 1 0
XBLNR_VL Reference Document Number XBLNR_LIKP CHAR 25 0
LIFNR_CONSIGNOR Account Number of Vendor or Creditor LIFNR CHAR 10 0
NETPRL Net price NETPR CURR 11 2
MWSKL Tax on sales/purchases code MWSKZ CHAR 2 0
BRTWR Gross value of the billing item in document currency BRTWR_FP CURR 15 2
KOWRR 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
FKLMG Billing quantity in stockkeeping unit FKLMG QUAN 13 3
MEINS Base Unit of Measure MEINS UNIT 3 0
WERKS Plant WERKS_D CHAR 4 0
PRCTR_IV Profit Center PRCTR CHAR 10 0
KZVBR Consumption Posting KZVBR CHAR 1 0
NULL No consumption
V Consumption
A Asset
E Sales order
P Project
MSR_ID Process Identification Number MSR_PROCESS_ID CHAR 10 0
MSR_ITEM Item Number MSR_PROCESS_ITEM NUMC 6 0
RMA_CUSTOMER Customer RMA Number MSR_CRMA_NR CHAR 20 0
MSR_RET_REASON Return Reason MSR_RETURNS_REASON CHAR 3 0
MSR_RET_REASON_TEXT Return Reason Description MSR_RET_REASON_TEXT CHAR 60 0
MSR_MAT_RECEIVED Material Received MSR_MATERIAL_RECEIVED CHAR 1 0
X Yes
NULL No
MSR_FU_CODE Follow-Up Activity Code MSR_FU_CODE CHAR 4 0
MSR_FU_CODE_TEXT Follow-Up Activity Description MSR_FU_CODE_TEXT CHAR 60 0
MSR_FORW_VENDOR Account Number of Vendor or Creditor LIFNR CHAR 10 0
MSR_FWV_TITLE Form-of-Address Key AD_TITLE CHAR 4 0
MSR_FWV_ADDRNUM Address number AD_ADDRNUM CHAR 10 0
MSR_FWV_NAME1 Name 1 AD_NAME1 CHAR 40 0
MSR_FWV_NAME2 Name 2 AD_NAME2 CHAR 40 0
MSR_FWV_NAME3 Name 3 AD_NAME3 CHAR 40 0
MSR_FWV_NAME4 Name 4 AD_NAME4 CHAR 40 0
MSR_FWV_STREET Street AD_STREET CHAR 60 0
MSR_FWV_PO_BOX PO Box AD_POBX CHAR 10 0
MSR_FWV_PO_BOX_LOC PO Box city AD_POBXLOC CHAR 40 0
MSR_FWV_CITY_CODE2 City PO box code (City file) AD_CIT2NUM CHAR 12 0
MSR_FWV_COUNTRY Country Key LAND1 CHAR 3 0
MSR_FWV_LANGU Language Key SPRAS LANG 1 0
MSR_FWV_POST_CODE1 City postal code AD_PSTCD1 CHAR 10 0
MSR_FWV_CITY1 City AD_CITY1 CHAR 40 0
MSR_FWV_CITY2 District AD_CITY2 CHAR 40 0
MSR_FWV_REGION Region (State, Province, County) REGIO CHAR 3 0
RMA_VENDOR Vendor RMA Number MSR_VRMA_NR CHAR 20 0
MSR_INSP_CODE Inspection Code MSR_INSPECTION_CODE CHAR 4 0
MSR_INSP_CODE_TX Inspection Comment MSR_INSPECTION_COMMENT CHAR 40 0
MSR_REFUND_CODE Returns Refund Code MSR_RETURNS_REFUND_CODE CHAR 3 0
MSR_REFUND_CODE_TEXT Refund Code Description MSR_REFUND_CODE_TEXT CHAR 60 0
MSR_FORW_PLANT1 Plant WERKS_D CHAR 4 0
MSR_PLANT1_TXT Name NAME1 CHAR 30 0
MSR_FORW_PLANT2 Plant WERKS_D CHAR 4 0
MSR_PLANT2_TXT Name NAME1 CHAR 30 0
MSR_FORW_PLANT3 Plant WERKS_D CHAR 4 0
MSR_PLANT3_TXT Name NAME1 CHAR 30 0
MSR_SPLIT Checkbox XFELD CHAR 1 0
X Yes
NULL No
VBELN_VF_REVERSED Reversed Billing Document VBELN_VF_REVERSED CHAR 10 0
POSNR_VF_REVERSED Reversed Billing Item POSNR_VF_REVERSED NUMC 6 0
POSNR_VF_PARTNER Partner Billing Item POSNR_VF_PARTNER NUMC 6 0
/BEV1/EMMVGR1 Material group 1 MVGR1 CHAR 3 0
/BEV1/EMMVGR2 Material group 2 MVGR2 CHAR 3 0
/BEV1/EMMVGR3 Material group 3 MVGR3 CHAR 3 0
/BEV1/EMMVGR4 Material group 4 MVGR4 CHAR 3 0
/BEV1/EMMVGR5 Material group 5 MVGR5 CHAR 3 0
/BEV1/EMNEUPOS Item number of the SD document POSNR NUMC 6 0
/BEV1/EMPRODH Product hierarchy PRODH_D CHAR 18 0
OID_EXTBOL External bill of lading OID_EXTBOL CHAR 16 0
OID_MISCDL Miscellaneous delivery number OID_MISCDL CHAR 16 0
OIHANTYPE Excise Duty Handling Type OIH_HANTYP CHAR 2 0
OICERTF1 Excise tax external license number OIH_CERTF1 CHAR 15 0
OIDATFM1 Excise Duty License Valid from Date OIH_DATFM1 DATS 8 0
OIDATTO1 Valid to date for excise duty tax certificate OIH_DATTO1 DATS 8 0
OIUECHA Higher-Level Item of Batch Split Item UECHA NUMC 6 0

VBDPR foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
VBDPR GEWEI SYST MANDT T006 Units of Measurement MANDT
VBDPR GEWEI VBDPR GEWEI T006 Units of Measurement MSEHI
VBDPR KMEIN SYST MANDT T006 Units of Measurement MANDT
VBDPR KMEIN VBDPR KMEIN T006 Units of Measurement MSEHI
VBDPR KUNWE SYST MANDT KNA1 General Data in Customer Master MANDT
VBDPR KUNWE VBDPR KUNWE KNA1 General Data in Customer Master KUNNR
VBDPR LAND1_WE SYST MANDT T005 Countries MANDT
VBDPR LAND1_WE VBDPR LAND1_WE T005 Countries LAND1
VBDPR MATNR SYST MANDT MARA General Material Data MANDT
VBDPR MATNR VBDPR MATNR MARA General Material Data MATNR
VBDPR MATWA SYST MANDT MARA General Material Data MANDT
VBDPR MATWA VBDPR MATWA MARA General Material Data MATNR
VBDPR POSNR SYST MANDT VBUP Sales Document: Item Status MANDT
VBDPR POSNR VBUK VBELN VBUP Sales Document: Item Status VBELN
VBDPR POSNR VBDPR POSNR VBUP Sales Document: Item Status POSNR
VBDPR POSNR_VAUF VBDPR VBELN_VAUF VBUP Sales Document: Item Status VBELN
VBDPR POSNR_VAUF VBDPR POSNR_VAUF VBUP Sales Document: Item Status POSNR
VBDPR POSNR_VAUF SYST MANDT VBUP Sales Document: Item Status MANDT
VBDPR POSPA SYST MANDT VBUP Sales Document: Item Status MANDT
VBDPR POSPA VBDPR VBELN_VL VBUP Sales Document: Item Status VBELN
VBDPR POSPA VBDPR POSPA VBUP Sales Document: Item Status POSNR
VBDPR REGIO_WE VBDPR REGIO_WE T005S Taxes: Region (Province) Key BLAND
VBDPR REGIO_WE SYST MANDT T005S Taxes: Region (Province) Key MANDT
VBDPR REGIO_WE VBDPR LAND1_WE T005S Taxes: Region (Province) Key LAND1
VBDPR VBELN_VAUF SYST MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
VBDPR VBELN_VAUF VBDPR VBELN_VAUF VBUK Sales Document: Header Status and Administrative Data VBELN
VBDPR VBELN_VL SYST MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
VBDPR VBELN_VL VBDPR VBELN_VL VBUK Sales Document: Header Status and Administrative Data VBELN
VBDPR VGBEL VBDPR VGBEL VBUK Sales Document: Header Status and Administrative Data VBELN
VBDPR VGBEL SYST MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
VBDPR VGPOS SYST MANDT VBUP Sales Document: Item Status MANDT
VBDPR VGPOS VBDPR VGBEL VBUP Sales Document: Item Status VBELN
VBDPR VGPOS VBDPR VGPOS VBUP Sales Document: Item Status POSNR
VBDPR VOLEH SYST MANDT T006 Units of Measurement MANDT
VBDPR VOLEH VBDPR VOLEH T006 Units of Measurement MSEHI
VBDPR VRKME SYST MANDT T006 Units of Measurement MANDT
VBDPR VRKME VBDPR VRKME T006 Units of Measurement MSEHI
VBDPR WAERK VBDPR WAERK TCURC Currency Codes WAERS
VBDPR WAERK SYST MANDT TCURC Currency Codes MANDT