Skip to Content
avatar image
Former Member

LIS Delta

Hi all,

Could anybody please tell me how to initialize and do delta in LIS extraction?

And what happens in the background when we initialize the delta?

Thanks.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Aug 18, 2007 at 06:13 PM

    Hi Komal,

    <b>Initialization</b>

    You will do <b>Initialization </b>after setting up the environment for the first time. Initialization allows you to extract the historical information as an initial load into BW from the specified LIS structure.

    Initialization makes sure that the data has been extracted to the system up to a certain point and it will time stamp at that point. Once we go to extract data again with Delta upload method, only the changed records or newly added records will be extracted to the target system which obviously stops data redundancy.

    The <b>delta update</b> is basically enables the delta time stamp after the initial load and the loads on daily basis / weekly basis or what ever the time is appropriate.

    <b>LIS Extraction step by step Procedure:</b>

    Step by Step for LIS Extraction

    LIS EXTRACTION

    T.code - :MC18 – create field catalog

    1. Characteristic Catalog

    Application-01-Sales and Distribution, 02-Purchasing, 03-Inventory Controlling, etc.

    Catalog category 1. Characteristic catalog, 2. Key figures catalog 3. 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.

    Save, similarly create key figures catalog

    T.code : MC21 – create infostructure

    Infostructure : 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

    T.code – 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. Daily, 2. Week, 3. Month, 4. Posting period

    Updating –1)No updating,2)Synchronous updating (V1), 3)As synchronous updating (V2), 4)As synchronous updating (V3),

    T.code – LBW0 - Connection of LIS Information structures to SAPBW

    Information structure : S786

    Select the radio button-Setup LIS environment and Execute.

    Select the radio button-Generate data source and Execute.

    For Delta update:

    Select the radio button-Generate updating and Execute

    Select the radio button -Activate / deactivate and Execute.

    T.code – 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.

    Choose activity

    Setup – Orders, deliveries, billing

    Choose the activities enter the infostructure (S789), give name of the run, date of termination, time of termination, No. of tolerated faulty documents. Then execute

    T.code – RSA3 – Extractor checker

    Give the data source name eg. 2LIS 01S789 and execute, result will get some records

    Go to BW side replicate data source – Assign infosource – Create infocube – Create update rules – create infopackage and schedule the package with initialize delta process.

    For delta update :

    In R/3 side

    T.code – MC25, set update (V1) or (V2) or (V3)

    T.code – LBW0, choose generate updating and execute then choose activate / deactivate and execute

    BW side - create infopackage and schedule the package with delta update.

    First time if your scheduling the infopackage -in R/3 side T.code :MC25 -Udating set to No update,insted of selecting the update V1,V2,V3.

    If your doing the Delta update:in R/3 side T.code :MC25-Updating set to either V1 or V2 or V3. and the to T.code :LBW0 -Select the radio button Active/deactivate and Execute.

    and schedule the infopackage with delta update.

    Refer this PDF for explanation with screen shots,

    http://help.sap.com/bp_biv170/documentation/HowToInventoryNW.pdf

    Assign points if it helps,

    Regards,

    Mani

    Message was edited by:

    Manikandan A

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Mani,

      Thanks for ur info .

      What I understood is during initial loading process, the update of the infostructure in the R/3 system should be set to 'No Update'. Why we've set as 'No Update'? Is there any reason?