Which tables does P_GLAccountBalanceEnd_F0707A read from?

P_GLAccountBalanceEnd_F0707A reads data from: I_FiscalCalYearPeriodForLedger, I_GLAccountLineItem.

What VDM layer is P_GLAccountBalanceEnd_F0707A?

P_GLAccountBalanceEnd_F0707A is classified as a Consumption view optimized for specific business scenarios and reporting.

P_GLAccountBalanceEnd_F0707A

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

P_GLAccountBalanceEnd_F0707A is a consumption CDS view in SAP S/4HANA. It contains 86 fields.

DDL: P_GLACCOUNTBALANCEEND_F0707A Type: view_entity CONSUMPTION

86 Fields 2 Data Sources 1 Associations

P_GLAccountBalanceEnd_F0707A is a Consumption CDS View in SAP S/4HANA. It reads from 2 data sources (I_FiscalCalYearPeriodForLedger, I_GLAccountLineItem) and exposes 86 fields with key fields SourceLedger, CompanyCode, FiscalYear, AccountingDocument, LedgerGLLineItem. It has 1 association to related views.

Data Sources (2)

Source	Alias	Join Type
I_FiscalCalYearPeriodForLedger	I_FiscalCalYearPeriodForLedger	inner
I_GLAccountLineItem	I_GLAccountLineItem	from

Associations (1)

Cardinality	Target	Alias	Condition
[1..1]	E_JournalEntryItem	_Extension	`$projection.SourceLedger = _Extension.SourceLedger and $projection.CompanyCode = _Extension.CompanyCode and $projection.FiscalYear = _Extension.FiscalYear and $projection.AccountingDocument = _Extension.AccountingDocument and $projection.LedgerGLLineItem = _Extension.LedgerGLLineItem`

Annotations (7)

Name	Value	Level
AccessControl.authorizationCheck	#NOT_REQUIRED	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.serviceQuality	#X	view
ObjectModel.usageType.sizeCategory	#S	view
ObjectModel.usageType.dataClass	#MIXED	view
VDM.private	true	view
VDM.viewType	#CONSUMPTION	view

Fields (86)

