SAP table LUBU (Posting Change Document)

SAP table LUBU has 3 primary key fields being MANDT,LGNUM,UBNUM.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 MANDT
LGNUM Warehouse Number / Warehouse Complex CHAR 3 0 T300 LGNUM
UBNUM Posting Change Number NUMC 10 0 UBNUM
STATU Status of Posting Change CHAR 1 0 LUBU_STATU
Open
T Partially Processed
U Posting Change Processed
MJAHR Material Document Year NUMC 4 0 MJAHR
MBLNR Number of Material Document CHAR 10 0 MBLNR
MBPOS Item in Material Document NUMC 4 0 MBLPO
WENUM Goods Receipt Number CHAR 10 0 LVS_WENUM
BNAME User Name CHAR 12 0 LVS_BNAME
BDATU Creation Date of Posting Change Notice DATS 8 0 LUBU_BDATU
BWART Movement type (inventory management) CHAR 3 0 T156 BWART
BWLVS Movement Type for Warehouse Management NUMC 3 0 T333 BWLVS
TBPRI Transfer Priority CHAR 1 0 TBPRI
MATN1 Material Number CHAR 40 0 MARA MATNR
WERK1 Plant CHAR 4 0 T001W WERKS_D
BSTQ1 Stock Category in the Warehouse Management System CHAR 1 0 BESTQ
Available Stock
Q Stock in Quality Control
R Returns Stock
S Blocked Stock
CHRG1 Batch Number CHAR 10 0 CHARG_D
SOKZ1 Special Stock Indicator CHAR 1 0 T148 SOBKZ
SONR1 Special Stock Number CHAR 16 0 LVS_SONUM
LGTYP Storage Type CHAR 3 0 T301 LGTYP
LGPLA Storage Bin CHAR 10 0 LAGP LGPLA
MATN2 Material Number CHAR 40 0 MARA MATNR
WERK2 Plant CHAR 4 0 T001W WERKS_D
BSTQ2 Stock Category in the Warehouse Management System CHAR 1 0 BESTQ
Available Stock
Q Stock in Quality Control
R Returns Stock
S Blocked Stock
CHRG2 Batch Number CHAR 10 0 CHARG_D
SOKZ2 Special Stock Indicator CHAR 1 0 T148 SOBKZ
SONR2 Special Stock Number CHAR 16 0 LVS_SONUM
MENGE Post.change quantity QUAN 13 3 LUBU_MENGE
MEINS Base Unit of Measure UNIT 3 0 T006 MEINS
MNGA1 Posting Change Quantity in Alternative Unit of Measure QUAN 13 3 LUBU_MNGA1
UMRN1 Denominator for conversion to base units of measure DEC 5 0 UMREN
UMRZ1 Numerator for Conversion to Base Units of Measure DEC 5 0 UMREZ
ALTM1 Alternative Unit of Measure for Stockkeeping Unit UNIT 3 0 T006 LRMEI
MNGA2 Posting change quantity in alternative unit of measure QUAN 13 3 LUBU_MNGA2
UMRN2 Denominator for conversion to base units of measure DEC 5 0 UMREN
UMRZ2 Numerator for Conversion to Base Units of Measure DEC 5 0 UMREZ
ALTM2 Alternative Unit of Measure for Stockkeeping Unit UNIT 3 0 T006 LRMEI
TANUM Transfer Order Number Last Assigned NUMC 10 0 LUBU_TANUM
TAMEN Transfer Order Quantity in Stockkeeping Unit QUAN 13 3 LUBU_TAMEN
AOFTA Number of Open Transfer Order Items DEC 5 0 LUBU_AOFTA
AGSTA Total Number of Transfer Order Items DEC 5 0 LUBU_AGSTA
TDATU Date of Last Transfer Order DATS 8 0 LUBU_TDATU
TZEIT Time of last transfer order TIMS 6 0 LUBU_TZEIT
UBTXT Posting Change Text CHAR 40 0 LUBU_UBTXT
QPLOS Inspection Lot Number NUMC 12 0 QPLOS
QPLON New Insp.Lot Created by Posting Change (Only in LUBU) NUMC 12 0 QPLON
DIRTA Automatic TO Creation Immediately After TR Generation CHAR 1 0 LVS_DIRTA
AUTTA Automatic Transfer Order Creation CHAR 1 0 T333N LVS_AUTTA
LGOR1 Storage location CHAR 4 0 T001L LGORT_D
LGOR2 Storage location CHAR 4 0 T001L LGORT_D
BZEIT Creation time of posting change notice TIMS 6 0 LUBU_BZEIT
/CWM/XCWMAT Material Is Activated for CW CHAR 1 0 /CWM/XCWMAT
/CWM/TGT_QTY Target Parallel Quantity of Transfer Order Item QUAN 13 3 /CWM/TGT_QTY
/CWM/TGT_UOM Unit of Measure for Target PQ for Transfer Order Item UNIT 3 0 * /CWM/TGT_UOM
/CWM/HU_OLD_QTY Old Parallel Quantity of HU Item QUAN 13 3 /CWM/HU_OLD_QTY
/CWM/VEMEH Parallel Unit of Measure UNIT 3 0 * /CWM/VEMEH
SGT_SCAT Stock Segment CHAR 40 0 SGT_SCAT
SGT_UMSCAT Receiving/Issuing Stock Segment CHAR 40 0 SGT_UMSCAT

