P_RU_PropertyTaxFixedAssetVal3

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_PropertyTaxFixedAssetVal3.
-- 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: PRUPRTFASSETVAL3
-- Parameters: P_StartDate : adatu, P_EndDate : bdatu, P_DeprPeriod : char1, P_AssetAccountingKeyFigureSet : faa_key_figure_set

CREATE VIEW P_RU_PropertyTaxFixedAssetVal3 AS
SELECT
  AssetValues.CompanyCode AS CompanyCode,
  AssetValues.AssetDepreciationArea AS AssetDepreciationArea,
  AssetValues.MasterFixedAsset AS MasterFixedAsset,
  AssetValues.FixedAsset AS FixedAsset,
  AssetValues.AssetClass AS AssetClass,
  AssetValues.AssetCapitalizationDate AS AssetCapitalizationDate,
  AssetValues.AssetDeactivationDate AS AssetDeactivationDate,
  AssetValues.Ledger AS Ledger,
  AssetValues.FiscalYear AS FiscalYear,
  AssetValues.FiscalPeriod AS FiscalPeriod,
  AssetValues.DocumentDate AS DocumentDate,
  AssetValues.PostingDate AS PostingDate,
  AssetValues.AssetValueDate AS AssetValueDate,
  AssetValues.AssetAccountingKeyFigure AS AssetAccountingKeyFigure,
  AssetValues.AssetAcctTransClassfctn AS AssetAcctTransClassfctn,
  AssetValues.SubLedgerAcctLineItemType AS SubLedgerAcctLineItemType,
  AssetValues.AssetTransactionType AS AssetTransactionType,
  AssetValues.CompanyCodeCurrency AS CompanyCodeCurrency,
  AssetValues.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  AssetValues.DepreciationFiscalPeriod AS DepreciationFiscalPeriod,
  CalendarPostingPeriod.FiscalPeriodStartDate AS CalendarPostingPeriodStartDate,
  CalendarPostingPeriod.FiscalPeriodEndDate AS CalendarPostingPeriodEndDate,
  CalendarDeprPeriod.FiscalPeriodStartDate AS CalendarDeprPeriodStartDate,
  CalendarDeprPeriod.FiscalPeriodEndDate AS CalendarDeprPeriodEndDate
FROM P_RU_PropertyTaxFixedAssetVal2
LEFT OUTER JOIN I_FiscalYearPeriodForLedger AS CalendarPostingPeriod ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_FiscalYearPeriodForLedger AS CalendarDeprPeriod ON /* join condition not captured in parsed metadata */
;