Programme SAP J_3RMOBVED - Stock Overview (Russia)

Description
The program is intended for material valuated stocks and theirs movementshow from the point of view of:
MATERIAL - VALUATION TYPE - PLANT - STORAGE LOCATION - SPECIAL STOCK -RESIDENCE PLACE -BATCH.
The report shows valuated stock types:

  • unrestricted-use

  • in transfer from one storage location to another

  • in quality inspection

  • blocked

  • special valuated

  • in transit (plant - plant)

  • restricted-use
  • Special ctock.
    The report shows five special (valuated) stock types.

    • W - consignment stock at customer

    • V - returnable packaging at customer

    • E - stock for customer orders

    • Q - project stock

    • O - part provided vendor

    • Special stocks of types W, V, O is show on storage with #### descriptor.

      Residence place.
      Is show for special stock only. Its my be:

      • vendor,

      • customer,

      • WBS element,

      • customer order.
      • Algorithm
        Stock value and quantity are calculated by the report. The balance atthe beginning and end of the period is calculated by backward deductingturnovers from the current date value.
        Value of a storage location stock at the beginning of the periodis calculated by means of division the total stock value in terms ofvaluation type into the material stock quantity at the beginning periodof the plant.
        Value of a storage location stock at the end of the period iscalculated by means of division the total stock value in terms ofvaluation type into the material stock quantity at the end period of theplant.
        If it happens a stock value of the even-numbered quantity is representedby an odd number, or when the material of the odd value has beendistributed to an even number of storage locations. in this casedivergence is possible between the storage location stock value at thebeginning of the period and the storage location stock value at the endof the preceding period during the calculation.
        Since the stock value can variate at the PLANT level, totals of stockrevaluation documents will be calculated and distributed to storagelocations in accordance with the following algorithm:
        Determination the storage location stock quantity available at theperiod start.
        Calculated value is proportional to the quantity of the storagelocationmaterial stock. Here rounding errors are possible but they canbe corrected applying standard mathematical rules. If the total ofstorage location material values is not equal to the material value ofthe valuation type, a storage location with the maximum materialquantity available at the period start is determined. The stock value ofthis storage location is corrected in such a way so that the sum of thematerial value for storage location is equal to the material stockvalueof the valuation type.
        It is possible, that material on one of factories warehouse iscapitalization with price, differenced from factory material price.Price of a similar material in other warehouses also will change. Inthis case in report on each warehouse you see the amounts, whichadjusted this material price with according to a factory price.
        When material is transferred without any accounting documents created,rounding errors (corrected later) on the calculation of the transferredstock value are also possible.
        The material stock value at the period end is calculated in a usual way:the period-end balance is equal to the period-start balance plusmaterial receipt minus expenses (in accordance with movement documents).

        Stock in transfer and two-step moving specificity show in the report.
        Should take into account, the R/3 system creates documents for two-stepmoving in the following way:
        For issue from plant sender the system creates three documents

        • Issue material document;

        • Issue financial document for plant sender;

        • Delivery financial document for plant recipient.

        • Transaction dates these three documents are coincided. After thisdelivery document for plant recipient is created without financialdocument. At that the transaction date can be not equal the deliveryfinancial document transaction date. It possible can be arbitrarycorrelation issue and delivery events:
          • one issue event and one delivery event;

          • one issue event and some delivery events;

          • some issue events and one delivery event;

          • some issue events and some delivery event.

          • Two-step movings are possible as with reference to transfer order (351and 101 moving type), as without reference to transfer order (forexample 303 and 305 moving type).
            If it happens in the R/3 system exist stock in transfer in current date,the report show two-step moving with '####' out of pseudo-storagewarehose identifier for plant recipient, of course if two-step movingwere in the slection-screen defined period.
            If it happens in the R/3 system doesn't exist stock in transfer incurrent date, the report doesn't show two-step movings, even if theirswere in the slection-screen defined period.
            Issue events from plant sender are shown in the report for out of palntrecipient out of pseude-storage warehouse as transfer stock intransit i.e. issue material document for plant sender is also shown forpalnt recipient out of pseude-storage warehouse as deliverydocument in transit. Financial document is shown for the out of
            pseude-storage warehouse as extension value document in transit.
            Delivery events for target storage warehouse of plant are also shown inthe report as issue documents for out of pseude-storagewarehouse.
            If transfer stok is made with reference to transfer order, for outof pseude-storage warehouse and for target warehouse are shown samedocuments, for out of pseude-storage warehouse these are issuedocuments but for target storage warehouse these are deliverydocuments.
            If issue document date is out of selection-screen parameters range anddelivery document date within selection-screen parameters range thereport show cost increase financial document for target plant.
            If transfer stok is made with reference to transfer order, the reportdoesn't show financial document number for targets storage warehouse,but show cost of transfer stock which is calculated. Same is showntransfer for out of pseude-storage warehouse.

            Required_entries
            For a possibility of account of cost of a stock in a warehouse on anyany date, it is necessary to ensure consecutive data data input inSystem, according to date of posting.
            The report will not be work correctly, if in you system usedsummarization accounting documents.

            Output
            The report is prepared by means of ABAP LIST VIEWER. Use its standardfunctions to get various displays of received data includingcalculations of subtotals. In case of any alteration of the reportrepresentation, it is recommended to save its settings as a reportvariant.
            The variant of the report depend on "Material movement documents"option. Variant was created with specified option cannot be accessiblefor use without this option.
            The report is available in two modes:

            Material movement documents
            A two-level hierarchical list is displayed in the output screen when theindicator is activate.
            If the indicator is off, the data is output as a single-level two-rowlist. Second level rows display total material movement turnovers.
            The "Account assignment" field can display various information dependingon the movement type and document category.
            G/L - G/L account
            PuOr - Purchase order number
            OrdN - Order nomer
            CuOr - Customer order nomer
            Pln. - Receiving plant / Issuing plant
            Pric - moving average price correction sum
            Cust - Customer account number
            Vend - Vendor account number
            AA - Main asset number
            CCt - Cost center
            WBS - work breakdown structure element
            Strg - Storage location
            Chrg - Batch

            Non-movement materials
            If the option is not activated, the report displays only thosematerialsthat have remaining quantities and/or movement during thereporting period.
            If the indicator is activated, the output list contains all materialschosen on the selection screen.

            Correcting documents
            Setting this option affects the output of correcting documents andcorrecting business volume values in the report. The following reportoptions are available:
            If the "Correcting documents" and "Material movement documents" optionsare not activated, the quantities and values on reversal and cancelabledocuments are not included in the business volume value.
            If the "Material movement documents" option is activated and the"Correcting documents" option - deactivated, the reversal and cancelabledocuments aren't displayed in the report.
            If the "Correcting documents" option is activated and the "Materialmovement documents" option - deactivated, the quantities and values onreversal and cancelable documents aren't included in the business volumevalue.
            If both "Correcting documents" and "Material movement documents" optionsare activated, the correcting documents are included in the list andhighlighted with yellow color. reversal and cancelable turnovers aren'tincluded in the business volume value.
            This option govern processing two correction documents types: materialdocuments and invoices. If canceled or reversal document posting date isout of select-option range, in this case these documents are shownwithout the special option.
            The report will not be show in special mode reversal for reversaldocuments. I.e. should not reverse a reversed document, but create ausual document, otherwise reverse for reversed documents will not beshow in special mode.

            Price change: separately graph
            It happens that on one of warehouses will be debit of material whichprice is not equal to moving average price on a factory or invoice withother material price. This price different amount from material priceisnecessary to rundown stock balancing for similar material in allwarehouses of factory.
            The program in this case created in report a separate line on eachwarehouse. The distribution amount settled automatically according toanalyzed material quantity and is allocated on all warehouses. Thedistributed amount sign (+/-) shows, is the total costs of thismaterialon warehouse increased or decreases. The operation coursecontent is showed under column "Assignment".
            If the indicator is not activated, materials price different amountsareshowed under column "DebitAmount".
            If the indicator is activated, materials price different amounts areshowed under separate column "Supplementary value".

            Additional features
            To view additional information, choose the desired item
            the "Stock overview: plant/storage location/batch" report from the"material number" item (transaction MMBE)
            material document from the "material document number" item
            accounting document from the "accounting document number" item
            sales order
            purchase order
            work breakdown structure element

            Options to keep / receive the report from a database.
            If the option "Keep report in database" is active our report is kept inthe databases table "INDX" with the key "IM". That report can be usedoperatively for the further analysis.
            The storing is possible on two vevels:
            on a plant level
            on a company code + GL account level
            In both cases storing is possible only for one period (month).
            Preservation is made strictly on a plant and period (month) for all fouroptions combinations of the selection screen separately.
            At the data saving in database two options of the selection screen areconsideration: "Show corrective documents" and "Price change: separatecolumn"
            If on the selection screen:
            more, than one value into field "Plant" are entered
            more than one value into fields "Company code" and "GL account"
            calculation period more, than one month
            you see a warning message and those fields are corrected automatically.
            You can looking the report again, pressed a button "F8" if the basicfields contents are not changed.
            Repeated calculation also will not be carried out, if you only fields "View variant (format) " and / or options "Material movement documents "have changed.

            SAP extension.
            In programm is included BADI /CCIS/IF_EX_SCMIM_ENH. The BADI allow makeown riport format.

            Example
            The report displays material revaluation documents (of the invoice) thatalter the material value. Revaluation is performed at the plant level,the total of this document is distributed to storage locationsinproportion to the quantity of material available at the revaluationdateRevalua total of all revaluation items displayed in the report ondifferent storage locations is equal to the total of the accountingrevaluation document.
            Output of material prior to revaluation
            Material Storage location Qty Start value End value
            M001 001 1 20,19 20,19
            M001 002 1 20,18 20,18
            Plant total: 40,37 (2 pieces)
            Output of material after revaluation
            Material Storage location Qty Start value End value
            M001 001 1 20,19 20,19
            Revaluation document Receipt:0,01
            M001 002 1 20,18 20,18
            Revaluation document Receipt:0,01
            Plant total: 40,39 (2 pieces)

            Performance:
            If the non-unique indexes for following tables are activated, processingoccurs faster.
            Table Fields
            MARD MANDT, WERKS
            MBEW MANDT, BWKEY
            EBEW MANDT, BWKEY
            QBEW MANDT, BWKEY
            MCHA MANDT, WERKS
            MCHB MANDT, WERKS
            MSKU MANDT, WERKS, SOBKZ
            MSKA MANDT, WERKS, SOBKZ
            MSPR MANDT, WERKS, SOBKZ
            MSLB MANDT, WERKS, SOBKZ
            MKPF MANDT, XBLNR
            VBFA MANDT, VBELN, VBELV, VBTYP_V
            The report settlement time is reduced, if:
            on the selection screen restrictions under the materials list, plantsand / or valuation type are entered,
            reports period is not far to the current date,
            analyzed material is only in one warehouse and this warehouse is chosenon the selection screen.

            Recommendation
            You should also make usage of the note 114716 for databse Oracle.

            Authority objects
            The following authorization objects are checked in the program:

            • J_3RM_WRTB - Writing result of the report to database

            • M_MATE_WRK - Material Master: Plants

            • F_BKPF_BUK - Accounting Document: Authorization for Company Codes
            • Note
              The report calculate stock and value by backward deducting turnoversfrom the current date value. If a material stock or value is changedduring the report work, it locks master record of the material,recalculate steock and vluae and unlocks the record. Lock method allowsto avoid result mistakes in the report if material changing during theprogram work.