cancel
Showing results for 
Search instead for 
Did you mean: 

Table KEKO

amine_lamkaissi
Active Contributor
0 Kudos

Hello CO experts,

I am working on BW, I am looking to enhance an extractor with some fields from table KEKO. I need to understand the functional relationships before of this table with other ones (in order to make consistent links).

Did someone have the relational model of this table with the other SAP tables?

In other words, If I take the key fields of Table KEKO:

-BZOBJ : Reference Object

-KALNR : Cost Estimate Number - Product Costing

-KALKA : Costing Type

-KADKY : Costing Date (Key)

-TVERS : Costing Version

-BWVAR : Valuation Variant in Costing

-KKZMA : Costs Entered Manually in Additive or Automatic Cost Est.

On which tables, I can find the sames records stored in table KEKO concering the above fields (e.g KEKO-KALKA = TCK03-KALKA)

If possible, only real functional links between tables

Many thanks for you help,

Amine

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Amine,

You can get same fields in KEPH Table .

Regards,

Ram    

Answers (1)

Answers (1)

narasimhulu_konnipati
Active Contributor
0 Kudos

Dear,

All the cost estimate details will be stored in the tables KEKO and KEPH

Also, you can refer the table CKIS which will help you with additional costing details

Thanks

amine_lamkaissi
Active Contributor
0 Kudos

Hi Ram and Narasimhulu,

Fisrt of all, thanks for your helpful answers.

One point that in fact I didn't mention in my demand. The idea is to start form extract structure KKBW_PCP2 (please use SE11 for more details, refer to below screen)and use its fields to find common fields with other tables.


I give you this example:

In order to add fields VBELN and POSNR to extract structure KKBW_PCP2, I got this proposal in a forum:

From KKBW_PCP2 data the key fields of KEKO can be determined.

The missing key fields are:
1) KALKA and BWVAR
These can be determined by reading table TCK03 with key KKBW_PCP1-KLVAR
2) BZOBJ
This is '0' here.
3) KKZMA
This is ' ' (space) here.
4) KALNR
- Read T001W with key KKBW_PCP1-WERKS
- Read table MBEW with key KKBW_PCP1-MATNR and T001W-BWKEY and
MBEW-BWTAR = Space
- if KKBW_PCP1-ERZKA = 'X'
then MBEW-KALN1 has to be taken
else MBEW-KALNR has to be taken

If I take the example of the 4th point. How the person knows that we should read table T001W….?

I mean there is a functional link. I can’t find any documentation to understand it…

The answer seems to be good, but I need to understand it.

Thanks for your help,

Amine

narasimhulu_konnipati
Active Contributor
0 Kudos

KEKO_WERKS

T001W_WERKS

KKBW_PCP2_WERKS

MBEW_BWKEY

T001W_BWKEY

All these BWKEY and WERKS are referring to Plant

Hope this helps

Thanks