What is P_AssetBalanceLineItem in SAP S/4HANA?

P_AssetBalanceLineItem is a composite CDS view in SAP S/4HANA. It contains 62 fields.

Which tables does P_AssetBalanceLineItem read from?

P_AssetBalanceLineItem reads data from: P_AssetBalanceLineItem1.

What VDM layer is P_AssetBalanceLineItem?

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

P_AssetBalanceLineItem

DDL: P_ASSETBALANCELINEITEM SQL: PASSTBALINEITMS Type: view COMPOSITE

62 Fields 1 Data Sources

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

Data Sources (1)

Source	Alias	Join Type
P_AssetBalanceLineItem1	LineItems	from

Annotations (7)

Name	Value	Level
AbapCatalog.sqlViewName	PASSTBALINEITMS	view
AbapCatalog.preserveKey	true	view
AbapCatalog.compiler.compareFilter	true	view
VDM.viewType	#COMPOSITE	view
VDM.private	true	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view

Fields (62)

Key	Field	Source Table	Source Field	Description
KEY	AssetDepreciationArea	P_AssetBalanceLineItem1	AssetDepreciationArea	Deprec. Area
KEY	CompanyCode	P_AssetBalanceLineItem1	CompanyCode	Receiver Company Code
KEY	FiscalYear	P_AssetBalanceLineItem1	LedgerFiscalYear
KEY	MasterFixedAsset	P_AssetBalanceLineItem1	MasterFixedAsset	Fixed Asset
KEY	FixedAsset	P_AssetBalanceLineItem1	FixedAsset	Sub-number
KEY	Ledger	P_AssetBalanceLineItem1	Ledger	Ledger
KEY	FiscalPeriod	P_AssetBalanceLineItem1	FiscalPeriod	Tax period
KEY	SubLedgerAcctLineItemType	P_AssetBalanceLineItem1	SubLedgerAcctLineItemType	SLALineItemType
KEY	AssetAcctTransClassfctn	P_AssetBalanceLineItem1	AssetAcctTransClassfctn	Trans.Type Cat.
KEY	AccountingDocument	P_AssetBalanceLineItem1	AccountingDocument	Journal Entry
KEY	TransactionSubitem	P_AssetBalanceLineItem1	TransactionSubitem	Sub Transaction
KEY	DebitCreditCode	P_AssetBalanceLineItem1	DebitCreditCode	Single-Character Flag
	LedgerGroup	P_AssetBalanceLineItem1	LedgerGroup	Ledger Group
	GLAccount	P_AssetBalanceLineItem1	GLAccount	General Ledger
	GroupMasterFixedAsset	P_AssetBalanceLineItem1	GroupMasterFixedAsset
	GroupFixedAsset	P_AssetBalanceLineItem1	GroupFixedAsset
	FinancialAccountType	P_AssetBalanceLineItem1	FinancialAccountType	Fin. Account Type
	ChartOfDepreciation	P_AssetBalanceLineItem1	ChartOfDepreciation
	AccountingDocumentCreationDate	P_AssetBalanceLineItem1	AccountingDocumentCreationDate	Journal Entry Date
	CreationTime	P_AssetBalanceLineItem1	CreationTime	Time of Change
	JointVentureCostRecoveryCode	P_AssetBalanceLineItem1	JointVentureCostRecoveryCode	Recovery Ind.
	CostCenter	P_AssetBalanceLineItem1	CostCenter	Cost Center
	Plant	P_AssetBalanceLineItem1	Plant	Valuation Area
	BusinessArea	P_AssetBalanceLineItem1	BusinessArea	Business Area
	PersonnelNumber	P_AssetBalanceLineItem1	PersonnelNumber	Personnel No.
	Fund	P_AssetBalanceLineItem1	Fund	Sender Fund
	ProfitCenter	P_AssetBalanceLineItem1	ProfitCenter	Profit Center
	Segment	P_AssetBalanceLineItem1	Segment	Segment number
	FunctionalArea	P_AssetBalanceLineItem1	FunctionalArea	Sendr Fctl Area
	PostingDate	P_AssetBalanceLineItem1	PostingDate	Posting Date for GR
	AssetTransactionType	P_AssetBalanceLineItem1	AssetTransactionType	Trans.Type
	DepreciationFiscalPeriod	P_AssetBalanceLineItem1	DepreciationFiscalPeriod	Deprec. Period
	CompanyCodeCurrency	P_AssetBalanceLineItem1	CompanyCodeCurrency	Local Currency
	GlobalCurrency	P_AssetBalanceLineItem1	GlobalCurrency	GM Billing Element: Global Currency
	FreeDefinedCurrency1	P_AssetBalanceLineItem1	FreeDefinedCurrency1	Freely Defined Currency 1
	FreeDefinedCurrency2	P_AssetBalanceLineItem1	FreeDefinedCurrency2	Freely Defined Currency 2
	FreeDefinedCurrency3	P_AssetBalanceLineItem1	FreeDefinedCurrency3	Freely Defined Currency 3
	FreeDefinedCurrency4	P_AssetBalanceLineItem1	FreeDefinedCurrency4	Freely Defined Currency 4
	FreeDefinedCurrency5	P_AssetBalanceLineItem1	FreeDefinedCurrency5	Freely Defined Currency 5
	FreeDefinedCurrency6	P_AssetBalanceLineItem1	FreeDefinedCurrency6	Freely Defined Currency 6
	FreeDefinedCurrency7	P_AssetBalanceLineItem1	FreeDefinedCurrency7	Freely Defined Currency 7
	FreeDefinedCurrency8	P_AssetBalanceLineItem1	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_AssetBalanceLineItem.
-- 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: PASSTBALINEITMS

CREATE VIEW P_AssetBalanceLineItem AS
SELECT
  LineItems.AssetDepreciationArea AS AssetDepreciationArea,
  LineItems.CompanyCode AS CompanyCode,
  LineItems.LedgerFiscalYear 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.PostingDate AS PostingDate,
  LineItems.AssetTransactionType AS AssetTransactionType,
  LineItems.DepreciationFiscalPeriod AS DepreciationFiscalPeriod,
  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 P_AssetBalanceLineItem1 AS LineItems
;

Depth:

P_AssetBalanceLineItem view

P_AssetBalanceLineItem1 view

I_ActualAssetBalWithTmpPlanVal view_entity