Which tables does P_RU_PropertyTaxFixedAssetVal1 read from?

P_RU_PropertyTaxFixedAssetVal1 reads data from: I_FiscalYearPeriodForLedger, I_FixedAssetValue, I_FixedAssetValue, I_FixedAssetValue, P_RU_MaxFiscalPeriodForLedger and more.

What VDM layer is P_RU_PropertyTaxFixedAssetVal1?

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

P_RU_PropertyTaxFixedAssetVal1

Q: What is P_RU_PropertyTaxFixedAssetVal1 in SAP S/4HANA?

P_RU_PropertyTaxFixedAssetVal1 is a composite CDS view in SAP S/4HANA. It contains 70 fields.

DDL: P_RU_PROPERTYTAXFIXEDASSETVAL1 SQL: PRUPRTFASSETVAL1 Type: view COMPOSITE

70 Fields 6 Data Sources

P_RU_PropertyTaxFixedAssetVal1 is a Composite CDS View in SAP S/4HANA. It reads from 6 data sources and exposes 70 fields with key fields CompanyCode, AssetDepreciationArea, MasterFixedAsset, FixedAsset, AccountingDocument.

Data Sources (6)

Source	Alias	Join Type
I_FiscalYearPeriodForLedger	CalendarPostingPeriod	from
I_FixedAssetValue	I_FixedAssetValue	inner
I_FixedAssetValue	I_FixedAssetValue	inner
I_FixedAssetValue	I_FixedAssetValue	inner
P_RU_MaxFiscalPeriodForLedger	P_RU_MaxFiscalPeriodForLedger	union_all
P_RU_MinFiscalPeriodForLedger	P_RU_MinFiscalPeriodForLedger	union_all

Parameters (3)

Name	Type	Default
P_StartDate	adatu
P_EndDate	bdatu
P_AssetAccountingKeyFigureSet	faa_key_figure_set

Annotations (6)

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

Fields (70)

Key	Field	Source Table	Source Field	Description
KEY	CompanyCode	AssetValues	CompanyCode	Receiver Company Code
KEY	AssetDepreciationArea	AssetValues	AssetDepreciationArea	Deprec. Area
KEY	MasterFixedAsset	AssetValues	MasterFixedAsset	Fixed Asset
KEY	FixedAsset	AssetValues	FixedAsset	Sub-number
KEY	AccountingDocument	AssetValues	AccountingDocument	Journal Entry
KEY	TransactionSubitem	AssetValues	TransactionSubitem	Sub Transaction
KEY	Ledger	AssetValues	Ledger	Ledger
KEY	FiscalYear	AssetValues	FiscalYear	G/L Fiscal Year
KEY	FiscalPeriod	AssetValues	FiscalPeriod	Tax period
KEY	SubLedgerAcctLineItemType	AssetValues	SubLedgerAcctLineItemType	SLALineItemType
KEY	AssetAcctTransClassfctn	AssetValues	AssetAcctTransClassfctn	Trans.Type Cat.
KEY	AssetAccountingKeyFigureSet	AssetValues	AssetAccountingKeyFigureSet
KEY	AssetAccountingKeyFigure	AssetValues	AssetAccountingKeyFigure
KEY	DebitCreditCode	AssetValues	DebitCreditCode	Single-Character Flag
	DocumentDate	AssetValues	DocumentDate	Journal Entry Date
	PostingDate	AssetValues	PostingDate	Posting Date for GR
	AssetValueDate	AssetValues	AssetValueDate	Reference date
	AssetTransactionType	AssetValues	AssetTransactionType	Trans.Type
	AssetClass	AssetValues	AssetClass	Asset Class
	AssetCapitalizationDate	AssetValues	AssetCapitalizationDate	Asset Capitalization
	AssetDeactivationDate	AssetValues	AssetDeactivationDate
	DepreciationFiscalPeriod	AssetValues	DepreciationFiscalPeriod	Deprec. Period
	CompanyCodeCurrency	AssetValues	CompanyCodeCurrency	Local Currency
	CompanyCode			Receiver Company Code
KEY	AssetDepreciationArea	AssetValues	AssetDepreciationArea	Deprec. Area
KEY	MasterFixedAsset	AssetValues	MasterFixedAsset	Fixed Asset
KEY	FixedAsset	AssetValues	FixedAsset	Sub-number
KEY	AccountingDocument	AssetValues	AccountingDocument	Journal Entry
KEY	TransactionSubitem	AssetValues	TransactionSubitem	Sub Transaction
KEY	Ledger	AssetValues	Ledger	Ledger
KEY	FiscalYear	AssetValues	FiscalYear	G/L Fiscal Year
KEY	FiscalPeriod	AssetValues	FiscalPeriod	Tax period
KEY	SubLedgerAcctLineItemType	AssetValues	SubLedgerAcctLineItemType	SLALineItemType
KEY	AssetAcctTransClassfctn	AssetValues	AssetAcctTransClassfctn	Trans.Type Cat.
KEY	AssetAccountingKeyFigureSet	AssetValues	AssetAccountingKeyFigureSet
KEY	AssetAccountingKeyFigure	AssetValues	AssetAccountingKeyFigure
KEY	DebitCreditCode	AssetValues	DebitCreditCode	Single-Character Flag
	DocumentDate	AssetValues	DocumentDate	Journal Entry Date
	PostingDate	AssetValues	PostingDate	Posting Date for GR
	AssetValueDate	AssetValues	AssetValueDate	Reference date
	AssetTransactionType	AssetValues	AssetTransactionType	Trans.Type
	AssetClass	AssetValues	AssetClass	Asset Class
	AssetCapitalizationDate	AssetValues	AssetCapitalizationDate	Asset Capitalization
	AssetDeactivationDate	AssetValues	AssetDeactivationDate
	DepreciationFiscalPeriod	AssetValues	DepreciationFiscalPeriod	Deprec. Period
	CompanyCodeCurrency	AssetValues	CompanyCodeCurrency	Local Currency
	CompanyCode			Receiver Company Code
