SAP Table LUBU
Posting Change Document
LUBU (Posting Change Document) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link LUBU to other SAP tables.
LUBU table fields
Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
MANDT | Client | MANDT | CLNT | 3 | 0 | |||||||||||
LGNUM | Warehouse Number / Warehouse Complex | LGNUM | T300 | CHAR | 3 | 0 | ||||||||||
UBNUM | Posting Change Number | UBNUM | NUMC | 10 | 0 | |||||||||||
STATU | Status of Posting Change | LUBU_STATU | CHAR | 1 | 0 |
Possible values
|
||||||||||
MJAHR | Material Document Year | MJAHR | NUMC | 4 | 0 | |||||||||||
MBLNR | Number of Material Document | MBLNR | CHAR | 10 | 0 | |||||||||||
MBPOS | Item in Material Document | MBLPO | NUMC | 4 | 0 | |||||||||||
WENUM | Goods Receipt Number | LVS_WENUM | CHAR | 10 | 0 | |||||||||||
BNAME | User Name | LVS_BNAME | CHAR | 12 | 0 | |||||||||||
BDATU | Creation Date of Posting Change Notice | LUBU_BDATU | DATS | 8 | 0 | |||||||||||
BWART | Movement Type (Inventory Management) | BWART | T156 | CHAR | 3 | 0 | ||||||||||
BWLVS | Movement Type for Warehouse Management | BWLVS | T333 | NUMC | 3 | 0 | ||||||||||
TBPRI | Transfer Priority | TBPRI | CHAR | 1 | 0 | |||||||||||
MATN1 | Material Number | MATNR | MARA | CHAR | 18 | 0 | ||||||||||
WERK1 | Plant | WERKS_D | T001W | CHAR | 4 | 0 | ||||||||||
BSTQ1 | Stock Category in the Warehouse Management System | BESTQ | CHAR | 1 | 0 |
Possible values
|
||||||||||
CHRG1 | Batch Number | CHARG_D | CHAR | 10 | 0 | |||||||||||
SOKZ1 | Special Stock Indicator | SOBKZ | T148 | CHAR | 1 | 0 | ||||||||||
SONR1 | Special Stock Number | LVS_SONUM | CHAR | 16 | 0 | |||||||||||
LGTYP | Storage Type | LGTYP | T301 | CHAR | 3 | 0 | ||||||||||
LGPLA | Storage Bin | LGPLA | LAGP | CHAR | 10 | 0 | ||||||||||
MATN2 | Material Number | MATNR | MARA | CHAR | 18 | 0 | ||||||||||
WERK2 | Plant | WERKS_D | T001W | CHAR | 4 | 0 | ||||||||||
BSTQ2 | Stock Category in the Warehouse Management System | BESTQ | CHAR | 1 | 0 |
Possible values
|
||||||||||
CHRG2 | Batch Number | CHARG_D | CHAR | 10 | 0 | |||||||||||
SOKZ2 | Special Stock Indicator | SOBKZ | T148 | CHAR | 1 | 0 | ||||||||||
SONR2 | Special Stock Number | LVS_SONUM | CHAR | 16 | 0 | |||||||||||
MENGE | Post.change quantity | LUBU_MENGE | QUAN | 13 | 3 | |||||||||||
MEINS | Base Unit of Measure | MEINS | T006 | UNIT | 3 | 0 | ||||||||||
MNGA1 | Posting Change Quantity in Alternative Unit of Measure | LUBU_MNGA1 | QUAN | 13 | 3 | |||||||||||
UMRN1 | Denominator for conversion to base units of measure | UMREN | DEC | 5 | 0 | |||||||||||
UMRZ1 | Numerator for Conversion to Base Units of Measure | UMREZ | DEC | 5 | 0 | |||||||||||
ALTM1 | Alternative Unit of Measure for Stockkeeping Unit | LRMEI | T006 | UNIT | 3 | 0 | ||||||||||
MNGA2 | Posting change quantity in alternative unit of measure | LUBU_MNGA2 | QUAN | 13 | 3 | |||||||||||
UMRN2 | Denominator for conversion to base units of measure | UMREN | DEC | 5 | 0 | |||||||||||
UMRZ2 | Numerator for Conversion to Base Units of Measure | UMREZ | DEC | 5 | 0 | |||||||||||
ALTM2 | Alternative Unit of Measure for Stockkeeping Unit | LRMEI | T006 | UNIT | 3 | 0 | ||||||||||
TANUM | Transfer Order Number Last Assigned | LUBU_TANUM | NUMC | 10 | 0 | |||||||||||
TAMEN | Transfer Order Quantity in Stockkeeping Unit | LUBU_TAMEN | QUAN | 13 | 3 | |||||||||||
AOFTA | Number of Open Transfer Order Items | LUBU_AOFTA | DEC | 5 | 0 | |||||||||||
AGSTA | Total Number of Transfer Order Items | LUBU_AGSTA | DEC | 5 | 0 | |||||||||||
TDATU | Date of Last Transfer Order | LUBU_TDATU | DATS | 8 | 0 | |||||||||||
TZEIT | Time of last transfer order | LUBU_TZEIT | TIMS | 6 | 0 | |||||||||||
UBTXT | Posting Change Text | LUBU_UBTXT | CHAR | 40 | 0 | |||||||||||
QPLOS | Inspection Lot Number | QPLOS | NUMC | 12 | 0 | |||||||||||
QPLON | New Insp.Lot Created by Posting Change (Only in LUBU) | QPLON | NUMC | 12 | 0 | |||||||||||
DIRTA | Automatic TO Creation Immediately After TR Generation | LVS_DIRTA | CHAR | 1 | 0 |
Possible values
|
||||||||||
AUTTA | Automatic Transfer Order Creation | LVS_AUTTA | T333N | CHAR | 1 | 0 | ||||||||||
LGOR1 | Storage Location | LGORT_D | T001L | CHAR | 4 | 0 | ||||||||||
LGOR2 | Storage Location | LGORT_D | T001L | CHAR | 4 | 0 | ||||||||||
BZEIT | Creation time of posting change notice | LUBU_BZEIT | TIMS | 6 | 0 | |||||||||||
/CWM/XCWMAT | Material Is Activated for Catch Weight | /CWM/XCWMAT | CHAR | 1 | 0 |
Possible values
|
||||||||||
/CWM/TGT_QTY | Target Parallel Quantity of Transfer Order Item | /CWM/TGT_QTY | QUAN | 13 | 3 | |||||||||||
/CWM/TGT_UOM | Unit of Measure for Target PQ for Transfer Order Item | /CWM/TGT_UOM | UNIT | 3 | 0 | |||||||||||
/CWM/HU_OLD_QTY | Old Parallel Quantity of HU Item | /CWM/HU_OLD_QTY | QUAN | 13 | 3 | |||||||||||
/CWM/VEMEH | Parallel Unit of Measure | /CWM/VEMEH | UNIT | 3 | 0 |
LUBU foreign key relationships
Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
---|---|---|---|---|---|---|
LUBU | ALTM1 | LUBU | MANDT | T006 | Units of Measurement | MANDT |
LUBU | ALTM1 | LUBU | ALTM1 | T006 | Units of Measurement | MSEHI |
LUBU | ALTM2 | LUBU | MANDT | T006 | Units of Measurement | MANDT |
LUBU | ALTM2 | LUBU | ALTM2 | T006 | Units of Measurement | MSEHI |
LUBU | AUTTA | LUBU | MANDT | T333N | Control for automatic transfer order creation | MANDT |
LUBU | AUTTA | LUBU | LGNUM | T333N | Control for automatic transfer order creation | LGNUM |
LUBU | AUTTA | LUBU | AUTTA | T333N | Control for automatic transfer order creation | AUTTA |
LUBU | BWART | LUBU | MANDT | T156 | Movement Type | MANDT |
LUBU | BWART | LUBU | BWART | T156 | Movement Type | BWART |
LUBU | BWLVS | LUBU | LGNUM | T333 | WM Movement Types | LGNUM |
LUBU | BWLVS | LUBU | BWLVS | T333 | WM Movement Types | BWLVS |
LUBU | BWLVS | LUBU | MANDT | T333 | WM Movement Types | MANDT |
LUBU | LGNUM | LUBU | LGNUM | T300 | WM Warehouse Numbers | LGNUM |
LUBU | LGNUM | LUBU | MANDT | T300 | WM Warehouse Numbers | MANDT |
LUBU | LGOR1 | LUBU | LGOR1 | T001L | Storage Locations | LGORT |
LUBU | LGOR1 | LUBU | MANDT | T001L | Storage Locations | MANDT |
LUBU | LGOR1 | LUBU | WERK1 | T001L | Storage Locations | WERKS |
LUBU | LGOR2 | LUBU | MANDT | T001L | Storage Locations | MANDT |
LUBU | LGOR2 | LUBU | WERK2 | T001L | Storage Locations | WERKS |
LUBU | LGOR2 | LUBU | LGOR2 | T001L | Storage Locations | LGORT |
LUBU | LGPLA | LUBU | MANDT | LAGP | Storage bins | MANDT |
LUBU | LGPLA | LUBU | LGNUM | LAGP | Storage bins | LGNUM |
LUBU | LGPLA | LUBU | LGTYP | LAGP | Storage bins | LGTYP |
LUBU | LGPLA | LUBU | LGPLA | LAGP | Storage bins | LGPLA |
LUBU | LGTYP | LUBU | MANDT | T301 | WM Storage Types | MANDT |
LUBU | LGTYP | LUBU | LGNUM | T301 | WM Storage Types | LGNUM |
LUBU | LGTYP | LUBU | LGTYP | T301 | WM Storage Types | LGTYP |
LUBU | MATN1 | LUBU | MANDT | MARA | General Material Data | MANDT |
LUBU | MATN1 | LUBU | MATN1 | MARA | General Material Data | MATNR |
LUBU | MATN2 | LUBU | MANDT | MARA | General Material Data | MANDT |
LUBU | MATN2 | LUBU | MATN2 | MARA | General Material Data | MATNR |
LUBU | MEINS | LUBU | MANDT | T006 | Units of Measurement | MANDT |
LUBU | MEINS | LUBU | MEINS | T006 | Units of Measurement | MSEHI |
LUBU | SOKZ1 | LUBU | MANDT | T148 | Special Stock Indicator | MANDT |
LUBU | SOKZ1 | LUBU | SOKZ1 | T148 | Special Stock Indicator | SOBKZ |
LUBU | SOKZ2 | LUBU | MANDT | T148 | Special Stock Indicator | MANDT |
LUBU | SOKZ2 | LUBU | SOKZ2 | T148 | Special Stock Indicator | SOBKZ |
LUBU | WERK1 | LUBU | WERK1 | T001W | Plants/Branches | WERKS |
LUBU | WERK1 | LUBU | MANDT | T001W | Plants/Branches | MANDT |
LUBU | WERK2 | LUBU | MANDT | T001W | Plants/Branches | MANDT |
LUBU | WERK2 | LUBU | WERK2 | T001W | Plants/Branches | WERKS |