Skip to main content
Question

How to create Data Model by using O2C files imported with SAP ABAP output loader?

  • January 31, 2022
  • 1 reply
  • 25 views
J
Level 0
Forum|alt.badge.img+7

I've uploaded all the tables that the ABAP reports generated, but now I need to use that tables to create the Data Model and hence be able to use the O2C apps. After installing the O2C app, it gives error as it cannot find the Activity Table. How can I create it? I thought this was automatically performed once the CSV files are loaded. Am I missing something?

    1 reply

    D
    Level 2

    Hello Juan,

     

    The activity table needs to be created in transformation statement.

    Check if O2C app contain specific transformation (it sohuld done as one of the first ones), if not below you can find the code for the most basic one:

     

    --Query No: 1

    DROP TABLE IF EXISTS _CEL_ACTIVITIES;

     

    -- Query No: 2

    CREATE TABLE _CEL_ACTIVITIES (

        "_CASE_KEY" VARCHAR(30)

        ,"ACTIVITY_EN" VARCHAR(100)

        ,"EVENTTIME" TIMESTAMP

        ,"_SORTING" INTEGER

    );

     

    Best Regards,

    Mateusz Dudek

    Community Code of ConductAccessibility statement