P_RU_LandTaxItem1

DDL: P_RU_LANDTAXITEM1 SQL: PRULNDTITEM1 Type: view COMPOSITE
25 Fields 1 Data Sources

P_RU_LandTaxItem1 is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_RU_LandTaxItemLog) and exposes 25 fields with key fields StatryRptgEntity, StatryRptCategory, StatryRptRunID, RU_LandTaxItemNumber.

Data Sources (1)

SourceAliasJoin Type
I_RU_LandTaxItemLog I_RU_LandTaxItemLog from

Parameters (1)

NameTypeDefault
P_ReportingPeriodEndDate firu_prt_submsn_dcl_valid_to

Annotations (7)

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

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY StatryRptgEntity StatryRptgEntity Reporting Entity
KEY StatryRptCategory StatryRptCategory Report ID
KEY StatryRptRunID StatryRptRunID Report Run ID
KEY RU_LandTaxItemNumber RU_LandTaxItemNumber Russia Statutory Reporting Report Land Tax, Run Item ID
CompanyCode CompanyCode Receiver Company Code
MasterFixedAsset MasterFixedAsset Fixed Asset
FixedAsset FixedAsset Sub-number
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
RU_LandTaxOKTMO RU_LandTaxOKTMO
RU_CadastrAmtInLoclCrcy RU_CadastrAmtInLoclCrcy LandPlotCadastralVal
RU_AssetCommonPropertyShare RU_AssetCommonPropertyShare ShareRightOwnership
RU_LandTaxBaseReduction RU_LandTaxBaseReduction TaxBaseReductionCode
RU_LandTaxBaseReducnAmount RU_LandTaxBaseReducnAmount TaxBaseReduction
TaxBaseAmountInCountryCrcy TaxBaseAmountInCountryCrcy Base Amount
TaxRate TaxRate Tax Rate
RU_LandTaxRateReduction RU_LandTaxRateReduction TaxRateReductionCode
RU_LandTaxReducedRate RU_LandTaxReducedRate Reduced Tax Rate
RU_LandTaxAmtReduction RU_LandTaxAmtReduction Tax Amount Red.Code
RU_LandTaxReducnAmtInLoclCrcy RU_LandTaxReducnAmtInLoclCrcy TaxAmountReduction
TaxOverpaymentAmountInLoclCrcy TaxOverpaymentAmountInLoclCrcy Overpayment Amount
TotalTaxAmount
RU_LandPlotOwnershipInMonths RU_LandPlotOwnershipInMonths Months of Ownership
RU_CadastrAmtValidityInMonths RU_CadastrAmtValidityInMonths Months of Cad. Value
RU_LandTxConstructionCoeffVal RU_LandTxConstructionCoeffVal CoeffConstrPeriod

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_LandTaxItem1.
-- 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: PRULNDTITEM1
-- Parameters: P_ReportingPeriodEndDate : firu_prt_submsn_dcl_valid_to

CREATE VIEW P_RU_LandTaxItem1 AS
SELECT
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID,
  RU_LandTaxItemNumber,
  CompanyCode,
  MasterFixedAsset,
  FixedAsset,
  ValidityStartDate,
  ValidityEndDate,
  RU_LandTaxOKTMO,
  RU_CadastrAmtInLoclCrcy,
  RU_AssetCommonPropertyShare,
  RU_LandTaxBaseReduction,
  RU_LandTaxBaseReducnAmount,
  TaxBaseAmountInCountryCrcy,
  TaxRate,
  RU_LandTaxRateReduction,
  RU_LandTaxReducedRate,
  RU_LandTaxAmtReduction,
  RU_LandTaxReducnAmtInLoclCrcy,
  TaxOverpaymentAmountInLoclCrcy,
  cast( ( TaxAmountInCountryCrcy - RU_LandTaxReducnAmtInLoclCrcy - DownPaymentQtr1AmtInLoclCrcy - DownPaymentQtr2AmtInLoclCrcy - DownPaymentQtr3AmtInLoclCrcy - TaxOverpaymentAmountInLoclCrcy ) as firu_lndt_tax_amount_total ) AS TotalTaxAmount,
  RU_LandPlotOwnershipInMonths,
  RU_CadastrAmtValidityInMonths,
  RU_LandTxConstructionCoeffVal
FROM I_RU_LandTaxItemLog
;

Learn More