SAP Table BV03V

Structure of Indiv/Collective Requirements

BV03V (Structure of Indiv/Collective Requirements) 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 BV03V to other SAP tables.

BV03V table fields

Field Data element Checktable Datatype Length Decimals
NEWPOS Item number of the SD document POSNR VBUP NUMC 6 0
MATNR Material Number MATNR MARA CHAR 18 0
WERKS Plant WERKS_D T001W CHAR 4 0
MBDAT Material Staging/Availability Date MBDAT DATS 8 0
VBELN Sales and Distribution Document Number VBELN VBUK CHAR 10 0
POSNR Item number of the SD document POSNR VBUP NUMC 6 0
ETENR Delivery Schedule Line Number ETENR VBEP NUMC 4 0
LGORT Storage Location LGORT_D T001L CHAR 4 0
BERID MRP Area BERID CHAR 10 0
CHARG Batch Number CHARG_D MCHA CHAR 10 0
VBTYP 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
BDART Requirement type BDART CHAR 2 0
PLART Planning type PLART CHAR 1 0
OMENG Open Qty in Stockkeeping Units for Transfer of Reqmts to MRP OMENG QUAN 15 3
VMENG Confirmed quantity for availability check in SKU VMENG QUAN 15 3
PZMNG Planned allocation quantity for independent requirements PZMNG QUAN 15 3
RFMNG Referenced quantity in base unit of measure RFMNG QUAN 15 3
OMMAX Open Qty in Stockkeeping Units for Transfer of Reqmts to MRP OMENG QUAN 15 3
VMMAX Confirmed quantity for availability check in SKU VMENG QUAN 15 3
MEINS Base Unit of Measure MEINS T006 UNIT 3 0
VBELE Business document number VBELE VBUK CHAR 10 0
POSNE Business item number POSNE VBUP NUMC 6 0
ETENE Schedule line ETENE VBEP NUMC 4 0
AWAHR Order probability of the item AWAHR NUMC 3 0
000 Sales order probability
AUART Sales Document Type AUART TVAK CHAR 4 0
KUNNR Customer Number KUNNR KNA1 CHAR 10 0
NODIS Requirements record not relevant to MRP NODIS CHAR 1 0
NULL Requirement planned
1 Requirement not planned, but displayed
2 Requirements neither planned or displayed
VPZUO Allocation Indicator VPZUO CHAR 1 0
NULL No consumption with customer requirements
1 Consume planning with assembly
2 Consume planning w/o assembly
3 Consume planning material (w/o assembly)
VPMAT Planning material VPMAT CHAR 18 0
VPWRK Planning plant VPWRK CHAR 4 0
PRBME Base unit of measure for product group PRBME UNIT 3 0
UMREF Conversion factor: quantities UMREFF FLTP 16 16
KNTTP Account Assignment Category KNTTP CHAR 1 0
SOBKZ Special Stock Indicator SOBKZ CHAR 1 0
KZBWS Valuation of Special Stock KZBWS CHAR 1 0
NULL No stock valuation
M Separate valuation with ref. to sales document/project
A Valuation without reference to sales document
KZVBR Consumption Posting KZVBR CHAR 1 0
NULL No consumption
V Consumption
A Asset
E Sales order
P Project
SERNR BOM explosion number SERNR CHAR 8 0
PSPEL WBS Element PS_POSNR NUMC 8 0
PLNKZ Planning Indicator PLNKZ CHAR 1 0
1 Net requirements planning
2 Gross requirements planning
3 Single-item planning
DISMM MRP Type DISMM CHAR 2 0
MISKZ Mixed MRP indicator MISKZ CHAR 1 0
1 Subassembly planning with final assembly
2 Gross requirements planning
3 Subassembly planning without final assembly
VRMOD Consumption mode VRMOD CHAR 1 0
1 Backward consumption only
2 Backward/forward consumption
3 Forward consumption only
4 Forward/backward consumption
VINT1 Consumption period: backward VINT1 NUMC 3 0
VINT2 Consumption period: forward VINT2 NUMC 3 0
DISST Low-Level Code DISST CHAR 3 0
DISKZ Storage location MRP indicator DISKZ CHAR 1 0
NULL Storage location stock also planned at plant level
1 Storage location stock excluded from MRP
2 Storage location stock planned separately
DISGR MRP Group DISGR CHAR 4 0
DIBER Indicator: MRP area exists DIBER CHAR 1 0
X Yes
NULL No
WZEIT Total replenishment lead time (in workdays) WZEIT DEC 3 0
DZEIT In-house production time DZEIT DEC 3 0
APOKZ Indicator: Is material relevant for APO APOKZ CHAR 1 0
NULL Material is not relevant to APO
1 ATP check will be carried out in APO for material
2 ATP check and planning will be carried out in APO
3 Is active in APO integration model (set automatically)
EDATU Schedule line date EDATU DATS 8 0
SUMBD Summing up of requirements SUMBD CHAR 1 0
A Single records
B Totals records per day
C Totals records per week, reqs date on Monday of current week
D Totals records per week, reqs date on Monday of fol. week
ERVFP Availability: Original req'ments are completed with 1st ref. ERVFP CHAR 1 0
X Yes
NULL No
BDODB Requirements record has no data record (internal flag) BDODB CHAR 1 0
X Yes
NULL No
TABIX_BD Field defined as in SY-TABIX TABIX_D INT4 10 0
TABIX_OM Field defined as in SY-TABIX TABIX_D INT4 10 0
CUOBJ Configuration CUOBJ_VA NUMC 18 0
CUOBJ_CH Internal object number of the batch classification CUOBJ_CH NUMC 18 0
TECHS Parameter Variant/Standard Variant TECHS CHAR 12 0
AESKD Customer Engineering Change Status AESKD CHAR 17 0
MONKZ Assembly type MNTGA NUMC 1 0
0 No assembly order processing
1 Planned order ("static" processing)
2 Production order, network or service (static processing)
3 Production order (dynamic processing)
4 Planned order (dynamic processing)
POSGUID ATP: Encryption of DELNR and DELPS POSGUID CHAR 22 0
EZEIT Arrival time EZEIT_VBEP TIMS 6 0
MBUHR Material Staging Time (Local, Relating to a Plant) MBUHR TIMS 6 0
APOMOBILE Indicator for schedule line transfer to APO APOMOBILE CHAR 1 0
NULL Update Requirements in ERP; Transfer to APO (If Possible)
0 Update Requirements in ERP; No Transfer to APO
1 RBA Main Item
2 External Plant but No RBA Main Item
3 No ERP Requirements Update; No Transfer to APO
4 No ERP Requirements Update; but Transfer to APO
5 Goods Issue Posting, Transfer to APO for Receipt Element
6 Returns Item
7 Return Delivery Item
LOGSYSB Logical system with which document was created LOGSYSB CHAR 10 0
PZMNG_SA Planned allocation quantity for independent requirements PZMNG QUAN 15 3

