I_FIXEDASSETASSGMT
Fixed Asset Time Dependent Data
I_FIXEDASSETASSGMT is a CDS View in S/4HANA. Fixed Asset Time Dependent Data. It contains 53 fields. 21 CDS views read from this table.
CDS Views using this table (21)
| 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 | ||
| 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 | |
| P_AUDIT_AT_AssetHistorySheet | view | left_outer | COMPOSITE | |
| P_AUDIT_AT_AssetTransaction | view | left_outer | COMPOSITE | |
| 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 | |
| P_StRpFxdAsstLocTransferAssgmt | view | inner | CONSUMPTION |
Fields (53)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | CompanyCode | CompanyCode | 4 |
| KEY | FixedAsset | AssetSubNumber,FixedAsset | 6 |
| KEY | MasterFixedAsset | AssetNumber,MasterFixedAsset | 6 |
| KEY | ValidityEndDate | bdatu,bdatuz,ValidityEndDate | 10 |
| _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 | 8 | |
| BudgetPeriod | BudgetPeriod | 6 | |
| BusinessArea | AssetBusinessArea,BusinessArea,gsber | 10 | |
| BusinessPlace | BusinessPlace | 1 | |
| ControllingArea | ControllingArea | 8 | |
| CostCenter | AssetCostCenter,CostCenter,kostl,NewAssetCostCenter,OldAssetCostCenter | 11 | |
| CostCtrActivityType | CostCtrActivityType | 6 | |
| FunctionalArea | FunctionalArea | 6 | |
| FunctionalLocation | FunctionalLocation | 2 | |
| Fund | Fund | 6 | |
| FundsCenter | FundsCenter | 6 | |
| GrantID | GrantID | 6 | |
| InternalOrder | InternalOrder | 6 | |
| IsShutDown | IsShutDown | 4 | |
| LogicalSystem | LogicalSystem | 1 | |
| MaintenanceOrder | MaintenanceOrder | 3 | |
| PersonnelNumber | PersonnelNumber | 4 | |
| Plant | NewAssetPlant,OldAssetPlant,Plant,werks | 10 | |
| ProfitCenter | prctr,ProfitCenter,ProfitCenterBeforeOrglChange | 7 | |
| 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 | WBSElementInternalID | 1 | |
| 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: #NONE,
supportedCapabilities: [#ANALYTICAL_PROVIDER]
}
@Metadata: {ignorePropagatedAnnotations: true, allowExtensions: true}
define view entity I_FixedAssetAssgmt
as select from P_FixedAssetAssgmt
//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_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_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 CompanyCode,
@ObjectModel.foreignKey.association: '_MasterFixedAsset'
key MasterFixedAsset,
key FixedAsset,
@Semantics.businessDate.to: true
key ValidityEndDate,
@ObjectModel.foreignKey.association: '_ControllingArea'
ControllingArea,
//Relevant Fields
@Semantics.businessDate.from: true
ValidityStartDate,
VehicleLicensePlateNumber,
@ObjectModel.foreignKey.association: '_CostCenter'
CostCenter,
@ObjectModel.foreignKey.association: '_Plant'
Plant,
@ObjectModel.foreignKey.association: '_BusinessArea'
@VDM.lifecycle: {status: #DEPRECATED}
BusinessArea,
@ObjectModel.foreignKey.association: '_AssetLocation'
AssetLocation,
Room,
@ObjectModel.foreignKey.association: '_CostCenterActivityType'
CostCtrActivityType,
@ObjectModel.foreignKey.association: '_InternalOrder'
InternalOrder,
@VDM.lifecycle: {status: #DEPRECATED}
IsShutDown, //Works in OP only, hence deprecated in cloud with CE1911, moved to I_AssetTimeBasedValuation.IsShutDown
@ObjectModel.foreignKey.association: '_ResponsibleCostCenter'
ResponsibleCostCenter,
@ObjectModel.foreignKey.association: '_Employment'
PersonnelNumber,
@ObjectModel.foreignKey.association: '_MaintenanceOrder'
@VDM.lifecycle: {status: #DEPRECATED}
MaintenanceOrder,
TaxJurisdiction,
Fund,
WBSElementInternalID_2,
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'WBSElementInternalID_2'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'WBSElementInternalID_2'
WBSElementInternalID,
REInternalFinNumber,
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'REInternalFinNumber'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'REInternalFinNumber'
RealEstateObject,
@ObjectModel.foreignKey.association: '_ProfitCenter'
ProfitCenter,
@ObjectModel.foreignKey.association: '_Segment'
Segment,
@ObjectModel.foreignKey.association: '_FunctionalArea'
FunctionalArea,
@VDM.lifecycle: {status: #DEPRECATED}
ShiftOperationFactor, //Works in OP only, hence deprecated in cloud with CE1911, moved to I_AssetTimeBasedValuation.ShiftOperationFactor
GrantID,
BudgetPeriod,
FundsCenter,
@ObjectModel.foreignKey.association: '_FunctionalLocation'
@VDM.lifecycle: {status: #DEPRECATED}
FunctionalLocation, //Works in OP only, hence deprecated in cloud with CE1911, no longer available
BusinessPlace,
@Consumption.hidden: true
AssetAuthorizationContext, //Needed for DCL
ReferenceDocumentType,
LogicalSystem,
ReferenceDocumentContext,
ReferenceDocument,
// Define association to parent
@ObjectModel.association.type: [ #TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT ]
_FixedAsset,
_CompanyCode,
_MasterFixedAsset,
_CostCenter,
_ResponsibleCostCenter,
_CostCenterActivityType,
_Plant,
_BusinessArea,
_InternalOrder,
@VDM.lifecycle: {status: #DEPRECATED}
_MaintenanceOrder,
_ProfitCenter,
_Segment,
_FunctionalArea,
_ControllingArea,
_FunctionalLocation,
_AssetLocation,
_Employment
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_FIXEDASSETASSGMT"
],
"ASSOCIATED":
[
"I_BUSINESSAREA",
"I_COMPANYCODE",
"I_CONTROLLINGAREA",
"I_COSTCENTER",
"I_COSTCENTERACTIVITYTYPE",
"I_EMPLOYMENT",
"I_FIXEDASSET",
"I_FUNCTIONALAREA",
"I_FUNCTIONALLOCATION",
"I_INTERNALORDER",
"I_LOCATION",
"I_MAINTENANCEORDER",
"I_MASTERFIXEDASSET",
"I_PLANT",
"I_PROFITCENTER",
"I_SEGMENT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/