P_FixedAssetValueWthDetn

DDL: P_FIXEDASSETVALUEWTHDETN Type: view COMPOSITE

P_FixedAssetValueWthDetn is a Composite CDS View in SAP S/4HANA. It reads from 3 data sources (I_AssetKeyFigureTransTypeDetn, I_FixedAssetLineItem, I_FixedAssetPlanValue) and exposes 192 fields with key fields AssetDepreciationArea, CompanyCode, FiscalYear, MasterFixedAsset, FixedAsset. It has 1 association to related views.

3 data source(s) 192 fields

Data Sources (3)

SourceAliasJoin Type
I_AssetKeyFigureTransTypeDetn determination left_outer
I_FixedAssetLineItem lineitems from
I_FixedAssetPlanValue planvalues union_all

Parameters (1)

NameTypeDefault
P_AssetAccountingKeyFigureSet faa_key_figure_set

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_FixedAssetForLedger _FixedAssetForLedger _FixedAssetForLedger.CompanyCode = $projection.CompanyCode and _FixedAssetForLedger.MasterFixedAsset = $projection.MasterFixedAsset and _FixedAssetForLedger.FixedAsset = $projection.FixedAsset and _FixedAssetForLedger.Ledger = $projection.Ledger

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PFASSETVALDTN view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.buffering.status #NOT_ALLOWED view
Metadata.ignorePropagatedAnnotations true view

Fields (192)