Key	Field	Source Table	Source Field	Description
KEY	SourceLedger	I_GLAccountLineItem	SourceLedger	Source Ledger
KEY	CompanyCode	I_GLAccountLineItem	CompanyCode	Receiver Company Code
KEY	FiscalYear	I_GLAccountLineItem	FiscalYear	G/L Fiscal Year
KEY	AccountingDocument	I_GLAccountLineItem	AccountingDocument	Journal Entry
KEY	LedgerGLLineItem	I_GLAccountLineItem	LedgerGLLineItem	Journal Entry Item
KEY	Ledger	I_GLAccountLineItem	Ledger	Ledger
	FiscalYearVariant	I_GLAccountLineItem	FiscalYearVariant	FY Variant
	LedgerFiscalYear	I_GLAccountLineItem	LedgerFiscalYear
	FiscalYearPeriod	I_FiscalCalYearPeriodForLedger	FiscalYearPeriod	Period/Year
	FiscalPeriod	I_FiscalCalYearPeriodForLedger	FiscalPeriod	Tax period
	ChartOfAccounts	I_GLAccountLineItem	ChartOfAccounts	Node Class
	GLAccount	I_GLAccountLineItem	GLAccount	General Ledger
	ControllingArea	I_GLAccountLineItem	ControllingArea	Controlling Area
	ProfitCenter	I_GLAccountLineItem	ProfitCenter	Profit Center
	Segment	I_GLAccountLineItem	Segment	Segment number
	FunctionalArea	I_GLAccountLineItem	FunctionalArea	Sendr Fctl Area
	BusinessArea	I_GLAccountLineItem	BusinessArea	Business Area
	DebitCreditCode	I_GLAccountLineItem	DebitCreditCode	Single-Character Flag
	FinancialAccountType	I_GLAccountLineItem	FinancialAccountType	Fin. Account Type
	Supplier	I_GLAccountLineItem	Supplier	Supplier
	Customer	I_GLAccountLineItem	Customer	Sold-to Party
	AccountingDocumentType	I_GLAccountLineItem	AccountingDocumentType	Journal Entry Type
	CostCenter	I_GLAccountLineItem	CostCenter	Cost Center
	SalesDocument	I_GLAccountLineItem	SalesDocument	SD Document
	SalesOrganization	I_GLAccountLineItem	SalesOrganization	Sales Organization
	DistributionChannel	I_GLAccountLineItem	DistributionChannel	RefDistCh-Cust/Mat.
	OrganizationDivision	I_GLAccountLineItem	OrganizationDivision	Org. Division
	Plant	I_GLAccountLineItem	Plant	Valuation Area
	ValuationArea	I_GLAccountLineItem	ValuationArea	Valuation Area
	MasterFixedAsset	I_GLAccountLineItem	MasterFixedAsset	Fixed Asset
	FixedAsset	I_GLAccountLineItem	FixedAsset	Sub-number
	OrderID	I_GLAccountLineItem	OrderID	Order ID
	CompanyCodeCurrency	I_GLAccountLineItem	CompanyCodeCurrency	Local Currency
	EndingBalanceAmtInCoCodeCrcy	I_GLAccountLineItem	AmountInCompanyCodeCurrency	Local Crcy Amt
	GlobalCurrency	I_GLAccountLineItem	GlobalCurrency	GM Billing Element: Global Currency
	EndingBalanceAmtInGlobalCrcy	I_GLAccountLineItem	AmountInGlobalCurrency	Amount in Global Currency
	FunctionalCurrency	I_GLAccountLineItem	FunctionalCurrency	Functional Currency
	EndingBalanceAmtInFuncnlCrcy	I_GLAccountLineItem	AmountInFunctionalCurrency	Amount in Functional Currency
	FreeDefinedCurrency1	I_GLAccountLineItem	FreeDefinedCurrency1	Freely Defined Currency 1
	EndingBalAmtInFreeDfndCrcy1	I_GLAccountLineItem	AmountInFreeDefinedCurrency1	Amount in Freely Defined Currency 1
	FreeDefinedCurrency2	I_GLAccountLineItem	FreeDefinedCurrency2	Freely Defined Currency 2
	EndingBalAmtInFreeDfndCrcy2	I_GLAccountLineItem	AmountInFreeDefinedCurrency2	Amount in Freely Defined Currency 2
	FreeDefinedCurrency3	I_GLAccountLineItem	FreeDefinedCurrency3	Freely Defined Currency 3
	EndingBalAmtInFreeDfndCrcy3	I_GLAccountLineItem	AmountInFreeDefinedCurrency3	Amount in Freely Defined Currency 3
	FreeDefinedCurrency4	I_GLAccountLineItem	FreeDefinedCurrency4	Freely Defined Currency 4
	EndingBalAmtInFreeDfndCrcy4	I_GLAccountLineItem	AmountInFreeDefinedCurrency4	Amount in Freely Defined Currency 4
	FreeDefinedCurrency5	I_GLAccountLineItem	FreeDefinedCurrency5	Freely Defined Currency 5
	EndingBalAmtInFreeDfndCrcy5	I_GLAccountLineItem	AmountInFreeDefinedCurrency5	Amount in Freely Defined Currency 5
	FreeDefinedCurrency6	I_GLAccountLineItem	FreeDefinedCurrency6	Freely Defined Currency 6
	EndingBalAmtInFreeDfndCrcy6	I_GLAccountLineItem	AmountInFreeDefinedCurrency6	Amount in Freely Defined Currency 6
	FreeDefinedCurrency7	I_GLAccountLineItem	FreeDefinedCurrency7	Freely Defined Currency 7
	EndingBalAmtInFreeDfndCrcy7	I_GLAccountLineItem	AmountInFreeDefinedCurrency7	Amount in Freely Defined Currency 7
	FreeDefinedCurrency8	I_GLAccountLineItem	FreeDefinedCurrency8	Freely Defined Currency 8
	EndingBalAmtInFreeDfndCrcy8	I_GLAccountLineItem	AmountInFreeDefinedCurrency8	Amount in Freely Defined Currency 8
	_Ledger	I_GLAccountLineItem	_Ledger
	_SourceLedger	I_GLAccountLineItem	_SourceLedger
	_CompanyCode	I_GLAccountLineItem	_CompanyCode
	_FiscalYear	I_GLAccountLineItem	_FiscalYear
	_LedgerFiscalYearForVariant	I_GLAccountLineItem	_LedgerFiscalYearForVariant
	_FiscalYearVariant	I_GLAccountLineItem	_FiscalYearVariant
	_JournalEntry	I_GLAccountLineItem	_JournalEntry
	_Segment	I_GLAccountLineItem	_Segment
	_ProfitCenter	I_GLAccountLineItem	_ProfitCenter
	_CostCenter	I_GLAccountLineItem	_CostCenter
	_BusinessArea	I_GLAccountLineItem	_BusinessArea
	_FunctionalArea	I_GLAccountLineItem	_FunctionalArea
	_GLAccountInCompanyCode	I_GLAccountLineItem	_GLAccountInCompanyCode
	_ChartOfAccounts	I_GLAccountLineItem	_ChartOfAccounts
	_DebitCreditCode	I_GLAccountLineItem	_DebitCreditCode
	_CompanyCodeCurrency	I_GLAccountLineItem	_CompanyCodeCurrency
	_GlobalCurrency	I_GLAccountLineItem	_GlobalCurrency
	_FunctionalCurrency	I_GLAccountLineItem	_FunctionalCurrency
	_FreeDefinedCurrency1	I_GLAccountLineItem	_FreeDefinedCurrency1
	_FreeDefinedCurrency2	I_GLAccountLineItem	_FreeDefinedCurrency2
	_FreeDefinedCurrency3	I_GLAccountLineItem	_FreeDefinedCurrency3
	_FreeDefinedCurrency4	I_GLAccountLineItem	_FreeDefinedCurrency4
	_FreeDefinedCurrency5	I_GLAccountLineItem	_FreeDefinedCurrency5
	_FreeDefinedCurrency6	I_GLAccountLineItem	_FreeDefinedCurrency6
	_FreeDefinedCurrency7	I_GLAccountLineItem	_FreeDefinedCurrency7
	_FreeDefinedCurrency8	I_GLAccountLineItem	_FreeDefinedCurrency8
	_Supplier	I_GLAccountLineItem	_Supplier
	_Customer	I_GLAccountLineItem	_Customer
	_AccountingDocumentType	I_GLAccountLineItem	_AccountingDocumentType
	_SalesDocument	I_GLAccountLineItem	_SalesDocument
	_Order	I_GLAccountLineItem	_Order
	_FixedAsset	I_GLAccountLineItem	_FixedAsset

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_GLAccountBalanceEnd_F0707A.
-- 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_GLAccountBalanceEnd_F0707A AS
SELECT
  I_GLAccountLineItem.SourceLedger AS SourceLedger,
  I_GLAccountLineItem.CompanyCode AS CompanyCode,
  I_GLAccountLineItem.FiscalYear AS FiscalYear,
  I_GLAccountLineItem.AccountingDocument AS AccountingDocument,
  I_GLAccountLineItem.LedgerGLLineItem AS LedgerGLLineItem,
  I_GLAccountLineItem.Ledger AS Ledger,
  I_GLAccountLineItem.FiscalYearVariant AS FiscalYearVariant,
  I_GLAccountLineItem.LedgerFiscalYear AS LedgerFiscalYear,
  I_FiscalCalYearPeriodForLedger.FiscalYearPeriod AS FiscalYearPeriod,
  I_FiscalCalYearPeriodForLedger.FiscalPeriod AS FiscalPeriod,
  I_GLAccountLineItem.ChartOfAccounts AS ChartOfAccounts,
  I_GLAccountLineItem.GLAccount AS GLAccount,
  I_GLAccountLineItem.ControllingArea AS ControllingArea,
  I_GLAccountLineItem.ProfitCenter AS ProfitCenter,
  I_GLAccountLineItem.Segment AS Segment,
  I_GLAccountLineItem.FunctionalArea AS FunctionalArea,
  I_GLAccountLineItem.BusinessArea AS BusinessArea,
  I_GLAccountLineItem.DebitCreditCode AS DebitCreditCode,
  I_GLAccountLineItem.FinancialAccountType AS FinancialAccountType,
  I_GLAccountLineItem.Supplier AS Supplier,
  I_GLAccountLineItem.Customer AS Customer,
  I_GLAccountLineItem.AccountingDocumentType AS AccountingDocumentType,
  I_GLAccountLineItem.CostCenter AS CostCenter,
  I_GLAccountLineItem.SalesDocument AS SalesDocument,
  I_GLAccountLineItem.SalesOrganization AS SalesOrganization,
  I_GLAccountLineItem.DistributionChannel AS DistributionChannel,
  I_GLAccountLineItem.OrganizationDivision AS OrganizationDivision,
  I_GLAccountLineItem.Plant AS Plant,
  I_GLAccountLineItem.ValuationArea AS ValuationArea,
  I_GLAccountLineItem.MasterFixedAsset AS MasterFixedAsset,
  I_GLAccountLineItem.FixedAsset AS FixedAsset,
  I_GLAccountLineItem.OrderID AS OrderID,
  I_GLAccountLineItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  I_GLAccountLineItem.AmountInCompanyCodeCurrency AS EndingBalanceAmtInCoCodeCrcy,
  I_GLAccountLineItem.GlobalCurrency AS GlobalCurrency,
  I_GLAccountLineItem.AmountInGlobalCurrency AS EndingBalanceAmtInGlobalCrcy,
  I_GLAccountLineItem.FunctionalCurrency AS FunctionalCurrency,
  I_GLAccountLineItem.AmountInFunctionalCurrency AS EndingBalanceAmtInFuncnlCrcy,
  I_GLAccountLineItem.FreeDefinedCurrency1 AS FreeDefinedCurrency1,
  I_GLAccountLineItem.AmountInFreeDefinedCurrency1 AS EndingBalAmtInFreeDfndCrcy1,
  I_GLAccountLineItem.FreeDefinedCurrency2 AS FreeDefinedCurrency2,
  I_GLAccountLineItem.AmountInFreeDefinedCurrency2 AS EndingBalAmtInFreeDfndCrcy2,
  I_GLAccountLineItem.FreeDefinedCurrency3 AS FreeDefinedCurrency3,
  I_GLAccountLineItem.AmountInFreeDefinedCurrency3 AS EndingBalAmtInFreeDfndCrcy3,
  I_GLAccountLineItem.FreeDefinedCurrency4 AS FreeDefinedCurrency4,
  I_GLAccountLineItem.AmountInFreeDefinedCurrency4 AS EndingBalAmtInFreeDfndCrcy4,
  I_GLAccountLineItem.FreeDefinedCurrency5 AS FreeDefinedCurrency5,
  I_GLAccountLineItem.AmountInFreeDefinedCurrency5 AS EndingBalAmtInFreeDfndCrcy5,
  I_GLAccountLineItem.FreeDefinedCurrency6 AS FreeDefinedCurrency6,
  I_GLAccountLineItem.AmountInFreeDefinedCurrency6 AS EndingBalAmtInFreeDfndCrcy6,
  I_GLAccountLineItem.FreeDefinedCurrency7 AS FreeDefinedCurrency7,
  I_GLAccountLineItem.AmountInFreeDefinedCurrency7 AS EndingBalAmtInFreeDfndCrcy7,
  I_GLAccountLineItem.FreeDefinedCurrency8 AS FreeDefinedCurrency8,
  I_GLAccountLineItem.AmountInFreeDefinedCurrency8 AS EndingBalAmtInFreeDfndCrcy8,
  I_GLAccountLineItem._Ledger AS _Ledger,
  I_GLAccountLineItem._SourceLedger AS _SourceLedger,
  I_GLAccountLineItem._CompanyCode AS _CompanyCode,
  I_GLAccountLineItem._FiscalYear AS _FiscalYear,
  I_GLAccountLineItem._LedgerFiscalYearForVariant AS _LedgerFiscalYearForVariant,
  I_GLAccountLineItem._FiscalYearVariant AS _FiscalYearVariant,
  I_GLAccountLineItem._JournalEntry AS _JournalEntry,
  I_GLAccountLineItem._Segment AS _Segment,
  I_GLAccountLineItem._ProfitCenter AS _ProfitCenter,
  I_GLAccountLineItem._CostCenter AS _CostCenter,
  I_GLAccountLineItem._BusinessArea AS _BusinessArea,
  I_GLAccountLineItem._FunctionalArea AS _FunctionalArea,
  I_GLAccountLineItem._GLAccountInCompanyCode AS _GLAccountInCompanyCode,
  I_GLAccountLineItem._ChartOfAccounts AS _ChartOfAccounts,
  I_GLAccountLineItem._DebitCreditCode AS _DebitCreditCode,
  I_GLAccountLineItem._CompanyCodeCurrency AS _CompanyCodeCurrency,
  I_GLAccountLineItem._GlobalCurrency AS _GlobalCurrency,
  I_GLAccountLineItem._FunctionalCurrency AS _FunctionalCurrency,
  I_GLAccountLineItem._FreeDefinedCurrency1 AS _FreeDefinedCurrency1,
  I_GLAccountLineItem._FreeDefinedCurrency2 AS _FreeDefinedCurrency2,
  I_GLAccountLineItem._FreeDefinedCurrency3 AS _FreeDefinedCurrency3,
  I_GLAccountLineItem._FreeDefinedCurrency4 AS _FreeDefinedCurrency4,
  I_GLAccountLineItem._FreeDefinedCurrency5 AS _FreeDefinedCurrency5,
  I_GLAccountLineItem._FreeDefinedCurrency6 AS _FreeDefinedCurrency6,
  I_GLAccountLineItem._FreeDefinedCurrency7 AS _FreeDefinedCurrency7,
  I_GLAccountLineItem._FreeDefinedCurrency8 AS _FreeDefinedCurrency8,
  I_GLAccountLineItem._Supplier AS _Supplier,
  I_GLAccountLineItem._Customer AS _Customer,
  I_GLAccountLineItem._AccountingDocumentType AS _AccountingDocumentType,
  I_GLAccountLineItem._SalesDocument AS _SalesDocument,
  I_GLAccountLineItem._Order AS _Order,
  I_GLAccountLineItem._FixedAsset AS _FixedAsset
FROM I_GLAccountLineItem
INNER JOIN I_FiscalCalYearPeriodForLedger ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN E_JournalEntryItem AS _Extension ON SourceLedger = _Extension.SourceLedger AND CompanyCode = _Extension.CompanyCode AND FiscalYear = _Extension.FiscalYear AND AccountingDocument = _Extension.AccountingDocument AND LedgerGLLineItem = _Extension.LedgerGLLineItem  -- association [1..1]
;

Depth:

P_GLAccountBalanceEnd_F0707A view_entity

I_GLAccountLineItem view_entity
I_FiscalCalYearPeriodForLedger view