I_FIXEDASSETLINEITEM

CDS View
103 Fields 9 CDS Views

Fixed Asset Line Items

I_FIXEDASSETLINEITEM is a CDS View in S/4HANA. Fixed Asset Line Items. It contains 103 fields. 9 CDS views read from this table.

CDS Views using this table (9)

ViewTypeJoinVDMDescription
FAC_DART_Z3_LINEITEM_FIXEDAST view from Fixed Assets - Line Item
I_FxdAstLineItemWithCrcyRole view from COMPOSITE Fixed Asset Line Items with currency role
P_AssetBalanceCube2 view_entity inner COMPOSITE P_AssetBalanceCube2
P_AssetHistorySheetCube4 view_entity inner COMPOSITE P_AssetHistorySheetCube4
P_FixedAssetDepreciationList2 view_entity inner COMPOSITE P_FixedAssetDepreciationList2
P_FixedAssetLineItem view from COMPOSITE P_FixedAssetLineItem
P_FixedAssetTransaction2 view_entity inner COMPOSITE P_FixedAssetTransaction2
P_FixedAssetValueWthDetn view from COMPOSITE P_FixedAssetValue
P_RU_PropertyTaxFixedAssetVal0 view left_outer COMPOSITE Russia Property Tax: select Fixed Assets Values - 2

