存档

‘SAP 相关技术’ 分类的存档

[转]SAP一句话入门:Material Management

2008年4月26日 没有评论

让我们来关注供应链上的另一个模块Material Management,即MM、物料管理。从SAP对其定义的范畴来看,它处在供应链的上中游。而广义的物料(物资或物品,是英文Material的翻译,下同)管理关注的范围则可能更多。延续上一篇的叙述风格,下面我尽量用浅显直白的语言对SAP的MM模块做一个介绍。

物料(Material)的含义极广,任何看得见看不见的东西几乎都可以称之为物料。在SAP中,将重点关注用来直接或间接为企业增值的物品,如原材料、半成品、成品、水、电、蒸汽、空气、设备、仪器仪表等等。同时,也可以把用于销售的、非物质形态的“服务”作为物料来管理。

我们将这些实物或者非实物的东西纳入物料管理,为其编码、分类、收集并记录它们的一般或者特殊属性(如形态、颜色、规格、重量、基本单位、销售单位、运输单位、存放条件、生产批次等),这些工作将有利于企业对自有资源的统一管理,也是日常业务单据处理的基础。

特别是物料(或物资)的编码与分类,好像这个是国际标准委员会或中国国家标准委员会做的事情,但是现实情况是,迄今为止没有一套完善的囊括各行各业的物料分类与编码规范。每个企业在做信息化建设的时候都要经历这么一道为企业特有的物质非物质资源分类与编码的程序。如果做的好,其重要性可能体现不出来;但是如果这一步就做得比较失败,后续的工作将如沙地盖楼。举一个最简单的例子,我在加工一个零件的时候要用到原材料,或者在销售的时候需要领料,如果同一种物料被创建了若干次,每一次的描述编码都不同,无论是前端业务的制单者或者是后端财务核算者,都将疲于区分。同时数据库中的垃圾、冗余的数据也将越来越多。

解决了物料管理的第一大问题,分类与编码的问题,接着来看SAP中MM的其他内容。前文说到SD是解决“卖”的问题,那么MM就是解决“买”和“仓储”的问题,当然“运输”将是MM和SD共同关注的问题,至于“生产”,PP模块会来处理。

针对“买”(正式一点叫法是“采购”),我们提出如下问题:

1,谁来买?

2,买什么?

3,向谁买?

4,以什么样的价格买入?

5,采购业务模式?

6,货物如何到达?

7,钱款交割方式?

同理,我们分别引出相应的概念:

1,谁来买?

当然是企业里的某个部门某个班组某一个几个具体的员工。根据需要,从下到上我们会应用到这些相关概念:雇员、采购组、采购组织、公司代码等。这就是所谓的采购组织架构

2,买什么?

物料,就是上文所说的分类与编码问题。

3,向谁买?

供应商。如同物料与客户一样,它是一个企业相对稳定的资源与财富,需要集中收集与管理,这种相对固定的、一旦建立只需要在变动的时候修改的数据,我们称之为“主数据”。既然将这些资源数据化,那么他们都有被被分类整理并分析的必要。比如供应商可以分成:一次性供应商、集团内供应商、国外供应商等。

4,以什么样的价格买入?

采购价。类似于SD中的销售价,一个最终的供应商发票上的价格,也可能包含若干计算小项。我们把这些若干小项称之为“条件类型(Condition Type)”,如:含税基价、进项税、运杂费等等。这些若干小项将以配置好的一种四则运算规则运算出最终价格,这个运算规则在SD中称为“Pricing Procedure”,而在MM中被称为“Calculation Schema”。另一个需要注意的是,采购价、成本价、销售价三者的区别,这是三个没有直接关系的概念,初学时容易混淆。

5,采购业务模式?

刚开始可以先把它理解为单据类型吧。常见的有标准采购、网络采购、空白采购订单(如采购办公用品之未建立物料号的东西),跨工厂的移库也可以用采购的功能来实现。

6,货物的到达

对于供应商的销售行为,他们的业务模式可以是门到门,到岸,或者自提等。如果不是供应商送货上门,企业就有一个内向物流“Inbound Delivery”(区别于销售时的Outbound Delivery)。如果是供应商负责送货上门,我们就可以简单根据采购订单收货入库。当然,不管是Inbound还是Outbound还是Inhouse,SAP的另一运输子功能“Transportation”都能管理起来,囊括从路线的设定到运输的排程到费用的结算的所有内容。

7,钱款的交割

向客户是叫应收AR,向供应商的则叫应付AP。方式也是有多种,当然,前提是收到并校验供应商开出的发票。

至此,物料已经采购入库了,我们再来看MM的仓库管理。物料的仓库管理形式在SAP中有如下定义:最高物料管理单位是Plant(翻译成工厂,容易混淆),Plant可下挂Storage Location。更全面的信息请参考MM的特别是WM的帮助文件。

以仓库为核心,物料的动作无非是:入、出、移动。不管是什么类型的动作,每一次移动SAP都会产生一个凭证:Material Document。不同的类型由不同的移动类型(Movement Type)区分。

1,入

有系统导入时的初始化入库,采购入库,无条件的入库,移库入库,退货入库,产成品入库等。

2,出

有销售出库、移库出库、报废出库、样品出库、采购退货出库、生产领料出库等。

3,移动

这个就无所谓了,想移就移。如果移出地与移入地相隔甚远,可以用Transportation来管理。

关于物料管理更深入的话题有,分割评估、批次管理、科目记账、库存状态、MRP、供应商评估、立体仓库管理、VMI、盘点、委外处理等。咱们花开两朵,各表一枝,下回再见。

SAP – The Basic Series

2008年4月22日 没有评论

Who and / or what is SAP? How popular is it? Wow!
SAP the company was founded in Germany in 1972 by five ex-IBM engineers. In case you’re ever asked, SAP stands for Systeme, Andwendungen, Produkte in der Datenverarbeitung which – translated to English – means Systems, Applications, Products in Data Processing. So now you know! Being incorporated in Germany, the full name of the parent company is SAP AG. It is located in Walldorf, Germany which is close to the beautiful town of Heidelberg. SAP has subsidiaries in over 50 countries around the world from Argentina to Venezuela (and pretty much everything in between). SAP America (with responsibility for North America, South America and Australia – go figure!) is located just outside Philadelphia, PA.

The original five founders have been so successful that they have multiplied many times over such that SAP AG is now the third largest software maker in the world, with over 17,500 customers (including more than half of the world’s 500 top companies). SAP employs over 27,000 people worldwide today, and had revenues of $7.34 billion and Net Income of $581 million in FY01. SAP is listed in Germany (where it is one of the 30 stocks which make up the DAX) and on the NYSE (ticker: SAP).

There are now 44,500 installations of SAP, in 120 countries, with more then 10 million users!

So what made this company so successful? Back in 1979 SAP released SAP R/2 (which runs on mainframes) into the German market. SAP R/2 was the first integrated, enterprise wide package and was an immediate success. For years SAP stayed within the German borders until it had penetrated practically every large German company. Looking for more growth, SAP expanded into the remainder of Europe during the 80’s. Towards the end of the 80’s, client-server architecture became popular and SAP responded with the release of SAP R/3 (in 1992). This turned out to be a killer app for SAP, especially in the North American region into which SAP expanded in 1988.

The success of SAP R/3 in North America has been nothing short of stunning. Within a 5 year period, the North American market went from virtually zero to 44% of total SAP worldwide sales. SAP America alone employs more than 3,000 people and has added the names of many of the Fortune 500 to it’s customer list (8 of the top 10 semiconductor companies, 7 of the top 10 pharmaceutical companies etc). SAP today is available in 46 country-specific versions, incorporating 28 languages including Kanji and other double-byte character languages. SAP also comes in 21 industry-specific versions.

SAP R/3 is delivered to a customer with selected standard process turned on, and many many other optional processes and features turned off. At the heart of SAP R/3 are about 10,000 tables which control the way the processes are executed. Configuration is the process of adjusting the settings of these tables to get SAP to run the way you want it to. Think of a radio with 10,000 dials to tune and you’ll get the picture. Functionality included is truly enterprise wide including: Financial Accounting (e.g. general ledger, accounts receivable etc), Management Accounting (e.g. cost centers, profitability analysis etc), Sales, Distribution, Manufacturing, Production Planning, Purchasing, Human Resources, Payroll etc etc etc. For a full description of the modules included in SAP, see the related articles. All of these modules are tightly integrated which – as you will find out – is a huge blessing … but brings with it special challenges.

SAP are maintaining and increasing their dominance over their competitors through a combination of
- embracing the internet with mySAP.com (a confusing name we believe) to head off i2 etc
- extending their solutions with CRM to head off Siebel
- adding functionality to their industry solutions

Who is it made for? Why might I need it?

We have all heard about the large (and very large) companies who have implemented (or are still busy implementing) SAP R/3. But SAP is gaining acceptance by smaller companies too.

There are many reasons a company selects and implements SAP – some are good and some are bad. The good ones include replacing an out-dated and inefficient IT Architecture (including the CIO’s nemesis … the burning platform), enabling business process change, and to gain competitive advantage. The bad ones are too numerous to go into here but would include the “why are we the only semiconductor company without SAP” question. More on the good reasons follows:

1. Replacing an out-dated and inefficient IT Architecture: In the beginning, computer systems were developed by individual departments to satisfy the requirements of that particular department. When someone finally realized that benefits could be had by linking these systems together, interface heaven was born. There are some companies today with literally thousands of interfaces, each of which needs to be maintained (assuming of course that there is someone around who understands how they work!). Sweeping them away and replacing them with an integrated system such as SAP can save much money in support. Of course, if you have a burning platform as well the question becomes even easier.

2. Enabling business process change – From the start, SAP was built on a foundation of process best practices. Although it sounds absurd, it is probably easier (and less expensive) to change your companies processes to adapt to SAP than the other way around. Many companies have reported good success from combining a SAP implementation with a BPR project.

3. Competitive advantage – The CFO types around have heard this old saying from the CIO types for many years now. The question still has to be asked … can you gain competitive advantage from implementing SAP? The answer, of course, depends on the company. It seems to us, however, that:

• being able to accurately provide delivery promise dates for manufactured products (and meet them) doesn’t hurt … and
• being able to consolidate purchase decisions from around the globe and use that leverage when negotiating with vendors has gotta help … and
• being able to place kiosks in stores where individual customers can enter their product specifications and then feed this data directly into it’s production planning process is pretty neat
• etc etc

How much does it cost? What will it take to implement it? Wow!
There is a defining moment in the journey of all companies on the road to SAP nirvana. This moment comes just after the company has concluded that it want’s SAP, it needs SAP, it’s gotta have SAP … then comes the question ‘so what does it take to implement it’?

Before being accused of being too negative, let me remind you that at the heart of every good business decision lies a cost benefit analysis. If this cannot be complete with a positive outcome, the initiative (whatever it is) should probably not be launched. Same goes for a SAP implementation.

Implementing SAP is expensive. No doubt about it. But the potential rewards can dwarf the costs (and have for many existing customers already). One customer reportedly made enough savings on the procurement of a single raw material to pay for the entire enterprise-wide SAP implementation! Of course these are hard to substantiate, but visit SAP’s website and take a look at the customer testimonials.

SAP sells it’s R/3 product on a ‘price per user basis’. The actual price is negotiated between SAP and the customer and therefore depends on numerous factors which include number of users and modules (and other factors which are present in any negotiation). You should check with SAP, but for a ballpark planning number you could do worse than starting with $4000 per user. There is also an annual support cost of about 10% which includes periodic upgrades. Again, check with SAP.

