P_GlobAssetAssignment

@AbapCatalog: { sqlViewName: 'PGFASSETASSGMT',  preserveKey: true, compiler.compareFilter: true }
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #BASIC
@VDM.private:true
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true

define view P_GlobAssetAssignment
  as select from           glofaatmdpndnt
    left outer to one join t001                                                            on t001.bukrs = glofaatmdpndnt.bukrs
    inner join             P_TF_AssetRedesignSwitchStatus( P_SAPClient : $session.client ) on P_TF_AssetRedesignSwitchStatus.IsActive = ''
{
  key glofaatmdpndnt.bukrs                                    as CompanyCode,
  key glofaatmdpndnt.anln1                                    as MasterFixedAsset,
  key glofaatmdpndnt.anln2                                    as FixedAsset,
  key glofaatmdpndnt.bdatu                                    as ValidityEndDate,

      glofaatmdpndnt.adatu                                    as ValidityStartDate,
      glofaatmdpndnt.glo_rus_shd_rsn                          as RU_AssetShutdownReason,
      glofaatmdpndnt.glo_rus_shd_docn                         as RU_AssetShutdownDocument,
      glofaatmdpndnt.glo_rus_pld_chck                         as RU_AssetIsPledged,
      glofaatmdpndnt.glo_rus_pld_amnt                         as RU_AssetPledgeAmountInLocCrcy,
      glofaatmdpndnt.glo_rus_pld_rcpn                         as RU_AssetPledgee,
      glofaatmdpndnt.glo_rus_docnum                           as RU_AssetPledgeDocumentNumber,
      glofaatmdpndnt.glo_rus_icnmb                            as RU_AssetInventoryCardNumber,
      glofaatmdpndnt.glo_rus_okof16                           as RU_AssetOKOF,
      glofaatmdpndnt.glo_rus_depgrn                           as RU_AssetDepreciationGroup,
      glofaatmdpndnt.glo_rus_tax_offc                         as RU_AssetTaxOfficeCode,
      glofaatmdpndnt.glo_rus_szpk                             as RU_AssetSZPKIsApplied,
      glofaatmdpndnt.glo_rus_prt_ptyp                         as RU_AssetPropertyType,
      cast(glofaatmdpndnt.glo_rus_prt_oktm as firu_oktmo_int) as RU_PropertyTaxOKTMO,
      glofaatmdpndnt.glo_rus_prt_scat                         as RU_PropertyTaxSpecialCategory,
      glofaatmdpndnt.glo_rus_prt_tcrt                         as RU_PropertyTaxRateReduction,
      glofaatmdpndnt.glo_rus_prt_tcam                         as RU_PropertyTaxAmtReduction,
      glofaatmdpndnt.glo_rus_prt_tcex                         as RU_PropertyTaxExemption,
      glofaatmdpndnt.glo_rus_prt_pnum                         as RU_PropertyTaxObjectNumber,
      glofaatmdpndnt.glo_rus_prt_pncd                         as RU_PropertyTaxObjectNumberType,
      glofaatmdpndnt.glo_rus_prt_cadv                         as RU_PrptyCadastrAmtInLoclCrcy,
      glofaatmdpndnt.glo_rus_prt_shre                         as RU_AssetCommonPropertyShare,
      glofaatmdpndnt.glo_rus_prt_aloc                         as RU_RoomFloorAreaInSquareMeter,
      glofaatmdpndnt.glo_rus_prt_atot                         as RU_RoomBuildFloorAreaInSqMtr,
      glofaatmdpndnt.glo_rus_prt_isre                         as RU_AssetIsRealEstate,
      glofaatmdpndnt.glo_rus_txb_type                         as RU_TransportTaxPowerUnit,
      @Semantics.quantity.unitOfMeasure: 'RU_TransportTaxPowerUnit'
      glofaatmdpndnt.glo_rus_txb_unit                         as RU_TranspTaxBaseQtyInBaseUnit,
      glofaatmdpndnt.glo_rus_trt_tcex                         as RU_TransportTaxExemption,
      glofaatmdpndnt.glo_rus_trt_tcrt                         as RU_TransportTaxReduction,
      glofaatmdpndnt.glo_rus_ttx_stld                         as RU_VehicleStolenDate,
      glofaatmdpndnt.glo_rus_ttx_rtrd                         as RU_VehicleReturnDate,
      glofaatmdpndnt.glo_rus_ttx_rgsd                         as RU_VehicleRegistrationDate,
      glofaatmdpndnt.glo_rus_ttx_rmvd                         as RU_VehicleCancellationDate,
      cast(glofaatmdpndnt.glo_rus_ttx_oktm as firu_oktmo_int) as RU_TransportTaxOKTMO,
      glofaatmdpndnt.glo_rus_ttx_lnum                         as RU_VehicleLicensePlateNumber,
      glofaatmdpndnt.glo_rus_trt_tcam                         as RU_TranspTxAmtReduction,
      glofaatmdpndnt.glo_rus_ttx_vpca                         as RU_VehTranspTxPriceCategory,
      glofaatmdpndnt.glo_rus_ttx_plat                         as RU_VehicleIsRegisteredInPlaton,
      glofaatmdpndnt.glo_rus_ttx_shre                         as RU_TransptCommonOwnershipShare,
      cast('' as cade_fxdast_usage)                           as CN_CADEFixedAssetUsage,
      cast('' as glo_pl_cust_invc_acctg_doc)                  as PL_CustInvcAccountingDocument,
      cast('' as glo_pl_cust_invc_fscl_yr)                    as PL_CustomerInvoiceFiscalYear,
      cast('CLASSIC' as faa_authcntxt)                        as AssetAuthorizationContext,
      @Semantics.amount.currencyCode: 'Currency'
      t001.waers                                              as Currency,
      t001.land1                                              as Country
}

