Loading Data From a Data Target

Loading Data From a Data Target

Can you please guide me for carrying out his activity with some important steps?

I am having few request with the without data mart status. How can I use only them & create a export datasource?

Can you please tell me how my data mechanism will work after the loading?

Follow these steps:

1. Select Source data target( in u r case X) , in the context menu click on Create Export Datasources.
DataSource ( InfoSource) with name 8(name of datatarget) will be generated.

2. In Modelling menu click on Source Systems, Select the logical Source System of your BW server, in the context menu click on Replicate DataSource.

3. In the DataModelling click on Infosources and search for infosource 8(name of datatarget). If not found in the search refresh it. Still not find then from DataModelling click on Infosources, in right side window again select Infosources, in the context menu click on insert Lost Nodes.
Now search you will definately found.

4. No goto Receiving DataTargets ( in your case Y1,Y2,Y3) create update rules.
In the next screen select Infocube radio button and enter name of Source Datatarget (in u r case X). click Next screen Button ( Shift F7), here select Addition radio button, then select Source keyfield radio button and map the keyfields form Source cube to target cube.

5. In the DataModelling click on Infosources select infoSource which u replicated earlier and create infopackage to load data..

Data load in SAP BW

What is the strategy to load for example 500,000 entries in BW (material master, transactional data)?

How to separate this entries in small packages and transfer it to BW in automatic?

Is there some strategy for that?

Is there some configuration for that?

See OSS note 411464 (example concerning Info Structures from purchasing documents) to create smaller jobs in order to integrate a large amount of data.

For example, if you wish to split your 500,000 entries in five intervals:

- Create 5 variants in RMCENEAU for each interval
- Create 5 jobs (SM36) that execute RMCENEAU for each variant
- Schedule your jobs
- You can then see the result in RSA3

Reflection

Walking into the sunlight filled field
With the weeping willow slowly dancing in the warm breeze,
The lake smooth on the surface even though
Underneath life flourishes,
Off in the distance there is a deer running back into the woods.
Always dreaming of the simplicity of that life,

Sitting in this picture perfect landscape thinking to myself.
Why must we make life so difficult?
Every once in awhile you need to stop and enjoy the scenery,
Because life isn’t about how much power you have
Or how many friends you have,
Life is about trying to find what makes you happy
And not getting caught up in the everyday nonsense.
This field put everything into perspective,
If you rush through life and never stop to look around
Have you ever really lived?

Be Positive To Be Creative

Negative attitude I strongly condemn
As it brings hope to the bottom
Moults confidence like an autumn
And makes heart a melancholy-drum

Our potential becomes infinite
If we strongly hope every minute
Will-power is mind’s main kit
Which makes success definite

Free the mind of cowardice-mask
With great care study the task
Will efforts suffice? Every day ask
With complacency never bask

When the task to achieve is mammoth
The road to reach it can never be smooth
Stones will laugh with sharp teeth
Determination alone can close each mouth

With rules of hard-work have strict compliance
Use brain which is the very best appliance
Ever develop with confidence an alliance
In goals never at all make any variance

Compete, compete, and compete
Ever with a true winning spirit
Allow not courage to split
The task, we will surely complete

Happiness gives a shining skin
Hard-work powers the bone within
Hope supplies courage-vitamin
Thought and soul prayers pin

If thoughts run helter-skelter
Pray to God to provide shelter
Offer tears on the holy altar
Mind will alter as prayers filter

Chewing the past is a postmortem
Which will spoil your AM and PM
Instead pray through a hymn
And find in hard-work asylum

Let him be Newton, Milton, Dalton or Washington
For all of us God is the one and only captain
His blessings come through prayer-fountain
And give us strength to move a mountain.

Once...

I had you once for a very short time,
and the memories we shared I stored in my mind.
I relish the memories that we once knew,
I only hope you remembered them too.

