HANA版本：
CREATE VIEW "IPS_VI_FldMapping"
AS
SELECT
T0."TableID" AS "TableName",T1."AliasID" AS "FieldName",T0."FldValue" AS "Code",T0."Descr" AS "Name"
FROM "UFD1" T0
INNER JOIN "CUFD" T1 ON T1."TableID"=T0."TableID" AND T1."FieldID"=T0."FieldID";
SQL版本
CREATE VIEW [IPS_VI_FldMapping]
AS
SELECT T0.TableID AS TableName,T1.AliasID AS FieldName,T0.FldValue AS Code,T0.Descr AS Name
FROM UFD1 T0
INNER JOIN CUFD T1 ON T1.TableID=T0.TableID AND T1.FieldID=T0.FieldID
效果图：