KeyFieldSource TableSource FieldDescription
KEY AssetDepreciationArea I_FixedAssetLineItem AssetDepreciationArea
KEY CompanyCode I_FixedAssetLineItem CompanyCode
KEY FiscalYear I_FixedAssetLineItem FiscalYear
KEY MasterFixedAsset I_FixedAssetLineItem MasterFixedAsset
KEY FixedAsset I_FixedAssetLineItem FixedAsset
KEY AccountingDocument I_FixedAssetLineItem AccountingDocument
KEY TransactionSubitem I_FixedAssetLineItem TransactionSubitem
KEY Ledger I_FixedAssetLineItem Ledger
KEY FiscalPeriod I_FixedAssetLineItem FiscalPeriod
KEY SubLedgerAcctLineItemType I_FixedAssetLineItem SubLedgerAcctLineItemType
KEY AssetAcctTransClassfctn I_FixedAssetLineItem AssetAcctTransClassfctn
KEY DebitCreditCode DebitCreditCode
LedgerFiscalYear LedgerFiscalYear
FiscalYearVariant FiscalYearVariant
FiscalYearPeriod FiscalYearPeriod
DepreciationFiscalPeriod DepreciationFiscalPeriod
LedgerGroup I_FixedAssetLineItem LedgerGroup
ChartOfAccounts I_FixedAssetLineItem ChartOfAccounts
CountryChartOfAccounts I_FixedAssetLineItem CountryChartOfAccounts
GLAccount I_FixedAssetLineItem GLAccount
AlternativeGLAccount I_FixedAssetLineItem AlternativeGLAccount
GroupMasterFixedAsset I_FixedAssetLineItem GroupMasterFixedAsset
GroupFixedAsset I_FixedAssetLineItem GroupFixedAsset
FinancialAccountType I_FixedAssetLineItem FinancialAccountType
ChartOfDepreciation I_FixedAssetLineItem ChartOfDepreciation
AccountingDocumentCreationDate I_FixedAssetLineItem AccountingDocumentCreationDate
CreationTime I_FixedAssetLineItem CreationTime
AccountingDocCreatedByUser I_FixedAssetLineItem AccountingDocCreatedByUser
JointVentureCostRecoveryCode I_FixedAssetLineItem JointVentureCostRecoveryCode
CostCenter I_FixedAssetLineItem CostCenter
Plant I_FixedAssetLineItem Plant
BusinessArea I_FixedAssetLineItem BusinessArea
PersonnelNumber I_FixedAssetLineItem PersonnelNumber
FinancialManagementArea I_FixedAssetLineItem FinancialManagementArea
Fund I_FixedAssetLineItem Fund
GrantID I_FixedAssetLineItem GrantID
FunctionalArea I_FixedAssetLineItem FunctionalArea
BudgetPeriod I_FixedAssetLineItem BudgetPeriod
ProfitCenter I_FixedAssetLineItem ProfitCenter
Segment I_FixedAssetLineItem Segment
FundsCenter I_FixedAssetLineItem FundsCenter
AssetTransactionType I_FixedAssetLineItem AssetTransactionType
AssetDeactivationDate _FixedAssetForLedger AssetDeactivationDate
ReferenceDocumentItem I_FixedAssetLineItem ReferenceDocumentItem
ReferenceDocumentType I_FixedAssetLineItem ReferenceDocumentType
LogicalSystem I_FixedAssetLineItem LogicalSystem
ReferenceDocument I_FixedAssetLineItem ReferenceDocument
ReferenceDocumentContext I_FixedAssetLineItem ReferenceDocumentContext
ReversalReferenceDocument I_FixedAssetLineItem ReversalReferenceDocument
ReversalReferenceDocumentCntxt I_FixedAssetLineItem ReversalReferenceDocumentCntxt
ReversalTransactionSubitem I_FixedAssetLineItem ReversalTransactionSubitem
IsReversal I_FixedAssetLineItem IsReversal
IsReversed I_FixedAssetLineItem IsReversed
DocumentDate I_FixedAssetLineItem DocumentDate
PostingDate I_FixedAssetLineItem PostingDate
AssetValueDate I_FixedAssetLineItem AssetValueDate
AccountingDocumentType I_FixedAssetLineItem AccountingDocumentType
AssignmentReference I_FixedAssetLineItem AssignmentReference
DocumentItemText I_FixedAssetLineItem DocumentItemText
IsStatisticalDocument I_FixedAssetLineItem IsStatisticalDocument
GLBusinessTransactionType I_FixedAssetLineItem GLBusinessTransactionType
PartnerMasterFixedAsset I_FixedAssetLineItem PartnerMasterFixedAsset
PartnerFixedAsset I_FixedAssetLineItem PartnerFixedAsset
CompanyCodeCurrency I_FixedAssetLineItem CompanyCodeCurrency
GlobalCurrency I_FixedAssetLineItem GlobalCurrency
FreeDefinedCurrency1 I_FixedAssetLineItem FreeDefinedCurrency1
FreeDefinedCurrency2 I_FixedAssetLineItem FreeDefinedCurrency2
FreeDefinedCurrency3 I_FixedAssetLineItem FreeDefinedCurrency3
FreeDefinedCurrency4 I_FixedAssetLineItem FreeDefinedCurrency4
FreeDefinedCurrency5 I_FixedAssetLineItem FreeDefinedCurrency5
FreeDefinedCurrency6 I_FixedAssetLineItem FreeDefinedCurrency6
FreeDefinedCurrency7 I_FixedAssetLineItem FreeDefinedCurrency7
FreeDefinedCurrency8 I_FixedAssetLineItem FreeDefinedCurrency8
ActualAmountInCompanyCodeCrcy
ActualAmountInGlobalCurrency
ActualAmountInFreeDfndCrcy1
ActualAmountInFreeDfndCrcy2
ActualAmountInFreeDfndCrcy3
ActualAmountInFreeDfndCrcy4
ActualAmountInFreeDfndCrcy5
ActualAmountInFreeDfndCrcy6
ActualAmountInFreeDfndCrcy7
ActualAmountInFreeDfndCrcy8
PlanAmountInCompanyCodeCrcy
PlanAmountInGlobalCurrency
PlanAmountInFreeDefinedCrcy1
PlanAmountInFreeDefinedCrcy2
PlanAmountInFreeDefinedCrcy3
PlanAmountInFreeDefinedCrcy4
PlanAmountInFreeDefinedCrcy5
PlanAmountInFreeDefinedCrcy6
PlanAmountInFreeDefinedCrcy7
PlanAmountInFreeDefinedCrcy8
BaseUnit BaseUnit
Quantity Quantity
AssetDepreciationArea
KEY CompanyCode I_FixedAssetPlanValue CompanyCode
KEY FiscalYear I_FixedAssetPlanValue FiscalYear
KEY MasterFixedAsset I_FixedAssetPlanValue MasterFixedAsset
KEY FixedAsset I_FixedAssetPlanValue FixedAsset
KEY AccountingDocument
KEY TransactionSubitem
KEY Ledger I_FixedAssetPlanValue Ledger
KEY FiscalPeriod I_FixedAssetPlanValue FiscalPeriod
KEY SubLedgerAcctLineItemType I_FixedAssetPlanValue SubLedgerAcctLineItemType
KEY AssetAcctTransClassfctn I_FixedAssetPlanValue AssetAcctTransClassfctn
KEY DebitCreditCode
LedgerFiscalYear
FiscalYearVariant
FiscalYearPeriod
DepreciationFiscalPeriod I_FixedAssetPlanValue FiscalPeriod
AssetAcctAnlytlTransClassfctn I_FixedAssetPlanValue AssetAcctTransClassfctn
LedgerGroup I_FixedAssetPlanValue LedgerGroup
ChartOfAccounts
CountryChartOfAccounts
GLAccount
AlternativeGLAccount
GroupMasterFixedAsset I_FixedAssetPlanValue GroupMasterFixedAsset
GroupFixedAsset I_FixedAssetPlanValue GroupFixedAsset
FinancialAccountType I_FixedAssetPlanValue FinancialAccountType
ChartOfDepreciation I_FixedAssetPlanValue ChartOfDepreciation
AccountingDocumentCreationDate
CreationTime
AccountingDocCreatedByUser
JointVentureCostRecoveryCode I_FixedAssetPlanValue JointVentureCostRecoveryCode
CostCenter
Plant
BusinessArea
PersonnelNumber
FinancialManagementArea
Fund
GrantID
FunctionalArea
BudgetPeriod
ProfitCenter
Segment
FundsCenter
AssetTransactionType
AssetDeactivationDate _FixedAssetForLedger AssetDeactivationDate
ReferenceDocumentItem
ReferenceDocumentType
LogicalSystem
ReferenceDocument
ReferenceDocumentContext
ReversalReferenceDocument
ReversalReferenceDocumentCntxt
ReversalTransactionSubitem
IsReversal
IsReversed
DocumentDate
PostingDate
AssetValueDate
AccountingDocumentType
AssignmentReference
DocumentItemText
IsStatisticalDocument
GLBusinessTransactionType
PartnerMasterFixedAsset
PartnerFixedAsset
CompanyCodeCurrency I_FixedAssetPlanValue CompanyCodeCurrency
GlobalCurrency I_FixedAssetPlanValue GlobalCurrency
FreeDefinedCurrency1 I_FixedAssetPlanValue FreeDefinedCurrency1
FreeDefinedCurrency2 I_FixedAssetPlanValue FreeDefinedCurrency2
FreeDefinedCurrency3 I_FixedAssetPlanValue FreeDefinedCurrency3
FreeDefinedCurrency4 I_FixedAssetPlanValue FreeDefinedCurrency4
FreeDefinedCurrency5 I_FixedAssetPlanValue FreeDefinedCurrency5
FreeDefinedCurrency6 I_FixedAssetPlanValue FreeDefinedCurrency6
FreeDefinedCurrency7 I_FixedAssetPlanValue FreeDefinedCurrency7
FreeDefinedCurrency8 I_FixedAssetPlanValue FreeDefinedCurrency8
ActualAmountInCompanyCodeCrcy
ActualAmountInGlobalCurrency
ActualAmountInFreeDfndCrcy1
ActualAmountInFreeDfndCrcy2
ActualAmountInFreeDfndCrcy3
ActualAmountInFreeDfndCrcy4
ActualAmountInFreeDfndCrcy5
ActualAmountInFreeDfndCrcy6
ActualAmountInFreeDfndCrcy7
ActualAmountInFreeDfndCrcy8
PlanAmountInCompanyCodeCrcy
PlanAmountInGlobalCurrency
PlanAmountInFreeDefinedCrcy1
PlanAmountInFreeDefinedCrcy2
PlanAmountInFreeDefinedCrcy3
PlanAmountInFreeDefinedCrcy4
PlanAmountInFreeDefinedCrcy5
PlanAmountInFreeDefinedCrcy6
PlanAmountInFreeDefinedCrcy7
PlanAmountInFreeDefinedCrcy8
BaseUnit
Quantity
IsPlanningDocument 
@AbapCatalog: {sqlViewName: 'PFASSETVALDTN', preserveKey: true}
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@VDM.private:true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.buffering.status: #NOT_ALLOWED
@Metadata.ignorePropagatedAnnotations: true

define view P_FixedAssetValueWthDetn
  with parameters
    P_AssetAccountingKeyFigureSet : faa_key_figure_set

  as select from    I_FixedAssetLineItem          as lineitems
    left outer join I_AssetKeyFigureTransTypeDetn as determination on  determination.AssetAccountingKeyFigureSet = :P_AssetAccountingKeyFigureSet
                                                                   and determination.AssetTransactionType        = lineitems.AssetTransactionType

  association [0..1] to I_FixedAssetForLedger as _FixedAssetForLedger on  _FixedAssetForLedger.CompanyCode      = $projection.CompanyCode
                                                                      and _FixedAssetForLedger.MasterFixedAsset = $projection.MasterFixedAsset
                                                                      and _FixedAssetForLedger.FixedAsset       = $projection.FixedAsset
                                                                      and _FixedAssetForLedger.Ledger           = $projection.Ledger
{

  key lineitems.AssetDepreciationArea,
  key lineitems.CompanyCode,
  key lineitems.FiscalYear,
  key lineitems.MasterFixedAsset,
  key lineitems.FixedAsset,
  key lineitems.AccountingDocument,
  key lineitems.TransactionSubitem,
  key lineitems.Ledger,
  key lineitems.FiscalPeriod,
  key lineitems.SubLedgerAcctLineItemType,
  key lineitems.AssetAcctTransClassfctn,
  key DebitCreditCode,

      LedgerFiscalYear,
      FiscalYearVariant,
      FiscalYearPeriod,
      DepreciationFiscalPeriod,

      case when determination.AssetTransactionType is not null
        then determination.AssetAcctAnlytlTransClassfctn
      else
        lineitems.AssetAcctTransClassfctn
      end                                                          as AssetAcctAnlytlTransClassfctn,

      lineitems.LedgerGroup,
      lineitems.ChartOfAccounts,
      lineitems.CountryChartOfAccounts,
      lineitems.GLAccount,
      lineitems.AlternativeGLAccount,
      lineitems.GroupMasterFixedAsset,
      lineitems.GroupFixedAsset,
      lineitems.FinancialAccountType,
      lineitems.ChartOfDepreciation,

      lineitems.AccountingDocumentCreationDate,
      lineitems.CreationTime,
      lineitems.AccountingDocCreatedByUser,
      lineitems.JointVentureCostRecoveryCode,
      lineitems.CostCenter,
      lineitems.Plant,
      lineitems.BusinessArea,
      lineitems.PersonnelNumber,
      lineitems.FinancialManagementArea,
      lineitems.Fund,
      lineitems.GrantID,
      lineitems.FunctionalArea,
      lineitems.BudgetPeriod,
      lineitems.ProfitCenter,
      lineitems.Segment,
      lineitems.FundsCenter,
      lineitems.AssetTransactionType,

      /* Dedicated properties which moved with the redesign of the asset master from ANLA to FAAT_MD_LD */
      /* -> I_FixedAssetForLedger selects based on the business function from the correct table         */
      _FixedAssetForLedger.AssetDeactivationDate,

      lineitems.ReferenceDocumentItem,
      lineitems.ReferenceDocumentType,
      lineitems.LogicalSystem,
      lineitems.ReferenceDocument,
      lineitems.ReferenceDocumentContext,
      lineitems.ReversalReferenceDocument,
      lineitems.ReversalReferenceDocumentCntxt,
      lineitems.ReversalTransactionSubitem,
      lineitems.IsReversal,
      lineitems.IsReversed,
      lineitems.DocumentDate,
      lineitems.PostingDate,
      lineitems.AssetValueDate,
      lineitems.AccountingDocumentType,
      lineitems.AssignmentReference,
      lineitems.DocumentItemText,
      lineitems.IsStatisticalDocument,
      lineitems.GLBusinessTransactionType,
      lineitems.PartnerMasterFixedAsset,
      lineitems.PartnerFixedAsset,

      @Semantics.currencyCode:true
      lineitems.CompanyCodeCurrency,
      @Semantics.currencyCode:true
      lineitems.GlobalCurrency,
      @Semantics.currencyCode:true
      lineitems.FreeDefinedCurrency1,
      @Semantics.currencyCode:true
      lineitems.FreeDefinedCurrency2,
      @Semantics.currencyCode:true
      lineitems.FreeDefinedCurrency3,
      @Semantics.currencyCode:true
      lineitems.FreeDefinedCurrency4,
      @Semantics.currencyCode:true
      lineitems.FreeDefinedCurrency5,
      @Semantics.currencyCode:true
      lineitems.FreeDefinedCurrency6,
      @Semantics.currencyCode:true
      lineitems.FreeDefinedCurrency7,
      @Semantics.currencyCode:true
      lineitems.FreeDefinedCurrency8,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
      cast(lineitems.AmountInCompanyCodeCurrency as fins_vhcur12)  as ActualAmountInCompanyCodeCrcy,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
      cast(lineitems.AmountInGlobalCurrency as fins_vhcur12)       as ActualAmountInGlobalCurrency,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }
      cast(lineitems.AmountInFreeDefinedCurrency1 as fins_vhcur12) as ActualAmountInFreeDfndCrcy1,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }
      cast(lineitems.AmountInFreeDefinedCurrency2 as fins_vhcur12) as ActualAmountInFreeDfndCrcy2,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }
      cast(lineitems.AmountInFreeDefinedCurrency3 as fins_vhcur12) as ActualAmountInFreeDfndCrcy3,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }
      cast(lineitems.AmountInFreeDefinedCurrency4 as fins_vhcur12) as ActualAmountInFreeDfndCrcy4,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }
      cast(lineitems.AmountInFreeDefinedCurrency5 as fins_vhcur12) as ActualAmountInFreeDfndCrcy5,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }
      cast(lineitems.AmountInFreeDefinedCurrency6 as fins_vhcur12) as ActualAmountInFreeDfndCrcy6,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }
      cast(lineitems.AmountInFreeDefinedCurrency7 as fins_vhcur12) as ActualAmountInFreeDfndCrcy7,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }
      cast(lineitems.AmountInFreeDefinedCurrency8 as fins_vhcur12) as ActualAmountInFreeDfndCrcy8,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
      cast('0' as fins_vhcur12)                                    as PlanAmountInCompanyCodeCrcy,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
      cast('0' as fins_vhcur12)                                    as PlanAmountInGlobalCurrency,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }
      cast('0' as fins_vhcur12)                                    as PlanAmountInFreeDefinedCrcy1,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }
      cast('0' as fins_vhcur12)                                    as PlanAmountInFreeDefinedCrcy2,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }
      cast('0' as fins_vhcur12)                                    as PlanAmountInFreeDefinedCrcy3,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }
      cast('0' as fins_vhcur12)                                    as PlanAmountInFreeDefinedCrcy4,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }
      cast('0' as fins_vhcur12)                                    as PlanAmountInFreeDefinedCrcy5,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }
      cast('0' as fins_vhcur12)                                    as PlanAmountInFreeDefinedCrcy6,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }
      cast('0' as fins_vhcur12)                                    as PlanAmountInFreeDefinedCrcy7,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }
      cast('0' as fins_vhcur12)                                    as PlanAmountInFreeDefinedCrcy8,

      @Semantics.unitOfMeasure:true
      BaseUnit,
      @DefaultAggregation: #SUM
      @Semantics: { quantity : {unitOfMeasure: 'BaseUnit'} }
      Quantity,

      cast ('' as boolean)                                         as IsPlanningDocument

}


union all select from I_FixedAssetPlanValue as planvalues

association [0..1] to I_FixedAssetForLedger as _FixedAssetForLedger on  _FixedAssetForLedger.CompanyCode      = $projection.CompanyCode
                                                                    and _FixedAssetForLedger.MasterFixedAsset = $projection.MasterFixedAsset
                                                                    and _FixedAssetForLedger.FixedAsset       = $projection.FixedAsset
                                                                    and _FixedAssetForLedger.Ledger           = $projection.Ledger
{

  key    planvalues.AssetDepreciationArea,
  key    planvalues.CompanyCode,
  key    planvalues.FiscalYear,
  key    planvalues.MasterFixedAsset,
  key    planvalues.FixedAsset,
  key    cast('' as belnr_d)                                           as AccountingDocument,
  key    cast('' as fins_subta)                                        as TransactionSubitem,
  key    planvalues.Ledger,
  key    planvalues.FiscalPeriod,
  key    planvalues.SubLedgerAcctLineItemType,
  key    planvalues.AssetAcctTransClassfctn,
  key    cast('' as shkzg)                                             as DebitCreditCode,

         cast('0000' as gjahr_pos)                                     as LedgerFiscalYear,
         cast('' as periv )                                            as FiscalYearVariant,
         cast('0000000' as jahrper)                                    as FiscalYearPeriod,
         planvalues.FiscalPeriod                                       as DepreciationFiscalPeriod,

         planvalues.AssetAcctTransClassfctn                            as AssetAcctAnlytlTransClassfctn,
         planvalues.LedgerGroup,
         cast('' as ktopl)                                             as ChartOfAccounts,
         cast('' as ktop2)                                             as CountryChartOfAccounts,
         cast('' as fagl_hkont)                                        as GLAccount,
         cast('' as  fis_altkt_skb1)                                   as AlternativeGLAccount,
         planvalues.GroupMasterFixedAsset,
         planvalues.GroupFixedAsset,
         planvalues.FinancialAccountType,
         planvalues.ChartOfDepreciation,

         cast('00000000' as fis_cpudt)                                 as AccountingDocumentCreationDate,
         cast('000000' as fis_cputm)                                   as CreationTime,
         cast('' as fis_usnam)                                         as AccountingDocCreatedByUser,
         planvalues.JointVentureCostRecoveryCode,
         cast('' as kostl)                                             as CostCenter,
         cast('' as werks_d)                                           as Plant,
         cast('' as gsber)                                             as BusinessArea,
         cast('' as pernr_d)                                           as PersonnelNumber,
         cast('' as fikrs)                                             as FinancialManagementArea,
         cast('' as bp_geber)                                          as Fund,
         cast('' as gm_grant_nbr)                                      as GrantID,
         cast('' as fm_farea)                                          as FunctionalArea,
         cast('' as fm_budget_period)                                  as BudgetPeriod,
         cast('' as prctr)                                             as ProfitCenter,
         cast('' as fb_segment)                                        as Segment,
         cast('' as fistl)                                             as FundsCenter,
         cast('' as bwasl)                                             as AssetTransactionType,

         /* Dedicated properties which moved with the redesign of the asset master from ANLA to FAAT_MD_LD */
         /* -> I_FixedAssetForLedger selects based on the business function from the correct table         */
         _FixedAssetForLedger.AssetDeactivationDate,

         cast('' as fins_awitem)                                       as ReferenceDocumentItem,
         cast('' as fis_awtyp)                                         as ReferenceDocumentType,
         cast('' as awsys)                                             as LogicalSystem,
         cast('' as awref)                                             as ReferenceDocument,
         cast('' as aworg)                                             as ReferenceDocumentContext,
         cast('' as fis_stblg)                                         as ReversalReferenceDocument,
         cast('' as aworg_rev)                                         as ReversalReferenceDocumentCntxt,
         cast('' as fins_subta_rev)                                    as ReversalTransactionSubitem,
         cast('' as fins_xreversing)                                   as IsReversal,
         cast('' as fins_xreversed)                                    as IsReversed,
         cast('00000000' as bldat)                                     as DocumentDate,
         cast('00000000' as budat)                                     as PostingDate,
         cast('00000000' as bzdat)                                     as AssetValueDate,
         cast('' as fis_blart)                                         as AccountingDocumentType,
         cast('' as dzuonr)                                            as AssignmentReference,
         cast('' as sgtxt)                                             as DocumentItemText,
         cast('' as boolean preserving type)                           as IsStatisticalDocument,
         cast('' as vorgn)                                             as GLBusinessTransactionType,
         cast('' as panl1)                                             as PartnerMasterFixedAsset,
         cast('' as panl2)                                             as PartnerFixedAsset,

         @Semantics.currencyCode:true
         planvalues.CompanyCodeCurrency,
         @Semantics.currencyCode:true
         planvalues.GlobalCurrency,
         @Semantics.currencyCode:true
         planvalues.FreeDefinedCurrency1,
         @Semantics.currencyCode:true
         planvalues.FreeDefinedCurrency2,
         @Semantics.currencyCode:true
         planvalues.FreeDefinedCurrency3,
         @Semantics.currencyCode:true
         planvalues.FreeDefinedCurrency4,
         @Semantics.currencyCode:true
         planvalues.FreeDefinedCurrency5,
         @Semantics.currencyCode:true
         planvalues.FreeDefinedCurrency6,
         @Semantics.currencyCode:true
         planvalues.FreeDefinedCurrency7,
         @Semantics.currencyCode:true
         planvalues.FreeDefinedCurrency8,

         @DefaultAggregation: #SUM
         @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
         cast('0' as fins_vhcur12)                                     as ActualAmountInCompanyCodeCrcy,

         @DefaultAggregation: #SUM
         @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
         cast('0' as fins_vhcur12)                                     as ActualAmountInGlobalCurrency,

         @DefaultAggregation: #SUM
         @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }
         cast('0' as fins_vhcur12)                                     as ActualAmountInFreeDfndCrcy1,

         @DefaultAggregation: #SUM
         @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }
         cast('0' as fins_vhcur12)                                     as ActualAmountInFreeDfndCrcy2,

         @DefaultAggregation: #SUM
         @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }
         cast('0' as fins_vhcur12)                                     as ActualAmountInFreeDfndCrcy3,

         @DefaultAggregation: #SUM
         @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }
         cast('0' as fins_vhcur12)                                     as ActualAmountInFreeDfndCrcy4,

         @DefaultAggregation: #SUM
         @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }
         cast('0' as fins_vhcur12)                                     as ActualAmountInFreeDfndCrcy5,

         @DefaultAggregation: #SUM
         @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }
         cast('0' as fins_vhcur12)                                     as ActualAmountInFreeDfndCrcy6,

         @DefaultAggregation: #SUM
         @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }
         cast('0' as fins_vhcur12)                                     as ActualAmountInFreeDfndCrcy7,

         @DefaultAggregation: #SUM
         @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }
         cast('0' as fins_vhcur12)                                     as ActualAmountInFreeDfndCrcy8,


         @DefaultAggregation: #SUM
         @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
         cast(planvalues.AmountInCompanyCodeCurrency as fins_vhcur12)  as PlanAmountInCompanyCodeCrcy,

         @DefaultAggregation: #SUM
         @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
         cast(planvalues.AmountInGlobalCurrency as fins_vhcur12)       as PlanAmountInGlobalCurrency,

         @DefaultAggregation: #SUM
         @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }
         cast(planvalues.AmountInFreeDefinedCurrency1 as fins_vhcur12) as PlanAmountInFreeDefinedCrcy1,

         @DefaultAggregation: #SUM
         @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }
         cast(planvalues.AmountInFreeDefinedCurrency2 as fins_vhcur12) as PlanAmountInFreeDefinedCrcy2,

         @DefaultAggregation: #SUM
         @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }
         cast(planvalues.AmountInFreeDefinedCurrency3 as fins_vhcur12) as PlanAmountInFreeDefinedCrcy3,

         @DefaultAggregation: #SUM
         @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }
         cast(planvalues.AmountInFreeDefinedCurrency4 as fins_vhcur12) as PlanAmountInFreeDefinedCrcy4,

         @DefaultAggregation: #SUM
         @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }
         cast(planvalues.AmountInFreeDefinedCurrency5 as fins_vhcur12) as PlanAmountInFreeDefinedCrcy5,

         @DefaultAggregation: #SUM
         @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }
         cast(planvalues.AmountInFreeDefinedCurrency6 as fins_vhcur12) as PlanAmountInFreeDefinedCrcy6,

         @DefaultAggregation: #SUM
         @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }
         cast(planvalues.AmountInFreeDefinedCurrency7 as fins_vhcur12) as PlanAmountInFreeDefinedCrcy7,

         @DefaultAggregation: #SUM
         @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }
         cast(planvalues.AmountInFreeDefinedCurrency8 as fins_vhcur12) as PlanAmountInFreeDefinedCrcy8,

         @ObjectModel.foreignKey.association: '_BaseUnit'
         @Semantics.unitOfMeasure:true
         cast ('' as meins)                                            as BaseUnit,
         @DefaultAggregation: #SUM
         @Semantics: { quantity : {unitOfMeasure: 'BaseUnit'} }
         cast (0 as quan1_12)                                          as Quantity,

         cast ('X' as boolean)                                         as IsPlanningDocument

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ASSETKEYFIGURETRANSTYPEDETN",
"I_FIXEDASSETFORLEDGER",
"I_FIXEDASSETLINEITEM",
"I_FIXEDASSETPLANVALUE"
],
"ASSOCIATED":
[
"I_FIXEDASSETFORLEDGER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More