P_FxdAstPlanValWithTmpPlanVal

DDL: P_FXDASTPLANVALWITHTMPPLANVAL SQL: PFASSETPVALL Type: view COMPOSITE
64 Fields 2 Data Sources

P_FxdAstPlanValWithTmpPlanVal is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_FixedAssetPlanValue, I_FixedAssetTmpPlanVal) and exposes 64 fields with key fields CompanyCode, AssetDepreciationArea, MasterFixedAsset, FixedAsset, Ledger.

Data Sources (2)

SourceAliasJoin Type
I_FixedAssetPlanValue I_FixedAssetPlanValue union_all
I_FixedAssetTmpPlanVal I_FixedAssetTmpPlanVal from

Parameters (3)

NameTypeDefault
P_CreationDateTime timestampl
P_UserID username
P_FirstFiscalYear gjahr

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PFASSETPVALL view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (64)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_FixedAssetTmpPlanVal CompanyCode Amount in Freely Defined Currency 8
KEY AssetDepreciationArea I_FixedAssetTmpPlanVal AssetDepreciationArea Deprec. Area
KEY MasterFixedAsset MasterFixedAsset Fixed Asset
KEY FixedAsset FixedAsset Sub-number
KEY Ledger I_FixedAssetTmpPlanVal Ledger Ledger
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY FiscalPeriod FiscalPeriod Tax period
KEY SubLedgerAcctLineItemType SubLedgerAcctLineItemType SLALineItemType
KEY AssetAcctTransClassfctn AssetAcctTransClassfctn Trans.Type Cat.
LedgerGroup LedgerGroup Ledger Group
PlannedValueIsInclusive I_FixedAssetTmpPlanVal PlannedValueIsInclusive
ChartOfDepreciation ChartOfDepreciation
CompanyCodeCurrency CompanyCodeCurrency Local Currency
GlobalCurrency GlobalCurrency GM Billing Element: Global Currency
FreeDefinedCurrency1 FreeDefinedCurrency1 Freely Defined Currency 1
FreeDefinedCurrency2 FreeDefinedCurrency2 Freely Defined Currency 2
FreeDefinedCurrency3 FreeDefinedCurrency3 Freely Defined Currency 3
FreeDefinedCurrency4 FreeDefinedCurrency4 Freely Defined Currency 4
FreeDefinedCurrency5 FreeDefinedCurrency5 Freely Defined Currency 5
FreeDefinedCurrency6 FreeDefinedCurrency6 Freely Defined Currency 6
FreeDefinedCurrency7 FreeDefinedCurrency7 Freely Defined Currency 7
FreeDefinedCurrency8 FreeDefinedCurrency8 Freely Defined Currency 8
CompanyCode Amount in Freely Defined Currency 8
KEY AssetDepreciationArea I_FixedAssetPlanValue AssetDepreciationArea Deprec. Area
KEY MasterFixedAsset MasterFixedAsset Fixed Asset
KEY FixedAsset FixedAsset Sub-number
KEY Ledger I_FixedAssetPlanValue Ledger Ledger
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY FiscalPeriod FiscalPeriod Tax period
KEY SubLedgerAcctLineItemType SubLedgerAcctLineItemType SLALineItemType
KEY AssetAcctTransClassfctn AssetAcctTransClassfctn Trans.Type Cat.
LedgerGroup LedgerGroup Ledger Group
PlannedValueIsInclusive I_FixedAssetPlanValue PlannedValueIsInclusive
ChartOfDepreciation I_FixedAssetPlanValue ChartOfDepreciation
CompanyCodeCurrency CompanyCodeCurrency Local Currency
PlanAmountInCompanyCodeCrcy AmountInCompanyCodeCurrency Local Crcy Amt
ActualAmountInCompanyCodeCrcy
GlobalCurrency GlobalCurrency GM Billing Element: Global Currency
PlanAmountInGlobalCurrency AmountInGlobalCurrency Amount in Global Currency
ActualAmountInGlobalCurrency
FreeDefinedCurrency1 FreeDefinedCurrency1 Freely Defined Currency 1
PlanAmountInFreeDefinedCrcy1 AmountInFreeDefinedCurrency1 Amount in Freely Defined Currency 1
ActualAmountInFreeDfndCrcy1
FreeDefinedCurrency2 FreeDefinedCurrency2 Freely Defined Currency 2
PlanAmountInFreeDefinedCrcy2 AmountInFreeDefinedCurrency2 Amount in Freely Defined Currency 2
ActualAmountInFreeDfndCrcy2
FreeDefinedCurrency3 FreeDefinedCurrency3 Freely Defined Currency 3
PlanAmountInFreeDefinedCrcy3 AmountInFreeDefinedCurrency3 Amount in Freely Defined Currency 3
ActualAmountInFreeDfndCrcy3
FreeDefinedCurrency4 FreeDefinedCurrency4 Freely Defined Currency 4
PlanAmountInFreeDefinedCrcy4 AmountInFreeDefinedCurrency4 Amount in Freely Defined Currency 4
ActualAmountInFreeDfndCrcy4
FreeDefinedCurrency5 FreeDefinedCurrency5 Freely Defined Currency 5
PlanAmountInFreeDefinedCrcy5 AmountInFreeDefinedCurrency5 Amount in Freely Defined Currency 5
ActualAmountInFreeDfndCrcy5
FreeDefinedCurrency6 FreeDefinedCurrency6 Freely Defined Currency 6
PlanAmountInFreeDefinedCrcy6 AmountInFreeDefinedCurrency6 Amount in Freely Defined Currency 6
ActualAmountInFreeDfndCrcy6
FreeDefinedCurrency7 FreeDefinedCurrency7 Freely Defined Currency 7
PlanAmountInFreeDefinedCrcy7 AmountInFreeDefinedCurrency7 Amount in Freely Defined Currency 7
ActualAmountInFreeDfndCrcy7
FreeDefinedCurrency8 FreeDefinedCurrency8 Freely Defined Currency 8
PlanAmountInFreeDefinedCrcy8 AmountInFreeDefinedCurrency8 Amount in Freely Defined Currency 8
ActualAmountInFreeDfndCrcy8

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 P_FxdAstPlanValWithTmpPlanVal.
-- 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: PFASSETPVALL
-- Parameters: P_CreationDateTime : timestampl, P_UserID : username, P_FirstFiscalYear : gjahr

