- Created by SNP on Aug 17, 2021
You are viewing an old version of this page. View the current version.
Compare with Current View Page History
Version 1 Current »
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 |
|---|---|---|---|
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_1/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"]
}
Example of the REST API output:
{
"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.
- No labels