sapjournal

Регистрируемся и качаем:

http://www.scribd.com/search?cx=007890693382555206581%3A7fgc6et2hmk&cof=FORID%3A10&ie=UTF-8&c=all&ft=&q=sap&sa=Search#1146

http://help.sap.com/bp_blv1600/BL_US/html/end_user_BPP_list.htm

Business blueprint step by step guide

http://sapdocs.info/netweaver/business-blueprintstep-by-step-guide/

A comprehensive configuration management is the most important basis of SAP Change and Transport Management. For ABAP code, this is accepted as general practice and supported by suitable tools. But how about configuration management for SAP customizing?

From our experience, the major part of changes transported across a SAP system landscape are customizing changes. Not surprisingly, the persons responsible for change and transport management often keep struggling with problems after roll-outs for lack of consistently applied configuration management for these objects. A consistent change and distribution of customizing requires stringent configuration management.
Crucial to a cross-enterprise use and protection of SAP templates is that central and local objects are well documented, comprising all versions of their lifecycle up to the newest version.

Comprehensive SAP configuration management all across the SAP landscape is meant to ensure overall integrity of the objects involved in SAP development, including ABAP as well as non-ABAP objects:

The use of well-defined standardized naming conventions clearly reveals to which organizations, areas and projects the objects belong.
All changes to objects, including individual customizing settings, are documented. At any time, it is obvious who is – and at which times – the owner of settings, who is entitled to make and has made changes and for which reason. This allows the changes to be tracked afterwards, which is an equivalent to versioning.
The documentation also includes the information as to who and what and who depends from a defined customizing setting. This is an integral factor of reasonable impact management.
In the context of each change to the SAP landscape systems, it must be made sure that the Prospero, which have been designed to disclose the causes of problems in SAP logistic processes, or even to give a prognosis concerning their results. The same is achieved by using SAP change management data for the transport of SAP changes. In any case, SAP change and transport management has still plenty of room for improvement in complex SAP landscapes.

Summary
Applying a wide-ranging SAP configuration management has turned out to be the most effective method to ensure a consistent and efficient SAP change and transport management and a consistent customizing across the SAP system landscape.

Unfortunately, the opportunity for global enterprises using large SAP systems to improve the quality and to save costs by investing in SAP change and transport management is very often not seized, because it is thought to be technically complex. But if the challenge is taken up it soon shows that the problems are more political or company-related than of a technical nature.

http://www.beteoblog.com/2008/06/27/configuration-management-for-sap-customizing/

P.S.
Customizing is a process to customize SAP (through configuration or ABAP programming) to make it fits with company's requirements or company's business process. Configuration is a process to fit SAP with company's requirements or company's business process by using SAP own transaction codes, which is SPRO. This T-Code can be used to configure all of SAP R3 Modules, such as Create company code, plant, sales organization, etc. You can find a good collection of SAP study materials, especially SAP FI module configuration at http://www.sapstudymaterials.com They provide screenshots and video of SAP configuration.

Which database in SAP BI/BW is best to use for data that is stored in an InfoCube? Are there separate databases available for SAP, or is Oracle the best option?

SAP BI/BW supports databases, such as Oracle, SQL Server, as well as IBM's DB2 and Informix. Choosing the database depends on various factors like availability, scalability, manageability and security features. Oracle has the most market share and has many features that SAP BI/BW utilizes well.

Since the beginning of movement toward data warehousing, data warehouses have been defined as being:

Subject-oriented. Data is organized around a major object or process of an organization.Classic examples include subject area databases for customer, material, vendor, and transaction.

Integrated. The data from various subject areas should be rationalized with one another.

Nonvolatile. Data in a data warehouse is not updated. Once a record is properly placed in the warehouse, it is not subject to change. This contrasts with a record of data in an online environment, which is indeed very much subject to change.

Time-variant. Arecord is accurate only as of some moment in time. In some cases the moment in time is a single moment. In other cases it is a span of time. But in any case, the values of data found in a data warehouse are accurate and relevant only to some moment in time.

Created for the purpose of management decisions.

The preceding definition has remained unchanged since the inception of the data warehouse. In addition, the data warehouse provides:

Detailed or granular data
Integrated data
Historical data
Easy-access data
The data warehouse is at the center of the business intelligence environment. The data warehouse represents the single version of truth for the corporation and holds data at a granular level. In addition, the data warehouse contains a robust amount of historical data. The need for a data warehouse is as true within the confines of SAP as it is outside of SAP. And the elements of a data warehouse are as valid for SAP as for the non-SAP environment.

The data warehouse evolves from these requirements and supports the process of moving data from source systems, transforming, and cleansing the data so that it may be stored in an integrated data model at an atomic level of granularity. There are many factors that influence the design of a data warehouse and the structure that data records are stored. We discuss some of these factors in the next sections.

http://gleez.com/sap-bw/what-is-a-data-warehouse

http://help.sap.com/saphelp_nw04/helpdata/en/26/64f623fa8911d386e70000e82011b8/content.htm

http://academic.uofs.edu/faculty/gramborw/sap/sapguide.htm

http://www.scribd.com/doc/7805492/2SAP-Business-Planning-and-Consolidation-70-HandsOn-Exercises-for-Business-Planning

http://homepages.wmich.edu/~p5verma/SAP%20FINAL.htm

ILOG OPL-CPLEX Development System with this free trial version
http://www.ilog.com/products/oplstudio/trial.cfm?id=oplfreetrial

Comprehensive SAP Configuration Guide
http://sapdocs.info/sap-general/comprehensive-sap-configuration-guide/

Download...
http://help.sap.com/printdocu/core/Print46c/en/Data/Index_en.htm

SAP Change and Transport management
http://www.sap-press.de/download/dateien/1757/sappress_sap_change_and_transport_management_3..pdf

08_02_SAP_Connector_Basics.rar
Download link: http://www.mediafire.com/file/vcmjeqapywl

ABAP Workbench Tutorial
http://www.pdffiles.org/bc-abap-workbench-tutorial.html

ABAP_Program_Tips_v3.zip
Download link: http://www.mediafire.com/file/zm5mai3b46v

Understanding SAP R/3 A Tutorial for Computer Scientists
http://www.pdffiles.org/understanding-sap-r-3-a-tutorial-for-computer-scientists.html

High Performance Networks for Securing and Delivering SAP
http://www.pdffiles.org/high-performance-networks-for-securing-and-delivering-sap.html

ALE-scenario.zip
Download link: http://www.mediafire.com/file/88awjvgubr7

ale.zip
Download link: http://www.mediafire.com/file/oibmtmvt3jx

ALE_new.zip
Download link: http://www.mediafire.com/file/nwyd4devypk

ALE_programming_Guide.zip
Download link: http://www.mediafire.com/file/lihgdk0hs9g

ALE_quick_start.zip
Download link: http://www.mediafire.com/file/iexpmncafgk

Application_Consultant_June2000.rar
Download link: http://www.mediafire.com/file/kvrvwnxrgzu

Apress.Foundations.of.Java.for.ABAP.Programmers.Mar.2006.rar
Download link: http://www.mediafire.com/file/nkj00klnbng

Balance_Sheet_and_Profit_and_Loss_Statements_in_the_SAP_Business_Information_Warehouse_Exercise.rar
Download link: http://www.mediafire.com/file/zcjkvwac5zv

BC620_SAP_Idoc_Interface_Technology_1_.zip
Download link: http://www.mediafire.com/file/penw7gdf4xr

bdc_programming.zip
Download link: http://www.mediafire.com/file/g3ubot29kfj

BDC_RECORDING_STEPS.zip
Download link: http://www.mediafire.com/file/g6bswmqg0hi

Beginners_guide_for_SAP_XI_Part1.rar
Download link: http://www.mediafire.com/file/r2r1o1zezhj

Beginners_guide_for_SAP_XI_Part_2.rar
Download link: http://www.mediafire.com/file/kg2zqm7ctu0

