I_IN_FixedAssetTransaction
CDS view for Fixed Asset Transaction (India)
I_IN_FixedAssetTransaction is a Composite CDS View that provides data about "CDS view for Fixed Asset Transaction (India)" in SAP S/4HANA. It reads from 2 data sources (I_FixedAssetValue, I_IN_TransactionType) and exposes 21 fields.
Data Sources (2)
| Source | Alias | Join Type |
|---|---|---|
| I_FixedAssetValue | I_FixedAssetValue | from |
| I_IN_TransactionType | ttype | inner |
Parameters (1)
| Name | Type | Default |
|---|---|---|
| P_AssetAccountingKeyFigureSet | faa_key_figure_set |
Annotations (11)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | IINFASSETTRANS | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AbapCatalog.preserveKey | true | view | |
| VDM.viewType | #COMPOSITE | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| EndUserText.label | CDS view for Fixed Asset Transaction (India) | view | |
| ObjectModel.usageType.serviceQuality | #D | view | |
| ObjectModel.usageType.sizeCategory | #XXL | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| Metadata.ignorePropagatedAnnotations | true | view |
Fields (21)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| CompanyCode | fav | CompanyCode | ||
| AssetDepreciationArea | fav | AssetDepreciationArea | ||
| MasterFixedAsset | fav | MasterFixedAsset | ||
| FixedAsset | fav | FixedAsset | ||
| AccountingDocument | fav | AccountingDocument | ||
| Ledger | fav | Ledger | ||
| FiscalYear | fav | FiscalYear | ||
| SubLedgerAcctLineItemType | fav | SubLedgerAcctLineItemType | ||
| AssetAcctTransClassfctn | fav | AssetAcctTransClassfctn | ||
| AssetAccountingKeyFigure | fav | AssetAccountingKeyFigure | ||
| ChartOfDepreciation | fav | ChartOfDepreciation | ||
| DocumentDate | fav | DocumentDate | ||
| PostingDate | fav | PostingDate | ||
| AssetValueDate | fav | AssetValueDate | ||
| AmountInCompanyCodeCurrency | fav | AmountInCompanyCodeCurrency | ||
| CompanyCodeCurrency | fav | CompanyCodeCurrency | ||
| AssetCapitalizationDate | fav | AssetCapitalizationDate | ||
| AssetDeactivationDate | fav | AssetDeactivationDate | ||
| PartnerMasterFixedAsset | fav | PartnerMasterFixedAsset | ||
| PartnerFixedAsset | fav | PartnerFixedAsset | ||
| AssetTransactionTypeGroup | I_IN_TransactionType | AssetTransactionTypeGroup |
@AbapCatalog.sqlViewName: 'IINFASSETTRANS'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'CDS view for Fixed Asset Transaction (India)'
@ObjectModel: { usageType.serviceQuality: #D,
usageType.sizeCategory: #XXL,
usageType.dataClass: #MIXED }
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
define view I_IN_FixedAssetTransaction
with parameters
P_AssetAccountingKeyFigureSet : faa_key_figure_set
as select from I_FixedAssetValue(P_AssetAccountingKeyFigureSet: :P_AssetAccountingKeyFigureSet) as fav
inner join I_IN_TransactionType as ttype
on fav.AssetTransactionType = ttype.AssetTransactionType
and fav.AssetAccountingKeyFigureSet = $parameters.P_AssetAccountingKeyFigureSet
{
fav.CompanyCode,
fav.AssetDepreciationArea,
fav.MasterFixedAsset,
fav.FixedAsset,
fav.AccountingDocument,
fav.Ledger,
fav.FiscalYear,
fav.SubLedgerAcctLineItemType,
fav.AssetAcctTransClassfctn,
fav.AssetAccountingKeyFigure,
fav.ChartOfDepreciation,
fav.DocumentDate,
fav.PostingDate,
fav.AssetValueDate,
@Semantics.amount.currencyCode:'CompanyCodeCurrency'
fav.AmountInCompanyCodeCurrency,
fav.CompanyCodeCurrency,
fav.AssetCapitalizationDate,
fav.AssetDeactivationDate,
fav.PartnerMasterFixedAsset,
fav.PartnerFixedAsset,
ttype.AssetTransactionTypeGroup
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_FIXEDASSETVALUE",
"I_IN_TRANSACTIONTYPE"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/
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