How to Open Multiple Planning Areas on IBP Excel Add-on At The Same Time

Sometimes, different planning areas are created to facilitate different functionalities. But login and logout is quite a pain in the butt. Here’s how you can do it easily by opening up a new Excel instance.

For Opening Up another Excel Instance, Hold you ALT key, then click Excel (**remember to KEEP holding it until you see the window: "Do you want to start a new instance for excel?". After that you can release the ATL key)

Select Yes

Login

Check PA info

Repeat the same process and login to a different planning area

Enjoy!

Excel Formatting - Local Members

Local Member:

Some basic SAP Master Data tables in ECC

Object	Table Name	Description
Material Master	MARA	Basic data
	MAKT	Material description
	MVKE	Sales area
	MARC	Plant data
	MARD	Storage location
	MARM	All unit of measure data
	MBEW	Accounting
	MLAN	Tax
	MAPL	Assignment of Task Lists to Materials
	MKPF	Header: Material Document
	MSEG	Document Segment: Material
	MGEF	Hazardous Materials
BOM	MAST	Material to BOM Link
	STKO	BOM header data
	STPO	BOM item
	STAS	BOMs - Item Selection
Classes	KLAH	Class Header Data
	KLAT
	STXL	Data Lead
	KSML
	SWOR
Characteristics	CABN	Classification
	CABNT
	CAWN
	CAWNT
	AUSP	Characteristic Values
	KSSK	SAP Allocation Table: Object to Class Table and data
	MCHA	Batches
	MCH1	Batches (if Batch Management Cross-Plant)
PIR	EINA	Header Data
	EINE	Item data
Source list	EORD	Source list data
CMIR	KNMT	Customer Material Info record data
Ship Chain (Material Determination)	KONDD	Material Substitution - Data Division
	KONDDP	Conditions: Additional Materials for Material Determination
Inventory Movement	IKPF	Header: Physical Inventory Document
	ISEG	Physical Inventory Document Items
Production Versions	MKAL	Production Versions of Material
Purchase Requisition	EBAN	Purchase Requisition
Purchase Order	EKKO	Purchasing Document Header
	EKPO	Purchasing Document Item
	EKBE	History per Purchasing Document
Sales Order	VBAK	Sales Document: Header Data
	VBAP	Sales Document: Item Data
	LIKP	SD Document: Delivery Header Data
	LIPS	SD document: Delivery: Item data
	VBBE	Sales Requirements: Individual Records
	VBKD	Sales Document: Business Data
Vendor Master	LFA1	General data
	LFB1	Company Code data
	LFM1	Purchase org  data
	ADRC	Address Data
	ADR2	Vendor Telephone Numbers
	ADR4	Vendor Fax Numbers
	ADR6	Vendor Email-Addresses
	LFBK	Bank data
	LFB5	Dunning data
	LFAS	Vendor master (VAT registration numbers general section)
	LFBW	Vendor master record (withholding tax types) X
	WYT3	Partner Functions
	BKPF	Accounting Document Header
	BSEG	Accounting Document Segment
Customer Master	KNA1	General data
	KNB1	Company Code data
	KNVV	Sales area  data
	KNVP	Partner function data
	KNBK	Bank data
	KNVH	Hiearchy data
	KNVI	Tax data
	KNKK	Dunning data
	KNKA	Customer master credit management: Central data
	KNVK	Customer Master Contact Partner
	ADRC	Customer & Contact Person - Address Data
	ADR2	Customer & Contact Person - Telephone Numbers
	ADR4	Customer & Contact Person - Fax Numbers
	ADR6	Customer & Contact Person - Email-Addresses
	KNB5	Customer master (dunning data)
	BSID	Accounting: Secondary Index for Customers
	KNAS	Customer master (VAT registration numbers general section)
	VBRK	Billing Document: Header Data
Cost Centers	CSKS	Cost Center Master Data
	CSKT	cost center Texts
	CSSK	cost center /cost element
	CSSL	cost center/Activity Type
Cost Center Group / Hierarchy	CSKS
Profit Centers	CEPC	Profit Center Master Data Table
	CEPCT
	T005
	T002
	CEPC_BUKRS
Profit Center Group / Hierarchy	CEPC
G/L Account / Chart of Accounts	SKA1	G/L Account Master (Chart of Accounts)
	SKB1	G/L account master (company code)
Customer Hierarchy	KNVH	Customer Hierarchies
Asset Master	ANLA	Asset Master Record Segment
	ANLB	Asset Depreciation terms
	ANKA	Asset Classes
	ANKB	Asset Classes with dep area.
	ANLZ	Time-Dependent Asset Allocations
Asset Values	ANLC	Asset Value fields
	ANEP	Asset Line Items
Cost Elements	CSKA	Cost Elements (Data Dependent on Chart of Accounts)
	CSKB	Cost Elements (Data Dependent on Controlling Area)
	CSKU	cost Element Texts
Pricing conditions	KONH	Conditions (Header)
	KONP	Conditions (Item)
	A***	Pricing tables
WorkCenter	CRHD	Work Center Header
	CRCA	Work Center Capacity Allocation
	CRCO	Assignment of Work Center to Cost Center
Routings / Task List	PLKO	Task list - header
	PLPO	Task list - operation/activity
	PLAS	Task list - selection of operations/activities
Production Order	AUFK	Order master data
	AFPO	Order Item
	AFKO	Order Header Data PP Orders
Planned Order	PLAF	Planned Order
Cross Application	NAST	Message Status
Activity Price	CLSA	E1BPPLNHDR - CO Planning: Header Information (CSLA)
		E1BPACPOBJ - CO Planning: Objects (CSLA)
		E1BPACPCTRL - CO Planning: Control Values (CSLA)
	COEJT	E1BPACPTOT - CO Planning: Total Values 2 (COEJT)
		E1BPACPVAL - CO Planning: Total Values (COEJL)
Activity_Type_Group	CLSA	E1ACTIVITYTYPEGROUP_CREATE - Header Segment
		EIBPSET_HIER - Interface Structure for Groups - Hierarchy Table
		E1BP1115_VALUES - Activity Type Groups - Intervals in the Hierarchy
Activity_Type	CSLA	activity master
	CSLT	activity type texts
Additive Costs
Bank Master Data	BNKA	Bank master data
	BNKAIN	bank master (Additional Fields for BNKA)
	E1BANK_CREATE	E1BANK_CREATE-Header Segment
	E1BP1011_ADDRESS	E1BP1011_ADDRESS-Transfer structure object 1011: Bank address
	TIBAN	IBAN table