Hybris 6.3 Data model Updates


New and updated modules

There are some changes in the data model in hybris 6.3 in comparison with the previous version. Understanding these changes is crucial for an upgrade.

B2B Accelerator Addon

  • REMOVED Type AcceptQuoteAndOrderAction

Base Commerce

  • ADDED Attribute ReturnRequest.subtotal (BigDecimal)
  • REMOVED Attribute ReturnRequest.trackingID (String)

Catalog

  • ADDED Enum SyncItemStatus   (IN_SYNC, NOT_SYNC, COUNTERPART_MISSING, ITEM_MISSING, NOT_APPLICABLE, IN_PROGRESS, SYNC_RULES_VIOLATED)
See Catalog Item Synchronization Status API for details.

Commerce Services

model4.png
  • ADDED Enum QuoteState (enum). Extend QuoteState with values specific to use in commerceservices: BUYER_APPROVED, BUYER_DRAFT, BUYER_SUBMITTED, BUYER_OFFER, BUYER_ACCEPTED, BUYER_REJECTED, BUYER_ORDERED, SELLER_REQUEST, SELLER_DRAFT, SELLER_SUBMITTED, SELLERAPPROVER_DRAFT, SELLERAPPROVER_PENDING, SELLERAPPROVER_REJECTED, SELLERAPPROVER_APPROVED.
  • ADDED Enum QuoteAction (enum). CREATE, VIEW, SUBMIT, SAVE, EDIT, DISCOUNT, CANCEL, CHECKOUT, ORDER, APPROVE, REJECT, EXPIRED.
  • ADDED Enum QuoteUserType (enum). BUYER, SELLER, SELLERAPPROVER.
  • ADDED Enum DiscountType (enum). PERCENT, ABSOLUTE, TARGET
  • ADDED Enum SearchQueryContext (enum). DEFAULT, SUGGESTIONS
  • ADDED Relation Assignee2Quotes (Quote->User)
  • ADDED Attribute AbstractOrder.quoteDiscountValuesInternal (String)
  • ADDED Attribute Order.quoteReference (Quote). The reference to quote from which the order was placed
  • ADDED Attribute Cart.quoteReference (Quote). The reference to quote from which the cart was created.
  • REMOVED Attribute Cart.expirationTime (Date). The date/time when the saved cart will expire. Moved to AbstractOrder
  • REMOVED Attribute Cart.name (String). The name of the saved cart provided by user or auto-generated. Moved to AbstractOrder
  • REMOVED Attribute Cart.description (String). The description of the saved cart provided by user or auto-generated. Moved to AbstractOrder
  • REMOVED Attribute SolrIndexedProperty.displayName (localized String). The display name for this property in the list of facet. Moved to Solr Facet Search module.
  • ADDED Type QuoteProcess
  • ADDED Attribute Employee.organizationRoles (PrincipalGroupCollection). OrganizationRoles will only have organization related roles as its members.
  • ADDED Attribute Quote.cartReference (Cart). The reference to cart used to manipulate the quote
See the following pages on hybris wiki for the details:

Core

  • ADDED Collection  QuoteEntryCollection (QuoteEntry)
  • ADDED Enum QuoteState. CREATED, DRAFT, SUBMITTED, OFFER, ORDERED, CANCELLED, EXPIRED
  • ADDED Relation User2Quotes (Quote->User)
  • ADDED Attribute AbstractOrder.description (String)
  • ADDED Attribute AbstractOrder.expirationTime (Date)
  • ADDED Attribute AbstractOrder.name (String)
  • ADDED Type Quote extends AbstractOrder
  • ADDED Type QuoteEntry extends AbstractOrderEntry
  • ADDED Type StoredHttpSession 

Order Self Service Addon

  • ADDED Type ReturnOrderAction extends SimpleCMSAction

Personalization

Personalization Integration

  • ADDED Attribute CxConfig.autoCreateSegments. If set to true segments are automatically created from external data during update

Personalization Services

  • ADDED Collection RecalculateActionStringCollection (set of String)
  • ADDED Type CxConfig 
  • ADDED Type CxUrlVoterConfig
  • ADDED Relation CxConfigToCxUrlVoterConfig (CxUrlVoterConfig -> CxConfig)
  • ADDED Relation BaseSiteToCxConfig (BaseSite -> CxConfig)

Personalization Promotions [NEW]

  • ADDED Type CxPromotionAction

Promotion/Rule Engine

Promotion Engine Services

  • ADDED Relation PromotionGroup2PromotionSourceRuleRelation (PromotionSourceRule -> PromotionGroup)
  • REMOVED Attribute website (PromotionGroup)

Rule Engine

  • ADDED Attribute deployedMvnVersion (String)

SAP Integration

SAP Model

  • ADDED Enum ConsignmentEntryStatus 
  • ADDED Enum SapSystemType
  • ADDED Attribute SAPLogicalSystem.sapSystemType (SapSystemType)
  • ADDED Attribute SAPLogicalSystem.senderName (String)
  • ADDED Attribute SAPLogicalSystem.senderPort (String)
  • ADDED Attribute ConsignmentEntry.sapOrderEntryRowNumber (int)
  • ADDED Attribute ConsignmentEntry.status (ConsignmentEntryStatus)

SAP Order Exchange OMS

  • ADDED Type SapConsignmentProcess

SAP Product Config Rules

  • ADDED Enum ProductConfigRuleMessageSeverity
  • ADDED Attribute ProductConfigSourceRule.stackable (boolean)
  • ADDED Attribute ProductConfigSourceRule.messageSeverity (ProductConfigRuleMessageSeverity)
  • ADDED Attribute AbstractRuleEngineRule.messageSeverity (ProductConfigRuleMessageSeverity)

SAP Product Recommendation

  • ADDED Enum usage (scenario, modeltype)
  • ADDED Attribute SAPGlobalConfiguration.sapproductrecommendation_rfcdest
  • ADDED Attribute SAPGlobalConfiguration.sapproductrecommendation_usage (usage)

SAP Prod Reco Buffer [NEW]

  • ADDED Type SAPRecommendationBuffer 
  • ADDED Type SAPRecommendationMapping
  • ADDED Type SAPRecoTypeMapping

Y Sap Oms Fulfillment

  • ADDED Enum ConsignmentEntryStatus (WAITING, PICKPACK, READY, SHIPPED, CANCELLED)
  • ADDED Attribute Order.sapSystemType (SapSystemType)
  • REMOVED Declaration SapConsignmentProcess.waitingForConsignment 
  • REMOVED Declaration SapConsignmentProcess.warehouseConsignmentState
  • REMOVED Declaration SapConsignmentProcess.done
  • REMOVED Declaration SapConsignmentEntry.sapOrderEntryRowNumber
  • REMOVED Declaration SapConsignmentEntry.status

Y SAP Product Config Addon

  • REMOVED Type ProductConfigurationSpecificationComponent
  • REMOVED Type ProductConfigurationTabNavigationComponent

SOLR Facet Search

model3.png
  • ADDED Relation SolrIndexedType2SolrSearchQueryTemplate (SolrSearchQueryTemplate -> SolrIndexedType)
  • ADDED Relation SolrIndexedProperty2SolrSearchQueryProperty (SolrSearchQueryProperty -> SolrIndexedProperty)
  • ADDED Relation SolrSearchQueryTemplate2SolrSearchQueryProperty (SolrSearchQueryProperty -> SolrSearchQueryTemplate)
  • ADDED Attribute SolrIndexedProperty.displayName (localized String). The display name for this property in the list of facet.
  • ADDED Attribute SolrIndexedProperty.topValuesProvider (String). topValuesProvider used by this property.
  • ADDED Type SolrSearchQueryTemplate 
  • ADDED Type SolrSearchQueryProperty
  • ADDED Type SolrSearchQuerySort

Warehousing

model1.png
  • ADDED Enum AsnStatus (CREATED, ACCEPTED, CANCELLED)
  • ADDED Relation AdvancedShippingNotice2WarehouseRelation (AdvancedShippingNotice -> Warehouse)
  • ADDED Relation AdvancedShippingNoticeEntry2StockLevelRelation (StockLevel -> AdvancedShippingNoticeEntry )
  • ADDED Relation AdvancedShippingNotice2POSRelation (PointOfService -> AdvancedShippingNotice)
  • ADDED Relation AdvancedShippingNoticeEntry2AsnRelation (AdvancedShippingNoticeEntry -> AdvancedShippingNotice)
model2.png
  • ADDED Relation Warehouse2WarehouseBinRelation (WarehouseBin -> Warehouse)
  • ADDED Relation WarehouseBin2WarehouseBinEntryRelation (WarehouseBinEntry -> WarehouseBin)
  • ADDED Relation WarehouseBin2WarehouseTransferEntrySrcRelation (WarehouseTransferEntry -> WarehouseBin)
  • ADDED Relation WarehouseBin2WarehouseTransferEntryDestRelation (WarehouseTransferEntry -> WarehouseBin)
  • ADDED Relation WarehouseTransfer2WarehouseTransferEntryRelation (WarehouseTransferEntry -> WarehouseTransfer)
  • ADDED Relation WarehouseTransfer2WarehouseTransferRelation (WarehouseTransfer -> WarehouseTransfer)
  • ADDED Attribute SourcingConfig.scoreWeightFactor (int)
  • ADDED Attribute Warehouse.score (Double)
  • ADDED Attribute Warehouse.external (Boolean)
  • ADDED Attribute Warehouse.warehouseBinTransferWorkflowName (String)
  • ADDED Attribute ATPFormula.external (boolean). A flag indicating that the external availability is included in the ATP calculation.
  • ADDED Attribute OrderReturnRecordEntry.returnRequest (ReturnRequest)
  • ADDED Type AdvancedShippingNotice
  • ADDED Type AdvancedShippingNoticeEntry
  • ADDED Type WarehouseBin
  • ADDED Type WarehouseBinEntry
  • ADDED Type WarehouseTransfer
  • ADDED Type WarehouseTransferEntry

Yaas

Yaas Configuration

  • ADDED Relation YaasClientApplicationRelation (YaasClient -> YaasApplication)
  • ADDED Type YaasClient
  • ADDED Attribute YaasApplication.oauthURL (String)
  © Rauf Aliev, March 2017

3 Responses

  1. Iurii Iegupov

    Iurii Iegupov

    Reply

    7 March 2017 at 01:10

    thank you for the article

  2. Ravi Gill

    Ravi Gill

    Reply

    9 March 2017 at 19:16

    Nice digest there Raul on Hybris 6.3!

  3. Hybris 6.4 Data Model Updates | hybrismart | SAP hybris under the hood

    Hybris 6.4 Data Model Updates | hybrismart | SAP hybris under the hood

    Reply

    6 June 2017 at 16:06

    […] the previous article about the differences in the data models of hybris 6.2 and hybris […]

Leave a Reply