Evaluated Receipt Settlement (ERS)

Main
Evaluated Receipt Settlement is the procedure for settling the Goods receipts automatically. Purchaser enters into the agreement with the vendor that the purchaser system posts the invoice document automatically on the basis of the purchase order and the goods receipts. Main advantage of this process is that this process eliminates the invoice variances and there is no requirement for the vendor invoices.

IMG Setting:
1.Define Message type
  SPRO> IMG>MM>LIV>Message determination > Maintain Message Types
2.Maintain Message Schemas
  SPRO> IMG>MM>LIV>Message determination > Maintain Message Schemas
3.Maintain Conditions
  SPRO> IMG>MM>LIV>Message determination > Maintain Conditions
4.Assign Forms and Programs
  SPRO> IMG>MM>LIV>Message determination > Assign Forms and programs

ERS Process:
1.Setting Vendor Master
   Control tab - AutoEvalGRSetmt check box active.
2.Setting Info Record
   Control tab - No ERS check box no active.
3.Check PO
   Invoice tab - ERS active.
4.Evaluated Receipt Settlement(ERS) with Logistics Invoice Verification
   Run T-code:MRRL. The Simulation is also possible by test run.

form
http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/20c57f75-d26f-2910-c3aa-dee124530121?QuickLink=index&overridelayout=true&10402410816402

MB1C - Message No. M7093

事由：當A Plant 將料送至B Plant作加工，這時B廠收901收料時，不能產生GL Account。
執行MB1C時發生以下Error Message
Fld selectn for mvmt type 901 / acct 7480000 differs for Customer goods movement(015)

1.T-code: SE38.
   Program Name: RM07CUFA

2.原因Mvt: 901在Account Grouping設定為1.管價不管量 2.管價也管量..
   而B Plant該Material Type:ROH 設定為管量又管價會產生GL Account...
   故修正B Plant作901時管量不管價，不會觸發Account.

PS 相關IMG
．Logistics -General/MM/Basic Settings/Material Types/Define Attriubtes of Material Types.
．MM/Inventory Management and Physical Inventory/Movement Types/Copy, Change Movement Types.
．MM/Valuation and Account Assignment/Account Determination/Account Determinatin Without Wizard/Configure Automatic Postings.

MIRO - Error RW011 ( No subsequent document found in Accounting )

在升級時碰到MIR7發現無法找到FI doc.
原因是Logical System在後來被修改過而造成的
檢查方法參照 Note 781498
請Basis修正該錯誤參照Note 446294

Note 781498
Symptom
You display a logistic invoice via transaction 'Display invoice document'
(MIR4). When you click on the button 'Follow-on documents' you receive the
message 'No subsequent document found in Accounting' (RW011).

Solution
Using transaction SE16, table RBKP, enter document number, Fiscal Year.
Check the value of logical system, field LOGSYS.
Using transaction SE16, table T000, check logical system maintained for the
client. If there is a change in logical system the link to follow-on
documents in financial accounting is lost. To correct this please refer to
the note 28958. Please also refer to the other related notes.

 Note 446294
Symptom
Following a client copy, entities still have the old logical system name of the source client.

The workflow cannot use or forward on objects that were created in the source client.

Consequently, you can no longer branch to the relevant accounting document when you display the material document in transaction MB03, for example. The M7082 message appears instead:
   Material document & does not include an accounting document

Solution
Define a logical system using transaction BD54 and assign it to the target client using the client administration (transaction SCC4).
If the client was already copied, you can still convert the logical system, if necessary, using transaction BDLS.
The logical system name is not converted automatically by the client copy until after Release 4.6C with SAPKB46C21 or 4.6D with SAPKB46D08. However, a prerequisite for this is that the target client already has a logical system name before the copy is started.
With client transports the attached correction 407854 or 407856 is also required (comes with SAPKB46C32, SAPKB46D21 or SAPKB61017).

New Company For Check Master Data

主檔資料準備與資料確認
 

Module / Master Data	Master Data Detail
PP
Material Master file	MRP
	Work Scheduling
	Sale
	Accounting
	Cost
