I_FixedAssetAssgmtTP
Transactional View Fixed Asset Assignments
I_FixedAssetAssgmtTP is a Transactional CDS View that provides data about "Transactional View Fixed Asset Assignments" in SAP S/4HANA. It reads from 1 data source (I_FixedAssetAssgmt) and exposes 49 fields with key fields CompanyCode, MasterFixedAsset, FixedAsset, ValidityEndDate. It has 7 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_FixedAssetAssgmt | I_FixedAssetAssgmt | from |
Associations (7)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..1] | I_FixedAssetTP | _FixedAsset | $projection.CompanyCode = _FixedAsset.CompanyCode and $projection.MasterFixedAsset = _FixedAsset.MasterFixedAsset and $projection.FixedAsset = _FixedAsset.FixedAsset |
| [0..*] | I_CostCenter | _CostCenter | $projection.CostCenter = _CostCenter.CostCenter and $projection.ControllingArea = _CostCenter.ControllingArea and $projection.ValidityStartDate <= _CostCenter.ValidityEndDate and $projection.ValidityStartDate >= _CostCenter.ValidityStartDate |
| [0..*] | I_CostCenter | _ResponsibleCostCenter | $projection.ResponsibleCostCenter = _ResponsibleCostCenter.CostCenter and $projection.ControllingArea = _ResponsibleCostCenter.ControllingArea and $projection.ValidityStartDate <= _ResponsibleCostCenter.ValidityEndDate and $projection.ValidityStartDate >= _ResponsibleCostCenter.ValidityStartDate |
| [0..*] | I_CostCenterActivityType | _CostCenterActivityType | $projection.CostCtrActivityType = _CostCenterActivityType.CostCtrActivityType and $projection.ControllingArea = _CostCenterActivityType.ControllingArea and $projection.ValidityStartDate <= _CostCenterActivityType.ValidityEndDate and $projection.ValidityStartDate >= _CostCenterActivityType.ValidityStartDate |
| [0..*] | I_ProfitCenter | _ProfitCenter | $projection.ProfitCenter = _ProfitCenter.ProfitCenter and $projection.ControllingArea = _ProfitCenter.ControllingArea and $projection.ValidityStartDate <= _ProfitCenter.ValidityEndDate and $projection.ValidityStartDate >= _ProfitCenter.ValidityStartDate |
| [0..1] | I_TaxJurisCalcProcedure | _TaxJurisdictionCalcProcedure | $projection.taxcalculationprocedure = _TaxJurisdictionCalcProcedure.TaxJurisdictionCalcProcedure |
| [0..1] | I_TaxJurisdiction | _TaxJurisdiction | $projection.TaxJurisdiction = _TaxJurisdiction.TaxJurisdiction and $projection.taxcalculationprocedure = _TaxJurisdiction.TaxJurisdictionCalcProcedure |
Annotations (13)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | IFASSETASSGMTTP | view | |
| AbapCatalog.preserveKey | true | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| EndUserText.label | Transactional View Fixed Asset Assignments | view | |
| VDM.viewType | #TRANSACTIONAL | view | |
| ObjectModel.writeDraftPersistence | ANLZ_D | view | |
| ObjectModel.createEnabled | true | view | |
| ObjectModel.updateEnabled | true | view | |
| ObjectModel.deleteEnabled | true | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #XXL | view | |
| ObjectModel.usageType.dataClass | #MASTER | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view |
Fields (49)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | CompanyCode | I_FixedAssetAssgmt | CompanyCode | |
| KEY | MasterFixedAsset | I_FixedAssetAssgmt | MasterFixedAsset | |
| KEY | FixedAsset | I_FixedAssetAssgmt | FixedAsset | |
| KEY | ValidityEndDate | I_FixedAssetAssgmt | ValidityEndDate | |
| ValidityStartDate | I_FixedAssetAssgmt | ValidityStartDate | ||
| VehicleLicensePlateNumber | I_FixedAssetAssgmt | VehicleLicensePlateNumber | ||
| CostCenter | I_FixedAssetAssgmt | CostCenter | ||
| CostCenterName | ||||
| Plant | I_FixedAssetAssgmt | Plant | ||
| BusinessArea | I_FixedAssetAssgmt | BusinessArea | ||
| AssetLocation | I_FixedAssetAssgmt | AssetLocation | ||
| Room | I_FixedAssetAssgmt | Room | ||
| CostCtrActivityType | I_FixedAssetAssgmt | CostCtrActivityType | ||
| InternalOrder | I_FixedAssetAssgmt | InternalOrder | ||
| IsShutDown | I_FixedAssetAssgmt | IsShutDown | ||
| ResponsibleCostCenter | I_FixedAssetAssgmt | ResponsibleCostCenter | ||
| PersonnelNumber | I_FixedAssetAssgmt | PersonnelNumber | ||
| MaintenanceOrder | I_FixedAssetAssgmt | MaintenanceOrder | ||
| TaxJurisdiction | I_FixedAssetAssgmt | TaxJurisdiction | ||
| Fund | I_FixedAssetAssgmt | Fund | ||
| WBSElementInternalID | I_FixedAssetAssgmt | WBSElementInternalID_2 | ||
| RealEstateObject | ||||
| ProfitCenter | I_FixedAssetAssgmt | ProfitCenter | ||
| Segment | I_FixedAssetAssgmt | Segment | ||
| FunctionalArea | I_FixedAssetAssgmt | FunctionalArea | ||
| ShiftOperationFactor | I_FixedAssetAssgmt | ShiftOperationFactor | ||
| GrantID | I_FixedAssetAssgmt | GrantID | ||
| BudgetPeriod | I_FixedAssetAssgmt | BudgetPeriod | ||
| FundsCenter | I_FixedAssetAssgmt | FundsCenter | ||
| ControllingArea | I_FixedAssetAssgmt | ControllingArea | ||
| TaxCalculationProcedure | ||||
| _FixedAsset | _FixedAsset | |||
| _CompanyCode | _CompanyCode | |||
| _MasterFixedAsset | _MasterFixedAsset | |||
| _CostCenter | _CostCenter | |||
| _ResponsibleCostCenter | _ResponsibleCostCenter | |||
| _CostCenterActivityType | _CostCenterActivityType | |||
| _Plant | _Plant | |||
| _AssetLocation | _AssetLocation | |||
| _BusinessArea | _BusinessArea | |||
| _InternalOrder | _InternalOrder | |||
| _MaintenanceOrder | _MaintenanceOrder | |||
| _TaxJurisdiction | _TaxJurisdiction | |||
| _TaxJurisdictionCalcProcedure | _TaxJurisdictionCalcProcedure | |||
| _ProfitCenter | _ProfitCenter | |||
| _Segment | _Segment | |||
| _FunctionalArea | _FunctionalArea | |||
| _ControllingArea | _ControllingArea | |||
| _Employment | _Employment |
@AbapCatalog: {sqlViewName: 'IFASSETASSGMTTP', preserveKey: true}
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Transactional View Fixed Asset Assignments'
@VDM.viewType: #TRANSACTIONAL
@ObjectModel: {
writeDraftPersistence: 'ANLZ_D',
createEnabled: true,
updateEnabled: true,
deleteEnabled: true,
semanticKey: ['CompanyCode', 'MasterFixedAsset', 'FixedAsset', 'ValidityEndDate'],
usageType.serviceQuality: #C,
usageType.sizeCategory: #XXL,
usageType.dataClass: #MASTER
}
@ClientHandling.algorithm: #SESSION_VARIABLE
define view I_FixedAssetAssgmtTP
as select from I_FixedAssetAssgmt
association [1..1] to I_FixedAssetTP as _FixedAsset on $projection.CompanyCode = _FixedAsset.CompanyCode
and $projection.MasterFixedAsset = _FixedAsset.MasterFixedAsset
and $projection.FixedAsset = _FixedAsset.FixedAsset
association [0..*] to I_CostCenter as _CostCenter on $projection.CostCenter = _CostCenter.CostCenter
and $projection.ControllingArea = _CostCenter.ControllingArea
and $projection.ValidityStartDate <= _CostCenter.ValidityEndDate
and $projection.ValidityStartDate >= _CostCenter.ValidityStartDate
association [0..*] to I_CostCenter as _ResponsibleCostCenter on $projection.ResponsibleCostCenter = _ResponsibleCostCenter.CostCenter
and $projection.ControllingArea = _ResponsibleCostCenter.ControllingArea
and $projection.ValidityStartDate <= _ResponsibleCostCenter.ValidityEndDate
and $projection.ValidityStartDate >= _ResponsibleCostCenter.ValidityStartDate
association [0..*] to I_CostCenterActivityType as _CostCenterActivityType on $projection.CostCtrActivityType = _CostCenterActivityType.CostCtrActivityType
and $projection.ControllingArea = _CostCenterActivityType.ControllingArea
and $projection.ValidityStartDate <= _CostCenterActivityType.ValidityEndDate
and $projection.ValidityStartDate >= _CostCenterActivityType.ValidityStartDate
association [0..*] to I_ProfitCenter as _ProfitCenter on $projection.ProfitCenter = _ProfitCenter.ProfitCenter
and $projection.ControllingArea = _ProfitCenter.ControllingArea
and $projection.ValidityStartDate <= _ProfitCenter.ValidityEndDate
and $projection.ValidityStartDate >= _ProfitCenter.ValidityStartDate
association [0..1] to I_TaxJurisCalcProcedure as _TaxJurisdictionCalcProcedure on $projection.taxcalculationprocedure = _TaxJurisdictionCalcProcedure.TaxJurisdictionCalcProcedure
association [0..1] to I_TaxJurisdiction as _TaxJurisdiction on $projection.TaxJurisdiction = _TaxJurisdiction.TaxJurisdiction
and $projection.taxcalculationprocedure = _TaxJurisdiction.TaxJurisdictionCalcProcedure
{
key I_FixedAssetAssgmt.CompanyCode as CompanyCode,
key I_FixedAssetAssgmt.MasterFixedAsset as MasterFixedAsset,
key I_FixedAssetAssgmt.FixedAsset as FixedAsset,
@Semantics.businessDate.to: true
@ObjectModel.readOnly: true
key I_FixedAssetAssgmt.ValidityEndDate as ValidityEndDate,
@Semantics.businessDate.from: true
@ObjectModel: { readOnly: true }
I_FixedAssetAssgmt.ValidityStartDate as ValidityStartDate,
@ObjectModel: { readOnly: 'EXTERNAL_CALCULATION' , mandatory: 'EXTERNAL_CALCULATION' }
I_FixedAssetAssgmt.VehicleLicensePlateNumber as VehicleLicensePlateNumber,
@ObjectModel: { readOnly: 'EXTERNAL_CALCULATION' , mandatory: 'EXTERNAL_CALCULATION' }
I_FixedAssetAssgmt.CostCenter as CostCenter,
@ObjectModel: { readOnly: true }
//_CostCenter._Text[1: Language = $session.system_language].CostCenterName,
_CostCenter[1:CostCenter = CostCenter and ControllingArea = ControllingArea and ValidityStartDate >= ValidityStartDate and ValidityEndDate <= ValidityEndDate]._Text[1: Language = $session.system_language].CostCenterName as CostCenterName,
@ObjectModel: { readOnly: 'EXTERNAL_CALCULATION' , mandatory: 'EXTERNAL_CALCULATION' }
I_FixedAssetAssgmt.Plant as Plant,
@ObjectModel: { readOnly: 'EXTERNAL_CALCULATION' , mandatory: 'EXTERNAL_CALCULATION' }
I_FixedAssetAssgmt.BusinessArea as BusinessArea,
@ObjectModel: { readOnly: 'EXTERNAL_CALCULATION' , mandatory: 'EXTERNAL_CALCULATION' }
I_FixedAssetAssgmt.AssetLocation as AssetLocation,
@ObjectModel: { readOnly: 'EXTERNAL_CALCULATION' , mandatory: 'EXTERNAL_CALCULATION' }
I_FixedAssetAssgmt.Room as Room,
@ObjectModel: { readOnly: 'EXTERNAL_CALCULATION' , mandatory: 'EXTERNAL_CALCULATION' }
I_FixedAssetAssgmt.CostCtrActivityType as CostCtrActivityType,
@ObjectModel: { readOnly: 'EXTERNAL_CALCULATION' , mandatory: 'EXTERNAL_CALCULATION' }
I_FixedAssetAssgmt.InternalOrder as InternalOrder,
@ObjectModel: { readOnly: 'EXTERNAL_CALCULATION', mandatory: 'EXTERNAL_CALCULATION' }
I_FixedAssetAssgmt.IsShutDown as IsShutDown,
@ObjectModel: { readOnly: 'EXTERNAL_CALCULATION' , mandatory: 'EXTERNAL_CALCULATION' }
I_FixedAssetAssgmt.ResponsibleCostCenter as ResponsibleCostCenter,
@ObjectModel: { readOnly: 'EXTERNAL_CALCULATION' , mandatory: 'EXTERNAL_CALCULATION' }
I_FixedAssetAssgmt.PersonnelNumber as PersonnelNumber,
@ObjectModel: { readOnly: 'EXTERNAL_CALCULATION' , mandatory: 'EXTERNAL_CALCULATION' }
I_FixedAssetAssgmt.MaintenanceOrder as MaintenanceOrder,
@ObjectModel.foreignKey.association: '_TaxJurisdiction'
@ObjectModel: { readOnly: 'EXTERNAL_CALCULATION' , mandatory: 'EXTERNAL_CALCULATION' }
I_FixedAssetAssgmt.TaxJurisdiction as TaxJurisdiction,
@ObjectModel: { readOnly: 'EXTERNAL_CALCULATION' , mandatory: 'EXTERNAL_CALCULATION' }
I_FixedAssetAssgmt.Fund as Fund,
I_FixedAssetAssgmt.WBSElementInternalID_2 as WBSElementInternalID,
@ObjectModel: { readOnly: 'EXTERNAL_CALCULATION' , mandatory: 'EXTERNAL_CALCULATION' }
cast(I_FixedAssetAssgmt.REInternalFinNumber as imkey) as RealEstateObject,
@ObjectModel: { readOnly: 'EXTERNAL_CALCULATION' , mandatory: 'EXTERNAL_CALCULATION' }
I_FixedAssetAssgmt.ProfitCenter as ProfitCenter,
@ObjectModel: { readOnly: 'EXTERNAL_CALCULATION' , mandatory: 'EXTERNAL_CALCULATION' }
I_FixedAssetAssgmt.Segment as Segment,
@ObjectModel.foreignKey.association: '_FunctionalArea'
@ObjectModel: { readOnly: 'EXTERNAL_CALCULATION' , mandatory: 'EXTERNAL_CALCULATION' }
I_FixedAssetAssgmt.FunctionalArea as FunctionalArea,
@ObjectModel: { readOnly: 'EXTERNAL_CALCULATION' , mandatory: 'EXTERNAL_CALCULATION' }
I_FixedAssetAssgmt.ShiftOperationFactor as ShiftOperationFactor,
@ObjectModel: { readOnly: 'EXTERNAL_CALCULATION' , mandatory: 'EXTERNAL_CALCULATION' }
I_FixedAssetAssgmt.GrantID as GrantID,
@ObjectModel: { readOnly: 'EXTERNAL_CALCULATION' , mandatory: 'EXTERNAL_CALCULATION' }
I_FixedAssetAssgmt.BudgetPeriod as BudgetPeriod,
@ObjectModel: { readOnly: 'EXTERNAL_CALCULATION' , mandatory: 'EXTERNAL_CALCULATION' }
I_FixedAssetAssgmt.FundsCenter as FundsCenter,
@ObjectModel.readOnly: true
I_FixedAssetAssgmt.ControllingArea,
@ObjectModel.foreignKey.association: '_TaxJurisdictionCalcProcedure'
I_FixedAssetAssgmt._CompanyCode._Country.TaxCalculationProcedure,
@ObjectModel.association.type: [ #TO_COMPOSITION_ROOT, #TO_COMPOSITION_PARENT ]
_FixedAsset,
_CompanyCode,
_MasterFixedAsset,
_CostCenter,
_ResponsibleCostCenter,
_CostCenterActivityType,
_Plant,
_AssetLocation,
_BusinessArea,
_InternalOrder,
_MaintenanceOrder,
_TaxJurisdiction,
_TaxJurisdictionCalcProcedure,
_ProfitCenter,
_Segment,
_FunctionalArea,
_ControllingArea,
_Employment
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_COMPANYCODE",
"I_COSTCENTER",
"I_COSTCENTERTEXT",
"I_COUNTRY",
"I_FIXEDASSETASSGMT"
],
"ASSOCIATED":
[
"I_BUSINESSAREA",
"I_COMPANYCODE",
"I_CONTROLLINGAREA",
"I_COSTCENTER",
"I_COSTCENTERACTIVITYTYPE",
"I_EMPLOYMENT",
"I_FIXEDASSETTP",
"I_FUNCTIONALAREA",
"I_INTERNALORDER",
"I_LOCATION",
"I_MAINTENANCEORDER",
"I_MASTERFIXEDASSET",
"I_PLANT",
"I_PROFITCENTER",
"I_SEGMENT",
"I_TAXJURISCALCPROCEDURE",
"I_TAXJURISDICTION"
],
"BASE":
[
"I_FIXEDASSETASSGMT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA