Deprecated
This CDS view is deprecated in S/4HANA. Use I_AstAcqnAndRtrmtOverview instead. View all deprecated CDS views →

I_FxdAstTransInPreviousQuarter

DDL: I_FXDASTTRANSINPREVIOUSQUARTER SQL: IFASSETTRNPQ Type: view COMPOSITE
48 Fields 1 Data Sources 1 Associations

Fixed Asset Transaction in Previous Quarter

I_FxdAstTransInPreviousQuarter is a Composite CDS View that provides data about "Fixed Asset Transaction in Previous Quarter" in SAP S/4HANA. It reads from 1 data source (P_FxdAstTransInPreviousQuarter) and exposes 48 fields with key fields CompanyCode, MasterFixedAsset, FixedAsset, AssetDepreciationArea, Ledger. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
P_FxdAstTransInPreviousQuarter P_FxdAstTransInPreviousQuarter from

Parameters (3)

NameTypeDefault
P_KeyDate fagl_keydate
P_TodayDate fagl_keydate
P_AssetAccountingKeyFigureSet faa_key_figure_set

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_FixedAssetForLedger _FixedAssetForLedger _FixedAssetForLedger.CompanyCode = $projection.CompanyCode and _FixedAssetForLedger.MasterFixedAsset = $projection.MasterFixedAsset and _FixedAssetForLedger.FixedAsset = $projection.FixedAsset and _FixedAssetForLedger.Ledger = $projection.Ledger

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IFASSETTRNPQ view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Fixed Asset Transaction in Previous Quarter view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
VDM.lifecycle.status #DEPRECATED view
VDM.lifecycle.successor I_AstAcqnAndRtrmtOverview view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (48)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY MasterFixedAsset MasterFixedAsset Fixed Asset
KEY FixedAsset FixedAsset Sub-number
KEY AssetDepreciationArea AssetDepreciationArea Deprec. Area
KEY Ledger Ledger Ledger
KEY AssetAccountingKeyFigureSet
KEY CurrencyRole CurrencyRole Curr./Val. Type
CompanyCodeName CompanyCodeName Company Name
AssetCostCenter AssetCostCenter
AssetClass AssetClass Asset Class
AssetPlant AssetPlant
BusinessArea BusinessArea Business Area
Segment Segment Segment number
AssetProfitCenter AssetProfitCenter
AssetCountryOfOrigin
AssetSupplier _FixedAsset Supplier Supplier
SupplierAccountGroup
SupplierBasicAuthorizationGrp
AssetAuthorizationContext _FixedAsset AssetAuthorizationContext
Supplier _FixedAsset Supplier Supplier
AssetSupplierName _FixedAsset AssetSupplierName
AssetDeactivationDate _FixedAssetForLedger AssetDeactivationDate
AssetCapitalizationDate _FixedAssetForLedger AssetCapitalizationDate Asset Capitalization
FixedAssetDescription _FixedAsset FixedAssetDescription Description
Group1AssetEvaluationKey _FixedAsset Group1AssetEvaluationKey
Group2AssetEvaluationKey _FixedAsset Group2AssetEvaluationKey
Group3AssetEvaluationKey _FixedAsset Group3AssetEvaluationKey
Group4AssetEvaluationKey _FixedAsset Group4AssetEvaluationKey
Group5AssetEvaluationKey _FixedAsset Group5AssetEvaluationKey
AccountingPrinciple _DepreciationArea AccountingPrinciple AP Ledger/CoCode
AssetClassName
AssetLocation
CostCenterName
BusinessAreaName
PlantName
ProfitCenterName
SegmentName
AssetAccountDetermination _FixedAsset AssetAccountDetermination Account Determ.
AssetAccountDeterminationDesc
PeriodType PeriodType PeriodIndicator
SelectedCurrencyBranch SelectedCurrencyBranch
DisplayCurrency DisplayCurrency Display Currency
AcqnProdnAmtInDspCrcy AcqnProdnAmtInDspCrcy
ValueAdjustmentAmtInDspCrcy ValueAdjustmentAmtInDspCrcy
RtrmtNetBookValueAmtInDspCrcy RtrmtNetBookValueAmtInDspCrcy
AssetTransactionTypeName _AssetTransactionType AssetTransactionTypeName
_AssetClass _AssetClass
_FixedAsset _FixedAsset

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_FxdAstTransInPreviousQuarter.
-- 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: IFASSETTRNPQ
-- Parameters: P_KeyDate : fagl_keydate, P_TodayDate : fagl_keydate, P_AssetAccountingKeyFigureSet : faa_key_figure_set

CREATE VIEW I_FxdAstTransInPreviousQuarter AS
SELECT
  CompanyCode,
  MasterFixedAsset,
  FixedAsset,
  AssetDepreciationArea,
  Ledger,
  cast( AssetAccountingKeyFigureSet as faa_asset_transaction_type preserving type ) AS AssetAccountingKeyFigureSet,
  CurrencyRole,
  CompanyCodeName,
  AssetCostCenter,
  AssetClass,
  AssetPlant,
  BusinessArea,
  Segment,
  AssetProfitCenter,
  cast(_FixedAsset.AssetCountryOfOrigin as faa_asset_cntry_of_origin) AS AssetCountryOfOrigin,
  _FixedAsset.Supplier AS AssetSupplier,
  _FixedAsset._Supplier.SupplierAccountGroup AS SupplierAccountGroup,
  _FixedAsset._Supplier.AuthorizationGroup AS SupplierBasicAuthorizationGrp,
  _FixedAsset.AssetAuthorizationContext AS AssetAuthorizationContext,
  _FixedAsset.Supplier AS Supplier,
  _FixedAsset.AssetSupplierName AS AssetSupplierName,
  _FixedAssetForLedger.AssetDeactivationDate AS AssetDeactivationDate,
  _FixedAssetForLedger.AssetCapitalizationDate AS AssetCapitalizationDate,
  _FixedAsset.FixedAssetDescription AS FixedAssetDescription,
  _FixedAsset.Group1AssetEvaluationKey AS Group1AssetEvaluationKey,
  _FixedAsset.Group2AssetEvaluationKey AS Group2AssetEvaluationKey,
  _FixedAsset.Group3AssetEvaluationKey AS Group3AssetEvaluationKey,
  _FixedAsset.Group4AssetEvaluationKey AS Group4AssetEvaluationKey,
  _FixedAsset.Group5AssetEvaluationKey AS Group5AssetEvaluationKey,
  _DepreciationArea.AccountingPrinciple AS AccountingPrinciple,
  _FixedAsset._AssetClass._Text[1:Language = $session.system_language].AssetClassName AS AssetClassName,
  _FixedAssetAssgmt[1:ValidityStartDate <= :P_TodayDate and ValidityEndDate >= :P_TodayDate].AssetLocation AS AssetLocation,
  _FixedAssetAssgmt[1:ValidityStartDate <= :P_TodayDate and ValidityEndDate >= :P_TodayDate]._CostCenter[1:ValidityStartDate <= :P_TodayDate and ValidityEndDate >= :P_TodayDate]._Text[1:Language = $session.system_language].CostCenterName AS CostCenterName,
  _FixedAssetAssgmt[1:ValidityStartDate <= :P_TodayDate and ValidityEndDate >= :P_TodayDate]._BusinessArea._Text[1:Language = $session.system_language].BusinessAreaName AS BusinessAreaName,
  _FixedAssetAssgmt[1:ValidityStartDate <= :P_TodayDate and ValidityEndDate >= :P_TodayDate]._Plant.PlantName AS PlantName,
  _FixedAssetAssgmt[1:ValidityStartDate <= :P_TodayDate and ValidityEndDate >= :P_TodayDate]._ProfitCenter[1:ValidityStartDate <= :P_TodayDate and ValidityEndDate >= :P_TodayDate]._Text[1:Language = $session.system_language].ProfitCenterName AS ProfitCenterName,
  _FixedAssetAssgmt[1:ValidityStartDate <= :P_TodayDate and ValidityEndDate >= :P_TodayDate]._Segment._Text[1:Language = $session.system_language].SegmentName AS SegmentName,
  _FixedAsset.AssetAccountDetermination AS AssetAccountDetermination,
  _FixedAsset._AssetAccountDetermination._Text[1: Language = $session.system_language ].AssetAccountDeterminationDesc AS AssetAccountDeterminationDesc,
  PeriodType,
  SelectedCurrencyBranch,
  DisplayCurrency,
  AcqnProdnAmtInDspCrcy,
  ValueAdjustmentAmtInDspCrcy,
  RtrmtNetBookValueAmtInDspCrcy,
  _AssetTransactionType.AssetTransactionTypeName AS AssetTransactionTypeName
FROM P_FxdAstTransInPreviousQuarter
LEFT OUTER JOIN I_FixedAssetForLedger AS _FixedAssetForLedger ON _FixedAssetForLedger.CompanyCode = CompanyCode AND _FixedAssetForLedger.MasterFixedAsset = MasterFixedAsset AND _FixedAssetForLedger.FixedAsset = FixedAsset AND _FixedAssetForLedger.Ledger = Ledger  -- association [0..1]
;

Learn More