on 04-27-2008 1:21 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello RAM ,
give ur mail id.
i will send you a document on enhancing the datasource.
Thanks,
Vinay
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
Please have a look at the below url
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.