Question:
hi everybody
i am novice to this co/pa thing and would like any body to give me information about what is co/pa and what are the steps in implementing this datasource and making it available on the biw side.
please help me with this as i have to start work in two days or so.
thanking you
Answer:
Shortly said
COPA is a module in R3 where the structure of the tables are not known when SAP is delivered to the customer;
the structure of the tables itself is determined by the customization made by the people implementing the module;
therefore, there is no standard datasource already defined that you would have to just activate, like for other modules;
instead, you have to generate (generate, not create : you have less work than if you would do everything from scratch) the datasource yourself;
this step is quite easy if the analysis was already done : you just have to locate the options for generating the datasource in SBIW, and follow the steps by choosing which fields you want to upload from COPA to BW (some of the fields are mandatory),
then do the replication and off you go.
For the loading itself, you should always have a delta management, as the volume of the tables is generally HUGE, so you have to make an initialization and deltas ; the delta is based on a timestamp, and when you upload a delta, there is a socalled delta security of 30 minutes, meaning you upload everything up to now minus 30 minutes
depending on the plug-in level, there is no delta capability for account based copa (see below)
miscellaneous
always keep in mind that volume is critical within copa (most of the time)
if you generate a datasource in DEV 100 and want to use it in PRD 200 (other mandant), there are some tricks
the underlying tables are not the same if you speak about COST based COPA (CE1*...) or ACCOUNT based COPA (COEP...)
you will read stuff around summarization level and so on, forget about it at the moment, most of the time you don't use it
...and many others, as you are working in BW (should I say SAP?)
documentation
I am pretty sure there is a white paper on sap network about implementing COPA, but don't remember if that's for a specific problem or a generic solution
all the SAP course materials I read about extraction does always contain a whole chapter about COPA extraction
the online help will not help you much at this stage of your development
you've got two days : do a search on this forum using keyword 'COPA', read everything even if you don't understand, you will remember when needed that the solution of your problem is here
experts
El Belgio is one of them here around
(don't PM him and don't write 'urgent' in your posts, and he will try to help you)
wishes
Good luck
Ch
PS : rock, register and send me a PM
disclaimer
adviser is not a payer, I may write erroneous things here, I hope somebody else will correct me if needed
referenceCHC
This is only a tag to easily find this message back to show people that are complaining about the fact I am not always kind with people asking too generic quesitons