LUBU SAP (Posting Change Document) Table details
Dictionary Type: Table
Description: Posting Change Document
Description: Posting Change Document
Table field list including key, data, relationships and ABAP select examples
LUBU is a standard SAP Table which is used to store Posting Change Document data and is available within R/3 SAP systems depending on the version and release level.
The LUBU table consists of various fields, each holding specific information or linking keys about Posting Change Document data available in SAP. These include LGNUM (Warehouse Number / Warehouse Complex), UBNUM (Posting Change Number), STATU (Status of Posting Change), MJAHR (Material Document Year).. 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 LUBU 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 | |||
LGNUM | Warehouse Number / Warehouse Complex | LGNUM | CHAR | 3 | T300 | LGNUM | LGN | ||
UBNUM | Posting Change Number | UBNUM | NUMC | 10 | UBNUM | UBN | |||
STATU | Status of Posting Change | LUBU_STATU | CHAR | 1 | LUBU_STATU | ||||
MJAHR | Material Document Year | MJAHR | NUMC | 4 | GJAHR | GJAHR | MJA | ||
MBLNR | Number of Material Document | MBLNR | CHAR | 10 | ALPHA | BELNR | MBN | ||
MBPOS | Item in Material Document | MBLPO | NUMC | 4 | MBLPO | POS | |||
WENUM | Goods Receipt Number | LVS_WENUM | CHAR | 10 | ALPHA | BELNR | |||
BNAME | User Name | LVS_BNAME | CHAR | 12 | USNAM | ||||
BDATU | Creation Date of Posting Change Notice | LUBU_BDATU | DATS | 8 | DATUM | ||||
BWART | Movement Type (Inventory Management) | BWART | CHAR | 3 | T156 | BWART | BWA | ||
BWLVS | Movement Type for Warehouse Management | BWLVS | NUMC | 3 | T333 | BWLVS | BWL | ||
TBPRI | Transfer Priority | TBPRI | CHAR | 1 | TBPRI | ||||
MATN1 | Material Number | MATNR | CHAR | 18 | MARA | MATN1 | MATNR | MAT | S_MAT1 |
WERK1 | Plant | WERKS_D | CHAR | 4 | T001W | WERKS | WRK | H_T001W_C | |
BSTQ1 | Stock Category in the Warehouse Management System | BESTQ | CHAR | 1 | BESTQ | ||||
CHRG1 | Batch Number | CHARG_D | CHAR | 10 | Assigned to domain | CHARG | CHA | ||
SOKZ1 | Special Stock Indicator | SOBKZ | CHAR | 1 | T148 | SOBKZ | |||
SONR1 | Special Stock Number | LVS_SONUM | CHAR | 16 | ALPHA | LVS_SONUM | |||
LGTYP | Storage Type | LGTYP | CHAR | 3 | T301 | LGTYP | LGT | H_T301 | |
LGPLA | Storage Bin | LGPLA | CHAR | 10 | LAGP | LGPLA | LGP | LAG1 | |
MATN2 | Material Number | MATNR | CHAR | 18 | MARA | MATN1 | MATNR | MAT | S_MAT1 |
WERK2 | Plant | WERKS_D | CHAR | 4 | T001W | WERKS | WRK | H_T001W_C | |
BSTQ2 | Stock Category in the Warehouse Management System | BESTQ | CHAR | 1 | BESTQ | ||||
CHRG2 | Batch Number | CHARG_D | CHAR | 10 | Assigned to domain | CHARG | CHA | ||
SOKZ2 | Special Stock Indicator | SOBKZ | CHAR | 1 | T148 | SOBKZ | |||
SONR2 | Special Stock Number | LVS_SONUM | CHAR | 16 | ALPHA | LVS_SONUM | |||
MENGE | Post.change quantity | LUBU_MENGE | QUAN | 13(3) | MENG13 | ||||
MEINS | Base Unit of Measure | MEINS | UNIT | 3 | T006 | CUNIT | MEINS | ||
MNGA1 | Posting Change Quantity in Alternative Unit of Measure | LUBU_MNGA1 | QUAN | 13(3) | MENG13 | ||||
UMRN1 | Denominator for conversion to base units of measure | UMREN | DEC | 5 | UMBSN | ||||
UMRZ1 | Numerator for Conversion to Base Units of Measure | UMREZ | DEC | 5 | UMBSZ | ||||
ALTM1 | Alternative Unit of Measure for Stockkeeping Unit | LRMEI | UNIT | 3 | T006 | CUNIT | MEINS | ||
MNGA2 | Posting change quantity in alternative unit of measure | LUBU_MNGA2 | QUAN | 13(3) | MENG13 | ||||
UMRN2 | Denominator for conversion to base units of measure | UMREN | DEC | 5 | UMBSN | ||||
UMRZ2 | Numerator for Conversion to Base Units of Measure | UMREZ | DEC | 5 | UMBSZ | ||||
ALTM2 | Alternative Unit of Measure for Stockkeeping Unit | LRMEI | UNIT | 3 | T006 | CUNIT | MEINS | ||
TANUM | Transfer Order Number Last Assigned | LUBU_TANUM | NUMC | 10 | TANUM | ||||
TAMEN | Transfer Order Quantity in Stockkeeping Unit | LUBU_TAMEN | QUAN | 13(3) | MENG13 | ||||
AOFTA | Number of Open Transfer Order Items | LUBU_AOFTA | DEC | 5 | LVS_ANZPS | ||||
AGSTA | Total Number of Transfer Order Items | LUBU_AGSTA | DEC | 5 | LVS_ANZPS | ||||
TDATU | Date of Last Transfer Order | LUBU_TDATU | DATS | 8 | DATUM | ||||
TZEIT | Time of last transfer order | LUBU_TZEIT | TIMS | 6 | UZEIT | ||||
UBTXT | Posting Change Text | LUBU_UBTXT | CHAR | 40 | TEXT40 | ||||
QPLOS | Inspection Lot Number | QPLOS | NUMC | 12 | Assigned to domain | QPLOS | QLS | QALS | |
QPLON | New Insp.Lot Created by Posting Change (Only in LUBU) | QPLON | NUMC | 12 | Assigned to domain | QPLOS | QLS | ||
DIRTA | Automatic TO Creation Immediately After TR Generation | LVS_DIRTA | CHAR | 1 | XFELD | ||||
AUTTA | Automatic Transfer Order Creation | LVS_AUTTA | CHAR | 1 | T333N | AUTTA | |||
LGOR1 | Storage Location | LGORT_D | CHAR | 4 | T001L | LGORT | LAG | ||
LGOR2 | Storage Location | LGORT_D | CHAR | 4 | T001L | LGORT | LAG | ||
BZEIT | Creation time of posting change notice | LUBU_BZEIT | TIMS | 6 | UZEIT |
Key field | Non-key field |
How do I retrieve data from SAP table LUBU using ABAP code
The following ABAP code Example will allow you to do a basic selection on LUBU to SELECT all data from the tableDATA: WA_LUBU TYPE LUBU.
SELECT SINGLE *
FROM LUBU
INTO CORRESPONDING FIELDS OF WA_LUBU
WHERE...
How to access SAP table LUBU
Within an ECC or HANA version of SAP you can also view further information about LUBU 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