union all select from    glo_faat_md_tdd
  left outer to one join t001                                                            on t001.bukrs = glo_faat_md_tdd.comp_code
  inner join             P_TF_AssetRedesignSwitchStatus( P_SAPClient : $session.client ) on P_TF_AssetRedesignSwitchStatus.IsActive = 'X'
{
  key          glo_faat_md_tdd.comp_code                                as CompanyCode,
  key          glo_faat_md_tdd.asset_no                                 as MasterFixedAsset,
  key          glo_faat_md_tdd.asset_subno                              as FixedAsset,
  key          glo_faat_md_tdd.valid_to_date                            as ValidityEndDate,

               glo_faat_md_tdd.valid_from_date                          as ValidityStartDate,
               glo_faat_md_tdd.glo_rus_shd_rsn                          as RU_AssetShutdownReason,
               glo_faat_md_tdd.glo_rus_shd_docn                         as RU_AssetShutdownDocument,
               glo_faat_md_tdd.glo_rus_pld_chck                         as RU_AssetIsPledged,
               glo_faat_md_tdd.glo_rus_pld_amnt                         as RU_AssetPledgeAmountInLocCrcy,
               glo_faat_md_tdd.glo_rus_pld_rcpn                         as RU_AssetPledgee,
               glo_faat_md_tdd.glo_rus_docnum                           as RU_AssetPledgeDocumentNumber,
               glo_faat_md_tdd.glo_rus_icnmb                            as RU_AssetInventoryCardNumber,
               glo_faat_md_tdd.glo_rus_okof16                           as RU_AssetOKOF,
               glo_faat_md_tdd.glo_rus_depgrn                           as RU_AssetDepreciationGroup,
               glo_faat_md_tdd.glo_rus_tax_offc                         as RU_AssetTaxOfficeCode,
               glo_faat_md_tdd.glo_rus_szpk                             as RU_AssetSZPKIsApplied,               
               glo_faat_md_tdd.glo_rus_prt_ptyp                         as RU_AssetPropertyType,
               cast(glo_faat_md_tdd.glo_rus_prt_oktm as firu_oktmo_int) as RU_PropertyTaxOKTMO,
               glo_faat_md_tdd.glo_rus_prt_scat                         as RU_PropertyTaxSpecialCategory,
               glo_faat_md_tdd.glo_rus_prt_tcrt                         as RU_PropertyTaxRateReduction,
               glo_faat_md_tdd.glo_rus_prt_tcam                         as RU_PropertyTaxAmtReduction,
               glo_faat_md_tdd.glo_rus_prt_tcex                         as RU_PropertyTaxExemption,
               glo_faat_md_tdd.glo_rus_prt_pnum                         as RU_PropertyTaxObjectNumber,
               glo_faat_md_tdd.glo_rus_prt_pncd                         as RU_PropertyTaxObjectNumberType,
               glo_faat_md_tdd.glo_rus_prt_cadv                         as RU_PrptyCadastrAmtInLoclCrcy,
               glo_faat_md_tdd.glo_rus_prt_shre                         as RU_AssetCommonPropertyShare,
               glo_faat_md_tdd.glo_rus_prt_aloc                         as RU_RoomFloorAreaInSquareMeter,
               glo_faat_md_tdd.glo_rus_prt_atot                         as RU_RoomBuildFloorAreaInSqmtr,
               glo_faat_md_tdd.glo_rus_prt_isre                         as RU_AssetIsRealEstate,
               glo_faat_md_tdd.glo_rus_txb_type                         as RU_TransportTaxPowerUnit,
               @Semantics.quantity.unitOfMeasure: 'RU_TransportTaxPowerUnit'
               glo_faat_md_tdd.glo_rus_txb_unit                         as RU_TranspTaxBaseQtyInBaseUnit,
               glo_faat_md_tdd.glo_rus_trt_tcex                         as RU_TransportTaxExemption,
               glo_faat_md_tdd.glo_rus_trt_tcrt                         as RU_TransportTaxReduction,
               glo_faat_md_tdd.glo_rus_ttx_stld                         as RU_VehicleStolenDate,
               glo_faat_md_tdd.glo_rus_ttx_rtrd                         as RU_VehicleReturnDate,
               glo_faat_md_tdd.glo_rus_ttx_rgsd                         as RU_VehicleRegistrationDate,
               glo_faat_md_tdd.glo_rus_ttx_rmvd                         as RU_VehicleCancellationDate,
               cast(glo_faat_md_tdd.glo_rus_ttx_oktm as firu_oktmo_int) as RU_TransportTaxOKTMO,
               glo_faat_md_tdd.glo_rus_ttx_lnum                         as RU_VehicleLicensePlateNumber,
               glo_faat_md_tdd.glo_rus_trt_tcam                         as RU_TranspTxAmtReduction,
               glo_faat_md_tdd.glo_rus_ttx_vpca                         as RU_VehTranspTxPriceCategory,
               glo_faat_md_tdd.glo_rus_ttx_plat                         as RU_VehicleIsRegisteredInPlaton,
               glo_faat_md_tdd.glo_rus_trt_shre                         as RU_TransptCommonOwnershipShare,
               glo_faat_md_tdd.cade_fxdast_usage                        as CN_CADEFixedAssetUsage,      
               glo_faat_md_tdd.glo_pl_cust_invc_acctg_doc               as PL_CustInvcAccountingDocument,
               glo_faat_md_tdd.glo_pl_cust_invc_fscl_yr                 as PL_CustomerInvoiceFiscalYear,                                     
               cast('NEW' as faa_authcntxt)                             as AssetAuthorizationContext,
               @Semantics.amount.currencyCode: 'Currency'
               t001.waers                                               as Currency,
               t001.land1                                               as Country
}