What is P_TrsyPosFlow in SAP S/4HANA?

P_TrsyPosFlow is a composite CDS view in SAP S/4HANA. It contains 114 fields.

What VDM layer is P_TrsyPosFlow?

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

P_TrsyPosFlow

Q: Which tables does P_TrsyPosFlow read from?

P_TrsyPosFlow reads data from: I_FinInstrProductGroup, I_TrsyPositionTransactionFlow, I_TrsyAccountingItem.

DDL: P_TRSYPOSFLOW Type: view_entity COMPOSITE

114 Fields 3 Data Sources 19 Associations

P_TrsyPosFlow is a Composite CDS View in SAP S/4HANA. It reads from 3 data sources (I_FinInstrProductGroup, I_TrsyPositionTransactionFlow, I_TrsyAccountingItem) and exposes 114 fields with key fields TreasuryTransactionFlow, BusinessTransactionDocUUID. It has 19 associations to related views.

Data Sources (3)

Source	Alias	Join Type
I_FinInstrProductGroup	I_FinInstrProductGroup	inner
I_TrsyPositionTransactionFlow	itrlttranspos	from
I_TrsyAccountingItem	TRAC	left_outer

Associations (19)

Cardinality	Target	Alias	Condition
[0..1]	I_Treasurypositionlot	_TreasuryPositionLot	`$projection.TreasuryPosition = _TreasuryPositionLot.TreasuryPosition and $projection.TreasuryPositionLot = _TreasuryPositionLot.TreasuryPositionLot`
[0..1]	I_TrsyScrtyClScrtyAccountFlow	_TrsyScrtyClScrtyAccountFlow	`itrlttranspos.TreasuryBusinessTransaction = _TrsyScrtyClScrtyAccountFlow.TreasuryBusinessTransaction and itrlttranspos.TreasuryTransactionFlow = _TrsyScrtyClScrtyAccountFlow.TreasuryTransactionFlow -- **`
[0..1]	I_TrsyPosAssetLbltyCodeText	_TrsyPosAssetLbltyCodeText	`$projection.TreasuryPosAssetLiabilityCode = itrlttranspos.TreasuryPosAssetLiabilityCode and _TrsyPosAssetLbltyCodeText.Language = $session.system_language`
[0..1]	I_FinInstrProductGroupText	_FinInstrProductGroupText	`$projection.FinInstrProductGroup = I_FinInstrProductGroup.FinInstrProductGroup and _FinInstrProductGroupText.Language = $session.system_language`
[0..1]	I_TrsyFinExpsrItmText	_TrsyFinExpsrItmText	`itrlttranspos.FinancialExposureItem = _TrsyFinExpsrItmText.FinancialExposureItem`
[0..1]	I_TrsyFinExpsrSubitemText	_TrsyFinExpsrSubitemText	`itrlttranspos.TreasuryPosition = _TrsyFinExpsrSubitemText.TreasuryPosition`
[0..1]	I_TrsyPosCustomDiffntnTerm1	_TrsyPosCustomDiffntnTerm1	`$projection.TrsyPosCustomDiffntnTerm1 = _TrsyPosCustomDiffntnTerm1.TrsyPosCustomDiffntnTerm1`
[0..1]	I_TrsyPosCustomDiffntnTerm2	_TrsyPosCustomDiffntnTerm2	`$projection.TrsyPosCustomDiffntnTerm2 = _TrsyPosCustomDiffntnTerm2.TrsyPosCustomDiffntnTerm2`
[0..1]	I_TrsyPosCustomDiffntnTerm3	_TrsyPosCustomDiffntnTerm3	`$projection.TrsyPosCustomDiffntnTerm3 = _TrsyPosCustomDiffntnTerm3.TrsyPosCustomDiffntnTerm3`
[0..1]	I_TrsyPosCustomDiffntnTerm4	_TrsyPosCustomDiffntnTerm4	`$projection.TrsyPosCustomDiffntnTerm4 = _TrsyPosCustomDiffntnTerm4.TrsyPosCustomDiffntnTerm4`
[0..1]	I_TrsyPosCustomDiffntnTerm5	_TrsyPosCustomDiffntnTerm5	`$projection.TrsyPosCustomDiffntnTerm5 = _TrsyPosCustomDiffntnTerm5.TrsyPosCustomDiffntnTerm5`
[0..1]	I_SecurityClass	_SecurityClass	`$projection.SecurityClass = _SecurityClass.SecurityClass`
[0..1]	I_SecurityAccount	_SecurityAccount	`$projection.SecurityAccount = _SecurityAccount.SecurityAccount and $projection.CompanyCode = _SecurityAccount.CompanyCode`
[0..1]	I_DifferentiationPortfolioText	_DifferentiationPortfolioText	`$projection.DifferentiationPortfolio = _DifferentiationPortfolioText.DifferentiationPortfolio and $projection.CompanyCode = _DifferentiationPortfolioText.CompanyCode and _DifferentiationPortfolioText.Language = $session.system_language`
[0..1]	I_TreasuryPositionAccount	_TreasuryPositionAccount	`$projection.TreasuryPositionAccount = _TreasuryPositionAccount.TreasuryPositionAccount`
[0..1]	I_CentralClearingAccount	_CentralClearingAccount	`$projection.CentralClearingAccount = _CentralClearingAccount.CentralClearingAccount and $projection.CompanyCode = _CentralClearingAccount.CompanyCode`
[0..1]	I_LoanContract	_LoanContract	`$projection.LoanContract = _LoanContract.LoanContract and $projection.CompanyCode = _LoanContract.CompanyCode`
[0..1]	I_FinancialInstrValClassText	_FinancialInstrValClassText	`$projection.FinancialInstrValuationClass = _FinancialInstrValClassText.FinancialInstrValuationClass and _FinancialInstrValClassText.Language = $session.system_language`
[0..1]	I_TreasuryValuationClassText	_TreasuryValuationClassText	`$projection.TreasuryValuationClass = _TreasuryValuationClassText.TreasuryValuationClass and $projection.TreasuryValuationArea = _TreasuryValuationClassText.TreasuryValuationArea and _TreasuryValuationClassText.Language = $session.system_language`

