Skip to Content
Jun 16, 2012 at 03:04 PM

join problems between BSEG and CSKS



I am joining BSEG table with CSKS (Cost Center Master Data). The CSKS is unique with the combination KOKRS (Controlling Area) / KOSTL ( Cost Center ) and / DATBI (Valid To Date) .

BSEG has KOKRS and KOSTL , but does not seem to have a "Valid to Date" .

How do I join BSEG and CSKS ? is there any other table that I can bring in to get the "Valid to Date" in the data foundation , so that I can still connect CSKS as an attribute view .

My BSEG is also connected to BKPF and CE4xxxx_ACCT in the data foundation.