movement_movement查看 row - CSDN
精华内容
参与话题
  • SAP MM MoveMent Type

    千次阅读 2012-12-17 11:49:43
    1.101 收货到非限制性使用仓。...MM MoveMent Type" title="SAP MM MoveMent Type"> 3.105 将103收回来的冻结在工厂一级的物料,解冻到非限制性使用仓。收货时要写库存地了。 MM MoveMent Type" titl

    1.101 收货到非限制性使用仓。

    2.103 收货到冻结仓(GR Blocked Stock)。收货时无需填写库存地点,它直接收货到工厂一级的冻结仓。

    SAP <wbr>MM <wbr>MoveMent <wbr>Type

    3.105 将103收回来的冻结在工厂一级的物料,解冻到非限制性使用仓。收货时要写库存地了。

    SAP <wbr>MM <wbr>MoveMent <wbr>Type

    4.102主要用于处理当月因供应商送来货物的质量问题等原因,需要进行退货,详见MIGO反向交货(参考物料凭证或交货单号)。migo进入,然后returndelivery,输入物料凭证号或者交货单号就可以对之前收货的的单子进行退货,退货的价格只能根据物料凭证上的价格,但可以输入数量。
    SAP <wbr>MM <wbr>MoveMent <wbr>Type

    5.102    主要用于处理因操作人员人为原因产生的错误(如,录入数量等等),详见migo中取消(参考物料凭证或交货单号)。migo进入后,选cancellation,输入物料凭证或者交货单对之前的单子进行取消,不可以改变数量,价格也根据单子上的价格进行取消。
    SAP <wbr>MM <wbr>MoveMent <wbr>Type

    6.161   主要用于跨月向供应商退货的业务。例如:3月份供应商给公司送过来一批货物,当时没有仔细检查,在4月份使用时,才发现货物质量不合格。这时发票可能已经做,这样的话,想要处理跨月发票的话,只能先创建一张退货采购订单来实现。

    使用161时先me21n建一个退货单(退货单上的价格和数量都可以改变的),然后用migo收货的方式进行退货。

    SAP <wbr>MM <wbr>MoveMent <wbr>Type

     

    7. 124 用103进行的收货处理(也就是收货到冻结仓)进行退货处理,migo进去,输入return delivery,输入103收货产生的物料凭证,就可以进行退货处理。

    SAP <wbr>MM <wbr>MoveMent <wbr>Type

    8. 301 工厂到工厂的一步转仓。进入migo,输入 transferposting,就可以将物料从这个工厂的非限制性使用仓转到另一个工厂的非限制性使用仓,但必须输入库存地点。

    SAP <wbr>MM <wbr>MoveMent <wbr>Type

    9. 303+305作用是跟301一样的,只是301用一步就可以从一个工厂转换到另一个工厂,而303+305要先用303将工厂1的转到在途,在用305通过在途转到工厂2的库存中去。

    1.303,从工厂1转到在途状态

    SAP <wbr>MM <wbr>MoveMent <wbr>Type

    SAP <wbr>MM <wbr>MoveMent <wbr>Type

    2.305将在途的物料转化为工厂2的非限制性使用仓中物料。

    SAP <wbr>MM <wbr>MoveMent <wbr>Type

    SAP <wbr>MM <wbr>MoveMent <wbr>Type
    10.311 同一工厂下不同仓库之间的转移(一步完成)。

    11.313+315作用是跟311一样的,只是分两步走,首先313将工厂1000下的库存1030里的物料转到库存1050的在途,再用315将在途转为非限制性使用库存。

    12. 321 从质检仓转移到非限制性使用仓库(可以是不同仓库之间的转移也可以是同一个仓库之间的转移)

    13. 323 从一个仓库的质检仓转到另一个仓库的质检仓。

    14. 325 从一个仓库的冻结仓转到另一个仓库的冻结仓。

    15. 331 从质检仓移除。migo进去,输入goods issue,然后331进行操作。

    16. 333 从非限制性使用仓移除。

    17. 335 从冻结仓移除。

    18. 343 从冻结仓转移到非限制性使用仓,即解冻到非限制性使用仓。

    19. 349 从冻结仓转移到质检仓,即解冻到质检仓。

    20. 351 根据转储单发货。先建一个UB类型的转出单,然后用351根据转储单发货。

    21. 411 将放在特殊库存的属于客户的物料转到公司自己库存,并所有权属于自己。

    22. 413 将非限制性使用库存转到销售订单库存。也可以将销售订单库存,寄售库存转到销售订单库存。

    23. 451 从客户处退货,退到退货仓。

    24. 453 从退货仓转到非限制性使用仓。

    25. 455 退货仓之间的转仓。从1050的退货仓转到1030的退货仓。

    26. 457 从退货仓转到质检仓。

    27. 459 从退货仓转到冻结仓。

    28. 501 没有采购订单的收货到非限制性使用仓。

    29. 503 没有采购订单的收货到质检仓。

    30. 505 没有采购订单的收货到冻结仓。

    31. 541 外包发货,外包业务发原材料时,用移动类型541,发到属于客户的仓库。Transfer postingunrestricted-use stock - stock of material provided to vendor

    32. 543 外包扣料,将放在属于客户的仓库中的原材料做消耗。 Consumption from stock ofmaterial provided to vendor
    33. 551 从自由库存报废。

    34. 553 从质检仓报废。

    35. 555 从冻结仓报废。

    36. 561 给非限制性库存初始化。

    37. 563 给质检仓库存初始化。

    38. 565 给冻结仓库存初始化。

    39. 601 根据外向交货单发货。

        SAP <wbr>MM <wbr>MoveMent <wbr>Type

    40. 641 有库存调拨单的工厂之间的发货。从一个工厂发往另一个工厂时所用的移动类型。

        SAP <wbr>MM <wbr>MoveMent <wbr>Type
    41. 643 不同公司的不同工厂之间的用库存调拨单的库存调拨,发货时用移动类型643。

    展开全文
  • 关于row movement的一点应用

    千次阅读 2014-08-12 01:07:25
    今天对一张创建了分区表的表进行updateca

    今天对一张创建了分区表的表进行update操作,正好需要修改的是创建分区的那一列,由于是要修改在分区表范围内的数据,所以无法修改。

    然后搜了一下,需要修改row movement这个属性:alter table eq_excpdetail enable row movement;将该属性打开,然后就可以对分区列进行修改。关闭是alter table eq_excpdetail disable row movement; 


    将row movement设置为enable,有可能发生行的物理移动,行的rowid会变化,某一行更新时,如果更新的是分区列,并且更新后的列值不属于原来的这个分区,如果开启了这个选项,就会把这行从这个分区中delete掉,并加到更新后所属的分区。相当于一个隐式的delete+insert,但是不会触发insert/delete触发器。如果没有开启这个选项,就会在更新时报错。


    当然row movement不只用于分区还用于闪回。



    另外转两篇对 row movement的讲解:点击打开链接

    展开全文
  • 什么是Movement type ?

    千次阅读 2009-02-28 13:29:00
    ▲什么是Movement type ?1.物料的移动在SAP中的反映,也可以理解为物流业务在SAP中的反映2.移动类型可以根据物料类型的Quantity/Value属性,更新(数量(Stock)或价值(FI凭证/科目的确定)3.移动类型的字段显示(Screen)...

    ▲什么是Movement type ?
    1.物料的移动在SAP中的反映,也可以理解为物流业务在SAP中的反映
    2.移动类型可以根据物料类型的Quantity/Value属性,更新(数量(Stock)或价值(FI凭证/科目的确定)
    3.移动类型的字段显示(Screen)可以在IMG中设置
    4.MRP,ATP check 等计算的基础
    5.链接SAP各模块

    ▲Movement type
    Mvt   type Description
    1xx   GR from Pur/Prd and return
    2xx   GI for Consumption
    3xx,4xx  Transfer
    5xx   GR W/O ref to Pur/Prd Order
    6xx   LE-SHP movement types
    7xx   Physical inventory(IM:70x/WM:71x)
    8xx   Brazil
    Customer  9xx,Xxx,Yxx,Zxx

    ▲T-Code: OMJJ
    Menu path: IMG - Materials Management - Inventory Management and Physical Inventory – Movement type - Copy, Change Movement Types

    GI: goods issue (consumption/usage, withdrawal) or goods receipt without reference;发料
    GR: goods receipt with reference to a purchase order or production order
    GD: goods movement with reference to a delivery (from the Shipping component)
    RE: return delivery, return, reversal
    RE: returns reversal
    TP: transfer to company's own stock
    TF: transfer posting
    TR: reversal of transfer posting
    SLS: sales value receipt
     
    ▲Movement type tables
    Customized table
    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
    T156SY   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
     

    ▲Special stock
    K  Consignment (vendor)
    O  Parts prov.vendor
    W  Consignment (cust)
    E  Order on hand
    Q  Project stock
    V  Ret.pkg w.customer
    M  Ret.trans.pkg vendor
    P  Pipeline material

    ▲Movement indicator (KZBEW)
    Space  Goods movement w/o reference
    B  Goods movement for purchase order
    F  Goods movement for production order
    L  Goods movement for delivery note
    K  Goods movement for kanban requirement (WM - internal only)
    O  Subsequent adjustment of "material-provided" consumption
    W  Subsequent adjustment of proportion/product unit material

    Below you will find a short description of the standard movement types. The cancellation movement type is the movement type + 1 (cancellation for 101 = 102).

    ▲101 Goods receipt for purchase order or order
    If the purchase order or order has not been assigned to an account, a stock type (unrestricted-use stock, stock in quality inspection, blocked stock) can be entered during goods receipt.
    If the purchase order or order has been assigned to an account, the goods receipt is not posted to the warehouse, but to consumption.
    In the case of non-valuated materials, the goods receipt is posted to the warehouse, although the purchase order has not been assigned to an account.
    Possible special stock indicators:
    K, Goods receipt for purchase order to consignment stock
    O, Goods receipt for purchase order to stock of material provided to vendor
    E, GR for purchase order or order to sales order stock
    Q, GR for purchase order or order to project stock

    ▲103 Goods receipt for purchase order into GR blocked stock
    You cannot receive goods into goods receipt blocked stock for stock transport orders.
    Possible special stock indicators:
    K, O, E, Q

    ▲105 Release from GR blocked stock for purchase order
    Movement type 105 has the same effects as 101.
    Possible special stock indicators:
    K, O, E, Q

    ▲121 Subsequent adjustment for subcontracting
    This movement type cannot be entered manually.
    With a subsequent adjustment for a subcontract order it is possible to correct the consumption of components. In this case, the material produced by the supplier is credited with the excess consumption / under-consumption. For this reason, if there is a subsequent adjustment, an item is generated for the produced material using movement movement type 121.
    Movement type 121 does not have a reversal movement type.
    Possible special stock indicators:
    O, E, Q

    ▲122 Return delivery to supplier or to production
    Using movement type 122, you can distinguish real return deliveries for a purchase order or order from cancellations (102).
    In the standard version, you must enter a reason for the return delivery if you are using movement type 122. This enables you to carry out evaluations for return deliveries.
    The effects of movement type 122 correspond to a cancellation of movement type 101.
    Possible special stock indicators:
    K, O, E, Q

    ▲123 Reversal of return delivery
    If you returned a goods receipt using movement type 122, you can reverse the return delivery using movement type 123. This movement type has the same effects as movement type 101.
    Possible special stock indicators:
    K, O, E, Q

    ▲124 Return delivery to vendor from GR blocked stock
    Using movement type 124, you can return a goods receipt to GR blocked stock (103).
    Movement type 124 has the same effects as movement type 104.
    Possible special stock indicators:
    K, O, E, Q

    ▲125 Return delivery from GR blocked stock - reversal
    If you returned a goods receipt to GR blocked stock using movement type

    ▲124, you can reverse the return delivery using movement type 125.
    Movement type 125 has the same effects as movement type 103.
    Possible special stock indicators:
    K, O, E, Q

    ▲131 Goods receipt for run schedule header
    This movement type cannot be entered manually. It is generated automatically at notification of goods receipt for a run schedule header.
    Possible special stock indicators:
    E, Q

    ▲141 Goods receipt for subsequent adjustment for active ingredient
    This movement type cannot be entered manually. It is generated automatically upon subsequent adjustment for a proportion/product unit . Subsequent adjustment is necessary if the system finds that there has been excess consumption or under-consumption after a goods receipt posting.
    Possible special stock indicators:
    K, O, E, Q

    ▲161 Return for purchase order
    If a purchase order item is marked as a returns item, the returns to vendor are posted using movement type 161 when the goods receipt for purchase order (101) is posted.
    Movement type 161 has the same effects as movement type 122.
    Possible special stock indicators:
    K, O, E, Q

    ▲201 Goods receipt for a cost center
    The goods can only be withdrawn from unrestricted-use stock.
    Possible special stock indicators:
    o K: Goods withdrawal from
    o consignment stock
    o P: Goods withdrawal from pipeline
    If you have withdrawals from consignment stock and from pipeline, payables to suppliers ensue.

    ▲221 Goods issue for a project
    The goods can only be withdrawn from unrestricted-use stock.
    Possible special stock indicators:
    K, Q

    ▲231 Goods issue for a customer order (without Shipping)
    You use this movement type if you want to process the delivery without Shipping.
    The goods can only be withdrawn from unrestricted-use stock.
    Possible special stock indicators:
    E, K, Q

    ▲241 Goods issue for an asset
    The goods can only be withdrawn from unrestricted-use stock.
    Possible special stock indicators:
    K

    ▲251 Goods issue for sales (without customer order)
    Use this movement type if you have not entered a customer order in SD. In the standard system, the movement is assigned to a cost center.
    The goods can only be withdrawn from unrestricted-use stock.
    Possible special stock indicators:
    K

    ▲261 Goods issue for an order
    This refers to all withdrawals for orders (for example, production order, maintenance order, except customer orders.
    Possible special stock indicators:
    E, K, P, Q, W
    The goods issue can be posted manually in Inventory Management or automatically when an order is confirmed or via a delivery in Shipping.

    ▲281 Goods issue for a network
    The goods can only be withdrawn from unrestricted-use stock.
    The goods issue can also be posted via a delivery in Shipping.
    Possible special stock indicators:
    E, K, P, Q

    ▲291 Goods issue for any arbitrary account assignment
    With this movement type, all account assignment fields are ready for input. You can assign the movement to any arbitrary account assignment object.
    The goods can only be withdrawn from unrestricted-use stock.
    Possible special stock indicators:
    E, K, P, Q

    ▲301 Transfer posting plant to plant in one step
    The quantity is transferred from unrestricted-use stock in the issuing plant to unrestricted-use stock in the receiving plant.
    Possible special stock indicators:
    E, O, Q, V, W

    ▲303 Transfer posting plant to plant in two steps - removal from storage
    The quantity is transferred from unrestricted-use stock of the issuing plant to stock in transfer in the receiving plant.
    For technical reasons, you cannot carry out transfer postings from plant to plant in two steps for split valuation materials.
    Removal from storage can be posted with movement type 603 via Shipping.
    Possible special stock indicators:
    None

    ▲305 Transfer posting plant to plant in two steps - placement in storage
    The quantity is posted from
    stock in transfer to unrestricted-use stock in the receiving plant. The movement is not valuated.
    You can use movement type 605 in Shipping to post the goods receipt with reference to the delivery.
    Possible special stock indicators:
    None

    ▲309 Transfer posting material to material
    The quantity is posted from unrestricted-use stock of the issuing material into unrestricted-use stock in the receiving material.
    Prerequisite: both materials have the same stockkeeping unit.
    Possible special stock indicators:
    E, O, Q, V, W

    ▲311 Transfer posting storage location to storage location in one step
    The quantity is transferred from unrestricted-use stock of the issuing storage location to unrestricted use in the receiving storage location.
    Possible special stock indicators:
    E, K, M, Q
    See also 321, 343, 349, 455 for other stock types.

    ▲313 Stock transfer storage location to storage location in two steps - removal from storage
    The quantity is transferred from unrestricted-use stock of the issuing storage location to stock in transfer in the receiving storage location.
    Possible special stock indicators:
    None

    ▲315 Transfer posting storage location to storage location in two steps - placement in storage
    In the receiving storage location, the quantity is transferred from the stock in transfer to the unrestricted-use stock.
    Possible special stock indicators:
    None

    ▲317 Creation of a structured material from constituent components (Retail)
    A material split into its components using movement type 319 can be rejoined using movement type 317.
    Movement type 317 has the same effect as a cancellation of movement type 319.
    Possible special stock indicators:
    None

    ▲319 Split structured material into components (Retail)
    You can enter the splitting of a structured material manually using movement type 319.
    You can configure Customizing so that a structured material (for example, a set, prepack or display is automatically split into its components at goods receipt. The system posts the split using movement type 319. In this process, the BOM header material is posted and each of the component stocks are increased. You can also use this function if you use the Warehouse Management System (WM).
    Possible special stock indicators:
    None
    Example:
    A box of the structured material S contains 3 pieces of the component K1 and 4 pieces of the component K2. The following material document items result after the material is split at goods receipt:
    Qty Unit Material Movement type
    1 box S 101 +
    1 box S 319 -
    4 piece K1 319 +
    5 piece K2 319 +

    ▲321 Transfer posting stock in quality inspection - unrestricted-use stock
    The quantity is transferred from stock in quality inspection into unrestricted-use stock. Here it is possible to post the quantity to another storage location.
    You cannot use this movement type for QM-managed materials since transfer posting for these materials takes place using the usage decision.
    Possible special stock indicators:
    E, K, O, Q, V, W

    ▲323 Transfer posting storage location to storage location - stock in quality inspection
    The quantity is transferred from stock in quality inspection in the issuing storage location into stock in quality inspection in the receiving storage location.
    Possible special stock indicators:
    E, K, Q

    ▲325 Transfer posting storage location to storage location - blocked stock
    The quantity is transferred from blocked stock in the issuing storage location into blocked stock in the receiving storage location.
    Possible special stock indicators:
    E, K, Q

    ▲331 Withdrawal of sample from stock in quality inspection
    The sample is destructive, that is, the withdrawal has the same effects asscrapping.
    Possible special stock indicators:
    E, K, Q, V, W

    ▲333 Withdrawal of sample from unrestricted-use stock
    The sample is destructive, that is, the withdrawal has the same effects asscrapping.
    Possible special stock indicators:
    E, K, Q, V, W

    ▲335 Withdrawal of sample from blocked stock
    The sample is destructive, that is, the withdrawal has the same effects asscrapping.
    Possible special stock indicators:
    E, K, Q

    ▲341 Change in status of a batch (available to unavailable)
    This goods movement is automatically created when there is a change in the status of a batch and it is also used to transfer the unrestricted-use stock into
    restricted-use stock.
    Possible special stock indicators:
    E, K, M, O, Q, V, W

    ▲343 Transfer posting blocked stock - unrestricted-use stock
    The quantity is transferred from blocked stock to unrestricted-use stock. You can also post the quantity to another storage location.
    Possible special stock indicators:
    E, K, Q

    ▲349 Transfer posting from blocked stock to stock in quality inspection
    The quantity is transferred from blocked stock to stock in quality inspection. Here you can transfer the quantity to another storage location.
    Possible special stock indicators:
    E, K, Q

    ▲351 Goods issue for a stock transport order (without Shipping)
    The quantity is transferred from unrestricted-use stock in the issuing plant to stock in transit in the receiving plant.
    Movement type 351 is only used if the goods issue is posted without a delivery in Shipping. A goods issue for a stock transport order with delivery in Shipping is posted using movement type 641, 643, 645 or 647.
    The transfer posting is also possible for materials with split valuation.
    The goods issue for a stock transport order takes place using movement type 101.
    Possible special stock indicators:
    E, Q
    For special stock indicators E and Q and for purchase orders assigned to an account, ensure that the quantity is not posted to the stock in transit in the receiving plant.

    ▲411 Transfer posting of special stocks E, K, and Q to company's own stock
    The quantity is transferred from unrestricted-use special stock E( sales order stock ), unrestricted-use special stock K ( consignment stock) andunrestricted-use special stock Q ( project_stock ) to unrestricted-use storage location stock. The corresponding special stock indicator is required for this movement.
    If you do not use the special stock indicator, the system uses this movement type and movement type 311.
    For sales order stock, you can change the material number for this movement if you manage the material in your company's own stock under a different material number (for example, for configurable materials).
    Consignment stock is transferred to valuated stock, thus resulting in a vendor liability.

    ▲413 Transfer posting to sales order stock
    You can use this movement type to carry out a transfer posting from your own unrestricted-use stock, other sales order stock, consignment stock, and project stock to a sales order stock.
    Possible special stock indicators:
    E, K, Q

    ▲415 Transfer posting to project stock
    You can use this movement type to carry out a transfer posting from your own unrestricted-use stock, consignment stock, and other project stock to a project stock.
    Possible special stock indicators:
    E, K, Q

    ▲441 Transfer posting non-tied to tied empties
    Part of the stock of an "empties" material assigned to a full product is managed in the stock type "tied empties".
    Empties stock not assigned to a full product forms part of the stock type "unrestricted-use".
    Using movement type 441, you can make a transfer posting for an empties material from the stock type "unrestricted-use" to the stock type "tied empties". Movement type 442 reverses this transaction.
    Example:
    The full product "beer" has a stock of 15 cases. Part of the empties components "bottle" and "case" is tied empties stock.
    Material unrestricted-use tied empties
    Beer 15
    Bottle 240 360
    case 10 15

    ▲451 Returns from customers (without Shipping)
    Using movement type 451, you post customer returns without a returns delivery in Shipping into blocked stock returns . The blocked stock returns are not valuated.
    Possible special stock indicators:
    None
    See also: 453, 651, 653

    ▲453 Transfer posting blocked stock returns to unrestricted-use stock
    The quantity is transferred from blocked stock returns to unrestricted-use stock and thereby transferred to valuated stock.
    With this movement you can transfer the quantity to another storage location at the same time.
    Possible special stock indicators:
    None

    ▲455 Transfer posting storage location to storage location - blocked stock
    returns
    The quantity is transferred from blocked stock returns of the issuing storage location to blocked stock returns of the receiving storage location.
    Possible special stock indicators:
    None

    ▲457 Transfer posting blocked stock returns to quality inspection stock
    The quantity is transferred from blocked stock returns to quality inspection stock and thereby transferred to valuated stock.
    With this movement you can transfer the quantity to another storage location at the same time.
    Possible special stock indicators:
    None

    ▲459 Transfer posting blocked stock returns to blocked stock
    The quantity is transferred from blocked stock returns to blocked stock and thereby transferred to valuated stock.
    With this movement you can transfer the quantity to another storage location at the same time.
    Possible special stock indicators:
    None

    ▲501 Goods receipt without purchase order - unrestricted-use stock
    This movement type is used for deliveries from vendors that are not based on a purchase order. Invoice verification is not possible for these goods receipts.
    For a goods receipt for purchase order (101), the receipt of returnable transport packaging can be entered using movement type 501 and special stock indicator M.
    Possible special stock indicators:
    E, K, M, Q

    ▲503 Goods receipt without purchase order - stock in quality inspection
    This movement type is used for deliveries from vendors that are not based on a purchase order. Invoice verification is not possible for these goods receipts.
    Possible special stock indicators:
    E, K, Q

    ▲505 Goods receipt without purchase order - blocked stock
    This movement type is used for deliveries from vendors that are not based on a purchase order. Invoice verification is not possible for these goods receipts.
    Possible special stock indicators:
    E, K, Q

    ▲511 Free-of-charge delivery from vendor
    The quantity is posted to unrestricted-use stock. If there is a material with moving average price, the moving average price is reduced accordingly.
    Possible special stock indicators:
    None

    ▲521 Goods receipt without order - unrestricted-use stock
    This movement type is used for deliveries from production that are not based on an order.
    Possible special stock indicators:
    E, Q

    ▲523 Goods receipt without order - stock in quality inspection
    This movement type is used for deliveries from production that are not based on an order.
    Possible special stock indicators:
    E, Q

    ▲525 Goods receipt without order - blocked stock
    This movement type is used for deliveries from production that are not based on an order.
    Possible special stock indicators:
    E, Q

    ▲531 Goods receipt from by-product from the order
    The goods receipt of a by-product usually refers to an order, but it can be entered without a reference.
    If a component is entered with a negative quantity in the order, a reservation item is created with 531 (instead of 261). The receipt of a by-product can be entered when the component for the order is withdrawn from stock or it can be entered as an 'other goods receipt'.
    Possible special stock indicators:
    E, Q
    See also: 545 and 581

    ▲541 Transfer posting unrestricted-use stock - stock of material provided to vendor
    With this movement type you provide the subcontractor with the components required for subcontract orders . The quantity is posted into unrestricted-use stock of material provided to vendor.
    If there is a goods receipt for a subcontract order (101), the consumption of components is posted from this stock.
    The transfer posting can be posted via a delivery in Shipping.
    Possible special stock indicators:
    None

    ▲543 Consumption from stock of material provided to vendor
    This movement cannot be entered manually.
    The consumption of components for a subcontract order is posted using goods receipt for purchase order (101). It can be corrected by means of a subsequent adjustment.
    For special stock indicators E and Q, you must ensure that the quantity is not posted to the stock of material provided to vendor, but to the unrestricted-use sales order or project stock.
    Possible special stock indicators:
    E, O, Q

    ▲545 Goods receipt from by-product from subcontracting
    If a component is entered with a negative quantity for the subcontract order, the receipt of the by-product is posted to stock provided to vendor during goods receipt for purchase order or during the subsequent adjustment.
    For special stock indicators E and Q, you must ensure that the quantity is not posted to the stock of material provided to vendor, but to the unrestricted-use sales order or project stock.
    Possible special stock indicators:
    E, O, Q

    ▲551 Scrapping from unrestricted-use stock
    Possible special stock indicators:
    E, K, O, Q, V, W

    ▲553 Scrapping from stock in quality inspection
    Possible special stock indicators:
    E, K, O, Q, V, W

    ▲555 Scrapping from blocked stock
    Possible special stock indicators:
    E, K, Q

    ▲561 Initial entry of stock - unrestricted-use stock
    During
    initial entry of stock balances, when the R/3 system is active, you enter the physical warehouse stock figures or the book inventory from your old system into the R/3 Materials Management component. This data entry usually takes place by means of batch input.
    Possible special stock indicators:
    E, K, M, O, Q, V, W

    ▲563 Initial entry of stock - quality inspection
    During
    initial entry of stock balances, when the R/3 system is active, you enter the physical warehouse stock figures or the book inventory from your old system into the R/3 Materials Management component. This data entry usually takes place by means of batch input.
    Possible special stock indicators:
    E, K, O, Q, V, W

    ▲565 Initial entry of stock - blocked stock
    During
    initial entry of stock balances, when the R/3 system is active, you enter the physical warehouse stock figures or the book inventory from your old system into the R/3 Materials Management component. This data entry usually takes place by means of batch input.
    Possible special stock indicators:
    E, K, Q

    ▲571 Goods receipt for assembly order to unrestricted-use
    This movement cannot be entered in Inventory Management, but only in repetitive manufacturing using the Goods receipt for sales order function.
    Possible special stock indicators:
    E, Q

    ▲573 Goods receipt for assembly order to quality inspection
    This movement cannot be entered in Inventory Management, but only in repetitive manufacturing using the Goods receipt for sales order function.
    Possible special stock indicators:
    E, Q

    ▲575 Goods receipt for assembly order to blocked stock
    This movement cannot be entered in Inventory Management, but only in repetitive manufacturing using the Goods receipt for sales order function.
    Possible special stock indicators:
    E, Q

    ▲581 Goods receipt of a by-product from the network
    The goods receipt of a by-product usually refers to a network , but can be entered without reference.
    If a component is entered with a negative quantity in the network, a reservation is created with 581 (instead of 281). The receipt of a by-product can be entered during the withdrawal for the network or as an 'other goods receipt'.
    Possible special stock indicators:
    E, Q

    ▲601 Goods issue for delivery (Shipping)
    In Shipping, this movement type is created automatically with the Goods issue for delivery function.
    The quantity is taken from unrestricted-use stock.
    Possible special stock indicators:
    E, K, Q

    ▲603 Goods issue for stock transport order (Shipping) with additional
    item
    If you issue goods for a stock transport order in Shipping using movement type 641, you can use this movement type to assign an extra item to the order.
    The ordered material is transferred to the stock in transit of the receiving plant. The material for the additional item is transferred from unrestricted-use stock in the issuing plant to stock in transfer in the receiving plant.
    You can also use this movement type without referencing a purchase order.
    Possible special stock indicators:
    None
    See also: 303, 641

    ▲605 Goods receipt for a stock transport order (Shipping) with
    additional item
    You can use this movement type to transfer into unrestricted-use stock the material you posted into stock in transfer in the receiving plant using movement type 603. You post the goods movement with reference to the purchase order (if available) or the delivery.
    Possible special stock indicators:
    None
    See also: 305, 641

    ▲621 Transfer posting unrestricted-use - returnable packaging (Shipping)
    The quantity is transferred from unrestricted-use stock to the returnable packaging stock at customer .
    Possible special stock indicators:
    none

    ▲623 Goods issue from returnable packaging stock at customer (Shipping)
    This quantity is withdrawn from unrestricted-use returnable packaging stock at the customer.
    Possible special stock indicators:
    V

    ▲631 Transfer posting unrestricted use - customer consignment stock (Shipping)
    The quantity is transferred from unrestricted-use stock to consignment stock at customer.
    Possible special stock indicators:
    E, Q

    ▲633 Goods issue from customer consignment (Shipping)
    The quantity is withdrawn from unrestricted-use consignment stock at the customer.
    Possible special stock indicators:
    W

    ▲641 Goods issue for a stock transport order (Shipping)
    The quantity is transferred using a delivery in Shipping from unrestricted-use stock of the issuing plant to stock in transit of the receiving plant.
    The goods receipt for the
    stock transport order takes place using movement type 101 and can, if required, refer to the purchase order or to the delivery. If a purchase order item is flagged as a returns item in the stock transport order, you can post the goods receipt of the returns in the issuing plant with movment type 671.
    Possible special stock indicators:
    E, Q
    For the special stock indicators E and Q and for purchase orders assigned to an account, you must ensure that the quantity is not posted to the stock in transit of the receiving plant.
    See also: 351, 643, 671

    ▲643 Goods issue for a cross-company
    stock transport order (Shipping)
    It is used only for cross-company stock transport orders with SD billing and invoice. The quantity is withdrawn from the unrestricted-use stock of the issuing plant. No stock in transit is created here. In the second step, the goods receipt must be entered in the receiving plant. If a purchase order item is flagged as a returns item in the stock transport order, you can post the goods receipt of the returns in the issuing plant with movment type 673.
    Possible special stock indicators:
    None
    See also: 351, 641, 673

    ▲645 Goods issue for a cross-company
    stock transport order in one step (Shipping)
    Unlike movement type 643, when a goods issue is posted using movement type 645, a goods receipt line is generated automatically. If a purchase order item is flagged as a returns item in the stock transport order, you can post the goods receipt of the returns in the issuing plant with movment type 675.
    Possible special stock indicators:
    None
    See also: 675

    ▲647 Goods issue for a stock transport order in one step
    (Shipping)
    Unlike movement type 641, when a goods issue is posted using movement type 647, a goods receipt line (101) is generated automatically in the receiving plant. If a purchase order item is flagged as a returns item in the stock transport order, you can post the goods receipt of the returns in the issuing plant with movment type 677.
    Possible special stock indicators:
    E, Q
    See also: 677

    ▲651 Returns from customer (Shipping)
    Using movement type 651, you post returns from a customer with a return delivery in Shipping to blocked stock returns.
    Possible special stock indicators:
    None
    See also: 451, 453, 653

    ▲653 Returns from customer (Shipping) to unrestricted-use stock
    With this movement type you post returns from the customer with returns delivery via Shipping directly to the valuated stock.
    Possible special stock indicators:
    E
    See also: 451, 453, 651

    ▲655 Returns from customer (Shipping) to stock in quality inspection
    With this movement type you post returns from the customer with returns delivery via Shipping directly to the valuated stock.
    Possible special stock indicators:
    E
    See also: 451, 453, 651

    ▲657 Returns from customer (Shipping) to blocked stock
    With this movement type you post returns from the customer with returns delivery via Shipping directly to the valuated stock.
    Possible special stock indicators:
    E
    See also: 451, 453, 651

    ▲661 Returns to vendor via Shipping
    As with movement type 502, a return delivery to the vendor is entered without reference to the purchase order, but the goods issue is posted via a delivery in Shipping.
    Possible special stock indicators:
    E

    ▲671 Returns for stock transport order via Shipping
    If a purchase order item is marked as a returns item in a stock transport order using movement type 641, when a goods receipt for a stock transport order (101) is posted, the return is posted to stock in transit using movement type 161. When the return arrives, the issuing plant posts the goods receipt for the return using movement type 671. Movement type 671 (like movement types 352 and 642) reduces the receiving plant's stock in transit and increases the issuing plant's unrestricted-use stock.
    Possible special stock indicators:
    E, Q

    ▲673 Returns for cross-company stock transport order
    (Shipping)
    If you post a goods issue for a cross-company stock transport order with returns items using movement type 643 via Shipping, the returns are transferred to unrestricted-use stock in the issuing plant in a second step using movement type 673.
    Possible special stock indicators:
    None
    See also: 643

    ▲675 Returns for cross-company stock transport order
    (Shipping) in one step
    If you use movement type 645 to post a goods issue for a cross-company stock transport order with returns items in one step, the returns are transferred to unrestricted-use stock in the issuing plant using movement type 161 in the receiving plant and movement type 675 in the issuing plant.
    Possible special stock indicators:
    None
    See also: 645

    ▲677 Returns for stock transport order in one step (Shipping)
    If you use movement type 647 to post a goods issue for a stock transport order with returns items in one step, the returns are transferred to unrestricted-use stock in the issuing plant using movement type 161 in the receiving plant and movement type 677 in the issuing plant.
    Possible special stock indicators:
    E, Q
    See also: 647

    ▲701 Inventory differences in unrestricted-use stock (MM-IM)
    This movement is generated automatically during inventory difference posting in Inventory Management.
    Possible special stock indicators:
    E, K, M, O, Q, V, W

    ▲703 Inventory differences in quality inspection stock (MM-IM)
    This movement is generated automatically during inventory difference posting in Inventory Management.
    Possible special stock indicators:
    E, K, M, O, Q, V, W

    ▲707 Inventory differences in blocked stock (MM-IM)
    This movement is generated automatically during inventory difference posting in Inventory Management.
    Possible special stock indicators:
    E, K, M, Q

    ▲711 Inventory differences in unrestricted-use stock (LE-WM)
    This movement is generated automatically when you post inventory differences in the Warehouse Management System.
    Possible special stock indicators:
    E, K, M, Q

    ▲713 Inventory differences in quality inspection stock (LE-WM)
    This movement is generated automatically when you post inventory differences in the Warehouse Management System.
    Possible special stock indicators:
    E, K, M, Q

    ▲715 Inventory differences in blocked stock returns (LE-WM)
    This movement is generated automatically when you post inventory differences in the Warehouse Management System.
    Possible special stock indicators:
    None

    ▲717 Inventory differences in blocked stock (LE-WM)
    This movement is generated automatically when you post inventory differences in the Warehouse Management System.
    Possible special stock indicators:
    E, K, M, Q

    ▲721 - Sales value receipt - not affecting margins (Retail)
    The movement is generated automatically when the sales price of a value-only material is changed (total sales price revaluation on the posting date).
    Possible special stock indicators:
    None

    ▲731 - Sales value receipt - affecting margins (Retail)
    The movement is generated automatically when the sales price of a value-only material is changed (partial sales price revaluation on the posting date).
     

    展开全文
  • SAP MM之移动类型(Movement type-MVT)

    千次阅读 2019-10-14 23:21:50
    SAP如何在系统中实现对物流的控制: 一、需要满足的最基本需求是:物流的进、出、消耗: 1、何来何往:来(采购订单/生产订单/其它库位);往(销售订单/生产订单/成本中心/内部订单/其它库位/其它工厂) ...

    SAP如何在系统中实现对物流的控制:
    一、需要满足的最基本需求是:物流的进、出、消耗:
    1、何来何往:来(采购订单/生产订单/其它库位);往(销售订单/生产订单/成本中心/内部订单/其它库位/其它工厂)
    2、移动的原因:对物料进行控制,可以区分部门责任
    3、移动的数量和金额:对货仓和财务帐的影响,以及能够实现自动对接。


    二、物料移动的大类(字母标识)
    1表示物料的接收(收货)(receipt)
    2表示物料的发送(发货)(issue)
    3表示物料的转移(transfer)
    当物料移动时,会产生两张DOCUMENTS:
    1、material document (从Warehouse(物流)的角度描述物料的移动)
    2、accout document (从value flow(价值流)的角度描述物料的移动)
    三、物料移动的细项:
    Movement type 
        Mvt type Description 
        1xx GR from Pur/Prd and return 
        2xx GI for Consumption 
        3xx,4xx Transfer 
        5xx GR W/O ref to Pur/Prd Order 
        6xx LE-SHP movement types 
        7xx Physical inventory(IM:70x/WM:71x) 
        8xx Brazil 
        Customer 9xx,Xxx,Yxx,Zxx

    移动类型规律总结:
    1  开头的移动类型:针对收货业务;     

    2  开头的移动类型:针对发货业务;      

    3  开头的移动类型:针对转储业务;    

    4  开头的移动类型:针对特殊转储业务;       

    5 开头的移动类型:针对特殊发货和收货业务;      

    6  开头的移动类型:针对SD/LE货物移动业务;      

    7  开头的移动类型:针对盘点业务;    

    X/Z/Y  等开头的移动类型:一般都是企业自定义的

     

    MvT Movement Type Text  
    101 GR goods receipt 采购订单收货(收货类)
    102 GR for PO   reversal  
    103 GR into blocked stck 采购订单收货至冻结状态(收货类)
    104 GR to blocked rev.  
    105 GR from blocked stck  
    106 GR from blocked rev.  
    107 GR to Val. Bl. Stock  
    108 GR to Val. Bl. Rev.  
    109 GR fr. Val. Bl. St.  
    110 GR fr. Val. Bl. Rev.  
    121 GR subseq. adjustm.  
    122 RE return to vendor 无采购订单退货(收货类)
    123 RE rtrn vendor rev.  
    124 GR rtrn blocked stck  
    125 GR rtn blkd stck rev  
    131 Goods receipt 从生产订单收货(收货类)
    132 Goods receipt  
    141 GR G subseq. adjustm  
    142 GR G subseq. adjustm  
    161 GR returns 按退货采购订单退货(收货类)
    162 GR rtrns reversal  
    201 GI for cost center 成本中心消耗(发货类)
    202 RE for cost center  
    221 GI for project  
    222 RE for project  
    231 GI for sales order  
    232 RE for sales order  
    241 GI for asset  
    242 RE for asset  
    251 GI for sales  
    252 RE for sales  
    261 GI for order 内部订单消耗(发货类)
    262 RE for order  
    281 GI for network  
    282 RE for network  
    291 GI all acc. assigmts  
    292 RE all acct assigmts  
    301 TF trfr plnt to plnt 工厂间转移(转移类)
    302 TR trfr plnt to plnt  
    303 TF rem.fm stor.to pl  
    304 TR rem.fm stor.to pl  
    305 TF pl.in stor.in pl.  
    306 TR pl.in stor.in pl.  
    309 TF tfr ps.mat.to mat  
    310 TR tfr ps.mat.to mat  
    311 TF trfr within plant 存储地点转移(转移类)
    312 TR transfer in plant  
    313 TF rem.fm str.toSLoc  
    314 TR rem.fm str.toSLoc  
    315 TF pl.in str.in SLoc  
    316 TR pl.in stor.inSLoc  
    317 Create struct. mat.  
    318 RE create struc. mat  
    319 Split structured mat  
    320 RE split struct.mat.  
    321
    TF quality to unrest
     
    322 TR quality to unr.  
    323 TF quality in plant 321-325库存类为冻结/质检状态的记账修改和移动
    324 TR quality in plant  
    325 TF blocked in plant  
    326 TR blocked in plant  
    331 GI to sampling QI  
    332 RE to sampling QI  
    333 GI to sampling unre.  
    334 RE to sampling unre.  
    335 GI to sampl. blocked  
    336 RE to sampling blkd  
    340 Batch revaluation  
    341 TF unrestr.to restr.  
    342 TF rstricted to unr.  
    343 TF blocked to unre.  
    344 TR blocked to unre.  
    349 TF blocked to QI  
    350 TR blocked to QI  
    351 TF to stck in trans.  
    352 TR to stck in trans.  
    411 TF SLoc to SLoc  
    412 TR SLoc to SLoc  
    413 TF SLoc to sls order  
    414 TR SLoc to sls order  
    415 TF SLoc to project  
    416 TR SLoc to proj.  
    441 TP unrstr.to tiedEmp  
    442 TP tiedEmp.to unrstr  
    451 GI returns  
    452 RE returns reversal  
    453 TP returns to own  
    454 TP own to returns  
    455 TF st. trfr returns  
    456 TR st. trfr returns  
    457 TP Returns to own QI  
    458 TP Own QI to returns  
    459 TP Ret. to own blckd  
    460 TP Own blckd to ret.  
    501 Receipt w/o PO 无采购订单收货(收货类)
    502 RE receipt w/o PO  
    503 Receipt to QI  
    504 RE receipt to QI  
    505 Receipt to blocked  
    506 RE receipt to blockd  
    511 Delivery w/o charge 免费收货(收货类)
    512 RE deliv. w/o charge  
    521 Receipt w/o order  
    522 RE receipt w/o prOrd  
    523 Rcpt QI w/o prOrder  
    524 RE quality w/o prOrd  
    525 Rcpt blkd w/o pr.ord  
    526 RE blocked w/o PrOrd  
    531 Receipt by-product  
    532 RE by-product  
    541 GI whse to subc.stck 委外加工发货(发货类)
    542 RE subctrStck toWhse  
    543 GI issue sls ord.st.  
    544 GI receipt sls or.st  
    545 Rcpt SC by-product  
    546 GI issue SC by-prod.  
    551 GI scrapping 库房报损(发货类)
    552 RE scrapping  
    553 GI scrapping QI  
    554 RE scrapping QI  
    555 GI scrapping blocked  
    556 RE scrapping blocked  
    557 GI adjust. transit  
    558 GI adjust. transit  
    561 Init.entry of stBal.  
    562 RE in.entry stk bals  
    563 Init. entrStBals: QI  
    564 RE ent.st.bals: QI  
    565 In.ent.stBals: blckd  
    566 RE ent.stBals: blckd  
    571 Receipt assembly  
    572 RE receipt assembly  
    573 Rcpt QI assembly  
    574 RE rcpt QI assembly  
    575 Rcpt blckd assmbly  
    576 RE rcpt blkd assmbly  
    581 Rcpt by-prod network  
    582 RE by-prod. network  
    601 GD goods issue:delvy  
    602 RE goods deliv. rev.  
    603 TF rem.fm stor.to pl  
    604 TR rem.fm stor.to pl  
    605 TF pl.in stor.in pl.  
    606 TR pl.in stor.in pl.  
    617 Cre. Str. Mat. Cons.  
    618 RE Cr. Str. Mat. Con  
    619 Rem. Str. Mat. Cons.  
    620 RE Rem. Str Mat Cons  
    621 GI ret.pack.:lending  
    622 GI ret.pack:ret.del.  
    623 GI iss:cust.ret.pack  
    624 GI rcpt:cust.re.pack  
    631 GI consgmt: lending  
    632 GI consgmt:ret.delvy  
    633 GI iss: cust.consgmt  
    634 GI rcpt:cust.consgmt  
    635 TF consgmt lending  
    636 TR consgmt ret. del.  
    641 TF to stck in trans.  
    642 TR to stck in trans.  
    643 TF to cross company  
    644 TR to cross company  
    645 TF cross company  
    646 TR cross company  
    647 TF to stck in trans.  
    648 TR to stck in trans.  
    651 GD ret.del.  returns  
    652 GD ret.del. retn rev  
    653 GD returns unrestr.  
    654 GD returns unr. rev.  
    655 GD returns QI  
    656 GD returns QI  rev.  
    657 GD returns blocked  
    658 GD returns blk. rev.  
    661 GI returns to vendor  
    662 RE ret. to vdr revrs  
    671 TR to stck in trans.  
    672 TF to stck in trans.  
    673 TF to cross company  
    674 TR to cross company  
    675 TR cross company  
    676 TF cross company  
    677 TR to stck in trans.  
    678 TF to stck in trans.  
    6A1 TF GI1  
    6A2 TR GI1  
    6A3 TF CC GI1  
    6A4 TR CC GI1  
    6A5 TF CC GI1  
    6A6 TR CC GI1  
    6A7 TF GI1  
    6A8 TR GI1  
    6B1 TF GI2  
    6B2 TR GI2  
    6B3 TF CC GI2  
    6B4 TR CC GI2  
    6B5 TF CC GI2  
    6B6 TR CC GI2  
    6B7 TF GI2  
    6B8 TR GI2  
    6K5 TF GI2 consi  
    6K6 TR GI2 consi  
    6W5 TF GI1 consi  
    6W6 TR GI1 consi  
    701 GR phys.inv.: whse  
    702 GI phys.inv.: whse  
    703 GR phys.inv: QI  
    704 GI phys.inv: QI  
    707 GR phys.inv.:blocked  
    708 GI phys.inv.:blocked  
    711 GI InvDiff.:whouse  
    712 GR InvDiff.:wrhouse  
    713 GI InvDiff: QI  
    714 GR InvDiff: QI  
    715 GI InvDiff.:returns  
    716 GR InvDiff.:returns  
    717 GI InvDiff.: blocked  
    718 GR InvDiff.: blocked  
    721 SlsVal.rec.n.afftMgs  
    722 SlsVal.iss.n.afftMgs  
    731 SlsVal.rec. afftgMgs  
    732 SlsVal.iss. afftgMgs  
    841    
    842    
    843    
    844    
    901 TF trfr plnt to plnt  
    902 TR trfr plnt to plnt  


    四、移动类型在某电子行业重复制造模式企业的应用

        以部门为线 串一下

        1/库房收货处 唯一任务是收货 按采购订单号码 清点货物数量 整理通知IQC准备质检 
        101 按采购订单收货 MB01 没上WM会收到PO指定的存储地点 有WM会收到收货区(是对应WM移动类型决定) 
        使用QM模块 并在主数据中设定必须做IQC的物料 收货后自动转为质检库存类 直到作出使用决定后再移动 
        501 无采购订单收货 
        511 免费收货 MIGO/MB1C

        2/库房材料库 主要任务是WM转储/库存调拨/按生产订单投料/非生产消耗/盘库 
        WM转库就不讲了 
        库存调拨 有工厂间调拨 301 存储地点间调拨 311 事务码都是MB1A 
        还分一步和两步方法 例如用 303+305 效果与301类似 但两个工厂都需要做动作 用内部订单控制 
        月底结算 双方对帐 
        对特殊库存状态(special storage category)物料库存调拨需要用特殊移动类型 质检料的转库 323 冻结料的转库 325 
        对库存状态变化 质检->自由库存 321 MB1B 
        编码转换 309 MB1B

        由于生产方式是重复制造 采用反冲方法 将原材料转入supply area 通过生产线软件取数据 自动confirm生产订单 然后反冲 根据order消耗 然后发货到生产线收货区 
        对材料 261消耗到订单 对应前端MB1C 对半成品/成品 101收货 对应前端MB31

        报损 551 MB1C 这里的移动原因一般是强制输入的 以便月底报表 区分各部门数据(供应商原因/研发原因/各生产线原因) 
        借料 系统里面没有 拷一个出来就是 自然是借到成本中心来控制

        月底盘库 701/702 Or 711/712 这个用户看不到 对盘库差异清算自动产生

        3/库房发货处 
        这里的移动类型也看不见 对这里人员是根据delivery note和shipping noification发货 
        601 销售出库 
        633 寄售出库(总部->分公司) 
        541 委外加工发货 

     

     

    转自:https://blog.csdn.net/xiaohutushen/article/details/5648278

     

    展开全文
  • ROW MOVEMENT特性最初是在8i时引入的,其目的是提高分区表的灵活性——允许更新Partition Key。这一特性默认是关闭,只是在使用到一些特殊功能时会要求打开。 在下面3中情况下才会使用此特性: 1.flashback ...
  • 关于ROW MOVEMENT

    2017-05-02 10:40:11
    Row Movement Common Questions and Problems (Doc ID 1518567.1) To Bottom MOVEMENT" /> Modified:21-Jan-2013MOVEMENT" />Type:FAQMOVEMENT" /> MOVEMENT" /> MOVEMENT" /> MOVEMENT" /> M
  • 关于alter table enable row movement的应用

    万次阅读 2016-04-05 21:13:50
    1. 一般用于分区表,将row movement设置为enable,有可能发生行的物理移动,行的rowdi会变化,某一行更新时,如果更新的是分区列,并且更新后的列值不属于原来的这个分区,如果开启了这个选项,就会把这行从这个分区...
  • 如果经常在表上执行DML操作,会造成数据库块中数据分布稀疏,浪费大量空间。同时也会影响全表扫描的性能,因为全表扫描需要访问更多的数据块。从oracle10g开始,表可以通过shrink来重组数据使数据分布更紧密,同时...
  • Oracle row movement

    千次阅读 2012-03-30 14:43:14
    ROW MOVEMENT特性最初是在8i时引入的,其目的是提高分区表的灵活性,这一特性默认是关闭,只要使用一下3个功能才需要打开: 1.Flashback Table 这一功能能帮助我们及时回滚一些误操作,防止数据意外丢失。在...
  • flashback table t to scn:scn  * ERROR at line 1: ORA-08189: cannot flashback the table because row movement is not enabled   使用闪回命令出错      
  • row movement,该特性用来指定是否运行数据库能move 表里的row (ROWID发生了变化) 常见到需要enable row movement的地方有 1)segment shrink(from 10g)(必须) 2)flashback table(from 10g)(必须) 3)update ...
  • alter table table_name enable row movement

    千次阅读 2015-02-16 15:50:48
    Row movement 从字面意思解释为行移动.默认情况下,oracle数据块中的一行其生命周期内是不会发生移动的,即其rowid不会发生改变. 但是在某些情景下,我们希望行的rowid可以发生变化,这时候我们就需要启动表的row ...
  • 解释器模式(Interpreter Pattern) 解释器模式属于行为型模式,给定一个语言,定义它的文法表示,并定义一个解释器,这个解释器使用该标识来解释语言中的句子。 解释器模式提供了评估语言的语法或表达式的方式。...
  • SAP移动类型详细说明

    千次阅读 2013-01-09 15:19:12
    SAP移动类型详细说明 101 Goods receipt for purchase order or order 101有关采购订单或生产订单的收货 If the purchase order or order has not been assigned to an account, a stock type (unrestricted...
  • sql server例子处理

    千次阅读 2012-06-26 13:11:09
    以下为当时所做的项目一些垃圾数据处理。当时不知道如何调试sql server 2005(2008),就单独写了一段代码处理,也未使用存储过程。 DROP TABLE #ContainerTemp DECLARE @varRowCountID int DECLARE @...
  • SAP的标准移动类型说明(From SAP Help)

    千次阅读 2008-01-21 16:01:00
    Further informationBelow you will find a short description of the standard movement types. The reversal movement type is the movement type + 1 (reversal of 101 = 102).101 Goods receipt for purchas
  • 作者简介:黄玮(Fuyuncat)资深Oracle DBA,个人网站www.HelloDBA.com,致力于数据库底层技术的研究,其作品获得广大同行的高度评价.ROW MOVEMENT特性最初是在8i时引入的,其目的是提高分区表的灵活性——允许更新...
  • Unity3D 中物体移动脚本小记

    千次阅读 2017-02-01 22:57:56
    Uinty3D 中物体移动脚本小记最近几天在Unity官网看了官方提供的教程,自己也实验了一下,发现几个不同的项目中,脚本中对物体移动的实现方式并不相同。using UnityEngine;public class PlayerMoveController : ...
  • Fld selectn for mvmt type 551 / acct 400001 differs for Customer goods movement (015) Message no. M7093 Diagnosis Comparison of the field selection strings from movement type 551 and G/L account 4
  • UGUI提高<一> Scroll View参数详解

    万次阅读 2016-11-17 17:13:24
    原创 最近用UGUI的时候老感觉有的参数不记得什么作用了,找这个找那个的,记性真不行,还是要写在博客上,不记得可以来看看。现在越来越觉得写博客真的非常有必要。 先创建一个UGUI整合好的Scroll View。...
1 2 3 4 5 ... 20
收藏数 29,533
精华内容 11,813
关键字:

movement