You gave me my wings and taught me to fly,
You didn’t hold me back you showed me the sky.
You gave me the world on a silver tray,
And taught me how to love and the games that people play.

You gave it all but you’ll never know,
Just how much you helped me grow

Just let me sleep

What is worse than empty lined paper,
lying in front of you?

A pencil moving light and slowly,
beautifully but tired, over the sheet?

Drawing circles in your head,
but on the paper nothing is written?

The head upon the pillow,
the eyes are nearly closed. Dreaming far away.

In this dream, nothing has changed. Bright it is,
and oh, so wonderful.

Dreams turns into nightmares. Nightmares into reality.
Reality is once again worse than dreams.

What is then worse than empty lined paper?
Reality I tell you my friend.

Does she really know it ?

You don’t know

Don’t you know that I have cared about you,
That I fall just for you
That I cried because of you
That I could die for you.

Don’t you know that I live just for you,
That I dream just for you
That I laugh just for you
That I hope just for you

Don’t you feel my great love just for you,
My dreams I have offered you
My pain each time you cry
My joy each time you smile.

Don’t you see what’s deep inside of me,
What’s in the very heart of me
Don’t you see, yes you really don’t care
Because you don’t know me after all.

i luv this one !

we grow stronger

the years pass and we grow stronger
when our days grow shorter and nights longer
just know ill always be there for you
a place to cry somewhere for comfort and truth

im so happy you became my best friend
no real beginning and no real end
this friendship we have is superior and strong
unbreakable, like an ionic bond

we may go up we may go down
sometimes our smiles will be frowns
but we’ll work through it, me and you
cuz thats what best friend do!

Nashili shayari !

1. Log kehte hain bada dard hota hain pyar karne ke baad,
hume toh bada dard huwa tha police ne gand pe waar karne ke baad !.... Mr Rajeshwar :P
2.kisi ne kaha tha hume toh apno loota gairo main kaha dum tha,
hamari kashti toh dubi thi waha jaha paani toh boot tha lekin saala kya kare DAARU kam tha !
3. Koi Mila Hi Nahi Jis Ko Wafa Dete
Har Ik Ne Dokha Diya Kis Kis Ko Saza Dete
Ye Hamara Dil Tha Ke Khamosh Rahe Warna
Daastan Sunatey To Mehfil Ko Rula Data

4.Nafrat Thi Humse To Izhaar Kyu Kiya?
Dena Tha Zehar To Pyar Kyu Kiya?
Dekar Zehar Kehte Ho Pina Hi Hoga
Aur Jab Pee Gaye Zehar
To Kehte Ho Ab Jeena Hi Hoga.

5.Koi Dikah Ke Roay Koi Chupa Ke Roay
Hamein Rulane Wale Hameain Rula Ke Roay
Marne Ka Maza To Tab Hai
Jab Qatil Bi Janaze Pe Aa Ke Roay.

6.Dosti Ka Haq Hum Youn Ada Kartay Hain
Dost Ke Naam Per Jan Fida Kartay Hain
Tumhey Phool Ka Zakham Bhi Na Anay Pae
Allah Say Roz Yeh Dua Kartay Hain.

7.Wada Karte Hain Dosti Nibhayenge
Koshish Yahi Rahegi Tujhe Na Satyaenge
Zarurat Pade Toh Dil Se Pukarana
Mar Bhi Rahe Honge To Mohlat Lekar Aayenge.

8. log kehte hain ki hum ladki na pata paye, hum qayar hain

lekin un kambakhto ko kya pata, ki hum bade SHAAYAR hain !

9.Aankh ke kinare bhige nahi,
Aur woh samjhe ke hum roye nahi,
Poochte hain kal raat sapne mein kisko dekha,
par woh kya jaane hum ek arse se sooye nahi.

10.Premi aksar jaan gavaya karte hain apni premika ke liye,

un kambakto se pooncho kabhi unhone apni jaan gawayi hain apne MAA-BAAP ke bhoomika ke liye !

