Hi
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.