I_FIXEDASSETASSGMT
Fixed Asset Time Dependent Data
I_FIXEDASSETASSGMT is a CDS View in S/4HANA. Fixed Asset Time Dependent Data. It contains 52 fields. 22 CDS views read from this table.
CDS Views using this table (22)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_CN_CADEAssetByPeriod | view | left_outer | CONSUMPTION | Asset Assignment by Period for CADE |
| FAA_M_AANLC | view | inner | Selection view for matchcode ID AANL-C | |
| FAA_PFixedAssetValueHelp | view | left_outer | Fixed Asset | |
| FAC_AUDIT_Z3_ASSET_MASTER | view | left_outer | Asset Master | |
| FINOC_RT_FA_FILL | view | inner | Orgl Change: Fill Runtime for Fixed Asset | |
| I_CN_CADEFixedAssetValueCube | view | left_outer | COMPOSITE | Fixed Asset Balance Cube for CADE |
| I_FixedAssetAssgmtTP | view | from | TRANSACTIONAL | Transactional View Fixed Asset Assignments |
| I_FixedAssetWorklist | view | inner | COMPOSITE | Interface View for Fixed Asset Worklist |
| I_FxdAstAssgmtByFsclPerdEndDte | view | from | COMPOSITE | Fixed Asset Assignment valid at fiscal period end date |
| I_RU_LandTaxItemCube | view | inner | COMPOSITE | Russia Land Tax: Cube |
| I_RU_PropertyTaxItemCube | view | inner | COMPOSITE | Russia Property Tax - Cube |
| I_RU_TransportTaxItemCube | view | inner | COMPOSITE | Russia Transport Tax: Cube |
| P_AssetAssignment | view | from | COMPOSITE | Asset Assignment |
| P_AUDIT_AT_AssetHistorySheet | view | left_outer | COMPOSITE | Austrian Audit Asset History Sheet |
| P_AUDIT_AT_AssetTransaction | view | left_outer | COMPOSITE | Austrian Audit Asset Transaction |
| P_BG_StRpTaxDeprShutdown | view | from | CONSUMPTION | Tax depr. plan - shutdowns |
| P_FuncnlAreaFxdAst | view | from | COMPOSITE | WUFAREA Fixed Assets |
| P_FundFixedAsset | view | from | COMPOSITE | WUFUND Fixed Assets |
| P_GrantFxdAst | view | from | COMPOSITE | WUGRANT Fixed Assets |
| P_StRpFxdAsstLocTransferAssgmt | view | from | CONSUMPTION | Fixed Asset Location Transfer Assignment |
| P_StRpFxdAsstLocTransferAssgmt | view | inner | CONSUMPTION | Fixed Asset Location Transfer Assignment |
| R_FixedAssetAssignmentTP | view_entity | from | TRANSACTIONAL | Fixed Asset Assignment |
Fields (52)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | CompanyCode | CompanyCode | 4 |
| KEY | FixedAsset | AssetSubNumber,FixedAsset | 5 |
| KEY | MasterFixedAsset | AssetNumber,MasterFixedAsset | 5 |
| KEY | ValidityEndDate | bdatu,bdatuz,ValidityEndDate | 9 |
| _AssetLocation | _AssetLocation | 3 | |
| _BusinessArea | _BusinessArea | 3 | |
| _CompanyCode | _CompanyCode | 2 | |
| _ControllingArea | _ControllingArea | 3 | |
| _CostCenter | _CostCenter | 4 | |
| _CostCenterActivityType | _CostCenterActivityType | 2 | |
| _Employment | _Employment | 1 | |
| _FixedAsset | _FixedAsset | 1 | |
| _FunctionalArea | _FunctionalArea | 1 | |
| _InternalOrder | _InternalOrder | 2 | |
| _MasterFixedAsset | _MasterFixedAsset | 1 | |
| _Plant | _Plant | 2 | |
| _ProfitCenter | _ProfitCenter | 1 | |
| _ResponsibleCostCenter | _ResponsibleCostCenter | 2 | |
| _Segment | _Segment | 1 | |
| AssetAuthorizationContext | AssetAuthorizationContext | 1 | |
| AssetLocation | AssetLocation,NewAssetLocation,OldAssetLocation | 7 | |
| BudgetPeriod | BudgetPeriod | 5 | |
| BusinessArea | AssetBusinessArea,BusinessArea,gsber | 9 | |
| BusinessPlace | BusinessPlace | 1 | |
| ControllingArea | ControllingArea | 8 | |
| CostCenter | AssetCostCenter,CostCenter,kostl,NewAssetCostCenter,OldAssetCostCenter | 11 | |
| CostCtrActivityType | CostCtrActivityType | 6 | |
| FunctionalArea | FunctionalArea | 5 | |
| FunctionalLocation | FunctionalLocation | 2 | |
| Fund | Fund | 5 | |
| FundsCenter | FundsCenter | 5 | |
| GrantID | GrantID | 5 | |
| InternalOrder | InternalOrder | 6 | |
| IsShutDown | IsShutDown | 4 | |
| LogicalSystem | LogicalSystem | 1 | |
| MaintenanceOrder | MaintenanceOrder | 3 | |
| PersonnelNumber | PersonnelNumber | 4 | |
| Plant | NewAssetPlant,OldAssetPlant,Plant,werks | 9 | |
| ProfitCenter | prctr,ProfitCenter | 6 | |
| RealEstateObject | RealEstateObject | 3 | |
| ReferenceDocument | ReferenceDocument | 2 | |
| ReferenceDocumentContext | ReferenceDocumentContext | 1 | |
| ReferenceDocumentType | ReferenceDocumentType | 1 | |
| REInternalFinNumber | RealEstateObject,REInternalFinNumber | 2 | |
| ResponsibleCostCenter | ResponsibleCostCenter | 5 | |
| Room | Room | 4 | |
| Segment | Segment | 5 | |
| ShiftOperationFactor | ShiftOperationFactor | 2 | |
| TaxJurisdiction | TaxJurisdiction | 5 | |
| ValidityStartDate | adatu,ValidityStartDate | 9 | |
| VehicleLicensePlateNumber | VehicleLicensePlateNumber | 4 | |
| WBSElementInternalID_2 | WBSElementInternalID | 2 |
@Analytics: { technicalName: 'IFASSETASSGMT',
dataCategory: #DIMENSION }
@EndUserText.label: 'Fixed Asset Time Dependent Data'
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #CHECK
@ObjectModel: { representativeKey: 'FixedAsset',
usageType.serviceQuality: #A,
usageType.sizeCategory: #XXL,
usageType.dataClass: #MIXED,
modelingPattern: #ANALYTICAL_DIMENSION,
supportedCapabilities: [#ANALYTICAL_DIMENSION, #ANALYTICAL_PROVIDER, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET, #SQL_DATA_SOURCE]
}
@Metadata: {ignorePropagatedAnnotations: true, allowExtensions: true}
define view entity I_FixedAssetAssgmt
as select from faat_md_tdd
left outer to one join tka02 on tka02.bukrs = faat_md_tdd.comp_code
and tka02.gsber = ''
//Association with Asset Master Reference
association [1..1] to I_FixedAsset as _FixedAsset on $projection.CompanyCode = _FixedAsset.CompanyCode
and $projection.MasterFixedAsset = _FixedAsset.MasterFixedAsset
and $projection.FixedAsset = _FixedAsset.FixedAsset
association [0..1] to I_CompanyCode as _CompanyCode on $projection.CompanyCode = _CompanyCode.CompanyCode
association [0..1] to I_MasterFixedAsset as _MasterFixedAsset on $projection.CompanyCode = _MasterFixedAsset.CompanyCode
and $projection.MasterFixedAsset = _MasterFixedAsset.MasterFixedAsset
association [0..*] to I_CostCenter as _CostCenter on $projection.CostCenter = _CostCenter.CostCenter
and $projection.ControllingArea = _CostCenter.ControllingArea
association [0..*] to I_CostCenter as _ResponsibleCostCenter on $projection.ResponsibleCostCenter = _ResponsibleCostCenter.CostCenter
and $projection.ControllingArea = _ResponsibleCostCenter.ControllingArea
association [0..*] to I_CostCenterActivityType as _CostCenterActivityType on $projection.CostCtrActivityType = _CostCenterActivityType.CostCtrActivityType
and $projection.ControllingArea = _CostCenterActivityType.ControllingArea
association [0..1] to I_Plant as _Plant on $projection.Plant = _Plant.Plant
association [0..1] to I_BusinessArea as _BusinessArea on $projection.BusinessArea = _BusinessArea.BusinessArea
association [0..1] to I_WBSElementBasicData as _WBSElement on $projection.WBSElementInternalID_2 = _WBSElement.WBSElementInternalID
association [0..1] to I_InternalOrder as _InternalOrder on $projection.InternalOrder = _InternalOrder.InternalOrder
association [0..1] to I_MaintenanceOrder as _MaintenanceOrder on $projection.MaintenanceOrder = _MaintenanceOrder.MaintenanceOrder
association [0..*] to I_ProfitCenter as _ProfitCenter on $projection.ProfitCenter = _ProfitCenter.ProfitCenter
and $projection.ControllingArea = _ProfitCenter.ControllingArea
association [0..1] to I_Segment as _Segment on $projection.Segment = _Segment.Segment
association [0..1] to I_FunctionalArea as _FunctionalArea on $projection.FunctionalArea = _FunctionalArea.FunctionalArea
association [0..1] to I_ControllingArea as _ControllingArea on $projection.ControllingArea = _ControllingArea.ControllingArea
association [0..1] to I_FunctionalLocation as _FunctionalLocation on $projection.FunctionalLocation = _FunctionalLocation.FunctionalLocation
association [0..1] to I_Location as _AssetLocation on $projection.AssetLocation = _AssetLocation.Location
and $projection.Plant = _AssetLocation.Plant
association [0..1] to I_REObjectByIntFinNumber as _RealEstateObject on $projection.REInternalFinNumber = _RealEstateObject.REInternalFinNumber
association [0..1] to I_Employment as _Employment on $projection.PersonnelNumber = _Employment.EmploymentInternalID
// Association to Extension View
association [1..1] to E_FixedAssetAssgmt as _Extension on $projection.CompanyCode = _Extension.CompanyCode
and $projection.MasterFixedAsset = _Extension.MasterFixedAsset
and $projection.FixedAsset = _Extension.FixedAsset
and $projection.ValidityEndDate = _Extension.ValidityEndDate
{
//Key Fields
@ObjectModel.foreignKey.association: '_CompanyCode'
key faat_md_tdd.comp_code as CompanyCode,
@ObjectModel.foreignKey.association: '_MasterFixedAsset'
key faat_md_tdd.asset_no as MasterFixedAsset,
key faat_md_tdd.asset_subno as FixedAsset,
@Semantics.businessDate.to: true
key faat_md_tdd.valid_to_date as ValidityEndDate,
@ObjectModel.foreignKey.association: '_ControllingArea'
tka02.kokrs as ControllingArea,
//Relevant Fields
@Semantics.businessDate.from: true
faat_md_tdd.valid_from_date as ValidityStartDate,
faat_md_tdd.car_license_plate as VehicleLicensePlateNumber,
@ObjectModel.foreignKey.association: '_CostCenter'
faat_md_tdd.cost_center as CostCenter,
@ObjectModel.foreignKey.association: '_Plant'
faat_md_tdd.plant as Plant,
@ObjectModel.foreignKey.association: '_BusinessArea'
@VDM.lifecycle: {status: #DEPRECATED}
faat_md_tdd.business_area as BusinessArea,
@ObjectModel.foreignKey.association: '_AssetLocation'
faat_md_tdd.location as AssetLocation,
faat_md_tdd.room as Room,
@ObjectModel.foreignKey.association: '_CostCenterActivityType'
faat_md_tdd.activity_type as CostCtrActivityType,
@ObjectModel.foreignKey.association: '_InternalOrder'
faat_md_tdd.internal_order as InternalOrder,
@VDM.lifecycle: {status: #DEPRECATED}
cast( '' as xstil ) as IsShutDown, //Moved to I_AssetTimeBasedValuation.IsShutDown
@ObjectModel.foreignKey.association: '_ResponsibleCostCenter'
faat_md_tdd.responsible_cost_center as ResponsibleCostCenter,
@ObjectModel.foreignKey.association: '_Employment'
faat_md_tdd.personnel_number as PersonnelNumber,
@ObjectModel.foreignKey.association: '_MaintenanceOrder'
@VDM.lifecycle: {status: #DEPRECATED}
cast( '' as iaufn ) as MaintenanceOrder,
faat_md_tdd.tax_jurisdiction as TaxJurisdiction,
faat_md_tdd.fund as Fund,
@ObjectModel.foreignKey.association: '_WBSElement'
faat_md_tdd.wbs_element as WBSElementInternalID_2,
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'WBSElementInternalID_2'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'WBSElementInternalID_2'
cast( faat_md_tdd.wbs_element as am_ipsnr preserving type ) as WBSElementInternalID,
@ObjectModel.foreignKey.association: '_RealEstateObject'
cast( faat_md_tdd.real_estate_key as recaimkeyfi preserving type ) as REInternalFinNumber,
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'REInternalFinNumber'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'REInternalFinNumber'
cast( faat_md_tdd.real_estate_key as faa_deprecated_real_estate_obj preserving type ) as RealEstateObject,
@ObjectModel.foreignKey.association: '_ProfitCenter'
faat_md_tdd.profit_center as ProfitCenter,
@ObjectModel.foreignKey.association: '_Segment'
faat_md_tdd.segment as Segment,
@ObjectModel.foreignKey.association: '_FunctionalArea'
faat_md_tdd.functional_area as FunctionalArea,
@VDM.lifecycle: {status: #DEPRECATED}
cast( '0' as msfak ) as ShiftOperationFactor, //Moved to I_AssetTimeBasedValuation.ShiftOperationFactor
faat_md_tdd.grant_id as GrantID,
faat_md_tdd.budget_period as BudgetPeriod,
faat_md_tdd.funds_center as FundsCenter,
@ObjectModel.foreignKey.association: '_FunctionalLocation'
@VDM.lifecycle: {status: #DEPRECATED}
cast( '' as tplnr ) as FunctionalLocation, //Works in OP only, hence deprecated in cloud with CE1911, no longer available
faat_md_tdd.business_place as BusinessPlace,
@Consumption.hidden: true
@VDM.lifecycle.status: #DEPRECATED
cast( 'NEW' as faa_authcntxt ) as AssetAuthorizationContext, //Needed for DCL
faat_md_tdd.awtyp as ReferenceDocumentType,
faat_md_tdd.awsys as LogicalSystem,
faat_md_tdd.aworg as ReferenceDocumentContext,
faat_md_tdd.awref as ReferenceDocument,
// Define association to parent
@ObjectModel.association.type: [ #TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT ]
_FixedAsset,
_CompanyCode,
_MasterFixedAsset,
_CostCenter,
_ResponsibleCostCenter,
_CostCenterActivityType,
_Plant,
_BusinessArea,
_WBSElement,
_InternalOrder,
@VDM.lifecycle: {status: #DEPRECATED}
_MaintenanceOrder,
_ProfitCenter,
_Segment,
_FunctionalArea,
_ControllingArea,
_FunctionalLocation,
_AssetLocation,
_RealEstateObject,
_Employment
}