11. Log aksar chodt jate hain marne ke baad apni yaade,
isiliye karjaoe aise kuch baatien jien se tal jaye dard bhari raatien !

12.khuda kare hume DAARU naseeb ho maszid main,

ya toh phir aisi jagah dikao waha khuda nahi hain !

13.Mohabat ka ajab karobar humne kia
Wo bewafa sahi magr pyar humne kia
Agr wo chor gaya tu mat kaho bura usko
Kasor uska nai aitebar humne kia.

14. jindagi main aisa kuch karke dikhao ki duniya tumhe bhool na paye,

lekin aisa kuch na karo jise duniya BHOOL na paye !

15.kya tum yaad rakho ge apni jindagi saath bitane ke baad,

ya phir yaad karoge is kambakth maut ke aane ke baad !

16.har ek ko kisiko har ek cheez ka hisaab dena hain,

are lavde ye lavde ye mat soch kitna kamana hain ye dekh kitna gawaya hain.

17.kisi na kisiko ek din ye duniya chod ke jana hain,

ye waqt toh har ek ke jindagi main kabhi na kabhi toh aana hain

hume toh kuch aisa kar dikhana hain, ki humare is jindagi se tashrif hone ke baad sabhi ko rulana hain !

18.ye banda toh pita hain sirf ek kaam ke liya

lekin ye shayar toh pita hain kisi EK jaam ke liye !

kyonki is jaam ke saath ek rangin shaam ho aur jaam ke saath kuch na kaam ho !

19.hum toh sharab piya karte yaadon ke chakne ke saath,

un yaadon ke yaad karte hain pi ke behek ne ke baad !

20.kabhi kabhi sochta hoon ek haath main jaam ho aur ek bewafa shaam ho,

lekin saala uske sath na koi DAAM ho !

21. socte hain hum k hume koi yaad karle,

ya toh abhi, ya marne ke baad karle..

22. jindagi main socha tha ki bohot kuch karna chahte the lekin kuch bhi na kar sake,

haath main ek jaam aur uske siwa kuch sambhal na sake !

23. aashiyane ka intezaar kiya tanhayi main, wafa ka intezaar kiya bewafai main

lekin ye jannat ka intezaar kiya toh bas ek DAARU mili.

24.log aksar maara karte hain bekhudi ki jindagi jine ke baad,

aur hum jaise shayar bola karte hain DAARU pi ne ke baad !

just all over ma head !

SAP Modules questions and answers

• What is the difference between updated project and end to end project. please explain
• What is Ranking order in automatic payment programme ?
• What is SAP APO?
• What are the support tickets given in SAP fico module? please give some examples.
• How is bank reconciliation handled in SAP?
• How do you configure electronic bank statement?
• How do you configure manual bank statement?
• What is dunning?
• What is the difference between profit center accounting and Profitability analysis ?
• What are the manufacturing cost of a producting?
• What is the difference between stock transfer between two plants belongs to same company code and to that of different company code?
• In real time, How listing and exclusion is used ?
• What is the schema you use in Time Management?
• What is the work relation between SAP-MM, SD and fi/co modules?
• In SAP-HR, What is the landscape of your project?
• What is the role of abapers? What is the Work Bench?
• How to integrate MM With Fico?
• What is difference between business area or cost centre?
• How to create Tax Calculation Procedure?
• What is the difference between business area and profit center?
• What is Legaccy System Migration Workbench? How it can be carried out in SAP SD?
• What is the difference between the stock transfer between two plants belonging to same company code and those belonging to different company code?
• What are the fields in purchasing view?
• How do you create movement types? What are the steps involved? When will you recommend a new movement type?
• What is meant by access sequence? When it is used?
• How does the PO pick up the pricing schema?
• What are the types of special stocks available?
• What are the types of inforecords?
• What is meant by consignment stock?
• What are the steps involved in consignment cycle?
• Tell me about the subcontracting cycle.
• How is scrap accounted in subcontracting?
• How are the byproducts taken care of in subcontracting?
• Tell me about the various movement types and usage.
• What is the difference between a contract and a scheduling agreement?
• How does the system calculate taxes?
• What are the cutover activities performed infinal preparartion phase ?
• How to create a Purchase Order to a vendor who got best rating in Price comparision session (me49). I wish to create PO from this session directly, explain how can it be created?
• What is the complete flow of the profit center accounting,and Internal orders in controlling
• What is the one full implementation of life cycle in SAP-BW.?
• How the Price determination process works in SAP-MM?
• What are the activities we will do in SAP MM module implementation?
• Explain what are the steps in the SD process at least up to the invoicing stage
• Condition technique
• What is the work you have done in the MM module and what programs did you use for creating views in MM?
• How do you get the Sales Order (S.O) No. from the Delivery Order?
• What is an Open Item in SAP? How will you find an Open Item in SAP?

