I_FixedAssetCompanyCodeLedger
Fixed Asset Company Code Ledger
I_FixedAssetCompanyCodeLedger is a Basic CDS View that provides data about "Fixed Asset Company Code Ledger" in SAP S/4HANA. It reads from 1 data source (faat_cmp_ledger) and exposes 5 fields with key fields CompanyCode, Ledger. Part of development package FINS_FAA_CFG_CMP.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| faat_cmp_ledger | faat_cmp_ledger | from |
Annotations (7)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #NOT_REQUIRED | view | |
| EndUserText.label | Fixed Asset Company Code Ledger | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| ObjectModel.usageType.serviceQuality | #X | view | |
| ObjectModel.usageType.sizeCategory | #S | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| VDM.viewType | #BASIC | view |
Fields (5)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | CompanyCode | comp_code | ||
| KEY | Ledger | ledger | ||
| AssetAcctgLastOpenFiscalYear | ||||
| FixedAssetLedgerPlanningHrzn | plan_horizon | |||
| _FiscalYearVariant | _FiscalYearVariant |
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Fixed Asset Company Code Ledger'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
serviceQuality: #X,
sizeCategory: #S,
dataClass: #MIXED
}
@VDM.viewType: #BASIC
define view entity I_FixedAssetCompanyCodeLedger as select from faat_cmp_ledger
//association[0..1] to I_FiscalYearVariantText as _Text on $projection.FiscalYearVariant = _Text.FiscalYearVariant
// and _Text.Language = $session.system_language
association[0..1] to I_FiscalYearForLedger as _FiscalYearVariant on $projection.CompanyCode = _FiscalYearVariant.CompanyCode
and $projection.Ledger = _FiscalYearVariant.Ledger
and $projection.AssetAcctgLastOpenFiscalYear = _FiscalYearVariant.FiscalYear
{
//key mandt as Mandt,
key comp_code as CompanyCode,
key ledger as Ledger,
cast (current_fisc_year as faa_max_open_fisc_year preserving type) as AssetAcctgLastOpenFiscalYear,
plan_horizon as FixedAssetLedgerPlanningHrzn,
_FiscalYearVariant
}
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA