What VDM layer is P_FxdAstValueWithCurrencyRole?

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

P_FxdAstValueWithCurrencyRole

Q: What is P_FxdAstValueWithCurrencyRole in SAP S/4HANA?

P_FxdAstValueWithCurrencyRole is a composite CDS view in SAP S/4HANA. It contains 99 fields.

Q: Which tables does P_FxdAstValueWithCurrencyRole read from?

P_FxdAstValueWithCurrencyRole reads data from: I_FxdAstLineItemWithCrcyRole, I_FxdAstPlanValueWithCrcyRole, P_LedgerCompanyCodeCrcyRoles, P_LedgerCompanyCodeCrcyRoles.

DDL: P_FXDASTVALUEWITHCURRENCYROLE Type: view COMPOSITE

99 Fields 4 Data Sources

P_FxdAstValueWithCurrencyRole is a Composite CDS View in SAP S/4HANA. It reads from 4 data sources (I_FxdAstLineItemWithCrcyRole, I_FxdAstPlanValueWithCrcyRole, P_LedgerCompanyCodeCrcyRoles, P_LedgerCompanyCodeCrcyRoles) and exposes 99 fields with key fields CompanyCode, MasterFixedAsset, FixedAsset, FiscalYear, FiscalPeriod.

Data Sources (4)

Source	Alias	Join Type
I_FxdAstLineItemWithCrcyRole	I_FxdAstLineItemWithCrcyRole	from
I_FxdAstPlanValueWithCrcyRole	I_FxdAstPlanValueWithCrcyRole	union_all
P_LedgerCompanyCodeCrcyRoles	P_LedgerCompanyCodeCrcyRoles	inner
P_LedgerCompanyCodeCrcyRoles	P_LedgerCompanyCodeCrcyRoles	inner

Annotations (9)

Name	Value	Level
AbapCatalog.sqlViewName	PFASSETVALCRCYRL	view
AbapCatalog.preserveKey	true	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 (99)

Key	Field	Source Table	Source Field	Description
KEY	CompanyCode	I_FxdAstLineItemWithCrcyRole	CompanyCode	Receiver Company Code
KEY	MasterFixedAsset		MasterFixedAsset	Fixed Asset
KEY	FixedAsset		FixedAsset	Sub-number
KEY	FiscalYear		FiscalYear	G/L Fiscal Year
KEY	FiscalPeriod		FiscalPeriod	Tax period
KEY	SubLedgerAcctLineItemType		SubLedgerAcctLineItemType	SLALineItemType
KEY	AssetDepreciationArea		AssetDepreciationArea	Deprec. Area
KEY	LedgerGroup	I_FxdAstLineItemWithCrcyRole	LedgerGroup	Ledger Group
KEY	Ledger	I_FxdAstLineItemWithCrcyRole	Ledger	Ledger
KEY	AccountingDocument		AccountingDocument	Journal Entry
KEY	TransactionSubitem		TransactionSubitem	Sub Transaction
KEY	DebitCreditCode		DebitCreditCode	Single-Character Flag
KEY	CurrencyRole	P_LedgerCompanyCodeCrcyRoles	CurrencyRole	Curr./Val. Type
KEY	AssetAcctTransClassfctn		AssetAcctTransClassfctn	Trans.Type Cat.
	LedgerFiscalYear		LedgerFiscalYear
	FiscalYearVariant		FiscalYearVariant	FY Variant
	FiscalYearPeriod		FiscalYearPeriod	Period/Year
	ChartOfAccounts		ChartOfAccounts	Node Class
	GroupMasterFixedAsset		GroupMasterFixedAsset
	GroupFixedAsset		GroupFixedAsset
	ChartOfDepreciation	I_FxdAstLineItemWithCrcyRole	ChartOfDepreciation
	AssetValueDate		AssetValueDate	Reference date
	AssetTransactionType		AssetTransactionType	Trans.Type
	AssignmentReference		AssignmentReference	Assignment Reference
	DocumentItemText		DocumentItemText	Text
	ReferenceDocumentType		ReferenceDocumentType	Reference Document Type
	ReferenceDocument		ReferenceDocument	Reference Document
	LogicalSystem		LogicalSystem	Logical System
	ReferenceDocumentContext		ReferenceDocumentContext	Reference Document Context
	ReversalReferenceDocumentCntxt		ReversalReferenceDocumentCntxt	Reversal Reference Document Context
	ReversalReferenceDocument		ReversalReferenceDocument	Reversal Reference Document
	ReversalTransactionSubitem		ReversalTransactionSubitem	Reversal Sub Trans
	IsReversal		IsReversal	Reversal doc.
	IsReversed		IsReversed	Reversed?
	BusinessArea		BusinessArea	Business Area
	Segment		Segment	Segment number
	FinancialAccountType		FinancialAccountType	Fin. Account Type
	AccountingDocumentCreationDate		AccountingDocumentCreationDate	Journal Entry Date
	CreationTime		CreationTime	Time of Change
	PostingDate		PostingDate	Posting Date for GR
	DocumentDate		DocumentDate	Journal Entry Date
	AccountingDocCreatedByUser		AccountingDocCreatedByUser	User which created overhead document
	IsStatisticalDocument		IsStatisticalDocument
	ControllingArea		ControllingArea	Controlling Area
	FinancialManagementArea		FinancialManagementArea	FM Area
	Fund		Fund	Sender Fund
	GrantID		GrantID	Sender Grant
	FunctionalArea		FunctionalArea	Sendr Fctl Area
	BudgetPeriod		BudgetPeriod	Budget Period
	CompanyCode			Receiver Company Code
