ITPub博客

首页 > Linux操作系统 > Linux操作系统 > stock tables and stock type

stock tables and stock type

原创 Linux操作系统 作者:canc3r 时间:2012-03-13 09:22:06 0 删除 编辑

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

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/11782589/viewspace-718394/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2010-12-06

  • 博文量
    120
  • 访问量
    233389