What is P_AssetHistorySheetCube1 in SAP S/4HANA?

P_AssetHistorySheetCube1 is a composite CDS view in SAP S/4HANA. It contains 121 fields.

Which tables does P_AssetHistorySheetCube1 read from?

P_AssetHistorySheetCube1 reads data from: I_AssetKeyFigureSetSpec, P_AssetHistorySheetCube2, P_AssetHistorySheetCube2.

What VDM layer is P_AssetHistorySheetCube1?

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

P_AssetHistorySheetCube1

DDL: P_ASSETHISTORYSHEETCUBE1 Type: view_entity COMPOSITE

121 Fields 3 Data Sources

P_AssetHistorySheetCube1 is a Composite CDS View in SAP S/4HANA. It reads from 3 data sources (I_AssetKeyFigureSetSpec, P_AssetHistorySheetCube2, P_AssetHistorySheetCube2) and exposes 121 fields with key fields CompanyCode, AssetDepreciationArea, MasterFixedAsset, FixedAsset, Ledger.

Data Sources (3)

Source	Alias	Join Type
I_AssetKeyFigureSetSpec	AssetKeyFigureSetSpec	inner
P_AssetHistorySheetCube2	P_AssetHistorySheetCube2	from
P_AssetHistorySheetCube2	P_AssetHistorySheetCube2	union_all

Parameters (3)

Name	Type	Default
P_AssetAccountingKeyFigureSet	faa_key_figure_set
P_FiscalYear	fis_gjahr
P_FiscalPeriod	fis_poper

Annotations (4)

Name	Value	Level
AccessControl.authorizationCheck	#NOT_REQUIRED	view
VDM.viewType	#COMPOSITE	view
VDM.private	true	view
Metadata.ignorePropagatedAnnotations	true	view

Fields (121)

Key	Field	Source Table	Source Field	Description
KEY	CompanyCode		CompanyCode	Receiver Company Code
KEY	AssetDepreciationArea		AssetDepreciationArea	Deprec. Area
KEY	MasterFixedAsset		MasterFixedAsset	Fixed Asset
KEY	FixedAsset		FixedAsset	Sub-number
KEY	Ledger		Ledger	Ledger
KEY	FiscalYear		FiscalYear	G/L Fiscal Year
KEY	FiscalPeriod		FiscalPeriod	Tax period
KEY	SubLedgerAcctLineItemType		SubLedgerAcctLineItemType	SLALineItemType
KEY	AssetAcctTransClassfctn		AssetAcctTransClassfctn	Trans.Type Cat.
KEY	AssetAccountingKeyFigure		AssetAccountingKeyFigure	Key Figure
KEY	AssetAccountingKeyFigureSet		AssetAccountingKeyFigureSet	Key Figure Group
KEY	AccountingDocument		AccountingDocument	Journal Entry
KEY	LedgerGLLineItem		LedgerGLLineItem	Journal Entry Item
KEY	TransactionSubitem		TransactionSubitem	Sub Transaction
KEY	DebitCreditCode		DebitCreditCode	Single-Character Flag
KEY	CurrencyRole		CurrencyRole	Curr./Val. Type
KEY	KeyFigureIsZeroBalance
	LedgerFiscalYear		LedgerFiscalYear
	FiscalYearVariant		FiscalYearVariant	FY Variant
	FiscalYearPeriod		FiscalYearPeriod	Period/Year
	DepreciationFiscalPeriod		DepreciationFiscalPeriod	Deprec. Period
	PostingDate		PostingDate	Posting Date for GR
	ChartOfDepreciation		ChartOfDepreciation
	AssetAccountingSortedKeyFigure		AssetAccountingSortedKeyFigure	KF Code
	ChartOfAccounts		ChartOfAccounts	Node Class
	ControllingArea		ControllingArea	Controlling Area
	Country		Country	Venue: Ctry/Reg
	CountryChartOfAccounts		CountryChartOfAccounts	Chart of Accts
	FinancialManagementArea		FinancialManagementArea	FM Area
	FinancialStatementVariant		FinancialStatementVariant
	AccountingPrinciple		AccountingPrinciple	AP Ledger/CoCode
	LedgerGroup		LedgerGroup	Ledger Group
	GLAccount		GLAccount	General Ledger
	AlternativeGLAccount		AlternativeGLAccount	Group Account
	GroupMasterFixedAsset		GroupMasterFixedAsset
	GroupFixedAsset		GroupFixedAsset
	FinancialAccountType		FinancialAccountType	Fin. Account Type
	AccountingDocumentCreationDate		AccountingDocumentCreationDate	Journal Entry Date
	CreationTime		CreationTime	Time of Change
	JointVentureCostRecoveryCode		JointVentureCostRecoveryCode	Recovery Ind.
	CostCenter		CostCenter	Cost Center
	Plant		Plant	Valuation Area
	BusinessArea		BusinessArea	Business Area
	PersonnelNumber		PersonnelNumber	Personnel No.
	Fund		Fund	Sender Fund
	ProfitCenter		ProfitCenter	Profit Center
	Segment		Segment	Segment number
	FunctionalArea		FunctionalArea	Sendr Fctl Area
	FundsCenter		FundsCenter	Funds Center
	AssetTransactionType		AssetTransactionType	Trans.Type
	GrantID		GrantID	Sender Grant
	BudgetPeriod		BudgetPeriod	Budget Period
	BusinessTransactionType		BusinessTransactionType	Bus.transaction
	BusinessTransactionCategory		BusinessTransactionCategory	Business Transaction Category
	FinancialClosingStep		FinancialClosingStep	Closing Step
	DisplayCurrency		DisplayCurrency	Display Currency
	AmountInDisplayCurrency		AmountInDisplayCurrency
	SelectedCurrencyBranch		SelectedCurrencyBranch
	BaseUnit		BaseUnit	Unit of Measure
	P_AssetAccountingKeyFigureSet
	P_FiscalYear
	CompanyCode			Receiver Company Code
