I_FXDASTSTATISTICALLINEITEM

CDS View
57 Fields 2 CDS Views

Statistical Line Items of Fixed Asset

I_FXDASTSTATISTICALLINEITEM is a CDS View in S/4HANA. Statistical Line Items of Fixed Asset. It contains 57 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_AssetBalanceLineItem1 view union_all COMPOSITE
P_FixedAssetLineItem1 view union_all COMPOSITE

Fields (57)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 2
KEY DebitCreditCode DebitCreditCode 2
KEY FiscalPeriod FiscalPeriod 2
KEY FiscalYear FiscalYear 2
KEY FixedAsset FixedAsset 2
KEY Ledger Ledger 2
KEY LedgerGroup LedgerGroup 2
KEY MasterFixedAsset MasterFixedAsset 2
KEY SubLedgerAcctLineItemType SubLedgerAcctLineItemType 2
KEY TransactionSubitem TransactionSubitem 2
AccountingDocCreatedByUser AccountingDocCreatedByUser 2
AccountingDocumentCreationDate AccountingDocumentCreationDate 2
AccountingPrinciple AccountingPrinciple 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
AmountInGlobalCurrency AmountInGlobalCurrency 2
AssetAcctTransClassfctn AssetAcctTransClassfctn 2
AssetTransactionType AssetTransactionType 2
AssetValueDate AssetValueDate 2
AssignmentReference AssignmentReference 2
ChartOfDepreciation ChartOfDepreciation 2
CompanyCodeCurrency CompanyCodeCurrency 2
CreationTime CreationTime 2
DocumentDate DocumentDate 2
DocumentItemText DocumentItemText 2
FreeDefinedCurrency1 FreeDefinedCurrency1 2
FreeDefinedCurrency2 FreeDefinedCurrency2 2
FreeDefinedCurrency3 FreeDefinedCurrency3 2
FreeDefinedCurrency4 FreeDefinedCurrency4 2
FreeDefinedCurrency5 FreeDefinedCurrency5 2
FreeDefinedCurrency6 FreeDefinedCurrency6 2
FreeDefinedCurrency7 FreeDefinedCurrency7 2
FreeDefinedCurrency8 FreeDefinedCurrency8 2
GLBusinessTransactionType GLBusinessTransactionType 2
GlobalCurrency GlobalCurrency 2
GroupFixedAsset GroupFixedAsset 2
GroupMasterFixedAsset GroupMasterFixedAsset 2
IsReversal IsReversal 2
IsReversed IsReversed 2
JointVentureCostRecoveryCode JointVentureCostRecoveryCode 2
LogicalSystem LogicalSystem 2
PartnerFixedAsset PartnerFixedAsset 2
PartnerMasterFixedAsset PartnerMasterFixedAsset 2
PostingDate PostingDate 2
ReferenceDocument ReferenceDocument 2
ReferenceDocumentContext ReferenceDocumentContext 2
ReferenceDocumentItem ReferenceDocumentItem 2
ReferenceDocumentType ReferenceDocumentType 2
ReversalReferenceDocument ReversalReferenceDocument 2
ReversalReferenceDocumentCntxt ReversalReferenceDocumentCntxt 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.

-- Statistical Line Items of Fixed Asset
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_FXDASTSTATISTICALLINEITEM (
    COMPANYCODE,
    DEBITCREDITCODE,
    FISCALPERIOD,
    FISCALYEAR,
    FIXEDASSET,
    LEDGER,
    LEDGERGROUP,
    MASTERFIXEDASSET,
    SUBLEDGERACCTLINEITEMTYPE,
    TRANSACTIONSUBITEM,
    ACCOUNTINGDOCCREATEDBYUSER,
    ACCOUNTINGDOCUMENTCREATIONDATE,
    ACCOUNTINGPRINCIPLE,
    AMOUNTINCOMPANYCODECURRENCY,
    AMOUNTINFREEDEFINEDCURRENCY1,
    AMOUNTINFREEDEFINEDCURRENCY2,
    AMOUNTINFREEDEFINEDCURRENCY3,
    AMOUNTINFREEDEFINEDCURRENCY4,
    AMOUNTINFREEDEFINEDCURRENCY5,
    AMOUNTINFREEDEFINEDCURRENCY6,
    AMOUNTINFREEDEFINEDCURRENCY7,
    AMOUNTINFREEDEFINEDCURRENCY8,
    AMOUNTINGLOBALCURRENCY,
    ASSETACCTTRANSCLASSFCTN,
    ASSETTRANSACTIONTYPE,
    ASSETVALUEDATE,
    ASSIGNMENTREFERENCE,
    CHARTOFDEPRECIATION,
    COMPANYCODECURRENCY,
    CREATIONTIME,
    DOCUMENTDATE,
    DOCUMENTITEMTEXT,
    FREEDEFINEDCURRENCY1,
    FREEDEFINEDCURRENCY2,
    FREEDEFINEDCURRENCY3,
    FREEDEFINEDCURRENCY4,
    FREEDEFINEDCURRENCY5,
    FREEDEFINEDCURRENCY6,
    FREEDEFINEDCURRENCY7,
    FREEDEFINEDCURRENCY8,
    GLBUSINESSTRANSACTIONTYPE,
    GLOBALCURRENCY,
    GROUPFIXEDASSET,
    GROUPMASTERFIXEDASSET,
    ISREVERSAL,
    ISREVERSED,
    JOINTVENTURECOSTRECOVERYCODE,
    LOGICALSYSTEM,
    PARTNERFIXEDASSET,
    PARTNERMASTERFIXEDASSET,
    POSTINGDATE,
    REFERENCEDOCUMENT,
    REFERENCEDOCUMENTCONTEXT,
    REFERENCEDOCUMENTITEM,
    REFERENCEDOCUMENTTYPE,
    REVERSALREFERENCEDOCUMENT,
    REVERSALREFERENCEDOCUMENTCNTXT,
    PRIMARY KEY (COMPANYCODE, DEBITCREDITCODE, FISCALPERIOD, FISCALYEAR, FIXEDASSET, LEDGER, LEDGERGROUP, MASTERFIXEDASSET, SUBLEDGERACCTLINEITEMTYPE, TRANSACTIONSUBITEM)
);

Learn More