P_ProductSearch

@AbapCatalog.sqlViewName: 'PPRODSEARCH'
@AbapCatalog.compiler.compareFilter: true
@VDM.private: true
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #CHECK //is 'CHECK' required?

@ObjectModel.representativeKey: 'Product'
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory : #L
@ObjectModel.usageType.dataClass: #MASTER
@ClientHandling.algorithm: #SESSION_VARIABLE
//@Search.searchable: true

//@EndUserText.label: 'Product anchor view for CDS search model'


define view P_ProductSearch 
  as select from I_Product as Product

  association [0..*] to I_ProductSalesDelivery         as _ProductSalesDelivery          on  $projection.Product = _ProductSalesDelivery.Product

  association [0..*] to P_ProductPlant                 as _ProductPlant                  on  $projection.Product = _ProductPlant.Product

  association [0..*] to I_ProductTypeText              as _ProductTypeName               on  $projection.ProductType = _ProductTypeName.ProductType
  association [0..*] to I_ProductGroupText             as _ProductGroupText              on  $projection.ProductGroup = _ProductGroupText.MaterialGroup
  association [0..*] to I_ProductCategoryText          as _ProductCategoryText           on  $projection.ProductCategory = _ProductCategoryText.ProductCategory
  //  association [0..*] to I_ProductStatusText            as _ProductStatusText             on  $projection.CrossPlantStatus = _ProductStatusText.Status

  association [0..*] to I_ProductText                  as _ProductText                   on  $projection.Product = _ProductText.Product
  association [0..*] to I_UnitOfMeasureText            as _BaseUnitOfMeasureText         on  $projection.BaseUnit = _BaseUnitOfMeasureText.UnitOfMeasure
  association [0..*] to I_UnitOfMeasureText            as _PurchaseOrderQuantityUnitText on  $projection.PurchaseOrderQuantityUnit = _PurchaseOrderQuantityUnitText.UnitOfMeasure
  association [0..*] to I_UnitOfMeasureText            as _WeightUnitText                on  $projection.WeightUnit = _WeightUnitText.UnitOfMeasure
  association [0..*] to I_DivisionText                 as _DivisionText                  on  $projection.Division = _DivisionText.Division
  association [0..*] to I_SourceOfSupplyCategoryT      as _SourceOfSupply                on  $projection.SourceOfSupply = _SourceOfSupply.SourceOfSupplyCategory
  association [0..*] to I_ProductHierarchyText         as _ProductHierarchyText          on  $projection.ProductHierarchy = _ProductHierarchyText.ProductHierarchy
  association [0..1] to I_Supplier                     as _Supplier                      on  $projection.ManufacturerNumber = _Supplier.Supplier
  association [0..*] to I_ESHSSLTEXT                   as _ESHSslText                    on  $projection.Product  = _ESHSslText.tdname
                                                                                         and _ESHSslText.tdobject = 'MATERIAL'
  association [0..*] to I_DocumentInfoRecordObjectLink as _DocumentInfoRecordObjectLink  on  $projection.Product                           = _DocumentInfoRecordObjectLink.LinkedSAPObjectKey
                                                                                         and _DocumentInfoRecordObjectLink.LinkedSAPObject = 'MARA'

{
  key Product.Product, //both request & response field


      //Request Parameters

      Product.LastChangedByUser, //also response param

      Product.CreatedByUser, //also response param

      Product.ProductExternalID, //also response param

      Product.ProductType, //also response param

      Product.ProductOldID, //also response param

      Product.ProductGroup, //also response param

      Product.ProductStandardID, //also response param


      //Response Parameters


      Product.NetWeight,
      Product.GrossWeight,

      Product.Division,
      Product.ProductHierarchy,

      Product.ProductManufacturerNumber,
      //These fields are included only for association condition

      Product.ProductCategory,
      Product.BaseUnit,
      Product.ManufacturerNumber,
      Product.PurchaseOrderQuantityUnit,
      Product.SourceOfSupply,
      Product.WeightUnit,
      Product.AuthorizationGroup,

      //      Product.LastChangeDateTime,

      //      Product.LastChangeDate,

      //      Product.DangerousGoodsIndProfile,

      //      Product.InternationalArticleNumberCat,

      //      Product.PackagingMaterialGroup,

      //      Product.ExternalProductGroup,

      //      Product.CrossPlantConfigurableProduct,

      //      Product.CrossPlantStatusValidityDate,

      //      Product.ProdIsEnvironmentallyRelevant,

      //      Product.DocumentIsCreatedByCAD,

      //      Product.ProductIsConfigurable,

      //      Product.AuthorizationGroup,

      //      Product.CrossPlantStatus,

      //      Product.SalesStatus,

      //      Product.ProductDocumentType,

      //      Product.ProductDocumentVersion,

      //      Product.SizeOrDimensionText,

      //      Product.LaboratoryOrDesignOffice,

      //      Product.IndustryStandardName,

      //      Product.BasicMaterial,

      //      Product.IsMarkedForDeletion,

      //      Product.ProductDocumentNumber,


      //      _ProductStatusText,

      _ProductTypeName,
      _ProductGroupText,
      _ProductCategoryText,
      _ProductText,
      _ProductSalesDelivery,
      _ProductPlant,
      _BaseUnitOfMeasureText,
      _PurchaseOrderQuantityUnitText,
      _WeightUnitText,
      _DivisionText,
      _SourceOfSupply,
      _ProductHierarchyText,
      _Supplier,
      _ESHSslText,
      _DocumentInfoRecordObjectLink
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PRODUCT"
],
"ASSOCIATED":
[
"I_DIVISIONTEXT",
"I_DOCUMENTINFORECORDOBJECTLINK",
"I_ESHSSLTEXT",
"I_PRODUCTCATEGORYTEXT",
"I_PRODUCTGROUPTEXT",
"I_PRODUCTHIERARCHYTEXT",
"I_PRODUCTSALESDELIVERY",
"I_PRODUCTTEXT",
"I_PRODUCTTYPETEXT",
"I_SOURCEOFSUPPLYCATEGORYT",
"I_SUPPLIER",
"I_UNITOFMEASURETEXT",
"P_PRODUCTPLANT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/