Building_and_Scaling_SAP_Business_Information_Warehouse_on_DB2_UDB_ESE.rar
Download link: http://www.mediafire.com/file/kq12zmhunym

Business_Task_Management_in_SAP_NetWeaver.rar
Download link: http://www.mediafire.com/file/uh1qyvro5ad

Data_Mining_with_the_SAP_NetWeaver_BI_Accelerator.rar
Download link: http://www.mediafire.com/file/nxrknzpbzni

Database_Administration_Experiences__SAP_R_3_on_DB2_for_OS_390.rar
Download link: http://www.mediafire.com/file/y0vnycdzdvc

datatransfer-FI.zip
Download link: http://www.mediafire.com/file/6ktxesqmdpp

Directinput_Program.zip
Download link: http://www.mediafire.com/file/dtxrdmejgqa

dynamic_SQL_in_SAP.rar
Download link: http://www.mediafire.com/file/dxc4ezurs9i

EDI__IDOC_Interface.zip
Download link: http://www.mediafire.com/file/03yvtnfwemt

End-to-End_Process_Integration_in_SAP_NetWeaver.rar
Download link: http://www.mediafire.com/file/t0jtqmm0lzu

Enhancement_BApi.zip
Download link: http://www.mediafire.com/file/odqjcryjm0w

Enterprise_Data_Warehousing_With_Sap_Bw_-_Overview.rar
Download link: http://www.mediafire.com/file/gjsd3ldlrmj

Enterprise_Reporting_Best_Practices_in_an_SAP_environment.rar
Download link: http://www.mediafire.com/file/gm7kf680ygh

From_SAP_NetWeaver_to_the_Business_Process_Platform.rar
Download link: http://www.mediafire.com/file/g9lb7hiozyl

Get_Ready_for_SAP_Enterprise_Portal_6_1_.0.rar
Download link: http://www.mediafire.com/file/ep0ghpk1zx0

Getting_started_with_SAP_R3_GUI.rar
Download link: http://www.mediafire.com/file/ky8e5y9z6fd

High_Availability_Guide_-_SAP_XI_03_1_.0.rar
Download link: http://www.mediafire.com/file/4zj0dxj2kl0

How_To_Configure_Message_Level_Security_in_SAP_XI_3_0.rar
Download link: http://www.mediafire.com/file/u081jzkwmoj

How_to_Configure_SAP_Web_Dispatcher_for_SSL20.rar
Download link: http://www.mediafire.com/file/itbonvm41zb

How_To_Develop_a_Simple_Web_Service_App_Using_SAP_Netweaver_Dev_Studio_and_XI_3_1_.0.rar
Download link: http://www.mediafire.com/file/lu1e92zut9u

How_to_Install_SAP_Netweaver_2004s_ABAP_Edition_on_Your_Local_PC.rar
Download link: http://www.mediafire.com/file/efoazfegstc

How_To_Scale_Up_SAP_Exchange_Infrastructure_3_1_.0.rar
Download link: http://www.mediafire.com/file/59mwb8may9d

IDocBook.zip
Download link: http://www.mediafire.com/file/c2dv29jnctf

idocs.zip
Download link: http://www.mediafire.com/file/jdyivmlsvc7

Implementing_SAP_R_3_on_OS_400.rar
Download link: http://www.mediafire.com/file/whp7oqyzffr

Installation_Guide_-_SAP_Exchange_Infrastructure_3_1_.0_SR1.rar
Download link: http://www.mediafire.com/file/okdnd1i2qej

Integrating_WebSphere_Commerce_with_SAP_R_3_Using_WebSphere_InterChange_Server.rar
Download link: http://www.mediafire.com/file/kptzhjuqooi

IntegrationSAP_BusinessIntegrationSuite.zip
Download link: http://www.mediafire.com/file/gn747ydgyv7

Interfaces_in_FI.zip
Download link: http://www.mediafire.com/file/g09oizx3nmg

ITS-Install-Guide.zip
Download link: http://www.mediafire.com/file/tqda0hqv5og

John_Wiley_Sons_Sap_Netweaver_For_Dummies_Ebook-Lib.rar
Download link: http://www.mediafire.com/file/1dat2osmwvn

L.K.Lau_-_Managing_Business_with_SAP.rar
Download link: http://www.mediafire.com/file/fawjyvzbfml

LSMW-IDoc_Inbound_Processing.zip
Download link: http://www.mediafire.com/file/bmp6xtggspi

LSMW_1.zip
Download link: http://www.mediafire.com/file/tjwn4s8k039

Managing_Business_with_SAP._Planning_Implementation_and_Evaluation_Jul_2004.rar
Download link: http://www.mediafire.com/file/nmlqoqdiktn

Managing_Business_with_SAP_Planning__Implementation_and_Evaluation_-_Idea_Group.rar
Download link: http://www.mediafire.com/file/fookijvjnyz

Managing_SAP_for_Optimum_Performance_and_Availability.rar
Download link: http://www.mediafire.com/file/enfwrwkvgzl

Managing_SAP_R_3_with_Tivoli.rar
Download link: http://www.mediafire.com/file/caggvgtszgh

Material_Requirements_Planning.rar
Download link: http://www.mediafire.com/file/xufk0tyorbn

Migrating_from_SAP_Enterprise_Portal_to_NW_Enterprise_Portal.rar
Download link: http://www.mediafire.com/file/orydqeaakho

Monitor_performance_with_SAP_Solution_Manager.rar
Download link: http://www.mediafire.com/file/eotzoaxnz2g

Multinational_SAP_Implementation.rar
Download link: http://www.mediafire.com/file/zzk1kx9gbcs

Organize_and_Simplify_Access_to_Unstructured_Information_Using_SAP_EP_Knowledge_Management.rar
Download link: http://www.mediafire.com/file/siveimhn17p

Performance_Tuning_for_SAP_R3.rar
Download link: http://www.mediafire.com/file/mtecujad0jy

S_390_Server_Consolidation_-_A_Guide_for_IT_Managers.rar
Download link: http://www.mediafire.com/file/s3si5c9h5xp

SAP_-_Building_Web_Services_with_Java_and_SAP_Web_Application_Server.rar
Download link: http://www.mediafire.com/file/n6tkbe9842g

Sap_-_Business_Process_Management_-_Build_Your_Own_Workflow_From_Scratch.rar
Download link: http://www.mediafire.com/file/fz1mx7w4y5p

Sap_-_Instalacao_e_Post_NW04_WAS_ABAP_HPUX_Oracle.rar
Download link: http://www.mediafire.com/file/jzyj3hmkvzh

Sap_-_NetWeaver_Master_Guide.rar
Download link: http://www.mediafire.com/file/iq0zbmqviig

SAP_4.6_Basic_Skills_Self-Study.rar
Download link: http://www.mediafire.com/file/5hwxsnkgjaz

Sap_Abap_Certification.rar
Download link: http://www.mediafire.com/file/rd5ba2efxer

SAP_ABAP_Dictionary.rar
Download link: http://www.mediafire.com/file/6ro5vdqoadh

SAP_ABAP_Idoc_Interface.rar
Download link: http://www.mediafire.com/file/czkpg3grfcy

SAP_BASIS_and_Security_Administration.rar
Download link: http://www.mediafire.com/file/dflooxtmxu2

SAP_Business_Information_Warehouse_on_OS_390.rar
Download link: http://www.mediafire.com/file/uoyt9mjpfmf

SAP_Business_Information_Warehouse_on_the_AS_400_System.rar
Download link: http://www.mediafire.com/file/3oyqv5yo6yy

SAP_Business_Workflow_-_Getting_Started.rar
Download link: http://www.mediafire.com/file/orkmne0kwor

SAP_Consultant_Certification.rar
Download link: http://www.mediafire.com/file/mwzi8c2ftjj

SAP_CONTROLS_WORKSHOP.rar
Download link: http://www.mediafire.com/file/kjlghirysxh

SAP_Customizing.rar
Download link: http://www.mediafire.com/file/89msbmhjn7m

