Ingesting Data from SAP S4 HANA

[Andrew_ENT]

Hi, how are others ingesting the data from S4 HANA for legacy tables?

With the transition from ECC to S4 some tables were replaced / combined / streamlined. We were assured that there would be views available so that you could see the data in the same format replicating the behaviour of the "old tables".

It seems, that those views are only accessible in SAP, you cannot pull a view into QCDI. So we instead need to replicate the logic that said views are doing.

• For MSEG, that's really straight forward as all of the data is included within the new table MATDOC and no filters / joins / aggregations are required.
• But for COEP it seems a lot trickier. It seems like COEP is now contained within ACDOCA, but ACDOCA doesn't contain the field KSTAR (Cost element) which is the GL Account number. This is essential for our Fixed Cost reporting.

Has anyone found documentation of the SQL code which each view does?

Thanks in advance.

[rubenmarin · Accepted solution]

Hi, the Account Number is stored in RACCT, if you search on interner for 'ACDOCA fields pdf' you'll find a document that relates differnt tables to acdoca, I'm not really sure if it's accurate but it could be a good start.

You can find one of the table definitions on https://www.se80.co.uk/sap-s4-hana-tables/?name=acdoca