KEY	AssetDepreciationArea	P_AssetHistorySheetCube2	AssetDepreciationArea	Deprec. Area
KEY	MasterFixedAsset	P_AssetHistorySheetCube2	MasterFixedAsset	Fixed Asset
KEY	FixedAsset	P_AssetHistorySheetCube2	FixedAsset	Sub-number
KEY	Ledger	P_AssetHistorySheetCube2	Ledger	Ledger
KEY	FiscalYear	P_AssetHistorySheetCube2	FiscalYear	G/L Fiscal Year
KEY	FiscalPeriod	P_AssetHistorySheetCube2	FiscalPeriod	Tax period
KEY	SubLedgerAcctLineItemType	P_AssetHistorySheetCube2	SubLedgerAcctLineItemType	SLALineItemType
KEY	AssetAcctTransClassfctn	P_AssetHistorySheetCube2	AssetAcctTransClassfctn	Trans.Type Cat.
KEY	AssetAccountingKeyFigure	I_AssetKeyFigureSetSpec	AssetAccountingKeyFigure	Key Figure
KEY	AssetAccountingKeyFigureSet	I_AssetKeyFigureSetSpec	AssetAccountingKeyFigureSet	Key Figure Group
KEY	AccountingDocument	P_AssetHistorySheetCube2	AccountingDocument	Journal Entry
KEY	LedgerGLLineItem	P_AssetHistorySheetCube2	LedgerGLLineItem	Journal Entry Item
KEY	TransactionSubitem	P_AssetHistorySheetCube2	TransactionSubitem	Sub Transaction
KEY	DebitCreditCode	P_AssetHistorySheetCube2	DebitCreditCode	Single-Character Flag
KEY	CurrencyRole	P_AssetHistorySheetCube2	CurrencyRole	Curr./Val. Type
KEY	KeyFigureIsZeroBalance
	LedgerFiscalYear	P_AssetHistorySheetCube2	LedgerFiscalYear
	FiscalYearVariant	P_AssetHistorySheetCube2	FiscalYearVariant	FY Variant
	FiscalYearPeriod	P_AssetHistorySheetCube2	FiscalYearPeriod	Period/Year
	DepreciationFiscalPeriod	P_AssetHistorySheetCube2	DepreciationFiscalPeriod	Deprec. Period
	PostingDate	P_AssetHistorySheetCube2	PostingDate	Posting Date for GR
	ChartOfDepreciation	P_AssetHistorySheetCube2	ChartOfDepreciation
	AssetAccountingSortedKeyFigure	I_AssetKeyFigureSetSpec	AssetAccountingSortedKeyFigure	KF Code
	ChartOfAccounts	P_AssetHistorySheetCube2	ChartOfAccounts	Node Class
	ControllingArea	P_AssetHistorySheetCube2	ControllingArea	Controlling Area
	Country	P_AssetHistorySheetCube2	Country	Venue: Ctry/Reg
	CountryChartOfAccounts	P_AssetHistorySheetCube2	CountryChartOfAccounts	Chart of Accts
	FinancialManagementArea	P_AssetHistorySheetCube2	FinancialManagementArea	FM Area
	FinancialStatementVariant	P_AssetHistorySheetCube2	FinancialStatementVariant
	AccountingPrinciple	P_AssetHistorySheetCube2	AccountingPrinciple	AP Ledger/CoCode
	LedgerGroup	P_AssetHistorySheetCube2	LedgerGroup	Ledger Group
	GLAccount	P_AssetHistorySheetCube2	GLAccount	General Ledger
	AlternativeGLAccount	P_AssetHistorySheetCube2	AlternativeGLAccount	Group Account
	GroupMasterFixedAsset	P_AssetHistorySheetCube2	GroupMasterFixedAsset
	GroupFixedAsset	P_AssetHistorySheetCube2	GroupFixedAsset
	FinancialAccountType	P_AssetHistorySheetCube2	FinancialAccountType	Fin. Account Type
	AccountingDocumentCreationDate	P_AssetHistorySheetCube2	AccountingDocumentCreationDate	Journal Entry Date
	CreationTime	P_AssetHistorySheetCube2	CreationTime	Time of Change
	JointVentureCostRecoveryCode	P_AssetHistorySheetCube2	JointVentureCostRecoveryCode	Recovery Ind.
	CostCenter	P_AssetHistorySheetCube2	CostCenter	Cost Center
	Plant	P_AssetHistorySheetCube2	Plant	Valuation Area
	BusinessArea	P_AssetHistorySheetCube2	BusinessArea	Business Area
	PersonnelNumber	P_AssetHistorySheetCube2	PersonnelNumber	Personnel No.
	Fund	P_AssetHistorySheetCube2	Fund	Sender Fund
	ProfitCenter	P_AssetHistorySheetCube2	ProfitCenter	Profit Center
	Segment	P_AssetHistorySheetCube2	Segment	Segment number
	FunctionalArea	P_AssetHistorySheetCube2	FunctionalArea	Sendr Fctl Area
	FundsCenter	P_AssetHistorySheetCube2	FundsCenter	Funds Center
	AssetTransactionType	P_AssetHistorySheetCube2	AssetTransactionType	Trans.Type
	GrantID	P_AssetHistorySheetCube2	GrantID	Sender Grant
	BudgetPeriod	P_AssetHistorySheetCube2	BudgetPeriod	Budget Period
	BusinessTransactionType	P_AssetHistorySheetCube2	BusinessTransactionType	Bus.transaction
	BusinessTransactionCategory	P_AssetHistorySheetCube2	BusinessTransactionCategory	Business Transaction Category
	FinancialClosingStep	P_AssetHistorySheetCube2	FinancialClosingStep	Closing Step
	DisplayCurrency	P_AssetHistorySheetCube2	DisplayCurrency	Display Currency
	AmountInDisplayCurrency
	SelectedCurrencyBranch	P_AssetHistorySheetCube2	SelectedCurrencyBranch
	BaseUnit	P_AssetHistorySheetCube2	BaseUnit	Unit of Measure
	Quantity

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_AssetHistorySheetCube1.
-- 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, P_FiscalYear : fis_gjahr, P_FiscalPeriod : fis_poper

CREATE VIEW P_AssetHistorySheetCube1 AS
SELECT
  CompanyCode,
  AssetDepreciationArea,
  MasterFixedAsset,
  FixedAsset,
  Ledger,
  FiscalYear,
  FiscalPeriod,
  SubLedgerAcctLineItemType,
  AssetAcctTransClassfctn,
  AssetAccountingKeyFigure,
  AssetAccountingKeyFigureSet,
  AccountingDocument,
  LedgerGLLineItem,
  TransactionSubitem,
  DebitCreditCode,
  CurrencyRole,
  cast('' as boolean preserving type) AS KeyFigureIsZeroBalance,
  LedgerFiscalYear,
  FiscalYearVariant,
  FiscalYearPeriod,
  DepreciationFiscalPeriod,
  PostingDate,
  ChartOfDepreciation,
  AssetAccountingSortedKeyFigure,
  ChartOfAccounts,
  ControllingArea,
  Country,
  CountryChartOfAccounts,
  FinancialManagementArea,
  FinancialStatementVariant,
  AccountingPrinciple,
  LedgerGroup,
  GLAccount,
  AlternativeGLAccount,
  GroupMasterFixedAsset,
  GroupFixedAsset,
  FinancialAccountType,
  AccountingDocumentCreationDate,
  CreationTime,
  JointVentureCostRecoveryCode,
  CostCenter,
  Plant,
  BusinessArea,
  PersonnelNumber,
  Fund,
  ProfitCenter,
  Segment,
  FunctionalArea,
  FundsCenter,
  AssetTransactionType,
  GrantID,
  BudgetPeriod,
  BusinessTransactionType,
  BusinessTransactionCategory,
  FinancialClosingStep,
  DisplayCurrency,
  AmountInDisplayCurrency,
  SelectedCurrencyBranch,
  BaseUnit,
  Quantity AS P_AssetAccountingKeyFigureSet,
  P_FiscalYear: $parameters.P_FiscalYear AS P_FiscalYear,
  cast (0 as quan1_12) AS Quantity
FROM P_AssetHistorySheetCube2
INNER JOIN I_AssetKeyFigureSetSpec AS AssetKeyFigureSetSpec ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): P_AssetHistorySheetCube2
;

Depth:

P_AssetHistorySheetCube1 view_entity

I_AssetHistorySheetCube view_entity