BW-based BCS: Random notes

Text Body:
Had some old notes for SEM-BCS the BW based version - thought of sharing it with everyone.. SEM BCS ODS allow to capture the granular details for the transactions. Run listing in the Cons Monitor instead of the infocube RMC Manage Flat file or manual – two ways to load data into BCS - even have to convert the SAP R/3 data into a flat file and upload it. (auto will come in 4.0) GLPCT table populates ODS – is the source of the legal and managerial cons Version = actual Valuation method = US GAAP, Canadian GAAP, IFRS Accrued values can also be stored as statistical items and made available for reporting Legal and management cons units are stored in different hierarchies. There are two kinds of Infoproviders – Data Targets (Transaction ODS) and Non Data Targets (Virtual Cubes) 0CS_ITEM does not have any attributes unlike 0ACCOUNT Anything starting with 0 is standard business content Something with 3rd party icon is a virtual cube Cons group is only in BW and not in R/3 0COMPANY = Cons Unit = Group Company we have a functional module written for the virtual cube (w-services) Manual Data Entry Reported Financial data can be entered manually in SEM-BCS using data entry layouts Data entry can be cumulative or periodic and be specified by layout. If the reported financial values have been saved in the T-cube using flexible upload – these can be processed manually afterwards using the data entry layouts (use posting level 00). Validations Assets = Liabs + SE B/S RE = I/S Annual Net Income. Message maintenance is in SE91. System can also reconcile financial data in ODS with the data in the totals cube in the same task. Like reconciling inventory data for elim of IU profit in the transferred inventory and checking values from investment ODS and capital ODS with corresponding values in the totals cube. Totals cube is populated by Manual Entries and Flex Upload. BCS journal entries (Cons Entries) are entered in the Trans ODS and goes to T-Cube at a summarized level. Currency Translation
Transaction Type isolates the opening balance @ historical rate, current rate or spot rate. The transaction type could be Opening Balance, Acquisition, Depreciation, Write Down, Transfer. Enables translation of financial data reported by cons unit from local currency to group currency. Can assign a curr translation method for each cons unit by time and version. So could have two different currency translation for planning and actuals for one company code.. or have a different method for 2004 and 2005. The type of curr translation depends on relationships between the corporate grp and the individual consolidation units (functional curr) – for US GAAP its dictated by FASB 52. Can define any of the standard curr translation methods for the Chart of Accounts .. eg: temporal, current rate. B/S and I/S item types are translated with different translation keys and exchange rates. Exchange rate Indicator – you can build in the version in its number code as well as the exchange rate indicator – like current, average, historical. Exchange rate Type – current, average, historical. Exchange Rate tables are maintained in R/3 and brought over. Need to make sure ALL the tables come in – the exchange rate types and ratios too. Translation key on B/S is cumulative and on I/S is periodic. Equity values are translated using historical rates under IAS, US GAAP, and German HGB. Reclassifications and Allocations We can use reclassification to transfer entries from one item to another. The triggering and source item can be same or different. Can be used to standardize entries reported by cons units or reclassify data that is already consolidated. Can reclassify periodic or the cumulative value (YTD). Can reclassify only a percentage of the value or the entire value. InterUnit Elimination Posting level is 20. In the method the Cons Unit is not mentioned that is gotten from the Trading partner field. Elimination entries are always two sided. Data needs to be reported with partner assignment for two sided elimination or the IU elim would not work. If the cons units report their original amounts in transaction currency – then you can split the differences on the differences tab while creating the Method. When the currency type is entered on the fly translation of local currency values to group currency happens . One sided elimination may be used in case where the sales revenue is eliminated against COGM