I_BR_ImprtFxdAstCrdtAmountItem

DDL: I_BR_IMPRTFXDASTCRDTAMOUNTITEM SQL: IBRIMPFXDASTITM Type: view COMPOSITE Package: GLO_FIN_IS_BR_CRED_CTRL
23 Fields 1 Data Sources 1 Associations

Import Fixed Assets Amount Item

I_BR_ImprtFxdAstCrdtAmountItem is a Composite CDS View that provides data about "Import Fixed Assets Amount Item" in SAP S/4HANA. It reads from 1 data source (P_BR_ImpFxAstCrdAmtItemTblFunc) and exposes 23 fields with key fields CompanyCode, AssetClass, FiscalYear, FiscalPeriod, AssetNumber. It has 1 association to related views. Part of development package GLO_FIN_IS_BR_CRED_CTRL.

Data Sources (1)

SourceAliasJoin Type
P_BR_ImpFxAstCrdAmtItemTblFunc P_BR_ImpFxAstCrdAmtItemTblFunc from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_BR_ImprtFxdAstCrdtAmtItemSts _ImprtFxdAstCrdtAmtItemSts _ImprtFxdAstCrdtAmtItemSts.CompanyCode = $projection.CompanyCode and _ImprtFxdAstCrdtAmtItemSts.AssetClass = $projection.AssetClass and _ImprtFxdAstCrdtAmtItemSts.FiscalYear = $projection.FiscalYear and _ImprtFxdAstCrdtAmtItemSts.FiscalPeriod = $projection.FiscalPeriod and _ImprtFxdAstCrdtAmtItemSts.AssetNumber = $projection.AssetNumber and _ImprtFxdAstCrdtAmtItemSts.AssetSubNumber = $projection.AssetSubNumber

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IBRIMPFXDASTITM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Import Fixed Assets Amount Item view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY AssetClass AssetClass Asset Class
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY FiscalPeriod FiscalPeriod Tax period
KEY AssetNumber AssetNumber Asset
KEY AssetSubNumber AssetSubNumber Sub-number
AssetDescription AssetDescription Description
CostCenter CostCenter Cost Center
BR_PISTaxAmount BR_PISTaxAmount PIS/PASEP Amount
BR_PISTaxRate BR_PISTaxRate PIS/PASEP Tax Rate
BR_COFINSTaxAmount BR_COFINSTaxAmount COFINS Amount
BR_COFINSTaxRate BR_COFINSTaxRate COFINS Tax Rate (%)
BR_CreditSource BR_CreditSource Credit Source
BR_AssetCreditQuotaNumber BR_AssetCreditQuotaNumber Quota Number
BR_AssetUsageStartDate BR_AssetUsageStartDate Start Cred Rec Date
AssetCapitalizationDate AssetCapitalizationDate Asset Capitalization
BR_FixedAssetQuotaStatus BR_FixedAssetQuotaStatus
BR_CreditRecoveryDate BR_CreditRecoveryDate Credit Recovery Date
BR_AstCrdtQtaBaseAmtInRptgCrcy BR_AstCrdtQtaBaseAmtInRptgCrcy Quota Base Amount
Currency Currency Valuation Crcy
CreditControlUUID CreditControlUUID Credit Control UUID
CreatedByUserName _ImprtFxdAstCrdtAmtItemSts CreatedByUserName Person Resp.
ChangeLogUTCDateTime _ImprtFxdAstCrdtAmtItemSts ChangeLogUTCDateTime

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_BR_ImprtFxdAstCrdtAmountItem.
-- 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.
-- SQL view name: IBRIMPFXDASTITM

CREATE VIEW I_BR_ImprtFxdAstCrdtAmountItem AS
SELECT
  CompanyCode,
  AssetClass,
  FiscalYear,
  FiscalPeriod,
  AssetNumber,
  AssetSubNumber,
  AssetDescription,
  CostCenter,
  BR_PISTaxAmount,
  BR_PISTaxRate,
  BR_COFINSTaxAmount,
  BR_COFINSTaxRate,
  BR_CreditSource,
  BR_AssetCreditQuotaNumber,
  BR_AssetUsageStartDate,
  AssetCapitalizationDate,
  BR_FixedAssetQuotaStatus,
  BR_CreditRecoveryDate,
  BR_AstCrdtQtaBaseAmtInRptgCrcy,
  Currency,
  CreditControlUUID,
  _ImprtFxdAstCrdtAmtItemSts.CreatedByUserName AS CreatedByUserName,
  _ImprtFxdAstCrdtAmtItemSts.ChangeLogUTCDateTime AS ChangeLogUTCDateTime
FROM P_BR_ImpFxAstCrdAmtItemTblFunc
LEFT OUTER JOIN I_BR_ImprtFxdAstCrdtAmtItemSts AS _ImprtFxdAstCrdtAmtItemSts ON _ImprtFxdAstCrdtAmtItemSts.CompanyCode = CompanyCode AND _ImprtFxdAstCrdtAmtItemSts.AssetClass = AssetClass AND _ImprtFxdAstCrdtAmtItemSts.FiscalYear = FiscalYear AND _ImprtFxdAstCrdtAmtItemSts.FiscalPeriod = FiscalPeriod AND _ImprtFxdAstCrdtAmtItemSts.AssetNumber = AssetNumber AND _ImprtFxdAstCrdtAmtItemSts.AssetSubNumber = AssetSubNumber  -- association [0..1]
;

Learn More