Annotations (3)

Name	Value	Level
AccessControl.authorizationCheck	#NOT_REQUIRED	view
VDM.private	true	view
VDM.viewType	#COMPOSITE	view

Fields (114)

Key	Field	Source Table	Source Field	Description
KEY	TreasuryTransactionFlow	I_TrsyPositionTransactionFlow	TreasuryLedgerFlow
KEY	BusinessTransactionDocUUID	I_TrsyPositionTransactionFlow	BusinessTransactionDocUUID
	TreasuryPosition	I_TrsyPositionTransactionFlow	TreasuryPosition
	TreasuryBusinessTransaction	I_TrsyPositionTransactionFlow	TreasuryBusinessTransaction
	TreasuryUpdateTypeName	I_TrsyPositionTransactionFlow	TreasuryUpdateTypeName
	TreasuryUpdateType	I_TrsyPositionTransactionFlow	TreasuryUpdateType
	AmountInPositionCurrency	I_TrsyPositionTransactionFlow	AmountInPositionCurrency
	PositionCurrency	I_TrsyPositionTransactionFlow	PositionCurrency
	AmountInValuationCurrency	I_TrsyPositionTransactionFlow	AmountInValuationCurrency
	ValuationCurrency	I_TrsyPositionTransactionFlow	ValuationCurrency
	TreasuryPositionLedgerDate	I_TrsyPositionTransactionFlow	TreasuryPositionLedgerDate
	TreasuryPositionTransferGroup	I_TrsyPositionTransactionFlow	TreasuryPositionTransferGroup
	TreasuryPositionTransferFactor	I_TrsyPositionTransactionFlow	TreasuryPositionTransferFactor
	TrsyPosQuantityChangeCategory	I_TrsyPositionTransactionFlow	TrsyPosQuantityChangeCategory
	TrsyPosAmountChangeCategory	I_TrsyPositionTransactionFlow	TrsyPosAmountChangeCategory
	QuantityInPieces	I_TrsyPositionTransactionFlow	QuantityInPieces
	IndexCleanAmountInPositionCrcy	I_TrsyPositionTransactionFlow	IndexCleanAmountInPositionCrcy
	NominalAmountInNominalCurrency	I_TrsyPositionTransactionFlow	NominalAmountInNominalCurrency
	OriglNominalAmtInNominalCrcy	I_TrsyPositionTransactionFlow	OriglNominalAmtInNominalCrcy
	NominalCurrency	I_TrsyPositionTransactionFlow	NominalCurrency
	CalculationDate	I_TrsyPositionTransactionFlow	CalculationDate
	CalcDateIsAsEndDateInclusive	I_TrsyPositionTransactionFlow	CalcDateIsAsEndDateInclusive
	DueDate	I_TrsyPositionTransactionFlow	DueDate	Promised For
	CalculationPeriodStartDate	I_TrsyPositionTransactionFlow	CalculationPeriodStartDate
	CalculationPeriodEndDate	I_TrsyPositionTransactionFlow	CalculationPeriodEndDate
	EffectiveInterestRate	I_TrsyPositionTransactionFlow	EffectiveInterestRate
	EffctvIntrstRateRdmptnSched	I_TrsyPositionTransactionFlow	EffctvIntrstRateRdmptnSched
	NextEffectiveInterestRate	I_TrsyPositionTransactionFlow	NextEffectiveInterestRate
	FixedRedemptionSchedule	I_TrsyPositionTransactionFlow	FixedRedemptionSchedule
	CalculationBasis	I_TrsyPositionTransactionFlow	CalculationBasis
	FinInstrProductGroup	I_FinInstrProductGroup	FinInstrProductGroup
	TreasuryBusinessTransStatus	I_TrsyPositionTransactionFlow	TreasuryBusinessTransStatus
	TrsyIntragroupTransacStatus	I_TrsyPositionTransactionFlow	TrsyIntragroupTransacStatus
	TreasuryBusinessTransCategory	I_TrsyPositionTransactionFlow	TreasuryBusinessTransCategory
	OriglTrsyBusinessTransaction	I_TrsyPositionTransactionFlow	OriglTrsyBusinessTransaction
	TrsyDerivedBusinessTransStatus	I_TrsyPositionTransactionFlow	TrsyDerivedBusinessTransStatus
	TreasuryPosAssetLiabilityCode	I_TrsyPositionTransactionFlow	TreasuryPosAssetLiabilityCode
	TrsyPosTransfSourceTargetCode	I_TrsyPositionTransactionFlow	TrsyPosTransfSourceTargetCode
	TreasuryValuationArea	I_TrsyPositionTransactionFlow	TreasuryValuationArea
	TreasuryValuationAreaName	I_TrsyPositionTransactionFlow	TreasuryValuationAreaName
	TreasuryValuationClass	I_TrsyPositionTransactionFlow	TreasuryValuationClass
	TreasuryValuationClassName	_TreasuryValuationClassText	TreasuryValuationClassName
	CompanyCode	I_TrsyPositionTransactionFlow	CompanyCode	Receiver Company Code
	FinancialInstrumentProductType	I_TrsyPositionTransactionFlow	FinancialInstrumentProductType	Product Type
	SecurityAccount	I_TrsyPositionTransactionFlow	SecurityAccount
	SecurityClass	I_TrsyPositionTransactionFlow	SecurityClass
	SecurityClassName	_SecurityClass	SecurityClassName
	SecurityClassDescription	_SecurityClass	SecurityClassDescription
	FinancialInstrValuationClass	I_TrsyPositionTransactionFlow	FinancialInstrValuationClass
	FinancialInstrValClassName	_FinancialInstrValClassText	FinancialInstrValClassName
	TreasuryPositionLot	I_TrsyPositionTransactionFlow	TreasuryPositionLot
	SecurityAccountGroup	I_TrsyPositionTransactionFlow	SecurityAccountGroup
	LoanContract	I_TrsyPositionTransactionFlow	LoanContract
	LoanContractName	_LoanContract	LoanContractName
	TreasuryPositionAccount	I_TrsyPositionTransactionFlow	TreasuryPositionAccount
	TreasuryPositionLongShortCode	I_TrsyPositionTransactionFlow	TreasuryPositionLongShortCode
	Fund	I_TrsyPositionTransactionFlow	Fund	Sender Fund
	GrantID	I_TrsyPositionTransactionFlow	GrantID	Sender Grant
	CostCenter	I_TrsyPositionTransactionFlow	CostCenter	Cost Center
	ProfitCenter	I_TrsyPositionTransactionFlow	ProfitCenter	Profit Center
	WBSElementInternalID	I_TrsyPositionTransactionFlow	WBSElementInternalID	WBS Internal ID
	FunctionalArea	I_TrsyPositionTransactionFlow	FunctionalArea	Sendr Fctl Area
	WBSElementExternalID
	WBSDescription
	TrsyPosCustomDiffntnTerm1	I_TrsyPositionTransactionFlow	TrsyPosCustomDiffntnTerm1
	TrsyPosCustomDiffntnTerm1Name
	TrsyPosCustomDiffntnTerm2	I_TrsyPositionTransactionFlow	TrsyPosCustomDiffntnTerm2
	TrsyPosCustomDiffntnTerm2Name
	TrsyPosCustomDiffntnTerm3	I_TrsyPositionTransactionFlow	TrsyPosCustomDiffntnTerm3
	TrsyPosCustomDiffntnTerm3Name
	TrsyPosCustomDiffntnTerm4	I_TrsyPositionTransactionFlow	TrsyPosCustomDiffntnTerm4
	TrsyPosCustomDiffntnTerm4Name
	TrsyPosCustomDiffntnTerm5	I_TrsyPositionTransactionFlow	TrsyPosCustomDiffntnTerm5
	TrsyPosCustomDiffntnTerm5Name
	CentralClearingAccount	I_TrsyPositionTransactionFlow	CentralClearingAccount
	CentralClearingAccountName	I_TrsyPositionTransactionFlow	CentralClearingAccountName
	CompanyCodeName	I_TrsyPositionTransactionFlow	CompanyCodeName	Company Name
	SecurityAccountName	_SecurityAccount	SecurityAccountName
	SecurityAccountGroupName	_SecurityAccountGroup	SecurityAccountGroupName
	PortfolioendasrportbasPortfolio
	Issuer	_SecurityClass	Issuer	User Name
	TrsyPosQtyChangeCategoryName	I_TrsyPositionTransactionFlow	TrsyPosQtyChangeCategoryName
	TreasuryPosChangeCategoryName	I_TrsyPositionTransactionFlow	TreasuryPosChangeCategoryName
	DifferentiationPortfolio	I_TrsyPositionTransactionFlow	DifferentiationPortfolio
	DifferentiationPortfolioName	_DifferentiationPortfolioText	DifferentiationPortfolioName
	FinancialTransaction	I_TrsyPositionTransactionFlow	FinancialTransaction	Transaction
	FinancialInstrActivityCategory	I_TrsyDistributorBusTrans	FinancialInstrActivityCategory
	FinancialInstrCharacteristic	I_TrsyDistributorBusTrans	FinancialInstrCharacteristic	Characteristics
	FinancialInstrumentReference	I_TrsyDistributorBusTrans	FinancialInstrumentReference
	FinancialInstrumentAssignment	I_TrsyDistributorBusTrans	FinancialInstrumentAssignment
	ConditionItemValidityStartDate	I_TrsyDistributorBusTrans	ConditionItemValidityStartDate
	CalcPeriodEndDateIsInclusive	I_TrsyDistributorBusTrans	CalcPeriodEndDateIsInclusive
	InterestCalculationMethod	I_TrsyDistributorBusTrans	InterestCalculationMethod
	DebitGLAccount	I_TrsyAccountingItem	DebitGLAccount	G/L Account
	CreditGLAccount	I_TrsyAccountingItem	CreditGLAccount
	DebitCustomer	I_TrsyAccountingItem	DebitCustomer
	CreditCustomer	I_TrsyAccountingItem	CreditCustomer
	FiscalYear	I_TrsyAccountingItem	FiscalYear	G/L Fiscal Year
	FiscalPeriod	I_TrsyAccountingItem	PostingFiscalPeriod	Period
	PostingFiscalPeriod	I_TrsyAccountingItem	PostingFiscalPeriod	Period
	PostingDate	I_TrsyAccountingItem	PostingDate	Posting Date for GR
	TreasuryGLAccountAssignmentRef	I_TrsyAccountingItem	TreasuryGLAccountAssignmentRef
	ReferenceDocument	I_TrsyAccountingItem	ReferenceDocument	Reference Document
	ReferenceDocumentContext	I_TrsyAccountingItem	ReferenceDocumentContext	Reference Document Context
	ReverseDocumentFiscalYear	I_TrsyAccountingItem	ReverseDocumentFiscalYear	Year
	ReverseDocumentFiscalPeriod	I_TrsyAccountingItem	ReverseDocumentFiscalPeriod
	ReverseDocumentPostingDate	I_TrsyAccountingItem	ReverseDocumentPostingDate
	ReversalReferenceDocument	I_TrsyAccountingItem	ReversalReferenceDocument	Reversal Reference Document
	ReversalReferenceDocumentCntxt	I_TrsyAccountingItem	ReversalReferenceDocumentCntxt	Reversal Reference Document Context
	AccountingDocument	I_TrsyAccountingItem	AccountingDocument	Journal Entry
	ReverseDocument	I_TrsyAccountingItem	ReverseDocument	Reversed With
	TreasuryAccountingCode	I_TrsyPositionTransactionFlow	TreasuryAccountingCode
	FinancialExposureItem	I_TrsyPositionTransactionFlow	FinancialExposureItem
	FinancialExposureSubItem	I_TrsyPositionTransactionFlow	FinancialExposureSubItem

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_TrsyPosFlow.
-- 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_TrsyPosFlow AS
SELECT
  itrlttranspos.TreasuryLedgerFlow AS TreasuryTransactionFlow,
  itrlttranspos.BusinessTransactionDocUUID AS BusinessTransactionDocUUID,
  itrlttranspos.TreasuryPosition AS TreasuryPosition,
  itrlttranspos.TreasuryBusinessTransaction AS TreasuryBusinessTransaction,
  itrlttranspos.TreasuryUpdateTypeName AS TreasuryUpdateTypeName,
  itrlttranspos.TreasuryUpdateType AS TreasuryUpdateType,
  itrlttranspos.AmountInPositionCurrency AS AmountInPositionCurrency,
  itrlttranspos.PositionCurrency AS PositionCurrency,
  itrlttranspos.AmountInValuationCurrency AS AmountInValuationCurrency,
  itrlttranspos.ValuationCurrency AS ValuationCurrency,
  itrlttranspos.TreasuryPositionLedgerDate AS TreasuryPositionLedgerDate,
  itrlttranspos.TreasuryPositionTransferGroup AS TreasuryPositionTransferGroup,
  itrlttranspos.TreasuryPositionTransferFactor AS TreasuryPositionTransferFactor,
  itrlttranspos.TrsyPosQuantityChangeCategory AS TrsyPosQuantityChangeCategory,
  itrlttranspos.TrsyPosAmountChangeCategory AS TrsyPosAmountChangeCategory,
  itrlttranspos.QuantityInPieces AS QuantityInPieces,
  itrlttranspos.IndexCleanAmountInPositionCrcy AS IndexCleanAmountInPositionCrcy,
  itrlttranspos.NominalAmountInNominalCurrency AS NominalAmountInNominalCurrency,
  itrlttranspos.OriglNominalAmtInNominalCrcy AS OriglNominalAmtInNominalCrcy,
  itrlttranspos.NominalCurrency AS NominalCurrency,
  itrlttranspos.CalculationDate AS CalculationDate,
  itrlttranspos.CalcDateIsAsEndDateInclusive AS CalcDateIsAsEndDateInclusive,
  itrlttranspos.DueDate AS DueDate,
  itrlttranspos.CalculationPeriodStartDate AS CalculationPeriodStartDate,
  itrlttranspos.CalculationPeriodEndDate AS CalculationPeriodEndDate,
  itrlttranspos.EffectiveInterestRate AS EffectiveInterestRate,
  itrlttranspos.EffctvIntrstRateRdmptnSched AS EffctvIntrstRateRdmptnSched,
  itrlttranspos.NextEffectiveInterestRate AS NextEffectiveInterestRate,
  itrlttranspos.FixedRedemptionSchedule AS FixedRedemptionSchedule,
  itrlttranspos.CalculationBasis AS CalculationBasis,
  I_FinInstrProductGroup.FinInstrProductGroup AS FinInstrProductGroup,
  itrlttranspos.TreasuryBusinessTransStatus AS TreasuryBusinessTransStatus,
  itrlttranspos.TrsyIntragroupTransacStatus AS TrsyIntragroupTransacStatus,
  itrlttranspos.TreasuryBusinessTransCategory AS TreasuryBusinessTransCategory,
  itrlttranspos.OriglTrsyBusinessTransaction AS OriglTrsyBusinessTransaction,
  itrlttranspos.TrsyDerivedBusinessTransStatus AS TrsyDerivedBusinessTransStatus,
  itrlttranspos.TreasuryPosAssetLiabilityCode AS TreasuryPosAssetLiabilityCode,
  itrlttranspos.TrsyPosTransfSourceTargetCode AS TrsyPosTransfSourceTargetCode,
  itrlttranspos.TreasuryValuationArea AS TreasuryValuationArea,
  itrlttranspos.TreasuryValuationAreaName AS TreasuryValuationAreaName,
  itrlttranspos.TreasuryValuationClass AS TreasuryValuationClass,
  _TreasuryValuationClassText.TreasuryValuationClassName AS TreasuryValuationClassName,
  itrlttranspos.CompanyCode AS CompanyCode,
  itrlttranspos.FinancialInstrumentProductType AS FinancialInstrumentProductType,
  itrlttranspos.SecurityAccount AS SecurityAccount,
  itrlttranspos.SecurityClass AS SecurityClass,
  _SecurityClass.SecurityClassName AS SecurityClassName,
  _SecurityClass.SecurityClassDescription AS SecurityClassDescription,
  itrlttranspos.FinancialInstrValuationClass AS FinancialInstrValuationClass,
  _FinancialInstrValClassText.FinancialInstrValClassName AS FinancialInstrValClassName,
  itrlttranspos.TreasuryPositionLot AS TreasuryPositionLot,
  itrlttranspos.SecurityAccountGroup AS SecurityAccountGroup,
  itrlttranspos.LoanContract AS LoanContract,
  _LoanContract.LoanContractName AS LoanContractName,
  itrlttranspos.TreasuryPositionAccount AS TreasuryPositionAccount,
  itrlttranspos.TreasuryPositionLongShortCode AS TreasuryPositionLongShortCode,
  itrlttranspos.Fund AS Fund,
  itrlttranspos.GrantID AS GrantID,
  itrlttranspos.CostCenter AS CostCenter,
  itrlttranspos.ProfitCenter AS ProfitCenter,
  itrlttranspos.WBSElementInternalID AS WBSElementInternalID,
  itrlttranspos.FunctionalArea AS FunctionalArea,
  itrlttranspos._PositionIdentifier._WBSElementBasicData.WBSElementExternalID AS WBSElementExternalID,
  itrlttranspos._PositionIdentifier._WBSElementBasicData.WBSDescription AS WBSDescription,
  itrlttranspos.TrsyPosCustomDiffntnTerm1 AS TrsyPosCustomDiffntnTerm1,
  _TrsyPosCustomDiffntnTerm1._Text[1: Language = $session.system_language].TrsyPosCustomDiffntnTerm1Name AS TrsyPosCustomDiffntnTerm1Name,
  itrlttranspos.TrsyPosCustomDiffntnTerm2 AS TrsyPosCustomDiffntnTerm2,
  _TrsyPosCustomDiffntnTerm2._Text[1: Language = $session.system_language].TrsyPosCustomDiffntnTerm2Name AS TrsyPosCustomDiffntnTerm2Name,
  itrlttranspos.TrsyPosCustomDiffntnTerm3 AS TrsyPosCustomDiffntnTerm3,
  _TrsyPosCustomDiffntnTerm3._Text[1: Language = $session.system_language].TrsyPosCustomDiffntnTerm3Name AS TrsyPosCustomDiffntnTerm3Name,
  itrlttranspos.TrsyPosCustomDiffntnTerm4 AS TrsyPosCustomDiffntnTerm4,
  _TrsyPosCustomDiffntnTerm4._Text[1: Language = $session.system_language].TrsyPosCustomDiffntnTerm4Name AS TrsyPosCustomDiffntnTerm4Name,
  itrlttranspos.TrsyPosCustomDiffntnTerm5 AS TrsyPosCustomDiffntnTerm5,
  _TrsyPosCustomDiffntnTerm5._Text[1: Language = $session.system_language].TrsyPosCustomDiffntnTerm5Name AS TrsyPosCustomDiffntnTerm5Name,
  itrlttranspos.CentralClearingAccount AS CentralClearingAccount,
  itrlttranspos.CentralClearingAccountName AS CentralClearingAccountName,
  itrlttranspos.CompanyCodeName AS CompanyCodeName,
  _SecurityAccount.SecurityAccountName AS SecurityAccountName,
  _SecurityAccountGroup.SecurityAccountGroupName AS SecurityAccountGroupName,
  cast(case I_TrsyDistributorBusTrans.ActivityFinancialTransaction when ' ' then _TrdtOrigBusTrans._FinancialTransaction.Portfolio else I_TrsyDistributorBusTrans._FinancialTransaction.Portfolio end as rportb) as Portfolio AS PortfolioendasrportbasPortfolio,
  _SecurityClass.Issuer AS Issuer,
  itrlttranspos.TrsyPosQtyChangeCategoryName AS TrsyPosQtyChangeCategoryName,
  itrlttranspos.TreasuryPosChangeCategoryName AS TreasuryPosChangeCategoryName,
  itrlttranspos.DifferentiationPortfolio AS DifferentiationPortfolio,
  _DifferentiationPortfolioText.DifferentiationPortfolioName AS DifferentiationPortfolioName,
  itrlttranspos.FinancialTransaction AS FinancialTransaction,
  I_TrsyDistributorBusTrans.FinancialInstrActivityCategory AS FinancialInstrActivityCategory,
  I_TrsyDistributorBusTrans.FinancialInstrCharacteristic AS FinancialInstrCharacteristic,
  I_TrsyDistributorBusTrans.FinancialInstrumentReference AS FinancialInstrumentReference,
  I_TrsyDistributorBusTrans.FinancialInstrumentAssignment AS FinancialInstrumentAssignment,
  I_TrsyDistributorBusTrans.ConditionItemValidityStartDate AS ConditionItemValidityStartDate,
  I_TrsyDistributorBusTrans.CalcPeriodEndDateIsInclusive AS CalcPeriodEndDateIsInclusive,
  I_TrsyDistributorBusTrans.InterestCalculationMethod AS InterestCalculationMethod,
  TRAC.DebitGLAccount AS DebitGLAccount,
  TRAC.CreditGLAccount AS CreditGLAccount,
  TRAC.DebitCustomer AS DebitCustomer,
  TRAC.CreditCustomer AS CreditCustomer,
  TRAC.FiscalYear AS FiscalYear,
  TRAC.PostingFiscalPeriod AS FiscalPeriod,
  TRAC.PostingFiscalPeriod AS PostingFiscalPeriod,
  TRAC.PostingDate AS PostingDate,
  TRAC.TreasuryGLAccountAssignmentRef AS TreasuryGLAccountAssignmentRef,
  TRAC.ReferenceDocument AS ReferenceDocument,
  TRAC.ReferenceDocumentContext AS ReferenceDocumentContext,
  TRAC.ReverseDocumentFiscalYear AS ReverseDocumentFiscalYear,
  TRAC.ReverseDocumentFiscalPeriod AS ReverseDocumentFiscalPeriod,
  TRAC.ReverseDocumentPostingDate AS ReverseDocumentPostingDate,
  TRAC.ReversalReferenceDocument AS ReversalReferenceDocument,
  TRAC.ReversalReferenceDocumentCntxt AS ReversalReferenceDocumentCntxt,
  TRAC.AccountingDocument AS AccountingDocument,
  TRAC.ReverseDocument AS ReverseDocument,
  itrlttranspos.TreasuryAccountingCode AS TreasuryAccountingCode,
  itrlttranspos.FinancialExposureItem AS FinancialExposureItem,
  itrlttranspos.FinancialExposureSubItem AS FinancialExposureSubItem
FROM I_TrsyPositionTransactionFlow AS itrlttranspos
LEFT OUTER JOIN I_TrsyAccountingItem AS TRAC ON /* join condition not captured in parsed metadata */
INNER JOIN I_FinInstrProductGroup ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Treasurypositionlot AS _TreasuryPositionLot ON TreasuryPosition = _TreasuryPositionLot.TreasuryPosition AND TreasuryPositionLot = _TreasuryPositionLot.TreasuryPositionLot  -- association [0..1]
LEFT OUTER JOIN I_TrsyScrtyClScrtyAccountFlow AS _TrsyScrtyClScrtyAccountFlow ON itrlttranspos.TreasuryBusinessTransaction = _TrsyScrtyClScrtyAccountFlow.TreasuryBusinessTransaction AND itrlttranspos.TreasuryTransactionFlow = _TrsyScrtyClScrtyAccountFlow.TreasuryTransactionFlow  -- association [0..1]
LEFT OUTER JOIN I_TrsyPosAssetLbltyCodeText AS _TrsyPosAssetLbltyCodeText ON TreasuryPosAssetLiabilityCode = itrlttranspos.TreasuryPosAssetLiabilityCode AND _TrsyPosAssetLbltyCodeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_FinInstrProductGroupText AS _FinInstrProductGroupText ON FinInstrProductGroup = I_FinInstrProductGroup.FinInstrProductGroup AND _FinInstrProductGroupText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_TrsyFinExpsrItmText AS _TrsyFinExpsrItmText ON itrlttranspos.FinancialExposureItem = _TrsyFinExpsrItmText.FinancialExposureItem  -- association [0..1]
LEFT OUTER JOIN I_TrsyFinExpsrSubitemText AS _TrsyFinExpsrSubitemText ON itrlttranspos.TreasuryPosition = _TrsyFinExpsrSubitemText.TreasuryPosition  -- association [0..1]
LEFT OUTER JOIN I_TrsyPosCustomDiffntnTerm1 AS _TrsyPosCustomDiffntnTerm1 ON TrsyPosCustomDiffntnTerm1 = _TrsyPosCustomDiffntnTerm1.TrsyPosCustomDiffntnTerm1  -- association [0..1]
LEFT OUTER JOIN I_TrsyPosCustomDiffntnTerm2 AS _TrsyPosCustomDiffntnTerm2 ON TrsyPosCustomDiffntnTerm2 = _TrsyPosCustomDiffntnTerm2.TrsyPosCustomDiffntnTerm2  -- association [0..1]
LEFT OUTER JOIN I_TrsyPosCustomDiffntnTerm3 AS _TrsyPosCustomDiffntnTerm3 ON TrsyPosCustomDiffntnTerm3 = _TrsyPosCustomDiffntnTerm3.TrsyPosCustomDiffntnTerm3  -- association [0..1]
LEFT OUTER JOIN I_TrsyPosCustomDiffntnTerm4 AS _TrsyPosCustomDiffntnTerm4 ON TrsyPosCustomDiffntnTerm4 = _TrsyPosCustomDiffntnTerm4.TrsyPosCustomDiffntnTerm4  -- association [0..1]
LEFT OUTER JOIN I_TrsyPosCustomDiffntnTerm5 AS _TrsyPosCustomDiffntnTerm5 ON TrsyPosCustomDiffntnTerm5 = _TrsyPosCustomDiffntnTerm5.TrsyPosCustomDiffntnTerm5  -- association [0..1]
LEFT OUTER JOIN I_SecurityClass AS _SecurityClass ON SecurityClass = _SecurityClass.SecurityClass  -- association [0..1]
LEFT OUTER JOIN I_SecurityAccount AS _SecurityAccount ON SecurityAccount = _SecurityAccount.SecurityAccount AND CompanyCode = _SecurityAccount.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_DifferentiationPortfolioText AS _DifferentiationPortfolioText ON DifferentiationPortfolio = _DifferentiationPortfolioText.DifferentiationPortfolio AND CompanyCode = _DifferentiationPortfolioText.CompanyCode AND _DifferentiationPortfolioText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_TreasuryPositionAccount AS _TreasuryPositionAccount ON TreasuryPositionAccount = _TreasuryPositionAccount.TreasuryPositionAccount  -- association [0..1]
LEFT OUTER JOIN I_CentralClearingAccount AS _CentralClearingAccount ON CentralClearingAccount = _CentralClearingAccount.CentralClearingAccount AND CompanyCode = _CentralClearingAccount.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_LoanContract AS _LoanContract ON LoanContract = _LoanContract.LoanContract AND CompanyCode = _LoanContract.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FinancialInstrValClassText AS _FinancialInstrValClassText ON FinancialInstrValuationClass = _FinancialInstrValClassText.FinancialInstrValuationClass AND _FinancialInstrValClassText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_TreasuryValuationClassText AS _TreasuryValuationClassText ON TreasuryValuationClass = _TreasuryValuationClassText.TreasuryValuationClass AND TreasuryValuationArea = _TreasuryValuationClassText.TreasuryValuationArea AND _TreasuryValuationClassText.Language = $session.system_language  -- association [0..1]
;

Depth:

P_TrsyPosFlow view_entity

I_TrsyPositionTransactionFlow view_entity
I_FinInstrProductGroup view
I_TrsyAccountingItem view

A_TrsyPosFlow view_entity