(Glue-2105) Glue tables

Glue tables are the main target for data replication in Glue, they represent a folder/structure outside of SAP where to replicate data.

List available Glue tables

Resource GET /glue-tables serve to obtain details about Glue tables. It supports the following input parameters passed in the body of the HTTP request (JSON format only): 

Parameter name 

Description 

Usage 

Type

Parameter name 

Description 

Usage 

Type

tableName 

Filtering based on Glue table name 

Optional 

Array input

package 

Filtering based on the SAP development package 

Optional 

Array input

author 

Filtering based on the author 

Optional 

Array input

storageID 

Filtering based on storage ID 

Optional 

Array input

All input parameters are case insensitive. 

Example of REST API call: 

GET

http://servername:portnumber/dvd/glue/api/v3/glue-tables?sap-client=800

JSON body: 

{ "tableName": ["ZAP_1", "ZAD_TEST"], "package": ["$TMP", "ZAD_TEST"], "author": ["APOLTANO", "ADZIRBIK"], "storageID": ["$T_ORACLE", "ZAP_TB_A2"] }
{ "tables": [ { "tabname": "ZAD_TEST", "status": "A", "type": "TABLE", "description": "creating test table", "devclass": "ZAD_TEST", "storid": "$T_ORACLE", "storidQuery": "", "tabUpd": "", "meaningfulField": "", "generated": false, "speakingFields": "", "dataEnrichment": false, "cruser": "ADZIRBIK", "crdate": "2020-03-03", "crtime": "14:22:48", "chuser": "ADZIRBIK", "chdate": "2020-03-11", "chtime": "08:02:42", "tableStructure": [ { "tabname": "ZAD_TEST", "fieldname": "GLREQUEST", "status": "S", "pos": 1, "keyflag": "X", "rollname": "/DVD/GL_EXT_DATA_REQUEST", "datatype": "DEC", "leng": 30, "decimals": 0, "domname": "/DVD/GL_EXT_DATA_REQUEST", "description": "Glue request", "partitioning": "X", "refFieldnm": "", "fieldnameExternal": "GLREQUEST" }, { "tabname": "ZAD_TEST", "fieldname": "TABLE_ID", "status": "S", "pos": 2, "keyflag": "X", "rollname": "ZAD_HISTORY_ID", "datatype": "INT4", "leng": 10, "decimals": 0, "domname": "ZAD_HISTORY_ID", "description": "ID.", "partitioning": "", "refFieldnm": "", "fieldnameExternal": "TABLE_ID" }, { "tabname": "ZAD_TEST", "fieldname": "OPERATION", "status": "S", "pos": 3, "keyflag": "", "rollname": "ZAD_CHAR", "datatype": "CHAR", "leng": 1, "decimals": 0, "domname": "ZAD_CHAR", "description": "Characters which represent arithmetic operation", "partitioning": "", "refFieldnm": "", "fieldnameExternal": "OPERATION" }, { "tabname": "ZAD_TEST", "fieldname": "FIRST_NUM", "status": "S", "pos": 4, "keyflag": "", "rollname": "ZAD_PACKED_NUM", "datatype": "DEC", "leng": 4, "decimals": 2, "domname": "ZAD_PACKED_NUM", "description": "Number with 2 decimal places.", "partitioning": "", "refFieldnm": "", "fieldnameExternal": "FIRST_NUM" }, { "tabname": "ZAD_TEST", "fieldname": "SECOND_NUM", "status": "S", "pos": 5, "keyflag": "", "rollname": "ZAD_PACKED_NUM", "datatype": "DEC", "leng": 4, "decimals": 2, "domname": "ZAD_PACKED_NUM", "description": "Number with 2 decimal places.", "partitioning": "", "refFieldnm": "", "fieldnameExternal": "SECOND_NUM" }, { "tabname": "ZAD_TEST", "fieldname": "RESULT_NUM", "status": "S", "pos": 6, "keyflag": "", "rollname": "ZAD_PACKED_NUM", "datatype": "DEC", "leng": 4, "decimals": 2, "domname": "ZAD_PACKED_NUM", "description": "Number with 2 decimal places.", "partitioning": "", "refFieldnm": "", "fieldnameExternal": "RESULT_NUM" } ], "binaryStorage": { "contid": "", "contPath": "", "delimiterType": "", "wrapValues": "", "extendEscaping": "", "includeHeader": "", "appendPackages": "", "compressionOn": "", "compressionLvl": 0 } }, { "tabname": "ZAP_1", "status": "A", "type": "TABLE", "description": "ZAP_1", "devclass": "$TMP", "storid": "ZAP_TB_A2", "storidQuery": "", "tabUpd": "", "meaningfulField": "", "generated": false, "speakingFields": "", "dataEnrichment": false, "cruser": "APOLTANO", "crdate": "2019-01-22", "crtime": "14:03:51", "chuser": "APOLTANO", "chdate": "2019-12-17", "chtime": "09:12:05", "tableStructure": [ { "tabname": "ZAP_1", "fieldname": "GLREQUEST", "status": "S", "pos": 1, "keyflag": "X", "rollname": "/DVD/GL_EXT_DATA_REQUEST", "datatype": "DEC", "leng": 30, "decimals": 0, "domname": "/DVD/GL_EXT_DATA_REQUEST", "description": "Glue request", "partitioning": "X", "refFieldnm": "", "fieldnameExternal": "GLREQUEST" }, { "tabname": "ZAP_1", "fieldname": "CALDAY", "status": "S", "pos": 2, "keyflag": "X", "rollname": "/BI0/OICALDAY", "datatype": "DATS", "leng": 8, "decimals": 0, "domname": "", "description": "Calendar day", "partitioning": "", "refFieldnm": "", "fieldnameExternal": "CALDAY" }, { "tabname": "ZAP_1", "fieldname": "CALMONTH", "status": "S", "pos": 3, "keyflag": "X", "rollname": "/BI0/OICALMONTH", "datatype": "NUMC", "leng": 6, "decimals": 0, "domname": "", "description": "Calendar year/month", "partitioning": "", "refFieldnm": "", "fieldnameExternal": "CALMONTH" }, { "tabname": "ZAP_1", "fieldname": "CALYEAR", "status": "S", "pos": 4, "keyflag": "X", "rollname": "/BI0/OICALYEAR", "datatype": "NUMC", "leng": 4, "decimals": 0, "domname": "", "description": "Calendar year", "partitioning": "", "refFieldnm": "", "fieldnameExternal": "CALYEAR" }, { "tabname": "ZAP_1", "fieldname": "FISCYEAR", "status": "S", "pos": 5, "keyflag": "X", "rollname": "/BI0/OIFISCYEAR", "datatype": "NUMC", "leng": 4, "decimals": 0, "domname": "", "description": "Fiscal year", "partitioning": "", "refFieldnm": "", "fieldnameExternal": "FISCYEAR" }, { "tabname": "ZAP_1", "fieldname": "FISCPER", "status": "S", "pos": 6, "keyflag": "X", "rollname": "/BI0/OIFISCPER", "datatype": "NUMC", "leng": 7, "decimals": 0, "domname": "", "description": "Fiscal year / period", "partitioning": "", "refFieldnm": "", "fieldnameExternal": "FISCPER" }, { "tabname": "ZAP_1", "fieldname": "FISCVARNT", "status": "S", "pos": 7, "keyflag": "X", "rollname": "/BI0/OIFISCVARNT", "datatype": "CHAR", "leng": 2, "decimals": 0, "domname": "", "description": "Fiscal year variant", "partitioning": "", "refFieldnm": "", "fieldnameExternal": "FISCVARNT" }, { "tabname": "ZAP_1", "fieldname": "CALQUART1", "status": "S", "pos": 8, "keyflag": "X", "rollname": "/BI0/OICALQUART1", "datatype": "NUMC", "leng": 1, "decimals": 0, "domname": "", "description": "Quarter", "partitioning": "", "refFieldnm": "", "fieldnameExternal": "CALQUART1" }, { "tabname": "ZAP_1", "fieldname": "CALQUARTER", "status": "S", "pos": 9, "keyflag": "X", "rollname": "/BI0/OICALQUARTER", "datatype": "NUMC", "leng": 5, "decimals": 0, "domname": "", "description": "Calendar year/quarter", "partitioning": "", "refFieldnm": "", "fieldnameExternal": "CALQUARTER" }, { "tabname": "ZAP_1", "fieldname": "/DV1/S_DMPARK", "status": "S", "pos": 10, "keyflag": "X", "rollname": "/DV1/OIDMPARK", "datatype": "CHAR", "leng": 20, "domname": "", "description": "DVD Amount FLTP KF", "partitioning": "", "refFieldnm": "", "fieldnameExternal": "DV1_S_DMAMO_FLT" }, { "tabname": "ZAP_1", "fieldname": "/DV1/S_DMCOST_E", "status": "S", "pos": 30, "keyflag": "", "rollname": "BAPICURR_D", "datatype": "DEC", "leng": 23, "decimals": 4, "domname": "", "description": "Currency amount in BAPI interfaces", "partitioning": "", "refFieldnm": "", "fieldnameExternal": "DV1_S_DMCOST_E" }, { "tabname": "ZAP_1", "fieldname": "/DV1/S_DMCOST_M", "status": "S", "pos": 31, "keyflag": "", "rollname": "BAPICURR_D", "datatype": "DEC", "leng": 23, "decimals": 4, "domname": "", "description": "Currency amount in BAPI interfaces", "partitioning": "", "refFieldnm": "", "fieldnameExternal": "DV1_S_DMCOST_M" }, { "tabname": "ZAP_1", "fieldname": "/DV1/S_DMCOST_P", "status": "S", "pos": 32, "keyflag": "", "rollname": "BAPICURR_D", "datatype": "DEC", "leng": 23, "decimals": 4, "domname": "", "description": "Currency amount in BAPI interfaces", "partitioning": "", "refFieldnm": "", "fieldnameExternal": "DV1_S_DMCOST_P" }, { "tabname": "ZAP_1", "fieldname": "/DV1/S_DMDAT_DAT", "status": "S", "pos": 33, "keyflag": "", "rollname": "/DV1/OIDMDAT_DAT", "fieldnameExternal": "DV1_S_DMTEMP" }, { "tabname": "ZAP_1", "fieldname": "/DV1/S_DMTIM_DEC", "status": "S", "pos": 45, "keyflag": "", "rollname": "/DV1/OIDMTIM_DEC", "datatype": "DEC", "leng": 17, "decimals": 0, "domname": "", "description": "DVD Time_Dec KF", "partitioning": "", "refFieldnm": "", "fieldnameExternal": "DV1_S_DMTIM_DEC" }, { "tabname": "ZAP_1", "fieldname": "/DV1/S_DMTIM_TIM", "status": "S", "pos": 46, "keyflag": "", "rollname": "/DV1/OIDMTIM_TIM", "datatype": "TIMS", "leng": 6, "decimals": 0, "domname": "", "description": "DVD Tims Time KF", "partitioning": "", "refFieldnm": "", "fieldnameExternal": "DV1_S_DMTIM_TIM" }, { "tabname": "ZAP_1", "fieldname": "/DV1/S_DMWIND_SP", "status": "S", "pos": 47, "keyflag": "", "rollname": "/DV1/OIDMWIND_SP", "datatype": "QUAN", "leng": 17, "decimals": 3, "domname": "", "description": "DVD Wind speed", "partitioning": "", "refFieldnm": "", "fieldnameExternal": "DV1_S_DMWIND_SP" }, { "tabname": "ZAP_1", "fieldname": "/DV1/S_DMDOC_CUR", "status": "S", "pos": 48, "keyflag": "", "rollname": "/DV1/OIDMDOC_CUR", "datatype": "CUKY", "leng": 5, "decimals": 0, "domname": "", "description": "DVD Currency", "partitioning": "", "refFieldnm": "", "fieldnameExternal": "DV1_S_DMDOC_CUR" }, { "tabname": "ZAP_1", "fieldname": "CURRENCY", "status": "S", "pos": 49, "keyflag": "", "rollname": "/BI0/OICURRENCY", "datatype": "CUKY", "leng": 5, "decimals": 0, "domname": "", "description": "Currency key", "partitioning": "", "refFieldnm": "", "fieldnameExternal": "CURRENCY" }, { "tabname": "ZAP_1", "fieldname": "/DV1/S_DMFORCR", "status": "S", "pos": 50, "keyflag": "", "rollname": "/DV1/OIDMFORCR", "datatype": "CUKY", "leng": 5, "decimals": 0, "domname": "", "description": "DVD Foreign currency", "partitioning": "", "refFieldnm": "", "fieldnameExternal": "DV1_S_DMFORCR" }, { "tabname": "ZAP_1", "fieldname": "/DV1/S_DMWUNIT", "status": "S", "pos": 51, "keyflag": "", "rollname": "/DV1/OIDMWUNIT", "datatype": "UNIT", "leng": 3, "decimals": 0, "domname": "", "description": "DVD Wolume Unit", "partitioning": "", "refFieldnm": "", "fieldnameExternal": "DV1_S_DMWUNIT" }, { "tabname": "ZAP_1", "fieldname": "/DV1/S_DMAR_UNIT", "status": "S", "pos": 52, "keyflag": "", "rollname": "/DV1/OIDMAR_UNIT", "datatype": "UNIT", "leng": 3, "decimals": 0, "domname": "", "description": "DVD Area Unit", "partitioning": "", "refFieldnm": "", "fieldnameExternal": "DV1_S_DMAR_UNIT" }, { "tabname": "ZAP_1", "fieldname": "UNIT", "status": "S", "pos": 53, "keyflag": "", "rollname": "/BI0/OIUNIT", "datatype": "UNIT", "leng": 3, "decimals": 0, "domname": "", "description": "Unit of measure", "partitioning": "", "refFieldnm": "", "fieldnameExternal": "UNIT" }, { "tabname": "ZAP_1", "fieldname": "RECORDMODE", "status": "S", "pos": 54, "keyflag": "", "rollname": "RODMUPDMOD", "datatype": "CHAR", "leng": 1, "decimals": 0, "domname": "", "description": "BW Delta Process: Record Mode", "partitioning": "", "refFieldnm": "", "fieldnameExternal": "RECORDMODE" } ], "binaryStorage": { "contid": "ZAP_1", "contPath": "", "delimiterType": ",", "wrapValues": "", "extendEscaping": "", "includeHeader": "", "appendPackages": "", "compressionOn": "", "compressionLvl": 0 } } ] }

 Functionality is implemented in the SAP class /DVD/GL_EXT2_API_TABLES.