SAP FICO Configuration

00 SAP FI, 01 SAP CO, SAP 相关技术, 摘录及转帖文章 No Comments »

SAP FICO Module

Configuration -Primary configuration considerations:

Once a business has decided to use the SAP FI(Financial Accounting) Module, there are several Configurations prerequisite steps that must be completed.Determining the organizational structure is one of the first steps in setting up the business functions in SAP as well as your reporting requirements.

The Organizational structure is created by defining the organizational units consisting of the following:
Client
Company
Company Code
Business Area

Client is the highest unit within an SAP system and contains Master records and Tables. Data entered at this level are valid for all company code data and organizational structures allowing for data consistency. User access and authorizations are assigned to each client created. Users must specify which client they are working in at the point of logon to the SAP system.

Company is the unit to which your financial statements are created and can have one to many company codes assigned to it. A company is equivalent to your legal business organization. Consolidated financial statements are based on the company’s financial statements. Companies are defined in configuration and assigned to company codes. Each company code must use the same COA( Chart of Accounts) and Fiscal Year. Also note that local currency for the company can be different.

Company Codes are the smallest unit within your organizational structure and is used for internal and external reporting purposes. Company Codes are not optional within SAP and are required to be defined. Financial transactions are viewed at the company code level. Company Codes can be created for any business organization whether national or international. It is recommended that once a Company Code has been defined in Configuration with all the required settings then other company codes later created should be copied from the existing company code. You can then make changes as needed. This reduces repetitive input of information that does not change from company code to company code as well as eliminate the possibility of missed data input.

When defining company codes, the following key areas must be updated:
Company Code Key- identifies the company code and consists of four alpha-numeric characters. Master data and business transactions are created by this key.
Company Code Name- identifies the name of the business organization within your organizational structure.
Address- identifies the street address, city, state, zip code for the company code created. This information is also used on correspondence and reports.
Country- identifies the country to which your business is based. Country codes within SAP are based on ISO Standards.
Country currency- identifies the local currency for the company code that you have defined.
Language- identifies the language to be used for you company code and is also used for text in your documents. SAP unlike other applications, offers over thirty languages including EN( English) , ES (Spanish), FR (French), DE (German), EL (Greek), IT(Italian), AR( Arabic), ZH (Chinese) , SV (Swedish) , and JA (Japanese) to name a few.

More FI configuration considerations:

Business Area, COA, GL, Fiscal year and Currencies

Business Area is optional and is equivalent to a specific area of responsibility within your company or business segment. BA (Business Area) also allows for internal and external reporting.

Another configuration requirement for set-up in SAP are the Basic settings consisting of the following:
Chart of Accounts(COA)
Fiscal Year Variants.
Currencies

The COA(Chart of Accounts) lists all General Ledger accounts that are used by the organization. It is assigned in configuration to each company code and allows for daily General Ledger postings.

The General Ledger accounts are made up of such data as account number, company code, a description of the account , classification of whether the account is a P & L Statement Account or a Balance Sheet Account.

Control data of the GL Account is where currency is specified, Tax category (posting without tax allowed) , marking the account as a reconciliation account ( e.g. Customer, Asset, Vendors, Accounts Receivable) or not.
Marking the G/L Account as a “reconciliation” account allows for postings to an Asset Account ( for example) as well as automatic update to the G/L Account.

Configuration prevents direct postings to reconciliation accounts thereby assisting in maintaining integrity of the data.
This allows reconciliation between the sub-ledger and general ledger to always be guaranteed.
Within the General Ledger control data , you can also designate whether line item display is possible in the account. The system then stores an entry per line in an index table which links back to the account. (Display of line item details are then available for reporting purposes ,etc.)

