• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1770
  • Last Modified:

Cost Cetner Account Reports

I would lke to extract the cost center spend data from SAP into SQL Server. We have SAP BW 3.1; however, the Bex explorer is difficult for data presentation. My problem is finding the relationship between cost center and their line items in the SAP R3 tables. I have looked thru the digrams online for FI/CO and still do not see the relationship between cost center and the line items in tables (for example how can I relate COEP (line items by period) to CSKS (Cost Center Master Data) or whatever tables that can give me cost center to line item relationship?

0
wagnerrc141
Asked:
wagnerrc141
1 Solution
 
tbarbe01Commented:
The cost object (ie, Cost Center, Internal Order, WBS Element, etc.) is populated in the field OBJNR in COEP.  For cost centers, the Cost Object is broken down by the characters in the field as follows:

1 - 2 = 'KS' for Cost Center
3 - 6 = Controlling Area
7 - 16 = Cost Center

So, in order to join the two tables, you have to have some coding that will state something like this:

If COEP-OBJNR(2) = 'KS' and
   COEP-OBJNR+2(4) = CSKS-KOKRS and
   COEP-OBJNR+6(10) = CSKS-KOSTL.
 . . . .
End if.

Hope this helps.
 
0
 
Computer101Commented:
Forced accept.

Computer101
EE Admin
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now