What is P_FixedAssetLineItem in SAP S/4HANA?

P_FixedAssetLineItem is a composite CDS view in SAP S/4HANA. It contains 60 fields.

Which tables does P_FixedAssetLineItem read from?

P_FixedAssetLineItem reads data from: I_FixedAssetLineItem.

What VDM layer is P_FixedAssetLineItem?

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

P_FixedAssetLineItem

DDL: P_FIXEDASSETLINEITEM SQL: PFALINEITEMS Type: view COMPOSITE

60 Fields 1 Data Sources

P_FixedAssetLineItem is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_FixedAssetLineItem) and exposes 60 fields with key fields AssetDepreciationArea, CompanyCode, FiscalYear, MasterFixedAsset, FixedAsset.

Data Sources (1)

Source	Alias	Join Type
I_FixedAssetLineItem	lineitems	from

Parameters (1)

Name	Type	Default
P_FirstFiscalYear	gjahr

Annotations (5)

Name	Value	Level
AbapCatalog.sqlViewName	PFALINEITEMS	view
VDM.viewType	#COMPOSITE	view
VDM.private	true	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view

Fields (60)

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	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	AccountingDocument	I_FixedAssetLineItem	AccountingDocument	Journal Entry
KEY	TransactionSubitem	I_FixedAssetLineItem	TransactionSubitem	Sub Transaction
KEY	DebitCreditCode	I_FixedAssetLineItem	DebitCreditCode	Single-Character Flag
	LedgerGroup	I_FixedAssetLineItem	LedgerGroup	Ledger Group
	GLAccount	I_FixedAssetLineItem	GLAccount	General Ledger
	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
	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.
	Fund	I_FixedAssetLineItem	Fund	Sender Fund
	ProfitCenter	I_FixedAssetLineItem	ProfitCenter	Profit Center
	Segment	I_FixedAssetLineItem	Segment	Segment number
	FunctionalArea	I_FixedAssetLineItem	FunctionalArea	Sendr Fctl Area
	AssetTransactionType	I_FixedAssetLineItem	AssetTransactionType	Trans.Type
	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

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_FixedAssetLineItem.
-- 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: PFALINEITEMS
-- Parameters: P_FirstFiscalYear : gjahr

CREATE VIEW P_FixedAssetLineItem AS
SELECT
  lineitems.AssetDepreciationArea AS AssetDepreciationArea,
  lineitems.CompanyCode AS CompanyCode,
  lineitems.FiscalYear AS FiscalYear,
  lineitems.MasterFixedAsset AS MasterFixedAsset,
  lineitems.FixedAsset AS FixedAsset,
  lineitems.Ledger AS Ledger,
  lineitems.FiscalPeriod AS FiscalPeriod,
  lineitems.SubLedgerAcctLineItemType AS SubLedgerAcctLineItemType,
  lineitems.AssetAcctTransClassfctn AS AssetAcctTransClassfctn,
  lineitems.AccountingDocument AS AccountingDocument,
  lineitems.TransactionSubitem AS TransactionSubitem,
  lineitems.DebitCreditCode AS DebitCreditCode,
  lineitems.LedgerGroup AS LedgerGroup,
  lineitems.GLAccount AS GLAccount,
  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.JointVentureCostRecoveryCode AS JointVentureCostRecoveryCode,
  lineitems.CostCenter AS CostCenter,
  lineitems.Plant AS Plant,
  lineitems.BusinessArea AS BusinessArea,
  lineitems.PersonnelNumber AS PersonnelNumber,
  lineitems.Fund AS Fund,
  lineitems.ProfitCenter AS ProfitCenter,
  lineitems.Segment AS Segment,
  lineitems.FunctionalArea AS FunctionalArea,
  lineitems.AssetTransactionType AS AssetTransactionType,
  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
FROM I_FixedAssetLineItem AS lineitems
;

Depth:

P_FixedAssetLineItem view

I_FixedAssetLineItem view

I_FixedAssetValWithTmpPlanVal view