(Glue-2108) 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.