What is P_FixedAssetValueWthDetn in SAP S/4HANA?

P_FixedAssetValueWthDetn is a composite CDS view in SAP S/4HANA. It contains 192 fields.

Which tables does P_FixedAssetValueWthDetn read from?

P_FixedAssetValueWthDetn reads data from: I_AssetKeyFigureTransTypeDetn, I_FixedAssetLineItem, I_FixedAssetPlanValue.

What VDM layer is P_FixedAssetValueWthDetn?

P_FixedAssetValueWthDetn is classified as a Composite view that combines data from multiple basic views.

P_FixedAssetValueWthDetn

DDL: P_FIXEDASSETVALUEWTHDETN Type: view COMPOSITE

192 Fields 3 Data Sources 1 Associations

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.

Data Sources (3)

Source	Alias	Join Type
I_AssetKeyFigureTransTypeDetn	determination	left_outer
I_FixedAssetLineItem	lineitems	from
I_FixedAssetPlanValue	planvalues	union_all

Parameters (1)

Name	Type	Default
P_AssetAccountingKeyFigureSet	faa_key_figure_set

Associations (1)

Cardinality	Target	Alias	Condition
[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)

Name	Value	Level
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)

Key	Field	Source Table	Source Field	Description
KEY	AssetDepreciationArea	I_FixedAssetLineItem	AssetDepreciationArea	Deprec. Area
KEY	CompanyCode	I_FixedAssetLineItem	CompanyCode	Receiver Company Code
KEY	FiscalYear	I_FixedAssetLineItem	FiscalYear	G/L Fiscal Year
KEY	MasterFixedAsset	I_FixedAssetLineItem	MasterFixedAsset	Fixed Asset
KEY	FixedAsset	I_FixedAssetLineItem	FixedAsset	Sub-number
KEY	AccountingDocument	I_FixedAssetLineItem	AccountingDocument	Journal Entry
KEY	TransactionSubitem	I_FixedAssetLineItem	TransactionSubitem	Sub Transaction
KEY	Ledger	I_FixedAssetLineItem	Ledger	Ledger
KEY	FiscalPeriod	I_FixedAssetLineItem	FiscalPeriod	Tax period
KEY	SubLedgerAcctLineItemType	I_FixedAssetLineItem	SubLedgerAcctLineItemType	SLALineItemType
KEY	AssetAcctTransClassfctn	I_FixedAssetLineItem	AssetAcctTransClassfctn	Trans.Type Cat.
KEY	DebitCreditCode		DebitCreditCode	Single-Character Flag
	LedgerFiscalYear		LedgerFiscalYear
	FiscalYearVariant		FiscalYearVariant	FY Variant
	FiscalYearPeriod		FiscalYearPeriod	Period/Year
	DepreciationFiscalPeriod		DepreciationFiscalPeriod	Tax period
	LedgerGroup	I_FixedAssetLineItem	LedgerGroup	Ledger Group
	ChartOfAccounts	I_FixedAssetLineItem	ChartOfAccounts	Node Class
	CountryChartOfAccounts	I_FixedAssetLineItem	CountryChartOfAccounts	Chart of Accts
	GLAccount	I_FixedAssetLineItem	GLAccount	General Ledger
	AlternativeGLAccount	I_FixedAssetLineItem	AlternativeGLAccount	Group Account
	GroupMasterFixedAsset	I_FixedAssetLineItem	GroupMasterFixedAsset
	GroupFixedAsset	I_FixedAssetLineItem	GroupFixedAsset
	FinancialAccountType	I_FixedAssetLineItem	FinancialAccountType	Fin. Account Type
	ChartOfDepreciation	I_FixedAssetLineItem	ChartOfDepreciation
	AccountingDocumentCreationDate	I_FixedAssetLineItem	AccountingDocumentCreationDate	Journal Entry Date
	CreationTime	I_FixedAssetLineItem	CreationTime	Time of Change
	AccountingDocCreatedByUser	I_FixedAssetLineItem	AccountingDocCreatedByUser	User which created overhead document
	JointVentureCostRecoveryCode	I_FixedAssetLineItem	JointVentureCostRecoveryCode	Recovery Ind.
	CostCenter	I_FixedAssetLineItem	CostCenter	Cost Center
	Plant	I_FixedAssetLineItem	Plant	Valuation Area
	BusinessArea	I_FixedAssetLineItem	BusinessArea	Business Area
	PersonnelNumber	I_FixedAssetLineItem	PersonnelNumber	Personnel No.
	FinancialManagementArea	I_FixedAssetLineItem	FinancialManagementArea	FM Area
	Fund	I_FixedAssetLineItem	Fund	Sender Fund
	GrantID	I_FixedAssetLineItem	GrantID	Sender Grant
	FunctionalArea	I_FixedAssetLineItem	FunctionalArea	Sendr Fctl Area
	BudgetPeriod	I_FixedAssetLineItem	BudgetPeriod	Budget Period
	ProfitCenter	I_FixedAssetLineItem	ProfitCenter	Profit Center
	Segment	I_FixedAssetLineItem	Segment	Segment number
	FundsCenter	I_FixedAssetLineItem	FundsCenter	Funds Center
	AssetTransactionType	I_FixedAssetLineItem	AssetTransactionType	Trans.Type
	AssetDeactivationDate	_FixedAssetForLedger	AssetDeactivationDate
	ReferenceDocumentItem	I_FixedAssetLineItem	ReferenceDocumentItem	Reference item
	ReferenceDocumentType	I_FixedAssetLineItem	ReferenceDocumentType	Reference Document Type
	LogicalSystem	I_FixedAssetLineItem	LogicalSystem	Logical System
	ReferenceDocument	I_FixedAssetLineItem	ReferenceDocument	Reference Document
	ReferenceDocumentContext	I_FixedAssetLineItem	ReferenceDocumentContext	Reference Document Context
	ReversalReferenceDocument	I_FixedAssetLineItem	ReversalReferenceDocument	Reversal Reference Document
	ReversalReferenceDocumentCntxt	I_FixedAssetLineItem	ReversalReferenceDocumentCntxt	Reversal Reference Document Context
	ReversalTransactionSubitem	I_FixedAssetLineItem	ReversalTransactionSubitem	Reversal Sub Trans
	IsReversal	I_FixedAssetLineItem	IsReversal	Reversal doc.
	IsReversed	I_FixedAssetLineItem	IsReversed	Reversed?
	DocumentDate	I_FixedAssetLineItem	DocumentDate	Journal Entry Date
	PostingDate	I_FixedAssetLineItem	PostingDate	Posting Date for GR
	AssetValueDate	I_FixedAssetLineItem	AssetValueDate	Reference date
	AccountingDocumentType	I_FixedAssetLineItem	AccountingDocumentType	Journal Entry Type
	AssignmentReference	I_FixedAssetLineItem	AssignmentReference	Assignment Reference
	DocumentItemText	I_FixedAssetLineItem	DocumentItemText	Text
	IsStatisticalDocument	I_FixedAssetLineItem	IsStatisticalDocument
	GLBusinessTransactionType	I_FixedAssetLineItem	GLBusinessTransactionType	Transact. Type
	PartnerMasterFixedAsset	I_FixedAssetLineItem	PartnerMasterFixedAsset	Partner Asset
	PartnerFixedAsset	I_FixedAssetLineItem	PartnerFixedAsset	Partner Sub-No.
	CompanyCodeCurrency	I_FixedAssetLineItem	CompanyCodeCurrency	Local Currency
	GlobalCurrency	I_FixedAssetLineItem	GlobalCurrency	GM Billing Element: Global Currency
	FreeDefinedCurrency1	I_FixedAssetLineItem	FreeDefinedCurrency1	Freely Defined Currency 1
	FreeDefinedCurrency2	I_FixedAssetLineItem	FreeDefinedCurrency2	Freely Defined Currency 2
	FreeDefinedCurrency3	I_FixedAssetLineItem	FreeDefinedCurrency3	Freely Defined Currency 3
	FreeDefinedCurrency4	I_FixedAssetLineItem	FreeDefinedCurrency4	Freely Defined Currency 4
	FreeDefinedCurrency5	I_FixedAssetLineItem	FreeDefinedCurrency5	Freely Defined Currency 5
	FreeDefinedCurrency6	I_FixedAssetLineItem	FreeDefinedCurrency6	Freely Defined Currency 6
	FreeDefinedCurrency7	I_FixedAssetLineItem	FreeDefinedCurrency7	Freely Defined Currency 7
	FreeDefinedCurrency8	I_FixedAssetLineItem	FreeDefinedCurrency8	Freely Defined Currency 8
	ActualAmountInCompanyCodeCrcy
	ActualAmountInGlobalCurrency
	ActualAmountInFreeDfndCrcy1
	ActualAmountInFreeDfndCrcy2
	ActualAmountInFreeDfndCrcy3
	ActualAmountInFreeDfndCrcy4
	ActualAmountInFreeDfndCrcy5
	ActualAmountInFreeDfndCrcy6
	ActualAmountInFreeDfndCrcy7
	ActualAmountInFreeDfndCrcy8
	PlanAmountInCompanyCodeCrcy
	PlanAmountInGlobalCurrency
	PlanAmountInFreeDefinedCrcy1
	PlanAmountInFreeDefinedCrcy2
	PlanAmountInFreeDefinedCrcy3
	PlanAmountInFreeDefinedCrcy4
	PlanAmountInFreeDefinedCrcy5
	PlanAmountInFreeDefinedCrcy6
	PlanAmountInFreeDefinedCrcy7
	PlanAmountInFreeDefinedCrcy8
	BaseUnit		BaseUnit	Unit of Measure
	Quantity		Quantity	Value
	AssetDepreciationArea			Deprec. Area
KEY	CompanyCode	I_FixedAssetPlanValue	CompanyCode	Receiver Company Code
KEY	FiscalYear	I_FixedAssetPlanValue	FiscalYear	G/L Fiscal Year
KEY	MasterFixedAsset	I_FixedAssetPlanValue	MasterFixedAsset	Fixed Asset
KEY	FixedAsset	I_FixedAssetPlanValue	FixedAsset	Sub-number
KEY	AccountingDocument			Journal Entry
KEY	TransactionSubitem			Sub Transaction
KEY	Ledger	I_FixedAssetPlanValue	Ledger	Ledger
KEY	FiscalPeriod	I_FixedAssetPlanValue	FiscalPeriod	Tax period
KEY	SubLedgerAcctLineItemType	I_FixedAssetPlanValue	SubLedgerAcctLineItemType	SLALineItemType
KEY	AssetAcctTransClassfctn	I_FixedAssetPlanValue	AssetAcctTransClassfctn	Trans.Type Cat.
KEY	DebitCreditCode			Single-Character Flag
	LedgerFiscalYear
	FiscalYearVariant			FY Variant
	FiscalYearPeriod			Period/Year
	DepreciationFiscalPeriod	I_FixedAssetPlanValue	FiscalPeriod	Tax period
	AssetAcctAnlytlTransClassfctn	I_FixedAssetPlanValue	AssetAcctTransClassfctn	Trans.Type Cat.
	LedgerGroup	I_FixedAssetPlanValue	LedgerGroup	Ledger Group
	ChartOfAccounts			Node Class
	CountryChartOfAccounts			Chart of Accts
	GLAccount			General Ledger
	AlternativeGLAccount			Group Account
	GroupMasterFixedAsset	I_FixedAssetPlanValue	GroupMasterFixedAsset
	GroupFixedAsset	I_FixedAssetPlanValue	GroupFixedAsset
	FinancialAccountType	I_FixedAssetPlanValue	FinancialAccountType	Fin. Account Type
	ChartOfDepreciation	I_FixedAssetPlanValue	ChartOfDepreciation
	AccountingDocumentCreationDate			Journal Entry Date
	CreationTime			Time of Change
	AccountingDocCreatedByUser			User which created overhead document
	JointVentureCostRecoveryCode	I_FixedAssetPlanValue	JointVentureCostRecoveryCode	Recovery Ind.
	CostCenter			Cost Center
	Plant			Valuation Area
	BusinessArea			Business Area
	PersonnelNumber			Personnel No.
	FinancialManagementArea			FM Area
	Fund			Sender Fund
	GrantID			Sender Grant
	FunctionalArea			Sendr Fctl Area
	BudgetPeriod			Budget Period
	ProfitCenter			Profit Center
	Segment			Segment number
	FundsCenter			Funds Center
	AssetTransactionType			Trans.Type
	AssetDeactivationDate	_FixedAssetForLedger	AssetDeactivationDate
	ReferenceDocumentItem			Reference item
	ReferenceDocumentType			Reference Document Type
	LogicalSystem			Logical System
	ReferenceDocument			Reference Document
	ReferenceDocumentContext			Reference Document Context
	ReversalReferenceDocument			Reversal Reference Document
	ReversalReferenceDocumentCntxt			Reversal Reference Document Context
	ReversalTransactionSubitem			Reversal Sub Trans
	IsReversal			Reversal doc.
	IsReversed			Reversed?
	DocumentDate			Journal Entry Date
	PostingDate			Posting Date for GR
	AssetValueDate			Reference date
	AccountingDocumentType			Journal Entry Type
	AssignmentReference			Assignment Reference
	DocumentItemText			Text
	IsStatisticalDocument
	GLBusinessTransactionType			Transact. Type
	PartnerMasterFixedAsset			Partner Asset
	PartnerFixedAsset			Partner Sub-No.
	CompanyCodeCurrency	I_FixedAssetPlanValue	CompanyCodeCurrency	Local Currency
	GlobalCurrency	I_FixedAssetPlanValue	GlobalCurrency	GM Billing Element: Global Currency
	FreeDefinedCurrency1	I_FixedAssetPlanValue	FreeDefinedCurrency1	Freely Defined Currency 1
	FreeDefinedCurrency2	I_FixedAssetPlanValue	FreeDefinedCurrency2	Freely Defined Currency 2
	FreeDefinedCurrency3	I_FixedAssetPlanValue	FreeDefinedCurrency3	Freely Defined Currency 3
	FreeDefinedCurrency4	I_FixedAssetPlanValue	FreeDefinedCurrency4	Freely Defined Currency 4
	FreeDefinedCurrency5	I_FixedAssetPlanValue	FreeDefinedCurrency5	Freely Defined Currency 5
	FreeDefinedCurrency6	I_FixedAssetPlanValue	FreeDefinedCurrency6	Freely Defined Currency 6
	FreeDefinedCurrency7	I_FixedAssetPlanValue	FreeDefinedCurrency7	Freely Defined Currency 7
	FreeDefinedCurrency8	I_FixedAssetPlanValue	FreeDefinedCurrency8	Freely Defined Currency 8
	ActualAmountInCompanyCodeCrcy
	ActualAmountInGlobalCurrency
	ActualAmountInFreeDfndCrcy1
	ActualAmountInFreeDfndCrcy2
	ActualAmountInFreeDfndCrcy3
	ActualAmountInFreeDfndCrcy4
	ActualAmountInFreeDfndCrcy5
	ActualAmountInFreeDfndCrcy6
	ActualAmountInFreeDfndCrcy7
	ActualAmountInFreeDfndCrcy8
	PlanAmountInCompanyCodeCrcy
	PlanAmountInGlobalCurrency
	PlanAmountInFreeDefinedCrcy1
	PlanAmountInFreeDefinedCrcy2
	PlanAmountInFreeDefinedCrcy3
	PlanAmountInFreeDefinedCrcy4
	PlanAmountInFreeDefinedCrcy5
	PlanAmountInFreeDefinedCrcy6
	PlanAmountInFreeDefinedCrcy7
	PlanAmountInFreeDefinedCrcy8
	BaseUnit			Unit of Measure
	Quantity			Value
	IsPlanningDocument

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_FixedAssetValueWthDetn.
-- 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.
-- Parameters: P_AssetAccountingKeyFigureSet : faa_key_figure_set

CREATE VIEW P_FixedAssetValueWthDetn AS
SELECT
  lineitems.AssetDepreciationArea AS AssetDepreciationArea,
  lineitems.CompanyCode AS CompanyCode,
  lineitems.FiscalYear AS FiscalYear,
  lineitems.MasterFixedAsset AS MasterFixedAsset,
  lineitems.FixedAsset AS FixedAsset,
  lineitems.AccountingDocument AS AccountingDocument,
  lineitems.TransactionSubitem AS TransactionSubitem,
  lineitems.Ledger AS Ledger,
  lineitems.FiscalPeriod AS FiscalPeriod,
  lineitems.SubLedgerAcctLineItemType AS SubLedgerAcctLineItemType,
  lineitems.AssetAcctTransClassfctn AS AssetAcctTransClassfctn,
  DebitCreditCode,
  LedgerFiscalYear,
  FiscalYearVariant,
  FiscalYearPeriod,
  DepreciationFiscalPeriod,
  lineitems.LedgerGroup AS LedgerGroup,
  lineitems.ChartOfAccounts AS ChartOfAccounts,
  lineitems.CountryChartOfAccounts AS CountryChartOfAccounts,
  lineitems.GLAccount AS GLAccount,
  lineitems.AlternativeGLAccount AS AlternativeGLAccount,
  lineitems.GroupMasterFixedAsset AS GroupMasterFixedAsset,
  lineitems.GroupFixedAsset AS GroupFixedAsset,
  lineitems.FinancialAccountType AS FinancialAccountType,
  lineitems.ChartOfDepreciation AS ChartOfDepreciation,
  lineitems.AccountingDocumentCreationDate AS AccountingDocumentCreationDate,
  lineitems.CreationTime AS CreationTime,
  lineitems.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
  lineitems.JointVentureCostRecoveryCode AS JointVentureCostRecoveryCode,
  lineitems.CostCenter AS CostCenter,
  lineitems.Plant AS Plant,
  lineitems.BusinessArea AS BusinessArea,
  lineitems.PersonnelNumber AS PersonnelNumber,
  lineitems.FinancialManagementArea AS FinancialManagementArea,
  lineitems.Fund AS Fund,
  lineitems.GrantID AS GrantID,
  lineitems.FunctionalArea AS FunctionalArea,
  lineitems.BudgetPeriod AS BudgetPeriod,
  lineitems.ProfitCenter AS ProfitCenter,
  lineitems.Segment AS Segment,
  lineitems.FundsCenter AS FundsCenter,
  lineitems.AssetTransactionType AS AssetTransactionType,
  _FixedAssetForLedger.AssetDeactivationDate AS AssetDeactivationDate,
  lineitems.ReferenceDocumentItem AS ReferenceDocumentItem,
  lineitems.ReferenceDocumentType AS ReferenceDocumentType,
  lineitems.LogicalSystem AS LogicalSystem,
  lineitems.ReferenceDocument AS ReferenceDocument,
  lineitems.ReferenceDocumentContext AS ReferenceDocumentContext,
  lineitems.ReversalReferenceDocument AS ReversalReferenceDocument,
  lineitems.ReversalReferenceDocumentCntxt AS ReversalReferenceDocumentCntxt,
  lineitems.ReversalTransactionSubitem AS ReversalTransactionSubitem,
  lineitems.IsReversal AS IsReversal,
  lineitems.IsReversed AS IsReversed,
  lineitems.DocumentDate AS DocumentDate,
  lineitems.PostingDate AS PostingDate,
  lineitems.AssetValueDate AS AssetValueDate,
  lineitems.AccountingDocumentType AS AccountingDocumentType,
  lineitems.AssignmentReference AS AssignmentReference,
  lineitems.DocumentItemText AS DocumentItemText,
  lineitems.IsStatisticalDocument AS IsStatisticalDocument,
  lineitems.GLBusinessTransactionType AS GLBusinessTransactionType,
  lineitems.PartnerMasterFixedAsset AS PartnerMasterFixedAsset,
  lineitems.PartnerFixedAsset AS PartnerFixedAsset,
  lineitems.CompanyCodeCurrency AS CompanyCodeCurrency,
  lineitems.GlobalCurrency AS GlobalCurrency,
  lineitems.FreeDefinedCurrency1 AS FreeDefinedCurrency1,
  lineitems.FreeDefinedCurrency2 AS FreeDefinedCurrency2,
  lineitems.FreeDefinedCurrency3 AS FreeDefinedCurrency3,
  lineitems.FreeDefinedCurrency4 AS FreeDefinedCurrency4,
  lineitems.FreeDefinedCurrency5 AS FreeDefinedCurrency5,
  lineitems.FreeDefinedCurrency6 AS FreeDefinedCurrency6,
  lineitems.FreeDefinedCurrency7 AS FreeDefinedCurrency7,
  lineitems.FreeDefinedCurrency8 AS FreeDefinedCurrency8,
  cast(lineitems.AmountInCompanyCodeCurrency as fins_vhcur12) AS ActualAmountInCompanyCodeCrcy,
  cast(lineitems.AmountInGlobalCurrency as fins_vhcur12) AS ActualAmountInGlobalCurrency,
  cast(lineitems.AmountInFreeDefinedCurrency1 as fins_vhcur12) AS ActualAmountInFreeDfndCrcy1,
  cast(lineitems.AmountInFreeDefinedCurrency2 as fins_vhcur12) AS ActualAmountInFreeDfndCrcy2,
  cast(lineitems.AmountInFreeDefinedCurrency3 as fins_vhcur12) AS ActualAmountInFreeDfndCrcy3,
  cast(lineitems.AmountInFreeDefinedCurrency4 as fins_vhcur12) AS ActualAmountInFreeDfndCrcy4,
  cast(lineitems.AmountInFreeDefinedCurrency5 as fins_vhcur12) AS ActualAmountInFreeDfndCrcy5,
  cast(lineitems.AmountInFreeDefinedCurrency6 as fins_vhcur12) AS ActualAmountInFreeDfndCrcy6,
  cast(lineitems.AmountInFreeDefinedCurrency7 as fins_vhcur12) AS ActualAmountInFreeDfndCrcy7,
  cast(lineitems.AmountInFreeDefinedCurrency8 as fins_vhcur12) AS ActualAmountInFreeDfndCrcy8,
  cast('0' as fins_vhcur12) AS PlanAmountInCompanyCodeCrcy,
  cast('0' as fins_vhcur12) AS PlanAmountInGlobalCurrency,
  cast('0' as fins_vhcur12) AS PlanAmountInFreeDefinedCrcy1,
  cast('0' as fins_vhcur12) AS PlanAmountInFreeDefinedCrcy2,
  cast('0' as fins_vhcur12) AS PlanAmountInFreeDefinedCrcy3,
  cast('0' as fins_vhcur12) AS PlanAmountInFreeDefinedCrcy4,
  cast('0' as fins_vhcur12) AS PlanAmountInFreeDefinedCrcy5,
  cast('0' as fins_vhcur12) AS PlanAmountInFreeDefinedCrcy6,
  cast('0' as fins_vhcur12) AS PlanAmountInFreeDefinedCrcy7,
  cast('0' as fins_vhcur12) AS PlanAmountInFreeDefinedCrcy8,
  BaseUnit,
  Quantity,
  planvalues.AssetAcctTransClassfctn AS AssetAcctAnlytlTransClassfctn,
  cast ('X' as boolean) AS IsPlanningDocument
FROM I_FixedAssetLineItem AS lineitems
LEFT OUTER JOIN I_AssetKeyFigureTransTypeDetn AS determination ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_FixedAssetForLedger AS _FixedAssetForLedger ON _FixedAssetForLedger.CompanyCode = CompanyCode AND _FixedAssetForLedger.MasterFixedAsset = MasterFixedAsset AND _FixedAssetForLedger.FixedAsset = FixedAsset AND _FixedAssetForLedger.Ledger = Ledger  -- association [0..1]
-- UNION ALL with additional select branch(es): I_FixedAssetPlanValue
;

Depth:

P_FixedAssetValueWthDetn view