GOSHHHH !

In the past when people were discussing SAP, the conversation very quickly boiled down to modules, for example: SAP’s courses were structured along module lines so that you would attend MM 101, 102 and 103. While at the course you would learn many things about MM, but not much about the rest of the SAP system and how MM fits into it. A conversation with a SAP recruiter might go something like this: Recruiter … “which modules do you work with?”Candidate … “well, I have a lot of purchasing process experience” Recruiter … “yes, but which modules do you work with?” Candidate … “well, it’s purchasing functionality … so that would be, umm, MM, FI and CO mainly” Recruiter … “great I have just the job for you” Candidate … “fantastic, is it purchasing?” Recruiter … “well it says here that they want an MM, FI and CO person and that’s you, right?” Not necessarily! A MM, FI, CO role might include Inventory Management (MM), Accounts Receivable (FI) and Profitability Analysis (CO) – none of which a purchasing person is guaranteed to have Many programme teams were organised along module lines, so that you would have a FI/CO, an MM and a HR team, for example. Training courses were (therefore) often prepared and delivered along module lines too. The result of this was that solutions were frequently optimised along module lines, and less often well integratred, and as for users, well, they were pretty much trained up in a module and left to get on with it post go-live. Fortunately those days are mostly passed, and more and more programmes (from design to build to training) are being organised along process lines such as: Order to Cash (including parts of SD, FI-AR and probably TY as well) Purchase to Pay (including MM-Purchasing and FI-AP) Record to Report (FI-GL etc) SAP now are moving away from describing their system as a set of modules, and now are using the term ‘solutions’, which is much better, as follows: Financials Human Resources Customer Relationship Management Supplier Relationship Management Product Lifecycle Management Supply Chain Management Business Intelligence If you’re still looking for that list of modules, here they are:
	FI Financial Accounting (Online Training, Tutorial, SAP Access) – essentially your regulatory ‘books of record’, including General ledger Book close Tax Accounts receivable Accounts payable Consolidation Special ledgers
	CO Controlling (Online Training, Tutorial, SAP Access) – basically your internal cost/management accounting, including Cost elements Cost centres Profit centres Internal orders Activity based costing Product costing AM Asset Management (Online Training, SAP Access) – track, value and depreciate your assets, including Purchase Sale Depreciation Tracking PS Project Systems (Online Training, SAP Access) – manage your projects, large and small, including Make to order Plant shut downs (as a project) Third party billing (on the back of a project) HR Human Resources (Online Training, SAP Access) – ah yes, people, including Employment history Payroll Training Career management Succession planning PM Plant Maintenance (Online Training, SAP Access) – maintain your equipment (e.g. a machine, an oil rig, an aircraft etc), including Labour Material Down time and outages MM Materials Management (Online Training, SAP Access) – underpins the supply chain, including Requisitions Purchase orders Goods receipts Accounts payable Inventory management BOM’s Master raw materials, finished goods etc QM Quality Management (Online Training, SAP Access) – improve the quality of your goods, including Planning Execution Inspections Certificates PP Production Planning (Online Training, SAP Access) – manages your production process, including Capacity planning Master production scheduling Material requirements planning Shop floor SD Sales and Distribution (Online Training, SAP Access) – from order to delivery, including RFQ Sales orders Pricing Picking (and other warehouse processes) Packing Shipping CA Cross Application (Online Training, SAP Access) – these lie on top of the individual modules, and include WF – workflow BW – business information warehouse Office – for email Workplace Industry solutions New Dimension products such as CRM, PLM, SRM, APO etc Go here to see our full list of our best SAP Tutorials, including one on the SAP FI Module and one on the SAP CO Module. If you need more go here to find over 450 more pages of free SAP Articles. We hope you have enjoyed reading this article. If you are interested in learning more, check out the online SAP training courses offered by Michael Management Corporation Cost Centre Accounting Internal Order Accounting Profit Centre Accounting Revenue Accounting Asset Accounting Investment Management Project System Legacy System Migration Workbench (LSMW) SAP Query Report Design SAP Solution Manager (SOLMAN) ... and many more covering all parts of SAP ...

