Material 360 > Integrating Material 360 with SAP > Creating a custom table in SAP
  

Creating a custom table in SAP

Create a custom table in SAP to store the MDM SaaS data in SAP S/4HANA. After you create a custom table 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.
    7On the Fields tab, enter the following fields to the table:
    Field Name
    Data Type
    Length
    Description
    BUSINESSID
    CHAR
    50
    Unique identifier that MDM SaaS uses to identify records.
    INTEGRATIONSTATUS
    CHAR
    10
    Status of record integration. For example, success or failure.
    MATERIALNUMBER
    CHAR
    18
    Unique identifier for a material, generated by the Business Application Programming Interface (BAPI) named GET_MATERIAL_NUMBER.
    SYNCDATE
    DATS
    8
    Date of synchronizing MDM with S/4HANA.
    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.