What is P_MX_FinStmntWthTrialBalance2 in SAP S/4HANA?

P_MX_FinStmntWthTrialBalance2 is a composite CDS view in SAP S/4HANA. MX Financial Statement with Trial Balance It contains 70 fields.

Which tables does P_MX_FinStmntWthTrialBalance2 read from?

P_MX_FinStmntWthTrialBalance2 reads data from: P_MX_FinStmntWthTrialBalance.

What VDM layer is P_MX_FinStmntWthTrialBalance2?

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

P_MX_FinStmntWthTrialBalance2

DDL: P_MX_FINSTMNTWTHTRIALBALANCE2 SQL: PMXFINSTMTTRLBL2 Type: view COMPOSITE Package: GLO_FIN_IS_VAT_MX

70 Fields 1 Data Sources

MX Financial Statement with Trial Balance

P_MX_FinStmntWthTrialBalance2 is a Composite CDS View that provides data about "MX Financial Statement with Trial Balance" in SAP S/4HANA. It reads from 1 data source (P_MX_FinStmntWthTrialBalance) and exposes 70 fields with key fields HierarchyNodeUniqueID, FinancialStatementVariant, ChartOfAccounts, ValidityEndDate, CompanyCode. Part of development package GLO_FIN_IS_VAT_MX.

Data Sources (1)

Source	Alias	Join Type
P_MX_FinStmntWthTrialBalance	P_MX_FinStmntWthTrialBalance	from

Parameters (7)

Name	Type	Default
P_FromPostingDate	fis_budat_from
P_ToPostingDate	fis_budat_to
P_FromFiscalPeriod	fis_period_from
P_ToFiscalPeriod	fis_period_to
P_FinancialStatementVariant	versn_011
P_AlternativeGLAccount	figlmx_prim
P_FiscalYear	fis_gjahr

Annotations (6)

Name	Value	Level
AbapCatalog.sqlViewName	PMXFINSTMTTRLBL2	view
VDM.viewType	#COMPOSITE	view
VDM.private	true	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
ClientHandling.algorithm	#SESSION_VARIABLE	view

Fields (70)

Key	Field	Source Table	Source Field	Description
KEY	HierarchyNodeUniqueID	TrialBalance	HierarchyNodeUniqueID	Node
KEY	FinancialStatementVariant	TrialBalance	FinancialStatementVariant	Hierarchy ID
KEY	ChartOfAccounts	TrialBalance	ChartOfAccounts	Node Class
KEY	ValidityEndDate	TrialBalance	ValidityEndDate	ValidTo
KEY	CompanyCode	TrialBalance	CompanyCode	Receiver Company Code
KEY	Ledger	TrialBalance	Ledger	Ledger
KEY	AccountingDocument	TrialBalance	AccountingDocument	Journal Entry
KEY	FiscalYear	TrialBalance	FiscalYear	G/L Fiscal Year
KEY	LedgerGLLineItem	TrialBalance	LedgerGLLineItem	Journal Entry Item
KEY	GLAccount	TrialBalance	GLAccount	General Ledger
KEY	StatryRptCategory	TrialBalance	StatryRptCategory	Report ID
KEY	StatryRptgEntity	TrialBalance	StatryRptgEntity	Reporting Entity
KEY	StatryRptRunID	TrialBalance	StatryRptRunID	Report Run ID
	AccountingDocumentItem	TrialBalance	AccountingDocumentItem	Posting View Item
	ValidityStartDate	TrialBalance	ValidityStartDate	Validity Start Date
	BusinessPlace	TrialBalance	BusinessPlace	Business place
	FinancialStatementItem	TrialBalance	FinancialStatementItem	FS Item
	PostingDate	TrialBalance	PostingDate	Posting Date for GR
	FiscalPeriod	TrialBalance	FiscalPeriod	Tax period
	VATRegistration	TrialBalance	VATRegistration	VAT Registration No.
	GLAccountType	TrialBalance	GLAccountType	G/L Account Type
	GLAccountInfo	TrialBalance	GLAccountInfo
	MX_SATGLAccountGrouping	TrialBalance	MX_SATGLAccountGrouping	FS Item
	GLAccountGroup	TrialBalance	GLAccountGroup	Account Group
	CompanyCodeCurrency	TrialBalance	CompanyCodeCurrency	Local Currency
	StartingBalanceAmtInCoCodeCrcy	TrialBalance	StartingBalanceAmtInCoCodeCrcy
	DebitAmountInCoCodeCrcy	TrialBalance	DebitAmountInCoCodeCrcy	Debit Amount in Company Code Currency
	CreditAmountInCoCodeCrcy	TrialBalance	CreditAmountInCoCodeCrcy	Credit Amount in Company Code Currency
	EndingBalanceAmtInCoCodeCrcy	TrialBalance	EndingBalanceAmtInCoCodeCrcy
	ReportingCurrency	TrialBalance	ReportingCurrency	Currency
	StartingBalanceAmtInRptgCrcy	TrialBalance	StartingBalanceAmtInRptgCrcy
	DebitAmountInReportingCurrency	TrialBalance	DebitAmountInReportingCurrency
	CreditAmountInReportingCrcy	TrialBalance	CreditAmountInReportingCrcy
	P_FromPostingDate
	P_ToPostingDate
	P_AlternativeGLAccount
	HierarchyNodeUniqueID			Node
