sap 库存解析
凡是看库存报表可能会用到如下几个T-code:
MMBE:MARD-LABST(Valuated stock with unrestricted u)
MB52:MARD-LABST
MB51:MSEG:ERFMG累加
MM03:MBEW-LBKUM (Total valuated stock)
MB5L:MBEW-SALK3 (Value of total valuated stock)
MC.9:S032-MBWBEST(Quantity of valuated stock)
S032-WBWBEST(Value of valuated stock)
你看到上方几个典范T-code实际上是从不合table读数据的.
应用Mard,MSEG,MBEW的T-code看库存数据一般会一致,然则 MC.9等应用了LIS table的就不必然了
熟悉LIS的伴侣必然熟悉此两表
TMC4:Global Control Elements: LIS Info Structure
TMCAE:Features of Application
并且知道凡是S031,S032的 rule是Synchronous Updating (V1 Update)
是的,它是由MB1*的include 法度RMCSV3VB完成的.就是说在物料移动时及时那么为什么
MC.9看到的库存还会和MB1*或MMBE看到的不合呢?原因有很多,比如你更该了material type, Material group等
呈现题目了,当然你必须更新信息机构的数据.
更新S012 PURCHASE DATA.
OLI3 - Statistical tup of info structures purchasing documents
重组Purcha Doc to LIS.
NPRT - Log for Setup of Statistical Data
NPRT to check REtup log.
MC26容许你看到LIS, QIS,SIS的更新景象,无论是LIS,QIS,,库存如不一致就应当一下了.
关于如何更新IS体系下面有一堆T-code
(OLI1-9),实际上后台你也可看到.
一.for WM相干(项目组):
LS09 Display Material Data for Stor.Type
LS24 Display Quants for Material
LS25 Display Quants per Storage Bin
LS26 Warehou stocks per material
LS27 Display quants for storage unit
LS28 Display storage units / bin
LT0G Return delivery to stock
LX02 Stock list
二.库存从头估价
J1A3 MM goods issue revaluation(从头估价)
J1A5 MM Warehou stock report
J1AI Ast Revaluation (Inflation)
三.关于物料价格(及其更改)
MR21 Price Change
MR22 Material Debit/Credit
CK24 Mark/change Standard Cost
CKMTOPSTOCKVAL Materials w/ Highest Inventory Value
MRN8 Lowest Value: Price Variances
四.关于库存解析.
MMBE(MB53): 显示单个库存(可将0库存的sto.过滤)
MB52: Warehou Stocks on Hand (不克不及By date)
MB54:Consignment Stocks
MB51/MB59:Material Doc. List (查看物料凭证,可by posting date)
MB5B: Stocks for Posting Date
** By Selection date可分时段查询库存MB5B
MB5K Stock Consistency Check
MB5L(MB5W) 显示 Stock Values Balances
** MB5L是从物料评估层看物料价值.比如某plant 1100的valuation clas是12110101
** 若是你应用MB52 by plant 1100和MB5L的12110101(物料总帐科目)价值不合就有题目了.
MB5T Stock in transit CC(转储)
**凡是跨公司转储应用MB1B 311同plant转,301跨plant(且可跨company)转.
**内部公司接洽关系贸易若是推敲MRP,一般不直接应用MB1B而开PO,如
许open PO就推敲了.
MBBS Display valuated special stock
MBGR Displ. Material Docs. by Mvt. Reason(有题目的库存)
MBLB Stocks at Subcontractor
MBST Cancel Material Document
**凡是MBST是整单的,比如PO 101收货错误,如整单可应用MBST,或一个个应用102.
**MBST能找到cancelling mat.doc的对应的反向mvtype .
MBSM Display Cancelled Material Docs.
物料发卖相干解析
MC+A Customer Returns, Selection
MC+E Customer, Sales - Selection
MC+I SIS: Customer Credit Memos - Selec.
MC+M Material Returns, Selection
MC+Q Material, Sales - Selection
MC+U Material Credit Memos, Selec.
MC+Y Sales Org. Returns, Selection
来料加工贸易
MC-0 Shipping Point Returns, Selec.
MC-A Sales Office Returns, Selection
MC-E SIS: Sales Office - Sales Selection
MC-I SIS: Sales Office Credit Memos Selec
MC-M Employee - Returns, Selection
MC-Q Employee - Sales, Selection
MC-U Employee - Credit Memos, Selec.
MC.H Business Area Anal.Sel. Stock
MC.I Bus. Area Anal. Sel. Rec/Iss
MC.J Bus. Area Anal. Sel. Turnover
MC.K Bus. Area Anal. Sel. Coverage
MC.L Mat.Group Analysis Sel. Stock
MC.M Mat.Group Anal. Sel. Rec/Iss
MC.N Mat.Group Anal. Sel. Turnover
MC.O Mat.Group Anal. Sel. Coverage
MC.P Division Analysis Sel. Stock
MC.Q Division Anal. Sel. Rec/Iss
MC.R Division Anal. Sel. Turnover
MC.S Division Anal. Sel. Coverage
物料工厂相干解析
contradiction
MC.1 Plant Anal. Selection: Stock
MC.2 Plant Anal.Selection, Rec/Iss
MC.3 Plant Anal.Selection,Turnover
MC.4 Plant Anal.Selection,Coverage
MC.5 SLoc Anal. Selection, Stock
MC.6 SLoc Anal. Selection: Rec/Iss
MC.7 SLoc Anal. Selection,Turnover
MC.8 SLoc Anal.Selection, Coverage
MC.9 Material Anal.Selection,Stock
MC.A Mat.Anal.Selection, Rec/Iss
MC.B Mat.Anal.Selection, Turnover
MC.C Mat.Anal.Selection, Coverage
MC.D MRP Cntrllr.Anal.Sel. Stock
MC.E MRP Cntrllr Anal.Sel. Rec/Iss
MC.F MRP Cntlr Anal.Sel. Turnover
MC.G MRP Cntlr.Anal.Sel. Coverage
MC.T Mat.Type Anal.Selection Stock
MC.U Mat.Type Anal.Sel. Rec/Issues
MC.V Mat.Type Anal.Sel. Turnover
MC.W Mat.Type Anal.Sel. Coverage
物料汗青.
MRN9 Balance Sheet Values by Account (各类价值)
MM60 Materials List
MM04 material Changed History(物料被更改的汗青记录)
MM06 mark Material d flat (将物料设置删除标记)
MMAM Change Material Type
**MMAM如何的material type才可change比如从SFG转到FG,前提是什么?我知道.
MCE9 Purchasing Function(转到MM_PUR功能菜单)
MCE3 Vendor Analysis Selection
MCE5 MatGrp Analysis Selection
MCE7 Material Analysis Selection
MCW2
ME2M Material by Purcha Order
以上是斗劲常用的关于stock analyst的一些t-code
---------------------------------------------------------------
库存相干表格:
MKOL :Special Stocks Ve
ndor
MKOLH:Special Stocks Vendor: History
MSCA :Sales Orders on Hand with Vendor
MSCAH:Sales Order Stock at Vendor: History美国女议员
MSKA :Sales Order Stock
pantihoMSKAH:Sales Order Stock: History
MSKU :Special Stocks at Customer
MSKUH:Special Stocks at Customer: History
MSLB :Special Stocks at Vendor
MSLBH:Special Stocks at Vendor: History
MARA :Plant Data for Material(物料plant相干master data)
MARCH:Material Master C Segment: History
MARD :Material Master Storage Location(常规库存在此表)
MARDH:Material Master Storage Location Segment: History
MBEW :对应material master data的account1-2,costing1-2 view.
MBEWH:Material Valuation: History
MCHB : Batch Stocks
MCHBH Batch Stocks: History
MCH1 Batches (if Batch Management Cross-Plant)
MCHA Batches
-----------------------------------------------------
MC00 Logistics Information System (LIS
mbew表中库存数据和mard(自由库存)+mslb(供应商库存)+mspr(项目库存)+mska(销售订单库存)
OLI1 INVCO Stat. Setup: Material Movemts
OLI2 INVCO Stat. Setup: Stocks
OLI3 PURCHIS Statistical Setup
OLI4 SFIS Statistical Setup
OLI5 PMIS Statistical Setup
OLI7 SIS Statistical Setup: Orders
OLI8 Set Up SIS for Deliveries
OLI9 SIS Statistical Setup: Billing Docs
OLIA C Maintenance Processing
OLIB PURCHIS: StatUpdate Header Doc Level
OLID SIS: Stat. Setup - Sales Activities
OLIE Statistical Setup - TIS: Shipments
OLIF SFIS: Setup-Repetitive Manufacturing
OLIH MRP Data Procurement for BW
OLIM Periodic stock qty - Plant
OLIP C Plant Maintenance Planning
OLIQ Reorganization of QM info system
OLIX Stat. Setup: Copy/Delete Versions
OLIZ INVCO Setup: Invoice Verification
BDMC Upload info structures
MC20 Display Field Catalog
MC21 Create Info Structure
MC22 Change Info Structure
MC23 Display Info Structure
MC24 Create Update
MC25 Change Update
MC26 Display Update
MC27 Create Evaluation Structure
cdna是什么MC28 Change Evaluation Structure
MC29 Display Evaluation Structure
MCC1 Inventory Controlling
MCC2 Inventory Information System
MCC3 Set Up INVCO Info Structs. from Docs
MCC4 Set Up INVCO Info Structs.from Stock
MCD7 PURCHIS: Create Eval. Structure
MCD8 PURCHIS: Change Eval. Structure
MCD9 PURCHIS: Display Eval. Structure
MCDA PURCHIS: Create Evaluation
MCDB PURCHIS: Change Evaluation
MCDC PURCHIS: Display Evaluation
MCDG PURCHIS: Execute Evaluation
SECR_EDIT Edit Audit Info Structures
VFS3 Adjusting info structure S060
VFSN Reorganization info structure S060
PTU Maint. PS Info System field ttings
OPTV Maint. PS Info System sort criteria
OPTW Maint.PS Info System group. criteria
OPTX Maint. PS Info System databa t.
PO0 Info. System Orders: Prettings
RPON Info. System Orders: Prettings
RPP0 Proj. Info System: Default Settings
RPPN Proj. Info System: Default Settin
gs
OPSW Info System Profile
OPUR Info System: Structure overview
ORIS Stat. Setup: Retail Info System
RISV Setup: Retail Info System - Versions
OLIQ Reorganization of QM info system
OCCB Info System: Further Reports
OLIZ INVCO Setup: Invoice Verification
OCC8 Info System: Report Selection
OCCB Info System: Further Reports
MS71 Copy info structure version to LTP
MCSS Display Log: Gen. Info Structure
MCST Display Log: Gen. Updating
MCSA SIS: Create Evaluation
MCSB SIS: Change Evaluation
MCSC SIS: Display Evaluation
MCSM1 TIS: Create evaluation
MCSM2 TIS: Change evaluation
MCSM3 TIS: Display evaluation
MCSM4 TIS: Execute evaluation
MCH+ RIS: Display Evaluation Structure
MCH0 Retail Information System
MCH1 RIS: Execute Evaluation
MCH2 RIS: Create Evaluation
MCH3 RIS: Change Evaluation
MCH4 RIS: Display Evaluation
MCH6 Update Maintenance: RIS
MC9E Info Structure: Add to General Char.
MC9F Info Structure: Delete All Charact.
MC8S Transfer Profiles
MC8T Activities
MC8U Calculate Proportional Factors
MC8V LIS Planning: Copy Versions
MC8W LIS Planning: Delete Versions
MC20 Display Field Catalog
MC21 Create Info Structure
MC22 Change Info Structure
MC23 Display Info Structure
MC24 Create Update
MC25 Change Update
MC26 Display Update
amg什么意思
MC27 Create Evaluation Structure
MC28 Change Evaluation Structure
MC29 Display Evaluation Structure
MC30 Update Log
MC31 Create Planning
MC35 Create Rough-Cut Planning Profile
MC36 Change Rough-Cut Planning Profile
MC37 Display Rough-Cut Planning Profile
MC38 Number range maintenance: MC_ERKO
MC3V U3 update
MC40 INVCO: ABC Analysis of Usage Values
MC41 INVCO: ABC Analysis of Reqmt Values
MC42 INVCO: Range of Coverage by Usg.Val.
MC43 INVCO: Range Of Coverage By Reqmts
MC44 INVCO:Analysis of Inventory Turnover
MC45 INVCO: Analysis of Usage Values
MC46 INVCO: Analysis of Slow-Moving Items
MC47 INVCO: Analysis of Reqmt Values
MC48 INVCO: Anal. of Current Stock Values
MC49 INVCO: Mean Stock Values
MC50 INVCO: Analysis of Dead Stock
MC59 Revi Planning Hierarchy
MC60 Maintain SOP Plant
MC61 Create Planning Hierarchy
MC62 Change Planning Hierarchy
MC63 Display Planning Hierarchy
MC64 Create Event
MC65 Change Event
MC66 Display Event
MC67 aphics screen: genl.plg.hier.
MC6A Sales and Operations Planning
MC6B Sales and Operations Planning
MC70 Maintain Capacity Planning (SOP)
MC71 Evaluation: Product Group Hierarchy
MC72 Evaluation: Product Group Usage
MC73 "Evaluation: Material Usage, Prod.Grp"
MC74 Transfer Mat. to Demand Management
MC75 Transfer PG to Demand Management
MC76 Disaggregation: Planning
MC77 Disaggregation: Display Planning
MC78 Copy SOP Version
MC79 Ur Settings for SOP
MC7A Plant Distribution
MC7B Information Structure: Units
MC7C Key Figure Parameters: Info Struct.
MC7D Planning Parameters: LIS
MC7E ALE Configuration fo
r Info Structure
MC7F Planning Parameters
MC7M Methods maintenance
MC7N Price Band Prices
MC7O Characteristic Fields for Info Str.
MC7P COPA Profile
MC7Q Characteristic Assignment
MC7R Key Figure(s) Assignment
MC80 Delete and activate versions
MC81 Sales and Operations Planning
MC82 Sales and Operations Planning
MC83 Sales and Operations Planning
anyMC84 Create Product Group
MC85 Display Product Group
MC86 Change Product Groups
MC87 Sales and Operations Planning
MC88 Sales and Operations Planning
MC89 Sales and Operations Planning
MC8A Create Planning Type
MC8B Change Planning Type
deadpoetssocietyMC8C Display Planning Type
MC8D Mass Processing: Create Planning
MC8E Mass Processing: Change Planning
MC8F Delete Entry in Planning File
gcMC8G Schedule Mass Processing
MC8H Maintain Ur Methods
MC8I Mass Processing: Check Planning
MC8J Reprocess Mass Processing
MC8K Copy/Delete Planning Versions
MC8L Calculate Proportions: SOP
MC8M Read Opening Stocks
MC8N Delete Forecast Versions
MC8O Ret Regeneration Time Stamp
MC8P Standard SOP: Generate Master Data
MC8Q Aggregate Copy
MC8R RESET: Status for Planning Objects
MC8S Transfer Profiles
MC8T Activities
MC8U Calculate Proportional Factors
MC8V LIS Planning: Copy Versions
MC8W LIS Planning: Delete Versions
MC8X SOP: Distribution Scenario - Select
MC8Y SOP: Distribution Scenario - Display
MC8Z SOP => Key Figure Assignments
MC90 Dm.Mgmt.: Mat.from any IS
MC91 Initial Graphic: Product Groups
MC92 "Initial: Product Groups, Hierarchies"
MC93 Create Flexible LIS Planning
MC94 Change Flexible LIS Planning
MC95 Display Flexible LIS Planning
MC96 Maintain Table 440P
MC97 Number Range Maintenance: MC_SAUF
MC98 Maintain Planning Objects
MC99 Display Planning Objects
MC9A Flexible Planning: Gen. Master Data
MC9B Calc. Proportions as in Pl.Hierarchy
MC9C Reports for Flexible Planning
MC9D Maintain Copy Profiles
MC9E Info Structure: Add to General Char.
MC9F Info Structure: Delete All Charact.
MC11 Create Evaluation
MC12 Change Evaluation
MC13 Display Evaluation
MC04 Create Info Set
MC05 Change Info Set
MC06 Display Info Set
MC07 Create Key Figure
MC08 Change Key Figure
MCS7 SIS: Create Evaluation Structure
MCS8 SIS: Change Evaluation Structure
MCS9 SIS: Display Evalaution Structure
MCS= Info Structure Data: Create Archive
MCSA SIS: Create Evaluation
MCSB SIS: Change Evaluation
MCSC SIS: Display Evaluation
MCSG SIS: Execute Evaluation
MCSM1 TIS: Create evaluation
MCSM2 TIS: Change evaluation
MCSM3 TIS: Display evaluation
MCSM4 TIS: Execute evaluation
MCSM5 TIS: Create evaluation structure
MCSM6 TIS: Change evaluation structure
MCSM7 TIS: Display evaluation structure
MCSS Display Log: Gen. Info Structure
MCST Display Log: Gen. Updating
MCW1 PURCHIS: Evaluate Payment Header
MCW2 PURCHIS: Evaluate Payment Item
MCW3 PURCHIS: Eval
uate VBD Header
MCW4 PURCHIS: Evaluate VBD Item
MCW6 LIS Setup for Agency Documents
MCX1 QMIS: Create Evaluation
MCX2 QMIS: Change Evaluation
MCX3 QMIS: Display Evaluation
MCX4 QMIS: Execute Evaluation
MCX7 QIS: Create Evaluation Structure
MCX8 QIS: Change Evaluation Structure
MCX9 QIS: display evaluation structure
NPRT LIS/tup/log(记录)
VFSN Reorganization info structure S060
VFS3 Adjusting info structure S060
VFSN Reorganization info structure S060
PVH0 Create/Change External Instructor
PV19 Activity Allocation for Instructors(外)
OV9Z Suitable Statistical Structures
OT75 Reconstruct CM from Vendor Bill.Docs
OT76 Reconstruct CM from Loans
OT77 Reconstruct CM from Securities
OT78 "Reconstruct FC, Money Mkt, Deriv."
OPUR Info System: Structure overview(forproject system)
MGV_CORRECT Checks + Corrects Quantity Structure
------------------------------------------------------------
If you wish to create an information structure that contains fields from
different applications, you first need to create a lf-defined application.
信息结构。我们可以列出
一些最具有代表性和最原始的报表,加以分析,客制信息结构,必要的话可以自己写更新规则、
更新过程或更新需求。这些信息结构因为直接接受交易数据,因此能得到实时的更新,而且由于
不需要从最原始的被打散的数据表中取数累算,速度是很快的。接着我们可以利用信息结构的复
制技术和ENHANCE技术对此信息结构进行一些复制(运算规则有区别不要紧,只要有规律就可以;
周期小的可以生成周期大的;有不同的列项不要紧,不是有ENHANCE吗;用户习惯不一致以及需求
有偏差不要紧,不是可以tting吗)
请教关于信息系统的更新机制中U1和U2的区别,它们都是系统根据负载的情况决定何时
悲惨世界经典语录英文版
做的吗?
一个信息结构表发现有误,清空完毕后,怎样重新开始做!
OLI0 C Plant Maintenance Master Data
OLI1 INVCO Stat. Setup: Material Movemts
OLI2 INVCO Stat. Setup: Stocks
OLI3 PURCHIS Statistical Setup
OLI4 SFIS Statistical Setup
OLI5 PMIS Statistical Setup
OLI7 SIS Statistical Setup: Orders
OLI8 Set Up SIS for Deliveries
OLI9 SIS Statistical Setup: Billing Docs
OLIA C Maintenance Processing
OLIB PURCHIS: StatUpdate Header Doc Level
OLID SIS: Stat. Setup - Sales Activities
OLIE Statistical Setup - TIS: Shipments
OLIF SFIS: Setup-Repetitive Manufacturing
OLIH MRP Data Procurement for BW
OLIM Periodic stock qty - Plant
OLIP C Plant Maintenance Planning
OLIQ Reorganization of QM info system
OLIX Stat. Setup: Copy/Delete Versions
OLIZ INVCO Setup: Invoice Verification
NPRT - Log for Setup of Statistical Data
OLIX - Copy/delete versions of an info structure
--------------------------------------
LIS最常用的几个table
S031 Statistics: Moveme