小崔说SAP技术博客 - 自定义字段
type: channel
link: https://www.sapxiaocui.top/index.php/tag/%E8%87%AA%E5%AE%9A%E4%B9%89%E5%AD%97%E6%AE%B5/
items: SAP B1自定义字段有效值清单视图

SAP B1自定义字段有效值清单视图
type: item
date: 2025-11-27T08:57:00+00:00
description: 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 效果图：