- It is an Application specific business content extractor , It can extract the data from all the logistics applications.
Logistics application Numbers
02 ------------ Purchasing
03 ------------ Inventory controlling
05 ------------ Quality Management
06 ------------ Invoice verification
11 ------------ Sales order
12 ------------ Delivery
13 ------------ Billing
Some numbers for logistics applications.
- From the material Procurement till to the Delivery of the Product.
- There are some applications which are grouped as logistics applications.
- In logistics the data is Divided into
Master Data (Attr/Text/Hier)
Transaction Data. - Logistics Transaction data is divided into Header Data , Item Data & Schedule Line Data.
- Header Data : It includes all Document Header Data . ex. Doc no.
- Item Data : It Includes Item Level data. ex . order qty , order value , Invoice Amount...
- Schedule Line Data : It Includes all the deliverable Information . ex. Delivery Data , Delivery Quantity , Delivery Value ..
- All the data is updated to standard table like VBAK , VBRK, LIKP ... etc. from the standard tables using a Business content Data Source the Data should be Extracted to BW system.
DATA SOURCE NAMING CONVENTIONS :
11 ------- 2LIS_11_VAHDR / 2LIS_11_VAITM / 2LIS_11_VASCL
2LIS -------- Standard refer for every LO Data Source.
11 ----------- Application Number.
va/vc/vd ------ events for Applications.
HDR ----------- Header
ITM ----------- Item
SCL ----------- Schedule line.
Some Basic Data Source used regularly
12 --------- 2LIS_12_VCHDR / 2LIS_12_VCITM / 2LIS_12_VCSCL
13 --------- 2LIS_13_VDHDR / 2LIS_13_VDITM
LO EXTRACTION STRUCTURE :
In ECC system :
1. Install the Data Source from Business Content ----> Use Tcode RSA5.
2. Maintain Extract Structure ( Transfer the Required colomns from ECC to Extract Structure) & Data Source ----- > Tcode : LBWE.
3. Fill Data To Setup Table ---- SBIW / 0LI*BW ------ > FULL / INIT.
4. Check the Extractor. Tcode : RSA3.
In SAP BW System :
5. Replicate and Activate the Data Source ----- Tcode : RSDS.
6. Create Info Package -----> Right click on Data Source-----> select Create Info Package.
7. Install the data Target from Business content.
8. Create Transformation
9. Create Data Transfer Process.