SAP_Eng_Construction_VG.rar
Download link: http://www.mediafire.com/file/2h4eblsyfgw

SAP_FI_Transaction_Code_List_1.zip
Download link: http://www.mediafire.com/file/cowmvmggnhe

SAP_Getting_started.rar
Download link: http://www.mediafire.com/file/rdwgvyssmmm

SAP_Glossary.rar
Download link: http://www.mediafire.com/file/wpqatr1szyc

SAP_HR.rar
Download link: http://www.mediafire.com/file/ug6o0szvojr

SAP_Integration_using_ALE.zip
Download link: http://www.mediafire.com/file/zbqzr4nyozu

SAP_ITS_-_Exercise.rar
Download link: http://www.mediafire.com/file/qx75kdjjewz

SAP_ITS_-_Web_Reporting.rar
Download link: http://www.mediafire.com/file/cb40lhmz1ct

SAP_Navigation_Training2.rar
Download link: http://www.mediafire.com/file/b9zvcb8lmf7

SAP_NetWeaver_-_Cross-Component_Business_Process_Management_with_XI_3_1_.0.rar
Download link: http://www.mediafire.com/file/ytm4q3o6ifw

SAP_NetWeaver_2004s_SP-Stack_7.rar
Download link: http://www.mediafire.com/file/iw7a0jtynew

SAP_NetWeaver_Landscape_Strategies.rar
Download link: http://www.mediafire.com/file/t2xgrutnuzc

SAP_overview.rar
Download link: http://www.mediafire.com/file/ce36hlwwmbd

SAP_Paper_Documents.rar
Download link: http://www.mediafire.com/file/ppnbtohow8y

SAP_R_3_on_DB2_UDB_for_OS_390__Application_Servers_on_OS_390.rar
Download link: http://www.mediafire.com/file/vtggl6wwmvd

SAP_Report_painter_-_GRR1.rar
Download link: http://www.mediafire.com/file/ypidtiwxgfi

SAP_RFC_Programming_in_ABAP.rar
Download link: http://www.mediafire.com/file/milzaaoeytn

sap_router.rar
Download link: http://www.mediafire.com/file/hqv5oynuzmr

SAP_Smart_Form_Overview_Brief.rar
Download link: http://www.mediafire.com/file/yyzdblcyuli

SAP_Table_MM.rar
Download link: http://www.mediafire.com/file/ekiwoiud9rn

SAPNetWeaverForDummies.rar
Download link: http://www.mediafire.com/file/j5rjolnv5vw

SAS_Publishing_-_Base_SAS_Guide_to_Information_Maps._2006.rar
Download link: http://www.mediafire.com/file/ubkymqjpklk

TCP_IP_Pots_Used_by_SAP_Applications.rar
Download link: http://www.mediafire.com/file/0oqgh8forml

Teach_Yourself_SAP_R3_in_10_Minutes.rar
Download link: http://www.mediafire.com/file/azytqqprekh

Technical_Consultant_-_Test_Description_-_Final1.rar
Download link: http://www.mediafire.com/file/yykomyzqpgl

Web-Enable_Your_SAP_with_the_power_of_JavaScript.rar
Download link: http://www.mediafire.com/file/p1mvy5sj3nk

WebSphere_Business_Integration_for_SAP.rar
Download link: http://www.mediafire.com/file/hwywtypjakl

What_you_need_to_know_about_SAP_NetWeaver_Exchange_Infrastructure.rar
Download link: http://www.mediafire.com/file/9tzz9vt7mn2

workflow.zip
Download link: http://www.mediafire.com/file/0oivylvdlcg

SAP Product costing
http://www.mediafire.com/?je2xlj9xon2

WMV File walking you through all the steps in LSMW
http://www.mediafire.com/?ymgjyyzeyqg

SAP SRM 6.0 Portal Configuration
http://www.mediafire.com/?dt0dhadtwmy

SAP MM _CIN Configuration
http://www.mediafire.com/?etiebntxtyn

Document Management System is a very small module in SAP but one which can really help you get meaty roles and good rates. There are very few consultants specialized in this module and any one can take up this module.
http://rapidshare.com/files/220944745/DMS.pdf
http://www.mediafire.com/?3mjton2y2mj

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

http://www.sapdb.info/sap-tables/
http://www.henrikfrank.dk/abaptips/appendixes/sap%20tables.htm#accounting

Table Desription
PROJ Project Definition
PRPS WBS Element Master Data
PRTE Scheduling of WBS elements
PRHI WBS element Hierarchy pointer
AFVC Operation within an order Activities
AFVV Scheduling of Activities
AFRU Activity Confirmations
EVPOC Percentage of completion
BPJA Total costs for Annual period CO Object(WBS related Budgets)
RPSCO WBS and Activities /Network related Actual costs
CAUFV View Orders (PP/CO)- Networks

Table Links
1.) Links to PRPS Table
PROJ : PROJ-PSPNR = PRPS-PSPHI
PRTE : PRTE- POSNR = PRPS-PSPNR , PRPS-PSPHI = PRTE-PSPHI
PRHI : PRPS-PSPNR = PRHI-POSNR
AFVC : PRPS-PSPNR = AFVC-PROJN
BPJA : PRPS-OBJNR = BPJA-OBJNR
RPSCO : PRPS-OBJNR = RPSCO-OBJNR

2.) Links to AFVC Table
CAUFV :AFVC-AUFPL = CAUFV-AUFPL
RPSCO :AFVC-OBJNR = RPSCO-OBJNR
EVPOC : AFVC-OBJNR = EVPOC-OBJNR
AFRU: AFVC-AUFPL = AFRU-AUFPL
AFVV: AFVC-AUFPL = AFVV-AUFPL , AFVC-APLZL = AFVV-APLZL

http://www.sapdb.info/list-of-tables-frequently-used-in-the-ps-module/

