RL030_UNIQUE SAP (Unique fields from tables lagp & lqua.) Structure details
Description: Unique fields from tables lagp & lqua.
Structure field list including key, data, relationships and ABAP select examples
RL030_UNIQUE is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Unique fields from tables lagp & lqua." Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_RL030_UNIQUE TYPE RL030_UNIQUE.
The RL030_UNIQUE table consists of various fields, each holding specific information or linking keys about Unique fields from tables lagp & lqua. data available in SAP. These include WERKS (Plant), MATNR (Material Number), BESTQ (Stock Category in the Warehouse Management System), CHARG (Batch Number).. 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:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP RL030_UNIQUE structure 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 |
LGNUM | Warehouse Number / Warehouse Complex | LGNUM | CHAR | 3 | Assigned to domain | LGNUM | LGN | ||
WERKS | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
MATNR | Material Number | MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | S_MAT1 |
BESTQ | Stock Category in the Warehouse Management System | BESTQ | CHAR | 1 | BESTQ | ||||
CHARG | Batch Number | CHARG_D | CHAR | 10 | Assigned to domain | CHARG | CHA | ||
SOBKZ | Special Stock Indicator | SOBKZ | CHAR | 1 | Assigned to domain | SOBKZ | |||
SONUM | Special Stock Number | LVS_SONUM | CHAR | 16 | ALPHA | LVS_SONUM | |||
LGTYP | Storage Type | LGTYP | CHAR | 3 | Assigned to domain | LGTYP | LGT | H_T301 | |
WDATU | Date of Goods Receipt | LVS_WDATU | DATS | 8 | DATUM | ||||
VFDAT | Shelf Life Expiration or Best-Before Date | VFDAT | DATS | 8 | DATUM | ||||
LGPLA | Storage Bin | LGPLA | CHAR | 10 | Assigned to domain | LGPLA | LGP | LAG1 | |
GESME | Total Quantity | LQUA_GESME | QUAN | 13(3) | MENSH | ||||
PLPOS | Position in storage bin | LVS_PLPOS | CHAR | 2 | LVS_PLPOS | ||||
VERME | Available stock | LQUA_VERME | QUAN | 13(3) | MENSH | ||||
MEINS | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
BTANR_Q | Document Number of Last Stock Change in Quant | LQUA_BTANR | NUMC | 10 | TANUM | ||||
BTANR_B | Transfer order number of last stock transfer | LAGP_BTANR | NUMC | 10 | TANUM | ||||
SKZUE | Blocking indicator: for putaways (user) | LQUA_SKZUE | CHAR | 1 | XFELD | ||||
SKZUA | Blocking Indicator: For Stock Removals (User) | LQUA_SKZUA | CHAR | 1 | XFELD | ||||
SKZSE | Blocking indicator: current placement into stock (system) | LQUA_SKZSE | CHAR | 1 | XFELD | ||||
SKZSA | Blocking Indicator: Current Stock Removal (System) | LQUA_SKZSA | CHAR | 1 | XFELD | ||||
SKZSI | Blocking Indicator: Current Inventory (System) | LQUA_SKZSI | CHAR | 1 | XFELD | ||||
SPGRU | Blocking reason | LVS_SPGRU | CHAR | 1 | Assigned to domain | LVS_SPGRU | |||
ZEUGN | Certificate Number | LVS_ZEUGN | CHAR | 10 | LVS_ZEUGN | ||||
BDATU | Date of last movement | LAGP_BDATU | DATS | 8 | DATUM | ||||
BZEIT | Time of last movement | LQUA_BZEIT | TIMS | 6 | UZEIT | ||||
BTAPS | Item in transfer order of last stock transfer | LQUA_BTAPS | NUMC | 4 | TAPOS | ||||
EDATU | Date of last placement into stock | LQUA_EDATU | DATS | 8 | DATUM | ||||
EZEIT | Time of last placement into stock | LQUA_EZEIT | TIMS | 6 | UZEIT | ||||
ADATU | Date of last stock removal | LQUA_ADATU | DATS | 8 | DATUM | ||||
AZEIT | Time of last stock removal | LQUA_AZEIT | TIMS | 6 | UZEIT | ||||
ZDATU | Date of last addition to existing stock | LQUA_ZDATU | DATS | 8 | DATUM | ||||
WENUM | Goods Receipt Number | LVS_WENUM | CHAR | 10 | ALPHA | BELNR | |||
WEPOS | Goods receipt item | LVS_WEPOS | NUMC | 4 | MBLPO | ||||
EINME | Stock for putaway | LQUA_EINME | QUAN | 13(3) | MENSH | ||||
LETYP | Storage Unit Type | LVS_LETYP | CHAR | 3 | Assigned to domain | LVS_LETYP | |||
AUSME | Quantity to remove | LQUA_AUSME | QUAN | 13(3) | MENSH | ||||
MGEWI | Weight of material | LQUA_MGEWI | DEC | 11(3) | DEC8_3 | ||||
TBNUM | Transfer Requirement Number | TBNUM | NUMC | 10 | Assigned to domain | TBNUM | TBN | ||
GEWEI | Weight Unit | GEWEI | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
IVNUM | Number of system inventory record | LVS_IVNUM | CHAR | 10 | ALPHA | BELNR | IVN | ||
IVPOS | Item number in inventory document | LVS_IVPOS | NUMC | 4 | LVS_IVPOS | ||||
BETYP | Requirement Type | LVS_BETYP | CHAR | 1 | Assigned to domain | LVS_BETYP | |||
BENUM | Requirement Number | LVS_BENUM | CHAR | 10 | ALPHA | LVS_BENUM | |||
LENUM | Storage Unit Number | LENUM | CHAR | 20 | Assigned to domain | LENUM | LENUM | LEN | |
QPLOS | Inspection Lot Number | QPLOS | NUMC | 12 | Assigned to domain | QPLOS | QLS | QALS | |
LGBER | Storage Section | LGBER | CHAR | 3 | Assigned to domain | LGBER | |||
LPTYP | Storage bin type | LVS_LPTYP | CHAR | 2 | Assigned to domain | LVS_LPTYP | LPT | ||
PLAUF | Section of a storage bin | LVS_PLAUF | CHAR | 1 | Assigned to domain | LVS_PLAUF | |||
ANZQU | Number of quants in storage bin | LAGP_ANZQU | DEC | 7 | LVS_ANZQU | ||||
MAXQU | Maximum number of quants in storage bin | LAGP_MAXQU | DEC | 7 | LVS_ANZQU | ||||
ANZLE | Number of storage units in storage bin | LAGP_ANZLE | DEC | 9(3) | LAGP_ANZLE | ||||
MAXLE | Maximum number of storage units in storage bin | LAGP_MAXLE | DEC | 5 | LAGP_MAXLE | ||||
KZDYN | Indicator: dynamic storage bin | LVS_KZDYN | CHAR | 1 | XFELD | ||||
LGEWI | Load Capacity of Storage Bin | LAGP_LGEWI | DEC | 11(3) | DEC8_3 | ||||
RDATU | Date of last bin clearing | LAGP_RDATU | DATS | 8 | DATUM | ||||
RZEIT | Time of last clearing | LAGP_RZEIT | TIMS | 6 | UZEIT | ||||
KZINV | Inventory method | LVS_KZINV | CHAR | 2 | LVS_KZINV | ||||
IDATU | Date of last inventory for this storage bin | LAGP_IDATU | DATS | 8 | DATUM | ||||
IVIVO | Inventory in preparation | LVS_IVIVO | CHAR | 1 | XFELD | ||||
KZLER | Indicator whether storage bin is empty | LAGP_KZLER | CHAR | 1 | XFELD | ||||
KZVOL | Indicator whether storage bin is full | LAGP_KZVOL | CHAR | 1 | XFELD | ||||
SORLP | Sort field for storage bin (cross-line storage) | LAGP_SORLP | CHAR | 6 | LAGP_SORLP | ||||
BRAND | Fire-containment section | LVS_BRAND | CHAR | 2 | Assigned to domain | LVS_BRAND | |||
UNAME | Last changed by | LAGP_UNAME | CHAR | 12 | USERNAME | ||||
LAEDT | Date of last change | LAGP_LAEDT | DATS | 8 | DATUM | ||||
LKAPV | Total capacity of storage bin | LAGP_LKAPV | DEC | 11(3) | DEC8_3 | ||||
RKAPV | Available capacity in storage bin | LAGP_RKAPV | DEC | 11(3) | LAGP_RKAPV | ||||
KOBER | Picking Area | KOBER | CHAR | 3 | Assigned to domain | KOBER | |||
REIHF | Sort field for storage bin (TO items, picking) | LAGP_REIHF | CHAR | 6 | LAGP_SORLP | ||||
VERIF | Verification Field for Mobile Data Entry | LAGP_VERIF | CHAR | 10 | Assigned to domain | LGPLA | |||
MAKTX | Material Description (Short Text) | MAKTX | CHAR | 40 | TEXT40 | ||||
LQNUM | Quant | LVS_LQNUM | NUMC | 10 | LVS_LQNUM | LQN | |||
LGORT | Storage Location | LGORT_D | CHAR | 4 | Assigned to domain | LGORT | LAG |
Key field | Non-key field |
How do I retrieve data from SAP structure RL030_UNIQUE using ABAP code?
As RL030_UNIQUE is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on RL030_UNIQUE as there is no data to select.How to access SAP table RL030_UNIQUE
Within an ECC or HANA version of SAP you can also view further information about RL030_UNIQUE 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