Show TOC

Function documentationExport Management for Advanced Users Locate this document in the navigation structure

 

You can generate configured metadata (called entities) directly from the SQL Manager, save the entities to a text file, and then export entities from the text file to an export data file using Mobile System Maintenance (MSY).

Prerequisites

  • You have ensured that the format of the entity entries in the text file is as follows:

    Export:<BONAME>:<UNIQUE KEY>:<ENTITY SHORT CODE>:<ENTITY DISPLAY ATTRIBUTE VALUE>

    • Export is the keyword for the export

    • BONAME is the business object name of the entity

    • UNIQUE KEY is the unique key of the entity record (or the SFAKEY value)

    • ENTITY SHORT CODE indicates the type of entity to be exported

      You can find the short codes for all the entities in the EXPORTIMPORTENTITIES choice field.

      For more information about choice fields, see Choice Field Overview.

    • ENTITY DISPLAY ATTRIBUTE VALUE gives information about the values from a specified field in the tables for each entity type.

      Following are the table and field names from which the display attribute values are retrieved for each entity type.

      Entity Type

      Field Name

      Table Name

      Business Content Provider

      BCPUNIQUENAME

      SMOBCP

      Reports, Charts

      NAME

      SMOREPMA

      Document Layouts

      LAYNAM and LAYSC

      SMOLAYITM

      Choice Fields

      CLIST

      SMOCHLIST

      Advanced Selection

      EXNAME

      SMOEXHEAD

      Advanced Selection Criteria

      CONNAME

      SMOEXCOND

      Relationship Category

      RELTYP

      SMOKVBEZTP

      Business Hours

      KVOPTYP

      CDBC_TB049

      Contact Person Type

      KTOKD

      SMOT077D

      Application Parameters

      ID

      SMOREG

      Inbox Mappings

      TNAME

      SMOUIMAP

      Field Property Maintenance

      AUART, PSTYV, MODNAM, FIELDN

      SMOSDFLDS

      The entity type, Sales Transaction Customization, has the fixed value Sales Tran. Customization.

      Note Note

      You must enter a colon after each keyword in the export format specified above. Each record that you enter must be in a new line.

      For more information about the data structures of these entity types, see Data Structures of Entity Types.

      End of the note.

      Example Example

      To export a Relation Type, enter:

      Export:BOKVBEZTP:0772FAAAEBBE43C8B206BB3183F9C87F:REL:00000010

      End of the example.
  • You have fulfilled the prerequisites for using the export manager function.

    For more information, see Export Manager.

Activities

  1. In MSY, choose   Export-Import   Export Manager   .

  2. In the My Export Basket tile, choose Load from File to load entities from the text file that you generated directly from SQL Manager to the export basket.

  3. The My Export Basket tile contains the list of entities that you want to export.

  4. Select the required entities and export them.

    For more information, see Export Manager.