P_FixedAssetValue

Q: Which tables does P_FixedAssetValue use?

P_FixedAssetValue reads from 3 data source(s): I_AssetKeyFigureSetSpec, I_AssetKeyFigureSpecification, P_FixedAssetValueWthDetn.

Q: How many fields does P_FixedAssetValue have?

P_FixedAssetValue has 99 fields. Key fields: AssetDepreciationArea, CompanyCode, FiscalYear, MasterFixedAsset, FixedAsset.

DDL: P_FIXEDASSETVALUE Type: view COMPOSITE

P_FixedAssetValue is a Composite CDS View in SAP S/4HANA. It reads from 3 data sources (I_AssetKeyFigureSetSpec, I_AssetKeyFigureSpecification, P_FixedAssetValueWthDetn) and exposes 99 fields with key fields AssetDepreciationArea, CompanyCode, FiscalYear, MasterFixedAsset, FixedAsset.

Data Sources (3)

Source	Alias	Join Type
I_AssetKeyFigureSetSpec	AssetKeyFigureSetSpec	inner
I_AssetKeyFigureSpecification	AssetKeyFigureSpec	inner
P_FixedAssetValueWthDetn	P_FixedAssetValueWthDetn	from

Parameters (1)

Name	Type	Default
P_AssetAccountingKeyFigureSet	faa_key_figure_set

Annotations (8)

Name	Value	Level
AbapCatalog.sqlViewName	PFASSETVALUE	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 (99)

Key	Field	Source Table	Source Field
KEY	AssetDepreciationArea	values	AssetDepreciationArea
KEY	CompanyCode	values	CompanyCode
KEY	FiscalYear	values	FiscalYear
KEY	MasterFixedAsset	values	MasterFixedAsset
KEY	FixedAsset	values	FixedAsset
KEY	AccountingDocument	values	AccountingDocument
KEY	TransactionSubitem	values	TransactionSubitem
KEY	Ledger	values	Ledger
KEY	FiscalPeriod	values	FiscalPeriod
KEY	SubLedgerAcctLineItemType	values	SubLedgerAcctLineItemType
KEY	AssetAcctTransClassfctn	values	AssetAcctTransClassfctn
KEY	DebitCreditCode	values	DebitCreditCode
	LedgerFiscalYear		LedgerFiscalYear
	FiscalYearVariant		FiscalYearVariant
	FiscalYearPeriod		FiscalYearPeriod
	DepreciationFiscalPeriod		DepreciationFiscalPeriod
	AssetAccountingSortedKeyFigure	I_AssetKeyFigureSetSpec	AssetAccountingSortedKeyFigure
	AssetAcctAnlytlTransClassfctn	values	AssetAcctAnlytlTransClassfctn
	LedgerGroup	values	LedgerGroup
	ChartOfAccounts	values	ChartOfAccounts
	CountryChartOfAccounts	values	CountryChartOfAccounts
	GLAccount	values	GLAccount
	AlternativeGLAccount	values	AlternativeGLAccount
	GroupMasterFixedAsset	values	GroupMasterFixedAsset
	GroupFixedAsset	values	GroupFixedAsset
	FinancialAccountType	values	FinancialAccountType
	ChartOfDepreciation	values	ChartOfDepreciation
	AccountingDocumentCreationDate	values	AccountingDocumentCreationDate
	CreationTime	values	CreationTime
	AccountingDocCreatedByUser	values	AccountingDocCreatedByUser
	JointVentureCostRecoveryCode	values	JointVentureCostRecoveryCode
	CostCenter	values	CostCenter
	Plant	values	Plant
	BusinessArea	values	BusinessArea
	PersonnelNumber	values	PersonnelNumber
	FinancialManagementArea	values	FinancialManagementArea
	Fund	values	Fund
	GrantID	values	GrantID
	FunctionalArea	values	FunctionalArea
	BudgetPeriod	values	BudgetPeriod
	ProfitCenter	values	ProfitCenter
	Segment	values	Segment
	FundsCenter	values	FundsCenter
	AssetTransactionType	values	AssetTransactionType
	AssetDeactivationDate	values	AssetDeactivationDate
	AssetAccountingKeyFigure	I_AssetKeyFigureSpecification	AssetAccountingKeyFigure
	PlannedValueIsInclusive	I_AssetKeyFigureSpecification	PlannedValueIsInclusive
	ReferenceDocumentItem	values	ReferenceDocumentItem
	ReferenceDocumentType	values	ReferenceDocumentType
	LogicalSystem	values	LogicalSystem
	ReferenceDocument	values	ReferenceDocument
	ReferenceDocumentContext	values	ReferenceDocumentContext
	ReversalReferenceDocument	values	ReversalReferenceDocument
	ReversalReferenceDocumentCntxt	values	ReversalReferenceDocumentCntxt
	ReversalTransactionSubitem	values	ReversalTransactionSubitem
	IsReversal	values	IsReversal
	IsReversed	values	IsReversed
	DocumentDate	values	DocumentDate
	PostingDate	values	PostingDate
	AssetValueDate	values	AssetValueDate
	AccountingDocumentType	values	AccountingDocumentType
	AssignmentReference	values	AssignmentReference
	DocumentItemText	values	DocumentItemText
	IsStatisticalDocument	values	IsStatisticalDocument
	GLBusinessTransactionType	values	GLBusinessTransactionType
	PartnerMasterFixedAsset	values	PartnerMasterFixedAsset
	PartnerFixedAsset	values	PartnerFixedAsset
	CompanyCodeCurrency	values	CompanyCodeCurrency
	GlobalCurrency	values	GlobalCurrency
	FreeDefinedCurrency1	values	FreeDefinedCurrency1
	FreeDefinedCurrency2	values	FreeDefinedCurrency2
	FreeDefinedCurrency3	values	FreeDefinedCurrency3
	FreeDefinedCurrency4	values	FreeDefinedCurrency4
	FreeDefinedCurrency5	values	FreeDefinedCurrency5
	FreeDefinedCurrency6	values	FreeDefinedCurrency6
	FreeDefinedCurrency7	values	FreeDefinedCurrency7
	FreeDefinedCurrency8	values	FreeDefinedCurrency8
	ActualAmountInCompanyCodeCrcy	values	ActualAmountInCompanyCodeCrcy
	ActualAmountInGlobalCurrency	values	ActualAmountInGlobalCurrency
	ActualAmountInFreeDfndCrcy1	values	ActualAmountInFreeDfndCrcy1
	ActualAmountInFreeDfndCrcy2	values	ActualAmountInFreeDfndCrcy2
	ActualAmountInFreeDfndCrcy3	values	ActualAmountInFreeDfndCrcy3
	ActualAmountInFreeDfndCrcy4	values	ActualAmountInFreeDfndCrcy4
	ActualAmountInFreeDfndCrcy5	values	ActualAmountInFreeDfndCrcy5
	ActualAmountInFreeDfndCrcy6	values	ActualAmountInFreeDfndCrcy6
	ActualAmountInFreeDfndCrcy7	values	ActualAmountInFreeDfndCrcy7
	ActualAmountInFreeDfndCrcy8	values	ActualAmountInFreeDfndCrcy8
	PlanAmountInCompanyCodeCrcy	values	PlanAmountInCompanyCodeCrcy
	PlanAmountInGlobalCurrency	values	PlanAmountInGlobalCurrency
	PlanAmountInFreeDefinedCrcy1	values	PlanAmountInFreeDefinedCrcy1
	PlanAmountInFreeDefinedCrcy2	values	PlanAmountInFreeDefinedCrcy2
	PlanAmountInFreeDefinedCrcy3	values	PlanAmountInFreeDefinedCrcy3
	PlanAmountInFreeDefinedCrcy4	values	PlanAmountInFreeDefinedCrcy4
	PlanAmountInFreeDefinedCrcy5	values	PlanAmountInFreeDefinedCrcy5
	PlanAmountInFreeDefinedCrcy6	values	PlanAmountInFreeDefinedCrcy6
	PlanAmountInFreeDefinedCrcy7	values	PlanAmountInFreeDefinedCrcy7
	PlanAmountInFreeDefinedCrcy8	values	PlanAmountInFreeDefinedCrcy8
	BaseUnit		BaseUnit
	Quantity		Quantity

@AbapCatalog: { sqlViewName: 'PFASSETVALUE',
                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_FixedAssetValue
  with parameters
    P_AssetAccountingKeyFigureSet : faa_key_figure_set

  as select from P_FixedAssetValueWthDetn(P_AssetAccountingKeyFigureSet: :P_AssetAccountingKeyFigureSet) as values
    inner join   I_AssetKeyFigureSetSpec                                                                 as AssetKeyFigureSetSpec on AssetKeyFigureSetSpec.AssetAccountingKeyFigureSet = :P_AssetAccountingKeyFigureSet
    inner join   I_AssetKeyFigureSpecification                                                           as AssetKeyFigureSpec    on  AssetKeyFigureSpec.AssetAccountingKeyFigure      = AssetKeyFigureSetSpec.AssetAccountingKeyFigure
                                                                                                                                  and AssetKeyFigureSpec.AssetAcctAnlytlTransClassfctn = values.AssetAcctAnlytlTransClassfctn
                                                                                                                                  and AssetKeyFigureSpec.SubLedgerAcctLineItemType     = values.SubLedgerAcctLineItemType
{

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

      LedgerFiscalYear,
      FiscalYearVariant,
      FiscalYearPeriod,
      DepreciationFiscalPeriod,

      AssetKeyFigureSetSpec.AssetAccountingSortedKeyFigure,
      values.AssetAcctAnlytlTransClassfctn,
      values.LedgerGroup,
      values.ChartOfAccounts,
      values.CountryChartOfAccounts,
      values.GLAccount,
      values.AlternativeGLAccount,
      values.GroupMasterFixedAsset,
      values.GroupFixedAsset,
      values.FinancialAccountType,
      values.ChartOfDepreciation,

      values.AccountingDocumentCreationDate,
      values.CreationTime,
      values.AccountingDocCreatedByUser,
      values.JointVentureCostRecoveryCode,
      values.CostCenter,
      values.Plant,
      values.BusinessArea,
      values.PersonnelNumber,
      values.FinancialManagementArea,
      values.Fund,
      values.GrantID,
      values.FunctionalArea,
      values.BudgetPeriod,
      values.ProfitCenter,
      values.Segment,
      values.FundsCenter,
      values.AssetTransactionType,
      values.AssetDeactivationDate,
      AssetKeyFigureSpec.AssetAccountingKeyFigure,
      AssetKeyFigureSpec.PlannedValueIsInclusive,

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

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

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
      values.ActualAmountInCompanyCodeCrcy,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
      values.ActualAmountInGlobalCurrency,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }
      values.ActualAmountInFreeDfndCrcy1,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }
      values.ActualAmountInFreeDfndCrcy2,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }
      values.ActualAmountInFreeDfndCrcy3,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }
      values.ActualAmountInFreeDfndCrcy4,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }
      values.ActualAmountInFreeDfndCrcy5,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }
      values.ActualAmountInFreeDfndCrcy6,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }
      values.ActualAmountInFreeDfndCrcy7,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }
      values.ActualAmountInFreeDfndCrcy8,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
      values.PlanAmountInCompanyCodeCrcy,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
      values.PlanAmountInGlobalCurrency,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }
      values.PlanAmountInFreeDefinedCrcy1,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }
      values.PlanAmountInFreeDefinedCrcy2,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }
      values.PlanAmountInFreeDefinedCrcy3,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }
      values.PlanAmountInFreeDefinedCrcy4,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }
      values.PlanAmountInFreeDefinedCrcy5,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }
      values.PlanAmountInFreeDefinedCrcy6,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }
      values.PlanAmountInFreeDefinedCrcy7,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }
      values.PlanAmountInFreeDefinedCrcy8,

      @Semantics.unitOfMeasure:true
      BaseUnit,
      @DefaultAggregation: #SUM
      @Semantics: { quantity : {unitOfMeasure: 'BaseUnit'} }
      Quantity
}
where
  (
    (
          IsPlanningDocument                         =  ''
    )
    or(
          IsPlanningDocument                         =  'X'
      and AssetKeyFigureSpec.PlannedValueIsInclusive <> '0'
    )
  )
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ASSETKEYFIGURESETSPEC",
"I_ASSETKEYFIGURESPECIFICATION",
"P_FIXEDASSETVALUEWTHDETN"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

P_FixedAssetValue view

I_FixedAssetValue view