CREATE VIEW P_FxdAstPlanValWithTmpPlanVal AS
SELECT
  I_FixedAssetTmpPlanVal.CompanyCode AS CompanyCode,
  I_FixedAssetTmpPlanVal.AssetDepreciationArea AS AssetDepreciationArea,
  MasterFixedAsset,
  FixedAsset,
  I_FixedAssetTmpPlanVal.Ledger AS Ledger,
  FiscalYear,
  FiscalPeriod,
  SubLedgerAcctLineItemType,
  AssetAcctTransClassfctn,
  LedgerGroup,
  I_FixedAssetTmpPlanVal.PlannedValueIsInclusive AS PlannedValueIsInclusive,
  ChartOfDepreciation,
  CompanyCodeCurrency,
  GlobalCurrency,
  FreeDefinedCurrency1,
  FreeDefinedCurrency2,
  FreeDefinedCurrency3,
  FreeDefinedCurrency4,
  FreeDefinedCurrency5,
  FreeDefinedCurrency6,
  FreeDefinedCurrency7,
  FreeDefinedCurrency8,
  AmountInCompanyCodeCurrency AS PlanAmountInCompanyCodeCrcy,
  cast('0' as fins_vhcur12) AS ActualAmountInCompanyCodeCrcy,
  AmountInGlobalCurrency AS PlanAmountInGlobalCurrency,
  cast('0' as fins_vhcur12) AS ActualAmountInGlobalCurrency,
  AmountInFreeDefinedCurrency1 AS PlanAmountInFreeDefinedCrcy1,
  cast('0' as fins_vhcur12) AS ActualAmountInFreeDfndCrcy1,
  AmountInFreeDefinedCurrency2 AS PlanAmountInFreeDefinedCrcy2,
  cast('0' as fins_vhcur12) AS ActualAmountInFreeDfndCrcy2,
  AmountInFreeDefinedCurrency3 AS PlanAmountInFreeDefinedCrcy3,
  cast('0' as fins_vhcur12) AS ActualAmountInFreeDfndCrcy3,
  AmountInFreeDefinedCurrency4 AS PlanAmountInFreeDefinedCrcy4,
  cast('0' as fins_vhcur12) AS ActualAmountInFreeDfndCrcy4,
  AmountInFreeDefinedCurrency5 AS PlanAmountInFreeDefinedCrcy5,
  cast('0' as fins_vhcur12) AS ActualAmountInFreeDfndCrcy5,
  AmountInFreeDefinedCurrency6 AS PlanAmountInFreeDefinedCrcy6,
  cast('0' as fins_vhcur12) AS ActualAmountInFreeDfndCrcy6,
  AmountInFreeDefinedCurrency7 AS PlanAmountInFreeDefinedCrcy7,
  cast('0' as fins_vhcur12) AS ActualAmountInFreeDfndCrcy7,
  AmountInFreeDefinedCurrency8 AS PlanAmountInFreeDefinedCrcy8,
  cast('0' as fins_vhcur12) AS ActualAmountInFreeDfndCrcy8
FROM I_FixedAssetTmpPlanVal
-- UNION ALL with additional select branch(es): I_FixedAssetPlanValue
;

Learn More