Open Item Indicators can be set on the G/L Account allowing for better management of open items. Examples include: Bank Clearing Accounts, GR/IR Clearing Accounts, Payroll, etc.
Fiscal Year configuration is a must and can be defined to meet your company’s reporting periods whether Fiscal (any period combination that is not calendar) or Calendar( Jan-Dec).
Posting Periods are defined and assigned to the Fiscal Year.Within the periods you specify start dates and finished dates.
SAP allows for 12 posting periods along with specially defined periods that can be used for year-end financial closing.
Currencies are another basic configuration setting requirement which defines your company’s legal means of payment by country.
It is recommended that all Currency set-ups in SAP follow the ISO Standards.
The ISO Standards ensure Global conformity across businesses worldwide utilizing SAP.
Contents taken from SAP In Fico.

SAP相关各模块的关键集成点(2):PP与CO的关键集成点小析

01 SAP CO, 04 SAP PP, SAP 相关技术 No Comments »

Product Cost是PP与CO最主要也是最重要的集成点。 为了更好的联系起来理解Costing Run的前后台,我花了些时间整理出下面这个Flow Figure。

CO笔记:《100天学会SAP》

01 SAP CO, SAP 相关技术 1 Comment »

基本上来讲,《100天学会SAP》是一本入门的书,但是不同层次的人都可以从里面得到一些东西,因为它系统的介绍了SAP的几大模块的基本IMG设定和简单的前台操作。
我现在正在看CO部分,已经完成了一半了,感觉上CO的核心就是,首先是维护基础数据:成本要素、成本中心、作业类型,然后就是围绕着去做分配、分摊及内部订单。以期对于内部成本流进行准确的跟踪及监控。
就这点了,现在也只有这么多的领悟,先mark下来,以后应该会有更深入的了解。

ERP差异分析和分摊(转自SAP屠夫的博客)

00 SAP FI, 01 SAP CO, SAP 相关技术, 摘录及转帖文章 No Comments »
ERP差异来源和差异处理
只要成本模块采用标准成本,必定产生差异,差异分析的目的是找到管理漏洞,做到事中控制,可将ERP的差异来源分成以下几类:
1.物料移动发生的价差:
(a).MIGO PO收货时,采购价格和标准价格不同产生差异
(b).MIRO后勤发票检验时由于价格变更会产生差异
(c).物料转移过帐 311/309由于两边价格不一产生差异
(d).初始化库存差异,其它移动类型产生的差异
(e).来料加工等库存到自由库存产生差异
(f).退货时差异
2.发票价格差异和汇率差异:
发票校验由于价格变更会产生价格差异;跨期产生暂估和实际之差异;外币采购因为汇率变化引起的差异(SAP将收货到发票校验这段时间的汇率差异和材料差异同样处理,实际上,你也可将默认识的汇率差异直接也设置成材料采购差异, 而,
发票校验后产生的应付因汇率变化在期末外币重估时产生的差异则视为汇兑损益
)
3.重估库存和价格差异
MR21/MR22, CKMPRPN/CKME价格变更产生的差异,启动物料分类帐后,系统为了保持期间数据的一致,采用标准价的物料如果有交易一般不再允许修改单价。
4.生产成本结算差异
生产成本结算差异 = 生产成本投入-生产成本产出
在结算前,往往计算生产成本差异:
生产成本结算差异 = ( 生产成本投入-目标成本a) – (生产成本产出-目标成本b)
目标成本a (标准成本估算成本部件累计方) = 目标成本b (产品标准成本), 同一期内,产品的标准成本正是标准成本估算后
各成本部件的层层上卷累加,生成产本投入包括各成本部件的投入:原料辅料,人工机器折旧,通过实际生产成本的投入和目标成本a的比较,得到所谓的9种类差异类型,正好可以分析到所谓的直接材料成本差异(实际材料成本和标准成本a中的材料标准成本)和直接人工成本差异等,你可将系统默认的9种差异细分成你所需要的差异分析类别,这取决于你定义成本部件的明细程度,系统最多允许定义40个成本部件,你将这些成本对应到获利分析模的40个值字段,从而在差异计算后将实际成本部件传到获利分析,  实际上,财务模块并不反应这些差异明细, 只是才成本分析模块中体现, 这就是将财务和成本模块分开的好处避免产生一大堆垃圾财务凭证,  差异在向财务过帐时是以一个总的 生产成本结算差异过帐的,举一个简单实例,产品标准价968元/个, 其中原料950元,人工9元,折旧9元:
本期生产该产品10000个,  平时,原料以标准价投入了1000万(假设标准成本估原料是950万), 人工和机器折旧各以作业类型计划价的方式投入各10万(标准成本估算值为9万),产品以标准价收货910000个968万,期末结帐成本中心分配分摊作业实际价格重估重估工单一般就这些操作而已, 人工和机器折旧的实际价格各为12万,此时计算差异得到:
原料差异: 1000万 -  950 万 = 50万(由于多投入原料,产生50万数差)
人工差异:  12万(实际作业价)- 9万 = 3万(假设全为价差)
折旧差异: 12万(实际作业价)–9万=3万 (假设全为价差)
总共产生的实际生产成本投入为:1024万,借方!,这些类型差异反应在成本模块中,可以进行分析.
工单入库凭证为:
Dr:产品库存  968万
Cr:生产成本产出科目(Tcode:OBYC->GBB/AUF)  968万
总共产生的实际生产成本产出为:968万,贷方!
工单结算凭证为:
Dr:生产成本差异 56万(反应在物料分类帐中,CKM3可查看)
Cr :生产成本结算差异 56万(Tcode:OBYC->GBB/AUF)
生产成本结算差异 56万,贷方! 总的56万一笔反应在财务模块.
实际生产成本投入 =  实际生产成本产出 +  生产成本结算差异
如果你细心,就会发现,无论是原料还是产品,此时都还是标准成本,接下来可以使用物料分类帐将差异
分摊出去还原实际成本. 对产成品, 因为平时收发货都是标准成本,那么生产成本差异 56万将在销售发货和
期末库存间分摊, 对于原料同样采购差异在消耗和期末库存间分摊, 不同的是,原料的消耗是往上层层上卷到半成品和产品的,这就是所谓的”多层差异”, 如果BOM层次较多或象流程行业出现物料汇流的循环BOM,多层次差异就会耗费相当长的时间才能计算出.