Then there is the implementation cost. Yowser. It is about now that you need to get the business case out again and remind yourself why you need to do this. The major drivers of the total implementation cost are the Timeframe, Resource Requirements and Hardware.

Timeframe – The absolute quickest implementation we have ever heard of is 45 days … but this was for a tiny company with very few users and no changes to the delivered SAP processes. At the other end of the scale you get the multi-nationals who are implementing SAP over 5 to 10 years. These are not necessarily failures … many of them are planned as successive global deployments (which seem to roll around the globe forever). Of course the really expensive ones are those we don’t hear about! For the most part, you should be able to get your (single instance) project completed in a 9 to 18 month period.
People – The smallest of SAP implementations can get done on a part-time basis without outside help. The largest swallow up hundreds of people (sometimes over a thousand) and include whole armies of consultants. This adds up fast. Again, get that business case out. The types of people you will need run the range from heavy duty techies to project managers.
Hardware – The smallest of SAP implementations probably use only three instances (boxes) … one for the production system, one for test, and one for development. The largest implementations have well over 100 instances, especially if they involve multiple parallel projects (otherwise known as a program).
Adding all this up, your SAP project can run anywhere from $400,000 to hundreds of millions of $’s. As you can see, SAP can be all things to all companies … so it’s best to talk to them (or your consulting firm) about your specific requirements.

Is there any help out there? What should I do next? Help From SAP AG
There is a ton of help available out there – depending on your companies budget and culture – to help you along your journey beginning with your strategy and ending up when you reach that hallowed (and sometimes distant) ground of post-implementation. This article concentrates on the help available from SAP AG. Article 5 discusses other sources of help.

SAP AG employs around 22,000 people. Although they re-organize as often as most other companies, you can think of them as being organized into the following four areas: Pre-Sales, Consulting, Training and Developers.

• Pre-Sales. These are people with heavy-duty functional knowledge of one or more SAP modules and one or more industries. They give really excellent system demonstrations on particular areas of the system which – while thick with pre-sales features – are an extremely valuable source of information about SAP. I’m sure they have many other responsibilities as well, but if you can, get a demo from them. For an even more useful demo, ask if you can provide them with business process scenarios that are pertinent to your business or industry prior to the demo.

• Consulting. While also knowledgeable in SAP (of course), these are mostly consulting types like those that can be found in the major consulting firms. Often a team will consist of consultants from SAP and a partner consulting firm and you will not know the difference. Expect them to have business process and/or industry knowledge in addition to detailed SAP knowledge. They are not readily available to non-customers as they are usually assigned to one or more customers. A good list of consulting partners is available in the links section of this website.

• Training. In 1999 SAP opened up their training programs to non-customers and non-partners. This opens up a whole world of top-rate training programs at SAP’s facilities around the globe. These can be expensive, however, and up to three weeks are usually required to gain a sufficiently deep understanding of a particular module or subject. If you have lots of time and money, you could register for one of SAP’s ‘academies’ which are five-week crash courses (emphasis on crash … as in burn) in one of the following areas: FI/CO, MM/SD, and HR/ABAP. These end with an examination and ‘certification’ in your chosen area. More information on SAP training courses can be found on SAP’s website.

• Developers. These heavy-duty techies are off limits to non-customers. Customers can sometimes get a message to them via the OSS system – which is an automated trouble ticket type system. If you ever actually see one, or have one on the phone, ask all the questions you can think of, as you may never have the chance again!

Is there any help out there? What should I do next? Help From Other Sources
Here we will cover the help that is available from other sources, including: Consulting Companies, SAPPHIRE and other SAP Events, ASUG, and this website.

1. Consulting Companies
One of SAP’s key strategies has been to develop partnerships with the Consulting Companies. This has contributed enormously to the widespread adoption of SAP due to the fact that there are literally thousands of consultants (SAP estimate 55,000) ready to help with all aspects of your SAP implementation … from strategy to completion. There are two types of consulting partners:

1. Global consulting partners (13 of these at last count) are the largest of the consulting firms who are able to provide global assistance to global companies, and

2. National consulting partners who are accredited by country

Your need of a consulting partner depends on your project scope and complexity, your project budget, company culture, and prior SAP implementation experience in your company. Suffice to say that without heavy prior SAP experience in your company, all but the simplest SAP implementations would benefit from the involvement of experienced individuals who have done it before. Rates depend on your negotiations with the consulting company, of course, but you could do worse than use an estimate of $200 per person per hour. Consulting styles differ from firm to firm, so make sure your company culture is compatible with the typical approach of your chosen consulting partner. In addition, spend some time on their websites to get an idea of their approach, experience and capabilities.

2. SAPPHIRE and other SAP events
SAPPHIRE is the name given to SAP’s annual user conference. Multiple SAPPHIRE’s can be found around the globe each year, and are usually sold out in advance. North American SAPPHIRE’s are typically held in hot cities (off season) and attract upwards of 14,000 prospects, customers and partners. Read up on SAPPHIRE’99 here. SAPPHIRE is a great place to go explore, but is quite expensive at around $2,200 for three days (food, lodging, travel etc is at your own expense). Even so, it is well worth the time and expense.

Note: SAP holds other events throughout the year (TechEd, for example, is aimed at the more technical users) see their website for additional details.

3. ASUG (America’s SAP User Group)
As the name suggests, ASUG is a forum for users of SAP. Non-users (prospects and consultants) and not usually found lurking here. ASUG actually comprises of multiple sub-ASUG’s – each focusing on a particular area of SAP, for example there is an ASUG for High Tech companies, and an ASUG for companies using ALE etc. Leadership of these sub-ASUG’s (for lack of a better description) usually rotates between members of the user community. ASUG provides opportunities for networking, learning and influencing SAP (for example joining forces with other users to convince SAP to include a particular modification in their standard software). In addition to meetings within the sub-ASUG’s, there is an annual conference (which attracted nearly 6,000 users and vendors in 1999). More details on ASUG can be found at www.asug.com.

