LO Cockpit provides single point to enhance, schedule, extract and transfer logistics data from SAP source system (SAP R/3 / SAP ECC) to SAP BW system.
The cockpit displays various extract structures grouped by various application areas as shown in the figure below.
The transaction code to access the LO Cockpit is LBWE.
The following are the steps to extract LO data using the Cockpit.
- Activate the relevant DataSource.
- Replicate DataSource in BW
- Hook up the DataSource to corresponding InfoSource in BW
- Maintain the Extract Structure
- Activate the Extract Structure
- Delete the contents of the setup tables by running Tcode LBWG
- Run the setup job for relevant extractor
- Schedule delta initial load from BW system
- Select desired update method (V3) for the DataSource.
- Start executing the delta loads.
Sales and Distribution: Table Description Customers KNA1 General Data KNB1 Customer Master – Co. Code Data (payment method, reconciliation acct) KNB4 Customer Payment History KNB5 Customer Master – Dunning info KNBK Customer Master Bank Data KNKA Customer Master Credit Mgmt. KNKK Customer Master Credit Control Area Data (credit limits) KNVV Sales Area Data (terms, order probability) KNVI Customer Master Tax Indicator KNVP Partner Function key KNVD Output type KNVS Customer Master Ship Data KLPA Customer/Vendor Link Sales Documents VBAKUK VBAK + VBUK VBUK Header Status and Administrative Data VBAK Sales Document - Header Data VBKD Sales Document - Business Data VBUP Item Status VBAP Sales Document - Item Data VBPA Partners VBFA Document Flow VBEP Sales Document Schedule Line VBBE Sales Requirements: Individual Records SD Delivery DocumeLIPS Delivery Document item data, includes referencing PO LIKP Delivery Document Header data Billing Document VBRK Billing Document Header VBRP Billing Document Item SD Shipping Unit VEKP Shipping Unit Item (Content) VEPO Shipping Unit Header
I-AA-AA (AA) Asset Accounting: Basic Functions – Master Data ANKA Asset Classes: General Data ANLKL ANKP Asset Classes: Fld Cont Dpndnt on Chart ANLKL / AFAPL of Depreciation ANKT Asset Classes: Description SPRAS / ANLKL ANKV Asset Classes: Insurance Types ANLKL / VRSLFD ANLA Asset Master Record Segment BUKRS / ANLN1 / ANLN2 ANLB Depreciation Terms BUKRS / ANLN1 / ANLN2 / AFABE / BDATU ANLT Asset Texts SPRAS / BUKRS / ANLN1 / ANLN2 ANLU Asset Master Record User Fields .INCLUDE / BUKRS / ANLN1 / ANLN2 ANLW Insurable Values (Year Dependent) BUKRS / ANLN1 / ANLN2 / VRSLFD / GJAHR ANLX Asset Master Record Segment BUKRS / ANLN1 / ANLN2 ANLZ Time Dependent Asset Allocations BUKRS / ANLN1 / ANLN2 / BDATU