LUBU SAP (Posting Change Document) Table details

Dictionary Type: Table
Description: Posting Change Document




ABAP Code to SELECT data from LUBU
Related tables to LUBU
Access table LUBU




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
MANDTClient MANDTCLNT3Assigned to domainMANDT
LGNUMWarehouse Number / Warehouse Complex LGNUMCHAR3T300LGNUMLGN
UBNUMPosting Change Number UBNUMNUMC10UBNUMUBN
STATUStatus of Posting Change LUBU_STATUCHAR1LUBU_STATU
MJAHRMaterial Document Year MJAHRNUMC4GJAHRGJAHRMJA
MBLNRNumber of Material Document MBLNRCHAR10ALPHABELNRMBN
MBPOSItem in Material Document MBLPONUMC4MBLPOPOS
WENUMGoods Receipt Number LVS_WENUMCHAR10ALPHABELNR
BNAMEUser Name LVS_BNAMECHAR12USNAM
BDATUCreation Date of Posting Change Notice LUBU_BDATUDATS8DATUM
BWARTMovement Type (Inventory Management) BWARTCHAR3T156BWARTBWA
BWLVSMovement Type for Warehouse Management BWLVSNUMC3T333BWLVSBWL
TBPRITransfer Priority TBPRICHAR1TBPRI
MATN1Material Number MATNRCHAR18MARAMATN1MATNRMATS_MAT1
WERK1Plant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
BSTQ1Stock Category in the Warehouse Management System BESTQCHAR1BESTQ
CHRG1Batch Number CHARG_DCHAR10Assigned to domainCHARGCHA
SOKZ1Special Stock Indicator SOBKZCHAR1T148SOBKZ
SONR1Special Stock Number LVS_SONUMCHAR16ALPHALVS_SONUM
LGTYPStorage Type LGTYPCHAR3T301LGTYPLGTH_T301
LGPLAStorage Bin LGPLACHAR10LAGPLGPLALGPLAG1
MATN2Material Number MATNRCHAR18MARAMATN1MATNRMATS_MAT1
WERK2Plant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
BSTQ2Stock Category in the Warehouse Management System BESTQCHAR1BESTQ
CHRG2Batch Number CHARG_DCHAR10Assigned to domainCHARGCHA
SOKZ2Special Stock Indicator SOBKZCHAR1T148SOBKZ
SONR2Special Stock Number LVS_SONUMCHAR16ALPHALVS_SONUM
MENGEPost.change quantity LUBU_MENGEQUAN13(3) MENG13
MEINSBase Unit of Measure MEINSUNIT3T006CUNITMEINS
MNGA1Posting Change Quantity in Alternative Unit of Measure LUBU_MNGA1QUAN13(3) MENG13
UMRN1Denominator for conversion to base units of measure UMRENDEC5UMBSN
UMRZ1Numerator for Conversion to Base Units of Measure UMREZDEC5UMBSZ
ALTM1Alternative Unit of Measure for Stockkeeping Unit LRMEIUNIT3T006CUNITMEINS
MNGA2Posting change quantity in alternative unit of measure LUBU_MNGA2QUAN13(3) MENG13
UMRN2Denominator for conversion to base units of measure UMRENDEC5UMBSN
UMRZ2Numerator for Conversion to Base Units of Measure UMREZDEC5UMBSZ
ALTM2Alternative Unit of Measure for Stockkeeping Unit LRMEIUNIT3T006CUNITMEINS
TANUMTransfer Order Number Last Assigned LUBU_TANUMNUMC10TANUM
TAMENTransfer Order Quantity in Stockkeeping Unit LUBU_TAMENQUAN13(3) MENG13
AOFTANumber of Open Transfer Order Items LUBU_AOFTADEC5LVS_ANZPS
AGSTATotal Number of Transfer Order Items LUBU_AGSTADEC5LVS_ANZPS
TDATUDate of Last Transfer Order LUBU_TDATUDATS8DATUM
TZEITTime of last transfer order LUBU_TZEITTIMS6UZEIT
UBTXTPosting Change Text LUBU_UBTXTCHAR40TEXT40
QPLOSInspection Lot Number QPLOSNUMC12Assigned to domainQPLOSQLSQALS
QPLONNew Insp.Lot Created by Posting Change (Only in LUBU) QPLONNUMC12Assigned to domainQPLOSQLS
DIRTAAutomatic TO Creation Immediately After TR Generation LVS_DIRTACHAR1XFELD
AUTTAAutomatic Transfer Order Creation LVS_AUTTACHAR1T333NAUTTA
LGOR1Storage Location LGORT_DCHAR4T001LLGORTLAG
LGOR2Storage Location LGORT_DCHAR4T001LLGORTLAG
BZEITCreation time of posting change notice LUBU_BZEITTIMS6UZEIT

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 table
DATA: 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 as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!