Sunday, June 29, 2014

Big Data - Fundamentals

Big data is a term coined from past 4 years in the media.

Big data is basically the data sets which is too huge for traditional softwares to capture, process in a reasonable amount of time.



The size of this data sets is continually growing and it is in PB (Petabytes) now.

Emeet O Ryen writes in Dice.com

" Among the challenges of implementing solutions: capturing, storing, searching, sharing, analyzing and visualizing such data sets.
As a long time computer scientist in the area of information management, I see the term “Big Data” as a marketing label. It attempts to quantify all that is done in the Distributed Computing or High Performance Computing space, and make the results available to the Data Scientist or Information Analyst so that answers to questions can be formulated in timely manner."

So Big data is:

Capturing data from traditional and non traditional datasources, joining, transforming and processing it so that there is some kind of correlation between the different types that results in a single larger data set.
reducing the larger set to the representative of the whole. 
extracting the information that is relevant and applying the statistical analysis to it.
Visualizing the data and resulting information, so that trends can be determined and decisions made. 

A Competitive Advantage

Many businesses and organizations use Big Data to gain a competitive edge from the resulting business analytics — provided that they ask the right questions, have data sources that provide the right information and, of course, use the right statistical and analytical tools to interpret the answers they get.
These same businesses and organizations use Big Data to make timely strategic and tactical decisions. Instead of just relying on process or instinct, Big Data tools provide them with additional information to consider in making informed decisions.

The Technology

So is Big Data new? No, not really.  Distributed Computing or HPC has been around for well over 20 years. It’s just that never before have you used these HPC techniques and infrastructure on these different types of data sets, nor have you had to answer such business domain related questions. HPC has been the domain of scientists to do physics, biological and chemical analysis, simulations and experimentation where massive amounts of data are available.
The technology and infrastructure here is somewhat unique from HPC of even ten years ago. Today, low cost commodity servers or cloud computing infrastructures can be used for Big Data hardware platforms. As for software, key to a Big Data environment are Apache Hadoop/MapReduce and its associated tools, the use of NoSQL data bases, some means of doing basic analytics on data that’s to be processed, and a means of visualizing the results of the analytics.
There are now a wide variety of NoSQL data bases available, like MongoDB, Cassandra  and others. As for basic analytics, quite often Hadoop/MapReduce’s associated tools can do the trick. When it comes to advanced analytics, tools like R Project, SAS and other statistical packages can be used, though quite often an integration effort is needed to make them work.
Visualization of the data ingested and the resulting analytic results appears to be a wide open area with many vendors claiming dominance in one area or another.

Tuesday, June 24, 2014

BI Tools in the market

In today's fast changing business world, Business Intelligence is the need of every organization small or big. Data accuracy, Data discovery, Data integration, Information management, Data Transformations Analytics, Adhoc reporting, Formatted reporting, FI consolidation, Operational reporting, Methodoligies and best practices implementation, score carding are the subjects relevant to BI. 


Here are the tools which are available in market which serves end to end BI solutions. It is interesting to know that almost all have connectors to pull data from SAP. 


Oracle BI Enterprise Server 11.1.1.6
Oracle Hyperion System 9
SAP BusinessObjects Enterprise XI 4.0/FP3
SAP NetWeaver BI (+HANA) 7.3
Microsoft BI platform 2013
Information Builders WebFOCUS 8.01
Style Intelligence 11.5
Yellowfin BI 7.0
Pentaho BI Suite 5.0







IBM Cognos Series 10.2.1
SAS Enterprise BI Server 4.4
Board Management IntelligenceToolkit 8.1
MicroStrategy 9.4.1
QlikView 11.2
BizzScore Suite 7.4
JasperSoft 5.5
Tableau Software 8.1.5

Tuesday, June 17, 2014

ROOSOURCE table in SAP

ROOSOURCE table in SAP provides you detail information of each of the standard datasource irrespective of whether it is active.

Here you can check the following