如果仅仅从财务核算角度,国内ERP更愿意采用期末统一核算出成本,,但是这种”事后”核算的方式,外界评论是不能合理反应出”成本管理”的思想,不能作到事前预测,事中核算.

合理优化业务,避免物料分类帐运行时间过长
是在多层差异分配上,多层差异的产生的主要方式有3大类.
(1).跨工厂的转储301/302,比如产品从生产工厂到销售工厂使用301,则销售工厂到
生产工厂规定只能使用302,否则同期销售工厂到生产工厂也使用301,则多层差异分
配死循环,荆门不存在这种业务.
(2).物料309/310转移,经检查发现重污油309 68324006-》半沥青68324032使用了3
09,而半沥青68324032转回-》 重污油68324006也使用了309(原则上应该使用310),
也造成了死循环,  309/310物料转移的方式可以规范,尽量避免多层差异循环分配.
(3).产品回流循环BOM造成的循环,假设消耗A+B+C产出X,Y,Z, 而消耗X又产出A,则A
的多层消耗差异将分配到X作为接收方差异, X的消耗差异又转回A作为接受方差异,
A(X)的本期期初+接收差异又在A(X)的本期消耗和期末库存分配,这样就造成循环.

对于中间环节半成品过多的企业,如果半成品不需要进行库存管理或核算,可以考虑设置虚拟物料的方式.
一.规范309/310/311/312业务,坚决避免造成多层差异死循环.
二.优化循环BOM的结算规则,考虑将产量不多或核算无”精确”要求的造成循环回流
的联产品设置成副产品或固定价扣除,直接扣除生产成本,而不是参与生产成本的权
数分摊,避免多层差异分摊时循环!

SAP FICO Interview

00 SAP FI, 01 SAP CO, SAP 相关技术, 摘录及转帖文章 No Comments »
SAP FICO InterviewDaily how many tickets you are getting?
You can answer the number tickets/issues raised and routed to you for solution

