Which tables does P_FxdAstDBPlanWithTempPlanVal use?

P_FxdAstDBPlanWithTempPlanVal reads from 2 data source(s): I_FixedAssetPlanValue, I_FixedAssetTmpPlanVal.

How many fields does P_FxdAstDBPlanWithTempPlanVal have?

P_FxdAstDBPlanWithTempPlanVal has 50 fields. Key fields: AssetDepreciationArea, CompanyCode, FiscalYear, MasterFixedAsset, FixedAsset.

P_FxdAstDBPlanWithTempPlanVal

DDL: P_FXDASTDBPLANWITHTEMPPLANVAL SQL: PFAPLANVAL Type: view COMPOSITE

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

Data Sources (2)

Source	Alias	Join Type
I_FixedAssetPlanValue	planvalues	from
I_FixedAssetTmpPlanVal	planvalues	union_all

Parameters (2)

Name	Type	Default
P_CreationDateTime	timestampl
P_UserID	username

Associations (1)

Cardinality	Target	Alias	Condition
[1]	I_DeprAreaByCoCodeWithCrcyRole	_I_DeprAreaByCCWithCrcyRole	`$projection.CompanyCode = _I_DeprAreaByCCWithCrcyRole.CompanyCode and $projection.AssetDepreciationArea = _I_DeprAreaByCCWithCrcyRole.AssetDepreciationArea`

Annotations (5)

Name	Value	Level
AbapCatalog.sqlViewName	PFAPLANVAL	view
VDM.viewType	#COMPOSITE	view
VDM.private	true	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view

Fields (50)

Key	Field	Source Table	Source Field
KEY	AssetDepreciationArea	I_FixedAssetTmpPlanVal	AssetDepreciationArea
KEY	CompanyCode	I_FixedAssetTmpPlanVal	CompanyCode
KEY	FiscalYear	I_FixedAssetTmpPlanVal	FiscalYear
KEY	MasterFixedAsset	I_FixedAssetTmpPlanVal	MasterFixedAsset
KEY	FixedAsset	I_FixedAssetTmpPlanVal	FixedAsset
KEY	Ledger	I_FixedAssetTmpPlanVal	Ledger
KEY	FiscalPeriod	I_FixedAssetTmpPlanVal	FiscalPeriod
KEY	SubLedgerAcctLineItemType	I_FixedAssetTmpPlanVal	SubLedgerAcctLineItemType
KEY	AssetAcctTransClassfctn	I_FixedAssetTmpPlanVal	AssetAcctTransClassfctn
	LedgerGroup	I_FixedAssetTmpPlanVal	LedgerGroup
	CompanyCodeCurrency	I_FixedAssetTmpPlanVal	CompanyCodeCurrency
	AmountInCompanyCodeCurrency
	AmountInGlobalCurrency
	AmountInFreeDefinedCurrency1
	AmountInFreeDefinedCurrency2
	AmountInFreeDefinedCurrency3
	AmountInFreeDefinedCurrency4
	AmountInFreeDefinedCurrency5
	AmountInFreeDefinedCurrency6
	AmountInFreeDefinedCurrency7
	AssetDepreciationArea
KEY	CompanyCode	I_FixedAssetTmpPlanVal	CompanyCode
KEY	FiscalYear	I_FixedAssetTmpPlanVal	FiscalYear
KEY	MasterFixedAsset	I_FixedAssetTmpPlanVal	MasterFixedAsset
KEY	FixedAsset	I_FixedAssetTmpPlanVal	FixedAsset
KEY	Ledger	I_FixedAssetTmpPlanVal	Ledger
KEY	FiscalPeriod	I_FixedAssetTmpPlanVal	FiscalPeriod
KEY	SubLedgerAcctLineItemType	I_FixedAssetTmpPlanVal	SubLedgerAcctLineItemType
KEY	AssetAcctTransClassfctn	I_FixedAssetTmpPlanVal	AssetAcctTransClassfctn
	LedgerGroup	I_FixedAssetTmpPlanVal	LedgerGroup
	CompanyCodeCurrency	I_FixedAssetTmpPlanVal	CompanyCodeCurrency
	GlobalCurrency	I_FixedAssetTmpPlanVal	GlobalCurrency
	FreeDefinedCurrency1	I_FixedAssetTmpPlanVal	FreeDefinedCurrency1
	FreeDefinedCurrency2	I_FixedAssetTmpPlanVal	FreeDefinedCurrency2
	FreeDefinedCurrency3	I_FixedAssetTmpPlanVal	FreeDefinedCurrency3
	FreeDefinedCurrency4	I_FixedAssetTmpPlanVal	FreeDefinedCurrency4
	FreeDefinedCurrency5	I_FixedAssetTmpPlanVal	FreeDefinedCurrency5
	FreeDefinedCurrency6	I_FixedAssetTmpPlanVal	FreeDefinedCurrency6
	FreeDefinedCurrency7	I_FixedAssetTmpPlanVal	FreeDefinedCurrency7
	FreeDefinedCurrency8	I_FixedAssetTmpPlanVal	FreeDefinedCurrency8
	AmountInCompanyCodeCurrency
	AmountInGlobalCurrency
	AmountInFreeDefinedCurrency1
	AmountInFreeDefinedCurrency2
	AmountInFreeDefinedCurrency3
	AmountInFreeDefinedCurrency4
	AmountInFreeDefinedCurrency5
	AmountInFreeDefinedCurrency6
	AmountInFreeDefinedCurrency7
	AmountInFreeDefinedCurrency8

@AbapCatalog.sqlViewName: 'PFAPLANVAL'
@VDM.viewType: #COMPOSITE
@VDM.private: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE

define view P_FxdAstDBPlanWithTempPlanVal
  with parameters
    P_CreationDateTime : timestampl,
    P_UserID           : username

  as select from I_FixedAssetPlanValue as planvalues

  association [1] to I_DeprAreaByCoCodeWithCrcyRole as _I_DeprAreaByCCWithCrcyRole on  $projection.CompanyCode           = _I_DeprAreaByCCWithCrcyRole.CompanyCode
                                                                                   and $projection.AssetDepreciationArea = _I_DeprAreaByCCWithCrcyRole.AssetDepreciationArea
{


  key    planvalues.AssetDepreciationArea,
  key    planvalues.CompanyCode,
  key    planvalues.FiscalYear,
  key    planvalues.MasterFixedAsset,
  key    planvalues.FixedAsset,
  key    planvalues.Ledger,
  key    planvalues.FiscalPeriod,
  key    planvalues.SubLedgerAcctLineItemType,
  key    planvalues.AssetAcctTransClassfctn,


         planvalues.LedgerGroup,
         @Semantics.currencyCode:true
         planvalues.CompanyCodeCurrency,
         @Semantics.currencyCode:true
         //planvalues.GlobalCurrency,

         //Since the currencies for derived areas (not real depreciation areas) are sometimes stored erroneously, we have to read only the

         //Currency from the first column (Company Code currency) and to delete all other currencies

         case _I_DeprAreaByCCWithCrcyRole.IsRealDepreciationArea
         when 'X' then planvalues.GlobalCurrency
         else cast('     ' as fins_currk)
         end                                                           as GlobalCurrency,
         @Semantics.currencyCode:true
         //planvalues.FreeDefinedCurrency1,

         case _I_DeprAreaByCCWithCrcyRole.IsRealDepreciationArea
         when 'X' then planvalues.FreeDefinedCurrency1
         else cast('     ' as fins_curr1)
         end                                                           as FreeDefinedCurrency1,
         @Semantics.currencyCode:true
         //planvalues.FreeDefinedCurrency2,

         case _I_DeprAreaByCCWithCrcyRole.IsRealDepreciationArea
         when 'X' then planvalues.FreeDefinedCurrency2
         else cast('     ' as fins_curr2)
         end                                                           as FreeDefinedCurrency2,
         @Semantics.currencyCode:true
         //planvalues.FreeDefinedCurrency3,

         case _I_DeprAreaByCCWithCrcyRole.IsRealDepreciationArea
         when 'X' then planvalues.FreeDefinedCurrency3
         else cast('     ' as fins_curr3)
         end                                                           as FreeDefinedCurrency3,
         @Semantics.currencyCode:true
         //planvalues.FreeDefinedCurrency4,

         case _I_DeprAreaByCCWithCrcyRole.IsRealDepreciationArea
         when 'X' then planvalues.FreeDefinedCurrency4
         else cast('     ' as fins_curr4)
         end                                                           as FreeDefinedCurrency4,
         @Semantics.currencyCode:true
         //planvalues.FreeDefinedCurrency5,

         case _I_DeprAreaByCCWithCrcyRole.IsRealDepreciationArea
         when 'X' then planvalues.FreeDefinedCurrency5
         else cast('     ' as fins_curr5)
         end                                                           as FreeDefinedCurrency5,
         @Semantics.currencyCode:true
         //planvalues.FreeDefinedCurrency6,

         case _I_DeprAreaByCCWithCrcyRole.IsRealDepreciationArea
         when 'X' then planvalues.FreeDefinedCurrency6
         else cast('     ' as fins_curr6)
         end                                                           as FreeDefinedCurrency6,
         @Semantics.currencyCode:true
         //planvalues.FreeDefinedCurrency7,

         case _I_DeprAreaByCCWithCrcyRole.IsRealDepreciationArea
         when 'X' then planvalues.FreeDefinedCurrency7
         else cast('     ' as fins_curr7)
         end                                                           as FreeDefinedCurrency7,
         @Semantics.currencyCode:true
         //planvalues.FreeDefinedCurrency8,

         case _I_DeprAreaByCCWithCrcyRole.IsRealDepreciationArea
         when 'X' then planvalues.FreeDefinedCurrency8
         else cast('     ' as fins_curr8)
         end                                                           as FreeDefinedCurrency8,

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

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

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

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

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

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

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

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

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

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


union all select from I_FixedAssetTmpPlanVal as planvalues
{
  key    planvalues.AssetDepreciationArea,
  key    planvalues.CompanyCode,
  key    planvalues.FiscalYear,
  key    planvalues.MasterFixedAsset,
  key    planvalues.FixedAsset,
  key    planvalues.Ledger,
  key    planvalues.FiscalPeriod,
  key    planvalues.SubLedgerAcctLineItemType,
  key    planvalues.AssetAcctTransClassfctn,

         planvalues.LedgerGroup,
         @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(-1*planvalues.AmountInCompanyCodeCurrency as fins_vhcur12)  as AmountInCompanyCodeCurrency,

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

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

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

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

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

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

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

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

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

where

      planvalues.CreatedByUser          = :P_UserID
  and planvalues.CreationDateTime       = :P_CreationDateTime
  and planvalues.IsRepresentativeLedger = 'X'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_DEPRAREABYCOCODEWITHCRCYROLE",
"I_FIXEDASSETPLANVALUE",
"I_FIXEDASSETTMPPLANVAL"
],
"ASSOCIATED":
[
"I_DEPRAREABYCOCODEWITHCRCYROLE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

P_FxdAstDBPlanWithTempPlanVal view

I_FixedAssetPlanValue view
I_FixedAssetTmpPlanVal view

P_FxdAstCompCalcPlanWithDBVal view