I_FIXEDASSETPLANVALUE
Fixed Asset Plan Values
I_FIXEDASSETPLANVALUE is a CDS View in S/4HANA. Fixed Asset Plan Values. It contains 99 fields. 7 CDS views read from this table.
CDS Views using this table (7)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_FxdAstPlanValueWithCrcyRole | view | from | COMPOSITE | Fixed Asset Plan Values with currency role |
| P_AssetBalanceCube2 | view_entity | inner | COMPOSITE | |
| P_AssetHistorySheetCube3 | view_entity | inner | COMPOSITE | |
| P_FixedAssetDepreciationList2 | view_entity | inner | COMPOSITE | |
| P_FixedAssetValueWthDetn | view | union_all | COMPOSITE | |
| P_FxdAstDBPlanWithTempPlanVal | view | from | COMPOSITE | |
| P_FxdAstPlanValWithTmpPlanVal | view | union_all | COMPOSITE |
Fields (99)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | AccountingDocument | AccountingDocument | 3 |
| KEY | AssetAcctTransClassfctn | AssetAcctAnlytlTransClassfctn,AssetAcctTransClassfctn | 4 |
| KEY | AssetDepreciationArea | AssetDepreciationArea | 4 |
| KEY | CompanyCode | CompanyCode | 5 |
| KEY | DebitCreditCode | DebitCreditCode | 3 |
| KEY | FiscalPeriod | DepreciationFiscalPeriod,FiscalPeriod | 4 |
| KEY | FiscalYear | FiscalYear | 4 |
| KEY | FixedAsset | FixedAsset | 4 |
| KEY | Ledger | Ledger | 6 |
| KEY | LedgerGLLineItem | LedgerGLLineItem | 3 |
| KEY | MasterFixedAsset | MasterFixedAsset | 4 |
| KEY | SubLedgerAcctLineItemType | SubLedgerAcctLineItemType | 4 |
| KEY | TransactionSubitem | TransactionSubitem | 3 |
| _AccountingPrinciple | _AccountingPrinciple | 1 | |
| _CompanyCode | _CompanyCode | 1 | |
| _Ledger | _Ledger | 1 | |
| AccountingDocumentCreationDate | AccountingDocumentCreationDate | 2 | |
| AccountingDocumentType | AccountingDocumentType | 1 | |
| AccountingPrinciple | AccountingPrinciple | 2 | |
| AlternativeGLAccount | AlternativeGLAccount | 2 | |
| AmountInCompanyCodeCurrency | AmountInCompanyCodeCurrency | 3 | |
| AmountInFreeDefinedCurrency1 | AmountInFreeDefinedCurrency1 | 3 | |
| AmountInFreeDefinedCurrency2 | AmountInFreeDefinedCurrency2 | 3 | |
| AmountInFreeDefinedCurrency3 | AmountInFreeDefinedCurrency3 | 3 | |
| AmountInFreeDefinedCurrency4 | AmountInFreeDefinedCurrency4 | 3 | |
| AmountInFreeDefinedCurrency5 | AmountInFreeDefinedCurrency5 | 3 | |
| AmountInFreeDefinedCurrency6 | AmountInFreeDefinedCurrency6 | 3 | |
| AmountInFreeDefinedCurrency7 | AmountInFreeDefinedCurrency7 | 3 | |
| AmountInFreeDefinedCurrency8 | AmountInFreeDefinedCurrency8 | 3 | |
| AmountInFunctionalCurrency | AmountInFunctionalCurrency | 3 | |
| AmountInGlobalCurrency | AmountInGlobalCurrency | 3 | |
| AssetTransactionType | AssetTransactionType | 2 | |
| AssetValueDate | AssetValueDate | 1 | |
| AssignmentReference | AssignmentReference | 1 | |
| BaseUnit | BaseUnit | 2 | |
| BudgetPeriod | BudgetPeriod | 2 | |
| BusinessArea | BusinessArea | 2 | |
| ChartOfAccounts | ChartOfAccounts | 2 | |
| ChartOfDepreciation | ChartOfDepreciation | 5 | |
| CompanyCodeCurrency | CompanyCodeCurrency | 4 | |
| CompanyCodeCurrencyRole | CompanyCodeCurrencyRole | 1 | |
| ControllingArea | ControllingArea | 3 | |
| CostCenter | CostCenter | 2 | |
| Country | Country | 3 | |
| CountryChartOfAccounts | CountryChartOfAccounts | 2 | |
| CreationTime | CreationTime | 2 | |
| DepreciationFiscalPeriod | DepreciationFiscalPeriod | 2 | |
| DocumentDate | DocumentDate | 1 | |
| DocumentItemText | DocumentItemText | 1 | |
| FinancialAccountType | FinancialAccountType | 3 | |
| FinancialManagementArea | FinancialManagementArea | 3 | |
| FiscalYearPeriod | FiscalYearPeriod | 2 | |
| FiscalYearVariant | FiscalYearVariant | 3 | |
| FreeDefinedCurrency1 | FreeDefinedCurrency1 | 4 | |
| FreeDefinedCurrency1Role | FreeDefinedCurrency1Role | 1 | |
| FreeDefinedCurrency2 | FreeDefinedCurrency2 | 4 | |
| FreeDefinedCurrency2Role | FreeDefinedCurrency2Role | 1 | |
| FreeDefinedCurrency3 | FreeDefinedCurrency3 | 4 | |
| FreeDefinedCurrency3Role | FreeDefinedCurrency3Role | 1 | |
| FreeDefinedCurrency4 | FreeDefinedCurrency4 | 4 | |
| FreeDefinedCurrency4Role | FreeDefinedCurrency4Role | 1 | |
| FreeDefinedCurrency5 | FreeDefinedCurrency5 | 4 | |
| FreeDefinedCurrency5Role | FreeDefinedCurrency5Role | 1 | |
| FreeDefinedCurrency6 | FreeDefinedCurrency6 | 4 | |
| FreeDefinedCurrency6Role | FreeDefinedCurrency6Role | 1 | |
| FreeDefinedCurrency7 | FreeDefinedCurrency7 | 4 | |
| FreeDefinedCurrency7Role | FreeDefinedCurrency7Role | 1 | |
| FreeDefinedCurrency8 | FreeDefinedCurrency8 | 4 | |
| FreeDefinedCurrency8Role | FreeDefinedCurrency8Role | 1 | |
| FunctionalArea | FunctionalArea | 2 | |
| FunctionalCurrency | FunctionalCurrency | 3 | |
| FunctionalCurrencyRole | FunctionalCurrencyRole | 1 | |
| Fund | Fund | 2 | |
| FundsCenter | FundsCenter | 2 | |
| GLAccount | GLAccount | 2 | |
| GLBusinessTransactionType | GLBusinessTransactionType | 1 | |
| GlobalCurrency | GlobalCurrency | 4 | |
| GlobalCurrencyRole | GlobalCurrencyRole | 1 | |
| GrantID | GrantID | 2 | |
| GroupFixedAsset | GroupFixedAsset | 3 | |
| GroupMasterFixedAsset | GroupMasterFixedAsset | 3 | |
| IsReversal | IsReversal | 1 | |
| IsReversed | IsReversed | 1 | |
| JointVentureCostRecoveryCode | JointVentureCostRecoveryCode | 3 | |
| LedgerFiscalYear | LedgerFiscalYear | 3 | |
| LedgerGroup | LedgerGroup | 3 | |
| LogicalSystem | LogicalSystem | 1 | |
| PartnerFixedAsset | PartnerFixedAsset | 1 | |
| PartnerMasterFixedAsset | PartnerMasterFixedAsset | 1 | |
| PersonnelNumber | PersonnelNumber | 2 | |
| PlannedValueIsInclusive | PlannedValueIsInclusive | 1 | |
| Plant | Plant | 2 | |
| PostingDate | PostingDate | 3 | |
| ProfitCenter | ProfitCenter | 2 | |
| ReferenceDocument | ReferenceDocument | 1 | |
| ReferenceDocumentContext | ReferenceDocumentContext | 1 | |
| ReferenceDocumentItem | ReferenceDocumentItem | 1 | |
| ReferenceDocumentType | ReferenceDocumentType | 1 | |
| Segment | Segment | 2 |
@AbapCatalog: {sqlViewName: 'IFASSETPLAN',
preserveKey: true,
compiler.compareFilter: true}
@EndUserText.label: 'Fixed Asset Plan Values'
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel: { usageType.serviceQuality: #C,
usageType.sizeCategory: #XXL,
usageType.dataClass: #MIXED }
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
define view I_FixedAssetPlanValue
as select from P_FixedAssetPlanValue
inner join I_LedgerCompanyCodeCrcyRoles as LedgerCompanyCodeCrcyRoles on P_FixedAssetPlanValue.Ledger = LedgerCompanyCodeCrcyRoles.Ledger
and P_FixedAssetPlanValue.CompanyCode = LedgerCompanyCodeCrcyRoles.CompanyCode
association [0..1] to I_DepreciationAreaForLedger as _DepreciationArea on $projection.CompanyCode = _DepreciationArea.CompanyCode
and $projection.Ledger = _DepreciationArea.Ledger
and $projection.AssetDepreciationArea = _DepreciationArea.AssetDepreciationArea
association [0..1] to I_CompanyCode as _CompanyCode on $projection.CompanyCode = _CompanyCode.CompanyCode
association [0..1] to I_FiscalYearForCompanyCode as _FiscalYear on $projection.FiscalYear = _FiscalYear.FiscalYear
and $projection.CompanyCode = _FiscalYear.CompanyCode
association [0..1] to I_MasterFixedAsset as _MasterFixedAsset on $projection.CompanyCode = _MasterFixedAsset.CompanyCode
and $projection.MasterFixedAsset = _MasterFixedAsset.MasterFixedAsset
association [0..1] to I_FixedAsset as _FixedAsset on $projection.CompanyCode = _FixedAsset.CompanyCode
and $projection.FixedAsset = _FixedAsset.FixedAsset
and $projection.MasterFixedAsset = _FixedAsset.MasterFixedAsset
association [0..1] to I_SubLedgerAccLineItemType as _SubLedgerAccLineItemType on $projection.SubLedgerAcctLineItemType = _SubLedgerAccLineItemType.SubLedgerAcctLineItemType
association [0..1] to I_FiscalYearPeriodForCmpnyCode as _FiscalPeriod on $projection.FiscalYear = _FiscalPeriod.FiscalYear
and $projection.FiscalPeriod = _FiscalPeriod.FiscalPeriod
and $projection.CompanyCode = _FiscalPeriod.CompanyCode
association [0..1] to I_Ledger as _Ledger on $projection.Ledger = _Ledger.Ledger
association [0..1] to I_LedgerGroup as _LedgerGroup on $projection.LedgerGroup = _LedgerGroup.LedgerGroup
association [0..1] to I_FinancialAccountType as _FinancialAccountType on $projection.FinancialAccountType = _FinancialAccountType.FinancialAccountType
association [0..1] to I_ChartOfDepreciation as _ChartOfDepreciation on $projection.chartofdepreciation = _ChartOfDepreciation.ChartOfDepreciation
association [0..1] to I_MovementCategory as _AssetAcctTransClassfctn on $projection.AssetAcctTransClassfctn = _AssetAcctTransClassfctn.AssetAcctTransClassfctn
association [0..1] to I_Currency as _CompanyCodeCurrency on $projection.CompanyCodeCurrency = _CompanyCodeCurrency.Currency
association [0..1] to I_Currency as _GlobalCurrency on $projection.GlobalCurrency = _GlobalCurrency.Currency
association [0..1] to I_Currency as _FreeDefinedCurrency1 on $projection.FreeDefinedCurrency1 = _FreeDefinedCurrency1.Currency
association [0..1] to I_Currency as _FreeDefinedCurrency2 on $projection.FreeDefinedCurrency2 = _FreeDefinedCurrency2.Currency
association [0..1] to I_Currency as _FreeDefinedCurrency3 on $projection.FreeDefinedCurrency3 = _FreeDefinedCurrency3.Currency
association [0..1] to I_Currency as _FreeDefinedCurrency4 on $projection.FreeDefinedCurrency4 = _FreeDefinedCurrency4.Currency
association [0..1] to I_Currency as _FreeDefinedCurrency5 on $projection.FreeDefinedCurrency5 = _FreeDefinedCurrency5.Currency
association [0..1] to I_Currency as _FreeDefinedCurrency6 on $projection.FreeDefinedCurrency6 = _FreeDefinedCurrency6.Currency
association [0..1] to I_Currency as _FreeDefinedCurrency7 on $projection.FreeDefinedCurrency7 = _FreeDefinedCurrency7.Currency
association [0..1] to I_Currency as _FreeDefinedCurrency8 on $projection.FreeDefinedCurrency8 = _FreeDefinedCurrency8.Currency
association [1] to I_AccountingPrinciple as _AccountingPrinciple on $projection.AccountingPrinciple = _AccountingPrinciple.AccountingPrinciple
association [0..1] to I_ChartOfDeprForAcctgPrinciple as _ChartOfDeprForAcctgPrinciple on $projection.AccountingPrinciple = _ChartOfDeprForAcctgPrinciple.AccountingPrinciple
and $projection.CompanyCode = _ChartOfDeprForAcctgPrinciple.CompanyCode
{
@ObjectModel.foreignKey.association: '_CompanyCode'
key P_FixedAssetPlanValue.CompanyCode,
@ObjectModel.foreignKey.association: '_MasterFixedAsset'
key MasterFixedAsset,
@ObjectModel.foreignKey.association: '_FixedAsset'
key FixedAsset,
@ObjectModel.foreignKey.association: '_FiscalYear'
key FiscalYear,
@ObjectModel.foreignKey.association: '_DepreciationArea'
key AssetDepreciationArea,
@ObjectModel.foreignKey.association: '_FiscalPeriod'
key FiscalPeriod,
@ObjectModel.foreignKey.association: '_SubledgerAccLineItemType'
key SubLedgerAcctLineItemType,
@Semantics.fiscal.year: true
LedgerFiscalYear,
@ObjectModel.foreignKey.association: '_AccountingPrinciple'
LedgerCompanyCodeCrcyRoles.AccountingPrinciple,
cast('2' as faa_use_val_ty) as PlannedValueIsInclusive,
@ObjectModel.foreignKey.association: '_Ledger'
P_FixedAssetPlanValue.Ledger,
@ObjectModel.foreignKey.association: '_LedgerGroup'
cast('' as faa_deprecated_target_ldgrp) as LedgerGroup,
@ObjectModel.foreignKey.association: '_AssetAcctTransClassfctn'
AssetAcctTransClassfctn,
GroupMasterFixedAsset,
GroupFixedAsset,
@ObjectModel.foreignKey.association: '_FinancialAccountType'
FinancialAccountType,
JointVentureCostRecoveryCode,
@ObjectModel.foreignKey.association: '_ChartOfDepreciation'
_ChartOfDeprForAcctgPrinciple.ChartOfDepreciation,
DepreciationIsDue,
@Semantics.currencyCode:true
@ObjectModel.foreignKey.association: '_CompanyCodeCurrency'
CompanyCodeCurrency,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
AmountInCompanyCodeCurrency,
@Semantics.currencyCode:true
@ObjectModel.foreignKey.association: '_GlobalCurrency'
GlobalCurrency,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
AmountInGlobalCurrency,
@Semantics.currencyCode:true
@ObjectModel.foreignKey.association: '_FreeDefinedCurrency1'
FreeDefinedCurrency1,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }
AmountInFreeDefinedCurrency1,
@Semantics.currencyCode:true
@ObjectModel.foreignKey.association: '_FreeDefinedCurrency2'
FreeDefinedCurrency2,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }
AmountInFreeDefinedCurrency2,
@Semantics.currencyCode:true
@ObjectModel.foreignKey.association: '_FreeDefinedCurrency3'
FreeDefinedCurrency3,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }
AmountInFreeDefinedCurrency3,
@Semantics.currencyCode:true
@ObjectModel.foreignKey.association: '_FreeDefinedCurrency4'
FreeDefinedCurrency4,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }
AmountInFreeDefinedCurrency4,
@Semantics.currencyCode:true
@ObjectModel.foreignKey.association: '_FreeDefinedCurrency5'
FreeDefinedCurrency5,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }
AmountInFreeDefinedCurrency5,
@Semantics.currencyCode:true
@ObjectModel.foreignKey.association: '_FreeDefinedCurrency6'
FreeDefinedCurrency6,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }
AmountInFreeDefinedCurrency6,
@Semantics.currencyCode:true
@ObjectModel.foreignKey.association: '_FreeDefinedCurrency7'
FreeDefinedCurrency7,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }
AmountInFreeDefinedCurrency7,
@Semantics.currencyCode:true
@ObjectModel.foreignKey.association: '_FreeDefinedCurrency8'
FreeDefinedCurrency8,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }
AmountInFreeDefinedCurrency8,
_CompanyCode,
_FiscalYear,
_MasterFixedAsset,
_FixedAsset,
_DepreciationArea,
_SubLedgerAccLineItemType,
_FiscalPeriod,
_Ledger,
_LedgerGroup,
_FinancialAccountType,
_ChartOfDepreciation,
_AssetAcctTransClassfctn,
_CompanyCodeCurrency,
_GlobalCurrency,
_FreeDefinedCurrency1,
_FreeDefinedCurrency2,
_FreeDefinedCurrency3,
_FreeDefinedCurrency4,
_FreeDefinedCurrency5,
_FreeDefinedCurrency6,
_FreeDefinedCurrency7,
_FreeDefinedCurrency8,
_AccountingPrinciple
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHARTOFDEPRFORACCTGPRINCIPLE",
"I_LEDGERCOMPANYCODECRCYROLES",
"P_FIXEDASSETPLANVALUE"
],
"ASSOCIATED":
[
"I_ACCOUNTINGPRINCIPLE",
"I_CHARTOFDEPRECIATION",
"I_CHARTOFDEPRFORACCTGPRINCIPLE",
"I_COMPANYCODE",
"I_CURRENCY",
"I_DEPRECIATIONAREAFORLEDGER",
"I_FINANCIALACCOUNTTYPE",
"I_FISCALYEARFORCOMPANYCODE",
"I_FISCALYEARPERIODFORCMPNYCODE",
"I_FIXEDASSET",
"I_LEDGER",
"I_LEDGERGROUP",
"I_MASTERFIXEDASSET",
"I_MOVEMENTCATEGORY",
"I_SUBLEDGERACCLINEITEMTYPE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/