I_FixedAssetCountryData

@AbapCatalog: {sqlViewName:'IFIASTCNTRYDATA', preserveKey: true}
@Analytics: { dataCategory: #DIMENSION, dataExtraction.enabled: true }
@EndUserText.label: 'Country/Region Specific Fixed Asset'
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #CHECK
@ObjectModel: { representativeKey: 'FixedAsset',
                usageType.serviceQuality: #C,
                usageType.sizeCategory: #L,
                usageType.dataClass: #MASTER }
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.supportedCapabilities: [#CDS_MODELING_DATA_SOURCE]
@Metadata:{ignorePropagatedAnnotations: true, allowExtensions:true}

define view I_FixedAssetCountryData

  as select from P_FixedAssetCountryData
  //Association with Asset Master Reference

  //  association [1..1] to I_FixedAsset       as _FixedAsset       on  $projection.CompanyCode      = _FixedAsset.CompanyCode

  //                                                                and $projection.MasterFixedAsset = _FixedAsset.MasterFixedAsset

  //                                                                and $projection.FixedAsset       = _FixedAsset.FixedAsset


  association [0..1] to I_CompanyCode      as _CompanyCode      on  $projection.CompanyCode = _CompanyCode.CompanyCode
  association [0..1] to I_Country          as _Country          on  $projection.Country = _Country.Country
  association [0..1] to I_MasterFixedAsset as _MasterFixedAsset on  $projection.CompanyCode      = _MasterFixedAsset.CompanyCode
                                                                and $projection.MasterFixedAsset = _MasterFixedAsset.MasterFixedAsset
{
      //Key fields

      @ObjectModel.foreignKey.association: '_CompanyCode'
      @Consumption.valueHelpDefinition: [ { entity: { name: 'I_CompanyCodeStdVH', element: 'CompanyCode' } } ]
  key CompanyCode,
      @ObjectModel.foreignKey.association: '_MasterFixedAsset'
      @Consumption.valueHelpDefinition: [ { entity: { name: 'I_MasterFixedAssetStdVH', element: 'MasterFixedAsset' },
                                            additionalBinding:  [ { localElement: 'CompanyCode', element:'CompanyCode' } ]
                                        } ]
  key MasterFixedAsset,
  key FixedAsset,

      //National Classification

      NationalClassification,
      TaxDepreciationGroup,

      //RU General Data

      RU_LongSerialNumber,
      RU_WorkwearMaterial,
      RU_RetiredMasterFixedAsset,
      RU_RetiredFixedAsset,
    //RU Traceability

      RU_ProdTraceabilityStartDate,
      RU_ProdTraceabilityEndDate,  
      RU_AssetTNVED,      
      //RU Transport Tax

      RU_AssetTransportType,
      RU_VehicleIdNumber,
      RU_ManufacturingDate,
      RU_VehicleEcologicalClass,
      RU_PropertyAddress,
      RU_PropertyOwnershipRegnDate,
      RU_PropertyOwnershipTermnDate,

      //JP specific fields for Property Tax Report and Annex-16 Report

      JP_Annex16AssetStructure,
      JP_Annex16AssetItem,
      JP_Annex16LeasingAgrmtDate,
      JP_PrptyTxRptCity,
      JP_PrptyTxRptClassfctnKey,
      JP_PrptyTxRptSpclDepr,
      JP_PrptyTxRptAddlDepr,

      //IN specific fields

      IN_AssetBlock,
      IN_AssetPutToUseDate,
      IN_AdditionalAssetBlock,
      IN_AssetIsResearchAndDev,
      IN_AssetIsPriorYear,

      //PT specific fields for Fiscal Maps

      PT_VehicleTypeByEnergy,
      PT_VehicleIsWithoutLimit,
      PT_BigRepairAssetLink,
      PT_LandAssetLink,
      PT_AssetReportFormCategory,
      PT_AmortizedAssetIsReevaluated,

      //IL Investment center

      IL_InvmtCtrInternalCode,
      IL_InvmtCtrApprovalDocNmbr,
      IL_InvmtCtrApprovalVersion,
      IL_InvmtCtrBogusAssetNumber,
      IL_InvmtCtrAssetVersion,
      
      //RS specific fields in new asset master

      RS_GroupDeprExclusionYear,
      RS_AssetLastInvoiceDate,

      @ObjectModel.foreignKey.association: '_Country'
      Country,

      // Define association to parent

      //      @ObjectModel.association.type: [ #TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT ]

      //      _FixedAsset,

      _CompanyCode,
      _Country,
      _MasterFixedAsset
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_FIXEDASSETCOUNTRYDATA"
],
"ASSOCIATED":
[
"I_COMPANYCODE",
"I_COUNTRY",
"I_MASTERFIXEDASSET"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/