1. Can you tell me trade spend keys
2 R3 adaptor exists in R3
3. Business Partner category allows you to define number ranges
4. It is not possible to created your own business partner category
5. One role can have multiple data sets
6. In SAP,It is possible to identify duplicate BP master record
7. One relationship category can specify bidirectional relationship
8. Partner role in SAP R3 and classification in CRM used to define the interlinkage
9. Is it mandatory to define different org structure for sales and service
10. It is possible to transfer R3 org structure directly to CRM
11. R3 employee personal master can be transferred to CRM
12. It is possible to use distribution channel to define my CRM org structure
13. I can simultaneously use responsibility rule and org model rule
14. Org model is time dependent
15. Org model (HR) in R3 can be transferred to CRM
16. HR Master Record can be transferred to CRM
17. Terri and org mgt can be used simultaneously
18. User defined attributes can be used to define my CRM org models
19. Both in territory and org mgt it is possible to create different labels
20. It is possible to store inactive BP in CRM system 21. It is possible to store inactive products in CRM
22. Attributes in Product Master is attached directly
23. Will Org determination be triggered first then partner determination
24. Partner determination is done again after doc changes
25. Item cat can be made to be re-determined during copy control
26. Line item status as per R3 partial delivery will get updated in CRM doc
27. It is possible to do the billing of CRM service order in R3
28. In an activity journal template, can we really update material type
29. It is possible to create survey questions which will generate dynamic subsequent questions
30. It is possible to attach 2 alternative partner determination procedure to a transaction
31. When I am defining CRM access sequence, it is possible to refer business logic
32. It is not possible to handle free goods in CRM IPC ? through java codes
33. Is it possible that in partner determination procedure, different partner function can be determined at different times
34. In partner determination procedure, I can use multiple relationship levels
35. Is it possible to used preceding document?s org units during copy
36. Mandatory IPC data loader is needed to pull the data from R3 to CRM system
37. Is it possible to transfer specific objects from R3 to CRM
38. It is possible to combine both the CRM and R3 pricing conditions in one document
39. It is possible to do the same when document is going to R3
40. Is it possible to have CRM variant for 3 levels for products
41. Processing time for action is specified in scheduled conditions
42. Action can be used to trigger a workflow
43. Action can be used to take manual decision
43. Workflow can be used for date driven process
44. Customization from CRM to mobile data can be done through SBDOC
45. Customization from CRM can be pushed to R3 system
46. Consolidated Database is needed for every mBDOC
47. A BDOC can hold only modified fields
48. Hierarchical distribution of business data among CRM ecosystem
49. Publication and subscription are linked one to one
50. Middleware trace functionality can be used to monitor inbound queue
51. Flow context in middleware can be defined using a formula
52. In Solution Manager it is possible to initiate the integration testing
53. Internet Sales is an application that is built using JSP
54. Following application are used using JSP
a. Internet Sales
b. Win client
c. Web client
d. Collaborative Showroom
e. Partner Portal
55. Blueprint table exists in Enterprise portal server
56. How R3 text objects are brought into CRM?
57. How do we integrate the CRM with SAP R/3? Where do we mention the IP address of SAP R/3 server? What else is required?
58. What is the difference between replication and realignment in CRM?
59. What is the difference between an activity and a task in CRM?
60. Can you point out some details of BP ownership in CRM? Specifically, we will be loading channel partners from R/3.
We would like to assign these partners to specific “channel managers.” What constitutes this ownership?
61. Should clients implement both WinClient and WebClient for the IC or only one of them? Could you please explain
this with supporting reasons?
62. Fully grown my SAP CRM is built on the following components
a. CRM central serve
b. SAP R/3 as a back end system
c. SAP BW system as a data ware house solution with comprehensive statistical and analytical possibilities
d. SAP APO as global ATP check and demand planning solution
e. SAP enterprise portal as a tool to provide integrated access to all the systems
63. Can we create Business partner category
64. Business partner group hierarchy
a. A business partner can be assigned to several hierarchies of different categories
b. The business partner GH allows you to group business partners in a multilevel GH
c. Time dependent
d. Groups business partners together in a hierarchy for statistical or analysis purposes
65. The mapping classification from CRM to R/3 in PIDE
a. Consumer (an organization or person)
b. Customer
c. Prospect
d. Competitor
66. What is the organizational unit used for
a. Sales organization is used for pricing
b. The organizational structure can be different from R/3 and has no restrictions regarding usable levels
c. Time stamp
d. You can assign scenario specific attributes to the relevant org units for org. determination, transaction processing, partner determination etc.,
67. Organization data determination can be done using
a. Transaction type
b. Organization structure
c. Business partner
d. Product master
68. Org. data profile is assigned to Transaction Type
69. A holder can be?
a. Occupy positions
b. Is an optional organizational unit
70. Organizational model can be maintained in CRM. Which of the following are true.
a. To assign a user to a position u also need to have master data maintained for the same
b. Can be mapped from CRM to SAP R/3
c. Additional levels in CRM are mapped into R/3 automatically
71. Ways to determine the org units in a document
72. Responsible organizational unit is used for..
a. Derives all other org.units
b. For pricing
c. Equivalent to R/3 plant
d. Is in charge of a business transaction
73. Territory management is used for
a. Reflect the market view of an organization
b. Specifies which products can be offered in a territory
c. Who has the highest revenue
d. Which BP?s belong to a territory
74. Who is responsible for a territory
a. We must link employees with territories via the HR position in org. management
b. Can assign permanently or for a definite time period
75. True for territory management
a. Hierarchies can be time dependent
b. Can use hierarchies for representing territories
c. We can define our own attributes to define a territory
76. Following is true with regard to product categories
a. Initial assignment of products to product categories is done during download from OLTP
b. PC?s are assigned to Ptypes
c. PC can be assigned to many categories
d. Can have hierarchy of product categories
e. If a product type is assigned to a category only products of this type can be assigned to a category
77. Following is true with regard to attributes and set types
a. Attributes are assigned directly to product master
b. Set types are group of attributes or fields corresponding to various database tables
c. Attributes are assigned to set types
d. Set types and attributes can?t be transferred to R/3
78. Mapping of SAP R/3 to SAP CRM with regard to products
a. Material type to R3PRODSTYP
b. Material group to R3MATCLASS
c. Product hierarchy to R3PRODHIER
79. Sales Transactions are
a. Business activity
b. Quotation
c. Sales Order
d. Leads
e. Inquiry?
80. Control attributes in a transaction type
a. BOM explosion
b. Text determination procedure
c. Partner determination procedure
d. Object relation procedure
e. Action profile
f. Number ranges
81. Business transaction category is a control attribute that controls
a. Item category determination
b. Subordinate transaction type
c. Control attributes of transaction type
d. Subordinate item category
82. With regard to copying and creating a follow up document following is true
a. Copy survey
b. Copy control
c. Copy item number
d. Copy pricing agreements
83. In copy control customizing what setting can influence transaction type and
item category determination
a. Copy survey
b. Copy control
c. Copy item number
d. Copy pricing agreements
84. Following is true for texts
a. You define the source text of text types within access sequence
b. The texts are automatically determined in a document or can be entered
c. Can be assigned to transaction type and item categories
85. Which statements are correct for status management
a. It?s controlled by status profile
b. You must assign at least one object type to the status procedure
c. System status can be controlled by system profile
d. User status is set internally by the system
e. Header status is independent of item status except in case of status completed
f. Status profiles can be assigned to transaction type or item category
86. Following is true with regard to incompleteness check
a. Incompleteness check allows you to find out whether a document is complete or not
b. In customizing you define which fields are mandatory for which transaction type and/or item category
c. Incompleteness check is not available on the CRM mobile client
87. Which of these functions are possible on sales transaction in CRM
a. Change price at item level
b. ATP check
c. Document flow
d. Auto creation of delivery document
88. Activity management is an important component of CRM. Which of the following are true
a. Task is transaction replicated to R/3 and mobile client
89. Business activity and task have the following in common
a. Needs a specific date
b. Includes a business partner
c. Have org data
90. Activities and calendar integration
a. Bidirectional data exchange between my SAP CRM middleware and groupware solutions
b. Activities appear in calendar if calendar flag is active for each partner functions and Activity type
c. Activities can be created or changed directly from calendar
91. Fact sheet
92. Order of customizing for partner determination
93. Partner functions necessary for uploading sales order into R/3
a. Sold to party
b. Ship to party
c. Payer
d. Bill to party
e. Employee responsible
94. IPC is required to calculate pricing in CRM. Which of the following are true
a. It consists of SPE, SCE and TTE only. as it also includes data loader and limited product master information
b. IPC accesses CRM database
c. IPC is JAVA based technology
95. Identify the correct statements regarding the pricing in CRM
a. Maintained in CRM. IPC accesses R/3 enterprise
96. Tax calculation
a. The business partner and product tax classification is made by assigning tax groups to the tax types that must be
determined in any given country
b. The tax groups indicate whether a business partner is liable for or exempted from respective tax type that is
imposed
c. The combination of tax group, the country or region and the tax type determines the tax condition record
d. A business partner or a product has not been assigned a tax classification, the default tax group is used
97. True for actions
98. Schedule condition
99. Billing prerequisites
a. Billing unit
b. Number ranges
c. Billing types
d. Item categories
e. Item category determination
100. Data exchange between R/3 and CRM
101. What is Adapters ?
102. Main tasks of R/3 adapter
103. Administration console ?Replication Administration
104. Publisher-Subscriber Concept
105. Load filtering
106. What is a business scenario 46. Key Blocks for people centric CRM
107. What does the role definition determine
a. A task oriented content
108. SAP Net Weaver
109. Three layers of Web Application Server
110. What is business package
111. The delivery mechanism is in the iView studio. Following are the primary functions
a. Informing customers about available packages, worksets, and iViews and making the content available for down load
b. Supporting the develop community in creating new content and offering it to SAP portal customers
c. Delivering updates and patches
112. Functions of Blueprint Application Builder
113. Functions of CRM Designer
114. Blueprint tables
115. IViews are generally displayed through portal pages. You can import predefined pages or create your own. What
does the page definition include
a. iview bundles pages, worksets, roles
b. Pages bundles iviews, worksets, roles
c. List of the pages
d. A list of iviews and associated pages
116. What is role editor needed for?
117. The collaborative business is used for
118. What is the difference between Campaign and Trade Promotion
119. What is the difference between Action & Workflow
120. Do we need to assign workflow in Action
121. Organisation Management determination
122. What are the different organisational determination rule in CRM
123. How the objective and tactics are controlled in Marketing planner
124. Is it possible to create condition record in both crm as well as in R/3. explain in more details
125. Can you give some example of business object, customizing object, conditon object
126. What are the different bdocs available in MW
127. How do you integrate R/3 with CRM
128. What are the different data update in crm through middle ware
129. If i create a new condition record in R/3 how do you sync with crm
130. what are the org.objects available in org.mgt.
131. What are the process of org.mgt
132. can you tell me different rule for org.determination
133. How the vol/trade spend tab is determined in marketing planner, what are the important settings needed
134. Is it possible to create condition record in both crm as well as in R/3. explain in more details
135. Can you give some example of business object, customizing object, conditon object
136. What are the different bdocs available in M
137. How do you integrate R/3 with CRM
138. What are the different data update in crm through middle ware
139. If i create a new condition record in R/3 how do you sync with crm
140. what are the org.objects available in org.mgt.
141. What are the process of org.mgt1
142. can you tell me different rule for org.determination
143. How the vol/trade spend tab is determined in marketing planner, what are the important settings needed

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?

