primary key in ABAP and Hybris
in and Key ABAP PRIMARY Hybris
2023-09-14 09:02:49 时间
ABAP
Hybris
it is necessary to use attribute unique to decorate one field, which is defined in schema items.xsd:
<xs:attribute name="unique" type="xs:boolean" use="optional">
<xs:annotation>
<xs:documentation>If 'true', the value of this attribute has to be unique within all instances of this type. If there are multiple attributes marked as unique,
then their combined values must be unique. Will not be evaluated at jalo layer, if you want to manage the attribute directly using jalo layer you have to ensure uniqueness manually. Default is 'false'.
</xs:documentation>
</xs:annotation>
</xs:attribute>
See one example:
``xml
The above example fails to work as expected, in that case code1 and code2 are defined as unique separately, but don't constitute as composite key.
# solution
```xml
<itemtype code="xxx"
<deployment table="xxx" typecode="30001" />
<attributes>
<attribute qualifier="code1" type="String" generate="true">
<persistence type="property"></persistence>
<modifiers read="true" write="true" search="true" optional="false" />
</attribute>
<attribute qualifier="code2" type="String">
<modifiers read="true" write="true" search="true" optional="false" />
<persistence type="property" />
</attribute>
<indexes>
<index name="ProductSalesOrg" unique="true">
<key attribute="product"/>
<key attribute="salesOrg"/>
</index>
</indexes>
</itemtype>
相关文章
- “xxxxxxxxx”signer information does not match signer information of other classes in the same package
- ORA-00379: no free buffers available in buffer pool string for block size stringK ORACLE 报错 故障修复 远程处理
- ORA-19649: offline-range record RECID string STAMP string not found in file string ORACLE 报错 故障修复 远程处理
- ORA-24792: cannot mix services in a single global transaction ORACLE 报错 故障修复 远程处理
- ORA-26881: ORA-string: string raised in string automatic string job:”string”.”string” for Capture process “string” and cloned Capture process “string”. ORACLE 报错 故障修复 远程处理
- ORA-30094: failed to find the time zone data file for version string in $ORACLE_HOME/oracore/zoneinfo ORACLE 报错 故障修复 远程处理
- ORA-40388: Unsupported feature in PMML document: string ORACLE 报错 故障修复 远程处理
- MySQL Error number: 3580; Symbol: ER_WINDOW_CIRCULARITY_IN_WINDOW_GRAPH; SQLSTATE: HY000 报错 故障修复 远程处理
- ORA-01521: error in adding data files ORACLE 报错 故障修复 远程处理
- MySQL Error number: MY-011297; Symbol: ER_XPLUGIN_EXCEPTION_IN_TASK_SCHEDULER; SQLSTATE: HY000 报错 故障修复 远程处理
- ORA-06932: CMX: error in local name ORACLE 报错 故障修复 远程处理
- ORA-10643: Database should be mounted in restricted mode and Exclusive mode ORACLE 报错 故障修复 远程处理
- ORA-13363: no valid ETYPE in the geometry ORACLE 报错 故障修复 远程处理
- ORA-15485: number of volumes in diskgroup exceeds the maximum of string ORACLE 报错 故障修复 远程处理
- ORA-15504: cannot start workload capture because instance string not present in RESTRICTED SESSION mode ORACLE 报错 故障修复 远程处理
- 和in的区别深入研究MySQL查询条件中的=与IN的区别(mysql查询条件中)
- 如何在Linux系统中定时执行sh脚本?How to schedule the execution of a sh script in Linux?(linux定时执行sh)
- A Comprehensive Guide to Using Oracle DBMS: Everything You Need to Know in 25 Words.(oracledbms)
- Linux is Leading the Way in OpenSource Innovation and Development(linuxisla)
- Effortlessly Modify Values in Oracle: A Comprehensive Guide(oracle修改值)
- 如何有效运用SQL Server的IN语句(sqlserver用in)
- 语句SQL Server中使用IN语句处理多值查询(sqlserver中in)
- 探索Oracle中IN关联查询的精彩世界(oracle关联查询in)
- MySQL中使用IN类型参数(mysql中in类型参数)
- 深入分析MySQL中IN语句的性能问题(mysql中in性能分析)
- MySQL中使用IN操作会影响性能吗(mysql中in性能)
- 深入探究Mysql中IN与AND逻辑运算的应用(mysql中in与and)
- Oracle中的IN操作符使用指南(in在oracle)
- MySQL中为什么不能使用IN子查询(mysql不能in子查询)
- Oracle 数据库中使用AND拼接的威力(oracle中and拼接)
- 研究Oracle IN语句的技巧与窍门(oracle in的语句)
- Oracle IN一种SQL语句查询的高效方式(oracle in的定义)