1. whether delta is applicable
2. If yes, what is the delta method.

The following delta process are available. this is import to decide on the datatargets to use in the BW side.

BLANK     Delta Only Via Full Upload (ODS or InfoPackage Selection)
A    ALE Update Pointer (Master Data)
ABR  Complete Delta with Deletion Flag Via Delta Queue(Cube-Comp)
ABR1 Like Method 'ABR' But Serialization Only by Requests
ADD  Additive Extraction Via Extracto (e.g. LIS Info Structures)
ADDD Like 'ADD' But Via Delta Queue (Cube-Compatible)
AIE  After-Images Via Extractor (FI-GL/AP/AR)
AIED After-Images with Deletion Flag Via Extractor (FI-GL/AP/AR)
AIM  After-Images Via Delta Queue (e.g. FI-AP/AR)
AIMD After-Images with Deletion Flag Via Delta Queue (e.g. BtB)
CUBE InfoCube Extraction
D    Unspecific Delta Via Delta Queue (Not ODS-Compatible)
E    Unspecific Delta Via Extractor (Not ODS-Compatible)
FIL0 Delta Via File Import with After-Images
FIL1 Delta Via File Import with Delta Images
NEWD Only New Records (Inserts) Via Delta Queue (Cube-Compatible)
NEWE Only New Records (Inserts) Via Extractor (Cube-Compatible)
O
ODS  ODS Extraction
X    Delta Unspecified (Do Not Use!)



Further, you can find the
extract structure name,
extractor program,
delta specific field for datasource,
lower safety interval for delta selection
upper safety interval for delta selection

A good undersanding of this table is important to have better understanding of datasources and its usage in SAP BW.

When to use 0FI_GL_10 and 0FI_GL_14



Use 0FI_GL_14:


0FI_GL_14 provides you detail level information of account number at day level. (ie posting date). All line items in fbl3n can be reported.

Daily debit and credit and balance for the period selected can be reported in local and foreign currency. 

Mainly applicable for Expense line items(P&L line items).

Uses AIED delta method so DSO is required. Install 0FIGL_O14 DSO.



Use 0FI_GL_10:

Provides you cumulative balance at posting period level. 

Relevant report in ECC is S_PL0_86000030.

Mainly used to report Balance sheet line items where cumulative balance is to be reported. For eg, Fixed assets, current assets and current liabilities G/L accounts.

Uses AIE delta method so DSO is required. Install 0FIGL_O10 DSO.


Alternately 0FI_GL_12 can also be used. But cumulative balance have to be calculated using start routine in 
transformation rule from datasource to cube. No Need of DSO as it works on ADDD(additive delta method) so cube directly loaded. 

Thursday, June 12, 2014

ECC tables Module wise

ECC Tables:

MM MODULE

CYCLE:
Purchase Requisition (PR) Request for Quotation (RFQ) (Vendor Evaluation)
Purchase Order (PO) Goods Receipt Note (GRN) Invoice Verification Data to FI

Tables and important Fields.

LFA1 – vendor data (LIFNR)
LFB1 -- Company Code Segment : Vendor Data(LIFNR, BUKRS)
LFC1 -- FI Related Vendor Data (LIFNR, BELNR)
LFM1 – Pur. Orgn. Related Vendor Data (LIFNR, EKORG)

MARA – Material Master (MATNR)
MARC – Material Master with Plant Data (MATNR, WERKS)
MARD – Material Master with Storage Location Data (MATNR, LGORT, WERKS)
MAKT – Material Master Material Descriptions (MATNR, MATKL)
MBEW – Material Valuation Data (MATNR, BWTAR)
MVKE – Material Master : Sales related Data
MDKP, MDTB – MRP related Data( Header, Item)
MCHA, MCHB – Material Batches (Header, Item) (MATNR, WERKS, LGORT, CHARG)