http://www.sapdb.info/sap-sd-frequently-asked-questions-interview-questions/

1. What is ERP?
ERP is a package with the techniques and concepts for the integrated management of business as a whole, for effective use of management resources, to improve the efficiency of an enterprise. Initially, ERP was targeted for manufacturing industry mainly for planning and managing core business like production and financial market. As the growth and merits of ERP package ERP software is designed for basic process of a company from manufacturing to small shops with a target of integrating information across the company.

2. Different types of ERP?
SAP, BAAN, JD Edwards, Oracle Financials, Siebel, PeopleSoft. Among all the ERP’s most of the companies implemented or trying to implement SAP because of number of advantages aver other ERP packages.

3. What is SAP?
SAP is the name of the company founded in 1972 under the German name (Systems, Applications, and Products in Data Processing) is the leading ERP (Enterprise Resource Planning) software package.

4. Explain the concept of “Business Content” in SAP Business Information Warehouse?
Business Content is a pre-configured set of role and task-relevant information models based on consistent Metadata in the SAP Business Information Warehouse. Business Content provides selected roles within a company with the information they need to carry out their tasks. These information models essentially contain roles, workbooks, queries, InfoSources, InfoCubes, key figures, characteristics, update rules and extractors for SAP R/3, mySAP.com Business Applications and other selected applications.

5. Why do you usually choose to implement SAP?
There are number of technical reasons numbers of companies are planning to implement SAP. It’s highly configurable, highly secure data handling, min data redundancy, max data consistency, you can capitalize on economics of sales like purchasing, tight integration-cross function.

6. Can BW run without a SAP R/3 implementation?
Certainly. You can run BW without R/3 implementation. You can use pre-defined business content in BW using your non-SAP data. Here you simply need to map the transfer structures associated with BW data sources (InfoCubes, ODS tables) to the inbound data files or use 3rd part tool to connect your flat files and other data sources and load data in BW. Several third party ETL products such as Acta, Infomatica, DataStage and others will have been certified to load data in BW.

7. What is IDES?
International Demonstration and Education System. A sample application provided for faster learning and implementation.

8. What is WF and its importance?
Business Work Flow: Tool for automatic control and execution of cross-application processes. This involves coordinating the persons involved, the work steps required, the data, which needs to be processed (business objects). The main advantage is reduction in throughput times and the costs involved in managing business processes. Transparency and quality are enhanced by its use.

9. What is SAP R/3?
A third generation set of highly integrated software modules that performs common business function based on multinational leading practice. Takes care of any enterprise however diverse in operation, spread over the world. In R/3 system all the three servers like presentation, application server and database server are located at different system.

10. What are presentation, application and database servers in SAP R/3?
The application layer of an R/3 System is made up of the application servers and the message server. Application programs in an R/3 System are run on application servers. The application servers communicate with the presentation components, the database, and also with each other, using the message server. All the data are stored in a centralized server. This server is called database server.

11. What should be the approach for writing a BDC program?
Convert the legacy system data to a flat file and convert flat file into internal table. Transfer the flat file into sap system called “sap data transfer”. Call transaction(Write the program explicitly) or create sessions (sessions are created and processed ,if success data will transfer).

12. Explain open SQL Vs native SQL?
ABAP Native SQL allows you to include database-specific SQL statements in an ABAP program. Most ABAP programs containing database-specific SQL statements do not run with different databases. If different databases are involved, use Open SQL. To execute ABAP Native SQL in an ABAP program, use the statement EXEC. Open SQL (Subset of standard SQL statements), allows you to access all database tables available in the R/3 System, regardless of the manufacturer. To avoid conflicts between database tables and to keep ABAP programs independent from the database system used, SAP has generated its own set of SQL statements known as Open SQL.

13. What are datasets?
The sequential files (processed on application server) are called datasets. They are used for file handling in SAP.

14. What are internal tables check table, value table, and transparent table?
Internal table: It is a standard data type object, which exists only during the runtime of the program. Check table: Check table will be at field level checking. Value table: Value table will be at domain level checking ex: scarr table is check table for carrid. Transparent table: - Exists with the same structure both in dictionary as well as in database exactly with the same data and fields.

15. What are the major benefits of reporting with BW over R/3?
Would it be sufficient just to Web-enable R/3 Reports? - Performance — Heavy reporting along with regular OLTP transactions can produce a lot of load both on the R/3 and the database (cpu, memory, disks, etc). Just take a look at the load put on your system during a month end, quarter end, or year-end — now imagine that occurring even more frequently. Data analysis — BW uses a Data Warehouse and OLAP concepts for storing and analyzing data, where R/3 was designed for transaction processing. With a lot of work you can get the same analysis out of R/3 but most likely would be easier from a BW.

16. How can an ERP such as SAP help a business owner learn more about how business operates?
In order to use an ERP system, a business person must understand the business processes and how they work together from one functional area to the other. This knowledge gives the student a much deeper understanding of how a business operates. Using SAP as a tool to learn about ERP systems will require that the
people understand the business processes and how they integrate.

17. What is the difference between OLAP and Data Mining?
OLAP - On line Analytical processing is a reporting tool configured to understand your database schema ,composition facts and dimensions . By simple point-n-clicking, a user can run any number of canned or user-designed reports without having to know anything of SQL or the schema. Because of that prior configuration, the OLAP engine “builds” and executes the appropriate SQL. Mining is to build the application to specifically look at detailed analyses, often algorithmic; even more often misappropriate called “reporting.

18. What is “Extended Star Schema” and how did it emerge?
The Star Schema consists of the Dimension Tables and the Fact Table. The Master Data related tables are kept in separate tables, which has reference to the characteristics in the dimension table(s). These separate tables for master data is termed as the Extended Star Schema.

19. Define Meta data, Master data and Transaction data
Meta Data: Data that describes the structure of data or MetaObjects is called Metadata. In other words data about data is known as Meta Data.
Master Data: Master data is data that remains unchanged over a long period of time. It contains information that is always needed in the same way. Characteristics can bear master data in BW. With master data you are dealing with attributes, texts or hierarchies.
Transaction data: Data relating to the day-to-day transactions is the Transaction data.

20. Name some drawbacks of SAP
Interfaces are huge problem, Determine where master data resides, Expensive, very complex, demands highly trained staff, lengthy implementation time.

21. What is Bex?
Bex stands for Business Explorer. Bex enables end user to locate reports, view reports, analyze information and can execute queries. The queries in workbook can be saved to there respective roles in the Bex browser. Bex has the following components: Bex Browser, Bex analyzer, Bex Map, Bex Web.

