What is P_RU_PropertyTaxItemLogLSubmd in SAP S/4HANA?

P_RU_PropertyTaxItemLogLSubmd is a composite CDS view in SAP S/4HANA. All Reported Documents with Report RUN It contains 48 fields.

Which tables does P_RU_PropertyTaxItemLogLSubmd read from?

P_RU_PropertyTaxItemLogLSubmd reads data from: I_RU_PropertyTaxItemLog.

What VDM layer is P_RU_PropertyTaxItemLogLSubmd?

P_RU_PropertyTaxItemLogLSubmd is classified as a Composite view that combines data from multiple basic views.

P_RU_PropertyTaxItemLogLSubmd

DDL: P_RU_PROPERTYTAXITEMLOGLSUBMD SQL: PRUPRTITMLOGLSBM Type: view COMPOSITE Package: GLO_FIN_IS_RU_PROPERTY_TAX

48 Fields 1 Data Sources

All Reported Documents with Report RUN

P_RU_PropertyTaxItemLogLSubmd is a Composite CDS View that provides data about "All Reported Documents with Report RUN" in SAP S/4HANA. It reads from 1 data source (I_RU_PropertyTaxItemLog) and exposes 48 fields with key fields StatryRptgEntity, StatryRptCategory, StatryRptRunID, PositionID. Part of development package GLO_FIN_IS_RU_PROPERTY_TAX.

Data Sources (1)

Source	Alias	Join Type
I_RU_PropertyTaxItemLog	ProcessedDocs	from

Annotations (6)

Name	Value	Level
AbapCatalog.sqlViewName	PRUPRTITMLOGLSBM	view
AbapCatalog.preserveKey	true	view
VDM.viewType	#COMPOSITE	view
VDM.private	true	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view

Fields (48)

Key	Field	Source Table	Source Field	Description
KEY	StatryRptgEntity	I_RU_PropertyTaxItemLog	StatryRptgEntity	Reporting Entity
KEY	StatryRptCategory	I_RU_PropertyTaxItemLog	StatryRptCategory	Report ID
KEY	StatryRptRunID	I_RU_PropertyTaxItemLog	StatryRptRunID	Report Run ID
KEY	PositionID	I_RU_PropertyTaxItemLog	PositionID	Position ID
	CompanyCode	I_RU_PropertyTaxItemLog	CompanyCode	Receiver Company Code
	MasterFixedAsset	I_RU_PropertyTaxItemLog	MasterFixedAsset	Fixed Asset
	FixedAsset	I_RU_PropertyTaxItemLog	FixedAsset	Sub-number
	ValidityStartDate	I_RU_PropertyTaxItemLog	ValidityStartDate	Validity Start Date
	ValidityEndDate	I_RU_PropertyTaxItemLog	ValidityEndDate	ValidTo
	RU_PropertyTaxOKTMO	I_RU_PropertyTaxItemLog	RU_PropertyTaxOKTMO
	RU_AssetPropertyType	I_RU_PropertyTaxItemLog	RU_AssetPropertyType	Property Type
	NetBookValueAmt01InLoclCrcy	I_RU_PropertyTaxItemLog	NetBookValueAmt01InLoclCrcy	NBV as of 01.01
	NetBookValueAmt02InLoclCrcy	I_RU_PropertyTaxItemLog	NetBookValueAmt02InLoclCrcy	NBV as of 01.02
	NetBookValueAmt03InLoclCrcy	I_RU_PropertyTaxItemLog	NetBookValueAmt03InLoclCrcy	NBV as of 01.03
	NetBookValueAmt04InLoclCrcy	I_RU_PropertyTaxItemLog	NetBookValueAmt04InLoclCrcy	NBV as of 01.04
	NetBookValueAmt05InLoclCrcy	I_RU_PropertyTaxItemLog	NetBookValueAmt05InLoclCrcy	NBV as of 01.05
	NetBookValueAmt06InLoclCrcy	I_RU_PropertyTaxItemLog	NetBookValueAmt06InLoclCrcy	NBV as of 01.06
	NetBookValueAmt07InLoclCrcy	I_RU_PropertyTaxItemLog	NetBookValueAmt07InLoclCrcy	NBV as of 01.07
	NetBookValueAmt08InLoclCrcy	I_RU_PropertyTaxItemLog	NetBookValueAmt08InLoclCrcy	NBV as of 01.08
	NetBookValueAmt09InLoclCrcy	I_RU_PropertyTaxItemLog	NetBookValueAmt09InLoclCrcy	NBV as of 01.09
	NetBookValueAmt10InLoclCrcy	I_RU_PropertyTaxItemLog	NetBookValueAmt10InLoclCrcy	NBV as of 01.10
	NetBookValueAmt11InLoclCrcy	I_RU_PropertyTaxItemLog	NetBookValueAmt11InLoclCrcy	NBV as of 01.11
	NetBookValueAmt12InLoclCrcy	I_RU_PropertyTaxItemLog	NetBookValueAmt12InLoclCrcy	NBV as of 01.12
	NetBookValueAmt13InLoclCrcy	I_RU_PropertyTaxItemLog	NetBookValueAmt13InLoclCrcy	NBV as of 31.12
	RU_PrptyCadastrAmtInLoclCrcy	I_RU_PropertyTaxItemLog	RU_PrptyCadastrAmtInLoclCrcy	LandPlotCadastralVal
	RU_PropertyTaxExemption	I_RU_PropertyTaxItemLog	RU_PropertyTaxExemption	Tax Exemption Code
	RU_PropertyTaxExemptionDesc	I_RU_PropertyTaxItemLog	RU_PropertyTaxExemptionDesc	TaxExemptionOutCode
	RU_PropertyTaxExmpQuantity	I_RU_PropertyTaxItemLog	RU_PropertyTaxExmpQuantity	Value to Exemption
	RU_PropertyTaxExmpQuantityUnit	I_RU_PropertyTaxItemLog	RU_PropertyTaxExmpQuantityUnit	UnitOfValueToExemp
	RU_PropertyTaxRateReduction	I_RU_PropertyTaxItemLog	RU_PropertyTaxRateReduction	TaxRateReductionCode
	RU_PropertyTaxRateReducnDesc	I_RU_PropertyTaxItemLog	RU_PropertyTaxRateReducnDesc	TaxRateReducnOutCode
	TaxRate	I_RU_PropertyTaxItemLog	TaxRate	Tax Rate
	TaxBaseAmountInCountryCrcy	I_RU_PropertyTaxItemLog	TaxBaseAmountInCountryCrcy	Base Amount
	TaxAmount	I_RU_PropertyTaxItemLog	TaxAmount	Tax Amt in Rptg Crcy
	DownPaymentAmount	I_RU_PropertyTaxItemLog	DownPaymentAmount	Downpayment
	RU_PropertyTaxAmtReduction	I_RU_PropertyTaxItemLog	RU_PropertyTaxAmtReduction	Tax Amount Red.Code
	RU_PropertyTaxAmtReductionDesc	I_RU_PropertyTaxItemLog	RU_PropertyTaxAmtReductionDesc	TaxAmtReducnOutCode
	RU_PrptyTaxReducnAmtInLoclCrcy	I_RU_PropertyTaxItemLog	RU_PrptyTaxReducnAmtInLoclCrcy	TaxAmountReduction
	MonthInFirstInterval	I_RU_PropertyTaxItemLog	MonthInFirstInterval	Months of Ownership
	MonthInSecondInterval	I_RU_PropertyTaxItemLog	MonthInSecondInterval	Months of Cad. Value
	PaidAbroadTaxAmountInLoclCrcy	I_RU_PropertyTaxItemLog	PaidAbroadTaxAmountInLoclCrcy	Tax Paid Abroad
	Region	I_RU_PropertyTaxItemLog	Region	Venue Region
	RU_AssetIsMovableProperty	I_RU_PropertyTaxItemLog	RU_AssetIsMovableProperty	Is Movable Property
	RU_PropertyTaxSZPKAttribute	I_RU_PropertyTaxItemLog	RU_PropertyTaxSZPKAttribute	SZPK Attribute
	StatryRptTaskPeriod	ReportRuns	StatryRptTaskPeriod	Tax Period
	ReportingYear	ReportRuns	ReportingYear
	StatryRptTaskPeriodStartDate	ReportRuns	StatryRptTaskPeriodStartDate
	StatryRptTaskPeriodEndDate	ReportRuns	StatryRptTaskPeriodEndDate

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_PropertyTaxItemLogLSubmd.
-- 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: PRUPRTITMLOGLSBM