Fields (103)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 4
KEY AssetAcctTransClassfctn AssetAcctTransClassfctn 3
KEY AssetDepreciationArea AssetDepreciationArea 4
KEY CompanyCode CompanyCode 5
KEY DebitCreditCode DebitCreditCode 3
KEY FiscalPeriod FiscalPeriod 4
KEY FiscalYear FiscalYear 4
KEY FixedAsset FixedAsset 4
KEY Ledger Ledger 5
KEY LedgerGLLineItem LedgerGLLineItem 2
KEY LedgerGroup LedgerGroup 5
KEY MasterFixedAsset MasterFixedAsset 4
KEY SubLedgerAcctLineItemType SubLedgerAcctLineItemType 3
KEY TransactionSubitem TransactionSubitem 4
_AccountingPrinciple _AccountingPrinciple 1
_CompanyCode _CompanyCode 1
_FiscalYearVariant _FiscalYearVariant 1
_Ledger _Ledger 1
AccountingDocCreatedByUser AccountingDocCreatedByUser 2
AccountingDocumentCreationDate AccountingDocumentCreationDate 4
AccountingDocumentType AccountingDocumentType 1
AccountingPrinciple AccountingPrinciple 2
AlternativeGLAccount AlternativeGLAccount 2
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency 2
AmountInFreeDefinedCurrency1 AmountInFreeDefinedCurrency1 2
AmountInFreeDefinedCurrency2 AmountInFreeDefinedCurrency2 2
AmountInFreeDefinedCurrency3 AmountInFreeDefinedCurrency3 2
AmountInFreeDefinedCurrency4 AmountInFreeDefinedCurrency4 2
AmountInFreeDefinedCurrency5 AmountInFreeDefinedCurrency5 2
AmountInFreeDefinedCurrency6 AmountInFreeDefinedCurrency6 2
AmountInFreeDefinedCurrency7 AmountInFreeDefinedCurrency7 2
AmountInFreeDefinedCurrency8 AmountInFreeDefinedCurrency8 2
AmountInFunctionalCurrency AmountInFunctionalCurrency 2
AmountInGlobalCurrency AmountInGlobalCurrency 2
AssetTransactionType AssetTransactionType 4
AssetValueDate AssetValueDate 2
AssignmentReference AssignmentReference 2
BaseUnit BaseUnit 2
BudgetPeriod BudgetPeriod 3
BusinessArea BusinessArea 4
BusinessTransactionCategory BusinessTransactionCategory 2
BusinessTransactionType BusinessTransactionType 2
ChartOfAccounts ChartOfAccounts 2
ChartOfDepreciation ChartOfDepreciation 4
CompanyCodeCurrency CompanyCodeCurrency 4
ControllingArea ControllingArea 2
CostCenter CostCenter 3
Country Country 2
CountryChartOfAccounts CountryChartOfAccounts 2
CreationTime CreationTime 4
DepreciationFiscalPeriod DepreciationFiscalPeriod 1
DocumentDate DocumentDate 2
DocumentItemText DocumentItemText 2
FinancialAccountType FinancialAccountType 4
FinancialClosingStep FinancialClosingStep 2
FinancialManagementArea FinancialManagementArea 3
FiscalYearPeriod FiscalYearPeriod 2
FiscalYearVariant FiscalYearVariant 3
FreeDefinedCurrency1 FreeDefinedCurrency1 4
FreeDefinedCurrency2 FreeDefinedCurrency2 4
FreeDefinedCurrency3 FreeDefinedCurrency3 4
FreeDefinedCurrency4 FreeDefinedCurrency4 4
FreeDefinedCurrency5 FreeDefinedCurrency5 4
FreeDefinedCurrency6 FreeDefinedCurrency6 4
FreeDefinedCurrency7 FreeDefinedCurrency7 4
FreeDefinedCurrency8 FreeDefinedCurrency8 4
FunctionalArea FunctionalArea 4
FunctionalCurrency FunctionalCurrency 2
Fund Fund 4
FundsCenter FundsCenter 2
GLAccount GLAccount 3
GLBusinessTransactionType GLBusinessTransactionType 1
GlobalCurrency GlobalCurrency 4
GrantID GrantID 3
GroupFixedAsset GroupFixedAsset 4
GroupMasterFixedAsset GroupMasterFixedAsset 4
IsReversal IsReversal 2
IsReversed IsReversed 2
IsStatisticalDocument IsStatisticalDocument 2
JointVentureCostRecoveryCode JointVentureCostRecoveryCode 3
LedgerFiscalYear LedgerFiscalYear 2
LogicalSystem LogicalSystem 2
PartnerCompanyCode PartnerCompanyCode 2
PartnerFixedAsset PartnerFixedAsset 3
PartnerMasterFixedAsset PartnerMasterFixedAsset 3
PersonnelNumber PersonnelNumber 3
Plant Plant 3
PostingDate PostingDate 3
PredecessorJournalEntry PredecessorJournalEntry 1
PredecessorReferenceDocCntxt PredecessorReferenceDocCntxt 1
PredecessorReferenceDocItem PredecessorReferenceDocItem 1
PredecessorReferenceDocType PredecessorReferenceDocType 1
PredecessorReferenceDocument PredecessorReferenceDocument 1
ProfitCenter ProfitCenter 3
Quantity Quantity 2
ReferenceDocument ReferenceDocument 2
ReferenceDocumentContext ReferenceDocumentContext 2
ReferenceDocumentItem ReferenceDocumentItem 2
ReferenceDocumentType ReferenceDocumentType 2
ReversalReferenceDocument ReversalReferenceDocument 2
ReversalReferenceDocumentCntxt ReversalReferenceDocumentCntxt 2
ReversalTransactionSubitem ReversalTransactionSubitem 2
Segment Segment 4

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 Line Items
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_FIXEDASSETLINEITEM (
    ACCOUNTINGDOCUMENT,
    ASSETACCTTRANSCLASSFCTN,
    ASSETDEPRECIATIONAREA,
    COMPANYCODE,
    DEBITCREDITCODE,
    FISCALPERIOD,
    FISCALYEAR,
    FIXEDASSET,
    LEDGER,
    LEDGERGLLINEITEM,
    LEDGERGROUP,
    MASTERFIXEDASSET,
    SUBLEDGERACCTLINEITEMTYPE,
    TRANSACTIONSUBITEM,
    _ACCOUNTINGPRINCIPLE,
    _COMPANYCODE,
    _FISCALYEARVARIANT,
    _LEDGER,
    ACCOUNTINGDOCCREATEDBYUSER,
    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,
    CONTROLLINGAREA,
    COSTCENTER,
    COUNTRY,
    COUNTRYCHARTOFACCOUNTS,
    CREATIONTIME,
    DEPRECIATIONFISCALPERIOD,
    DOCUMENTDATE,
    DOCUMENTITEMTEXT,
    FINANCIALACCOUNTTYPE,
    FINANCIALCLOSINGSTEP,
    FINANCIALMANAGEMENTAREA,
    FISCALYEARPERIOD,
    FISCALYEARVARIANT,
    FREEDEFINEDCURRENCY1,
    FREEDEFINEDCURRENCY2,
    FREEDEFINEDCURRENCY3,
    FREEDEFINEDCURRENCY4,
    FREEDEFINEDCURRENCY5,
    FREEDEFINEDCURRENCY6,
    FREEDEFINEDCURRENCY7,
    FREEDEFINEDCURRENCY8,
    FUNCTIONALAREA,
    FUNCTIONALCURRENCY,
    FUND,
    FUNDSCENTER,
    GLACCOUNT,
    GLBUSINESSTRANSACTIONTYPE,
    GLOBALCURRENCY,
    GRANTID,
    GROUPFIXEDASSET,
    GROUPMASTERFIXEDASSET,
    ISREVERSAL,
    ISREVERSED,
    ISSTATISTICALDOCUMENT,
    JOINTVENTURECOSTRECOVERYCODE,
    LEDGERFISCALYEAR,
    LOGICALSYSTEM,
    PARTNERCOMPANYCODE,
    PARTNERFIXEDASSET,
    PARTNERMASTERFIXEDASSET,
    PERSONNELNUMBER,
    PLANT,
    POSTINGDATE,
    PREDECESSORJOURNALENTRY,
    PREDECESSORREFERENCEDOCCNTXT,
    PREDECESSORREFERENCEDOCITEM,
    PREDECESSORREFERENCEDOCTYPE,
    PREDECESSORREFERENCEDOCUMENT,
    PROFITCENTER,
    QUANTITY,
    REFERENCEDOCUMENT,
    REFERENCEDOCUMENTCONTEXT,
    REFERENCEDOCUMENTITEM,
    REFERENCEDOCUMENTTYPE,
    REVERSALREFERENCEDOCUMENT,
    REVERSALREFERENCEDOCUMENTCNTXT,
    REVERSALTRANSACTIONSUBITEM,
    SEGMENT,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, ASSETACCTTRANSCLASSFCTN, ASSETDEPRECIATIONAREA, COMPANYCODE, DEBITCREDITCODE, FISCALPERIOD, FISCALYEAR, FIXEDASSET, LEDGER, LEDGERGLLINEITEM, LEDGERGROUP, MASTERFIXEDASSET, SUBLEDGERACCTLINEITEMTYPE, TRANSACTIONSUBITEM)
);

Learn More