22. What are variables?
Variables are parameters of a query that are set in the parameter query definition and are not filled with values until the queries are inserted into workbooks. There are different types of variables which are used in different application: Characteristics variables, Hierarchies and hierarchy node, Texts, Formulas, Processing types, User entry/Default type, Replacment Path.

23. What is AWB?. What is its purpose?
AWB stands for Administrator WorkBench. AWB is a tool for controlling, monitoring and maintaining all the processes connected with data staging and processing in the business information whearhousing.

24. What is the significance of ODS in BIW?
An ODS Object serves to store consolidated and debugged transaction data on a document level (atomic level). It describes a consolidated dataset from one or more InfoSources. This dataset can be analyzed with a BEx Query or InfoSet Query. The data of an ODS Object can be updated with a delta update into InfoCubes and/or other ODS Objects in the same system or across systems. In contrast to multi-dimensional data storage with InfoCubes, the data in ODS Objects is stored in transparent, flat database tables.

25. What are the different types of source system?
SAP R/3 Source Systems, SAP BW, Flat Files and External Systems.

26. What is Extractor?
Extractors is a data retrieval mechanisms in the SAP source system. Which can fill the extract structure of a data source with the data from the SAP source system datasets. The extractor may be able to supply data to more fields than exist in the extract structure.

27. Describe how SAP handles Memory Management?
ST02 / ST03 In general via table buffers, you could go into the whole Work Process, roll in, roll out, heap (private) memory, etc. However just as a Unix or DBA admin would know, is you look this up when needed for the exact specifics.

28. Describe where they would look at the buffer statistics, and what steps they would use to adjust them?
ST02, RZ10 …

29. Describe how to setup a printer in SAP or where they would look to research why a user/users can not print?
SPAD, SP01, SM50, SU01 …

30. Can you create a table with fields not referring to data elements?
YES. eg:- ITAB LIKE SPFLI.here we are referening to a data object(SPFLI) not data element. What are the different types of data dictionary objects? tables, structures, views, domains, data elements, lock objects, Match code objects.

31. What should be the approach for writing a BDC program?

STEP 1: CONVERTING THE LEGACY SYSTEM DATA TO A FLAT FILE to internal table CALLED “CONVERSION”.
STEP 2: TRANSFERING THE FLAT FILE INTO SAP SYSTEM CALLED “SAP DATA TRANSFER”.
STEP 3: DEPENDING UPON THE BDC TYPE
i)call transaction(Write the program explicity)
ii) create sessions (sessions are created and processed.if success data will transfer).

32. What are the problems in processing batch input sessions and How is batch input process different from processing online?

PROBLEMS:
i) If the user forgets to opt for keep session then the session will be automatically removed from the session queue(log remains). However if session is processed we may delete it manually.

ii)if session processing fails data will not be transferred to SAP database table.

33. What does an extract statement do in the ABAP program?
Once you have declared the possible record types as field groups and defined their structure, you can fill the extract dataset using the following statements: EXTRACT. When the first EXTRACT statement occurs in a program, the system creates the extract dataset and adds the first extract record to it. In each subsequent EXTRACT statement, the new extract record is added to the dataset EXTRACT HEADER. When you extract the data, the record is filled with the current values of the corresponding fields. As soon as the system has processed the first EXTRACT statement for a field group , the structure of the corresponding extract record in the extract dataset is fixed. You can no longer insert new fields into the field groups and HEADER. If you try to modify one of the field groups afterwards and use it in another EXTRACT statement, a runtime error occurs. By processing EXTRACT statements several times using different field groups, you fill the extract dataset with records of different length and structure. Since you can modify field groups dynamically up to their first usage in an EXTRACT statement, extract datasets provide the advantage that you need not determine the structure at the beginning of the program.

34. Can a transparent table exist in data dictionary but not in the data base physically?
NO. TRANSPARENT TABLE DO EXIST WITH THE SAME STRUCTURE BOTH IN THE DICTIONARY AS WELL AS IN THE DATABASE,EXACTLY WITH THE SAME DATA AND FIELDS.

35. What is the step by step process to create a table in data dictionary?

Step 1: creating domains(data type, field length, range).
Step 2: creating data elements(properties and type for a table field).
Step 3: creating tables(SE11).

36. What is the difference between updated project and end to end project? Explain
Answer1:
Some organisations select to implement SAP module by module, thus gets updated as per their convenience / schedule. This is called as updated project.

Some organisations simply plan all integrated functional modules and decide to go-live with all functional modules and take their entire operations on SAP. This is called as End to End SAP implementation project.

Answer2:
Upgrade Project is a project where in SAP is already in place and it is the version upgrade from a lower end to a higher version.

End to End project is a project where SAP is implemented for the first time.

37. What is Ranking order in automatic payment programme ?
Its the priority assigned to each house bank which helps Automatic Payement program choose the house bank for payment in case there are more than one bank satisfying the payment program.

If a payment program ends up selecting more than one(say 4) bank for payment, the ranking of the banks helps it select one bank from the list of (say 4) selected banks.

38. What is SAP APO?
Answer1:
SAP APO stands for Advanced Planner and Optimizer, which is one area of SCM and application component of MySAP product. Its is designed to provide solutions for companies in Demand planning, network design, supply network planning, production planning and global available to promise, transportation and scheduling.

Answer2:
Prior to SCM4.0 (-APO3.1) APO was a system, now from SCM4.0 APO is a function of SCM not a system as SCM now includes ECH and CM

39. What are the support tickets given in SAP fico module? please give some examples.
Support tickets are basically the problems that arise in day to day usage of SAP. So any sap fico consultant who is resolving the day to day production issues is actually supporting the tickets.

40. How is bank reconciliation handled in SAP?

The following are the steps for BRS:
1. Create Bank Master Data - This can be created through T.Code FI01 or you can also create the house bank through IMG/FA/Bank accounting/Bank account
2. Define House Bank
3. Set up Bank selection payment programe- IMG/FA/ARAP/BT/AUTOIP/PM/Bank selection for payment prg.
a. setup all co codes for payment transaction - Customer and vendors
b.setup paying co codes for payment transactions
c.setup payment method per country
d.setup payment method per co code for payment transaction
e.setup bank determination for payment transaction

Please go for Cheque mangement using T code FCHI (IMG/FA/ARAP/BT/OP/AutoOp/PaymentMedia/ CheckManagement) and for void reasons FCHV. You can create Bank Reconcilliation statement by TC FF67 (SAP/AC/Treasury/CashManagement/Incomings /ManualBankStatement) . Don’t forget to keep the opening Balance as zero. Use FBEA for post process.

All the steps together will lead to (FF67) Bank reconciliation statement.

41. How do you configure electronic bank statement?
Answer1:
Following is the sequence of configuration to be done for Electronis Bank Statment(EBS):
1. create Tranaction types( which helps you group all the house baks with same External transaction code).
2. assign them to house banks.
3 create and define posting rule keys .
4 assign them to external transaction codes.
external transaction codes are bank specific codes for buisness tranactions( which it issues in each EBS) each one for each type of payment. eg. transfer order, foreign transfer,bill of exchange etc.
5 define posting specification for G/L posting as well as subledger posting
6. define account symbols(which determines the G/L account to be posted to) and assign them to posting keys.

Answer2:
1. Create account symbols
2. Create gl accounts ans assign t account symbols
3. Create posting keys:
4. Posting rules
5. Assing external transactions

42. How do you configure manual bank statement?
Configuration is required during electronic bank statement not in manual bank statement. In manual bank statement you just have to enter the data on screen and save it.

43. What is dunning?
Dunning is actually the process by which you “bill” or “invoice” a customer for past due items.
With regards bad Checks for example dunning procedure could follow these steps:

• Step 1: Phone call to customer on receipt of bad check – at this stage, perform the journal posting outlined in section on Returned Checks
• Step 2: Letter to customer (+10 days)
• Step 3: Letter to CO (+7 days)
• Step 4: Legal letter to customer (? DD139) (+13 days)
• Step 5: Issue DD139 (+10 days)
• Step 6: Follow-up on DD139 (dispersing officer) (+45 days)
• Step 7: Write-off (after 6 months)
Steps 2-6 above will be handled by dunning levels in SAP.

Configuration before dunning can be carried out
1. Defining Dunning Area
2. Define Dunning Keys
3. Define Dunning Block Reasons
4. Dunning Procedure
• Define Dunning Procedure (T. Code – FBMP), To set up a Dunning Procedure, the following must be specified: number of Dunning Levels (1-9) Dunning Texts, Standard Text can also be included in the Dunning Texts. Dunning Procedure major parameters: Dunning Interval, Number of Dunning Levels, Grace Period
5. Assign Dunning Procedure to Customer / Vendors Accounts (T. Code – XD02)
6. Define Correspondence Types (T. Code – OB77)
7. Assign Company Codes to Correspondence company Codes
8. Assign Programs for Correspondence Types (OB78)
9. Dunning Run: Transaction Code: F150
Menu Path: accounting > financial accounting > accounts receivable > periodic processing > dunning.
Note: Whenever you schedule more than one dunning run a day, the “Identification” number must change. You may run several dunning runs on the same date but the “Identification” name must be different as well as certain parameters such as the “Dunning Date” and “Documents Posted up to” date.

44. What is the difference between profit center accounting and Profitability analysis ?
Profit center accounting is basically done for internal controlling purposes. It lets you determine the profit and loss using the cost of sale approach or period accounting approach. Here you can find the profit from an “area of responsibility or person” point of view, this is account based costing

Whereas in Profitability analysis, market segments based on product, customer, order or any combination of these are studied to find outs the profit. PA provides information to the marketing, sales and planning department so that they can make decisions. PA has two forms account based and CO based.

Both these are tools for profit management, and both are alternative. They are not same.

45. What are the manufacturing cost of a production?
Material cost + Productions cost = Manufacturing cost

46. What is the difference between stock transfer between two plants belongs to same company code and to that of different company code?

In 1st case it is called as intra company stock transfer and the 2nd case is inter company stock transfer

Stock Transfer between plants of same company code only includes inventory movement without any pricing and so called Stock Transfer Order where Stock Transfer between plants of different company code is same as a purchase order as along with the inventory there is also accounts transfer (pricing) involved.

47. In real time, How listing and exclusion is used?
Listing and exclusion is used in chemical and pharma industries for ex:-Particular customer is not having a valid license of selling some chemical/Medicines and he is ordering the same. in this case listing and exclusion is usefull

48. What is the schema you use in Time Management?
Schema: TC00

49. What is the work relation between SAP-MM, SD and FICO modules?
SAP is the integration of all the modules and the topics are very relevant to each other because basically its management skill set group. From manufacturing the product / goods / services to reaching the customer. All the transaction process is depending on sales area, sales doc, item proposals, shipping, delivery and billing.

50. In SAP-HR, What is the landscape of your project?

Landscape in SAP consists the following:
1. IDES = Training Server
2. Development Server
* Configuration (200 client)
* Sandbox (210 client)
* Data Change (220 client)
3. Quality Server
* Standby (300 client)
* Testing (310 client)
4. Production Server
* Pre-Production (400 client)
* Real Production (500 client)

51. What is the role of ABAPers? What is the Work Bench?
Abaper is a application programmer who retrieves the data from the database and show it to the end-user with the help of report, out of three layers of SAP the abaper position is on Application Layer in which SAP programs are develop and then transported to the Production server…

Workbench… The ABAP Workbench contains several tools that allow you to edit specific repository objects, like ABAP Editor, Menu Painter etc…

52. How to integrate MM With Fico?
Answer1
By using transaction code OBYC we can get the details of MM, Fico integration.

Answer2
Go to IMG settings in Financial accounting and do the configuration for MM-FI settings

Answer3
Value from MM to FI is defined in OBYC…. on the material master the flow of values are assigned on the Costing, Accounting, etc tabs where the system helps to post the necessary stock values into the appropriate GL accounts. Helps to determine, the GL accounts updated when there is a movement of goods.

53. What is difference between business area or cost centre?
Business area is a place where the product or the produced components are valued in group or for the total transactions carried out, Right from procurement, production and sales of goods.

Where as Cost centre is a particular area where the production or the project is taken up and expenditure is identified separately with a separate GL account

54. How to create Tax Calculation Procedure?
Answer1:
Tax calculation procedures based on the countries depended. One country is using deferent of tax procedures. We are creating new country also and at what type calculation procedures present is running on the country and it is assigned which country used.

Answer2:
Tax calculation procedures based on the country wise using and which country is used at what percent and it is used on the country. We are creating new country also at what percent it is used and it is assigned to using of this country.

55. What is the difference between business area and profit center?
Answer1:
Business area is where the total business is valuated as a whole

Whereas Profit centre is an area where the company/work place allows the outside agency to use its machinery for external profits (Ex: A CNC machine which can run 24 hrs a day is utilized in our company for 15 hrs and the balance 9 hrs is let out for addition to the company’s profit) is known as Profit Centre.

Answer2:
Business area is related term to FI module and Profit centre is related to CO module. One business area can have one or more profit centers.

56. What is Legacy System Migration Workbench? How it can be carried out in SAP SD?
Answer1:
LSMW is widely used by EDI programmers. EDI Programmers connect the SAP system to Non SAP system. During this Data migration is a necessity. When data migrates from source to destination the destination code is different from the source code. So what LSMW does is
* Converts the data in to batch files
* Then converts the batch files in to source code batch files
* And then migrates data. Standard Interfaces like BAPI or Idoc are used in this process.

Answer2:
LSMW is used for migrating data from a legacy system to SAP system, or from one SAP system to another.
Apart from standard batch/direct input and recordings, BAPI and IDocs are available as additional import methods for processing the legacy data.