EBAN – Pur. Req. Data( BANFN, BNFPO, BADAT, MATNR)
EINA – Purchase Info. Record(General Data)(INFNR, MATNR, LIFNR)
EINE – Purchase Info. Record (pur. Orgn. Data) (INFNR, EKORG)
ELBK, ELBN, ELBP – Vendor Evaluation Related Data
EKKO – PO Data (Header) (EBELN, BSTYP, BSART)
EKPO – PO Data (Item) (EBELN, EBELP, MATNR)
Pur. Req., RFQ and PO are differentiated by Doc Type (BSTYP) in EKKO table.
For RFQ it is ‘A’ and for PO it is ‘F’
MKPF – GRN Data (Header) (EBELN, BLDAT, BUDAT, XBLNR, BKTXT)
MSEG – GRN Data(Item) MBLNR, BWART, LIFNR, MATNR, EBELN)
Apart from this there are lot of tables which begin with ‘M’ & ‘E’, but we
use the following very often.
EQUK – Quota (Header)(QUNUM, MATNR)
EQUP – Quota (Item) (QUNUM, QUPOS, LIFNR)
EKBE – PO History Data (EBELN, EBELP, BELNR, BLDAT, MATNR, VGABE)
EKBZ – PO History with Delivery Costs(EBELN, BELNR, LIFNR, XBLNR)
EKET – Schedule lines data of a PO(EBELN, EINDT, SLFDT)
EKES – Vendor Confirmations Data (EBELN, EBTYP, EINDT, XBLNR)
T163F – Confirmation Texts (EBTYP, EBTXT)
T156 – Movement Types (BWARE)
T024 – Purchasing Groups
T024E – Purchase Organizations
T163 – Item Category’s in Purchasing Documents(PSTYP)
T149D – Valuation Types
T134 – Material Types
FVLK – Delivery Types
STKO, STPO – BOM(Bill Of Material) related Data (Header & Item)
STPU, STPN, STST, STZU – BOM Related Tables
RKPF, RBKP, RSEG (Header & Item) – MM – FI Related Data
KONO, KONH – Pricing data
T006 – Basic Unit Of Measurements


SALES & DISTRIBUTION MODULE RELATED TABLES :

Cycle:
Enquiry  Quotation  Sales Order  Delivery(Picking, Packing, Post Goods Issue and Shipment)  Billing  Data to FI.

