I_FIXEDASSET

CDS View
78 Fields 28 CDS Views

Fixed Asset

I_FIXEDASSET is a CDS View in S/4HANA. Fixed Asset. It contains 78 fields. 28 CDS views read from this table.

CDS Views using this table (28)

ViewTypeJoinVDMDescription
C_AuCWthMultipleWBSElement view from CONSUMPTION Asset with multiple WBS Elements
C_IntOrdSettlmtRuleFxdAstVH view_entity from CONSUMPTION Internal Order Settlement Rule Fixed Asset
Faa_Anlp view inner Kompatibilitaets-View fuer Tabelle ANLP
FAA_PFixedAssetValueHelp view from
FAC_AUDIT_Z3_ASSET_MASTER view from Asset Master
fac_fixedassetvh view from Value help for fixed asset
FINOC_RULE_FA_BASE view inner Orgl Change: Fixed Asset Base
I_AssetTP view from TRANSACTIONAL Asset
I_FixedAssetEquipment view from BASIC Fixed Asset Equipments
I_FixedAssetFromLegacySystemVH view from COMPOSITE Legacy Asset Value Help
I_FixedAssetStdVH view_entity from COMPOSITE Fixed Asset
I_FixedAssetTaxItem view left_outer COMPOSITE Tax Items for Fixed Asset
I_FixedAssetTP view from TRANSACTIONAL Transactional View Fixed Asset
I_FixedAssetWorklist view from COMPOSITE Interface View for Fixed Asset Worklist
I_FxdAssetByLifeCycleStatusOvw view from COMPOSITE Fixed Assets by Life Cycle Status Overview
I_REFixedAssetRelation view from BASIC Real Estate Relation to Fixed Asset
I_RU_LandTaxItemCube view inner COMPOSITE Russia Land Tax: Cube
I_RU_PropertyTaxItemCube view inner COMPOSITE Russia Property Tax - Cube
P_AUDIT_AT_AssetHistorySheet view left_outer COMPOSITE
P_FixedAssetVH view from COMPOSITE
P_PL_SAFTFixedAssetFields10 view_entity from CONSUMPTION
P_PL_SAFTFixedAssetFields10 view_entity union CONSUMPTION
P_RO_SAFTFixedAsset view_entity from COMPOSITE RO SAFT Fixed Asset Master Data
P_RS_TaxDeprFixedAssetFields view from COMPOSITE
P_RS_TaxDeprFixedAssetFields view union_all COMPOSITE
P_RU_PropertyTaxFixedAsset1 view inner COMPOSITE
P_RU_TransportTaxAssetData view from CONSUMPTION Ru Transport Tax Master data
P_WhereUsdIntOrdFixedAsset view from COMPOSITE

Fields (78)

KeyField CDS FieldsUsed in Views
KEY CompanyCode bukrs,company_code,CompanyCode,CompanyCodeForEdit 9
KEY FixedAsset anln2,asset_subnum,FixedAsset,FixedAssetForEdit 9
KEY MasterFixedAsset anln1,asset_num,MasterFixedAsset,MasterFixedAssetForEdit 9
_AssetAccountDetermination _AssetAccountDetermination 1
_AssetClass _AssetClass 3
_AssetCountryOfOrigin _AssetCountryOfOrigin 1
_AssetStatusAtPurchase _AssetStatusAtPurchase 1
_CompanyCode _CompanyCode 3
_Currency _Currency 1
_FixedAssetPropertyType _FixedAssetPropertyType 1
_InvestmentOrder _InvestmentOrder 2
_InvestmentReason _InvestmentReason 1
_MasterFixedAsset _MasterFixedAsset 3
_PartnerCompany _PartnerCompany 2
_Supplier _Supplier 1
AccountIsBlockedForPosting AccountIsBlockedForPosting 1
AcquisitionValueDate AcquisitionValueDate 1
AreaSizeUnit AreaSizeUnit 1
AssetAccountDetermination AssetAccountDetermination,ktogr 4
AssetAdditionalDescription AssetAdditionalDescription 5
AssetAuthorizationContext AssetAuthorizationContext 3
AssetCapitalizationDate AssetCapitalizationDate 2
AssetClass AssetClass 9
AssetCountryOfOrigin AssetCountryOfOrigin 2
AssetDeactivationDate AssetDeactivationDate 2
AssetIsAcquiredUsed AssetIsAcquiredUsed 1
AssetIsRealEstate AssetIsRealEstate 1
AssetManufacturerName AssetManufacturerName 1
AssetSerialNumber AssetSerialNumber 1
AssetStatusAtPurchase AssetStatusAtPurchase 2
AssetSupplierName AssetSupplierName 2
AssetSynchronizationRule AssetSynchronizationRule 1
AssetTypeName AssetTypeName 2
AssetUnderConstIsInvmtMsr AssetUnderConstIsInvmtMsr 1
BaseUnit BaseUnit 2
CreatedByUser CreatedByUser 3
CreationDate CreationDate 3
Currency Currency 4
EnvrnmtlInvestmentReason EnvrnmtlInvestmentReason 1
FirstAcquisitionFiscalPeriod FirstAcquisitionFiscalPeriod 1
FirstAcquisitionFiscalYear FirstAcquisitionFiscalYear 1
FixedAssetDescription description,FixedAssetDescription 11
FixedAssetExternalID FixedAssetExternalID 2
FixedAssetFinDataCmpltns FixedAssetFinDataCmpltns 1
FixedAssetGroup FixedAssetGroup 1
FixedAssetOrderDate FixedAssetOrderDate 2
FixedAssetPropertyType FixedAssetPropertyType 1
Group1AssetEvaluationKey Group1AssetEvaluationKey 1
Group2AssetEvaluationKey Group2AssetEvaluationKey 1
Group3AssetEvaluationKey Group3AssetEvaluationKey 1
Group4AssetEvaluationKey Group4AssetEvaluationKey 1
Group5AssetEvaluationKey Group5AssetEvaluationKey 1
HasHistory HasHistory 1
InHouseProdnPercent InHouseProdnPercent 1
Inventory Inventory,InventoryNumber 5
InventoryIsCounted InventoryIsCounted 1
InventoryNote InventoryNote 1
InvestmentOrder InvestmentOrder 3
InvestmentProjectWBSElement InvestmentProjectWBSElement 2
InvestmentProjectWBSElement_2 InvestmentProjectWBSElement_2 1
InvestmentReason InvestmentReason 2
LastAssessmentNoticeDate LastAssessmentNoticeDate 1
LastChangedByUser LastChangedByUser 1
LastInventoryDate LastInventoryDate 1
MasterFixedAssetSearchTerm MasterFixedAssetSearchTerm 1
NoticeOfAssessmentTaxID NoticeOfAssessmentTaxID 1
ObjectInternalID ObjectInternalID 1
OriginalAcquisitionAmount OriginalAcquisitionAmount 1
OriginalAcquisitionFiscalYear OriginalAcquisitionFiscalYear 2
OriginalFixedAsset OriginalFixedAsset 2
OriginalFixedAssetValueDate OriginalFixedAssetValueDate 2
OriginalMasterFixedAsset OriginalMasterFixedAsset 2
OriglAcqnAmtInCoCodeCrcy OriglAcqnAmtInCoCodeCrcy 1
PartnerCompany PartnerCompany 3
PlannedRetirementDate PlannedRetirementDate 1
PropertyClass PropertyClass 1
Quantity Quantity 2
Supplier Supplier 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
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_FIXEDASSET (
    COMPANYCODE,
    FIXEDASSET,
    MASTERFIXEDASSET,
    _ASSETACCOUNTDETERMINATION,
    _ASSETCLASS,
    _ASSETCOUNTRYOFORIGIN,
    _ASSETSTATUSATPURCHASE,
    _COMPANYCODE,
    _CURRENCY,
    _FIXEDASSETPROPERTYTYPE,
    _INVESTMENTORDER,
    _INVESTMENTREASON,
    _MASTERFIXEDASSET,
    _PARTNERCOMPANY,
    _SUPPLIER,
    ACCOUNTISBLOCKEDFORPOSTING,
    ACQUISITIONVALUEDATE,
    AREASIZEUNIT,
    ASSETACCOUNTDETERMINATION,
    ASSETADDITIONALDESCRIPTION,
    ASSETAUTHORIZATIONCONTEXT,
    ASSETCAPITALIZATIONDATE,
    ASSETCLASS,
    ASSETCOUNTRYOFORIGIN,
    ASSETDEACTIVATIONDATE,
    ASSETISACQUIREDUSED,
    ASSETISREALESTATE,
    ASSETMANUFACTURERNAME,
    ASSETSERIALNUMBER,
    ASSETSTATUSATPURCHASE,
    ASSETSUPPLIERNAME,
    ASSETSYNCHRONIZATIONRULE,
    ASSETTYPENAME,
    ASSETUNDERCONSTISINVMTMSR,
    BASEUNIT,
    CREATEDBYUSER,
    CREATIONDATE,
    CURRENCY,
    ENVRNMTLINVESTMENTREASON,
    FIRSTACQUISITIONFISCALPERIOD,
    FIRSTACQUISITIONFISCALYEAR,
    FIXEDASSETDESCRIPTION,
    FIXEDASSETEXTERNALID,
    FIXEDASSETFINDATACMPLTNS,
    FIXEDASSETGROUP,
    FIXEDASSETORDERDATE,
    FIXEDASSETPROPERTYTYPE,
    GROUP1ASSETEVALUATIONKEY,
    GROUP2ASSETEVALUATIONKEY,
    GROUP3ASSETEVALUATIONKEY,
    GROUP4ASSETEVALUATIONKEY,
    GROUP5ASSETEVALUATIONKEY,
    HASHISTORY,
    INHOUSEPRODNPERCENT,
    INVENTORY,
    INVENTORYISCOUNTED,
    INVENTORYNOTE,
    INVESTMENTORDER,
    INVESTMENTPROJECTWBSELEMENT,
    INVESTMENTPROJECTWBSELEMENT_2,
    INVESTMENTREASON,
    LASTASSESSMENTNOTICEDATE,
    LASTCHANGEDBYUSER,
    LASTINVENTORYDATE,
    MASTERFIXEDASSETSEARCHTERM,
    NOTICEOFASSESSMENTTAXID,
    OBJECTINTERNALID,
    ORIGINALACQUISITIONAMOUNT,
    ORIGINALACQUISITIONFISCALYEAR,
    ORIGINALFIXEDASSET,
    ORIGINALFIXEDASSETVALUEDATE,
    ORIGINALMASTERFIXEDASSET,
    ORIGLACQNAMTINCOCODECRCY,
    PARTNERCOMPANY,
    PLANNEDRETIREMENTDATE,
    PROPERTYCLASS,
    QUANTITY,
    SUPPLIER,
    PRIMARY KEY (COMPANYCODE, FIXEDASSET, MASTERFIXEDASSET)
);

Learn More