I_WrntyClaimVersion

@AbapCatalog.sqlViewName: 'IWRNTYCLMVRN'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
@AccessControl.privilegedAssociations: [ '_LastChangedByUser' , '_CreatedByUser']
@EndUserText.label: 'Warranty Claim Version'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@ObjectModel:{
    representativeKey: 'WrntyVersionUUID',
    usageType:{
        dataClass       : #TRANSACTIONAL,
        serviceQuality  : #A,
        sizeCategory    : #L
        },
    supportedCapabilities: [#CDS_MODELING_ASSOCIATION_TARGET, #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE]
//Commented by Jeni becos custom cube CDS view can't be created on top of analytical dimension view

//  modelingPattern: #ANALYTICAL_DIMENSION,

//  supportedCapabilities: [#ANALYTICAL_DIMENSION, #CDS_MODELING_ASSOCIATION_TARGET, #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #EXTRACTION_DATA_SOURCE] 

}
//@Analytics:{

//             dataCategory: #DIMENSION,

//             dataExtraction.enabled: true,

//             internalName:#LOCAL

//           }

@Metadata.allowExtensions:true           
@Metadata.ignorePropagatedAnnotations: true
/*+[hideWarning] { "IDS" : [ "KEY_CHECK" ]  } */



define view I_WrntyClaimVersion
  as select from pnwtyv
  association [1..1] to I_WrntyClaimHeader       as _WrntyClaimHeader on $projection.WrntyClaimHeaderUUID = _WrntyClaimHeader.WrntyClaimHeaderUUID
  association [1..1] to I_WrntyClaimHeader       as _Header on $projection.WrntyClaimHeaderUUID = _Header.WrntyClaimHeaderUUID
  association [1..*] to I_WrntyClaimItem         as _WrntyClaimItem   on $projection.WrntyVersionUUID = _WrntyClaimItem.WrntyVersionUUID
  association [1..1] to I_UserContactCard            as _LastChangedByUser on  $projection.LastChangedByUser = _LastChangedByUser.ContactCardID
  association [1..1] to I_UserContactCard            as _CreatedByUser     on  $projection.CreatedByUser = _CreatedByUser.ContactCardID
  //association [1..*] to I_WrntyClaimCategoryText as _Text             on $projection.WrntyClaimCategory = _Text.ClaimCategory

//  association [1..*] to I_WrntyClaimVersionCategoryTxt as _Text             on $projection.WarrantyClaimVersionCategory = _Text.WarrantyClaimVersionCategory

  association [0..1] to I_Customer                     as _Customer    on  $projection.WarrantyClaimVersionPartner = _Customer.Customer
  association [1..1] to I_Supplier                   as _Supplier          on $projection.WarrantyClaimVersionPartner = _Supplier.Supplier
  association [0..1] to I_SalesOrganization            as _SalesOrganization         on  $projection.SalesOrganization = _SalesOrganization.SalesOrganization
  association [0..1] to I_PurchasingOrganization       as _PurchasingOrganization    on $projection.PurchasingOrganization = _PurchasingOrganization.PurchasingOrganization
  association [1..1] to I_WrntyClaimDecisionCode       as _DecisionCode              on  $projection.WrntyDecisionCode = _DecisionCode.WarrantyClaimItemDecisionCode 
  association [1..1] to I_WarrantyClaimVersionCategory as _VersionCategory on $projection.WarrantyClaimVersionCategory = _VersionCategory.WarrantyClaimVersionCategory
 association [1..1] to E_WarrantyClaimVersion                 as _ExtensionWrntyVers                    on  $projection.WrntyVersionUUID = _ExtensionWrntyVers.WrntyVersionUUID
{

  key pnguid                                                            as WrntyVersionUUID,
      header_guid                                                       as WrntyClaimHeaderUUID,
      //      pncnt                                                     as WarrantyInternalNumber, to be removed 

      //      pntxcnt                                                   as WrntyComponentNode, to be removed 

      cast(versn    as wty_versn   preserving type )                    as WrntyVersionNumber,
      //kateg                                                             as WrntyClaimCategory, 

      @ObjectModel.foreignKey.association:'_VersionCategory'                                                                        
        kateg                                                           as  WarrantyClaimVersionCategory,
      @ObjectModel.foreignKey.association: '_DecisionCode'  
      v_rejcd                                                           as WrntyDecisionCode,
      //v_parnr                                                           as WrntyPartNumber,

       
      v_parnr                                                           as WarrantyClaimVersionPartner,
      //cast(v_parvw as parvw_unv preserving type )                       as WrntyPartRole ,

      cast(v_parvw as parvw_unv preserving type )                       as WrntyClaimVersionPartnerRole,
      //cast(v_parvw as parvw_unv preserving type )                       as WrntyClaimVersionPartnerRole,

      //      refkt                                                     as WrntyRefType,

      //      refnr                                                     as WarrantyReferenceNumber,

      //aktiv                                                             as WrntyActiveVersion,

      @Semantics.booleanIndicator :true
      aktiv                                                             as WarrantyClaimVersionIsActive,
      fkdat                                                             as WrntyBillingDocumentDate,
      knumv                                                             as WrntyDocumentCondition,
      v_crncy                                                           as WrntyCurrencyCode,
      prsdt                                                             as WrntyPriceExchangeRateDate,
      cast(kursk  as fis_absolute_exchangerate preserving type)         as WrntyExchangeRateForPrice,
      //      v_log_handle                                              as WrntyApplLogHandle,

      //      log_hdl_dfct                                              as WrntyApplLogHandleDefect,

      prev_version                                                      as WrntyNumberPrecedingVersion,
      // WrntyClmPrecedingVersionNmbr

      @ObjectModel.foreignKey.association:'_SalesOrganization'
      vkorg                                                             as SalesOrganization,
      vtweg                                                             as DistributionChannel,
      spart                                                             as Division,
      //      v_mdocm                                                   as WrntyMeasurementDocumentNumber,

      reversal                                                          as WrntyVersionForReversePosting,
      //      endvn                                                     as WrntyClaimIsFinalVersion,

      @ObjectModel.foreignKey.association: '_PurchasingOrganization'
      ekorg                                                             as PurchasingOrganization,
      //      sdvbeln                                                   as WrntyContractDocumentNumber,

      //      sdposnr                                                   as WrntyContractItemNumber,

      //      refdt_vers                                                as WrntyReferenceVersionDate,

      // v_mganr                                                   as WrntyMasterVersions,

      //      v_gwldt                                                   as WrntyAssignedStartDate,

//      result_out_mwtyv                                                  as WrntyResultObjCheckCustomer, //to be commented 

//      result_in_mwtyv                                                   as WrntySupplierCheckResult,   // to be commneted 

      //v_dummy                                                   as WrntyDummyFunc,

      //pricing_ok                                                        as WrntyPricingStatus,

      pricing_ok                                                        as WarrantyVersionPricingStatus,
      
      //      new_version                                               as WrntyNewVersionStatus,

      //compsend                                                          as WrntyRelVersionShipPartner,

      @Semantics.booleanIndicator :true
      compsend                                                          as WrntyVersIsReldForShipgToPart,
      //WrntyVersIsReldForShipgToPart

      //timstmp                                                           as ValidToDateTime,

      timstmp                                                           as WarrantyClaimChangeDateTime,
      creadat                                                           as WrntyClaimCreationDate,
      @ObjectModel.foreignKey.association:'_CreatedByUser'
      creaby                                                            as CreatedByUser,
      chngdat                                                           as WrntyClaimChangedDate,
      @ObjectModel.foreignKey.association: '_LastChangedByUser'
      chngby                                                            as LastChangedByUser,
      //pntext                                                            as WrntyOfVersionText,

      pntext                                                            as WarrantyClaimVersionText,
      vers_representativeid                                             as WarrantyVersionRprstvID,
      _WrntyClaimHeader.WrntyCustClmProcessingStatus,
      _WrntyClaimHeader.WrntySuplrClmProcessingStatus,
     // WarrantyClaimVersionText

      //_Text[1:Language=$session.system_language].WrntyClaimCategoryText as WrntyClaimCategoryText,

//      _Text[1:Language=$session.system_language].WrntyClaimVersionCategoryText as WrntyClaimVersionCategoryText,

      _WrntyClaimHeader,
      _Header,
      _WrntyClaimItem,
      _LastChangedByUser,
      _CreatedByUser,
      _Customer,
      _Supplier,
      _SalesOrganization,
      _PurchasingOrganization,
      _DecisionCode,
     // _Extension,

      _VersionCategory
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_WRNTYCLAIMHEADER",
"PNWTYV"
],
"ASSOCIATED":
[
"E_WARRANTYCLAIMVERSION",
"I_CUSTOMER",
"I_PURCHASINGORGANIZATION",
"I_SALESORGANIZATION",
"I_SUPPLIER",
"I_USERCONTACTCARD",
"I_WARRANTYCLAIMVERSIONCATEGORY",
"I_WRNTYCLAIMDECISIONCODE",
"I_WRNTYCLAIMHEADER",
"I_WRNTYCLAIMITEM"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/