SAP AG Corporate Overview (Updated August 2004)
3rd – SAP is the 3rd largest software company in the world

30,000 – Total number of people employed by SAP
5,400 – Number of programmers employed by SAP

$7.024 billion – FY03 Revenue
$1.077 million – FY03 Net Income

12,000 – Number of companies using SAP
79,800 – Number of SAP installations
12,000,000 – Number of people using SAP
120,000,000 – Total number of people in the 12,000 companies who are using SAP

28 – Number of languages supported by SAP
46 – Number of country-specific versions of SAP
22 – Number of industry-specific versions of SAP

1,000 – Number of pre-defined best practices contained in the SAP system
10,000 – Number of tables requiring configuration in a full SAP implementation

55,000 – Number of SAP experienced consultants worldwide

28 – Number of years ago SAP was started

5 – Number of people who started SAP

SAP Modules and Solutions Overview
SAP now are moving away from describing their system as a set of modules, and now are using the term ‘solutions’, which is much better. If you visit SAP’s website (as we urge you to do) you will find that they have structured their Solutions tab as follows:

1. Financials
2. Human Resources
3. Customer Relationship Management
4. Supplier Relationship Management
5. Product Lifecycle Management
6. Supply Chain Management
7. Business Intelligence

If you’re still looking for that list of modules, here they are:

FI Financial Accounting – essentially your regulatory ‘books of record’, including
1. General ledger
2. Book close
3. Tax
4. Accounts receivable
5. Accounts payable
6. Consolidation
7. Special ledgers

CO Controlling – basically your internal cost/management accounting, including
1. Cost elements
2. Cost centres
3. Profit centres
4. Internal orders
5. Activity based costing
6. Product costing

AM Asset Management – track, value and depreciate your assets, including
1. Purchase
2. Sale
3. Depreciation
4. Tracking

PS Project Systems – manage your projects, large and small, including

1. Make to order
2. Plant shut downs (as a project)
3. Third party billing (on the back of a project)

HR Human Resources – ah yes, people, including
1. Employment history
2. Payroll
3. Training
4. Career management
5. Succession planning

PM Plant Maintenance – maintain your equipment (e.g. a machine, an oil rig, an aircraft etc), including
1. Labour
2. Material
3. Down time and outages

MM Materials Management – underpins the supply chain, including
1. Requisitions
2. Purchase orders
3. Goods receipts
4. Accounts payable
5. Inventory management
6. BOM’s
7. Master raw materials, finished goods etc

QM Quality Management – improve the quality of your goods, including
1. Planning
2. Execution
3. Inspections
4. Certificates

PP Production Planning – manages your production process, including
1. Capacity planning
2. Master production scheduling
3. Material requirements planning
4. Shop floor

SD Sales and Distribution – from order to delivery, including
1. RFQ
2. Sales orders
3. Pricing
4. Picking (and other warehouse processes)
5. Packing
6. Shipping

CA Cross Application – these lie on top of the individual modules, and include
1. WF – workflow
2. BW – business information warehouse
3. Office – for email
4. Workplace
5. Industry solutions
6. New Dimension products such as CRM, PLM, SRM, APO etc

Contributed by Rajagopalan M
———————
ABAPer, mail: abap.community@gmail.com http://abaplearner.blogspot.com

SAP- Finance (FI) Notes

2008年4月22日 没有评论

Module Functions:
The module that performs most of the traditional legal entity accounting functions, reporting by company, income statements and balance sheets. This is the module where you will find the A/R and A/P sub-ledgers and their open items along with the Asset Accounting Ledger.

