I_FIXEDASSETASSGMT

CDS View
52 Fields 22 CDS Views

Fixed Asset Time Dependent Data

I_FIXEDASSETASSGMT is a CDS View in S/4HANA. Fixed Asset Time Dependent Data. It contains 52 fields. 22 CDS views read from this table.

CDS Views using this table (22)

ViewTypeJoinVDMDescription
C_CN_CADEAssetByPeriod view left_outer CONSUMPTION Asset Assignment by Period for CADE
FAA_M_AANLC view inner Selection view for matchcode ID AANL-C
FAA_PFixedAssetValueHelp view left_outer Fixed Asset
FAC_AUDIT_Z3_ASSET_MASTER view left_outer Asset Master
FINOC_RT_FA_FILL view inner Orgl Change: Fill Runtime for Fixed Asset
I_CN_CADEFixedAssetValueCube view left_outer COMPOSITE Fixed Asset Balance Cube for CADE
I_FixedAssetAssgmtTP view from TRANSACTIONAL Transactional View Fixed Asset Assignments
I_FixedAssetWorklist view inner COMPOSITE Interface View for Fixed Asset Worklist
I_FxdAstAssgmtByFsclPerdEndDte view from COMPOSITE Fixed Asset Assignment valid at fiscal period end date
I_RU_LandTaxItemCube view inner COMPOSITE Russia Land Tax: Cube
I_RU_PropertyTaxItemCube view inner COMPOSITE Russia Property Tax - Cube
I_RU_TransportTaxItemCube view inner COMPOSITE Russia Transport Tax: Cube
P_AssetAssignment view from COMPOSITE Asset Assignment
P_AUDIT_AT_AssetHistorySheet view left_outer COMPOSITE Austrian Audit Asset History Sheet
P_AUDIT_AT_AssetTransaction view left_outer COMPOSITE Austrian Audit Asset Transaction
P_BG_StRpTaxDeprShutdown view from CONSUMPTION Tax depr. plan - shutdowns
P_FuncnlAreaFxdAst view from COMPOSITE WUFAREA Fixed Assets
P_FundFixedAsset view from COMPOSITE WUFUND Fixed Assets
P_GrantFxdAst view from COMPOSITE WUGRANT Fixed Assets
P_StRpFxdAsstLocTransferAssgmt view from CONSUMPTION Fixed Asset Location Transfer Assignment
P_StRpFxdAsstLocTransferAssgmt view inner CONSUMPTION Fixed Asset Location Transfer Assignment
R_FixedAssetAssignmentTP view_entity from TRANSACTIONAL Fixed Asset Assignment

Fields (52)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 4
KEY FixedAsset AssetSubNumber,FixedAsset 5
KEY MasterFixedAsset AssetNumber,MasterFixedAsset 5
KEY ValidityEndDate bdatu,bdatuz,ValidityEndDate 9
_AssetLocation _AssetLocation 3
_BusinessArea _BusinessArea 3
_CompanyCode _CompanyCode 2
_ControllingArea _ControllingArea 3
_CostCenter _CostCenter 4
_CostCenterActivityType _CostCenterActivityType 2
_Employment _Employment 1
_FixedAsset _FixedAsset 1
_FunctionalArea _FunctionalArea 1
_InternalOrder _InternalOrder 2
_MasterFixedAsset _MasterFixedAsset 1
_Plant _Plant 2
_ProfitCenter _ProfitCenter 1
_ResponsibleCostCenter _ResponsibleCostCenter 2
_Segment _Segment 1
AssetAuthorizationContext AssetAuthorizationContext 1
AssetLocation AssetLocation,NewAssetLocation,OldAssetLocation 7
BudgetPeriod BudgetPeriod 5
BusinessArea AssetBusinessArea,BusinessArea,gsber 9
BusinessPlace BusinessPlace 1
ControllingArea ControllingArea 8
CostCenter AssetCostCenter,CostCenter,kostl,NewAssetCostCenter,OldAssetCostCenter 11
CostCtrActivityType CostCtrActivityType 6
FunctionalArea FunctionalArea 5
FunctionalLocation FunctionalLocation 2
Fund Fund 5
FundsCenter FundsCenter 5
GrantID GrantID 5
InternalOrder InternalOrder 6
IsShutDown IsShutDown 4
LogicalSystem LogicalSystem 1
MaintenanceOrder MaintenanceOrder 3
PersonnelNumber PersonnelNumber 4
Plant NewAssetPlant,OldAssetPlant,Plant,werks 9
ProfitCenter prctr,ProfitCenter 6
RealEstateObject RealEstateObject 3
ReferenceDocument ReferenceDocument 2
ReferenceDocumentContext ReferenceDocumentContext 1
ReferenceDocumentType ReferenceDocumentType 1
REInternalFinNumber RealEstateObject,REInternalFinNumber 2
ResponsibleCostCenter ResponsibleCostCenter 5
Room Room 4
Segment Segment 5
ShiftOperationFactor ShiftOperationFactor 2
TaxJurisdiction TaxJurisdiction 5
ValidityStartDate adatu,ValidityStartDate 9
VehicleLicensePlateNumber VehicleLicensePlateNumber 4
WBSElementInternalID_2 WBSElementInternalID 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.

-- Fixed Asset Time Dependent Data
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_FIXEDASSETASSGMT (
    COMPANYCODE,
    FIXEDASSET,
    MASTERFIXEDASSET,
    VALIDITYENDDATE,
    _ASSETLOCATION,
    _BUSINESSAREA,
    _COMPANYCODE,
    _CONTROLLINGAREA,
    _COSTCENTER,
    _COSTCENTERACTIVITYTYPE,
    _EMPLOYMENT,
    _FIXEDASSET,
    _FUNCTIONALAREA,
    _INTERNALORDER,
    _MASTERFIXEDASSET,
    _PLANT,
    _PROFITCENTER,
    _RESPONSIBLECOSTCENTER,
    _SEGMENT,
    ASSETAUTHORIZATIONCONTEXT,
    ASSETLOCATION,
    BUDGETPERIOD,
    BUSINESSAREA,
    BUSINESSPLACE,
    CONTROLLINGAREA,
    COSTCENTER,
    COSTCTRACTIVITYTYPE,
    FUNCTIONALAREA,
    FUNCTIONALLOCATION,
    FUND,
    FUNDSCENTER,
    GRANTID,
    INTERNALORDER,
    ISSHUTDOWN,
    LOGICALSYSTEM,
    MAINTENANCEORDER,
    PERSONNELNUMBER,
    PLANT,
    PROFITCENTER,
    REALESTATEOBJECT,
    REFERENCEDOCUMENT,
    REFERENCEDOCUMENTCONTEXT,
    REFERENCEDOCUMENTTYPE,
    REINTERNALFINNUMBER,
    RESPONSIBLECOSTCENTER,
    ROOM,
    SEGMENT,
    SHIFTOPERATIONFACTOR,
    TAXJURISDICTION,
    VALIDITYSTARTDATE,
    VEHICLELICENSEPLATENUMBER,
    WBSELEMENTINTERNALID_2,
    PRIMARY KEY (COMPANYCODE, FIXEDASSET, MASTERFIXEDASSET, VALIDITYENDDATE)
);

Learn More