I_PT_AssetReportFormContent

DDL: I_PT_ASSETREPORTFORMCONTENT SQL: IPTARFMAPCONTENT Type: view BASIC Package: GLO_FIN_IS_AA_FISCMAPS_PT
58 Fields 1 Data Sources

PT Asset Fiscal Maps: Forms Content (ACR)

I_PT_AssetReportFormContent is a Basic CDS View that provides data about "PT Asset Fiscal Maps: Forms Content (ACR)" in SAP S/4HANA. It reads from 1 data source (fiaaptd_fsclmap) and exposes 58 fields with key fields StatryRptgEntity, StatryRptCategory, StatryRptRunID, CompanyCode, FiscalYear. Part of development package GLO_FIN_IS_AA_FISCMAPS_PT.

Data Sources (1)

SourceAliasJoin Type
fiaaptd_fsclmap fiaaptd_fsclmap from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IPTARFMAPCONTENT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label PT Asset Fiscal Maps: Forms Content (ACR) view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view

Fields (58)

KeyFieldSource TableSource FieldDescription
KEY StatryRptgEntity statryrptgentity Reporting Entity
KEY StatryRptCategory statryrptcategory Report ID
KEY StatryRptRunID statryrptrunid Report Run ID
KEY CompanyCode companycode Receiver Company Code
KEY FiscalYear fiscalyear G/L Fiscal Year
KEY AssetReportFormClass assetreportformclass Asset Form Class
KEY AssetReportForm assetreportform Asset Report Form
KEY AssetReportFormCategoryName assetreportformcategoryname Category Name
KEY AssetRptFormRtrmtCategoryName assetrptformrtrmtcategoryname Ret. Category Name
KEY SequenceNumber sequencenumber Sort sequence
KEY MasterFixedAsset masterfixedasset Fixed Asset
KEY FixedAsset fixedasset Sub-number
AssetTransactionType assettransactiontype Trans.Type
AssetReportFormType assetreportformtype Asset Category
AdditionalAssetReportFormType additionalassetreportformtype Asset Category
AssetEvaluationGroup assetevaluationgroup Natl. Clfn. Code
FixedAssetDescription fixedassetdescription Description
FirstAcquisitionFiscalYear firstacquisitionfiscalyear Acquisition Yr
DepreciationStartPeriod depreciationstartperiod Months
DepreciationStartYear depreciationstartyear Use Start Year
LandAssetLink landassetlink Land or Build.
BigRepairAssetLink bigrepairassetlink Repair Asset
AssetRealizationAmount assetrealizationamount Realization Amt.
BookAcquisitionAmount bookacquisitionamount APC Book
TaxAcquisitionAmount taxacquisitionamount APC Tax
BookValueAdjustmentAmount bookvalueadjustmentamount Tot.Val.Adj.
BookCapitalGainAmountSign bookcapitalgainamountsign BC.Gain +/-
BookCapitalGainAmount bookcapitalgainamount Capital Gain
NotTaxedCapitalGainAmount nottaxedcapitalgainamount Not Tax. Cap. Gain
TaxValueAdjustmentAmount taxvalueadjustmentamount Tax Adjustment
DevaluationCoefficient devaluationcoefficient Cooeficient
TaxCapitalGainAmountSign taxcapitalgainamountsign TC.Gain +/-
TaxCapitalGainAmount taxcapitalgainamount Tax Cap. Gain
PlannedUsefulLifeInDcmlYears plannedusefullifeindcmlyears Useful Life
ReportedBookDepreciationAmount reportedbookdepreciationamount Book Depr. Yr.
ReportedCumulativeTaxDeprAmt reportedcumulativetaxdepramt Ac.Tax Deprec.
PlannedUsefulLifeInYears plannedusefullifeinyears Planned Use Life Yr.
TaxDepreciationRate taxdepreciationrate Tax Rate
RevisedTaxDepreciationRate revisedtaxdepreciationrate Rev. Depr. Rate
ReportedTaxDepreciationAmount reportedtaxdepreciationamount Tax Depr. Yr.
AcceptedImpairmentLossAmount acceptedimpairmentlossamount Acptd. Impr. Loss
CumulativeLossTaxDeprRate cumulativelosstaxdeprrate Cum. Loss Tax Rate
NotAcceptedDepreciationAmount notaccepteddepreciationamount NA. Depreciation
RecoveredImprmtLossAndDeprAmt recoveredimprmtlossanddepramt Imprmt. Loss Dep.
AcqnProdnCostAndRevalAmount acqnprodncostandrevalamount APC after Reval.
PrevAcqnProdnCostAndRevalAmt prevacqnprodncostandrevalamt APC Rev.Prev.Ed.
TotalAcqnProdnCostAndRevalAmt totalacqnprodncostandrevalamt APC Rev.All Ed.
RltvExpiredUsefulLifeInYears rltvexpiredusefullifeinyears Exp. Use Life Yr.
RltvRemainingUsefulLifeInYears rltvremainingusefullifeinyears Rem. Use Life Yr.
AddlPlannedUsefulLifeInYears addlplannedusefullifeinyears Add. Use Life Yr.
AdditionalTaxDepreciationRate additionaltaxdepreciationrate Add. Tax Rate
CumulativeDepreciationAmount cumulativedepreciationamount Cum. Depr.
TotalDepreciationAmount totaldepreciationamount Depr. Total
NetBookValueAmount netbookvalueamount Net Book Value
TaxExemptionAmount taxexemptionamount Tax Exemption
ForegoneAmount foregoneamount Foregone Amt.
ReevaluatedAssetDeprAmount reevaluatedassetdepramount Rv. Asset Deprec.
DepreciationClassification depreciationclassification Depr. Classification

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 I_PT_AssetReportFormContent.
-- 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: IPTARFMAPCONTENT

CREATE VIEW I_PT_AssetReportFormContent AS
SELECT
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID,
  CompanyCode,
  FiscalYear,
  AssetReportFormClass,
  AssetReportForm,
  AssetReportFormCategoryName,
  AssetRptFormRtrmtCategoryName,
  SequenceNumber,
  MasterFixedAsset,
  FixedAsset,
  AssetTransactionType,
  AssetReportFormType,
  AdditionalAssetReportFormType,
  AssetEvaluationGroup,
  FixedAssetDescription,
  FirstAcquisitionFiscalYear,
  DepreciationStartPeriod,
  DepreciationStartYear,
  LandAssetLink,
  BigRepairAssetLink,
  AssetRealizationAmount,
  BookAcquisitionAmount,
  TaxAcquisitionAmount,
  BookValueAdjustmentAmount,
  BookCapitalGainAmountSign,
  BookCapitalGainAmount,
  NotTaxedCapitalGainAmount,
  TaxValueAdjustmentAmount,
  DevaluationCoefficient,
  TaxCapitalGainAmountSign,
  TaxCapitalGainAmount,
  PlannedUsefulLifeInDcmlYears,
  ReportedBookDepreciationAmount,
  ReportedCumulativeTaxDeprAmt,
  PlannedUsefulLifeInYears,
  TaxDepreciationRate,
  RevisedTaxDepreciationRate,
  ReportedTaxDepreciationAmount,
  AcceptedImpairmentLossAmount,
  CumulativeLossTaxDeprRate,
  NotAcceptedDepreciationAmount,
  RecoveredImprmtLossAndDeprAmt,
  AcqnProdnCostAndRevalAmount,
  PrevAcqnProdnCostAndRevalAmt,
  TotalAcqnProdnCostAndRevalAmt,
  RltvExpiredUsefulLifeInYears,
  RltvRemainingUsefulLifeInYears,
  AddlPlannedUsefulLifeInYears,
  AdditionalTaxDepreciationRate,
  CumulativeDepreciationAmount,
  TotalDepreciationAmount,
  NetBookValueAmount,
  TaxExemptionAmount,
  ForegoneAmount,
  ReevaluatedAssetDeprAmount,
  DepreciationClassification
FROM fiaaptd_fsclmap
;

Learn More