Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rcandeo
Creator III
Creator III

which tables are used for KSB1?

I'm using SAP Connector and need help finding in which tables are the data for KSB1 aplication.

I've found something in COBK and COEP but there's more table involved since I didn't find all data.

Somente can help me please?

Regards.

Robson

1 Solution

Accepted Solutions
disqr_rm
Partner - Specialist III
Partner - Specialist III

Hi Robson

Sunil is correct with COSP, the only problem would be that it would give you aggregated figures, which may be fine with your requirements but if you would like to be able to link to source transactions and make it drill-down-able, you may want to go with COBK & COEP route.

In COEP you can filter out records based on your requirements. For this you may use field VRGNG contents. For example, if you are looking for cost postings you could include VRGNG = COIN, for direct postings you can include RKL records. Just keep in mind that COEP contains both transaction postings and Settlement posting, so if you don't filter out the net would be zero. If you want to report what has been settled, you could go after KOKA and KOAO records.

Going after COEP is little extra efforts, but as soon as you link up other tables based on OBJNR and other fields, you would be smiling. 🙂

Good luck!!!

Rakesh

View solution in original post

6 Replies
suniljain
Master
Master

COSP

disqr_rm
Partner - Specialist III
Partner - Specialist III

Hi Robson

Sunil is correct with COSP, the only problem would be that it would give you aggregated figures, which may be fine with your requirements but if you would like to be able to link to source transactions and make it drill-down-able, you may want to go with COBK & COEP route.

In COEP you can filter out records based on your requirements. For this you may use field VRGNG contents. For example, if you are looking for cost postings you could include VRGNG = COIN, for direct postings you can include RKL records. Just keep in mind that COEP contains both transaction postings and Settlement posting, so if you don't filter out the net would be zero. If you want to report what has been settled, you could go after KOKA and KOAO records.

Going after COEP is little extra efforts, but as soon as you link up other tables based on OBJNR and other fields, you would be smiling. 🙂

Good luck!!!

Rakesh

suniljain
Master
Master

Hi Robson,

Agree with Rakesh,

actually problem with COBK,COEP is the delta extraction. There is no direct timestamp in COEP . it has numetic date field you have to convert it into date then olny you can extract delta.

it also depends on you which route you want to follow.

Not applicable

Hi Robson

For actual lines items you can use table COVP which is the table read when running KSB1. (Plan line items is COVJ, report KSBP).

If you have difficulty to identify what tables you need if you run transaction RKACSHOW in sap for a particular object (cost center, Internal Order etc) and it will list all tables with entries for the object. You can drill into the tables then to view the details.

Just to specify this will only give you values linked to object numbers, you would still have to pull master data tables (CSKS, AUFK etc) in order to get a complete view of KSB1.

Hope this is of some help.

cheers, Elaine

disqr_rm
Partner - Specialist III
Partner - Specialist III

HI Sunil,

How I deal with this problem is by creating a view on COBK and COEP and add Time stamp field(s) from COBK into the view, connecting them by primary keys. I actually usually put the selection field restrictions on Transaction Type (COIN, RKL....) in the view itself based on my needs, which also reduces the number of records I need. This hits many targets with just one stone. 🙂

suniljain
Master
Master

really, its goog idea to reduce complexity.