VBSP SAP (SD Document Item for Models of Material Structures) Table details
Dictionary Type: Table
Description: SD Document Item for Models of Material Structures
Description: SD Document Item for Models of Material Structures
Table field list including key, data, relationships and ABAP select examples
VBSP is a standard SAP Table which is used to store SD Document Item for Models of Material Structures data and is available within R/3 SAP systems depending on the version and release level.
The VBSP table consists of various fields, each holding specific information or linking keys about SD Document Item for Models of Material Structures data available in SAP. These include VBELN (Sales and Distribution Document Number), POSNR (Item number of the SD document), GRSTR (Group definition of structure data), STRUA (Structure type (feature, option)).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP VBSP table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
VBELN | Sales and Distribution Document Number | VBELN | CHAR | 10 | Assigned to domain | ALPHA | VBELN | AUN | |
POSNR | Item number of the SD document | POSNR | NUMC | 6 | Assigned to domain | POSNR | |||
GRSTR | Group definition of structure data | GRSTR | NUMC | 3 | GRSTR | ||||
STRUA | Structure type (feature, option) | STRUA | CHAR | 2 | STRUA | ||||
VKGRU | Repair Processing: Classification of Items | VKGRU | CHAR | 3 | Assigned to domain | RMA_VORGA | RMA_VORGA | ||
VKAUS | Unused - Reserve Length 3 | VKAUS | CHAR | 3 | VKAUS | ||||
VKTXT | Short text of the model | VKTXT | CHAR | 40 | TEXT40 | ||||
VRPRS | Cost in local currency of the sales organization | VRPRS | DEC | 11(2) | VRPRS | ||||
PRODH | Product hierarchy | PRODH_D | CHAR | 18 | Assigned to domain | PRODH | VPR | ||
SELKZ | Selection flag | SELKZ | CHAR | 1 | SELKZ | ||||
GRAUS | Basic model for alternative model | GRAUS | CHAR | 3 | VKAUS | ||||
ASMNG | Model quantity | ASMNG | QUAN | 13(3) | MENG13 | ||||
AUMGE | Unit of measure for the model quantity | AUMGE | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
ROMS1 | Size 1 | ROMS1 | QUAN | 13(3) | MENG13 | ||||
ROMS2 | Size 2 | ROMS2 | QUAN | 13(3) | MENG13 | ||||
ROMS3 | Size 3 | ROMS3 | QUAN | 13(3) | MENG13 | ||||
ROMEI | Unit of measure for sizes 1 to 3 | ROMEI | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
RMENG | Resulting qty (size qty) in units for variable-sized items | RMENG | QUAN | 13(3) | MENG13 | ||||
RMEIN | Unit of measure for qty of variable-sized item (result.qty) | RMEIN | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
UMPRZ | Numerator (factor) for conversion of sales qty to price qty | UMPRZ | DEC | 5 | UMBSZ | ||||
UMPRN | Denominator (divisor) f.conversion of sales qty to price qty | UMPRN | DEC | 5 | UMBSN | ||||
PMENG | Price quantity for pricing in price unit of measure | PMENG | QUAN | 13(3) | MENG13 | ||||
PMEIN | Price unit of measure | PMEIN | UNIT | 3 | Assigned to domain | CUNIT | MEINS |
Key field | Non-key field |
How do I retrieve data from SAP table VBSP using ABAP code
The following ABAP code Example will allow you to do a basic selection on VBSP to SELECT all data from the tableDATA: WA_VBSP TYPE VBSP.
SELECT SINGLE *
FROM VBSP
INTO CORRESPONDING FIELDS OF WA_VBSP
WHERE...
How to access SAP table VBSP
Within an ECC or HANA version of SAP you can also view further information about VBSP and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects