What is A_TrsyPostgJrnlEntrItm in SAP S/4HANA?

A_TrsyPostgJrnlEntrItm is a composite CDS view in SAP S/4HANA. Treasury Posting Journal Entry It contains 138 fields.

Which tables does A_TrsyPostgJrnlEntrItm read from?

A_TrsyPostgJrnlEntrItm reads data from: I_TrsyFinExpsrItmText, I_TrsyFinExpsrSubitemText, P_TrsyPostgJrnlEntrItm.

What VDM layer is A_TrsyPostgJrnlEntrItm?

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

A_TrsyPostgJrnlEntrItm

DDL: A_TRSYPOSTGJRNLENTRITM SQL: APSTGJRNLENTRITM Type: view COMPOSITE

138 Fields 3 Data Sources

Treasury Posting Journal Entry

A_TrsyPostgJrnlEntrItm is a Composite CDS View that provides data about "Treasury Posting Journal Entry" in SAP S/4HANA. It reads from 3 data sources (I_TrsyFinExpsrItmText, I_TrsyFinExpsrSubitemText, P_TrsyPostgJrnlEntrItm) and exposes 138 fields with key fields TrsyAccountingDocumentUUID, AccountingDocumentItemRef, TrsyPositionContextUUID.

Data Sources (3)

Source	Alias	Join Type
I_TrsyFinExpsrItmText	I_TrsyFinExpsrItmText	left_outer
I_TrsyFinExpsrSubitemText	I_TrsyFinExpsrSubitemText	left_outer
P_TrsyPostgJrnlEntrItm	P_TrsyPostgJrnlEntrItm	from

Annotations (16)

Name	Value	Level
AbapCatalog.sqlViewName	APSTGJRNLENTRITM	view
AbapCatalog.compiler.compareFilter	true	view
EndUserText.label	Treasury Posting Journal Entry	view
VDM.viewType	#COMPOSITE	view
AccessControl.authorizationCheck	#CHECK	view
AccessControl.personalData.blocking	#NOT_REQUIRED	view
ObjectModel.createEnabled	false	view
ObjectModel.deleteEnabled	false	view
ObjectModel.updateEnabled	false	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.serviceQuality	#D	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
OData.publish	true	view
Metadata.ignorePropagatedAnnotations	true	view
VDM.lifecycle.contract.type	#PUBLIC_REMOTE_API	view

Fields (138)

Key	Field	Source Table	Source Field	Description
KEY	TrsyAccountingDocumentUUID	P_TrsyPostgJrnlEntrItm	DocumentUUID	Doc UUID
KEY	AccountingDocumentItemRef	P_TrsyPostgJrnlEntrItm	AccountingDocumentItemRef	Position
KEY	TrsyPositionContextUUID	P_TrsyPostgJrnlEntrItm	PosContexUUID
	TreasuryBusinessTransStatus	P_TrsyPostgJrnlEntrItm	TreasuryBusinessTransStatus
	TreasuryBusTransStatusName	P_TrsyPostgJrnlEntrItm	TreasuryBusTransStatusName
	TreasuryUpdateType	P_TrsyPostgJrnlEntrItm	TreasuryUpdateType
	TreasuryUpdateTypeName	P_TrsyPostgJrnlEntrItm	TreasuryUpdateTypeName
	IsUsedInPaymentTransaction	P_TrsyPostgJrnlEntrItm	IsUsedInPaymentTransaction	Is Used In Payment Transaction
	TreasuryGLAccountAssignmentRef	P_TrsyPostgJrnlEntrItm	TreasuryGLAccountAssignmentRef
	TreasuryGLAccountAssignRefName	P_TrsyPostgJrnlEntrItm	TreasuryGLAccountAssignRefName
	TreasuryPostingCategory	P_TrsyPostgJrnlEntrItm	TreasuryPostingCategory
	TreasuryPostingCategoryName	P_TrsyPostgJrnlEntrItm	TreasuryPostingCategoryName
	TreasuryGLAccountSymbol	P_TrsyPostgJrnlEntrItm	TreasuryGLAccountSymbol
	TreasuryGLAccountSymbolName	P_TrsyPostgJrnlEntrItm	TreasuryGLAccountSymbolName
	PostingKey	P_TrsyPostgJrnlEntrItm	PostingKey	Posting Key
	PostingKeyName	P_TrsyPostgJrnlEntrItm	PostingKeyName
	GLAccount	P_TrsyPostgJrnlEntrItm	GLAccount	General Ledger
	PositionCurrency	P_TrsyPostgJrnlEntrItm	PositionCurrency
	AmountInPositionCurrency	P_TrsyPostgJrnlEntrItm	AmountInPositionCurrency
	CompanyCodeCurrency	P_TrsyPostgJrnlEntrItm	CompanyCodeCurrency	Local Currency
	AmountInCompanyCodeCurrency	P_TrsyPostgJrnlEntrItm	AmountInCompanyCodeCurrency	Local Crcy Amt
	TreasuryTransactionFlow	P_TrsyPostgJrnlEntrItm	TreasuryTransactionFlow
	AccountingDocument	P_TrsyPostgJrnlEntrItm	AccountingDocument	Journal Entry
	ReverseDocument	P_TrsyPostgJrnlEntrItm	ReverseDocument	Reversed With
	JournalEntryType	P_TrsyPostgJrnlEntrItm	JournalEntryType	Journal Entry Type
	AccountingDocumentTypeName	P_TrsyPostgJrnlEntrItm	AccountingDocumentTypeName
	PaymentDate	P_TrsyPostgJrnlEntrItm	PaymentDate	Payment Date
	Customer	P_TrsyPostgJrnlEntrItm	Customer	Sold-to Party
	PaymentTerms	P_TrsyPostgJrnlEntrItm	PaymentTerms	Pyt Terms
	PaymentMethod	P_TrsyPostgJrnlEntrItm	PaymentMethod	Pymt Meth.
	PaymentMethodName	P_TrsyPostgJrnlEntrItm	PaymentMethodName	Text
	PaymentMethodSupplement	P_TrsyPostgJrnlEntrItm	PaymentMethodSupplement	Pmnt Meth. Sup.
	PaymentMethodSupplementName	P_TrsyPostgJrnlEntrItm	PaymentMethodSupplementName
	PaymentBlockingReason	P_TrsyPostgJrnlEntrItm	PaymentBlockingReason	Pmnt block
	PaymentBlockingReasonName	P_TrsyPostgJrnlEntrItm	PaymentBlockingReasonName
	PayerPayeeFullName	P_TrsyPostgJrnlEntrItm	PayerPayeeFullName
	HouseBank	P_TrsyPostgJrnlEntrItm	HouseBank	House Bank
	StateCentralBankPaymentReason	P_TrsyPostgJrnlEntrItm	StateCentralBankPaymentReason	SCB Ind.
	SupplyingCountry	P_TrsyPostgJrnlEntrItm	SupplyingCountry	Supplying Ctry/Reg.
	CountryName	P_TrsyPostgJrnlEntrItm	CountryName	Country
	AssignmentReference	P_TrsyPostgJrnlEntrItm	AssignmentReference	Assignment Reference
	JournalEntryItemText	P_TrsyPostgJrnlEntrItm	JournalEntryItemText
	BusinessArea	P_TrsyPostgJrnlEntrItm	BusinessArea	Business Area
	BusinessAreaName	P_TrsyPostgJrnlEntrItm	BusinessAreaName	Business Area Name
	CostCenter	P_TrsyPostgJrnlEntrItm	CostCenter	Cost Center
	FinancialTransactionType	P_TrsyPostgJrnlEntrItm	FinancialTransactionType	Transact. Type
	FinancialTransactionTypeName	P_TrsyPostgJrnlEntrItm	FinancialTransactionTypeName
	PartnerCompany	P_TrsyPostgJrnlEntrItm	PartnerCompany	Trading Partner
	CompanyName	P_TrsyPostgJrnlEntrItm	CompanyName	Text
	Counterparty	P_TrsyPostgJrnlEntrItm	Counterparty	Supplier
	CounterpartyFullName	P_TrsyPostgJrnlEntrItm	CounterpartyFullName
	Issuer	P_TrsyPostgJrnlEntrItm	Issuer	User Name
	IssuerFullName	P_TrsyPostgJrnlEntrItm	IssuerFullName
	SpecialGLCode	P_TrsyPostgJrnlEntrItm	SpecialGLCode	Special G/L Ind
	SpecialGLCodeName	P_TrsyPostgJrnlEntrItm	SpecialGLCodeName
	TreasuryBusinessTransaction	P_TrsyPostgJrnlEntrItm	TreasuryBusinessTransaction
	TreasuryValuationArea	P_TrsyPostgJrnlEntrItm	TreasuryValuationArea
	TreasuryValuationAreaName	P_TrsyPostgJrnlEntrItm	TreasuryValuationAreaName
	ReferenceDocument	P_TrsyPostgJrnlEntrItm	ReferenceDocument	Reference Document
	ReferenceDocumentContext	P_TrsyPostgJrnlEntrItm	ReferenceDocumentContext	Reference Document Context
	PostingDate	P_TrsyPostgJrnlEntrItm	PostingDate	Posting Date for GR
	FiscalPeriod	P_TrsyPostgJrnlEntrItm	FiscalPeriod	Tax period
	FiscalYear	P_TrsyPostgJrnlEntrItm	FiscalYear	G/L Fiscal Year
	ReversalReferenceDocument	P_TrsyPostgJrnlEntrItm	ReversalReferenceDocument	Reversal Reference Document
	ReversalReferenceDocumentCntxt	P_TrsyPostgJrnlEntrItm	ReversalReferenceDocumentCntxt	Reversal Reference Document Context
	ReverseDocumentPostingDate	P_TrsyPostgJrnlEntrItm	ReverseDocumentPostingDate
	ReverseDocumentFiscalPeriod	P_TrsyPostgJrnlEntrItm	ReverseDocumentFiscalPeriod
	ReverseDocumentFiscalYear	P_TrsyPostgJrnlEntrItm	ReverseDocumentFiscalYear	Year
	Ledger	P_TrsyPostgJrnlEntrItm	Ledger	Ledger
	DocumentDate	P_TrsyPostgJrnlEntrItm	DocumentDate	Journal Entry Date
	AccountingPrinciple	P_TrsyPostgJrnlEntrItm	AccountingPrinciple	AP Ledger/CoCode
	TreasuryAcctgPostingCategory	P_TrsyPostgJrnlEntrItm	TreasuryAcctgPostingCategory
	TreasuryBusinessTransCategory	P_TrsyPostgJrnlEntrItm	TreasuryBusinessTransCategory
	TreasuryBusTransCategoryName	P_TrsyPostgJrnlEntrItm	TreasuryBusTransCategoryName
	DocumentHeaderText	P_TrsyPostgJrnlEntrItm	DocumentHeaderText	Doc.Header Text
	DocumentReferenceID	P_TrsyPostgJrnlEntrItm	DocumentReferenceID	Reference
	FinancialInstrValuationClass	P_TrsyPostgJrnlEntrItm	FinancialInstrValuationClass
	FinancialInstrValClassName	P_TrsyPostgJrnlEntrItm	FinancialInstrValClassName
	TreasuryValuationClass	P_TrsyPostgJrnlEntrItm	TreasuryValuationClass
	TreasuryValuationClassName	P_TrsyPostgJrnlEntrItm	TreasuryValuationClassName
	CompanyCode	P_TrsyPostgJrnlEntrItm	CompanyCode	Receiver Company Code
	FinancialInstrumentProductType	P_TrsyPostgJrnlEntrItm	FinancialInstrumentProductType
	FinancialInstrProdTypeName	P_TrsyPostgJrnlEntrItm	FinancialInstrProdTypeName
	SecurityAccount	P_TrsyPostgJrnlEntrItm	SecurityAccount
	SecurityAccountName	P_TrsyPostgJrnlEntrItm	SecurityAccountName
	SecurityClass	P_TrsyPostgJrnlEntrItm	SecurityClass
	SecurityClassName	P_TrsyPostgJrnlEntrItm	SecurityClassName
	SecurityClassDescription	P_TrsyPostgJrnlEntrItm	SecurityClassDescription
	DifferentiationPortfolio	P_TrsyPostgJrnlEntrItm	DifferentiationPortfolio
	DifferentiationPortfolioName	P_TrsyPostgJrnlEntrItm	DifferentiationPortfolioName
	SecurityAccountGroup	P_TrsyPostgJrnlEntrItm	SecurityAccountGroup
	SecurityAccountGroupName	P_TrsyPostgJrnlEntrItm	SecurityAccountGroupName
	LoanContract	P_TrsyPostgJrnlEntrItm	LoanContract
	LoanContractName	P_TrsyPostgJrnlEntrItm	LoanContractName
	TreasuryPositionAccount	P_TrsyPostgJrnlEntrItm	TreasuryPositionAccount
	TreasuryPositionAccountName	P_TrsyPostgJrnlEntrItm	TreasuryPositionAccountName
	TreasuryPositionLongShortCode	P_TrsyPostgJrnlEntrItm	TreasuryPositionLongShortCode
	Fund	P_TrsyPostgJrnlEntrItm	Fund	Sender Fund
	GrantID	P_TrsyPostgJrnlEntrItm	GrantID	Sender Grant
	WBSElementExternalID	P_TrsyPostgJrnlEntrItm	WBSElementExternalID	WBS Element External ID
	WBSDescription	P_TrsyPostgJrnlEntrItm	WBSDescription	WBS Element Name
	ProfitCenter	P_TrsyPostgJrnlEntrItm	ProfitCenter	Profit Center
	DifferentiationCostCenter	P_TrsyPostgJrnlEntrItm	DifferentiationCostCenter	Cost Center
	FunctionalArea	P_TrsyPostgJrnlEntrItm	FunctionalArea	Sendr Fctl Area
	TrsyPosCustomDiffntnTerm1	P_TrsyPostgJrnlEntrItm	TrsyPosCustomDiffntnTerm1
	TrsyPosCustomDiffntnTerm1Name	P_TrsyPostgJrnlEntrItm	TrsyPosCustomDiffntnTerm1Name
	TrsyPosCustomDiffntnTerm2	P_TrsyPostgJrnlEntrItm	TrsyPosCustomDiffntnTerm2
	TrsyPosCustomDiffntnTerm2Name	P_TrsyPostgJrnlEntrItm	TrsyPosCustomDiffntnTerm2Name
	TrsyPosCustomDiffntnTerm3	P_TrsyPostgJrnlEntrItm	TrsyPosCustomDiffntnTerm3
	TrsyPosCustomDiffntnTerm3Name	P_TrsyPostgJrnlEntrItm	TrsyPosCustomDiffntnTerm3Name
	TrsyPosCustomDiffntnTerm4	P_TrsyPostgJrnlEntrItm	TrsyPosCustomDiffntnTerm4
	TrsyPosCustomDiffntnTerm4Name	P_TrsyPostgJrnlEntrItm	TrsyPosCustomDiffntnTerm4Name
	TrsyPosCustomDiffntnTerm5	P_TrsyPostgJrnlEntrItm	TrsyPosCustomDiffntnTerm5
	TrsyPosCustomDiffntnTerm5Name	P_TrsyPostgJrnlEntrItm	TrsyPosCustomDiffntnTerm5Name
	CentralClearingAccount	P_TrsyPostgJrnlEntrItm	CentralClearingAccount
	CentralClearingAccountName	P_TrsyPostgJrnlEntrItm	CentralClearingAccountName
	ActivityFinancialTransaction	P_TrsyPostgJrnlEntrItm	ActivityFinancialTransaction
	FinancialTransaction	P_TrsyPostgJrnlEntrItm	FinancialTransaction	Transaction
	TreasuryAccountingCode	P_TrsyPostgJrnlEntrItm	TreasuryAccountingCode
	CreatedByUser
	CreationDate
	LastChangedByUser
	LastChangeDate
	GLAccountLongName
	CostCenterName
	FinancialInstrTransactionType
	FinancialInstrTransTypeName
	FinancialInstrCharacteristic
	FinancialInstrumentReference
	FinancialInstrumentAssignment
	Portfolio
	LetterOfCredit
	HedgingClassification
	HedgingClassificationName
	FinancialExposureItem	P_TrsyPostgJrnlEntrItm	FinancialExposureItem	Exposure Item ID
	FinancialExposureItemName	I_TrsyFinExpsrItmText	FinancialExposureItemName	Well Code Des.
	FinancialExposureSubItem	P_TrsyPostgJrnlEntrItm	FinancialExposureSubItem	Exposure Subitem ID
	FinancialExposureSubItemName	I_TrsyFinExpsrSubitemText	FinancialExposureSubItemName

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 A_TrsyPostgJrnlEntrItm.
-- 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: APSTGJRNLENTRITM

CREATE VIEW A_TrsyPostgJrnlEntrItm AS
SELECT
  P_TrsyPostgJrnlEntrItm.DocumentUUID AS TrsyAccountingDocumentUUID,
  P_TrsyPostgJrnlEntrItm.AccountingDocumentItemRef AS AccountingDocumentItemRef,
  P_TrsyPostgJrnlEntrItm.PosContexUUID AS TrsyPositionContextUUID,
  P_TrsyPostgJrnlEntrItm.TreasuryBusinessTransStatus AS TreasuryBusinessTransStatus,
  P_TrsyPostgJrnlEntrItm.TreasuryBusTransStatusName AS TreasuryBusTransStatusName,
  P_TrsyPostgJrnlEntrItm.TreasuryUpdateType AS TreasuryUpdateType,
  P_TrsyPostgJrnlEntrItm.TreasuryUpdateTypeName AS TreasuryUpdateTypeName,
  P_TrsyPostgJrnlEntrItm.IsUsedInPaymentTransaction AS IsUsedInPaymentTransaction,
  P_TrsyPostgJrnlEntrItm.TreasuryGLAccountAssignmentRef AS TreasuryGLAccountAssignmentRef,
  P_TrsyPostgJrnlEntrItm.TreasuryGLAccountAssignRefName AS TreasuryGLAccountAssignRefName,
  P_TrsyPostgJrnlEntrItm.TreasuryPostingCategory AS TreasuryPostingCategory,
  P_TrsyPostgJrnlEntrItm.TreasuryPostingCategoryName AS TreasuryPostingCategoryName,
  P_TrsyPostgJrnlEntrItm.TreasuryGLAccountSymbol AS TreasuryGLAccountSymbol,
  P_TrsyPostgJrnlEntrItm.TreasuryGLAccountSymbolName AS TreasuryGLAccountSymbolName,
  P_TrsyPostgJrnlEntrItm.PostingKey AS PostingKey,
  P_TrsyPostgJrnlEntrItm.PostingKeyName AS PostingKeyName,
  P_TrsyPostgJrnlEntrItm.GLAccount AS GLAccount,
  P_TrsyPostgJrnlEntrItm.PositionCurrency AS PositionCurrency,
  P_TrsyPostgJrnlEntrItm.AmountInPositionCurrency AS AmountInPositionCurrency,
  P_TrsyPostgJrnlEntrItm.CompanyCodeCurrency AS CompanyCodeCurrency,
  P_TrsyPostgJrnlEntrItm.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  P_TrsyPostgJrnlEntrItm.TreasuryTransactionFlow AS TreasuryTransactionFlow,
  P_TrsyPostgJrnlEntrItm.AccountingDocument AS AccountingDocument,
  P_TrsyPostgJrnlEntrItm.ReverseDocument AS ReverseDocument,
  P_TrsyPostgJrnlEntrItm.JournalEntryType AS JournalEntryType,
  P_TrsyPostgJrnlEntrItm.AccountingDocumentTypeName AS AccountingDocumentTypeName,
  P_TrsyPostgJrnlEntrItm.PaymentDate AS PaymentDate,
  P_TrsyPostgJrnlEntrItm.Customer AS Customer,
  P_TrsyPostgJrnlEntrItm.PaymentTerms AS PaymentTerms,
  P_TrsyPostgJrnlEntrItm.PaymentMethod AS PaymentMethod,
  P_TrsyPostgJrnlEntrItm.PaymentMethodName AS PaymentMethodName,
  P_TrsyPostgJrnlEntrItm.PaymentMethodSupplement AS PaymentMethodSupplement,
  P_TrsyPostgJrnlEntrItm.PaymentMethodSupplementName AS PaymentMethodSupplementName,
  P_TrsyPostgJrnlEntrItm.PaymentBlockingReason AS PaymentBlockingReason,
  P_TrsyPostgJrnlEntrItm.PaymentBlockingReasonName AS PaymentBlockingReasonName,
  P_TrsyPostgJrnlEntrItm.PayerPayeeFullName AS PayerPayeeFullName,
  P_TrsyPostgJrnlEntrItm.HouseBank AS HouseBank,
  P_TrsyPostgJrnlEntrItm.StateCentralBankPaymentReason AS StateCentralBankPaymentReason,
  P_TrsyPostgJrnlEntrItm.SupplyingCountry AS SupplyingCountry,
  P_TrsyPostgJrnlEntrItm.CountryName AS CountryName,
  P_TrsyPostgJrnlEntrItm.AssignmentReference AS AssignmentReference,
  P_TrsyPostgJrnlEntrItm.JournalEntryItemText AS JournalEntryItemText,
  P_TrsyPostgJrnlEntrItm.BusinessArea AS BusinessArea,
  P_TrsyPostgJrnlEntrItm.BusinessAreaName AS BusinessAreaName,
  P_TrsyPostgJrnlEntrItm.CostCenter AS CostCenter,
  P_TrsyPostgJrnlEntrItm.FinancialTransactionType AS FinancialTransactionType,
  P_TrsyPostgJrnlEntrItm.FinancialTransactionTypeName AS FinancialTransactionTypeName,
  P_TrsyPostgJrnlEntrItm.PartnerCompany AS PartnerCompany,
  P_TrsyPostgJrnlEntrItm.CompanyName AS CompanyName,
  P_TrsyPostgJrnlEntrItm.Counterparty AS Counterparty,
  P_TrsyPostgJrnlEntrItm.CounterpartyFullName AS CounterpartyFullName,
  P_TrsyPostgJrnlEntrItm.Issuer AS Issuer,
  P_TrsyPostgJrnlEntrItm.IssuerFullName AS IssuerFullName,
  P_TrsyPostgJrnlEntrItm.SpecialGLCode AS SpecialGLCode,
  P_TrsyPostgJrnlEntrItm.SpecialGLCodeName AS SpecialGLCodeName,
  P_TrsyPostgJrnlEntrItm.TreasuryBusinessTransaction AS TreasuryBusinessTransaction,
  P_TrsyPostgJrnlEntrItm.TreasuryValuationArea AS TreasuryValuationArea,
  P_TrsyPostgJrnlEntrItm.TreasuryValuationAreaName AS TreasuryValuationAreaName,
  P_TrsyPostgJrnlEntrItm.ReferenceDocument AS ReferenceDocument,
  P_TrsyPostgJrnlEntrItm.ReferenceDocumentContext AS ReferenceDocumentContext,
  P_TrsyPostgJrnlEntrItm.PostingDate AS PostingDate,
  P_TrsyPostgJrnlEntrItm.FiscalPeriod AS FiscalPeriod,
  P_TrsyPostgJrnlEntrItm.FiscalYear AS FiscalYear,
  P_TrsyPostgJrnlEntrItm.ReversalReferenceDocument AS ReversalReferenceDocument,
  P_TrsyPostgJrnlEntrItm.ReversalReferenceDocumentCntxt AS ReversalReferenceDocumentCntxt,
  P_TrsyPostgJrnlEntrItm.ReverseDocumentPostingDate AS ReverseDocumentPostingDate,
  P_TrsyPostgJrnlEntrItm.ReverseDocumentFiscalPeriod AS ReverseDocumentFiscalPeriod,
  P_TrsyPostgJrnlEntrItm.ReverseDocumentFiscalYear AS ReverseDocumentFiscalYear,
  P_TrsyPostgJrnlEntrItm.Ledger AS Ledger,
  P_TrsyPostgJrnlEntrItm.DocumentDate AS DocumentDate,
  P_TrsyPostgJrnlEntrItm.AccountingPrinciple AS AccountingPrinciple,
  P_TrsyPostgJrnlEntrItm.TreasuryAcctgPostingCategory AS TreasuryAcctgPostingCategory,
  P_TrsyPostgJrnlEntrItm.TreasuryBusinessTransCategory AS TreasuryBusinessTransCategory,
  P_TrsyPostgJrnlEntrItm.TreasuryBusTransCategoryName AS TreasuryBusTransCategoryName,
  P_TrsyPostgJrnlEntrItm.DocumentHeaderText AS DocumentHeaderText,
  P_TrsyPostgJrnlEntrItm.DocumentReferenceID AS DocumentReferenceID,
  P_TrsyPostgJrnlEntrItm.FinancialInstrValuationClass AS FinancialInstrValuationClass,
  P_TrsyPostgJrnlEntrItm.FinancialInstrValClassName AS FinancialInstrValClassName,
  P_TrsyPostgJrnlEntrItm.TreasuryValuationClass AS TreasuryValuationClass,
  P_TrsyPostgJrnlEntrItm.TreasuryValuationClassName AS TreasuryValuationClassName,
  P_TrsyPostgJrnlEntrItm.CompanyCode AS CompanyCode,
  P_TrsyPostgJrnlEntrItm.FinancialInstrumentProductType AS FinancialInstrumentProductType,
  P_TrsyPostgJrnlEntrItm.FinancialInstrProdTypeName AS FinancialInstrProdTypeName,
  P_TrsyPostgJrnlEntrItm.SecurityAccount AS SecurityAccount,
  P_TrsyPostgJrnlEntrItm.SecurityAccountName AS SecurityAccountName,
  P_TrsyPostgJrnlEntrItm.SecurityClass AS SecurityClass,
  P_TrsyPostgJrnlEntrItm.SecurityClassName AS SecurityClassName,
  P_TrsyPostgJrnlEntrItm.SecurityClassDescription AS SecurityClassDescription,
  P_TrsyPostgJrnlEntrItm.DifferentiationPortfolio AS DifferentiationPortfolio,
  P_TrsyPostgJrnlEntrItm.DifferentiationPortfolioName AS DifferentiationPortfolioName,
  P_TrsyPostgJrnlEntrItm.SecurityAccountGroup AS SecurityAccountGroup,
  P_TrsyPostgJrnlEntrItm.SecurityAccountGroupName AS SecurityAccountGroupName,
  P_TrsyPostgJrnlEntrItm.LoanContract AS LoanContract,
  P_TrsyPostgJrnlEntrItm.LoanContractName AS LoanContractName,
  P_TrsyPostgJrnlEntrItm.TreasuryPositionAccount AS TreasuryPositionAccount,
  P_TrsyPostgJrnlEntrItm.TreasuryPositionAccountName AS TreasuryPositionAccountName,
  P_TrsyPostgJrnlEntrItm.TreasuryPositionLongShortCode AS TreasuryPositionLongShortCode,
  P_TrsyPostgJrnlEntrItm.Fund AS Fund,
  P_TrsyPostgJrnlEntrItm.GrantID AS GrantID,
  P_TrsyPostgJrnlEntrItm.WBSElementExternalID AS WBSElementExternalID,
  P_TrsyPostgJrnlEntrItm.WBSDescription AS WBSDescription,
  P_TrsyPostgJrnlEntrItm.ProfitCenter AS ProfitCenter,
  P_TrsyPostgJrnlEntrItm.DifferentiationCostCenter AS DifferentiationCostCenter,
  P_TrsyPostgJrnlEntrItm.FunctionalArea AS FunctionalArea,
  P_TrsyPostgJrnlEntrItm.TrsyPosCustomDiffntnTerm1 AS TrsyPosCustomDiffntnTerm1,
  P_TrsyPostgJrnlEntrItm.TrsyPosCustomDiffntnTerm1Name AS TrsyPosCustomDiffntnTerm1Name,
  P_TrsyPostgJrnlEntrItm.TrsyPosCustomDiffntnTerm2 AS TrsyPosCustomDiffntnTerm2,
  P_TrsyPostgJrnlEntrItm.TrsyPosCustomDiffntnTerm2Name AS TrsyPosCustomDiffntnTerm2Name,
  P_TrsyPostgJrnlEntrItm.TrsyPosCustomDiffntnTerm3 AS TrsyPosCustomDiffntnTerm3,
  P_TrsyPostgJrnlEntrItm.TrsyPosCustomDiffntnTerm3Name AS TrsyPosCustomDiffntnTerm3Name,
  P_TrsyPostgJrnlEntrItm.TrsyPosCustomDiffntnTerm4 AS TrsyPosCustomDiffntnTerm4,
  P_TrsyPostgJrnlEntrItm.TrsyPosCustomDiffntnTerm4Name AS TrsyPosCustomDiffntnTerm4Name,
  P_TrsyPostgJrnlEntrItm.TrsyPosCustomDiffntnTerm5 AS TrsyPosCustomDiffntnTerm5,
  P_TrsyPostgJrnlEntrItm.TrsyPosCustomDiffntnTerm5Name AS TrsyPosCustomDiffntnTerm5Name,
  P_TrsyPostgJrnlEntrItm.CentralClearingAccount AS CentralClearingAccount,
  P_TrsyPostgJrnlEntrItm.CentralClearingAccountName AS CentralClearingAccountName,
  P_TrsyPostgJrnlEntrItm.ActivityFinancialTransaction AS ActivityFinancialTransaction,
  P_TrsyPostgJrnlEntrItm.FinancialTransaction AS FinancialTransaction,
  P_TrsyPostgJrnlEntrItm.TreasuryAccountingCode AS TreasuryAccountingCode,
  P_TrsyPostgJrnlEntrItm._TrgtUserData.CreatedByUser AS CreatedByUser,
  P_TrsyPostgJrnlEntrItm._TrgtUserData.CreationDate AS CreationDate,
  P_TrsyPostgJrnlEntrItm._TrgtUserData.LastChangedByUser AS LastChangedByUser,
  P_TrsyPostgJrnlEntrItm._TrgtUserData.LastChangeDate AS LastChangeDate,
  cast(P_TrsyPostgJrnlEntrItm._GLAccountText[1: Language = $session.system_language].GLAccountLongName as ftr_gen_gl_account_description preserving type) AS GLAccountLongName,
  cast(P_TrsyPostgJrnlEntrItm._CostCenterText[1: Language = $session.system_language].CostCenterName as ftr_gen_cost_center_name preserving type) AS CostCenterName,
  P_TrsyPostgJrnlEntrItm._FinancialTransaction.FinancialInstrTransactionType AS FinancialInstrTransactionType,
  cast(P_TrsyPostgJrnlEntrItm._FinancialTransaction._FinancialInstrTransType._Text[1: Language = $session.system_language].FinancialInstrTransTypeName as ftr_gen_transaction_type_name preserving type) AS FinancialInstrTransTypeName,
  P_TrsyPostgJrnlEntrItm._FinancialTransaction.FinancialInstrCharacteristic AS FinancialInstrCharacteristic,
  P_TrsyPostgJrnlEntrItm._FinancialTransaction.FinancialInstrumentReference AS FinancialInstrumentReference,
  P_TrsyPostgJrnlEntrItm._FinancialTransaction.FinancialInstrumentAssignment AS FinancialInstrumentAssignment,
  P_TrsyPostgJrnlEntrItm._FinancialTransaction.Portfolio AS Portfolio,
  P_TrsyPostgJrnlEntrItm._FinancialTransaction._LetterOfCredit.LetterOfCredit AS LetterOfCredit,
  P_TrsyPostgJrnlEntrItm._FinancialTransaction.HedgingClassification AS HedgingClassification,
  cast(P_TrsyPostgJrnlEntrItm._FinancialTransaction._TreasuryHedgingClassfctn._Text[1: Language = $session.system_language].HedgingClassificationName as ftr_gen_hedging_class_name preserving type) AS HedgingClassificationName,
  P_TrsyPostgJrnlEntrItm.FinancialExposureItem AS FinancialExposureItem,
  I_TrsyFinExpsrItmText.FinancialExposureItemName AS FinancialExposureItemName,
  P_TrsyPostgJrnlEntrItm.FinancialExposureSubItem AS FinancialExposureSubItem,
  I_TrsyFinExpsrSubitemText.FinancialExposureSubItemName AS FinancialExposureSubItemName
FROM P_TrsyPostgJrnlEntrItm
LEFT OUTER JOIN I_TrsyFinExpsrItmText ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_TrsyFinExpsrSubitemText ON /* join condition not captured in parsed metadata */
;

Depth:

A_TrsyPostgJrnlEntrItm view