SAP Table V_064S_1
Generated Table for View
V_064S_1 (Generated Table for View) 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 V_064S_1 to other SAP tables.
V_064S_1 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||
| WERKS | Plant | WERKS_D | T001W | CHAR | 4 | 0 | ||||||
| LGORT | Storage Location | LGORT_D | T001L | CHAR | 4 | 0 | ||||||
| MTART | Material Type | MTART | T134 | CHAR | 4 | 0 | ||||||
| LGNUM | Warehouse Number / Warehouse Complex | LGNUM | T300 | CHAR | 3 | 0 | ||||||
| LGTYP | Storage Type | LGTYP | T301 | CHAR | 3 | 0 | ||||||
| BSTAR | Stock type | BSTAR | T064A | CHAR | 1 | 0 | ||||||
| STICH | Stock mgmt level allowed for inventory sampling | MBS_STICH | CHAR | 1 | 0 |
Possible values
|
||||||
| GRUPP | Group used to combine stock management levels | MBS_GRUPP | CHAR | 2 | 0 | |||||||
| NAME1 | Name | NAME1 | CHAR | 30 | 0 | |||||||
| LGOBE | Description of Storage Location | LGOBE | CHAR | 16 | 0 | |||||||
| MTBEZ | Description of material type | MTBEZ | CHAR | 25 | 0 | |||||||
| BTEXT | Text for stock type | BTEXT | CHAR | 20 | 0 | |||||||
V_064S_1 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| V_064S_1 | BSTAR | V_064S_1 | BSTAR | T064A | Physical Inventory Stock Types | BSTAR |
| V_064S_1 | LGNUM | V_064S_1 | LGNUM | T300 | WM Warehouse Numbers | LGNUM |
| V_064S_1 | LGNUM | V_064S_1 | MANDT | T300 | WM Warehouse Numbers | MANDT |
| V_064S_1 | LGORT | V_064S_1 | MANDT | T001L | Storage Locations | MANDT |
| V_064S_1 | LGORT | V_064S_1 | WERKS | T001L | Storage Locations | WERKS |
| V_064S_1 | LGORT | V_064S_1 | LGORT | T001L | Storage Locations | LGORT |
| V_064S_1 | LGTYP | V_064S_1 | MANDT | T301 | WM Storage Types | MANDT |
| V_064S_1 | LGTYP | V_064S_1 | LGNUM | T301 | WM Storage Types | LGNUM |
| V_064S_1 | LGTYP | V_064S_1 | LGTYP | T301 | WM Storage Types | LGTYP |
| V_064S_1 | MANDT | V_064S_1 | MANDT | T000 | Clients | MANDT |
| V_064S_1 | MTART | V_064S_1 | MANDT | T134 | Material Types | MANDT |
| V_064S_1 | MTART | V_064S_1 | MTART | T134 | Material Types | MTART |
| V_064S_1 | WERKS | V_064S_1 | MANDT | T001W | Plants/Branches | MANDT |
| V_064S_1 | WERKS | V_064S_1 | WERKS | T001W | Plants/Branches | WERKS |