TABLES and Important Fields :
VBAK : Sales Document(Header Data) (VBELN)
VBAP : Sales Document(Item Data) (VBELN, POSNR, MATNR, ARKTX, CHARG)
Enquiry, Quotation, Sales Order are differentiated based on Doc.
Type(VBTYP Field) in VBAK, VBAP Tables for Enquiry VBTYP = A, for Quotation ‘B’ & for Order it is ‘C’.)
LIKP : Delivery Table(Header Data) (VBELN, LFART, KUNNR, WADAT, INCOL)
LIPS : Delivery Table(Item Data)(VBELN, POSNR, WERKS, LGORT, MATNR, VGBEL)
(LIPS – VBGELN = VBAK- VBELN, LIPS-VGPOS = VBAP-POSNR)
VTTK : Shipment Table(Header Data) (TKNUM)
VTTP : Shipment Table (Item Data)(TKNUM, TPNUM, VBELN)
(VTTP – VBELN = LIKP – VBELN)
VBRK : Billing Table(Header Data) (VBELN, FKART, BELNF)
VBRP : Billing Table(Item Data) (VBELN, POSNR, FKIMG, NEWR, VGBEL, VGPOS)
(VERP – AUBEL = VBAK- VBELN, VBRP – VBEL = LIKP – VBELN)
Apart from these tables there are lot of other tables which starts with ‘V’, but we use the
following tables frequently.
VBUK: All Sales Documents status & Admn. Data(Header) (VBELN, VBTYP)
VBTYP = ‘C’ (Sales Order) VBTYP = ‘L’(Delivery) VBTYP = ‘M’(Invoice)
VBUP: Sales Documents status & Admin. Data(Item) (VBELN, POSNR)
VBEP : Sales Document Schedule Lines Data (VBELN, POSNR, EDATU, WMENG)
VBKD: To get sales related Business data like Payment terms etc.(VBELN, ZTERM)
VBFA: Sales Document flow data(VBELV, VBELN, POSNV, VBTYP)
VBPA: Partner functions Data(VBELN, PARVW, KUNNR, LIFNR)
TVLKT: Delivery Type: Texts(LFART, VTEXT)
KNA1, KNB1, KNC1 : Customer Master Data and Other Partner’s Data(KUNNR,
NAME1,LAND1)
KNVK: Customer Master Contact Person(PARNR, KUNNR)
KNVV: Customer Master Sales Data.
LFA1, LFB1, LFC1: Vendor Master Data(To get Transporter data)(LIFNR, NAME1, ORT01)
MARA, MARC, MARD : Material Master Data(Basic, Plant, St. Location Views)
TVKO: Sales Organizations(VKORG)
TVKOV: Distribution Channels(VTWEG)
TVTA: Divisions(SPART)
TVKBZ: Sales Office(VKBUR)
TVBVK: Sales Group(VKGRP)
T077D: Customer Account Group(KTOKD)
T001W: Plants(WERKS)
T001L: Storage Locations(LGORT)
TWLAD: To get address of Storage Location and Plant(LGORT, ADRNR)
TVAU: Sales Document (Order) Types
KONV: Condition Types (pricing) (KNUMV, KSCHL, KWETR)
T685T: Condition Types Texts.
ADRC: To get Addresses of Partners
VBBE, VBBS: Sales Requirements Data
VBKA: Sales Activities Data
VBPV: Sales Document Product Proposal

PP & PM Module

AFKO: PP Order Header Data
AFPO: PP Order Item Data
AFVV: Order Operations Data Qty/Date/Values
AFVC: Operations within an Order
AFRU: Order Completion Confirmation
CSLA: Activity Types Master Data
CSLT: Activity Types Texts
KAKO: Capacity Header Segment
CRHD: Work Center Header Data
AUFK: Order Master Data
AFIH: Maintenance Order Header
AUFM: Goods Movement For Order
EQUI: Equipment Master Data
EQKT: Equipment Texts
ILOA: PM Object Location
T024I: Maintenance Planner Groups
T357: Plant Section
IFLO: Functional Location Text
IHSG: Permits in PM
IHGNS: Permit segment in PM
T357G_T: Permit Text
RESB: Reservation / Dependent requirement
V_EQUI: View for Equipment description
VIAUFKS: View for Order and Equipment Data
CAVFVD: Work Center Text.
VIQMEL: Notification Header View
VIQMFEL: PM Notification View
VIQMMA, VIQMSM : Views for Activities and Tasks


FI/CO Module

T001: Company Codes
T002: Language Keys
T003: FI Document Types
T004: Chart Of Accounts
T005: Country Keys
T007A: Tax Keys
T012: House Banks
TKA01: Controlling Areas
SKA1, SKB1: G/L Account Master data
SKAT : G/L Accounts Texts
KNBK: Customer Master(Bank Details)
LFBK: Vendor Master (Bank Details)
BKPF: Accounting Doc. Header
BSEG: Accounting Doc. Item(Cluster Table)
BSIS: G/L Open Items
BSAS: G/L Closed Items
BSID: Customer Open Items(Account Receivables)
BSAD: Customer Closed Items)(Account Receivables)
BSIK: Vendor Open Items(Account Payables)
BSAK: Vendor Closed Items(Account Payables)
BKPF and BSEG Tables consists of data from BSIS, BSAS, BSID, BSAD, BSIK, and BSAK tables.
BSET: Tax Information
BSEC: One Time Vendor Records
CSKS: Cost Center Master
CSKT: Cost Center Texts
CSSK: Cost Center/ Cost Element Relations
GLPCA: EC-PCA: Actual Line Items
GLPCT: EC-PCA: Totals Table
COEP: Co-Object Line Items by Period
COST: Co-Object Price Totals
CSSL: Cost Center- Activity Type
CRCO: Work Center- Cost Center Assignment
CSLA: Activity Types Master(LSTAR)
CSKB: Cost Elements(KSTAR, KOKRS)
COSS: Cost Totals(OBJNR, KSTAR)
COBL: Coding Block
CEPC: Profit Center Master Data
BNKA: Master Records of banks
TBSL: Posting Keys
KEKO: Product Costing Header Data
ANLH: Main Asset Number
ANLA, ANLB, ANLC : Segment Assets Masters

