1"use strict";(self.webpackChunkerpl_docusaurus=self.webpackChunkerpl_docusaurus||[]).push([[566],{28453:(e,s,t)=>{t.d(s,{R:()=>r,x:()=>i});var n=t(96540);const a={},l=n.createContext(a);function r(e){const s=n.useContext(l);return n.useMemo(function(){return"function"==typeof e?e(s):{...s,...e}},[s,e])}function i(e){let s;return s=e.disableParentContext?"function"==typeof e.components?e.components(a):e.components||a:r(e.components),n.createElement(l.Provider,{value:s},e.children)}},66275:(e,s,t)=>{t.r(s),t.d(s,{assets:()=>c,contentTitle:()=>i,default:()=>h,frontMatter:()=>r,metadata:()=>n,toc:()=>o});const n=JSON.parse('{"id":"references/rfc/sap_show_tables","title":"sap_show_tables","description":"Lists all or specific tables available in the SAP system.","source":"@site/docs/references/rfc/sap_show_tables.md","sourceDirName":"references/rfc","slug":"/references/rfc/sap_show_tables","permalink":"/docs/references/rfc/sap_show_tables","draft":false,"unlisted":false,"editUrl":"https://github.com/datazoode/erpl-landingpage/tree/main/docs/references/rfc/sap_show_tables.md","tags":[],"version":"current","frontMatter":{"title":"sap_show_tables","description":"Lists all or specific tables available in the SAP system."},"sidebar":"docs","previous":{"title":"sap_rfc_show_function","permalink":"/docs/references/rfc/sap_rfc_show_function"},"next":{"title":"sap_describe_fields","permalink":"/docs/references/rfc/sap_describe_fields"}}');var a=t(74848),l=t(28453);const r={title:"sap_show_tables",description:"Lists all or specific tables available in the SAP system."},i=void 0,c={},o=[{value:"Syntax",id:"syntax",level:2},{value:"Example usage",id:"example-usage",level:2}];function d(e){const s={code:"code",h2:"h2",p:"p",pre:"pre",...(0,l.R)(),...e.components};return(0,a.jsxs)(a.Fragment,{children:[(0,a.jsx)(s.h2,{id:"syntax",children:"Syntax"}),"\n",(0,a.jsxs)(s.p,{children:["To find a table you are looking for, you can use the ",(0,a.jsx)(s.code,{children:"sap_show_tables"})," function. This function returns a list of all available tables in the SAP ERP system."]}),"\n",(0,a.jsx)(s.p,{children:"The function has the following signature:"}),"\n",(0,a.jsx)(s.pre,{children:(0,a.jsx)(s.code,{className:"language-sql",children:'SELECT * FROM sap_show_tables([TABLENAME = "<tablename>"], [TEXT = "<search string>"])\n'})}),"\n",(0,a.jsx)(s.h2,{id:"example-usage",children:"Example usage"}),"\n",(0,a.jsx)(s.pre,{children:(0,a.jsx)(s.code,{className:"language-sql",children:"SELECT * FROM sap_show_tables()\n"})}),"\n",(0,a.jsxs)(s.p,{children:["This will return a (long) list of tables. To find a specific table, you can supply a search string to the function. The search string is matched against the table name and the table description. For example, to find all tables starting with ",(0,a.jsx)(s.code,{children:"FLIGHT"})," you can use the following query:"]}),"\n",(0,a.jsx)(s.pre,{children:(0,a.jsx)(s.code,{className:"language-sql",children:"SELECT * FROM sap_show_tables(TABLENAME='*SPFL*')\n"})}),"\n",(0,a.jsxs)(s.p,{children:["If you are not familiar with the internal naming scheme of SAP tables you can also use the ",(0,a.jsx)(s.code,{children:"sap_show_tables"})," function to find tables by their description text. For example, to find all tables containing the words ",(0,a.jsx)(s.code,{children:"Flight Schedule"})," you can use the following query:"]}),"\n",(0,a.jsx)(s.pre,{children:(0,a.jsx)(s.code,{className:"language-sql",children:"SELECT * FROM sap_show_tables(TEXT='*Flight Schedule*')\n"})})]})}function h(e={}){const{wrapper:s}={...(0,l.R)(),...e.components};return s?(0,a.jsx)(s,{...e,children:(0,a.jsx)(d,{...e})}):d(e)}}}]);
Line numbers count LF bytes from the start of the resource, as the search results do. Vendor segments are library code the classifier recognised; they are stored but not indexed. Bytes are shown as Latin1 characters, one per byte.