SAP table HV03V (Availability Check and Requirements at Item Level)

Field Description Data Type Length Decimals Checktable Data Element
MATNR Material Number CHAR 40 0 MARA MATNR
WERKS Plant CHAR 4 0 T001W WERKS_D
UPDKZ_WK Update indicator CHAR 1 0 UPDKZ_D
LGORT Storage location CHAR 4 0 T001L LGORT_D
BERID MRP Area CHAR 10 0 BERID
CHARG Batch Number CHAR 10 0 MCHA CHARG_D
XCHPF Batch Management Requirement Indicator CHAR 1 0 XCHPF
POSNR Item number of the SD document NUMC 6 0 POSNR
KOSCH Product allocation determination procedure CHAR 18 0 KOSCH
MTART Material type CHAR 4 0 MTART
APOKZ Indicator: Is material relevant for APO CHAR 1 0 APOKZ
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 CHAR 2 0 TMVF MTVFP
SUMBD Summing up of requirements CHAR 1 0 SUMBD
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 CHAR 1 0 FIXMG
BLOCK Single-Character Flag CHAR 1 0 CHAR1
MNTGA Assembly type NUMC 1 0 MNTGA
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 CHAR 1 0 AENKZ
TRTYP Transaction type CHAR 1 0 TRTYP
* Masked
A Display
B Edit
C Display from archive
D Print
E Single-item planning
H Add
K Copy reference
L Delete
P Planning file entry
S Standard parameter: normal mode
U Convert indiv. planned order
V Change
X Initial transaction
AUART_PP Order Type CHAR 4 0 * AUFART
CNFKZ Indicator: changed configuration CHAR 1 0 CO_CNFKZ
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 CHAR 1 0 VKOMP
KZAKP Indicator for type of component check CHAR 1 0 KZAKP
ATP check
1 Check against preliminary planning
KOTYP Cost Accounting Type CHAR 1 0 KOTYP
KOBEA Single-Character Flag CHAR 1 0 CHAR1
VFDIA Single-Character Flag CHAR 1 0 CHAR1
VKAPA Display Capacity Availability CHAR 1 0 VKAPA
1 Lead time scheduling
2 Lead time scheduling and capacity check
CUOBJ Configuration (internal object number) NUMC 18 0 CUOBJ
PWERT Total net value of selected items CURR 15 2 PWERT_D
WAERS Currency Key CUKY 5 0 * WAERS
SERNR BOM explosion number CHAR 8 0 * SERNR
EFFEX Return Code INT4 10 0 SYSUBRC
LPRIO Delivery Priority NUMC 2 0 * LPRIO
RFMNG Dummy FLTP 16 16 RFMNG_FLO
FABKL Factory calendar key CHAR 2 0 FABKL
EISBE Safety Stock QUAN 13 3 EISBE
UMLMC Stock in transfer (plant to plant) QUAN 13 3 UMLME
PLIFZ Planned Delivery Time in Days DEC 3 0 PLIFZ
WEBAZ Goods receipt processing time in days DEC 3 0 WEBAZ
WZEIT Total replenishment lead time (in workdays) DEC 3 0 WZEIT
DZEIT In-house production time DEC 3 0 DZEIT
BEARZ Processing time DEC 5 2 BEARZ
BASMG Base quantity QUAN 13 3 BASMG
RUEZT Setup and teardown time DEC 5 2 RUEZT
TRANZ Interoperation time DEC 5 2 TRANZ
DISMM MRP Type CHAR 2 0 DISMM
PLNKZ Planning Indicator CHAR 1 0 PLNKZ
1 Net requirements planning
2 Gross requirements planning
3 Single-item planning
MISKZ Mixed MRP indicator CHAR 1 0 MISKZ
1 Subassembly planning with final assembly
2 Gross requirements planning
3 Subassembly planning without final assembly
VRMOD Consumption mode CHAR 1 0 VRMOD
1 Backward consumption only
2 Backward/forward consumption
3 Forward consumption only
4 Forward/backward consumption
5 Period-specific consumption
VINT1 Consumption period: backward NUMC 3 0 VINT1
VINT2 Consumption period: forward NUMC 3 0 VINT2
DISST Low-Level Code CHAR 3 0 DISST
DISKZ Storage location MRP indicator CHAR 1 0 DISKZ
Storage location stock also planned at plant level
1 Storage location stock excluded from MRP
2 Storage location stock planned separately
DISGR MRP Group CHAR 4 0 DISGR
BESKZ Procurement Type CHAR 1 0 BESKZ
No Procurement
E In-House Production
F External Procurement
X Both Procurement Types
VPZUO Allocation Indicator CHAR 1 0 VPZUO
VPMAT Planning material CHAR 40 0 VPMAT
VPWRK Planning plant CHAR 4 0 VPWRK
PRBME Base unit of measure for product group UNIT 3 0 PRBME
NODIS Requirements record not relevant to MRP CHAR 1 0 NODIS
Requirement planned
1 Requirement not planned, but displayed
2 Requirements neither planned or displayed
QMATV Inspection Setup Exists for Material/Plant CHAR 1 0 QMATV
UMREF Conversion factor: quantities FLTP 16 16 UMREFF
KUNNR Customer Number CHAR 10 0 KUNNR
SOBKZ Special Stock Indicator CHAR 1 0 SOBKZ
UMSOK Special stock indicator for physical stock transfer CHAR 1 0 UMSOK
KNTTP Account Assignment Category CHAR 1 0 KNTTP
KZBWS Valuation of Special Stock CHAR 1 0 KZBWS
No stock valuation
A Valuation without reference to sales document
M Separate valuation with ref. to sales document/project
KZVBR Consumption posting CHAR 1 0 KZVBR
No consumption
A Asset
E Sales order
P Project
V Consumption
PSPEL WBS Element NUMC 8 0 PS_POSNR
VBELE Business document number CHAR 10 0 VBELE
POSNE Business item number NUMC 6 0 POSNE
VKORG Sales Organization CHAR 4 0 VKORG
VTWKU Reference distrib.channel for cust.and material masters CHAR 2 0 VTWKU
AUTLF Complete Delivery Defined for Each Sales Order? CHAR 1 0 AUTLF
GRKOR Delivery Group (Items are delivered together) NUMC 3 0 GRKOR
KZTLF Partial delivery at item level CHAR 1 0 KZTLF
Partial delivery allowed
A Create a delivery with quantity 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 DEC 1 0 ANTLF
AWAHR Order Probability of the Item NUMC 3 0 AWAHR
000 Sales order probability
MEINS Base Unit of Measure UNIT 3 0 T006 MEINS
UMVKN Denominator (divisor) for conversion of sales Qty into SKU DEC 5 0 UMVKN
UMVKZ Numerator (factor) for conversion of sales quantity into SKU DEC 5 0 UMVKZ
VRKME Sales unit UNIT 3 0 T006 VRKME
SUBSTN_NUMERATOR Quantity Conversion: Numerator INT2 5 0 MD_SUBSTN_NUMERATOR
SUBSTN_DENOMINATOR Quantity Conversion: Denominator INT2 5 0 MD_SUBSTN_DENOMINATOR
VSTEL Shipping Point / Receiving Point CHAR 4 0 TVST VSTEL
ROUTE Route CHAR 6 0 TVRO ROUTE
LADGR Loading Group CHAR 4 0 TLGR LADGR
TRTRM Activate Transportation Scheduling CHAR 1 0 TRTRM
VSTRM Activate Delivery Scheduling CHAR 1 0 VSTRM
Shipping scheduling off
A Shipping scheduling delivery order (only loading time) on
X Shipping scheduling on
VSBED Shipping Conditions CHAR 2 0 VSBED
TRAGR Transportation Group CHAR 4 0 TRAGR
RFPA_SW Route schedule switch for order types CHAR 1 0 RFPA_SW
AUBST Purchase requisition with delivery scheduling CHAR 1 0 AUBST
ARKTX Short text for sales order item CHAR 40 0 ARKTX
WKMNG Plant stock in sales units QUAN 13 3 WKMNG
KATPMN Cumulative ATP Quantity (Available to Promise) QUAN 15 3 KATPMN
POSGUID ATP: Encryption of DELNR and DELPS CHAR 22 0 POSGUID
TPROC ATP: Technical process for RBA CHAR 2 0 TPROC
BPROC ATP: Business Transaction for ATP CHAR 4 0 BPROC
ACTYP ATP: Transaction type for RBA CHAR 2 0 ACTTP
SUREA ATP: Substitution reason for rules-based ATP CHAR 4 0 SUREA
NUATO No assembly order update CHAR 1 0 NUATO
XLINE Line index for internal table processing INT4 10 0 XLINE
SYSIND ATP: Indicator for system CHAR 1 0 SYSIND
No system change
X System change with third-party order processing
Y System change with stock transfer
LOCNO Location number in APO CHAR 20 0 APOLOCNO
LOCTYPE APO location type CHAR 4 0 APOLOCTYPE
VGBEL Document number of the reference document CHAR 10 0 VGBEL
VGPOS Item number of the reference item NUMC 6 0 VGPOS
VGTYP 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)
REMFLG ATP: Remaining requirements (yes/no)? CHAR 1 0 RRFLG
WRKMOD ATP: Working Mode for APO CHAR 1 0 WRKMOD
Standard check
A Check based on saved process
KEEP_LM Checkbox CHAR 1 0 XFELD
No
X Yes
VFPPR_POS Checkbox CHAR 1 0 XFELD
No
X Yes
DIFF_PRUEF_RFMNG Quantity for completion (sales) in basic unit of measure FLTP 16 16 ERLMENGF
SOBSL Special procurement type CHAR 2 0 SOBSL
CUOBJ_CH Internal object number of the batch classification NUMC 18 0 CUOBJ_CH
TTYPE Means of Transport Used in APO CHAR 10 0 TRATY_APO
APOSCHREQ APO indicator for scheduling and requirements CHAR 1 0 APOSCHREQ
WETZON Time Zone CHAR 6 0 TZNZONE
HMLUP Checkbox CHAR 1 0 XFELD
No
X Yes
LOGSYSPRE Logical system CHAR 10 0 LOGSYS
NO_SCHEDUL Do Not Perform Transportation and Delivery Scheduling CHAR 1 0 NO_SCHEDUL
NO_REQMNTS Do Not Store Requirements Records CHAR 1 0 NO_REQMNTS
WERKS_EXT Plant CHAR 4 0 WERKS_D
ATPC_PICK Pick up confirmation schedule line from ATP Controller CHAR 1 0 ATPC_PICK
GRDAT Schedule line date DATS 8 0 EDATU
GRUHR Arrival time TIMS 6 0 EZEIT_VBEP
GRART Delivery Group Correlation Type CHAR 1 0 LGKART
A Deadline Correlation
B Deadline and Quantity Correlation
GRARTFOR ATP: Overriding Correlation Calculation Type CHAR 1 0 GRARTFOR
Correlation Type from Correlation Profile Is Used
T Only Deadlines Are Correlated
REQQTY_HD ATP Server: ATP quantity QUAN 15 3 ATPMNG
REQDAT_HD Schedule line date DATS 8 0 EDATU
REQUHR_HD Arrival time TIMS 6 0 EZEIT_VBEP
MEINS_HD Base Unit of Measure UNIT 3 0 MEINS
KZWSM Units of measure usage CHAR 1 0 KZWSO
Alternative unit of measure
A Proportion unit
B Product unit
TMREL External Transportation Management System (TMS) Relevance CHAR 1 0 TMREL
Not Relevant
X Relevant
KZAZU Order Combination Indicator CHAR 1 0 KZAZU_D
LOG_TM_NR Technical Transportation Management Number CHAR 4 0 LOG_TM_NR
RBACONTROL Control of Rules-Based ATP Check CHAR 1 0 RBACONTROL
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 CHAR 1 0 RBAEXCHANGE
No Substitution
P Plant Substitution in Item; Do Not Generate Subitems
ORIGINAL_PLANT Original Plant in Plant Substitution CHAR 4 0 ORIGINAL_PLANT
ATP_ABC_SUBSTITUTION_STATUS Substitution Status for Alternative-Based Confirmation (ABC) CHAR 1 0 ATP_ABC_SUBSTITUTION_STATUS
ABC Inactive
A Original Main Item for ABC
B Subitem Substituting Original Main Item
D Inline Substitute for Original Main Item
DEACTIVATE_ABC Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') CHAR 1 0 BOOLE_D
FORBID_INLINE_SUBSTITUTION Forbid inline substitution CHAR 1 0 ATP_ABC_FORBID_INLINE_SUBST
FORBID_SUBITEM_GENERATION Forbid subitem generation CHAR 1 0 ATP_ABC_FORBID_SUBITEM_GEN
ENFORCE_SUBITEM_GENERATION Enforce the Generation of a Subitem CHAR 1 0 ATP_ABC_ENFORCE_SUBITEM_GEN
SUBITEM Subitem INT4 10 0 ATP_SUBITEM
REVFP Rule for transferring the results of the availability check CHAR 1 0 REVFP
Dialog Box for Shortages (Batch/BAPI Full Delivery)
1 Delivery Proposal for Product Selection
A One-Time Delivery
B Full Delivery
C Delivery Proposal
D Dialog Box for Shortages (Batch/BAPI One-Time Delivery)
E Dialog Box (Batch/BAPI Delivery Proposal)
F Dialog Box (Batch/BAPI Full Delivery) as Item Overrride
DUMMY Checkbox CHAR 1 0 XFELD
No
X Yes
SGT_RCAT Requirement Segment CHAR 40 0 SGT_RCAT
SGT_SCOPE Segmentation Strategy Scope CHAR 1 0 SGT_SCOPE
1 Requirement and Stock Segments maintained
2 Only Requirement Segments maintained
SGT_COVS Segmentation Strategy CHAR 8 0 SGT_COVS
SGT_MRPSI Sort Stock based on Segment CHAR 1 0 SGT_SRT_STK
Requested Delivery Date higher than Segment
X Segment higher than Requested Delivery Date
FSH_MG_ARUN_REQ Supply Assignment (ARun) CHAR 1 0 FSH_MG_ARUN_REQ
ARun Non-Relevant
1 ARun Relevant
FPRFM Distribution profile of material in plant CHAR 3 0 * FPRFM
ARUN_FIX_BATCH Assign Batches in Supply Assignment (ARun) CHAR 1 0 ARUN_FIX_BATCH
Do not Assign Batches
1 Assign Batches
SATNR Cross-Plant Configurable Material CHAR 40 0 * SATNR
FSH_CALENDAR_GROUP Calendar Group CHAR 4 0 FSH_CALENDAR_GROUP

HV03V foreign key relationships

Table Field Check Table Check Field
0 HV03V CHARG MCHA Batches MANDT
0 HV03V CHARG MCHA Batches WERKS
0 HV03V CHARG MCHA Batches CHARG
1 HV03V LADGR TLGR Routes: Loading Groups LADGR
0 HV03V LGORT T001L Storage Locations MANDT
0 HV03V LGORT T001L Storage Locations WERKS
1 HV03V MATNR MARA General Material Data MANDT
1 HV03V MATNR MARA General Material Data MATNR
0 HV03V MEINS T006 Units of Measurement MANDT
0 HV03V MEINS T006 Units of Measurement MSEHI
1 HV03V MTVFP TMVF Availability Check Control MTVFP
0 HV03V ROUTE TVRO Routes MANDT
0 HV03V ROUTE TVRO Routes ROUTE
1 HV03V VRKME T006 Units of Measurement MANDT
1 HV03V VRKME T006 Units of Measurement MSEHI
0 HV03V VSTEL TVST Organizational Unit: Shipping Points MANDT
0 HV03V VSTEL TVST Organizational Unit: Shipping Points VSTEL
1 HV03V WERKS T001W Plants/Branches MANDT
1 HV03V WERKS T001W Plants/Branches WERKS