cancel
Showing results for 
Search instead for 
Did you mean: 

2lis_03_BF enhancement

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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.

Answers (4)

Answers (4)

Former Member
0 Kudos

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

Former Member
0 Kudos

Hello RAM ,

give ur mail id.

i will send you a document on enhancing the datasource.

Thanks,

Vinay

Former Member
0 Kudos

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,

Former Member
0 Kudos

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

Former Member
0 Kudos

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-dc673166...

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