KEY	AssetDepreciationArea	AssetValues	AssetDepreciationArea	Deprec. Area
KEY	MasterFixedAsset	AssetValues	MasterFixedAsset	Fixed Asset
KEY	FixedAsset	AssetValues	FixedAsset	Sub-number
KEY	AccountingDocument	AssetValues	AccountingDocument	Journal Entry
KEY	TransactionSubitem	AssetValues	TransactionSubitem	Sub Transaction
KEY	Ledger	AssetValues	Ledger	Ledger
KEY	FiscalYear	AssetValues	FiscalYear	G/L Fiscal Year
KEY	FiscalPeriod	AssetValues	FiscalPeriod	Tax period
KEY	SubLedgerAcctLineItemType	AssetValues	SubLedgerAcctLineItemType	SLALineItemType
KEY	AssetAcctTransClassfctn	AssetValues	AssetAcctTransClassfctn	Trans.Type Cat.
KEY	AssetAccountingKeyFigureSet	AssetValues	AssetAccountingKeyFigureSet
KEY	AssetAccountingKeyFigure	AssetValues	AssetAccountingKeyFigure
KEY	DebitCreditCode	AssetValues	DebitCreditCode	Single-Character Flag
	DocumentDate	AssetValues	DocumentDate	Journal Entry Date
	PostingDate	AssetValues	PostingDate	Posting Date for GR
	AssetValueDate	AssetValues	AssetValueDate	Reference date
	AssetTransactionType	AssetValues	AssetTransactionType	Trans.Type
	AssetClass	AssetValues	AssetClass	Asset Class
	AssetCapitalizationDate	AssetValues	AssetCapitalizationDate	Asset Capitalization
	AssetDeactivationDate	AssetValues	AssetDeactivationDate
	DepreciationFiscalPeriod	AssetValues	DepreciationFiscalPeriod	Deprec. Period
	CompanyCodeCurrency	AssetValues	CompanyCodeCurrency	Local Currency
	AmountInCompanyCodeCurrency

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_PropertyTaxFixedAssetVal1.
-- 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: PRUPRTFASSETVAL1
-- Parameters: P_StartDate : adatu, P_EndDate : bdatu, P_AssetAccountingKeyFigureSet : faa_key_figure_set

CREATE VIEW P_RU_PropertyTaxFixedAssetVal1 AS
SELECT
  AssetValues.CompanyCode AS CompanyCode,
  AssetValues.AssetDepreciationArea AS AssetDepreciationArea,
  AssetValues.MasterFixedAsset AS MasterFixedAsset,
  AssetValues.FixedAsset AS FixedAsset,
  AssetValues.AccountingDocument AS AccountingDocument,
  AssetValues.TransactionSubitem AS TransactionSubitem,
  AssetValues.Ledger AS Ledger,
  AssetValues.FiscalYear AS FiscalYear,
  AssetValues.FiscalPeriod AS FiscalPeriod,
  AssetValues.SubLedgerAcctLineItemType AS SubLedgerAcctLineItemType,
  AssetValues.AssetAcctTransClassfctn AS AssetAcctTransClassfctn,
  AssetValues.AssetAccountingKeyFigureSet AS AssetAccountingKeyFigureSet,
  AssetValues.AssetAccountingKeyFigure AS AssetAccountingKeyFigure,
  AssetValues.DebitCreditCode AS DebitCreditCode,
  AssetValues.DocumentDate AS DocumentDate,
  AssetValues.PostingDate AS PostingDate,
  AssetValues.AssetValueDate AS AssetValueDate,
  AssetValues.AssetTransactionType AS AssetTransactionType,
  AssetValues.AssetClass AS AssetClass,
  AssetValues.AssetCapitalizationDate AS AssetCapitalizationDate,
  AssetValues.AssetDeactivationDate AS AssetDeactivationDate,
  AssetValues.DepreciationFiscalPeriod AS DepreciationFiscalPeriod,
  AssetValues.CompanyCodeCurrency AS CompanyCodeCurrency,
  cast( AssetValues.AmountInCompanyCodeCurrency as fis_hsl ) AS AmountInCompanyCodeCurrency
FROM I_FiscalYearPeriodForLedger AS CalendarPostingPeriod
INNER JOIN I_FixedAssetValue ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): P_RU_MinFiscalPeriodForLedger, P_RU_MaxFiscalPeriodForLedger
;

Depth:

P_RU_PropertyTaxFixedAssetVal1 view

P_RU_PropertyTaxFixedAssetVal2 view