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 I_TrsyPositionTransactionFlow.
-- 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: ITRSYPOSTRANSFLW
CREATE VIEW I_TrsyPositionTransactionFlow AS
SELECT
trltflow.TreasuryLedgerFlow AS TreasuryLedgerFlow,
trltflow.TreasuryTransactionFlow AS TreasuryTransactionFlow,
cast( trltflow.TreasuryLedgerTransaction as ftr_gen_bus_trans_guid preserving type ) AS BusinessTransactionDocUUID,
cast( trltflow.TreasuryPosition as ftr_gen_position_uuid preserving type ) AS TreasuryPosition,
cast( _TreasuryUpdateTypeText.TreasuryUpdateTypeName as ftr_gen_update_type_name preserving type ) AS TreasuryUpdateTypeName,
cast( trltflow.TreasuryUpdateType as tpm_dis_flowtype preserving type ) AS TreasuryUpdateType,
cast( trltflow.AmountInPositionCurrency as ftr_gen_amount_position_crcy preserving type ) AS AmountInPositionCurrency,
cast( trltflow.PositionCurrency as ftr_gen_position_crcy preserving type ) AS PositionCurrency,
cast( trltflow.AmountInValuationCurrency as ftr_gen_amount_valuation_crcy preserving type ) AS AmountInValuationCurrency,
cast( trltflow.ValuationCurrency as ftr_gen_valuation_currency preserving type ) AS ValuationCurrency,
cast( I_TrsyLdgrPosChangeCatTxt.TreasuryPosChangeCategoryName as ftr_gen_pos_change_categ_name preserving type ) AS TreasuryPosChangeCategoryName,
cast( trltflow.TrsyPosTransfSourceTargetCode as ftr_gen_pos_transfer_src_trg preserving type ) AS TrsyPosTransfSourceTargetCode,
cast( trltflow.TreasuryPositionTransferGroup as ftr_gen_pos_transfer_group preserving type ) AS TreasuryPositionTransferGroup,
cast( trltflow.TreasuryPositionTransferFactor as ftr_gen_pos_transfer_coeff preserving type ) AS TreasuryPositionTransferFactor,
cast( trltflow.TrsyPosQuantityChangeCategory as ftr_gen_pos_chng_quant_categ preserving type ) AS TrsyPosQuantityChangeCategory,
cast( _PositionChangeCategoryQtyName.ddtext as tpm_qty_pm_cat_name preserving type ) AS TrsyPosQtyChangeCategoryName,
cast( trltflow.TrsyPosAmountChangeCategory as ftr_gen_pos_chng_amount_categ preserving type ) AS TrsyPosAmountChangeCategory,
cast( trltflow.QuantityInPieces as ftr_gen_quantity_in_units_l ) AS QuantityInPieces,
trltflow.NominalAmountInNominalCurrency AS NominalAmountInNominalCurrency,
cast( trltflow.OriglNominalAmtInNominalCrcy as ftr_gen_nominal_amount_orig preserving type ) AS OriglNominalAmtInNominalCrcy,
cast( trltflow.NominalCurrency as ftr_gen_nominal_currency preserving type ) AS NominalCurrency,
cast( trltflow.IndexCleanRpaytAmtInPosCrcy as ftr_gen_idxcln_amnt_pstn_crcy preserving type ) AS IndexCleanAmountInPositionCrcy,
cast( trltflow.CalculationDate as farp_dzindt preserving type ) AS CalculationDate,
cast( trltflow.CalcDateIsAsEndDateInclusive as ftr_gen_vvsincl preserving type ) AS CalcDateIsAsEndDateInclusive,
trltflow.DueDate AS DueDate,
trltflow.CalculationPeriodStartDate AS CalculationPeriodStartDate,
trltflow.CalculationPeriodEndDate AS CalculationPeriodEndDate,
trltflow.EffectiveInterestRate AS EffectiveInterestRate,
cast( trltflow.EffctvIntrstRateRdmptnSched as ftr_gen_rdmptn_schedule_eff_ir preserving type ) AS EffctvIntrstRateRdmptnSched,
trltflow.NextEffectiveInterestRate AS NextEffectiveInterestRate,
cast( trltflow.FixedRedemptionSchedule as ftr_gen_rdmptn_schedule_fixed preserving type ) AS FixedRedemptionSchedule,
trltflow.CalculationBasis AS CalculationBasis,
transaction.FinInstrProductGroup AS FinInstrProductGroup,
transaction.TreasuryBusinessTransCategory AS TreasuryBusinessTransCategory,
transaction.TreasuryPositionLedgerDate AS TreasuryPositionLedgerDate,
transaction.TreasuryBusinessTransaction AS TreasuryBusinessTransaction,
transaction.TrsyBusTransactionCreationDate AS CreationDate,
transaction.TrsyBusTransactionCreationTime AS CreationTime,
transaction.TrsyDerivedBusTransacIsUpdated AS TrsyDerivedBusTransacIsUpdated,
transaction.TreasuryBusinessTransStatus AS TreasuryBusinessTransStatus,
transaction.OriglTrsyBusinessTransaction AS OriglTrsyBusinessTransaction,
transaction.TrsyIntragroupTransacStatus AS TrsyIntragroupTransacStatus,
transaction.TreasuryUserStatisticsUUID AS TreasuryUserStatisticsUUID,
cast(position.TreasuryPosAssetLiabilityCode as ftr_gen_asset_liab_indicator preserving type ) AS TreasuryPosAssetLiabilityCode,
position.CreatedByUser AS CreatedByUser,
position.FirstResponseByDate AS FirstResponseByDate,
position.CorrespondenceCreationTime AS CorrespondenceCreationTime,
_PositionIdentifier.Fund AS Fund,
_PositionIdentifier.GrantID AS GrantID,
_PositionIdentifier.CostCenter AS CostCenter,
_PositionIdentifier.ProfitCenter AS ProfitCenter,
_PositionIdentifier._WBSElementBasicData.WBSElementExternalID AS WBSElementExternalID,
_PositionIdentifier.WBSElementInternalID AS WBSElementInternalID,
_PositionIdentifier.FunctionalArea AS FunctionalArea,
_PositionIdentifier.TrsyPosCustomDiffntnTerm1 AS TrsyPosCustomDiffntnTerm1,
_PositionIdentifier.TrsyPosCustomDiffntnTerm2 AS TrsyPosCustomDiffntnTerm2,
_PositionIdentifier.TrsyPosCustomDiffntnTerm3 AS TrsyPosCustomDiffntnTerm3,
_PositionIdentifier.TrsyPosCustomDiffntnTerm4 AS TrsyPosCustomDiffntnTerm4,
_PositionIdentifier.TrsyPosCustomDiffntnTerm5 AS TrsyPosCustomDiffntnTerm5,
_PositionIdentifier.TreasuryValuationClass AS TreasuryValuationClass,
_PositionIdentifier.TreasuryValuationArea AS TreasuryValuationArea,
_PositionIdentifier._TreasuryValuationArea.TreasuryValuationAreaName AS TreasuryValuationAreaName,
_PositionIdentifier._TreasuryValuationClassText.TreasuryValuationClassName AS TreasuryValuationClassName,
_PositionIdentifier.CompanyCode AS CompanyCode,
_PositionIdentifier.FinancialInstrumentProductType AS FinancialInstrumentProductType,
_PositionIdentifier.SecurityAccount AS SecurityAccount,
_PositionIdentifier.SecurityClass AS SecurityClass,
_PositionIdentifier._SecurityClass.SecurityClassName AS SecurityClassName,
_PositionIdentifier._SecurityClass.SecurityClassDescription AS SecurityClassDescription,
_PositionIdentifier.FinancialInstrValuationClass AS FinancialInstrValuationClass,
_PositionIdentifier.DifferentiationPortfolio AS DifferentiationPortfolio,
_PositionIdentifier._DifferentiationPortfolioText.DifferentiationPortfolioName AS DifferentiationPortfolioName,
_PositionIdentifier.Trader AS Trader,
_PositionIdentifier.TreasuryPositionLot AS TreasuryPositionLot,
_PositionIdentifier.SecurityAccountGroup AS SecurityAccountGroup,
_PositionIdentifier.LoanContract AS LoanContract,
_PositionIdentifier._LoanContract.LoanContractName AS LoanContractName,
_PositionIdentifier.TreasuryPositionAccount AS TreasuryPositionAccount,
_PositionIdentifier.TreasuryPositionLongShortCode AS TreasuryPositionLongShortCode,
_PositionIdentifier.FinancialTransaction AS FinancialTransaction,
_PositionIdentifier.CentralClearingAccount AS CentralClearingAccount,
_PositionIdentifier._CentralClearingAccount.CentralClearingAccountName AS CentralClearingAccountName,
_PositionIdentifier.CentralClearingAccountCurrency AS CentralClearingAccountCurrency,
_PositionIdentifier._CompanyCode.CompanyCodeName AS CompanyCodeName,
_PositionIdentifier._SecurityAccount.SecurityAccountName AS SecurityAccountName,
_PositionIdentifier._SecurityAccountGroup.SecurityAccountGroupName AS SecurityAccountGroupName,
_PositionIdentifier._TreasuryPositionAccount.TreasuryPositionAccountName AS TreasuryPositionAccountName,
cast( _PositionIdentifier._SecurityClass.Issuer as repke_new preserving type ) AS Issuer,
_PositionIdentifier._FinancialInstrValClassText.FinancialInstrValClassName AS FinancialInstrValClassName,
_PositionIdentifier.TreasuryAccountingCode AS TreasuryAccountingCode,
_PositionIdentifier.FinancialExposureItem AS FinancialExposureItem,
_PositionIdentifier.FinancialExposureSubItem AS FinancialExposureSubItem
FROM I_TreasuryLedgerFlow AS trltflow
INNER JOIN I_TreasuryLedgerPosition AS position ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_TrsyScrtyClScrtyAccountFlow AS _TrsyScrtyClScrtyAccountFlow ON TreasuryBusinessTransaction = _TrsyScrtyClScrtyAccountFlow.TreasuryBusinessTransaction AND TreasuryTransactionFlow = _TrsyScrtyClScrtyAccountFlow.TreasuryTransactionFlow -- association [0..1]
LEFT OUTER JOIN I_SecurityClassRdmptnSchedule AS _SecurityClassRdmptnSchedule ON FixedRedemptionSchedule = _SecurityClassRdmptnSchedule.FixedRedemptionSchedule -- association [0..1]
LEFT OUTER JOIN I_TrsyPosAssetLbltyCodeText AS _TrsyPosAssetLbltyCodeText ON TreasuryPosAssetLiabilityCode = _TrsyPosAssetLbltyCodeText.TreasuryPosAssetLiabilityCode AND _TrsyPosAssetLbltyCodeText.Language = $session.system_language -- association [0..1]
;