In your career, have you face any critical ticket? What is that ? Can explain?
Explain any critical issue faced.

What is difference between company code & business area?
Company Code and Business area are the Organizational units in FI. But Company Code is a must where as Business area is optional. Company code is the Org. unit under which all the activities of the finance takes place where as the Bus. Area can cut across company codes.Company code is a legal entity and the books of accounts are maintained at this level.

What is enterprise structure of your client?
Explain the ES of your client, the structure of the company and the organizational units defined under the client

What is the use of “Relevant cash flow check box?
This check box in the GL account helps u to take the account for cash flow analysis

After run the depreciation. can you reverse of that transcation?
Yes, it is possible

While transcation entry you are given the cost center & internal order so, where it will be effected — both or one?
The posting goes to Internal Order and from there the settlement goes to the Cost Center. The Cost Center gets only the Statistical Posting. We can have any number of statistical Postings, but only one real posting to the CO object

Can you forward the controlling number ranges to next year?
Yes, we can continue the existing number ranges

What is valuation class ? Can you change the valuation class after transcation posting?
The materials are assigned to valuation class through the account determination happens

How many GR/IR a/c’s are created?
They are provision accounts, and the balance becomes zero after the completion of the cycle. This is done in order to care of the good /invoice received in advanceov vice versa

How many retained earning a/c’s are created?
Generally we have one retained earnings account. We can also have more than one also. This is usually done for having different financial statements based on the depreciation areas for tax, Costing etc.     *– Jaggu

What is the significance of Posting Key? (OB41)

Ans: Posting key is a two charecter numberical key, which controls the entry of line items. It specifies the accounting area to which an account belongs to. ex: Customer, Vendor or GL etc, It controls Field Satus (Supress, Recquired and Optional) It also controls its reverse posting key also.

In summary, the Posting Key has control functions within the line items. It controls:
i)  On which type of account the line item can be posted to
ii)  If the item is posted as a debit or credit
iii) The field status of additional  details

What is the use of Account Groups in GL?

Account Group Controls the Master records. It controls the number range of Master record and Field status group (Supress, Required, Optional and Display) also. SAP follows a Grouping principle all throughout SAP to handle the Master Records that may be in GL, AR AP any thing. See to create a GL Account group you define at OBD4 there itself you assign the Number Range or those groups which also controls Field Staus of GL Master Records. And for Creating AR and AP Master Records you create at OBD2 and Vendor at OBD3 which will also controls Field Status Group of And Number range of Master record. The only difference between GL and AR/AP is assigning of number range. For GL will specify at OBD4 itself but for AR/AP we need to create a number range at FBN1 then assign to AR And AP at OBD2 and OBD3 respectively.

One more thing. Remember only Field Status group of Master recard (OBD2, OBD3, OBD4) only contain Display option but not to Posting Key or Field Satus Group (OB41 or OBC4). I am so specifing becoz I commited this mistake in one interview.        *– Satish

In summary, the account group controls:
i) The number ranges of the accounts,
ii) The status of the fields in the company code segment of the master record.  Since a chart of accounts contains many different types of accounts, they can be bundled into different “account groups “. Usually one account group bundles
accounts with the same tasks within the general ledger, e. g. cash accounts, material accounts, asset accounts, profit and loss
accounts,…

Give a summary of Product Costing?

The purpose of Product costing planning is to arrive the total planned cost of the product. It is integrated with the following modules in arriving the Product cost and supplies the information to other modules
1. MM to arrive at the raw material and semifinished goods cost based on the price indicator in Material master record.
2. PP to arrive at the cost of Operations required for producing the Finished product with the planning based in Cost Center Accounting.
3. SD to pass the information of COGS to COPA based on the Value fields linked to condition types.

Two manfacturing scenarios are there in production one is Repetitive manfacturing (e.g Pharma industry) costing type is Product cost by period and Discreet manfacturing (Order based industry) costing type is Product cost by period.
*– Ratna

WP Theme & Icons by N.Design Studio
Entries RSS Comments RSS 登录