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
Important Tables in SAP CO
Controlling
Table Name Description Important FieldsAUSP Characteristic Values MANDT / OBJEK / ATINN / ATZHLCO-KBAS Overhead Cost Controlling A132 Price per Cost Center MANDT / KAPPL / KSCHL / KOKRS A136 Price per Controlling Area MANDT / KAPPL / KSCHL / KOKRS A137 Price per Country / Region MANDT / KAPPL / KSCHL / KOKRS COSC CO Objects: Assignment of Origina MANDT / OBJNR / SCTYP / VERSN CSSK Cost Center / Cost Element MANDT / VERSN / KOKRS / GJAHR CSSL Cost Center / Activity Type MANDT / KOKRS / KOSTL / LSTAR KAPS CO Period Locks MANDT / KOKRS / GJAHR / VERSN CO-KBASCORE Overhead Cost Controlling: General Services CSKA Cost Elements (Data Dependent on MANDT / KTOPL / KSTAR CSKB Cost Elements (Data Dependent on MANDT / KOKRS / KSTAR / DATBI CSKS Cost Center Master Data MANDT / KOKRS / KOSTL / DATBI CSLA Activity Master MANDT / KOKRS / LSTAR / DATBI
CO-OM (KACC) Overhead Cost Controlling COBK CO Object: Document Header MANDT / KOKRS / BELNR COEJ CO Object: Line Items (by Fiscal MANDT / KOKRS / BELNR / BUZEI COEJL CO Object: Line Items for Activit MANDT / KOKRS / BELNR / BUZEI COEJR CO Object: Line Items for SKF (by MANDT / KOKRS / BELNR / BUZEI COEJT CO Object: Line Items for Prices MANDT / KOKRS / BELNR / BUZEI COEP CO Object: Line Items (by Period) MANDT / KOKRS / BELNR / BUZEI COEPL CO Object: Line Items for Activit MANDT / KOKRS / BELNR / BUZEI COEPR CO Object: Line Items for SKF (by MANDT / KOKRS / BELNR / BUZEI COEPT CO Object: Line Items for Prices MANDT / KOKRS / BELNR / BUZEI COKA CO Object: Control Data for Cost MANDT / OBJNR / GJAHR / KSTAR COKL CO Object: Control Data for Activ MANDT / LEDNR / OBJNR / GJAHR COKP CO Object: Control Data for Prima MANDT / LEDNR / OBJNR / GJAHR COKR CO Object: Control Data for Stati MANDT / LEDNR / OBJNR / GJAHR COKS CO Object: Control Data for Secon MANDT / LEDNR / OBJNR / GJAHR
CO-OM-CEL (KKAL) Cost Element Accounting (Reconciliation Ledger) COFI01 Object Table for Reconciliation L MANDT / OBJNR COFI02 Transaction Dependent Fields for MANDT / OBJNR COFIP Single Plan Items for Reconciliat RCLNT / GL_SIRID COFIS Actual Line Items for Reconciliat RCLNT / GL_SIRID CO-OM-CCA Cost Center Accounting (Cost Accounting Planning RK-S) – What is RK-S A138 Price per Company Code MANDT / KAPPL / KSCHL / KOKRS A139 Price per Profit Center MANDT / KAPPL / KSCHL / KOKRS
CO-OM-OPA (KABR) Overhead Orders: Application Development R/3 Cost Accounting Settlement AUAA Settlement Document: Receiver Seg MANDT / BELNR / LFDNR AUAB Settlement Document: Distribution MANDT / BELNR / BUREG / LFDNR AUAI Settlement Rules per Depreciation MANDT / BELNR / LFDNR / AFABE AUAK Document Header for Settlement MANDT / BELNR AUAO Document Segment: CO Objects to b MANDT / BELNR / LFDNR AUAV Document Segment: Transactions MANDT / BELNR / LFDNR COBRA Settlement Rule for Order Settlem MANDT / OBJNR COBRB Distribution Rules Settlement Rul MANDT / OBJNR / BUREG / LFDNR
CO-OM-OPA (KAUF) Overhead Orders: Cost Accounting Orders AUFK Order Master Data MANDT / AUFNR AUFLAY0 Enttity Table: Order Layouts MANDT / LAYOUT
EC-PCA (KE1) Profit Center Accounting CEPC Profit Center Master Data Table MANDT / PRCTR / DATBI / KOKRS CEPCT Texts for Profit Center Master Da MANDT / SPRAS / PRCTR / DATBI CEPC_BUKRS Assignment of Profit Center to a MANDT / KOKRS / PRCTR / BUKRS GLPCA EC-PCA: Actual Line Items RCLNT / GL_SIRID GLPCC EC-PCA: Transaction Attributes MANDT / OBJNR GLPCO EC-PCA: Object Table for Account MANDT / OBJNR GLPCP EC-PCA: Plan Line Items RCLNT / GL_SIRID EC-PCA BS (KE1C) PCA Basic Settings: Customizing for Profit Center Accounting A141 Dependent on Material and Receive MANDT / KAPPL / KSCHL / KOKRS A142 Dependent on Material MANDT / KAPPL / KSCHL / WERKS A143 Dependent on Material Group MANDT / KAPPL / KSCHL / WERKS
Important Tables in SAP FI
Financial Accounting
Table Name Description Important FieldsFinancial AccountingFBAS Financial Accounting “Basis”
BKPF Accounting Document Header BUKRS / BELNR / GJAHR
BSEG Accounting Document Segment BUKRS / BELNR / GJAHR / BUZEI
BSIP Index for Vendor Validation of Double BUKRS / LIFNR / WAERS / BLDAT /
Documents XBLNR / WRBTR / BELNR / GJAHR / BUZEI
BVOR Inter Company Posting Procedure BVORG / BUKRS / GJAHR / BELNR
EBKPF Accounting Document Header (docs from GLSBK / BELNR / GJHAR / GLEBK
External Systems)
FRUN Run Date of a Program PRGID
KLPA Customer / Vendor Linking NKULI / NBUKR / NKOAR / PNTYP
/ VKULI / VBUKR / VKOAR
KNB4 Customer Payment History KUNNR / BUKRS
KNB5 Customer Master Dunning Data KUNNR / BUKRS / MABER
KNBK Customer Master Bank Details KUNNR / BANKS / BANKL / BANKN
KNC1 Customer Master Transaction Figures KUNNR / BUKRS / GJHAR
KNC3 Customer Master Special GL Transactions KUNNR / BUKRS / GJAHR / SHBKZ
Figures
LFB5 Vendor Master Dunning Data LIFNR / BUKRS / MABER
LFBK Vendor Master Bank Details LIFNR / BANKS / BANKL / BANKN
LFC1 Vendor Master Transaction Figures LIFNR / BUKRS / GJHAR
LFC3 Vendor Master Special GL Transactions LIFNR / BUKRS / GJHAR / SHBKZ
Figures
VBKPF Document Header for Document Parking AUSBK / BUKRS / BELNR / GJHARFBASCORE Financial Accounting General Services “Basis”KNB1 Customer Master (Company Code) KUNNR / BUKRS
LFA1 Vendor Master (General Section) LIFNR
LFB1 Vendor Master (company Code Section) LIFNR / BUKRS
SKA1 G/L Account Master (Chart of Accounts) KTOPL / SAKNR
SKAT G/L Account Master (Chart of Accounts – SPRAS / KTOPL / SAKNR
Description)
MAHNS Accounts Blocked by Dunning Selection KOART / BUKRS / KONKO / MABER
MHNK Dunning Data (Account Entries) LAUFD / LAUFI / KOART / BUKRS /
KUNNR / LIFNR / CPDKY / SKNRZE /
SMABER / SMAHSK / BUSABFI-GL-GL (FBS) General Ledger Accounting: Basic Functions- G/L AccountsSKAS G/L Account Master (Chart of Accounts – SPRAS / KTOPL / SAKNR / SCHLW
Key Word list)
SKB1 G/L Account Master (Company Code) BUKRS / SAKNR
FI-GL-GL (FBSC) General Ledger Accounting: Basic
Functions - R/3 Customizing for G/L Accounts
FIGLREP Settings for G/L Posting Reports MANDT
TSAKR Create G/L account with reference BUKRS / SAKNR
FI-GL-GL (FFE) General Ledger Accounting: Basic
Functions - Fast Data Entry
KOMU Account Assignment Templates for G/L KMNAM / KMZEI
Account itemsFI-AR-AR (FBD) Accounts Receivable: Basic Functions - Customers KNKA Customer Master Credit Management : KUNNR Central Data KNKK Customer Master Credit Management : KUNNR / KKBER Control Area Data KNKKF1 Credit Management : FI Status data LOGSYS / KUNNR / KKBER / REGUL RFRR Accounting Data – A/R and A/P RELID / SRTFD / SRTF2 Information System
FI-BL-PT Bank Accounting: Payment (BFIBL_CHECK_D) Transactions – General SectionsPAYR Payment Medium File ZBUKR / HBKID / HKTID / RZAWE /
CHECT
PCEC Pre-numbered Check ZBUKR / HBKID / HKTID / STAPLFI-BL-PT-AP(FMZA)Bank Accounting: Payment Transactions – Automatic Payments F111G Global Settings for Payment Program for MANDT Payment Requests FDZA Cash Management Line Items in Payment KEYNO Requests PAYRQ Payment Requests KEYNO
Subscribe to:
Posts (Atom)