What is I_FixedAssetCountryData in SAP S/4HANA?

I_FixedAssetCountryData is a basic CDS view in SAP S/4HANA. Country/Region Specific Fixed Asset It contains 48 fields.

Which tables does I_FixedAssetCountryData read from?

I_FixedAssetCountryData reads data from: P_FixedAssetCountryData.

What VDM layer is I_FixedAssetCountryData?

I_FixedAssetCountryData is classified as a Basic (interface) view providing a 1:1 representation of a database table.

I_FixedAssetCountryData

DDL: I_FIXEDASSETCOUNTRYDATA Type: view BASIC

48 Fields 1 Data Sources 3 Associations

Country/Region Specific Fixed Asset

I_FixedAssetCountryData (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Fixed Asset · Accounting and Financial Close

I_FixedAssetCountryData is a Basic CDS View (Dimension) that provides data about "Country/Region Specific Fixed Asset" in SAP S/4HANA. It reads from 1 data source (P_FixedAssetCountryData) and exposes 48 fields with key fields CompanyCode, MasterFixedAsset, FixedAsset. It has 3 associations to related views.

SAP Help Documentation

Category	CDS Views for Master Data
Data Category	Dimension
Status	Released

Purpose
This CDS view provides access to the country-dependent master data of a fixed asset. The country-dependent attributes of the fixed asset business entity provide dimensions of the following countries: India Israel Japan Portugal Russia This CDS view provides the prerequisites for answering the following business questions: What is the country-dependent data of my fixed assets? What are the national classification codes of my fixed assets?

Prerequisites
You have the authorization for the following authorization objects: F_BKPF_BUK

Structure
Measures and attributes Some important measures and attributes are: Country National Classification Tax Depreciation Group

View on SAP Help Portal →

SAP API Hub

State	C1
Line of Business	Accounting and Financial Close
Application Component	FI-AA-IS
Capabilities	Analytical Dimension, Data Source for Defining CDS Entities, Association Target for Defining CDS Entities, Data Source in SQL Select
Package	Accounting and Financial Close for SAP S/4HANA Cloud Private Edition
Description	This CDS view provides access to the country-dependent master data of a fixed asset. The country-dependent attributes of the fixed asset business entity provide dimensions of the following countries: <ul> <li><p>India</p></li> </ul> <ul> <li><p>Israel</p></li> </ul> <ul> <li><p>Japan</p></li> </ul> <ul> <li><p>Portugal</p></li> </ul> <ul> <li><p>Russia</p></li> </ul> <p>This CDS view provides the prerequisites for answering the following business questions:</p> <ul> <li><p>What is the country-dependent data of my fixed assets?</p></li> <li><p>What are the national classification codes of my fixed assets?</p></li> </ul>

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Private Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Private Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Private Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP Extensibility Explorer for SAP S/4HANA Cloud Private Edition — Explore SAP S/4HANA Cloud Private Edition Extensibility options by leveraging the sample scenarios from SAP
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Private Edition
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
P_FixedAssetCountryData	P_FixedAssetCountryData	from

Associations (3)

Cardinality	Target	Alias	Condition
[0..1]	I_CompanyCode	_CompanyCode	`$projection.CompanyCode = _CompanyCode.CompanyCode`
[0..1]	I_Country	_Country	`$projection.Country = _Country.Country`
[0..1]	I_MasterFixedAsset	_MasterFixedAsset	`$projection.CompanyCode = _MasterFixedAsset.CompanyCode and $projection.MasterFixedAsset = _MasterFixedAsset.MasterFixedAsset`

Annotations (14)

Name	Value	Level
AbapCatalog.sqlViewName	IFIASTCNTRYDATA	view
AbapCatalog.preserveKey	true	view
Analytics.dataCategory	#DIMENSION	view
Analytics.dataExtraction.enabled	true	view
EndUserText.label	Country/Region Specific Fixed Asset	view
VDM.viewType	#BASIC	view
AccessControl.authorizationCheck	#CHECK	view
ObjectModel.representativeKey	FixedAsset	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.dataClass	#MASTER	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
Metadata.ignorePropagatedAnnotations	true	view
Metadata.allowExtensions	true	view

Fields (48)

Key	Field	Source Field	Description
KEY	CompanyCode	CompanyCode	Receiver Company Code
KEY	MasterFixedAsset	MasterFixedAsset	Main Asset Number
KEY	FixedAsset	FixedAsset	Asset Subnumber
	NationalClassification	NationalClassification	National Classification Code
	TaxDepreciationGroup	TaxDepreciationGroup	Tax Depreciation Group
	RU_LongSerialNumber	RU_LongSerialNumber	Russia: Serial Number
	RU_WorkwearMaterial	RU_WorkwearMaterial	Material Number
	RU_RetiredMasterFixedAsset	RU_RetiredMasterFixedAsset	Number of Retired Asset
	RU_RetiredFixedAsset	RU_RetiredFixedAsset	Subnumber of Retired Asset
	RU_ProdTraceabilityStartDate	RU_ProdTraceabilityStartDate	Start date of traceability
	RU_ProdTraceabilityEndDate	RU_ProdTraceabilityEndDate	End date of traceability
	RU_AssetTNVED	RU_AssetTNVED	Foreign Trade Goods Classification Code of the Customs Union
	RU_AssetTransportType	RU_AssetTransportType	Transport Type
	RU_VehicleIdNumber	RU_VehicleIdNumber	Manufacturer Vehicle Identification Number for Fleet Object
	RU_ManufacturingDate	RU_ManufacturingDate	Manufacturing Date
	RU_VehicleEcologicalClass	RU_VehicleEcologicalClass	Ecological Class
	RU_PropertyAddress	RU_PropertyAddress	Russia: Property Address
	RU_PropertyOwnershipRegnDate	RU_PropertyOwnershipRegnDate	Registration Date of Real Estate Ownership Rights
	RU_PropertyOwnershipTermnDate	RU_PropertyOwnershipTermnDate	Termination Date of Real Estate Ownership Rights
	JP_Annex16AssetStructure	JP_Annex16AssetStructure	Japan: Asset Structure of Annex16
	JP_Annex16AssetItem	JP_Annex16AssetItem	Japan: Asset Item of Annex16
	JP_Annex16LeasingAgrmtDate	JP_Annex16LeasingAgrmtDate	Japan: Leasing Agreement Date of Annex16-4 Report
	JP_PrptyTxRptCity	JP_PrptyTxRptCity	Japan: City Code of Property Tax Report
	JP_PrptyTxRptClassfctnKey	JP_PrptyTxRptClassfctnKey	Japan: Classification Key of Property Tax Report
	JP_PrptyTxRptSpclDepr	JP_PrptyTxRptSpclDepr	Japan: Special Depreciation Code of Property Tax Report
	JP_PrptyTxRptAddlDepr	JP_PrptyTxRptAddlDepr	Additional Depreciation Code
	IN_AssetBlock	IN_AssetBlock	India: Block Key
	IN_AssetPutToUseDate	IN_AssetPutToUseDate	India: Put to use date
	IN_AdditionalAssetBlock	IN_AdditionalAssetBlock	India: Additional Depreciation Block Key
	IN_AssetIsResearchAndDev	IN_AssetIsResearchAndDev	India: R & D Asset
	IN_AssetIsPriorYear	IN_AssetIsPriorYear	India: Prior Year Transaction
	PT_VehicleTypeByEnergy	PT_VehicleTypeByEnergy	Portugal: Vehicle Type
	PT_VehicleIsWithoutLimit	PT_VehicleIsWithoutLimit	Portugal: Is Vehicle Without Limit
	PT_BigRepairAssetLink	PT_BigRepairAssetLink	Portugal: Repair Asset Link
	PT_LandAssetLink	PT_LandAssetLink	Portugal: Land Asset Link
	PT_AssetReportFormCategory	PT_AssetReportFormCategory	Portugal: Asset Report Form Category
	PT_AmortizedAssetIsReevaluated	PT_AmortizedAssetIsReevaluated	Portugal: Is Amortized Asset Revaluated
	IL_InvmtCtrInternalCode	IL_InvmtCtrInternalCode	Israel: Internal code
	IL_InvmtCtrApprovalDocNmbr	IL_InvmtCtrApprovalDocNmbr	Israel: Approval document number
	IL_InvmtCtrApprovalVersion	IL_InvmtCtrApprovalVersion	Israel: Approval version
	IL_InvmtCtrBogusAssetNumber	IL_InvmtCtrBogusAssetNumber	Israel: Bogus asset number
	IL_InvmtCtrAssetVersion	IL_InvmtCtrAssetVersion	Israel: Asset version
	RS_GroupDeprExclusionYear	RS_GroupDeprExclusionYear	Exclusion Year
	RS_AssetLastInvoiceDate	RS_AssetLastInvoiceDate	Last Invoice Date
	Country	Country	Country/Region Key
	_CompanyCode	_CompanyCode
	_Country	_Country
	_MasterFixedAsset	_MasterFixedAsset

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_FixedAssetCountryData.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_FixedAssetCountryData AS
SELECT
  CompanyCode,
  MasterFixedAsset,
  FixedAsset,
  NationalClassification,
  TaxDepreciationGroup,
  RU_LongSerialNumber,
  RU_WorkwearMaterial,
  RU_RetiredMasterFixedAsset,
  RU_RetiredFixedAsset,
  RU_ProdTraceabilityStartDate,
  RU_ProdTraceabilityEndDate,
  RU_AssetTNVED,
  RU_AssetTransportType,
  RU_VehicleIdNumber,
  RU_ManufacturingDate,
  RU_VehicleEcologicalClass,
  RU_PropertyAddress,
  RU_PropertyOwnershipRegnDate,
  RU_PropertyOwnershipTermnDate,
  JP_Annex16AssetStructure,
  JP_Annex16AssetItem,
  JP_Annex16LeasingAgrmtDate,
  JP_PrptyTxRptCity,
  JP_PrptyTxRptClassfctnKey,
  JP_PrptyTxRptSpclDepr,
  JP_PrptyTxRptAddlDepr,
  IN_AssetBlock,
  IN_AssetPutToUseDate,
  IN_AdditionalAssetBlock,
  IN_AssetIsResearchAndDev,
  IN_AssetIsPriorYear,
  PT_VehicleTypeByEnergy,
  PT_VehicleIsWithoutLimit,
  PT_BigRepairAssetLink,
  PT_LandAssetLink,
  PT_AssetReportFormCategory,
  PT_AmortizedAssetIsReevaluated,
  IL_InvmtCtrInternalCode,
  IL_InvmtCtrApprovalDocNmbr,
  IL_InvmtCtrApprovalVersion,
  IL_InvmtCtrBogusAssetNumber,
  IL_InvmtCtrAssetVersion,
  RS_GroupDeprExclusionYear,
  RS_AssetLastInvoiceDate,
  Country
FROM P_FixedAssetCountryData
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Country AS _Country ON Country = _Country.Country  -- association [0..1]
LEFT OUTER JOIN I_MasterFixedAsset AS _MasterFixedAsset ON CompanyCode = _MasterFixedAsset.CompanyCode AND MasterFixedAsset = _MasterFixedAsset.MasterFixedAsset  -- association [0..1]
;

Depth:

I_FixedAssetCountryData view

P_FixedAssetCountryData view

I_GlobAssetTP view
P_RU_FixedAssetCountryData view