`
Jack Wu
  • 浏览: 887193 次
  • 来自: ...
社区版块
存档分类
最新评论

MM--移动类型的配置相关的系统表,举例说明SAP是如何根据配置抛帐的

阅读更多

一、移动类型相关的表

Customizable  

Table Name Descriptioin
T156 Movement Type - BWART
T156B Movement Types: Screen Selection (BWART+SOBKZ) Batch determination
T156SC Mvt Type: Qty/Value Posting: Customer Table; as of Rel. 4.6A ;QM.Inspection
T156Q Movement Type: Material-Independent Control
T156X Trans./Event Key Modification
T156T Movement Type Text
T158B Check Table: Movement Type for Transaction Code
T157H Help Texts for Movement Types
T157D Reason for Movement
T156N Next Movement Type
TMCA Evaluating movement types for LIS update
System   
Table Name Descriptioin
<p:colorscheme colors="#ffffff,#000000,#808080,#000000,#bbe0e3,#333399,#009999,#99cc00">T156SY</p:colorscheme> Mvt Type: Qty/Value Update: System Table; Rel. 4.6A;(<4.6,T156S)
T156W Posting string values(BUSTW)
T156M Posting String: Quantity(BUSTM)
T156F Fields in Quantity String
T156C Stock Types and Their Values

二、一些的作用说明

T163K
The 'Consumption posting' indicator and the account grouping code for the automatic account determination are read from table T163K for the account assignment category from the purchase order.
The consumption posting is empty for goods receipts that are not assigned.
The value from T163K is not always used for goods issues.
During goods issues with movement type 601, the 'Consumption posting' indicator originates from the delivery.
You can maintain the table with transaction OME9.

T156S
This table must contain an entry for the following key fields, because otherwise error message M7001 'Entry & & & not in table T156S (system error)' is displayed.
The movement type is entered in the goods receipt transactions.
The value update is stored in the detail screen for the material type, transaction OMS2.
The quantity update is stored in the detail screen for the material type, transaction OMS2.
The special stock indicator is entered in the goods receipt transaction.
The movement indicator is derived from the transaction.
Consumption posting indicator for stock transfer.
The consumption posting is selected from T163K.
For this key, important economical data such as value string and quantity string is read from T156S during a goods movement. If a value string is maintained for an entry for a material with value update, this must not be deleted because otherwise inconsistencies may occur.

T156X
If you add an entry in T156S, you must also maintain T156X. T156X has the same key fields as T156S plus value string plus numerator. The account grouping code for every entry is stored here. It is used in the automatic account determination.

T156W
The respective transaction/event keys (GBB, WRX) for the value string are maintained here. For these transaction/event keys, you must store a G/L account for the automatic account determination considering the valuation grouping code and the account grouping code (from T163K and T156X).

 关于T156S T156X T156K T156W参见:Note 34913 - The handling of tables T156S, T156X, T156W, T163K

三、举例说明SAP是如何根据配置抛帐的(以101移动类型为例)
In the test case that you propose, in the goods receipt for a purchase order with the movement type 101, normally:

.- We expect an invoice to arrive, so we post to the key WRX for the GR/IR clearing account.
.- We increase the value of our stock, so we post to the key BSX for the stock account.
第一步:
In the table T156 for the Movement Type you are posting (101 in this case) you have the Posting String Reference (T156-BUSTR, in this case it is also 101).
第二步:
With this posting string reference you can have a look at the table T156SY. Here, as mentioned before, depending on:
If you are posting into the special stock.
If value update and quantity update are made (see the material type for the material in the table MARA and then check OMS2 for the Plant).
If you post with reference to a document (purchase order, etc).
If you post with reference to a special procedure (stock transport order, for example).
If you update consumption.
第三步:
You locate the Value String T156SY-BUSTW. For example, WE01.
第四步:
With this value string, in T156W, you can see all the possible posting keys which can be used:

BUSTW CNT02 VORSL
WE01 01 BSX
WE01 02 WRX
WE01 03 PRD
WE01 04 KDM
WE01 05 EIN
WE01 06 EKG
WE01 07 BSV
WE01 08 FRL
WE01 09 FRN
WE01 10 BSX
WE01 11 UMB
第五步:
The program coding reads this table, and determine all these possible posting keys. Then it goes into the valuation program and tries to determine a value for all of them.
第六步:
Those keys which finally get a value of zero (for example, if BSX and WRX match, no price differences are generated, so PRD gets a value of zero) are not posted, and not included in the final accounting document.

四、相关的函数
 MR_ACCOUNT_ASSIGNMENT
account from the table T030 according to:

SELECT SINGLE * FROM T030 WHERE KTOPL = KONTENPLAN
AND KTOSL = VORGANGSSCHLUESSEL
AND BWMOD = BEWERTUNG_MODIF
AND KOMOK = KONTO_MODIF
AND BKLAS = BEWERTUNGSKLASSE.

the chart of accounts (KONTENPLAN), the posting key (VORGANGSSCHLUESSEL), the valuation grouping code (BEWERTUNG_MODIF), the account modifier (KONTO_MODIF) and the valuation class in the material master (BEWERTUNGSKLASSE).

This table T030 is customized in OBYC.
account from the table T030 according to:

五、配置路径说明
1) You are posting in a Plant. The Plant is assigned in OX18 to a Company Code. The Company Code is assigned in OB62 to a Chart of Accounts.
You take here the Chart of Accounts for your Company Code.

2) Under the IMG:
Materials Management -> Valuation and Account Assignment -> Account Determination -> Account Determination Without Wizard -> Define Valuation Control
You define whether you want your Plants to be grouped together or treated individually.
Then, in the next customizing step to "Group Together Valuation Areas", you can see to which group you have assigned the Plant.
This is the Valuation Grouping Code.

3) The Valuation class is defined in the Accounting 1 view of your Material Maser.

4) The account modifier is used in some posting keys like GBB, PRD or KON to subdivide the account determination.
You can see in the activity "Define Account Grouping for Movement Types" the different account modifiers to be used in these posting keys.
You need to know:
The movement type.
If you are posting into the special stock.
If value update and quantity update are made (see the material type for the material in the table MARA and then check OMS2 for the Plant).
If you post with reference to a document (purchase order, etc).
If you update consumption.

Once you have all this info, you can find the account in OBYC.
相关连接:
http://blog.csdn.net/CompassButton/archive/2008/02/01/2076149.aspx
http://blog.csdn.net/CompassButton/archive/2008/01/31/2075983.aspx

分享到:
评论

相关推荐

    SAP系统中移动类型107+109的配置与使用方法

    内容概要:本文详细介绍移动类型107与109在SAP系统下的应用配置和实施步骤。主要指导如何解决因使用移动类型101引发错误的情形,改用107移动类型完成原采购订单接收并进行原始地验收,之后通过109移动类型把商品由...

    图解SAP移动类型

    SAP系统管理员需要根据企业实际业务流程,预先配置好移动类型,包括关联的凭证类型、库存地点、物料组、批号管理和序列号管理等。合理的配置能有效支持企业的运营需求。 4. **移动类型与业务流程的关系** 每个...

    SAP的标准移动类型说明

    在SAP系统中,移动类型(Movement Types)是用来定义物料库存如何在不同的库存状态之间转换的。它们在库存管理、采购、生产和销售等业务流程中起着关键作用。以下是关于标题和描述中提及的一些标准移动类型的详细...

    SAP移动类型详细说明

    ### SAP移动类型详解 #### 一、概述 在SAP系统中,移动类型是指用于记录库存移动的不同类型的交易。这些移动可以是内部的(比如从一个仓库移到另一个仓库),也可以是外部的(例如从供应商接收货物)。每个移动...

    SAP MM自动记账科目配置

    通过合理配置评估等级、评估范围、评估类以及评估类别,并结合定义好的物料移动类型,SAP MM模块能够实现与FI模块的无缝集成,确保物料管理过程中的业务活动能够准确及时地反映在财务凭证中。这对于提高企业的运营...

    SAP-MM分割评估相关配置和操作

    ### SAP-MM 分割评估相关配置和操作 #### 一、背景与问题定义 在实际的企业运营过程中,常常会遇到一种特殊的情况:同一物料在同一个工厂内既可能存在自制入库的情况,也可能存在外购入库的情况。例如,某公司的...

    SAP_MM-SAP物料批次管理配置及操作手册.doc

    SAP_MM-SAP物料批次管理配置及操作手册 SAP 物料批次管理配置及操作手册是 SAP_MM 模块中的一个重要组件,主要用于管理物料的批次信息,跟踪物料的质量和batch信息。该手册旨在指导用户如何配置和操作 SAP 物料批次...

    sap移动类型详解

    sap移动类型应用1、101/102(凭证方向互为相反) 借:半成品/产成品/库存商品 贷:生产成本-转出 2、105/106(凭证方向互为相反) 直采收货: 借:材料/库存商品等(按标准成本计) 贷:GR/IR(材料采购)(按采购...

    SAP常用后台数据表大全(FI-CO-MM-SD-PP等).pdf

    - EKAB(移动类型数据):存储关于物料移动类型的详细信息。 - EKBE(评估类数据):存储物料评估相关的数据。 - EKBZ(库存管理数据):详细记录库存管理相关信息。 - EKES(库存/物料文档数据):记录库存和物料...

    SAP MM后台配置详解-(使用SAP S4HANA 1909版本系统) 共103页 2020年编著 PDF版.pdf

    SAP MM后台配置详解-(使用SAP S4HANA 1909版本系统) 共103页 2020年编著 PDF版

    SAP系统MM后台配置

    SAP系统MM模块后台配置介绍,一步一步很清晰的介绍,帮助你完成复杂的SAP系统MM的配置

    SAP-FI-FM基金管理-系统配置(1).doc

    SAP-FI-FM基金管理系统配置 SAP-FI-FM基金管理系统配置是SAP系统中的一种功能模块,主要用于基金管理和预算控制。该模块提供了一个综合的基金管理解决方案,涵盖了基金的创建、管理、预算控制等方面。 一、激活...

    SAP_MM-SAP委托加工(外协)业务配置及操作手册.doc

    SAP_MM-SAP 委托加工(外协)业务配置及操作手册 本手册详细介绍了 SAP 中的委托加工(外协)业务配置及操作手册,涵盖了业务配置、操作流程、会计科目设置、物料设置、采购订单设置、外协发料、外协入库、发票处理...

    PO SLD配置步骤sap官网-rxu笔记2020-3-3V0.docx

    - **参考官方文档**:对于不同类型的SAP系统,如Java或非SAP系统,参照官方文档进行详细配置。 5. **技术系统创建** - **技术系统定义**:技术系统代表安装在特定环境中的应用程序系统。 - **创建新技术系统**:...

    SAP-序列号-配置管理-PP

    在SAP系统中,序列号配置是生产管理(PP)模块的一个重要组成部分,它涉及到物料跟踪与追溯的关键功能。本文将详细阐述SAP序列号配置的相关知识点,以及如何在实际操作中有效地应用。 首先,我们要了解序列号配置的...

    SAP-MM-供应商配置.docx

    在SAP-MM模块中,供应商配置是企业供应链管理的关键部分,因为它涉及到与供应商的所有交互和交易数据的管理。以下是对标题和描述中涉及知识点的详细解释: 1. **供应商账户组**:供应商账户组是分类供应商信息的...

    SAP MM物料移动类型type

    ERP的基础是物流 那么 怎样在系统中控制物流? 最基础的需求是控制进/出/消耗 包括1/从哪里进来(采购订单/生产订单/其他...3/这种移动的数量和金额 对库房帐和财务帐带来的影响 以及这种影响能否自动实现(MM-FI的接口)

    SAP MM管理后台配置手册

    SAP MM管理后台配置手册是SAP系统中物料管理模块的配置指南,该手册提供了快速入门的指导,帮助用户快速掌握SAP MM管理后台的配置方法。 该手册包括了以下几个部分: 一、一般设置 在SAP MM管理后台配置中,需要...

Global site tag (gtag.js) - Google Analytics