CREATE VIEW P_RU_PropertyTaxItemLogLSubmd AS
SELECT
  ProcessedDocs.StatryRptgEntity AS StatryRptgEntity,
  ProcessedDocs.StatryRptCategory AS StatryRptCategory,
  ProcessedDocs.StatryRptRunID AS StatryRptRunID,
  ProcessedDocs.PositionID AS PositionID,
  ProcessedDocs.CompanyCode AS CompanyCode,
  ProcessedDocs.MasterFixedAsset AS MasterFixedAsset,
  ProcessedDocs.FixedAsset AS FixedAsset,
  ProcessedDocs.ValidityStartDate AS ValidityStartDate,
  ProcessedDocs.ValidityEndDate AS ValidityEndDate,
  ProcessedDocs.RU_PropertyTaxOKTMO AS RU_PropertyTaxOKTMO,
  ProcessedDocs.RU_AssetPropertyType AS RU_AssetPropertyType,
  ProcessedDocs.NetBookValueAmt01InLoclCrcy AS NetBookValueAmt01InLoclCrcy,
  ProcessedDocs.NetBookValueAmt02InLoclCrcy AS NetBookValueAmt02InLoclCrcy,
  ProcessedDocs.NetBookValueAmt03InLoclCrcy AS NetBookValueAmt03InLoclCrcy,
  ProcessedDocs.NetBookValueAmt04InLoclCrcy AS NetBookValueAmt04InLoclCrcy,
  ProcessedDocs.NetBookValueAmt05InLoclCrcy AS NetBookValueAmt05InLoclCrcy,
  ProcessedDocs.NetBookValueAmt06InLoclCrcy AS NetBookValueAmt06InLoclCrcy,
  ProcessedDocs.NetBookValueAmt07InLoclCrcy AS NetBookValueAmt07InLoclCrcy,
  ProcessedDocs.NetBookValueAmt08InLoclCrcy AS NetBookValueAmt08InLoclCrcy,
  ProcessedDocs.NetBookValueAmt09InLoclCrcy AS NetBookValueAmt09InLoclCrcy,
  ProcessedDocs.NetBookValueAmt10InLoclCrcy AS NetBookValueAmt10InLoclCrcy,
  ProcessedDocs.NetBookValueAmt11InLoclCrcy AS NetBookValueAmt11InLoclCrcy,
  ProcessedDocs.NetBookValueAmt12InLoclCrcy AS NetBookValueAmt12InLoclCrcy,
  ProcessedDocs.NetBookValueAmt13InLoclCrcy AS NetBookValueAmt13InLoclCrcy,
  ProcessedDocs.RU_PrptyCadastrAmtInLoclCrcy AS RU_PrptyCadastrAmtInLoclCrcy,
  ProcessedDocs.RU_PropertyTaxExemption AS RU_PropertyTaxExemption,
  ProcessedDocs.RU_PropertyTaxExemptionDesc AS RU_PropertyTaxExemptionDesc,
  ProcessedDocs.RU_PropertyTaxExmpQuantity AS RU_PropertyTaxExmpQuantity,
  ProcessedDocs.RU_PropertyTaxExmpQuantityUnit AS RU_PropertyTaxExmpQuantityUnit,
  ProcessedDocs.RU_PropertyTaxRateReduction AS RU_PropertyTaxRateReduction,
  ProcessedDocs.RU_PropertyTaxRateReducnDesc AS RU_PropertyTaxRateReducnDesc,
  ProcessedDocs.TaxRate AS TaxRate,
  ProcessedDocs.TaxBaseAmountInCountryCrcy AS TaxBaseAmountInCountryCrcy,
  ProcessedDocs.TaxAmount AS TaxAmount,
  ProcessedDocs.DownPaymentAmount AS DownPaymentAmount,
  ProcessedDocs.RU_PropertyTaxAmtReduction AS RU_PropertyTaxAmtReduction,
  ProcessedDocs.RU_PropertyTaxAmtReductionDesc AS RU_PropertyTaxAmtReductionDesc,
  ProcessedDocs.RU_PrptyTaxReducnAmtInLoclCrcy AS RU_PrptyTaxReducnAmtInLoclCrcy,
  ProcessedDocs.MonthInFirstInterval AS MonthInFirstInterval,
  ProcessedDocs.MonthInSecondInterval AS MonthInSecondInterval,
  ProcessedDocs.PaidAbroadTaxAmountInLoclCrcy AS PaidAbroadTaxAmountInLoclCrcy,
  ProcessedDocs.Region AS Region,
  ProcessedDocs.RU_AssetIsMovableProperty AS RU_AssetIsMovableProperty,
  ProcessedDocs.RU_PropertyTaxSZPKAttribute AS RU_PropertyTaxSZPKAttribute,
  ReportRuns.StatryRptTaskPeriod AS StatryRptTaskPeriod,
  ReportRuns.ReportingYear AS ReportingYear,
  ReportRuns.StatryRptTaskPeriodStartDate AS StatryRptTaskPeriodStartDate,
  ReportRuns.StatryRptTaskPeriodEndDate AS StatryRptTaskPeriodEndDate
FROM I_RU_PropertyTaxItemLog AS ProcessedDocs
;

Depth:

P_RU_PropertyTaxItemLogLSubmd view

I_RU_PropertyTaxItemLog view