Few more Questions !

1. How many secondary indexes can be created on a single table as per SAP recommendation.

Maximum 4

2. System can derive _________ from _________ but not from __________ at runtime using automatic characteristic relationship in BI-IP.

0CALYEAR , 0CALQUARTER , 0CALWEEK



3.SAP Business Object can run in which of the mode.

Two Tier Mode + Three Tier Mode



4. XML based extraction is used for small volumes of data to BI.

5.

Few Questions ?

1. When Aggregates are created and filled which valuation statistics are generated ?

Summarized Record, Usage

2. Planning variables in Integrated Planning can be used in.

- Characteristics Relatioship and Data Slices

- Filter & Planning functions

-Input-ready Queries

3. We can delete the original excel spreadsheet after importing the data on the Xcelcius envurinment.

Order to Cash Data Model Design !

Table for Contract Line item: VBAP
Table for Contract Header : VBAK

There are two types of Contract Document:

Doc Type: ZCCR: Cost Reim/ Time and Material Contract
Doc Type: ZCFP: Fixed Price Contract

Contract Value is stored in “NETWR” field of VBAP table (i.e Contract Line item) and has “WBS Element” assigned to it. Field for “WBS Element” in VBAP table is “PS_PSP_PNR”

T-code: VA43 can be used to view contract document.

Double click on the contract Line item à Go to Account assignment tab for “WBS Element”
Go to “Conditions” tab for “Contract Value” i.e. “NETWR”
Double click on the contract Line item à Go to Account assignment tab for “WBS Element”
Go to “Conditions” tab for “Contract Value” i.e. “NETWR”
KSH3 & KCH3 are tcode to view pft ctr and cost cntr hierarchy.

SAP Enterprise Performance Management - Some notes

FPM 7.5 :
-> SAP Strategy Management andBPC integration to BOBJ BI Toolsand BOBJ Enterprise.
->All three Consolidation solutions(BPC, BCS & BOBJ-Fin Cons) getenhancements and maintenance.
->BOBJ-Fin Cons and BOBJProfitability& Cost ManagementIntegration to SAP NetWeaver BIEDW.
-> IDD/BOE Integration for BOBJProfitability& Cost Management, BOBJ- Fin Consolidation.

Features of FPM 8.0 :
-> Unified, Highly usable FPM end-user & Authorising Environment
-> Unified Masterdata, Business Rules, Metadata for all applications
-> Unified workflow & process orcheastration across the suite.

Interesting to see how SAP BPC gets integrated with SAP BOBJ tools, more info will follow soon.