BOM
Routing
SD
Customer Master file	General
	關係人
Customer Material Master file
Customer Price Master file
Customer Credit Master file
Sample Cost Center
MM
Vendor Master file
Info Recorder
Purchasing
FI
House Bank
Bank Account
Vendor(員工)
CO
Cost Center
Activity Type

New Company For MM STEP

STEP Description
1 Copy New Plent and Assign New Plant to Company
2 Maintain Storage Location and Assign MRP Location
3 Maintain Purchase Org and Assign to Plant
4 Create purchase group

Source Determination

使用Source Determination先決條件如下

1.       quota arrangement

2.       Source list

3.       Outline aggrement (contract or schedule line)

4.       Info record

Source List

可在IMG內Materials Managment/Purchasing/Source List/Define Source List Requirement at Plant Level

設立Source List在工廠級別生效或是選擇只對某個物料生效。

T-Code:ME01

在開立PR時可在上面打勾，將會自動帶入設定好的Vendor

Outline aggrement

T-Code:MEQ1

先確認該物料有info record 

接下來更改material master的purchase view為使用quota management

至item分配Quota自動會帶出百分比

BAPI_GOODSMVT_CREATE

庫存盤點在作SCAN BARCODE之後依盤虧盤盈的結果依相同的PLANT與Storage Location BY BATCH 去作311 Movement

使用BAPI_GOODSMVT_CREATE 來處理異動

基本結構為六項：Header、gm_code、gm_head_ret、mat_doc、gm_item、return

REPORT  ZBEN_AUTO_GT.

************************************************************************

* Data type definition segment

************************************************************************

*Header

DATA: GM_HEADER LIKE BAPI2017_GM_HEAD_01.

*GM_code

DATA: BEGIN OF GM_CODE.

    INCLUDE STRUCTURE BAPI2017_GM_CODE.

DATA: END OF GM_CODE.

*GM_head_ret

DATA: BEGIN OF GM_HEADRET.

    INCLUDE STRUCTURE BAPI2017_GM_HEAD_RET.

DATA: END OF GM_HEADRET.

*Mat_doc

DATA: MAT_DOC LIKE BAPI2017_GM_HEAD_RET-MAT_DOC.

*GM_item

DATA: BEGIN OF GM_ITEM OCCURS 100.

    INCLUDE STRUCTURE BAPI2017_GM_ITEM_CREATE.

DATA: END OF GM_ITEM.

*Return Msg

DATA: BEGIN OF ERRMSG OCCURS 10.

    INCLUDE STRUCTURE BAPIRET2.

DATA: END OF ERRMSG.

************************************************************************

* Selection screen definition segment

************************************************************************

PARAMETERS: P_MATNR LIKE MCHB-MATNR OBLIGATORY.

PARAMETERS: P_WERKS LIKE MCHB-WERKS OBLIGATORY.

PARAMETERS: P_LGORT LIKE MCHB-LGORT OBLIGATORY.

************************************************************************

* Main program entry

************************************************************************

**Header

GM_HEADER-PSTNG_DATE = '20091031'. "SY-DATUM.

GM_HEADER-DOC_DATE   = '20091031'. "SY-DATUM.

** IF PACK_NO NE SPACE.

*    GM_HEADER-REF_DOC_NO = POITEM-PACK_NO "DELIVER NOTE - GR

*    GM_HEADER-HEADER_TXT = POITEM-PACK_NO " FOR GT

** ENDIF.

**Code

GM_CODE-GM_CODE = '04'.

**Item

GM_ITEM-MATERIAL = ' 2C P 906011A F001'.

GM_ITEM-PLANT = 1000.

GM_ITEM-STGE_LOC = ' 14A 1'.

GM_ITEM-BATCH = ' 5M C1680002'.

GM_ITEM-MOVE_TYPE = '311'.

GM_ITEM-MVT_IND = ''.

GM_ITEM-ENTRY_QNT = 2.

GM_ITEM-ENTRY_UOM = 'EA'.

GM_ITEM-MOVE_STLOC = ' 1A 01'.

GM_ITEM-NO_TRANSFER_REQ = 'X'.

APPEND GM_ITEM.

CALL FUNCTION 'BAPI_GOODSMVT_CREATE'

EXPORTING

GOODSMVT_HEADER    = GM_HEADER

GOODSMVT_CODE = GM_CODE   "Transfer posting

*   IMPORTING

*    GOODSMVT_HEADRET = GM_HEADRET

*    MATERIALDOCUMENT = MAT_DOC

*    MATDOCUMENTYEAR   =

  TABLES

GOODSMVT_ITEM = GM_ITEM

RETURN     = ERRMSG

  EXCEPTIONS

OTHERS     = 1.

IF ERRMSG[] IS INITIAL.

  REFRESH: GM_ITEM, ERRMSG.

  CALL FUNCTION 'BAPI_TRANSACTION_COMMIT'

    EXPORTING

  WAIT = 'X'.

ELSE.

*  MESSAGE = ERRMSG-MESSAGE.

  EXIT.

ENDIF.

特性值

我用了二個方法都可以取得我想要的值

方法一：

尋找方法由AUSP-OBJEK = MCH1-CUOBJ_BM 取得AUSP-ATWRT (特性值)

Table：MCH1

方法二：

1. TABLE INOB中 INOB-OBTAB = MCH1(看TABLE而定)

2. INOB-CUOBJ = MCH1-CUOBJ_BM

3. 呼叫Function的key值取得INOB-OBJEK = MCH1-MATNR + MCH1-CHARG (MATNR要補空格)

4. Call Function 'CLAF_CLASSIFICATION_OF_OBJECTS'

貨齡與庫存計算

先前導入某家的案子作到「每日庫存計算與最久貨齡日期與數量的計算」
當初導入為每日自動申請物料請購單資料交換
當某些廠商料號數量不足時會與某個廠商有一個EDI文件交換
自動將資料傳輸給予對方廠商...

但SAP的系統庫存值存入Table是以異動後的月作儲存
要計算到本月當日 又不便把物料主檔內的資料全部取出
造成程式運算過久與系統資料太占內存

解決流程：
1.每日庫存計算
   可由MBEW取得最後一次異動月庫存量來得到本月異動前庫存
   再加減本年度月份的物料文件去計算出 每日庫存值

2.最久貨齡日期與數量
   要建立二個暫存區
   一個為存放物料文件稱作A 另一個為該物料的最久庫存量暫時稱為B
   要先由物料主檔取得該物料的最久庫存量存放至B
   然後去滾算例年來的物料文件的負向異動去減B數量
   當B - A < 0時 開始加 上 A的正向異動文件
   直到A所有的負向文件都加文時...就EXIT跳出LOOP
   這時取到得值就是該料號的最久庫存日期與數量

批次特性值 T-Code、Function

T-Code: MSC3N
Function:

查詢批號特性質

CLAF_CLASSIFICATION_OF_OBJECTS

BOM T-Code、Table、Function

T-Code: CS03
Table: MAST、STKO、STPO
Function:

展開與特性相關的特定款號的BOM	CS_BOM_EXPL_ KND_V1
只展開BOM的涵數	CS_BOM_EXPL_MAT_V2
反查BOM	CS_WHERE_USED_MAT

庫存By Batch轉換數量與價格


     CALL FUNCTION 'MURC_ALL_BATCH_FACTORS_NEW'
       EXPORTING
         if_matnr                  = mkopf-matnr
         IF_KZDCH                  = chargen_ebene
         IF_MEINS                  = mkopf-basme
         if_meinh                  = if_meinh1
       tables
         it_sel_charg              = ms_charg_bestand[]
         it_sel_werks              = ms_werks_bestand[]
         it_mcha_objek             = gt_mcha_objek
         it_mch1_objek             = gt_mch1_objek
         it_objek                  = gt_objek
         et_conv_tab               = lt_conv_tab
       EXCEPTIONS
         NOT_FOUND                 = 1
         NO_BATCH_CONVERSION       = 2
         OTHERS                    = 3.