SAP Table 資料描述

SAP Table 資料描述

讀取資料表說明
SELECT a.TABNAME,b.* FROM SAPRDP.DD02L a
LEFT OUTER JOIN SAPRDP.DD02T b ON a.TABNAME=b.TABNAME AND B.DDLANGUAGE='E'
WHERE  a.TABNAME='RZLLITAB'


讀取欄位說明
SELECT a.TabName, a.FieldName, TO_NUMBER(a.Position,'999999' )Position,a.INTTYPE  , TO_NUMBER(a.INTLEN,'999999' )IntLen,
       a.DataType, TO_NUMBER(a.Leng,'999999' )Leng, TO_NUMBER(a.Decimals,'999999' )Decimals, a.DOMNAME, b.DDLANGUAGE , b.DDTEXT, a.ROLLNAME, c.DDTEXT
            FROM SAPRDP.DD03L a
 LEFT OUTER JOIN SAPRDP.DD03T b ON a.TABNAME = b.TABNAME AND a.FieldName=b.FieldName  AND b.DDLANGUAGE='E'
 LEFT OUTER JOIN SAPRDP.DD04T c ON a.ROLLNAME = c.ROLLNAME  AND c.DDLANGUAGE='E'
   WHERE a.TABNAME='RZLLITAB'
   ORDER BY a.TabName,  a.Position