I think life might go around THIS !

What is the?
SAP FI Module
- Introduction -

Page 1 of 4

Introduction

The SAP FI Module has the capability of meeting all the accounting and financial needs of an organization. It is within this module that Financial Managers as well as other Managers within your business can review the financial position of the company in real time as compared to legacy systems which often times require overnight updates before financial statements can be generated and run for management review.

The real-time functionality of the SAP modules allows for better decision making and strategic planning. The FI (Financial Accounting) Module integrates with other SAP Modules such as MM (Materials Management), PP (Production Planning), SD(Sales and Distribution), PM (Plant Maintenance),and PS (Project Systems).

The FI Module also integrates with HR(Human Resources) which includes PM(Personnel Management), Time Management, Travel Management, Payroll.Document transactions occurring within the specific modules generate account postings via account determination tables.

The FI (Financial Accounting) Module components.

The FI Module comprises several sub-modules as follows:

• Accounts Receivables
• Accounts Payable
• Asset Accounting
• Bank Accounting
• Consolidation
• Funds Management
• General Ledger
• Special Purpose Ledger
• Travel Management

Accounts Receivables records all account postings generated as a result of Customer sales activity.

These postings are automatically updated in the General Ledger . It is within the Accounts

Receivables Module that you can monitor aging of the receivables and generate customer analysis. The Accounts Receivable Module also integrates with the General ledger, Sales and Distribution, and Cash Management Modules.

Accounts Payable records account postings generated as a result of Vendor purchasing activity. Automatic postings are generated in the General Ledger as well. Payment programs within SAP enables the payment of payable documents by check, EDI, or transfers.

Asset Accounting is utilized for managing your company’s Fixed Assets. SAP allows you to categorize assets and to set values for depreciation calculations in each asset class.

Bank Accounting allows for management of bank transactions in the system including cash management.

Consolidation enables the combining of financial statements for multiple entities within an organization. These statements provide an overview of the financial position of the company as a whole.

Funds Management allows management to set budgets for revenues and expenses within your company as well as track these to the area of responsibility.

General Ledger is fully integrated with the other SAP Modules. It is within the General Ledger that all accounting postings are recorded. These postings are displayed in real-time providing up-to-date visibility of the financial accounts.

Special Purpose Ledger is used to define ledgers for reporting purposes. Data can be gathered from internal and external applications.

Travel Management provides management of all travel activities including booking trips and handling of expenses associated with travel.

Page 2 of 4

Primary configuration considerations:

Client, company and company code

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

The Organizational structure is created by defining the organizational units consisting of the following:

• Client
• Company
• Company Code
• Business Area

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

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

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

When defining company codes, the following key areas must be updated:

• Company Code Key- identifies the company code and consists of four alpha-numeric characters. Master data and business transactions are created by this key.

