Material 360 > Integrating Material 360 with SAP > Creating custom tables in SAP
  

Creating custom tables in SAP

Create custom tables in SAP to store the MDM SaaS data in SAP S/4HANA. After you create custom tables in SAP, you can use the Cloud Data Integration assets to load MDM SaaS data to SAP S/4HANA.
    1Log in to SAP.
    2To use the ABAP dictionary, enter the transaction code value as SE11 and press Enter.
    The ABAP Dictionary: Initial Screen page appears.
    3Enter the database table name you want to create as ZINFA_MM_EXTID.
    Note: The table name must start with Y or Z only.
    4Click Create.
    The Dictionary: Change Table page appears.
    5Enter a short description for the transparent table.
    6To create an application table that contains master data or transaction data, enter the delivery class value as A.
    7From the Fields tab, enter the following field name, data type, and length of the fields to the table.
    Field Name
    Data Type
    Length
    Description
    BUSINESSID
    CHAR
    50
    Stores the MDM provided business ID.
    MATERIALNUMBER
    CHAR
    18
    Stores the material number that the GET_MATERIAL_NUMBER BAPI generates.
    SYNCDATE
    DATS
    8
    Stores the date of the MDM to S/4HANA synchronization.
    INTEGRATIONSTATUS
    CHAR
    10
    Stores whether the status of integration was successful or failure.
    For more information about attributes, see Data model attributes.
    8Specify the primary key for each table. To set a field as a primary key for the table, select Key.
    9Click Save.
    10From the menu bar, click More > Extras > Enhancement Category.
    The Maintain Enhancement Category for <database table name> dialog box appears.
    11Select Can Be Enhanced (Deep).
    12Click Copy.
    13From the menu bar, click the Activate icon.