Friday, July 12, 2019

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



















Select Yes
Login










Check PA info


















Repeat the same process and login to a different planning area


















Enjoy!

Tuesday, June 25, 2019

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