LUBU foreign key relationships

Table Field Check Table Check Field
0 LUBU ALTM1 T006 Units of Measurement MANDT
1 LUBU ALTM2 T006 Units of Measurement MANDT
0 LUBU AUTTA T333N Control for automatic transfer order creation MANDT
0 LUBU AUTTA T333N Control for automatic transfer order creation LGNUM
1 LUBU BWART T156 Movement Type MANDT
1 LUBU BWART T156 Movement Type BWART
0 LUBU BWLVS T333 WM Movement Types MANDT
0 LUBU BWLVS T333 WM Movement Types LGNUM
1 LUBU LGNUM T300 WM Warehouse Numbers MANDT
1 LUBU LGNUM T300 WM Warehouse Numbers LGNUM
0 LUBU LGOR1 T001L Storage Locations MANDT
0 LUBU LGOR1 T001L Storage Locations WERKS
1 LUBU LGOR2 T001L Storage Locations MANDT
1 LUBU LGOR2 T001L Storage Locations WERKS
0 LUBU LGPLA LAGP Storage bins MANDT
0 LUBU LGPLA LAGP Storage bins LGNUM
0 LUBU LGPLA LAGP Storage bins LGPLA
1 LUBU LGTYP T301 WM Storage Types MANDT
1 LUBU LGTYP T301 WM Storage Types LGNUM
1 LUBU LGTYP T301 WM Storage Types LGTYP
0 LUBU MATN1 MARA General Material Data MANDT
0 LUBU MATN1 MARA General Material Data MATNR
1 LUBU MATN2 MARA General Material Data MANDT
1 LUBU MATN2 MARA General Material Data MATNR
0 LUBU MEINS T006 Units of Measurement MANDT
0 LUBU MEINS T006 Units of Measurement MSEHI
1 LUBU SOKZ1 T148 Special Stock Indicator MANDT
1 LUBU SOKZ1 T148 Special Stock Indicator SOBKZ
0 LUBU SOKZ2 T148 Special Stock Indicator MANDT
0 LUBU SOKZ2 T148 Special Stock Indicator SOBKZ
1 LUBU WERK1 T001W Plants/Branches MANDT
1 LUBU WERK1 T001W Plants/Branches WERKS
0 LUBU WERK2 T001W Plants/Branches MANDT
0 LUBU WERK2 T001W Plants/Branches WERKS