1. Home
  2. Resources
  3. SAP Tables
  4. HV03V - Availability Check and Requirements at Item Level

SAP Table HV03V

Availability Check and Requirements at Item Level

HV03V (Availability Check and Requirements at Item Level) 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 HV03V to other SAP tables.

HV03V table fields

Field Data element Checktable Datatype Length Decimals
MATNR Material Number MATNR MARA CHAR 18 0
WERKS Plant WERKS_D T001W CHAR 4 0
UPDKZ_WK Update indicator UPDKZ_D CHAR 1 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
XCHPF Batch management requirement indicator XCHPF CHAR 1 0
X Yes
NULL No
POSNR Item number of the SD document POSNR VBUP NUMC 6 0
KOSCH Product allocation determination procedure KOSCH CHAR 18 0
MTART Material Type MTART CHAR 4 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)
MTVFP Checking Group for Availability Check MTVFP TMVF CHAR 2 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
FIXMG Delivery date and quantity fixed FIXMG CHAR 1 0
X Yes
NULL No
BLOCK Single-Character Indicator CHAR1 CHAR 1 0
MNTGA 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)
AENKZ Change indicator AENKZ CHAR 1 0
TRTYP Transaction type TRTYP CHAR 1 0
* Masked
A Display
B Edit
C Display from archive
E Single-item planning
H Add
V Change
X Initial transaction
S Standard parameter: normal mode
U Convert indiv. planned order
L Delete
P Planning file entry
K Copy reference
D Print
AUART_PP Order Type AUFART CHAR 4 0
CNFKZ Indicator: changed configuration CO_CNFKZ CHAR 1 0
NULL No new master data
1 New routing selection
2 New BOM explosion
3 New routing selection/BOM explosion
VKOMP Availability check at component level in assembly order VKOMP CHAR 1 0
X Yes
NULL No
KZAKP Indicator for type of component check KZAKP CHAR 1 0
NULL ATP check
1 Check against preliminary planning
KOTYP Cost accounting type KOTYP CHAR 1 0
KOBEA Single-Character Indicator CHAR1 CHAR 1 0
VFDIA Single-Character Indicator CHAR1 CHAR 1 0
VKAPA Display Capacity Availability VKAPA CHAR 1 0
1 Lead time scheduling
2 Lead time scheduling and capacity check
CUOBJ Configuration (internal object number) CUOBJ NUMC 18 0
PWERT Total net value of selected items PWERT_D CURR 15 2
WAERS Currency Key WAERS CUKY 5 0
SERNR BOM explosion number SERNR CHAR 8 0
EFFEX Return Code SYSUBRC INT4 10 0
LPRIO Delivery Priority LPRIO NUMC 2 0
RFMNG Dummy RFMNG_FLO FLTP 16 16
FABKL Factory calendar key FABKL CHAR 2 0
EISBE Safety Stock EISBE QUAN 13 3
UMLMC Stock in Transfer (Plant to Plant) UMLME QUAN 13 3
PLIFZ Planned Delivery Time in Days PLIFZ DEC 3 0
WEBAZ Goods Receipt Processing Time in Days WEBAZ DEC 3 0
WZEIT Total replenishment lead time (in workdays) WZEIT DEC 3 0
DZEIT In-house production time DZEIT DEC 3 0
BEARZ Processing time BEARZ DEC 5 2
BASMG Base quantity BASMG QUAN 13 3
RUEZT Setup and teardown time RUEZT DEC 5 2
TRANZ Interoperation time TRANZ DEC 5 2
DISMM MRP Type DISMM CHAR 2 0
PLNKZ Planning Indicator PLNKZ CHAR 1 0
1 Net requirements planning
2 Gross requirements planning
3 Single-item planning
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
BESKZ Procurement Type BESKZ CHAR 1 0
E In-house production
F External procurement
NULL No procurement
X Both procurement types
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
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
QMATV Inspection Setup Exists for Material/Plant QMATV CHAR 1 0
X Yes
NULL No
UMREF Conversion factor: quantities UMREFF FLTP 16 16
KUNNR Customer Number KUNNR CHAR 10 0
SOBKZ Special Stock Indicator SOBKZ CHAR 1 0
UMSOK Special Stock Indicator for Physical Stock Transfer UMSOK CHAR 1 0
KNTTP Account Assignment Category KNTTP 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
PSPEL WBS Element PS_POSNR NUMC 8 0
VBELE Business document number VBELE CHAR 10 0
POSNE Business item number POSNE NUMC 6 0
VKORG Sales Organization VKORG CHAR 4 0
VTWKU Reference distrib.channel for cust.and material masters VTWKU CHAR 2 0
AUTLF Complete delivery defined for each sales order? AUTLF CHAR 1 0
X Yes
NULL No
GRKOR Delivery group (items are delivered together) GRKOR NUMC 3 0
KZTLF Partial delivery at item level KZTLF CHAR 1 0
NULL Partial delivery allowed
A Create a delivery with qty greater than zero
B Create only one delivery (also with quantity = 0)
C Only complete delivery allowed
D No limit to subsequent deliveries
ANTLF Maximum Number of Partial Deliveries Allowed Per Item ANTLF DEC 1 0
AWAHR Order probability of the item AWAHR NUMC 3 0
000 Sales order probability
MEINS Base Unit of Measure MEINS T006 UNIT 3 0
UMVKN Denominator (Divisor) for Conversion of Sales Qty into SKU UMVKN DEC 5 0
UMVKZ Numerator (factor) for conversion of sales quantity into SKU UMVKZ DEC 5 0
VRKME Sales unit VRKME T006 UNIT 3 0
VSTEL Shipping Point/Receiving Point VSTEL TVST CHAR 4 0
ROUTE Route ROUTE TVRO CHAR 6 0
LADGR Loading Group LADGR TLGR CHAR 4 0
TRTRM Activate transportation scheduling TRTRM CHAR 1 0
X Yes
NULL No
VSTRM Activate delivery scheduling VSTRM CHAR 1 0
NULL Shipping scheduling off
A Shipping scheduling delivery order (w/o loading time) on
X Shipping scheduling on
VSBED Shipping Conditions VSBED CHAR 2 0
TRAGR Transportation Group TRAGR CHAR 4 0
RFPA_SW Route schedule switch for order types RFPA_SW CHAR 1 0
X Yes
NULL No
AUBST Purchase requisition with delivery scheduling AUBST CHAR 1 0
X Yes
NULL No
ARKTX Short text for sales order item ARKTX CHAR 40 0
WKMNG Plant stock in sales units WKMNG QUAN 13 3
KATPMN Cumulative ATP quantity (available to promise) KATPMN QUAN 15 3
POSGUID ATP: Encryption of DELNR and DELPS POSGUID CHAR 22 0
TPROC ATP: Technical process for RBA TPROC CHAR 2 0
BPROC ATP: Business Transaction for ATP BPROC CHAR 4 0
ACTYP ATP: Transaction type for RBA ACTTP CHAR 2 0
SUREA ATP: Substitution reason for rules-based ATP SUREA CHAR 4 0
NUATO No assembly order update NUATO CHAR 1 0
X Yes
NULL No
XLINE Line index for internal table processing XLINE INT4 10 0
SYSIND ATP: Indicator for system SYSIND CHAR 1 0
NULL No system change
X System change with third-party order processing
Y System change with stock transfer
LOCNO Location number in APO APOLOCNO CHAR 20 0
LOCTYPE APO location type APOLOCTYPE CHAR 4 0
VGBEL Document number of the reference document VGBEL CHAR 10 0
VGPOS Item number of the reference item VGPOS NUMC 6 0
REMFLG ATP: Remaining requirements (yes/no)? RRFLG CHAR 1 0
X Yes
NULL No
WRKMOD ATP: Working Mode for APO WRKMOD CHAR 1 0
NULL Standard check
A Check based on saved process
KEEP_LM Checkbox XFELD CHAR 1 0
X Yes
NULL No
VFPPR_POS Checkbox XFELD CHAR 1 0
X Yes
NULL No
DIFF_PRUEF_RFMNG Quantity for completion (sales) in basic unit of measure ERLMENGF FLTP 16 16
SOBSL Special procurement type SOBSL CHAR 2 0
CUOBJ_CH Internal object number of the batch classification CUOBJ_CH NUMC 18 0
TTYPE Means of Transport Used in APO TRATY_APO CHAR 10 0
APOSCHREQ APO indicator for scheduling and requirements APOSCHREQ CHAR 1 0
X Yes
NULL No
WETZON Time Zone TZNZONE CHAR 6 0
HMLUP Checkbox XFELD CHAR 1 0
X Yes
NULL No
LOGSYSPRE Logical system LOGSYS CHAR 10 0
NO_SCHEDUL Do Not Perform Transportation and Delivery Scheduling NO_SCHEDUL CHAR 1 0
X Yes
NULL No
NO_REQMNTS Do Not Store Requirements Records NO_REQMNTS CHAR 1 0
X Yes
NULL No
WERKS_EXT Plant WERKS_D CHAR 4 0
ATPC_PICK Pick up confirmation schedule line from ATP Controller ATPC_PICK CHAR 1 0
X Yes
NULL No
GRDAT Schedule line date EDATU DATS 8 0
GRUHR Arrival time EZEIT_VBEP TIMS 6 0
GRART Delivery Group Correlation Type LGKART CHAR 1 0
A Deadline Correlation
B Deadline and Quantity Correlation
GRARTFOR ATP: Overriding Correlation Calculation Type GRARTFOR CHAR 1 0
NULL Correlation Type from Correlation Profile Is Used
T Only Deadlines Are Correlated
REQQTY_HD ATP Server: ATP quantity ATPMNG QUAN 15 3
REQDAT_HD Schedule line date EDATU DATS 8 0
REQUHR_HD Arrival time EZEIT_VBEP TIMS 6 0
MEINS_HD Base Unit of Measure MEINS UNIT 3 0
KZWSM Units of measure usage KZWSO CHAR 1 0
NULL Alternative unit of measure
A Proportion unit
B Product unit
TMREL External Transportation Management System (TMS) Relevance TMREL CHAR 1 0
NULL Not Relevant
X Relevant
KZAZU Order Combination Indicator KZAZU_D CHAR 1 0
X Yes
NULL No
LOG_TM_NR Technical Transportation Management Number LOG_TM_NR CHAR 4 0
RBACONTROL Control of Rules-Based ATP Check RBACONTROL CHAR 1 0
NULL Subitems Allowed, Plant Substitution in Item Not Allowed
C Subitems and Plant Substitution in Item Not Allowed
D Subitems Not Allowed, Plant Substitution in Item Allowed
E Subitems and Plant Substitution in Item Allowed
N Rules-Based ATP Check Not Allowed
RBAEXCHANGE RBA Substitution Control RBAEXCHANGE CHAR 1 0
NULL No Substitution
P Plant Substitution in Item; Do Not Generate Subitems
DUMMY Checkbox XFELD CHAR 1 0
X Yes
NULL No

