C_RU_PropertyTaxNetBookValQ

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 C_RU_PropertyTaxNetBookValQ.
-- 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: CRUPRTNBVQ
-- Parameters: P_ReportingPeriodStartDate : firu_prt_submsn_dcl_valid_from, P_ReportingPeriodEndDate : firu_prt_submsn_dcl_valid_to

CREATE VIEW C_RU_PropertyTaxNetBookValQ AS
SELECT
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID,
  CompanyCode,
  MasterFixedAsset,
  FixedAsset,
  FixedAssetDescription,
  AssetAdditionalDescription,
  AssetClass,
  ValidityStartDate,
  ValidityEndDate,
  RU_PropertyTaxOKTMO,
  RU_PropertyTaxSZPKAttribute,
  RU_AssetPropertyType,
  RU_PropertyTaxObjectNumberType,
  RU_PropertyTaxObjectNumber,
  Inventory,
  RU_AssetOKOF,
  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,
  NetBookValueAmtAvgInLoclCrcy,
  RU_PropertyTaxExemption,
  RU_PropertyTaxExemptionDesc,
  NetBookValAmtExmpAvgInLoclCrcy,
  TaxBaseAmountInCountryCrcy,
  RU_PropertyTaxRateReduction,
  RU_PropertyTaxRateReducnDesc,
  TaxRate,
  TaxAmount,
  DownPaymentAmount,
  PaidAbroadTaxAmountInLoclCrcy,
  RU_PropertyTaxAmtReduction,
  RU_PropertyTaxAmtReductionDesc,
  RU_PrptyTaxReducnAmtInLoclCrcy,
  TotalTaxAmount,
  ControllingArea,
  VehicleLicensePlateNumber,
  CostCenter,
  Plant,
  BusinessArea,
  AssetLocation,
  Room,
  CostCtrActivityType,
  InternalOrder,
  IsShutDown,
  ResponsibleCostCenter,
  PersonnelNumber,
  MaintenanceOrder,
  TaxJurisdiction,
  Fund,
  WBSElementInternalID,
  RealEstateObject,
  ProfitCenter,
  Segment,
  FunctionalArea,
  GrantID,
  BudgetPeriod,
  FundsCenter,
  FunctionalLocation
FROM I_RU_PropertyTaxItemCube
;