I_FIXEDASSETLINEITEM

CDS View
94 Fields 10 CDS Views

Fixed Asset Line Items

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

CDS Views using this table (10)

ViewTypeJoinVDMDescription
C_RO_SAFTFixedAssetTransCube view from CONSUMPTION RO SAFT Fixed Asset Transaction - Cube
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_AssetHistorySheetCube4 view_entity inner COMPOSITE
P_FixedAssetDepreciationList2 view_entity inner COMPOSITE
P_FixedAssetLineItem view from COMPOSITE
P_FixedAssetTransaction2 view_entity inner COMPOSITE
P_FixedAssetValueWthDetn view from COMPOSITE
P_RU_PropertyTaxFixedAssetVal0 view left_outer COMPOSITE

Fields (94)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 5
KEY AssetAcctTransClassfctn AssetAcctTransClassfctn 5
KEY AssetDepreciationArea AssetDepreciationArea 5
KEY CompanyCode CompanyCode 6
KEY DebitCreditCode DebitCreditCode 4
KEY FiscalPeriod FiscalPeriod 5
KEY FiscalYear FiscalYear 5
KEY FixedAsset FixedAsset 5
KEY Ledger Ledger 6
KEY LedgerGLLineItem LedgerGLLineItem 2
KEY LedgerGroup LedgerGroup 6
KEY MasterFixedAsset MasterFixedAsset 5
KEY SubLedgerAcctLineItemType SubLedgerAcctLineItemType 5
KEY TransactionSubitem TransactionSubitem 5
_AccountingPrinciple _AccountingPrinciple 1
_CompanyCode _CompanyCode 1
_FiscalYearVariant _FiscalYearVariant 1
_Ledger _Ledger 1
AccountingDocCreatedByUser AccountingDocCreatedByUser 3
AccountingDocumentCreationDate AccountingDocumentCreationDate 5
AccountingDocumentType AccountingDocumentType 1
AccountingPrinciple AccountingPrinciple 2
AlternativeGLAccount AlternativeGLAccount 2
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency 3
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 5
AssetValueDate AssetValueDate 3
AssignmentReference AssignmentReference 3
BaseUnit BaseUnit 2
BudgetPeriod BudgetPeriod 3
BusinessArea BusinessArea 5
ChartOfAccounts ChartOfAccounts 2
ChartOfDepreciation ChartOfDepreciation 5
CompanyCodeCurrency CompanyCodeCurrency 5
ControllingArea ControllingArea 3
CostCenter CostCenter 3
Country Country 2
CountryChartOfAccounts CountryChartOfAccounts 2
CreationTime CreationTime 5
DepreciationFiscalPeriod DepreciationFiscalPeriod 1
DocumentDate DocumentDate 3
DocumentItemText DocumentItemText 3
FinancialAccountType FinancialAccountType 5
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 5
FunctionalCurrency FunctionalCurrency 2
Fund Fund 5
FundsCenter FundsCenter 2
GLAccount GLAccount 3
GLBusinessTransactionType GLBusinessTransactionType 1
GlobalCurrency GlobalCurrency 4
GrantID GrantID 3
GroupFixedAsset GroupFixedAsset 5
GroupMasterFixedAsset GroupMasterFixedAsset 5
IsReversal IsReversal 3
IsReversed IsReversed 3
IsStatisticalDocument IsStatisticalDocument 3
JointVentureCostRecoveryCode JointVentureCostRecoveryCode 3
LedgerFiscalYear LedgerFiscalYear 2
LogicalSystem LogicalSystem 3
PartnerFixedAsset PartnerFixedAsset 1
PartnerMasterFixedAsset PartnerMasterFixedAsset 1
PersonnelNumber PersonnelNumber 3
Plant Plant 3
PostingDate PostingDate 4
ProfitCenter ProfitCenter 3
Quantity Quantity 2
ReferenceDocument ReferenceDocument 3
ReferenceDocumentContext ReferenceDocumentContext 3
ReferenceDocumentItem ReferenceDocumentItem 1
ReferenceDocumentType ReferenceDocumentType 3
ReversalReferenceDocument ReversalReferenceDocument 3
ReversalReferenceDocumentCntxt ReversalReferenceDocumentCntxt 3
ReversalTransactionSubitem ReversalTransactionSubitem 3
Segment Segment 5

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,
    CHARTOFACCOUNTS,
    CHARTOFDEPRECIATION,
    COMPANYCODECURRENCY,
    CONTROLLINGAREA,
    COSTCENTER,
    COUNTRY,
    COUNTRYCHARTOFACCOUNTS,
    CREATIONTIME,
    DEPRECIATIONFISCALPERIOD,
    DOCUMENTDATE,
    DOCUMENTITEMTEXT,
    FINANCIALACCOUNTTYPE,
    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,
    PARTNERFIXEDASSET,
    PARTNERMASTERFIXEDASSET,
    PERSONNELNUMBER,
    PLANT,
    POSTINGDATE,
    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