Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
rcandeo
Contributor II

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
Valued Contributor III

which tables are used for KSB1?

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

6 Replies
suniljain
Honored Contributor

which tables are used for KSB1?

COSP

disqr_rm
Valued Contributor III

which tables are used for KSB1?

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
Honored Contributor

which tables are used for KSB1?

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

which tables are used for KSB1?

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
Valued Contributor III

which tables are used for KSB1?

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
Honored Contributor

which tables are used for KSB1?

really, its goog idea to reduce complexity.

Community Browser