VBFA-MATNR SAP table Field - Material Number values
MATNR is a standard field within SAP Table VBFA that stores Material Number information.
Below is the list of attribute values for the MATNR field including its length, data type, description text, associated data element, search help etc... You could also view this information on your SAP system if you enter the table name VBFA or data type MATNR into the relevant SAP transactions such as SE11 or SE80 etc.
Also check out the Contributions section below to add and view useful hints, tips and screen shots specific to this SAP table field.
Example ABAP code to select data from table VBFA field MATNR
DATA: LD_MATNR TYPE VBFA-MATNR.SELECT single MATNR
FROM VBFA
INTO LD_MATNR
WHERE...
Key data for field VBFA-MATNR
Below is everything you need to know about the SAP matnr field in table VBFA, Including example ABAP code to show you how to select data, attributes/info such as that it is a none Key Field of table VBFA and that it stores Material Number
Attributes of MATNR field in SAP Table VBFA
Main Table: | VBFA |
Short Description:![]() |
Material Number. |
Position of field in table:![]() | 0016 |
Keyfield:![]() | No |
Application Class:![]() |
MG |
Mandatory:![]() | No |
Check table:![]() | MARA |
Used for foreign key relationship so that entries are restricted to those that appear within the primary key of the check table.
|
|
Memory ID:![]() | MAT |
Data type | CHAR |
Field Length | 000018 |
Number of Decimals | 000000 |
Internal type(i.e. C,I,N):![]() | C |
Internal Length(in Bytes):![]() | 000036 |
Reference table:![]() | |
Can field have NULL value?:![]() | No |
Data Element / Component Type:![]() | MATNR |
Domain name:![]() | MATNR |
Reference field for currency/qty fields:![]() | |
Origin of Search help:![]() | P - Input help implemented with check table |
The search help functionality for this field is implemented via the assignment of a foreign key relationship and the check table. Only entries that are contained within the linked fields of this check table are valid entries for this field. | |
Search help attached to field:![]() | |
Is field a table (i.e. nested table):![]() | No |
Depth for structured types:![]() | 00 |
Component Type:![]() | Data Element |
Is allocated Language Field?: | |
If a table/structure contains more than 1 language field (i.e. data type LANG) this flag denotes which one is used for the text language
| |
Object Referenced type:![]() | |
Position of field in database:![]() | 0016 |
Check table name of the foreign key:![]() | MARA |
Cardinality of a relationship:![]() | CN |
Short text:![]() | |
Message for unsuccessful foreign key check:![]() |
Other fields in SAP table VBFA
Below is the field in the previous position and the next position of table VBFA
SAP tables containing same field/data element
SAP tables containing data element MATNRSearch for further information about these or an SAP related objects