topic Re: MIR7 TABLES in Application Development and Automation Discussions

MIR7 TABLES

former_member538194 — Tue, 15 May 2018 10:27:24 GMT

what table can I get the cost center, profit center, gl account and its description? tried looking but no luck. also tried the link from rbkp to bkpf to bseg but, the bseg table always shows no records found.

please help.

i have to get this data in the tables.

Re: MIR7 TABLES

TammyPowlas — Tue, 15 May 2018 10:31:25 GMT

We linked these tables to get desired information (but please note we do not use profit center):

ekko, eban, csks, rbkp

We ended up having an ABAP report written. Good luck

Re: MIR7 TABLES

RaymondGiuseppi — Tue, 15 May 2018 14:25:07 GMT

You could try

Read invoice data with RBKP, RSEG then for CO data look at RBCO for GL items or EKPO/EKKN for MM items (or use a FM such as BAPI_INCOMINGINVOICE_GETDETAIL)
Then enrich with descriptions looking at tables such as CSKS/CSKT, SKB1/T001/SKAT and CEPC/CEPCT

NB: Don't look for parked documents in BKPF/BSEG, but try VBKPF/VBSEG* tables.

Re: MIR7 TABLES

former_member538194 — Thu, 17 May 2018 00:35:58 GMT

always return no records found! When linking to the bseg.

Re: MIR7 TABLES

RaymondGiuseppi — Thu, 17 May 2018 06:53:38 GMT

MIR7 is "parking" document not "posting" document, read (again) my answer...

Re: MIR7 TABLES

former_member538194 — Thu, 17 May 2018 07:21:50 GMT

same with vbsegs. returning no records found and BAPI_INCOMINGINVOICE_GETDETAIL, doesnt return the complete details.