SAP BI/BW Notes
Sap BI/BW and Business Objects Tips and Tricks
TCODES for SAP BI/BW
LO CockPit - How To
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.
LO Cockpit |
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.
Important Tables for SAP MM
Below are few important Common Tables used in Materials Management Modules:
EINA Purchasing Info Record- General Data EINE Purchasing Info Record- Purchasing Organization Data MAKT Material Descriptions MARA General Material Data MARC Plant Data for Material MARD Storage Location Data for Material MAST Material to BOM Link MBEW Material Valuation MKPF Header- Material Document MSEG Document Segment- Material MVER Material Consumption MVKE Sales Data for materials RKPF Document Header- Reservation T023 Mat. groups T024 Purchasing Groups T156 Movement Type T157H Help Texts for Movement Types MOFF Lists what views have not been created A501 Plant/Material EBAN Purchase Requisition EBKN Purchase Requisition Account Assignment EKAB Release Documentation EKBE History per Purchasing Document EKET Scheduling Agreement Schedule Lines EKKN Account Assignment in Purchasing Document EKKO Purchasing Document Header EKPO Purchasing Document Item IKPF Header- Physical Inventory Document ISEG Physical Inventory Document Items LFA1 Vendor Master (General section) LFB1 Vendor Master (Company Code) NRIV Number range intervals RESB Reservation/dependent requirements T161T Texts for Purchasing Document Types
Following are the list of Important MM tables. Inventory Management: |-------------------------+--------+-----------------------------------------| | | Table | Description | |-------------------------+--------+-----------------------------------------| | Material | MSEG | Material document / transaction details | | Document/Movements | MKPF | Material document header information | |-------------------------+--------+-----------------------------------------| | Material Stock Balances | MARD | Material stock | | | MBEW | Material stock with valuation | |-------------------------+--------+-----------------------------------------| | Sales Order Stock | MSKA | Stock balance with associated sales | | | | order data | |-------------------------+--------+-----------------------------------------| | Stock Transport | EKUB | Index for Stock Transport Orders for | | | MDUB | Material | | | | Reading View of Stock Transport Ord. for| | | | Release Ord. | |-------------------------+--------+-----------------------------------------| | Special Stocks | MKOL | Consignment, material provided to | | | | vendor, etc. | |-------------------------+--------+-----------------------------------------| Material Master Data: |-------------------------+---------+--------------------------------------| | |Table | Description | |-------------------------+---------+--------------------------------------| | Materials | MARA | General Data, material type, group, | | | | configurable & batch ind. | | | MAKT | Short Texts, descriptions | | | MARM | Conversion Factors | | | MVKE | Sales Org, distribution channel | | | MLAN | Sales data, tax indicator, tax | | | MARC | classification | | | MBEW | Plant Planning Data | | | MLGN | Valuation Data | | | MLGT | Warehouse Management Inventory Data | | | MVER | Warehouse Management Storage Type | | | MAPR | Data | | | MARD | Consumption Data | | | MCHA | Pointer for Forecast Data | | | MCHB | Storage location data with stock | | | | balances | | | | Batches | | | | Batch Stocks | |-------------------------+---------+--------------------------------------|
Important Tables for SAP SD
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
Important Tables in SAP AA
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
FI-AA-AA (AA2) Asset Accounting: Basic Functions – Master Data 2.0 ANAR Asset Types ANLAR ANAT Asset Type Text SPRAS / ANLAR FI-AA-AA (AB) Asset Accounting: Basic Functions – Asset Accounting ANEK Document Header Asset Posting BUKRS / ANLN1 / ANLN2 / GJAHR / LNRAN ANEP Asset Line Items BUKRS / ANLN1 / ANLN2 / GJAHR / LNRAN / AFABE ANEV Asset Downpymt Settlement BUKRS / ANLN1 / ANLN2 / GJAHR / LNRANS ANKB Asset Class: Depreciation Area ANLKL / AFAPL / AFABE / BDATU ANLC Asset value Fields BUKRS / ANLN1 / ANLN2 / GJAHR / AFABE ANLH Main Asset Number BUKRS / ANLN1 ANLP Asset Periodic Values BUKRS / GJAHR / PERAF / AFBNR / ANLN1 / ANLN2 / AFABER
FI-SL-VSR (GVAL) Special Purpose Ledger: Validation, Substitution and Rules GB03 Validation / Substitution User VALUSER GB92 Substitutions SUBSTID GB93 Validation VALID
Subscribe to:
Posts (Atom)