BV03V foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
BV03V AUART SYST MANDT TVAK Sales Document Types MANDT
BV03V AUART BV03V AUART TVAK Sales Document Types AUART
BV03V CHARG BV03V WERKS MCHA Batches WERKS
BV03V CHARG BV03V CHARG MCHA Batches CHARG
BV03V CHARG SYST MANDT MCHA Batches MANDT
BV03V CHARG BV03V MATNR MCHA Batches MATNR
BV03V ETENE SYST MANDT VBEP Sales Document: Schedule Line Data MANDT
BV03V ETENE BV03V VBELE VBEP Sales Document: Schedule Line Data VBELN
BV03V ETENE BV03V POSNE VBEP Sales Document: Schedule Line Data POSNR
BV03V ETENE BV03V ETENE VBEP Sales Document: Schedule Line Data ETENR
BV03V ETENR BV03V VBELN VBEP Sales Document: Schedule Line Data VBELN
BV03V ETENR BV03V POSNR VBEP Sales Document: Schedule Line Data POSNR
BV03V ETENR BV03V ETENR VBEP Sales Document: Schedule Line Data ETENR
BV03V ETENR SYST MANDT VBEP Sales Document: Schedule Line Data MANDT
BV03V KUNNR BV03V KUNNR KNA1 General Data in Customer Master KUNNR
BV03V KUNNR SYST MANDT KNA1 General Data in Customer Master MANDT
BV03V LGORT SYST MANDT T001L Storage Locations MANDT
BV03V LGORT BV03V WERKS T001L Storage Locations WERKS
BV03V LGORT BV03V LGORT T001L Storage Locations LGORT
BV03V MATNR SYST MANDT MARA General Material Data MANDT
BV03V MATNR BV03V MATNR MARA General Material Data MATNR
BV03V MEINS SYST MANDT T006 Units of Measurement MANDT
BV03V MEINS BV03V MEINS T006 Units of Measurement MSEHI
BV03V NEWPOS VBUK MANDT VBUP Sales Document: Item Status MANDT
BV03V NEWPOS VBUK VBELN VBUP Sales Document: Item Status VBELN
BV03V NEWPOS BV03V NEWPOS VBUP Sales Document: Item Status POSNR
BV03V POSNE BV03V VBELE VBUP Sales Document: Item Status VBELN
BV03V POSNE BV03V POSNE VBUP Sales Document: Item Status POSNR
BV03V POSNE SYST MANDT VBUP Sales Document: Item Status MANDT
BV03V POSNR SYST MANDT VBUP Sales Document: Item Status MANDT
BV03V POSNR BV03V VBELN VBUP Sales Document: Item Status VBELN
BV03V POSNR BV03V POSNR VBUP Sales Document: Item Status POSNR
BV03V VBELE SYST MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
BV03V VBELE BV03V VBELE VBUK Sales Document: Header Status and Administrative Data VBELN
BV03V VBELN BV03V VBELN VBUK Sales Document: Header Status and Administrative Data VBELN
BV03V VBELN SYST MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
BV03V WERKS BV03V WERKS T001W Plants/Branches WERKS
BV03V WERKS SYST MANDT T001W Plants/Branches MANDT