KEY	FinancialStatementVariant	FSV	FinancialStatementVariant	Hierarchy ID
KEY	ChartOfAccounts	FSV	ChartOfAccounts	Node Class
KEY	ValidityEndDate	FSV	ValidityEndDate	ValidTo
KEY	CompanyCode	FSV	CompanyCode	Receiver Company Code
KEY	Ledger			Ledger
KEY	AccountingDocument			Journal Entry
KEY	FiscalYear			G/L Fiscal Year
KEY	LedgerGLLineItem			Journal Entry Item
KEY	GLAccount	FSV	GLAccount	General Ledger
KEY	StatryRptCategory	FSV	StatryRptCategory	Report ID
KEY	StatryRptgEntity	FSV	StatryRptgEntity	Reporting Entity
KEY	StatryRptRunID	FSV	StatryRptRunID	Report Run ID
	AccountingDocumentItem			Posting View Item
	ValidityStartDate	FSV	ValidityStartDate	Validity Start Date
	BusinessPlace			Business place
	FinancialStatementItem	FSV	FinancialStatementItem	FS Item
	PostingDate			Posting Date for GR
	FiscalPeriod			Tax period
	VATRegistration	FSV	VATRegistration	VAT Registration No.
	GLAccountType	FSV	GLAccountType	G/L Account Type
	GLAccountInfo	FSV	GLAccountInfo
	MX_SATGLAccountGrouping	FSV	MX_SATGLAccountGrouping	FS Item
	GLAccountGroup	FSV	GLAccountGroup	Account Group
	CompanyCodeCurrency			Local Currency
	StartingBalanceAmtInCoCodeCrcy
	DebitAmountInCoCodeCrcy			Debit Amount in Company Code Currency
	CreditAmountInCoCodeCrcy			Credit Amount in Company Code Currency
	EndingBalanceAmtInCoCodeCrcy
	ReportingCurrency			Currency
	StartingBalanceAmtInRptgCrcy
	DebitAmountInReportingCurrency
	CreditAmountInReportingCrcy
	EndingBalanceAmtInRptgCrcy

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_MX_FinStmntWthTrialBalance2.
-- 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: PMXFINSTMTTRLBL2
-- Parameters: P_FromPostingDate : fis_budat_from, P_ToPostingDate : fis_budat_to, P_FromFiscalPeriod : fis_period_from, P_ToFiscalPeriod : fis_period_to, P_FinancialStatementVariant : versn_011, P_AlternativeGLAccount : figlmx_prim, P_FiscalYear : fis_gjahr

CREATE VIEW P_MX_FinStmntWthTrialBalance2 AS
SELECT
  TrialBalance.HierarchyNodeUniqueID AS HierarchyNodeUniqueID,
  TrialBalance.FinancialStatementVariant AS FinancialStatementVariant,
  TrialBalance.ChartOfAccounts AS ChartOfAccounts,
  TrialBalance.ValidityEndDate AS ValidityEndDate,
  TrialBalance.CompanyCode AS CompanyCode,
  TrialBalance.Ledger AS Ledger,
  TrialBalance.AccountingDocument AS AccountingDocument,
  TrialBalance.FiscalYear AS FiscalYear,
  TrialBalance.LedgerGLLineItem AS LedgerGLLineItem,
  TrialBalance.GLAccount AS GLAccount,
  TrialBalance.StatryRptCategory AS StatryRptCategory,
  TrialBalance.StatryRptgEntity AS StatryRptgEntity,
  TrialBalance.StatryRptRunID AS StatryRptRunID,
  TrialBalance.AccountingDocumentItem AS AccountingDocumentItem,
  TrialBalance.ValidityStartDate AS ValidityStartDate,
  TrialBalance.BusinessPlace AS BusinessPlace,
  TrialBalance.FinancialStatementItem AS FinancialStatementItem,
  TrialBalance.PostingDate AS PostingDate,
  TrialBalance.FiscalPeriod AS FiscalPeriod,
  TrialBalance.VATRegistration AS VATRegistration,
  TrialBalance.GLAccountType AS GLAccountType,
  TrialBalance.GLAccountInfo AS GLAccountInfo,
  TrialBalance.MX_SATGLAccountGrouping AS MX_SATGLAccountGrouping,
  TrialBalance.GLAccountGroup AS GLAccountGroup,
  TrialBalance.CompanyCodeCurrency AS CompanyCodeCurrency,
  TrialBalance.StartingBalanceAmtInCoCodeCrcy AS StartingBalanceAmtInCoCodeCrcy,
  TrialBalance.DebitAmountInCoCodeCrcy AS DebitAmountInCoCodeCrcy,
  TrialBalance.CreditAmountInCoCodeCrcy AS CreditAmountInCoCodeCrcy,
  TrialBalance.EndingBalanceAmtInCoCodeCrcy AS EndingBalanceAmtInCoCodeCrcy,
  TrialBalance.ReportingCurrency AS ReportingCurrency,
  TrialBalance.StartingBalanceAmtInRptgCrcy AS StartingBalanceAmtInRptgCrcy,
  TrialBalance.DebitAmountInReportingCurrency AS DebitAmountInReportingCurrency,
  TrialBalance.CreditAmountInReportingCrcy AS CreditAmountInReportingCrcy,
  TrialBalance.EndingBalanceAmtInRptgCrcy AS P_FromPostingDate,
  P_ToPostingDate: $parameters.P_ToPostingDate AS P_ToPostingDate,
  P_AlternativeGLAccount: $parameters.P_AlternativeGLAccount AS P_AlternativeGLAccount,
  cast( 0 as glo_ending_bal_amt_rptg_crcy ) AS EndingBalanceAmtInRptgCrcy
FROM P_MX_FinStmntWthTrialBalance
;

Depth:

P_MX_FinStmntWthTrialBalance2 view

P_MX_FinStmntWthTrialBalance view