P_RU_PropertyTaxFixedAsset2

DDL: P_RU_PROPERTYTAXFIXEDASSET2 SQL: PRUPRTFASSET2 Type: view COMPOSITE Package: GLO_FIN_IS_RU_PROPERTY_TAX
57 Fields 3 Data Sources

Russia Property Tax Fixed Asset Data

P_RU_PropertyTaxFixedAsset2 is a Composite CDS View that provides data about "Russia Property Tax Fixed Asset Data" in SAP S/4HANA. It reads from 3 data sources (I_FixedAssetForLedger, P_RU_PropertyTaxFixedAsset1, P_RU_PropertyTaxFixedAsset1) and exposes 57 fields with key fields CompanyCode, MasterFixedAsset, FixedAsset, DateTo, MasterFixedAsset. Part of development package GLO_FIN_IS_RU_PROPERTY_TAX.

Data Sources (3)

SourceAliasJoin Type
I_FixedAssetForLedger _FixedAssetForLedger inner
P_RU_PropertyTaxFixedAsset1 P_RU_PropertyTaxFixedAsset1 from
P_RU_PropertyTaxFixedAsset1 P_RU_PropertyTaxFixedAsset1 union_all

Parameters (2)

NameTypeDefault
P_PeriodStartDate dats
P_PeriodEndDate dats

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PRUPRTFASSET2 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #COMPOSITE view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (57)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode _PropertyTaxFixedAsset CompanyCode Receiver Company Code
KEY MasterFixedAsset _PropertyTaxFixedAsset MasterFixedAsset Fixed Asset
KEY FixedAsset _PropertyTaxFixedAsset FixedAsset Sub-number
KEY DateTo _PropertyTaxFixedAsset DateTo Valid-To Date
DateFrom _PropertyTaxFixedAsset DateFrom Valid From
OKOF _PropertyTaxFixedAsset OKOF New OKOF Code
IsSZPKApplied _PropertyTaxFixedAsset IsSZPKApplied
OKTMO _PropertyTaxFixedAsset OKTMO OKTMO
PropertyType _PropertyTaxFixedAsset PropertyType Property Type
TaxExemptionId _PropertyTaxFixedAsset TaxExemptionId Tax Exemption Code
TaxAmtReducnId _PropertyTaxFixedAsset TaxAmtReducnId Tax Amount Red.Code
TaxRateReducnId _PropertyTaxFixedAsset TaxRateReducnId TaxRateReductionCode
SpecialTaxCategory _PropertyTaxFixedAsset SpecialTaxCategory
AreaLocal _PropertyTaxFixedAsset AreaLocal
AreaTotal _PropertyTaxFixedAsset AreaTotal
PropertyShare _PropertyTaxFixedAsset PropertyShare
PropertyNumber _PropertyTaxFixedAsset PropertyNumber
PropertyNumberType _PropertyTaxFixedAsset PropertyNumberType
CadastralValue _PropertyTaxFixedAsset CadastralValue LandPlotCadastralVal
TaxOffice _PropertyTaxFixedAsset TaxOffice Dis. Tax Office
InventoryNumber _PropertyTaxFixedAsset InventoryNumber Ci Inventory
AddressNumber _PropertyTaxFixedAsset AddressNumber Src Address No
OwnershipRegistrationDate _PropertyTaxFixedAsset OwnershipRegistrationDate
OwnershipTerminationDate _PropertyTaxFixedAsset OwnershipTerminationDate
IsTaxableByCadastralValue _PropertyTaxFixedAsset IsTaxableByCadastralValue
Ledger I_FixedAssetForLedger Ledger Ledger
AssetCapitalizationDate I_FixedAssetForLedger AssetCapitalizationDate Asset Capitalization
P_PeriodStartDate
CompanyCode Receiver Company Code
KEY MasterFixedAsset _PropertyTaxFixedAsset MasterFixedAsset Fixed Asset
KEY FixedAsset _PropertyTaxFixedAsset FixedAsset Sub-number
KEY DateTo _PropertyTaxFixedAsset DateTo Valid-To Date
DateFrom _PropertyTaxFixedAsset DateFrom Valid From
OKOF _PropertyTaxFixedAsset OKOF New OKOF Code
IsSZPKApplied _PropertyTaxFixedAsset IsSZPKApplied
OKTMO _PropertyTaxFixedAsset OKTMO OKTMO
PropertyType _PropertyTaxFixedAsset PropertyType Property Type
TaxExemptionId _PropertyTaxFixedAsset TaxExemptionId Tax Exemption Code
TaxAmtReducnId _PropertyTaxFixedAsset TaxAmtReducnId Tax Amount Red.Code
TaxRateReducnId _PropertyTaxFixedAsset TaxRateReducnId TaxRateReductionCode
SpecialTaxCategory _PropertyTaxFixedAsset SpecialTaxCategory
AreaLocal _PropertyTaxFixedAsset AreaLocal
AreaTotal _PropertyTaxFixedAsset AreaTotal
PropertyShare _PropertyTaxFixedAsset PropertyShare
PropertyNumber _PropertyTaxFixedAsset PropertyNumber
PropertyNumberType _PropertyTaxFixedAsset PropertyNumberType
CadastralValue _PropertyTaxFixedAsset CadastralValue LandPlotCadastralVal
TaxOffice _PropertyTaxFixedAsset TaxOffice Dis. Tax Office
InventoryNumber _PropertyTaxFixedAsset InventoryNumber Ci Inventory
AddressNumber _PropertyTaxFixedAsset AddressNumber Src Address No
OwnershipRegistrationDate _PropertyTaxFixedAsset OwnershipRegistrationDate
OwnershipTerminationDate _PropertyTaxFixedAsset OwnershipTerminationDate
IsTaxableByCadastralValue _PropertyTaxFixedAsset IsTaxableByCadastralValue
IsRealEstate
Ledger Ledger
AssetCapitalizationDate Asset Capitalization
AssetDeactivationDate

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 P_RU_PropertyTaxFixedAsset2.
-- 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: PRUPRTFASSET2
-- Parameters: P_PeriodStartDate : dats, P_PeriodEndDate : dats

