Skip to Content
avatar image
Former Member

2lis_03_BF enhancement

Dear all

I have a requirement of enhancing the datasource of 2LIS_03_BF with a field BSART ( Purchasing Document type from the talbe EKKO). Can any one help me in this regard ?

wtih regards

Ram

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

5 Answers

  • Best Answer
    avatar image
    Former Member
    Apr 28, 2008 at 07:06 AM

    Hi,

    Here is LO Cockpit Step By Step

    LO EXTRACTION

    - Go to Transaction LBWE (LO Customizing Cockpit)

    1). Select Logistics Application

    Extract Structures

    2). Select the desired Extract Structure and deactivate it first.

    3). Give the Transport Request number and continue

    4). Click on `Maintenance' to maintain such Extract Structure

    Select the fields of your choice and continue

    Maintain DataSource if needed

    5). Activate the extract structure

    6). Give the Transport Request number and continue

    - Next step is to Delete the setup tables

    7). Go to T-Code SBIW

    8). Select Business Information Warehouse

    i. Setting for Application-Specific Datasources

    ii. Logistics

    iii. Managing Extract Structures

    iv. Initialization

    v. Delete the content of Setup tables (T-Code LBWG)

    vi. Select the application (01 – Sales & Distribution) and Execute

    - Now, Fill the Setup tables

    9). Select Business Information Warehouse

    i. Setting for Application-Specific Datasources

    ii. Logistics

    iii. Managing Extract Structures

    iv. Initialization

    v. Filling the Setup tables

    vi. Application-Specific Setup of statistical data

    vii. SD Sales Orders – Perform Setup (T-Code OLI7BW)

    Specify a Run Name and time and Date (put future date)

    Execute

    - Check the data in Setup tables at RSA3

    - Replicate the DataSource

    Use of setup tables:

    You should fill the setup table in the R/3 system and extract the data to BW - the setup tables is in SBIW - after that you can do delta extractions by initialize the extractor.

    Full loads are always taken from the setup tables

    Cheers,

    Malli.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 27, 2008 at 05:22 PM

    Hi

    Please have a look at the below url

    https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/b0af763b-066e-2910-a784-dc6731660f46

    Coding part:

    You can write code using EBELN to get the required information...Like

    select BSART from EKKO where

    EBELN = Your Extractstructure-EBELN ...

    Hope it helps

    Thanks,

    Teja

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 28, 2008 at 08:26 AM

    Hi Ram,

    Please go to rsa6 then select 2lis_03_bf then double click -->double click on extract structure MC03BF0 --> Choose Append Structure, add your additional field (BSART).

    To populate additional field BSART use datasource function enhancement (cmod) with a little abap.

    Link to table EKKO based on MC03BF0-EBELN.

    I hope this help.

    Cheer

    Ir

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 28, 2008 at 12:28 PM

    Hello RAM ,

    give ur mail id.

    i will send you a document on enhancing the datasource.

    Thanks,

    Vinay

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Vinay.

      can you send me the step by step document for enhancing the data source 2lis_03_bf on zeeshanhaider at g m ail com

      i want to enhance 2lis_03_bf with CPUTM field.

      kind regards,

  • avatar image
    Former Member
    Sep 21, 2010 at 10:29 AM

    Hi,

    You can follow the steps in the below document to Enhance LO datasource:

    http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/b0af763b-066e-2910-a784-dc6731660f46

    Hope tis helps!!!

    Thanks & Regards,

    Balaji.S

    Add comment
    10|10000 characters needed characters exceeded