I_FXDASTLINEITEMWITHCRCYROLE

CDS View
58 Fields 3 CDS Views

Fixed Asset Line Items with currency role

I_FXDASTLINEITEMWITHCRCYROLE is a CDS View in S/4HANA. Fixed Asset Line Items with currency role. It contains 58 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
C_FxdAstLineItmValueByCrcyRole view from CONSUMPTION Cons. View Line Items of a Fixed Asset
I_AssetLineItmBalByCrcyRole view_entity from COMPOSITE Asset Line Items with currency role
P_FxdAstValueWithCurrencyRole view from COMPOSITE

Fields (58)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 1
KEY AssetDepreciationArea AssetDepreciationArea 2
KEY CompanyCode CompanyCode 3
KEY DebitCreditCode DebitCreditCode 1
KEY FiscalPeriod FiscalPeriod 1
KEY FiscalYear FiscalYear 1
KEY FixedAsset FixedAsset 1
KEY Ledger Ledger 2
KEY LedgerGroup LedgerGroup 2
KEY MasterFixedAsset MasterFixedAsset 1
KEY SubLedgerAcctLineItemType SubLedgerAcctLineItemType 1
KEY TransactionSubitem TransactionSubitem 1
_AssetAcctTransClassfctn _AssetAcctTransClassfctn 1
_AssetTransactionType _AssetTransactionType 1
_ChartOfDepreciation _ChartOfDepreciation 1
_CompanyCode _CompanyCode 2
_DebitCreditCode _DebitCreditCode 1
_DepreciationArea _DepreciationArea 1
_FiscalYear _FiscalYear 1
_FixedAsset _FixedAsset 1
_Ledger _Ledger 1
_LedgerGroup _LedgerGroup 1
_MasterFixedAsset _MasterFixedAsset 1
_PurchasingDocument _PurchasingDocument 1
_SubLedgerAccLineItemType _SubLedgerAccLineItemType 1
AccountingDocCreatedByUser AccountingDocCreatedByUser 1
AccountingDocumentCreationDate AccountingDocumentCreationDate 1
AccountingDocumentItem AccountingDocumentItem 1
AssetAcctTransClassfctn AssetAcctTransClassfctn 1
AssetTransactionType AssetTransactionType 1
AssetValueDate AssetValueDate 1
AssignmentReference AssignmentReference 1
BaseUnit BaseUnit 1
BusinessArea BusinessArea 1
ChartOfDepreciation ChartOfDepreciation 2
CreationTime CreationTime 1
DepreciationFiscalPeriod DepreciationFiscalPeriod 1
DocumentDate DocumentDate 1
DocumentItemText DocumentItemText 1
FinancialAccountType FinancialAccountType 1
Fund Fund 1
GLBusinessTransactionType GLBusinessTransactionType 1
GrantID GrantID 1
GroupFixedAsset GroupFixedAsset 1
GroupMasterFixedAsset GroupMasterFixedAsset 1
IsStatisticalDocument IsStatisticalDocument 1
LedgerFiscalYear LedgerFiscalYear 1
LogicalSystem LogicalSystem 1
PostingDate PostingDate 1
ProfitCenter ProfitCenter 1
PurchasingDocument PurchasingDocument 1
Quantity Quantity 1
ReferenceDocument ReferenceDocument 1
ReferenceDocumentContext ReferenceDocumentContext 1
ReferenceDocumentType ReferenceDocumentType 1
ReversalReferenceDocument ReversalReferenceDocument 1
ReversalTransactionSubitem ReversalTransactionSubitem 1
Segment Segment 1

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 with currency role
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_FXDASTLINEITEMWITHCRCYROLE (
    ACCOUNTINGDOCUMENT,
    ASSETDEPRECIATIONAREA,
    COMPANYCODE,
    DEBITCREDITCODE,
    FISCALPERIOD,
    FISCALYEAR,
    FIXEDASSET,
    LEDGER,
    LEDGERGROUP,
    MASTERFIXEDASSET,
    SUBLEDGERACCTLINEITEMTYPE,
    TRANSACTIONSUBITEM,
    _ASSETACCTTRANSCLASSFCTN,
    _ASSETTRANSACTIONTYPE,
    _CHARTOFDEPRECIATION,
    _COMPANYCODE,
    _DEBITCREDITCODE,
    _DEPRECIATIONAREA,
    _FISCALYEAR,
    _FIXEDASSET,
    _LEDGER,
    _LEDGERGROUP,
    _MASTERFIXEDASSET,
    _PURCHASINGDOCUMENT,
    _SUBLEDGERACCLINEITEMTYPE,
    ACCOUNTINGDOCCREATEDBYUSER,
    ACCOUNTINGDOCUMENTCREATIONDATE,
    ACCOUNTINGDOCUMENTITEM,
    ASSETACCTTRANSCLASSFCTN,
    ASSETTRANSACTIONTYPE,
    ASSETVALUEDATE,
    ASSIGNMENTREFERENCE,
    BASEUNIT,
    BUSINESSAREA,
    CHARTOFDEPRECIATION,
    CREATIONTIME,
    DEPRECIATIONFISCALPERIOD,
    DOCUMENTDATE,
    DOCUMENTITEMTEXT,
    FINANCIALACCOUNTTYPE,
    FUND,
    GLBUSINESSTRANSACTIONTYPE,
    GRANTID,
    GROUPFIXEDASSET,
    GROUPMASTERFIXEDASSET,
    ISSTATISTICALDOCUMENT,
    LEDGERFISCALYEAR,
    LOGICALSYSTEM,
    POSTINGDATE,
    PROFITCENTER,
    PURCHASINGDOCUMENT,
    QUANTITY,
    REFERENCEDOCUMENT,
    REFERENCEDOCUMENTCONTEXT,
    REFERENCEDOCUMENTTYPE,
    REVERSALREFERENCEDOCUMENT,
    REVERSALTRANSACTIONSUBITEM,
    SEGMENT,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, ASSETDEPRECIATIONAREA, COMPANYCODE, DEBITCREDITCODE, FISCALPERIOD, FISCALYEAR, FIXEDASSET, LEDGER, LEDGERGROUP, MASTERFIXEDASSET, SUBLEDGERACCTLINEITEMTYPE, TRANSACTIONSUBITEM)
);

Learn More