Organizational Elements (Structures):
• Chart of Accounts – contains all account numbers and some general control data.
• Company Code – an independent balancing / legal accounting entity. each company code is assigned to one Chart of Accounts
• Functional Area – Classify operating expenses according to of cost-of-sales accounting by production, admin, S&D marketing, R&D, etc. By breaking costs into functional areas cost- of-sales accounting shows why costs accrue and indicates the economic purpose of the expense.
• Trading Partner
• Operating concern – the central organizational element in profitability analysis. It represents the environment within which a market or (customer defined) segment of the business can be monitored and profitability analyzed. 1:n relation to controlling.
• Controlling area – identifies a self-contained unit for which the management of costs and profits can be performed. Only one chart of accounts is allowed within a controlling area. However,
• (FI-AA) Asset Accounting – Depreciation (both book and tax), net book values, transfers and retirements
Document Posting Principles:
Each posting is in the form of a complete document. It must contain:
• Basic account assignment data (i.e. document date, posting date, document type, posting key, account number and amount.
• Entries must be made in all required fields.
• Debit and credit balances must be equal.
Every document contains a document header and at least two or more line items.
• The header contains information valid for the whole document (i.e. document date and type).
• Line items contain transaction specific data (i.e. posting key, account number and amount).
Document header:
• Document Date is the date that the transaction took place. (Must be on or before the Posting date ?) Posting Date determines the posting period (the system will enter this date if not provided?)
• Document Number is normally assigned b the system from a range predefined for each document type. (Not an input for g/l doc types {S}
• Reference and Document Header Text is descriptive data
• Period is the accounting period. Normally numeric (1 to 16?)
• Document type, a two character alphanumeric field. This field determines the document number range and the valid account types which may be used.
• A df Fixed Assets
• D df Accounts Receivable
• K df Accounts Payable
• R df Logistics (MM & SD)
• S df G/L
• T df Treasury
• W df Material Management
• Z df Sp0ecial purpose
Line Items:
• Posting Key is a two character numeric
• Together with the account number controls posting at item level
• Controls valid account type (D,K,M,A)
• Defines a Debit or credit entry
• Controls fields required optional or suppressed
• Valid FI posting keys
o 01-09 DR Customer
o 11-19 CR Customer
o 21-29 DR Vendor
o 31-39 CR Vendor
o 40 DR G/L
o 50 CR G/L

By Rajagopalan M
———————
ABAPer, mail: abap.community@gmail.com http://abaplearner.blogspot.com

Overview of functional tables

2008年4月22日 没有评论

Entities

Accounting
Accounting documents
Bill Of Material
Capacity planning
Classification
Classification class types, classifiable objects
Classification characteristics
Configurator
Cost elements centers and activities
Customer
Equipment
Equipment status system status / user status
Function location and reference function location
General ledger accounts
Goods movement
Inventory document
Maintenance Order PM order
Material
Material document
Notifications
Orders Purchase orders
Personel
Production resource tools PRTs
Project
Purchase Requisition
Purchasing document
Purchasing Info record
Reservation
Sales document Invoice, delivery, partners, contacts
Sales requirements
Storage locations and stocks
Tasklist General ~, function location ~ or equipment ~
Transfer requirement
User data
Vendor master
Warehouse Management transfer

If the information above is not sufficient, this bit could be interesting to you:

The search for functional tables

Table overview

Accounting BSAD Accounting: Secondary index for customers (cleared items)
BSID Accounting: Secondary index for customers
BSIW Index table for customer bills of exchange used
BSIX Index table for customer bills of exchange used
BSAK Accounting: Secondary index for vendors (cleared items)
BSIK Accounting: Secondary index for vendors
BSIP Index for vendor validation of double documents
BSAS Accounting: Secondary index for G/L accounts (cleared items)
Logical databases: -
Accounting documents BKPF Accounting document header
BSEG Accounting document segment
BSET Tax data document segment
BSEC One-time account data document segment
Logical databases: BRM
Bill Of Material MAST Material to BOM Link
EQST Equipment to BOM Link
STAS BOMs header
STKO BOM header
STPN BOM follow-Up control
STPO BOM item
STPU BOM sub-item
STST Standard BOM link
STVB Bills of material – Serialization of posting
STZU Permanent BOM data
Logical databases: -
Bill Of Material KBED Capacity requirements record
Logical databases: POH
Classification CABS Result of the Statistical Analysis of Table AUSP
CUFM Customizing: Class/Config: Screendesigner Form
TCME Validity for Global Characteristics
KLAH Class Header Data
KLAT Classes: long texts
KSML Characteristics of a Class
AUSP Characteristic values
SWOR Classification System: Catchwords
KSSK Allocation Table: Object to Class
TCLG Class groups
TCLO Key Fields of Objects
TCLS Classes: Organizational areas
TCLST Classes: Org. Areas (Texts)
TCLU Class Status
COCC PP-PI attributes for characteristics
COFV Process management – process instr. charact. in ctrl. recipe
COME Process management – message characteristics
CORE Process mgmt.- display characteristics of the eval. version
PLFV PI Characteristics/Sub-Operation Parameter Values
Logical databases: -
Matchcodes: CLAS, MERK en KLSW
Classification TCLA Class Types
TCLAT Class Type Texts
TCLT Classifiable Objects
LTCLTT Classifiable Objects: Texts
Logical databases: -
Classification characteristics CABN Characteristic
CAWN Characteristic values
Logical databases: -
Configurator CUCO Additional Data for Configurable Objects
CUCVRNT Variants of Constraints
CUEX Dependency Storage – Compilation
CUFM Customizing: Class/Config: Screendesigner Form
CUKB Administrative Information for Dependency Maintenance
CUKBT Text Table for Dependency Maintenance Admin. Information
CUKN Dependency Storage – Variants/Configuration
CUOB Link between Object and Dependency
CUPE Extension to BOM Item for Variants
CURSADD Dependency Net Additional Data
CUVT Variant Table
CUXREF Object Dependency Cross References
Logical databases: -
Cost elements, centers, activities CSKA Cost elements (data dependent on chart of accounts)
CSKB Cost elements (data dependent on controlling area)
CSKS Cost center master
CSKT Cost center texts
CSKU Cost element texts
CSLA Activity master
CSLT Activity type texts
CSSK Cost center /cost element
CSSL Cost center / activity
Logical databases: -
Customer KNA1 General Data in Customer Master
KNAS Customer master (VAT registration numbers general section)
KNB1 Customer master (company code)
KNB4 Customer payment history
KNB5 Customer master (dunning data) (aanmaangegevens)
KNBK Customer master (bank details)
KNC1 Customer master (transaction figures)
KNC3 Customer master (special G/L transaction figures)
KNKA Customer master credit management: Central data
KNKK Customer master credit management: Control area data
KNMT Customer-Material Info Record Data Table
KNMTK Customer-Material Info Record Header Table
KNVA Customer Master Loading Points
KNVD Customer master record sales request form
KNVI Customer Master Tax Indicator
KNVK Customer Master Contact Partner
KNVL Customer Master Licenses
KNVP Customer Master Partner Functions
KNVS Customer Master Shipping Data
KNVT Customer Master Record Texts for Sales
KNVV Customer Master Sales Data
Logical databases: DDF
Equipment EQUI Equipment master data
EQKT Equipment short texts
EQUZ Equipment time segment
EAPL Allocation of Task Lists to Pieces of Equipment
Logical databases: EQI
Equipment status EQUI Equipment master data
JSTO Status object information
JEST Object status
TJ30 User status
TJ30T Texts for user status
TJ02 System status
TJ02T Texts for system status
Logical databases: -
Function location IFLOT Functional Location (Table)
IFLOTX Functional location: short texts
IRLOTX Reference functional location: short texts
TAPL Allocation of task lists to functional locations
Customizing tables
T370R Reference functional location category
Logical databases: -
General ledger accounts SKA1 G/L accounts master (chart of accounts)
SKAS G/L account master (chart of accounts: key word list)
SKAT G/L account master record (chart of accounts: description)
SKB1 G/L account master (company code)
SKM1 Sample G/L accounts
SKMT Sample account names
SKPF Header Data: Inventory Sampling
Logical databases: -
Goods movement AUFM Goods movements for order
AFFW Goods movements with errors from confirmations
SER03 Doc.header f.serial numbers for goods movements
Customizing
T440C Planning file entries for goods movements
Logical databases: -
Inventory document IKPF Header: Physical Inventory Document
ISEG Physical Inventory Document Items
LINK Inventory document header in WM
LINP Inventory document item in WM
LINV Inventory data per quant
Maintenance Order
AFIH Maintenance Order Header
AFKO Order header data PP orders
AFPO Order item (not used much)
AFRU Order completion confirmations
AFVC Operation within an order
AFVV Order position data
CRCO Assignment of work center to cost center
OBJK Plant Maintenance Object List
CRHD Work Center Header
PLAF Planned order
HIKO Order master data history
HIVG PM order history: operations
Logical databases: CNJ
Material MARA Material Master: General Data
MARC Material Master: C Segment
MARD Material Master: Storage Location/Batch Segment
MAKT Material Descriptions
MAPL Allocation of task lists to materials
MARV Material Control Record
MARM Units of Measure
MBEW Material Valuation
MOFF Outstanding Material Master Records
MSTA Material Master Status
MVER Material consumption
MVKE Material Master: Sales Data
MAPR Material Index for Forecast
PROP Forecast parameters
Logical databases: MSM
Material document MKPF Header: Material Document
MSEG Document Segment: Material
BSIM Secondary Index, Documents for Material
Logical databases: -
Notifications QMEL Quality notification
QMIH Quality message – maintenance data excerpt
Logical databases: -
Orders AUFK Order master data
AFKO Order header data PP orders
AFPO Order item
JSTO Status object information
JEST Object status
Logical databases: ODK
Personel PCL5 HR/RP Cluster 5; HR Planning Usage
PREL HR Master Data (Version 3.0: Old Version !)
PTXT Texts for HR Master Data
…. table PREL has been changed to
PA0000 HR Master Record: Infotype 0000 (Events)
PA0001 HR Master Record: Infotype 0001 (Org. Assignment)
PA0002 HR Master Record: Infotype 0002 (Personal Data)
PA0003 HR Master Record: Infotype 0003 (Payroll Status)
PA0004 HR Master Record: Infotype 0004 (Challenge)
PA0005 HR Master Record: Infotype 0005 (Leave Entitlement)
PA0006 HR Master Record: Infotype 0006 (Addresses)
PA0007 HR Master Record: Infotype 0007 (Work Schedule)
PA0008 HR Master Record: Infotype 0008 (Basic Pay)
PA0009 HR Master Record: Infotype 0009 (Bank Details)
PA0010 HR Master Record: Infotype 0010 (Capital Formation)
PA0011 HR Master Record: Infotype 0011 (Ext.Bank Transfers)
PA0012 HR Master Record: Infotype 0012 (Fiscal Data Germany)
PA0013 Infotype Social Insurance – Germany
PA0014 HR Master Record: Infotype 0014 (Recurr. Bens/Deducs)
PA0015 HR Master Record: Infotype 0015 (Additional Payments)
PA0016 HR Master Record: Infotype 0016 (Contract Elements)
… and up to PA00281 and PA0900 is available !
Logical databases: PNP
Production resource tools AFFH PRT assignment data for the work order
CRVD_A Link of PRT to Document
CRVD_B Link of Document to PRT
CRVE_A Assignment PRT data – equipment
CRVE_B Assignment equipment – PRT data
CRVM_A Link of PRT data to a material
CRVS_A Relationship of PRT internal number to PRT external number
CRVS_B Relationship of PRT external number to PRT internal number
Customizing tables:
TCF02 PRT categories
TCF03 Texts for the production resources/tools category
TCF04 Status of the PRT master
TCF05 Language-dependent text table for PRT status
TCF06 Field groups in the PRT master for reference
TCF07 Language-dependent texts for field groups in PRT master
TCF08 Assignment of PRT master fields to field groups
TCF10 PRT control key
TCF11 Language-dependent text table for PRT control keys
TCF12 PRT group key
TCF13 Language-dependent text table for PRT group keys
Logical databases: -
Project PROJ Project definition
PRPS WBS (Work Breakdown Structure) Element Master Data
PRTE Scheduling Data for Project Item
Logical databases: CNJ, PSJ, IMA
Purchase Requisition EBAN Purchase Requisition
EBKN Purchase Requisition Account Assignment
EBUB Index for Stock Transport Requisitions for Material
Logical databases: BAM, BKM, BBM
Purchasing document EKAN Vendor Address: Purchasing Document
EKBE History of Purchasing Document
EKBZ History of Purchasing Document – Delivery Costs
EKET Delivery Schedules
EKKN Account Assignment in Purchasing Document
EKKO Purchasing Document Header
EKPO Purchasing Document Item
EKPB “Material Provided” Item in Purchasing Document
EKPV Shipping-Specific Data on Stock Tfr. for Purch. Doc. Item
Logical databases: -
Purchasing info record EINA Purchasing Info Record – General Data
EINE Purchasing Info Record – Purchasing Organization Data
EIPA Order Price History, Info Record
EIKP Export/import header data
EIPO Export/Import Item Data
KONH Conditions (Header)
KONP Conditions (Item)
KONM Conditions (1 Dimensional Quantity Scales)
KONW Conditions (1 Dimensional Value Scales)
Logical databases: IFM, ILM
Reservation RKPF Document Header: Reservation
RESB Reservation/dependent requirements
Logical databases: RKM, RNM, POH
Sales Document VBAK Header Data
VBAP Item Data
VBAG Release Data by Schedule Line in Sch.Agrmt.
VBUK Header Status and Administrative Data
VBUP Item Status
VBRL SD Document: Invoice List
VBPA partner
VBKD Business Data
VBKA Sales activities
VBEP Schedule Line Data
VBRK Billing: Header Data (invoice)
VBRP Billing: Item Data (invoice)
VBFA Sales Document Flow
LIKP Delivery Header Data
LIPS Delivery: Item data
Logical databases: AAV, AKV, ARV, VFV
Sales requirements VBBE Sales Requirements: Individual Records
VBBS Sales Requirement Totals Record
Logical databases: -
Storage locations and stocks LAGP Storage bins
LEIN Storage unit header records
LQUA Quants
LQUAB Total quant counts for certain strategies
MEIK Make-to-Order Stock for Customer Order
MSCA Sales Orders on Hand with Vendor
MSKA Sales Order Stock
MBPR Stock at Production Storage Bin
MLGN Material Data per Warehouse Number
MLGT Material Data per Storage Type
SLGH Elements of Stock Population
Logical databases: S1L, S2L
Tasklist
PLKO Task list – header
PLAS Task list – selection of operations/activities
PLPO Task list – operation/activity
PLKZ Task list: main header
PLWP Allocation of Maintenance Packages to Task List Operations
PLAB Relationships
PLFH Task list – production resources/tools
PLFL Task list – sequences
PLFT Process instructions
PLFV PI Characteristics/Sub-Operation Parameter Values
PLMZ Allocation of bill of material items to operations (component list)
PLPR Log collector for task lists
MAPL Allocation of task lists to materials
EAPL Allocation of task lists to pieces of equipments
TAPL Allocation of task lists to functional locations
Logical databases: -
Transfer requirement LTBK Transfer requirement header
LTBP Transfer requirement item
Logical databases: R1L, RBL, RUL
User data USR01User master record (run-time data)
USR02 Logon data
USR03 User address data
USR04 User master authorizations
USR05 User Master Parameter ID
USR06 Additional data per user
USR07 Object/values of last failed authorization check
USR08 Table for user menu entries
USR09 Entries for user menus (work areas)
USR10 User master authorization profiles
USR11 User Master Texts for Profiles (USR10)
USR12 User master authorization values
USR13 Short Texts for Authorizations
USR14 Surchargeable language versions per user
USR15 External User Name
USR20 Date of last user master reorganization
USR30 Additional Information for User Menu
USR40 Table for illegal passwords
USR41 User master: Additional data
USRCOBJ Object Filters for Exploding Product Structures
USRM0 Material Master User Settings: User Screen Reference
USRM1 Material Master User Settings: Organizational Levels
USRM2 Material Master User Settings: Logical Screens
USRMM User settings: material master
Vendor master LFA1 General section
LFAS VAT registration numbers general section
LFB1 Company code
LFB5 Dunning data
LFBK Bank details
LFC1 Transaction figures
LFC3 Special G/L transaction figures
LFM1 Record purchasing organization data
Logical databases: KDF
WM transfer LTAK WM transfer order header
LTAP WM transfer order item
LUBU Posting change document
Logical databases: R0L, RTL

SAP SD Frequently Asked Questions & Interview Questions

2008年4月22日 1 条评论

1. What is the purpose of text determination, account determination, partner determination, output determination, and storage location determination?
Answer1:
Text determination:
For transferring information from material or customer to order / delivery or invoice (and anything in between)

Account determination:
For transferring financial and costing information to proper financial docs

Partner determination:
For determine who is legally responsible for A/c, who the goods are going to and whatever else you waana drive through this functionality.

Output determination:
What kind output does a sales/delivery/billing document create and who gets it, where? For example A partner might get an EDI notification for a sales order just confirmed, whereas a financial/leasing company gets the invoice!

Answer2:
(a) Text Determination: Any Texts in Material Master/Material Determination/Order/Delivery , etc is meant to convey messages to the subsequent documents for compliance. e.g. “Give Top Priority” message mentioned in Order is meant for Production Dept.
(b) Account Determination: is integration between Finance and SD. The A/P along with Account Keys need to be allocated accordingly with combination of Account Determination Group for Customer and Material if required. (c) Partner Determination: To identify which type of Partner it is so that if required for same Customer different Partner Functions may be required (Ex. Only One Sold To Party per Customer. More than One Ship to Party / Bill to Party / Payer possible. Accordingly different Masters will have to be created. Useful for Despatch of Material in case of Ship to Party, sending Bill in case of Bill to Party and payment follow-up / Dunning in case of Payer.
(d) Output Determination: What type of Output (Fax/Mail, etc) is required, where and in what Format (ABAP Customization may be required in some cases especially Invoices).
(e) Storage Location Determination: depends on Plant, Shipping Point and Storage Conditions

2. What are the five imp fields to be maintained in account determination?
Account Determination:
Sales View, Sales Organisation, Distribution Chanel, Chart of Accounts, Account Assignment Group for Customer and Material and Account Keys.

3. How to create excise invoice and what is it

4. What is meant by transfer of data from legacy code to sap Legacy Code?

Answer1:
It should be legacy data to SAP. What it means is you want to transfer all customer and materials and all other information from Older (legacy system) to new SAP system. You can do it using many tools, most noticeably MDMs.

Answer2:
Before installation of SAP, Data maintained by Company is called Legacy Data. At the time of installation, it is required to transfer Data from Legacy to SAP like Masters (Material/Customer, etc). It can be done in various ways like BDC, LSMW, etc.

5. What do you do really in pricing determination and what are the main differences between pricing procedures?
Answer1:
Pricing is determined by combination of Sales Organisation, Distribution Channel, Division, Customer Pricing Procedure and Document Pricing Procedure.

Answer2:
We determine how the prices are calculated, taking into account sales area(sales org, distribution channel, division), document type and customer(generally sold-to-party).

The main differences between pricing procedures would be the differences as we mentioned above, from the point of view of field entries. Coming to the output and the procedure, suppose the condition types used will be different and hence the following whole procedure. One pricing procedure determination to the others, which data control these differences

6. What type of reports generally a support consultant maintains and report
Depends on Customer requirements.

7. What are interfaces used generally an indian organisation which is in retail business and which is in banking business and oil business.

8. What is the purpose of shipping point determination not menu path
So that Shipping Point is determined automatically once the settings for the same are done.

9. What and where types of copy controls we change
Copy Control: is basically meant so that Data is copied from preceding Document to subsequent one. What subsequent Document is required is to some extent determined by Customer Requirements as well as Document Types. (Ex.) In general case of Standard Order, it will be Copy Control (Order to Delivery) from OR to LF.

10. How to and where to maintain copy controls
Check for yourself in IMG (Sales Document types and Delivery Document Types)

11. What is purpose of maintaining common distribution channels and common divisions?
Common Distribution Channel and Common Division are maintained so that if any master data like customer or material maintained with respect to one distribution channel can be used in other DCh. It prevents the multiplication of master records.

Eg: A customer is created for say sales area 1000/20/00 then the same customer can be used in sales area 1000/30/00 if we maintain 20 as common distribution channel. Hence no need for extending the customers…the same for materials also.

12. What is the difference between the Availability check 01 (Daily requirement) and 02 (Individual Requirement) in material master?
01 and 02 are the checking group. Availability check is carried out with the help of these checking group and checking rule. Checking group 01 and 02 are maintained on the material master.

01 – Individual requirement -For this system generates transfers the requirement for each order to the MRP .So that MM can either produce or procure.

02- Collective requirement.-In this all the requirements in a day or in a week are processed at a time. System stores all req and passes on to the MRP in MRP run. In this system performance is high however you can not do the backorder processing whereas in other you can do.

13. What is a Division in SAP SD?
A division is a product group that can be defined for a wide range of products or services. Customer specific arrangements can also be made in a division. A sales organization can have many divisions.

14. What is a sales office in SAP SD?
A sales office is a geographically located unit of a sales organization.

15. What is a shipping point and loading points in SAP SD?
Shipping points are the points from where deliveries are initiated. One shipping point can be assigned to more than one store or plant. A Loading point is just a subdivision of a shipping point and manually entered into the header data of the delivery.

16. What is the transaction code for creating a customer in SAP SD?
VD01, VA01, XD01

17. What are the basic elements of a customer master record?
The sold to party, the ship to party, bill to party, and the payer record.

18. What are inter company customers?
These customers represent the sales customers within the same client but between different company codes.

19. What is a one time customer?
This is a general customer that is created for those customers for which you do not want to create separate records. This customer can be reused.

20. How does the SAP system knows which fields to turn on and off when you create a customer master record?
Using the account group which is assigned to the customer.

21. Who defines the account groups?
Normally these are defined by the finance team.

22. Who is a payer in the customer master record?
Payer is the individual or company who will settle the invoices for products or services sold.

23. Can you give me some tables in SAP SD for customer master?
Some of the tables are KNVV, RF02D, KNA1 etc

24. What are some of the examples of Global settings?
Currencies, countries etc. This data is application independent.

25. What is a sales organization?
Sales organization is an organizational unit that sells and distributes products and negotiates terms of sales and is responsible for all the transactions involved with a sale

26. What is the purpose of material master data?
Master data responsible for representing all information related to products or services that a company produces or sell.

27. What is the transaction code for creating a material/article in SAP?
MM41 for creating article in SAP IS Retail and MM01 in SAP Industry solution for creating a material.

28. How do you extend a material, which transaction?
MM01

29. What are some of the views in a material master?
Basic data, additional basic data, Accounting views, MRP views, Purchasing views, Storage views, forecasting views, sales views and in IS Retail there is also a Listing view and POS view.

30. What is a base unit of measure in material master?
This is a unit of measure used as a basis for all the transactions, all movements of quantities will be converted to that base unit of measure which is specific to an article.

31. Can you have specific customer material information entered in SAP?
Yes, VD51 is the transaction or inside VA02 also you can add customer material information records.

32. What is a customer group? Give me some examples.
Customer group is 2 digit numbers that is configured within IMG and allows logical grouping of customers. For example you may want to group International customers, Domestic customers or military customers separately.

33. What are some of the tables in SAP SD?
VBAK – Order header
VBAP – Order Item
VBEP – Order schedule line
LIKP – Delivery Header
LIPS – Delivery Item
VBPA – Partners
VBFA – Document flow

34. How would you find which table is being used in a particular field?
Bring your cursor to the field in a transaction and press F1 and then technical info.

35. How would you find all the tables in SAP?
SE16 (or) SE11.

36. What are some of the material master data tables?
MARA – Material highest level data
MBEW – Data referring to accounting
MVKE – Data referring to sales
MARC – Data at the plant level
WLK1 – Listing information
MARD – Data storage locations

Here are the Few frequently Asked SD Questions (With out Answer):

What are the five imp fields to be maintained in account determination?

How to create excise invoice and what is it?

What is meant by transfer of data from legacy code to sap?

What are interfaces used generally an indian organisation which is in retail business and and which is in banking business and oil business?

What is the purpose of shipping point determination not menu path?

What and where types of copy controls we change?

How to and where to maintain copy controls?

What is purpose of maintaining common distribution channels and common divisions?

What is the relation between sap sd and abap?

What should be the value set for Lead Time in Sales Document Type while configuring the system?

How do you calculate net price on MRP based?

What are the five imp fields to be maintained in account determination?

Is it possible to release change request, without releasing task.

What do you do really in pricing determination, and what are the main differences between one pricing procedure determination to the others, which data control these differences?

Product attributes means?

Can one have multiple packing for delivery?

What is the difference between general item category group and item category group ( sales org2 in MMR)?

To extend material one plant to another plant what are the configuration you done in your project?

How SAP support to the client to know the customer requirements?

How to stop PGI?

Quotation has been created for product-D, 10 quantities, sales order is created with reference to the quotation, system copies 10 quantities in sales order. How do you restrict in sales order end

user should not change quantities, system should not allow for changes by en user?

What is the client specific data? Give two examples of client specific data?

Random Posts

]]>