• Company Code Name- identifies the name of the business organization within your organizational structure.

• Address- identifies the street address, city, state, zip code for the company code created. This information is also used on correspondence and reports.

• Country- identifies the country to which your business is based. Country codes within SAP are based on ISO Standards.

• Country currency- identifies the local currency for the company code that you have defined.

• Language- identifies the language to be used for you company code and is also used for text in your documents. SAP unlike other applications, offers over thirty languages including EN( English) , ES (Spanish), FR (French), DE (German), EL (Greek), IT(Italian), AR( Arabic), ZH (Chinese) , SV (Swedish) , and JA (Japanese) to name a few.

Page 3 of 4

More FI configuration considerations:

Business Area, COA, GL, Fiscal year and Currencies

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

Another configuration requirement for set-up in SAP are the Basic settings consisting of the following:

• Chart of Accounts(COA)
• Fiscal Year Variants.
• Currencies

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

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

• Control data of the GL Account is where currency is specified, Tax category (posting without tax allowed) , marking the account as a reconciliation account ( e.g. Customer, Asset, Vendors, Accounts Receivable) or not.
• Marking the G/L Account as a “reconciliation” account allows for postings to an Asset Account ( for example) as well as automatic update to the G/L Account.
• Configuration prevents direct postings to reconciliation accounts thereby assisting in maintaining integrity of the data.
• This allows reconciliation between the sub-ledger and general ledger to always be guaranteed.
• Within the General Ledger control data , you can also designate whether line item display is possible in the account. The system then stores an entry per line in an index table which links back to the account. (Display of line item details are then available for reporting purposes ,etc.)
• Open Item Indicators can be set on the G/L Account allowing for better management of open items. Examples include: Bank Clearing Accounts, GR/IR Clearing Accounts, Payroll, etc.

Fiscal Year configuration is a must and can be defined to meet your company’s reporting periods whether Fiscal (any period combination that is not calendar) or Calendar( Jan-Dec).

• Posting Periods are defined and assigned to the Fiscal Year.
• Within the periods you specify start dates and finished dates.
• SAP allows for 12 posting periods along with specially defined periods that can be used for year-end financial closing.

Currencies are another basic configuration setting requirement which defines your company’s legal means of payment by country.

• It is recommended that all Currency set-ups in SAP follow the ISO Standards.
• The ISO Standards ensure Global conformity across businesses worldwide utilizing SAP.

Page 4 of 4

What are some of the integration points of the FI module?

SAP is marketed as a fully integrated system, therefore knowing some of the integration points enables the Users to better understand the Modules.

· Organization units are not only defined in FI(Financial Accounting) but also in other SAP Modules. The SD( Sales & Distribution) Module requires the set-up of Sales Organizations, Distribution Channels and Divisions ; Purchasing requires purchasing organizations, plants, and storage locations; and CO (Controlling) requires a Controlling area to be defined.

· To transfer data between FI(Financial Accounting) and CO (controlling) as well as other modules, a Company Code must be assigned to each of the Modules.

· Business Areas must be entered when generating business transactions if you would like visibility of those transactions impacting a certain BA(Business Area). You can also update your Master Records to include BA(Business Area) for example Cost Center.

· Document postings are automatically posted in the year and periods that you created in the Fiscal Year variant set-ups based on the month, start and end dates to which postings are allowed within a given period as defined.

· There are several integration points in SAP, the above lists a few .

We hope you have enjoyed reading this tutorial. If you are interested in learning more, check out the online SAP training courses offered by Michael Management Corporation

General Ledger Accounting

Accounts Receivable

Accounts Payable

FI Basic Reporting

FI Advanced Reporting

Asset Accounting

Investment Management

Project System

... and many more covering all parts of SAP

Recession hit me finally !

So i want d exception for recession ! rite now no job... lookin for it but not gettin than a blow job at any interview. packages suck. work timings suck ! everybody on this planet SUCK !