I_FIXEDASSETPLANVALUE

CDS View
103 Fields 7 CDS Views

Fixed Asset Plan Values

I_FIXEDASSETPLANVALUE is a CDS View in S/4HANA. Fixed Asset Plan Values. It contains 103 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
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 (103)

KeyField CDS FieldsUsed 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
BusinessTransactionCategory BusinessTransactionCategory 2
BusinessTransactionType BusinessTransactionType 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
FinancialClosingStep FinancialClosingStep 2
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
PartnerCompanyCode PartnerCompanyCode 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

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Fixed Asset Plan Values
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_FIXEDASSETPLANVALUE (
    ACCOUNTINGDOCUMENT,
    ASSETACCTTRANSCLASSFCTN,
    ASSETDEPRECIATIONAREA,
    COMPANYCODE,
    DEBITCREDITCODE,
    FISCALPERIOD,
    FISCALYEAR,
    FIXEDASSET,
    LEDGER,
    LEDGERGLLINEITEM,
    MASTERFIXEDASSET,
    SUBLEDGERACCTLINEITEMTYPE,
    TRANSACTIONSUBITEM,
    _ACCOUNTINGPRINCIPLE,
    _COMPANYCODE,
    _LEDGER,
    ACCOUNTINGDOCUMENTCREATIONDATE,
    ACCOUNTINGDOCUMENTTYPE,
    ACCOUNTINGPRINCIPLE,
    ALTERNATIVEGLACCOUNT,
    AMOUNTINCOMPANYCODECURRENCY,
    AMOUNTINFREEDEFINEDCURRENCY1,
    AMOUNTINFREEDEFINEDCURRENCY2,
    AMOUNTINFREEDEFINEDCURRENCY3,
    AMOUNTINFREEDEFINEDCURRENCY4,
    AMOUNTINFREEDEFINEDCURRENCY5,
    AMOUNTINFREEDEFINEDCURRENCY6,
    AMOUNTINFREEDEFINEDCURRENCY7,
    AMOUNTINFREEDEFINEDCURRENCY8,
    AMOUNTINFUNCTIONALCURRENCY,
    AMOUNTINGLOBALCURRENCY,
    ASSETTRANSACTIONTYPE,
    ASSETVALUEDATE,
    ASSIGNMENTREFERENCE,
    BASEUNIT,
    BUDGETPERIOD,
    BUSINESSAREA,
    BUSINESSTRANSACTIONCATEGORY,
    BUSINESSTRANSACTIONTYPE,
    CHARTOFACCOUNTS,
    CHARTOFDEPRECIATION,
    COMPANYCODECURRENCY,
    COMPANYCODECURRENCYROLE,
    CONTROLLINGAREA,
    COSTCENTER,
    COUNTRY,
    COUNTRYCHARTOFACCOUNTS,
    CREATIONTIME,
    DEPRECIATIONFISCALPERIOD,
    DOCUMENTDATE,
    DOCUMENTITEMTEXT,
    FINANCIALACCOUNTTYPE,
    FINANCIALCLOSINGSTEP,
    FINANCIALMANAGEMENTAREA,
    FISCALYEARPERIOD,
    FISCALYEARVARIANT,
    FREEDEFINEDCURRENCY1,
    FREEDEFINEDCURRENCY1ROLE,
    FREEDEFINEDCURRENCY2,
    FREEDEFINEDCURRENCY2ROLE,
    FREEDEFINEDCURRENCY3,
    FREEDEFINEDCURRENCY3ROLE,
    FREEDEFINEDCURRENCY4,
    FREEDEFINEDCURRENCY4ROLE,
    FREEDEFINEDCURRENCY5,
    FREEDEFINEDCURRENCY5ROLE,
    FREEDEFINEDCURRENCY6,
    FREEDEFINEDCURRENCY6ROLE,
    FREEDEFINEDCURRENCY7,
    FREEDEFINEDCURRENCY7ROLE,
    FREEDEFINEDCURRENCY8,
    FREEDEFINEDCURRENCY8ROLE,
    FUNCTIONALAREA,
    FUNCTIONALCURRENCY,
    FUNCTIONALCURRENCYROLE,
    FUND,
    FUNDSCENTER,
    GLACCOUNT,
    GLBUSINESSTRANSACTIONTYPE,
    GLOBALCURRENCY,
    GLOBALCURRENCYROLE,
    GRANTID,
    GROUPFIXEDASSET,
    GROUPMASTERFIXEDASSET,
    ISREVERSAL,
    ISREVERSED,
    JOINTVENTURECOSTRECOVERYCODE,
    LEDGERFISCALYEAR,
    LEDGERGROUP,
    LOGICALSYSTEM,
    PARTNERCOMPANYCODE,
    PARTNERFIXEDASSET,
    PARTNERMASTERFIXEDASSET,
    PERSONNELNUMBER,
    PLANNEDVALUEISINCLUSIVE,
    PLANT,
    POSTINGDATE,
    PROFITCENTER,
    REFERENCEDOCUMENT,
    REFERENCEDOCUMENTCONTEXT,
    REFERENCEDOCUMENTITEM,
    REFERENCEDOCUMENTTYPE,
    SEGMENT,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, ASSETACCTTRANSCLASSFCTN, ASSETDEPRECIATIONAREA, COMPANYCODE, DEBITCREDITCODE, FISCALPERIOD, FISCALYEAR, FIXEDASSET, LEDGER, LEDGERGLLINEITEM, MASTERFIXEDASSET, SUBLEDGERACCTLINEITEMTYPE, TRANSACTIONSUBITEM)
);

Learn More