KEY	MasterFixedAsset		MasterFixedAsset	Fixed Asset
KEY	FixedAsset		FixedAsset	Sub-number
KEY	FiscalYear		FiscalYear	G/L Fiscal Year
KEY	FiscalPeriod		FiscalPeriod	Tax period
KEY	SubLedgerAcctLineItemType		SubLedgerAcctLineItemType	SLALineItemType
KEY	AssetDepreciationArea		AssetDepreciationArea	Deprec. Area
KEY	LedgerGroup	I_FxdAstPlanValueWithCrcyRole	LedgerGroup	Ledger Group
KEY	Ledger	I_FxdAstPlanValueWithCrcyRole	Ledger	Ledger
KEY	AccountingDocument			Journal Entry
KEY	TransactionSubitem			Sub Transaction
KEY	DebitCreditCode			Single-Character Flag
KEY	CurrencyRole	P_LedgerCompanyCodeCrcyRoles	CurrencyRole	Curr./Val. Type
KEY	AssetAcctTransClassfctn		AssetAcctTransClassfctn	Trans.Type Cat.
	LedgerFiscalYear
	FiscalYearVariant			FY Variant
	FiscalYearPeriod			Period/Year
	ChartOfAccounts			Node Class
	GroupMasterFixedAsset		GroupMasterFixedAsset
	GroupFixedAsset		GroupFixedAsset
	ChartOfDepreciation	I_FxdAstPlanValueWithCrcyRole	ChartOfDepreciation
	AssetValueDate			Reference date
	AssetTransactionType			Trans.Type
	AssignmentReference			Assignment Reference
	DocumentItemText			Text
	ReferenceDocumentType			Reference Document Type
	ReferenceDocument			Reference Document
	LogicalSystem			Logical System
	ReferenceDocumentContext			Reference Document Context
	ReversalReferenceDocumentCntxt			Reversal Reference Document Context
	ReversalReferenceDocument			Reversal Reference Document
	ReversalTransactionSubitem			Reversal Sub Trans
	IsReversal			Reversal doc.
	IsReversed			Reversed?
	BusinessArea			Business Area
	Segment			Segment number
	FinancialAccountType		FinancialAccountType	Fin. Account Type
	AccountingDocumentCreationDate			Journal Entry Date
	CreationTime			Time of Change
	PostingDate			Posting Date for GR
	DocumentDate			Journal Entry Date
	AccountingDocCreatedByUser			User which created overhead document
	IsStatisticalDocument
	ControllingArea			Controlling Area
	FinancialManagementArea			FM Area
	Fund			Sender Fund
	GrantID			Sender Grant
	FunctionalArea			Sendr Fctl Area
	BudgetPeriod			Budget Period
	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_FxdAstValueWithCurrencyRole.
-- 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.

CREATE VIEW P_FxdAstValueWithCurrencyRole AS
SELECT
  I_FxdAstLineItemWithCrcyRole.CompanyCode AS CompanyCode,
  MasterFixedAsset,
  FixedAsset,
  FiscalYear,
  FiscalPeriod,
  SubLedgerAcctLineItemType,
  AssetDepreciationArea,
  I_FxdAstLineItemWithCrcyRole.LedgerGroup AS LedgerGroup,
  I_FxdAstLineItemWithCrcyRole.Ledger AS Ledger,
  AccountingDocument,
  TransactionSubitem,
  DebitCreditCode,
  P_LedgerCompanyCodeCrcyRoles.CurrencyRole AS CurrencyRole,
  AssetAcctTransClassfctn,
  LedgerFiscalYear,
  FiscalYearVariant,
  FiscalYearPeriod,
  ChartOfAccounts,
  GroupMasterFixedAsset,
  GroupFixedAsset,
  I_FxdAstLineItemWithCrcyRole.ChartOfDepreciation AS ChartOfDepreciation,
  AssetValueDate,
  AssetTransactionType,
  AssignmentReference,
  DocumentItemText,
  ReferenceDocumentType,
  ReferenceDocument,
  LogicalSystem,
  ReferenceDocumentContext,
  ReversalReferenceDocumentCntxt,
  ReversalReferenceDocument,
  ReversalTransactionSubitem,
  IsReversal,
  IsReversed,
  BusinessArea,
  Segment,
  FinancialAccountType,
  AccountingDocumentCreationDate,
  CreationTime,
  PostingDate,
  DocumentDate,
  AccountingDocCreatedByUser,
  IsStatisticalDocument,
  ControllingArea,
  FinancialManagementArea,
  Fund,
  GrantID,
  FunctionalArea,
  BudgetPeriod,
  cast ('X' as boolean) AS IsPlanningDocument
FROM I_FxdAstLineItemWithCrcyRole
INNER JOIN P_LedgerCompanyCodeCrcyRoles ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): I_FxdAstPlanValueWithCrcyRole
;

Depth:

P_FxdAstValueWithCurrencyRole view

P_FixedAssetDepreciationListKF view
P_FixedAssetTransaction view