Wednesday, June 11, 2014

SAP BW tcodes

Here is the list of all tcodes in SAP relevant to SAP BW in which I have worked during analysis and development project.

rsa1 - adminsitration workbench
rsds - replicate datsources
rsmo - monitor process chains
rsrt - query monitor
rspc - create process chains
cmod - enhancement of datsources (both bw and ECC replicated)
rsanwb - analysis process designer
rsrv - anlayse bw objects
rsdbc - DB conncet datasources list
rsa8 - BW datasources
al11- application server
listcube - display cube contents
se24 - class builder (eg: CL_RSTRAN_STAT)

SAP tcodes - BW relevant

Here is the list of all tcodes in SAP relevant to SAP BW in which I have worked during analysis and development project.


rsa5 - install datsources
rsa6  - Display installed datasources
rso2 - generic datasource - display/create
rsa7 - Delta queue moniter
rsa3 - extractor checker
lbwe - LO cockpit
oli*bw - FIlling LO datasources - setuptables (* indicates application number )
cmod - Enhancement of datasource with new fields
se18 - BADI initial definitions
se19 - BADI Intial screen for implementation
se37 - Funciton module (new/display/change)
se38 - ABAP program (new/display/change)
se03  - Transport organizer tools
se10/se11 - Transport organizer
se11/12/se16 - View tables/views
se14 - DB utility
se80- ABAP workbench
sm12 - Lock/Unlock objects
sm21 - system log
st22 - short dump
sm51 - list of servers
sm66 -  global process overview
sm50 - process overview
rsd1 - characteristics maintenance

FAGLBW03 - Assignment of FI datasources with Ledger
OMSL - Material number format details.





SAP tcodes - business relevant

Listing here all the SAP tcodes I have worked explored during analysis and development projects.

FI

fbl3n - view FI document line item
fs10n - view cumulative balance (carry forwarded) for Account number(G/L)


MM

MB51  - Material document list(movements)
MB5B  - Material wise opening and closing balance
MC.9 - As on date inventory


Production

CA03-   View Routing data

BOM

cs03 - BOM explosion
cs13 - Summarized BOM
CS11 -Exploded BOM level by level
CS15 - where used list of materials
CS12 - Multilevel BOM


MM03 - Material master - Display


CK13n - Cost estimate for Materials(product costing)

SAP Tables



Listing here all the tables in which i have worked, explored during analysis and developmental projects.


SD- sales

VBAK - Sales Header
VBAP - Sales Line items
 VBEP - Sales Schedule line item

SD-Billing

VBRK - Billing Header
VBRP - Billing Line items

SD - Delivery

LIKP - Deliver header
LIPS  - Delivery items

FI - GL

FAGLGLEXA  - Gl line item tables
FAGLFLEXT - GL balance totals table
BSEG - Accounting document segment
BKPF - Accounting document header

BOM

MAST - Material to BOM Link
STKO - BOM header
STPO - BOM Item

Production - Routing

MAPL - Task list to Materials assignment
PLKO - Task List header
PLPO - Task list Item



Excise

J_1IEXCDTL - Excise invoice line item details.


Material

MARA - General Material Data
MARM - UOM for Materials
MARC - Plant data for Materials