For delta update : In R/3 side – MC25, set update (V1) or (V2) or (V3) – LBW0, choose generate updating and execute then choose activate / deactivate and execute BW side - create infopackage and schedule the package with delta update.
Steps in LIS EXTRACTION: - : MC18 – create field catalog 1. Save, similarly create key figures catalog : MC21 – create infostructure Example – Inforstructure : S789 Application – 01 Choose characteristic select the catalog, select the fields, copy close Choose key figures catalog select the key figures ,copy close, save and generate – MC24 – create updating Infostructure : S789 Update group : 01- Sales document, delivery, billing document ,enter Select the key figures click on rules for key figures give suggest rules, copy save and generate Click on updating (activate updating) Select the infostructure set periodic split 1. For Delta update: Select the radio button-Generate updating and Execute Select the radio button -Activate / deactivate and Execute.
Characteristic Catalog Application-01-Sales and Distribution, 02-Purchasing, 03-Inventory Controlling, etc.. – SBIW – Display IMG (implementation guide) Setting for applications specific data source – logistics – Managing transfer information structure – setup of statistical data – applications specific setup of statistical data –perform statistical setup – sales.
Prior to this, any database update can be canceled by a database rollback (see Programming transactions ). Three types of SET statements si are supported:f = g In all selected lines, the database table column determined by f receives the values of the ABAP/4 field or literal g .f = f g In all selected lines, the contents of the ABAP/4 field or literal g is added to the value in the database table column determined by f . This statement can only be applied to a numeric field.f = f – g In all selected lines, the contents of the ABAP/4 field or literal g is subtracted from the value in the database table column determined by f . This statement can only be applied to a numeric field.
Data can only be updated using a view if the view refers to a single table and was created in the ABAP/4 Dictionary with the maintenance status “No restriction”. Notes Authorization checks are not supported by the UPDATE statement. Changes to lines made with the UPDATE command only become final after a database commit (see LUW ). If a WHERE condition is specified, only those records which satisfy the condition are updated. sn identifies the columns to be updated and assigns values to them.
It achives this using COMMIT WORK AND WAIT instead of using just COMMIT WORK.
Actually synchronous update is identical to using PERFORM …
Date catalog Select characteristic catalog and enter, click on characteristic select the source table and it will be display the relevant source field and select the source field, copy close, copy. Select the radio button-Generate data source and Execute.
Posting period Updating –1)No updating,2)Synchronous updating (V1), 3)As synchronous updating (V2), 4)As synchronous updating (V3), – LBW0 - Connection of LIS Information structures to SAPBW Information structure : S786 Select the radio button-Setup LIS environment and Execute.
Few might be wondering that this requirement can be well addressed by a simple development. Such development would be very complex because, taking care of Breakdown Duration of Equipments under a Functional Location would be very complicated and so a less reliable code would be an outcome if developed locally.
The same thing comes from Standard through this SAP-note in an accurate way.
The Audit demand was that the Equipment Availability figures be made available at the Functional Locations level, even when no direct M2 notifications are created on them. The recommendation was in the form of implementing an SAP note namely Readers might by now have understood that by implementing the said SAP note, SAP will be providing the collective MTTR, MTBR values on the Functional Locations. The moment we created one M2 Notification on the Big machine (F/Locn), the MCJC report showed the computed figures of hierarchical MTTR, MTBR values..