SAP MM Stock Tables and Stock Types
SAP MM
轉自:
Stock Tables
Table |
Description |
SOBKZ |
MARC |
Plant Data for Material |
|
MARD |
Storage Location Data for Material |
|
MCHB |
Batch Stocks |
|
MSSL |
Total Special Stocks with Vendor |
O |
MSLB |
Special Stocks with Vendor |
O |
MSKU |
Special Stocks with Customer |
V,W |
MSSA |
Total Customer Orders on Hand |
E |
MSKA |
Sales Order Stock |
E |
MSSQ |
Project Stock Total |
Q |
MSPR |
Project Stock |
Q |
MKOL |
Special Stocks from Vendor |
K,M |
MSTB |
Stock in Transit (as of 605) |
|
MSTE |
Stock in Transit Sales Order (as of 605) |
E |
MSTQ |
Stock in Transit Project (as of 605) |
Q |
Valuation Tables
Table |
Description |
MBEW |
Material Valuation |
EBEW |
Sales Order Stock Valuation |
QBEW |
Project Stock Valuation |
OBEW |
Valuated Stock with Subcontractor (only for Japan) |
Document Tables
Table |
Meaning |
Key fields |
MKPF |
Header: Material Document |
Document number (MBLNR), year (MJAHR) |
MSEG |
Material Document - segments/ lines |
Document number (MBLNR), year (MJAHR), line number (ZEILE) |
BSIM |
Index for material to the FI-documents |
Material (MATNR), Valuation Area (BWKEY)... |
CKMI1 |
Material ledger index, used to document changes in MBEW for each movement |
KALNR, use mbew-kaln1 |
All Stocks
Table |
Field |
Meaning |
Valuated in |
Total in table |
History table |
Posted with |
MARC |
|
Plant Data for Material |
|
|
|
|
MARC |
UMLMC |
Stock in transfer (plant to plant) |
MBEW |
|
MARCH |
Transfer without PO, 303 / 305 |
MARC |
TRAME |
Stock in transit |
MBEW |
|
MARCH |
Transfer with PO, 351 / 101, 641 |
MARC |
GLGMG |
Tied empties stock |
MBEW |
|
MARCH |
|
MARC |
VKUMC |
Stock transfer sales value (plant to plant) for VO material |
MBEW |
|
MARCH |
|
MARC |
VKTRW |
Transit value at sales price for value-only material |
MBEW |
|
MARCH |
|
MARC |
BWESB |
Valuated Goods Receipt Blocked Stock |
MBEW |
|
MARCH |
|
MARD |
|
Storage Location Data for Material |
|
|
|
|
MARD |
LABST |
Valuated stock with unrestricted use |
MBEW |
|
MARDH |
|
MARD |
UMLME |
Stock in transfer (from one storage location to another) |
MBEW |
|
MARDH |
313 / 315 |
MARD |
INSME |
Stock in quality inspection |
MBEW |
|
MARDH |
|
MARD |
EINME |
Total Stock of All Restricted Batches |
MBEW |
|
MARDH |
|
MARD |
SPEME |
Blocked stock |
MBEW |
|
MARDH |
|
MARD |
RETME |
Blocked Stock Returns |
|
|
MARDH |
|
MARD |
KLABS |
Unrestricted-use consignment stock |
|
|
|
|
MARD |
KINSM |
Consignment stock in quality inspection |
|
|
|
|
MARD |
KEINM |
Restricted-use consignment stock |
|
|
|
|
MARD |
KSPEM |
Blocked consignment stock |
|
|
|
|
MCHB |
|
Batch Stocks |
|
|
|
|
MCHB |
CLABS |
Valuated stock with unrestricted use |
MBEW |
MARD-LABST |
MCHBH |
|
MCHB |
CUMLM |
Stock in transfer (from one storage location to another) |
MBEW |
MARD-UMLME |
MCHBH |
|
MCHB |
CINSM |
Stock in quality inspection |
MBEW |
MARD-INSME |
MCHBH |
|
MCHB |
CEINM |
Total Stock of All Restricted Batches |
MBEW |
MARD-EINME |
MCHBH |
|
MCHB |
CSPEM |
Blocked stock |
MBEW |
MARD-SPEME |
MCHBH |
|
MCHB |
CRETM |
Blocked Stock Returns |
|
MARD-RETME |
MCHBH |
|
MSSL |
|
Total Special Stocks with Vendor |
|
|
|
|
MSSL |
SLLB |
Valuated stock with unrestricted use |
MBEW** |
|
|
|
MSSL |
SLINS |
Stock in quality inspection |
MBEW** |
|
|
|
MSSL |
SLEIN |
Total Stock of All Restricted Batches |
MBEW** |
|
|
|
MSLB |
|
Special Stocks with Vendor |
|
|
|
|
MSLB |
LBLAB |
Valuated stock with unrestricted use |
MBEW |
MSSL-SLLAB |
MSLBH |
|
MSLB |
LBINS |
Stock in quality inspection |
MBEW |
MSSL-SLINS |
MSLBH |
|
MSLB |
LBEIN |
Total Stock of All Restricted Batches |
MBEW |
MSSL-SLEIN |
MSLBH |
|
MSKU |
|
Special Stocks with Customer |
|
|
|
|
MSKU |
KULAB |
Valuated stock with unrestricted use |
MBEW |
|
MSKUH |
|
MSKU |
KUINS |
Stock in quality inspection |
MBEW |
|
MSKUH |
|
MSKU |
KUEIN |
Total Stock of All Restricted Batches |
MBEW |
|
MSKUH |
|
MSSA |
|
Total Customer Orders on Hand |
|
|
|
|
MSSA |
SALAB |
Total Customer Orders on Hand |
EBEW* MBEW+ |
|
|
|
MSSA |
SAINS |
Stock in quality inspection |
EBEW* MBEW+ |
|
|
|
MSSA |
SASPE |
Blocked stock |
EBEW* MBEW+ |
|
|
|
MSSA |
SAEIN |
Total Stock of All Restricted Batches |
EBEW* MBEW+ |
|
|
|
MSSA |
SATRA |
Stock in transit |
EBEW* MBEW+ |
|
MSSAH |
|
MSKA |
|
Sales Order Stock |
|
|
|
|
MSKA |
KALAB |
Total Customer Orders on Hand |
EBEW* MBEW+ |
MSSA-SALAB |
MSKAH |
|
MSKA |
KAINS |
Stock in quality inspection |
EBEW* MBEW+ |
MSSA-SAINS |
MSKAH |
|
MSKA |
KASPE |
Blocked stock |
EBEW* MBEW+ |
MSSA-SASPE |
MSKAH |
|
MSKA |
KAEIN |
Total Stock of All Restricted Batches |
EBEW* MBEW+ |
MSSA-SAEIN |
MSKAH |
|
MSSQ |
|
Project Stock Total |
|
|
|
|
MSSQ |
SQLAB |
Total Customer Orders on Hand |
QBEW* MBEW+ |
|
|
|
MSSQ |
SQINS |
Stock in quality inspection |
QBEW* MBEW+ |
|
|
|
MSSQ |
SQSPE |
Blocked stock |
QBEW* MBEW+ |
|
|
|
MSSQ |
SQEIN |
Total Stock of All Restricted Batches |
QBEW* MBEW+ |
|
|
|
MSSQ |
SQTRA |
Stock in transit |
QBEW* MBEW+ |
|
MSSQH |
|
MSPR |
|
Project Stock |
|
|
|
|
MSPR |
PRLAB |
Total Customer Orders on Hand |
QBEW* MBEW+ |
MSSQ-SQLAB |
MSPRH |
|
MSPR |
PRINS |
Stock in quality inspection |
QBEW* MBEW+ |
MSSQ-SQINS |
MSPRH |
|
MSPR |
PRSPE |
Blocked stock |
QBEW* MBEW+ |
MSSQ-SQSPE |
MSPRH |
|
MSPR |
PREIN |
Total Stock of All Restricted Batches |
QBEW* MBEW+ |
MSSQ-SQEIN |
MSPRH |
|
MKOL |
|
Special Stocks from Vendor |
|
|
|
|
MKOL |
SLABS |
Unrestricted-use consignment stock |
|
MARD-KLABS |
MKOLH |
|
MKOL |
SINSM |
Consignment stock in quality inspection |
|
MARD-KINSM |
MKOLH |
|
MKOL |
SEINM |
Restricted-use consignment stock |
|
MARD-KEINM |
MKOLH |
|
MKOL |
SSPEM |
Blocked consignment stock |
|
MARD-KSPEM |
MKOLH |
|
* only if MSSA/MSSQ - KZBWS = 'M'
+ only if MSSA/MSSQ - KZBWS = 'A'
** if MSSL-XOBEW = 'X' valuated in table OBEW (only for Japan from 4.6 on)
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/29829936/viewspace-1873513/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- stock Types
- MM Stock基礎知識
- Forget stock
- 「SAP技術」 SAP MM 已啟用質檢物料建立PO時候'STOCK TYPE'沒有預設為X?
- Credit block & Stock resevedBloC
- Stock overview and cost assignment - 1View
- Stock overview and cost assignment - 2View
- Stock overview and cost assignment - 3View
- Stock overview and cost assignment - 4View
- Stock overview and cost assignment - 5View
- Stock overview and cost assignment - 6View
- Best Time to Buy and Sell Stock系列分析
- Cross-company stock transport orderROS
- Quantity and Value Flow in Make-to-Stock Production
- [leetcode]Best Time to Buy and Sell StockLeetCode
- Leetcode Best Time to Buy and Sell StockLeetCode
- Leetcode Best Time to Buy and Sell Stock IILeetCode
- Best Time to Buy and Sell Stock III -- LeetCodeLeetCode
- Best Time to Buy and Sell Stock leetcode javaLeetCodeJava
- SAP QM 啟用04檢驗型別的物料,工單上STOCK TYPE不是QI?型別
- leetcode_best-time-to-buy-and-sell-stock-iiLeetCode
- LeetCode-Best Time to Buy and Sell Stock with CooldownLeetCode
- LeetCode-Best Time to Buy and Sell Stock IVLeetCode
- Leetcode-Best Time to Buy and Sell Stock IIILeetCode
- WM Define Strategy for Addition to Existing Stock(十五。3)
- Best Time to Buy and Sell Stock II leetcode javaLeetCodeJava
- Best Time to Buy and Sell Stock III leetcode javaLeetCodeJava
- SAP WM中階之儲存型別上架策略I(Adding to existing stock)型別
- SAP WM中階之儲存型別設定介面裡的’Return Stock To Same Storage Bin’型別
- leetcode best-time-to-buy-and-sell-stock-iii(Java)LeetCodeJava
- 【Lintcode】393. Best Time to Buy and Sell Stock IV
- [LeetCode] 121. Best Time to Buy and Sell StockLeetCode
- Edit SAP tables
- Types of SAP Support PackagesPackage
- LeetCode 714 Best Time to Buy and Sell Stock with Transaction FeeLeetCode
- LeetCode(188) Best Time to Buy and Sell Stock IV (Java)LeetCodeJava
- LeetCode 309. Best Time to Buy and Sell Stock with CooldownLeetCode
- [LeetCode] 122. Best Time to Buy and Sell Stock IILeetCode