The LSMW comprises the following main steps:
* Read data (legacy data in spreadsheet tables and/or sequential files).
* Convert data (from the source into the target format).
* Import data (to the database used by the R/3 application.

But, before these steps, you need to perform following steps :
* Define source structure: structure of data in the source file.
* Define target structure: structure of SAP that receives data.
* Field mapping: Mapping between the source and target structure with conversions, if any.
* Specify file: location of the source file

57. Of all the methods used for data migration like BDC, LSMW, Call Transaction which one is used most of the time? How is the decision made which method should be followed? What is the procedure followed for this analysis?
All the 3 methods are used to migrate data. Selection of these methods depends on the scenario, amount of data need to transfer. LSMW is a ready tool provided by SAP and you have to follow some 17 steps to migrate master data. While in BDCs Session method is the better choice because of some advantages over call transaction. But call transaction is also very useful to do immediate updation of small amount of data. (In call transaction developer has to handle errors).

Bottom line is make choice of these methods based of real time requirements.

These methods are chosen completely based on situation you are in. Direct input method is not available for all scenarios; else, they are the simplest ones. In batch input method, you need to do recording for the transaction concerned. Similarly, IDoc, and BAPI are there, and use of these need to be decided based on the requirement.

Try to go through the some material on these four methods, and implement them. You will then have a fair idea about when to use which.

58. What is the difference between the stock transfer between two plants belonging to same company code and those belonging to different company code?
Answer1:
A stock transfer from plant to plant generally takes place within a company code. It can, however, also take place between two company codes, if the plants are assigned to different valuation areas, which belong to different company codes.

Unlike a stock transfer from storage location to storage location, a stock transfer from plant to plant affects both accounting and Materials Planning, as follows:

* Accounting
Accounting is affected if both plants are assigned to different valuation areas. This means that a stock transfer leads not only to a quantity update but also to a value update (stock value, G/L accounts). Thus, parallel to the material document for stock transfer, an accounting document is created.

* Materials Planning
Materials Planning is affected because a change of plant stock is taken into account by Materials Planning.

Answer2:
The stock transfer from one plant to another belonging to same company code is same as that of belonging to different company code functionally.

In both the types of transfers, there will be a material document generated which will update the QTY in both the plants in the respective storage location.

Accounting document generation will depend on the valuation level of the material. If the materials are being valuated at company level and it is being transferred from one plant to another belonging to the same company code, no accounting entry is generated. However, if the valuation is being done at plant level, the accounting document will be generated in both the cases.

59. What are the fields in purchasing view?
- RFQ/Quotation
- Purchase requisition
- Purchase order
- Master data (Info record, Source list, Conditions, Vendors etc.)v - Outline agreements

60. How do you create movement types? What are the steps involved? When will you recommend a new movement type?
A movement type can be created using T code OMJJ. Copying an existing movement type and modifying the field contents can create a new movement type.

The SAP system is delivered with some pre-defined movement types from 100 to 899. 900 onwards can be used for customized movement types.

61. What is meant by access sequence? When it is used?
Condition type has an access sequence assigned to it which determines which tables to access for data and in what sequence. This has a sequence of table based on the most specific to most generic. It can be used for any new condition type creation.

62. How does the PO pick up the pricing schema?
The pricing procedure assigned to a vendor has a calculation schema attached to it. This schema defines the various conditions’ pre-requisite, calculation & sequence in the PO. Generally, only one type of pricing procedure is followed for all the vendors.

63. What are the types of special stocks available?
- Consignment stock - vendor
- Components provided to vendor
- Project stock
- Consignment stock – customer
- Pipeline material
- Orders on hand


64. What are the types of inforecords?
- Standard
- Pipeline
- Consignment
- Subcontracting

65. What is meant by consignment stock?
Consignment stock is the material which is lying in the premises but is not owned by the company. It has no value assigned to it until it is taken into own stock. Once it is used in production (or) to be sold, it is taken into own stock.

66. What are the steps involved in consignment cycle?
Consignment cycle is similar to a standard purchase cycle. The difference it that no accounting document is created at the time of goods receipts only QTY is updated.
It is settled once the same is utilized.

Tell me about the subcontracting cycle.
When the material is sent for subcontracting i.e. some value addition, it is converted into a different material. It needs a BOM to define the components of the finished item being received.

67. How is scrap accounted in subcontracting?
The scrap or the process loss can be adjusted while doing a quality inspection of the material received after subcontracting.

68. How are the byproducts taken care of in subcontracting?
Byproducts can be taken care of by defining them in the BOM

Tell me about the various movement types and usage.

101 – GR in unrest. use
103 – GR in Blocked stock
105 – Release from Block to Unrest. use stock.
122 – Return to vendor from unrest. use stock.
124 – Return to vendor from blocked stock
301 - Plant to Plant tfr.
309 – Material to Material tfr.
311 – Tfr. from stg loc to stg loc
261 – Issue for consumption.
411 – Taking consignment stock into own stock.
551 – Withdrawal for scrapping.
Etc.

69. What is the difference between a contract and a scheduling agreement?
A scheduling agreement can be made for Consignment, Subcontracting and stock transfer. A contract, also known as a blanket PO, can be made for standard items and can be restricted to a Value or QTY.

70. How does the system calculate taxes?
Based on the calculation schema of that condition and based on access sequence assigned to it.

71. What are the cutover activities performed in final preparation phase?
This activity involves- Master data upload for objects like customer masters including partner function assignment, customer material info, pricing, outputs and credit masters.

72. How to create a Purchase Order to a vendor who got best rating in Price comparison session (ME49). I wish to create PO from this session directly, explain how can it be created?
Answer1:
Vendor rating has to be done for new purchase order every time. PO can be generated by using transaction ME21N. This PO has to be released after creation
The other way is to assign that item to the vendor and maintain info records and update it by using ME11. This can also be done manually.

Answer2:
This is not possible. Price comparison session only gives you the idea which supplier has given the best price for a particular material. You have to raise the PO ME21N transaction only.

Answer3:
The vendor who has got best price will have a unique quotation number. Use ME21N transaction and create PO with respect RFQ from Overview tab .

73. What is the complete flow of the profit center accounting and Internal orders in controlling?
Profit Centre Accounting:
The following data can be passed on in Profit Center Accounting

* Costs (assessment and/or distribution)
* Revenue and sales deductions (assessment and/or distribution)
* Balance sheet items (distribution)

For this purpose, it is necessary to define cycles containing rules for finding sender-receiver relationships.

Related Activities in Controlling

* Definition of actual assessment cycles
* Definition of plan assessment cycles
* Definition of actual distribution cycles
* Definition of plan distribution cycles

Internal Orders
Internal orders are normally used to plan, collect, and settle the costs of internal jobs and tasks. The SAP system enables you to monitor your internal orders throughout their entire life-cycle; from initial creation, through the planning and posting of all the actual costs, to the final settlement and archiving:
Features
* You can use master data to assign certain characteristics to your internal orders, which enables you to control which business transactions can be used with the internal order.

* Internal order planning enables you to roughly estimate the costs of a job before the order starts and to
make an exact calculation at a later date. You can choose between various planning approaches to compare the effectiveness of different methods.

* You can assign and manage budgets for internal orders.

* You apply the actual costs incurred by a job to your internal orders using actual postings. In Financial Accounting, you can assign primary cost postings (such as the procurement of external activities and external deliveries) directly to internal orders.

* In period-end closing you can use various different allocation methods (for example, overhead costing) to allocate costs between different areas of Cost Accounting.
Order settlement enables you to transfer the costs incurred by an order to the appropriate receivers.

* The information system for internal orders enables you to track planned and assigned costs on your orders in each stage of the order life-cycle.

* You can archive internal orders that you no longer require.

74. What is the one full implementation of life cycle in SAP-BW.?
Full life cycle implementation means implementing the project start from requirement gathering, analysis, solution design, mapping, implementing according to ASAP methodology.

75. How the Price determination process works in SAP-MM?
Price determination process:
Create a Price schema
Add a condition type if required
Assign Access sequence to the condition type.
Create a condition table and specify flds required.
Create a cond. rec. The price schema for the particular mat. has a cond type. This pricing will trigger the Price determination process. Basically the access sequence assigned to the cond type will search the cond table to find the particular cond. rec. and determine the price.

76. What are the activities we will do in SAP MM module implementation?
Various activities in SAP MM are: Inventory, Warehouse, Purchasing, Vendor evolution, Invoice verification etc.

77. Explain what are the steps in the SD process at least up to the invoicing stage
Answer1:
1) pre-sales activity -inquiry,quotation
2) sales-order,
3) inventory sourcing,
4) delivery,
5) pgi,
6) invoicing

Answet2:
SD Inquiry– Quotation—Sales Order—Delivery—Transfer Order—-Post Good Issue—-Billing—Invoicing.

Condition technique :
condition technique means, the combination of
- condition table
- access sequence
- condition type
- procedure
- determination

78. What is the work you have done in the MM module and what programs did you use for creating views in MM?
1. Stock overview for a period can be done by Tcode-MB5B -further giving details like storage location,Plant,Material code,Date..

2. Stock as on date can be viewed by using Tcode-MMBE-further giving details like storage location,Plant,Material code.mail

79. How do you get the Sales Order (S.O) No. from the Delivery Order?
There are 2 ways through which you can see the reference of the documents.
1) Through Document Flow

2) Enter the delivery-> Go at the item level and select TAB PREDECESSOR DATA tab and you can see the reference order number.

80. What is an Open Item in SAP? How will you find an Open Item in SAP?
You can generate a list of open items from the information systems menu option:
* General Ledger: Information system ® General ledger reports ® Line items ® General ledger line items ® G/L line items, list for printing.
* Accounts Receivable: Information system
* ® Reports for accounts receivable ® Customer items ® List of customer open items for printing. Accounts Payable: Information system ® Reports for accounts payable ® Vendor items ® List of vendor open items for printing.

http://www.sapdb.info/sap-interview-questions-general-1-80/