I_RU_PropertyTaxItemCube

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_RU_PropertyTaxItemCube.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IRUPRTITEMCUBE
-- Parameters: P_ReportingPeriodStartDate : firu_prt_submsn_dcl_valid_from, P_ReportingPeriodEndDate : firu_prt_submsn_dcl_valid_to

CREATE VIEW I_RU_PropertyTaxItemCube AS
SELECT
  PropertyTaxItem.StatryRptgEntity AS StatryRptgEntity,
  PropertyTaxItem.StatryRptCategory AS StatryRptCategory,
  PropertyTaxItem.StatryRptRunID AS StatryRptRunID,
  PropertyTaxItem.PositionID AS PositionID,
  PropertyTaxItem.CompanyCode AS CompanyCode,
  PropertyTaxItem.MasterFixedAsset AS MasterFixedAsset,
  PropertyTaxItem.FixedAsset AS FixedAsset,
  I_FixedAsset.FixedAssetDescription AS FixedAssetDescription,
  I_FixedAsset.AssetAdditionalDescription AS AssetAdditionalDescription,
  I_FixedAsset.AssetClass AS AssetClass,
  I_FixedAsset.Currency AS Currency,
  PropertyTaxItem.ValidityStartDate AS ValidityStartDate,
  PropertyTaxItem.ValidityEndDate AS ValidityEndDate,
  PropertyTaxItem.RU_PropertyTaxOKTMO AS RU_PropertyTaxOKTMO,
  PropertyTaxItem.RU_AssetPropertyType AS RU_AssetPropertyType,
  RU_PropertyTaxSZPKAttribute,
  NetBookValueAmt01InLoclCrcy,
  NetBookValueAmt02InLoclCrcy,
  NetBookValueAmt03InLoclCrcy,
  NetBookValueAmt04InLoclCrcy,
  NetBookValueAmt05InLoclCrcy,
  NetBookValueAmt06InLoclCrcy,
  NetBookValueAmt07InLoclCrcy,
  NetBookValueAmt08InLoclCrcy,
  NetBookValueAmt09InLoclCrcy,
  NetBookValueAmt10InLoclCrcy,
  NetBookValueAmt11InLoclCrcy,
  NetBookValueAmt12InLoclCrcy,
  NetBookValueAmt13InLoclCrcy,
  NetBookValAmtExmp01InLoclCrcy,
  NetBookValAmtExmp02InLoclCrcy,
  NetBookValAmtExmp03InLoclCrcy,
  NetBookValAmtExmp04InLoclCrcy,
  NetBookValAmtExmp05InLoclCrcy,
  NetBookValAmtExmp06InLoclCrcy,
  NetBookValAmtExmp07InLoclCrcy,
  NetBookValAmtExmp08InLoclCrcy,
  NetBookValAmtExmp09InLoclCrcy,
  NetBookValAmtExmp10InLoclCrcy,
  NetBookValAmtExmp11InLoclCrcy,
  NetBookValAmtExmp12InLoclCrcy,
  NetBookValAmtExmp13InLoclCrcy,
  PropertyTaxItem.NetBookValueAmtAvgInLoclCrcy AS NetBookValueAmtAvgInLoclCrcy,
  PropertyTaxItem.RU_PropertyTaxExemption AS RU_PropertyTaxExemption,
  PropertyTaxItem.RU_PropertyTaxExemptionDesc AS RU_PropertyTaxExemptionDesc,
  PropertyTaxItem.NetBookValAmtExmpAvgInLoclCrcy AS NetBookValAmtExmpAvgInLoclCrcy,
  PropertyTaxItem.TaxBaseAmountInCountryCrcy AS TaxBaseAmountInCountryCrcy,
  PropertyTaxItem.RU_PropertyTaxRateReduction AS RU_PropertyTaxRateReduction,
  PropertyTaxItem.RU_PropertyTaxRateReducnDesc AS RU_PropertyTaxRateReducnDesc,
  cast (PropertyTaxItem.TaxRate as firu_prt_tax_rate_output) AS TaxRate,
  PropertyTaxItem.TaxAmount AS TaxAmount,
  PropertyTaxItem.DownPaymentAmount AS DownPaymentAmount,
  PropertyTaxItem.RU_PropertyTaxAmtReduction AS RU_PropertyTaxAmtReduction,
  RU_PropertyTaxAmtReductionDesc,
  RU_PrptyTaxReducnAmtInLoclCrcy,
  PropertyTaxItem.PaidAbroadTaxAmountInLoclCrcy AS PaidAbroadTaxAmountInLoclCrcy,
  TotalTaxAmount,
  GlobAssign.RU_PropertyTaxObjectNumberType AS RU_PropertyTaxObjectNumberType,
  GlobAssign.RU_PropertyTaxObjectNumber AS RU_PropertyTaxObjectNumber,
  I_FixedAsset.Inventory AS Inventory,
  case when GlobAssign.RU_AssetOKOF is not initial then GlobAssign.RU_AssetOKOF else CountryData.RU_AssetOKOF end as RU_AssetOKOF AS RU_AssetOKOFendasRU_AssetOKOF,
  NetBookValueAmount,
  RU_PrptyCadastrAmtInLoclCrcy,
  RU_CadastrAmtExmpInLoclCrcy,
  CountryData.RU_PropertyOwnershipRegnDate AS RU_PropertyOwnershipRegnDate,
  CountryData.RU_PropertyOwnershipTermnDate AS RU_PropertyOwnershipTermnDate,
  GlobAssign.RU_AssetCommonPropertyShare AS RU_AssetCommonPropertyShare,
  GlobAssign.RU_RoomFloorAreaInSquareMeter AS RU_RoomFloorAreaInSquareMeter,
  GlobAssign.RU_RoomBuildFloorAreaInSqMtr AS RU_RoomBuildFloorAreaInSqMtr,
  MonthInFirstInterval,
  MonthInSecondInterval,
  Region,
  TaxSection,
  ControllingArea,
  VehicleLicensePlateNumber,
  CostCenter,
  Plant,
  BusinessArea,
  AssetLocation,
  Room,
  CostCtrActivityType,
  InternalOrder,
  IsShutDown,
  ResponsibleCostCenter,
  PersonnelNumber,
  MaintenanceOrder,
  TaxJurisdiction,
  Fund,
  WBSElementInternalID,
  REInternalFinNumber,
  RealEstateObject,
  ProfitCenter,
  Segment,
  FunctionalArea,
  GrantID,
  BudgetPeriod,
  FundsCenter,
  FunctionalLocation
FROM P_RU_PropertyTaxItem
INNER JOIN I_FixedAsset ON /* join condition not captured in parsed metadata */
INNER JOIN I_FixedAssetAssgmt ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_RU_FixedAssetCountryData AS CountryData ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_RU_GlobAssetAssignment AS GlobAssign ON /* join condition not captured in parsed metadata */
;