0

How can I get the cost center, profit center? I am from RSEG and RBKP tables is there any other way to get those, I can't use vbseg tables cause the doc no. are stored in RSEG and RBKP since I created the document using MIR7. please help. thanks

Sandra Rossi
  • 11,934
  • 5
  • 22
  • 48
Kjarlvi
  • 126
  • 1
  • 13
  • What data do you have? Full key from `RBKP` and `RSEG`? And wanna get profit center (`PRCTR`) and cost center (`COSTL`)? – Suncatcher Apr 10 '18 at 06:03
  • have the document number or belnr from rseg, how can I get the PRCTR and KOSTL? do you have any Idea? – Kjarlvi Apr 10 '18 at 06:29

1 Answers1

2

Firstly you should find accounting document number from invoice number (RBKP-BELNR). You can do this by two ways:

  1. Via reference key (AWKEY). You should concatenate fields BELNR and GJAHR and link this with BKPF-AWKEY.

enter image description here

  1. Another way to find this number is via GUI. Enter your RBKP-BELNR into MIRO transaction and press Follow-on documents, here you will see it as well.

enter image description here

After finding that BKPF number take it along with full key and go to BSEG. You will find cost center there (KOSTL field).

Profit centers can be found by cost centers from CSKS link-table.

Suncatcher
  • 10,355
  • 10
  • 52
  • 90
  • I tried both of the method you instructed, but it doesn't work. i tried to concatenate the belnr and the gjahr but there's no data. btw i made the document in MIR7 Tcode. – Kjarlvi Apr 10 '18 at 08:19
  • what means 'no data'? no data in BKPF? and what shows MIRO? – Suncatcher Apr 10 '18 at 08:23
  • the document number given in miro does not exist in bkpf or bseg. i filtered the bkpf using the given doc no in the miro but no data was shown. – Kjarlvi Apr 10 '18 at 08:45
  • 1
    Bullshit. This cannot be, 'cause all accounting documents are stored in `BKPF`. Did you copy exactly accounting doc number, not any other follow-on doc (there are plenty of them)? Does your screenshot looks like mine? – Suncatcher Apr 10 '18 at 09:02
  • Quick reminder that swearing words are discouraged ;) – geisterfurz007 Apr 10 '18 at 09:04
  • i got it! thanks @Suncatcher , You're a legend. Thank you!! – Kjarlvi Apr 11 '18 at 01:05