HV03V foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
HV03V CHARG HV03V MATNR MCHA Batches MATNR
HV03V CHARG HV03V WERKS MCHA Batches WERKS
HV03V CHARG HV03V CHARG MCHA Batches CHARG
HV03V CHARG SY MANDT MCHA Batches MANDT
HV03V LADGR SYST MANDT TLGR Routes: Loading Groups MANDT
HV03V LADGR HV03V LADGR TLGR Routes: Loading Groups LADGR
HV03V LGORT HV03V LGORT T001L Storage Locations LGORT
HV03V LGORT SYST MANDT T001L Storage Locations MANDT
HV03V LGORT HV03V WERKS T001L Storage Locations WERKS
HV03V MATNR SYST MANDT MARA General Material Data MANDT
HV03V MATNR HV03V MATNR MARA General Material Data MATNR
HV03V MEINS SYST MANDT T006 Units of Measurement MANDT
HV03V MEINS HV03V MEINS T006 Units of Measurement MSEHI
HV03V MTVFP SYST MANDT TMVF Availability Check Control MANDT
HV03V MTVFP HV03V MTVFP TMVF Availability Check Control MTVFP
HV03V POSNR VBUK VBELN VBUP Sales Document: Item Status VBELN
HV03V POSNR HV03V POSNR VBUP Sales Document: Item Status POSNR
HV03V POSNR SYST MANDT VBUP Sales Document: Item Status MANDT
HV03V ROUTE SYST MANDT TVRO Routes MANDT
HV03V ROUTE HV03V ROUTE TVRO Routes ROUTE
HV03V VRKME HV03V VRKME T006 Units of Measurement MSEHI
HV03V VRKME SYST MANDT T006 Units of Measurement MANDT
HV03V VSTEL SYST MANDT TVST Organizational Unit: Shipping Points MANDT
HV03V VSTEL HV03V VSTEL TVST Organizational Unit: Shipping Points VSTEL
HV03V WERKS SYST MANDT T001W Plants/Branches MANDT
HV03V WERKS HV03V WERKS T001W Plants/Branches WERKS