/
(Glue-2205) SNP Glue™ tables

(Glue-2205) SNP Glue™ tables

Owned by SNP
May 19, 2022
5 min read

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

List available SNP Glue™ tables

Resource GET /glue-tables serve to obtain details about SNP 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 SNP 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. 

 

Related content