CREATE VIEW P_RU_PropertyTaxFixedAsset2 AS
SELECT
  _PropertyTaxFixedAsset.CompanyCode AS CompanyCode,
  _PropertyTaxFixedAsset.MasterFixedAsset AS MasterFixedAsset,
  _PropertyTaxFixedAsset.FixedAsset AS FixedAsset,
  _PropertyTaxFixedAsset.DateTo AS DateTo,
  _PropertyTaxFixedAsset.DateFrom AS DateFrom,
  _PropertyTaxFixedAsset.OKOF AS OKOF,
  _PropertyTaxFixedAsset.IsSZPKApplied AS IsSZPKApplied,
  _PropertyTaxFixedAsset.OKTMO AS OKTMO,
  _PropertyTaxFixedAsset.PropertyType AS PropertyType,
  _PropertyTaxFixedAsset.TaxExemptionId AS TaxExemptionId,
  _PropertyTaxFixedAsset.TaxAmtReducnId AS TaxAmtReducnId,
  _PropertyTaxFixedAsset.TaxRateReducnId AS TaxRateReducnId,
  _PropertyTaxFixedAsset.SpecialTaxCategory AS SpecialTaxCategory,
  _PropertyTaxFixedAsset.AreaLocal AS AreaLocal,
  _PropertyTaxFixedAsset.AreaTotal AS AreaTotal,
  _PropertyTaxFixedAsset.PropertyShare AS PropertyShare,
  _PropertyTaxFixedAsset.PropertyNumber AS PropertyNumber,
  _PropertyTaxFixedAsset.PropertyNumberType AS PropertyNumberType,
  _PropertyTaxFixedAsset.CadastralValue AS CadastralValue,
  _PropertyTaxFixedAsset.TaxOffice AS TaxOffice,
  _PropertyTaxFixedAsset.InventoryNumber AS InventoryNumber,
  _PropertyTaxFixedAsset.AddressNumber AS AddressNumber,
  _PropertyTaxFixedAsset.OwnershipRegistrationDate AS OwnershipRegistrationDate,
  _PropertyTaxFixedAsset.OwnershipTerminationDate AS OwnershipTerminationDate,
  _PropertyTaxFixedAsset.IsTaxableByCadastralValue AS IsTaxableByCadastralValue,
  _FixedAssetForLedger.Ledger AS Ledger,
  _FixedAssetForLedger.AssetCapitalizationDate AS AssetCapitalizationDate,
  _FixedAssetForLedger.AssetDeactivationDate AS P_PeriodStartDate,
  'X' AS IsRealEstate,
  cast( '00000000' as dats) AS AssetDeactivationDate
FROM P_RU_PropertyTaxFixedAsset1
INNER JOIN I_FixedAssetForLedger AS _FixedAssetForLedger ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): P_RU_PropertyTaxFixedAsset1
;

Learn More