(Glue-2405) Create SNP Glue™ Table
- Run the transaction /DVD/GL11 to open Data Dictionary.
- Enter the name of a new table and click Create.
- Enter the description of the table in Short Description.
- Under the Attributes tab fill in the following fields based on your preference:
- Enable update (optional): Simulates the update operation for tables on storages that do not support the update operation. More information can be found in the section Enable update.
- Table name (optional): Use different name of the table on storage
- Choose, if you prefer transparent or binary storage for the target table:
- For transparent storage, enter its ID in the field Storage ID.
- For binary storage see the chapter Create SNP Glue™ table on File storage.
- For transparent storage, enter its ID in the field Storage ID.
Step 2: Insert fields manually or import them from an existing SAP DDIC table, an InfoProvider, a file, or a BEx Query/View
You can either manually insert fields or import them from an existing SAP DDIC table, an InfoProvider, a file, or a BEx Query/BEx Query View. You may define the fields (columns) of a new table.
a. Import fields from an existing SAP table
To generate the field structure of the SNP Glue™ table based on an existing SAP DDIC table, an InfoProvider, a file, or a BEx Query/View
- Select the Fields tab.
- Select Import Fields. (Field names, data elements, types, lengths, and descriptions are imported from the selected source.)
- To import fields from a table, mark From table.
- To import fields from an InfoProvider, mark From InfoProvider.
- To import fields from a file, mark From File.
To import fields from a BEx Query or a BEx Query View, mark Bex Query/View. The program then automatically finds out which type of object is specified in the corresponding parameter. It finds out whether it is a BEx Query or a BEx Query View and it translates query elements to the DDIC fields form.
If you cannot import fields from BEx Query or BEx Query View due to unsupported structure (e.g. Characteristics in columns (axis X), enabled Hierarchy or multiple structures in rows (axis Y)), adjust your query in BEx Query Analyzer or Query Monitor (TCODE RSRT), save it as Query View and use it to import the fields.
- You can use standard SAP field names or meaningful ones. To use the meaningful fields select Use meaningful fields. More information can be found in the section Meaningful fields.
An example of imported fields.
The RAW fields will be added to the SNP Glue™ table with an empty data element. Before the activation, you must manually define the data element or remove the field from the SNP Glue™ table.
b. Insert fields manually
If you choose to manually insert fields
- Select the Fields tab.
- To insert or append a new field, click Insert or Append row.
- Fill in:
- Field name: Name of the field
- Key field: Select if it is a key field
The total number of characters for the primary Key field value is restricted to 338.
- Data element
- Data Type: Automatically filled according to the Data element or you can set it up manually by clicking Data Type/Element specification . You can then manually specify the Data Type, Length, Decimal Places, Short text.
The following data types are not supported when you create the SNP Glue™ table: LRAW, RAW, RSTR, VARC.
- Partitioning: You may set the partitioning for fields, based on which data is distributed into blocks during the extraction. This step enables you to modify the data grouped in these blocks. By default, the partitioning is set on the GLREQUEST field.
If you use a Hive or an Impala storage, keep in mind which fields you choose for Partitioning. Selecting too granular data for partitioning may decrease the performance and stability of the whole cluster.
- Reference Fieldname: The reference field for Data enrichment contains the name of the field with original values. More information can be found in the section Data Enrichment.
- To delete a row, highlight the particular row and click Delete Row. You may view the following ALV operations:
- Add fields button:
- After clicking on this button, a pop-up appears where you can select the field that will be added to the table. The following options are available:
- Deletion flag: Appends a field GLDELFLAG with data element /DVD/GL_DELFLAG (CHAR1), which will be automatically detected in the Extraction Process and Delete flag transfer rule assigned.
- Glue change time
- Glue commit time (in case that storage is type Snowflake)
- Google Cortex field (in case that storage is type Google BigQuery)
- After clicking on this button, a pop-up appears where you can select the field that will be added to the table. The following options are available:
4. Save: You can save the table anytime during your work. All actions you have made so far are performed on the SAP side and have no effect on the Hadoop system.
5. If the table was not saved before, the system will ask you to fill in the Package.
6. Activate: Only after you activate the SNP Glue™ table, it is created on external storage (for example Hadoop). The activation of the SNP Glue™ table does not influence other SNP Glue™ components.