Cost Cetner Account Reports

Posted on 2007-08-09
Last Modified: 2013-12-08
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?

Question by:wagnerrc141
    LVL 1

    Accepted Solution

    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.
    LVL 1

    Expert Comment

    Forced accept.

    EE Admin

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Suggested Solutions

    Note: You must have administrative privileges in order to create/edit Sharing Rules. ( (SFDC) is a cloud-based customer relationship management (CRM) system. It is a database most commonly used by sales an…
    "Disruption" is the most feared word for C-level executives these days. They agonize over their industry being disturbed by another player - most likely by startups.
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    794 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now