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 C_TreasuryPositionFlow.
-- 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: CTRSYPOSFLOW
CREATE VIEW C_TreasuryPositionFlow AS
SELECT
itrlttranspos.TreasuryLedgerFlow AS TreasuryLedgerFlow,
itrlttranspos.BusinessTransactionDocUUID AS BusinessTransactionDocUUID,
itrlttranspos.TreasuryPosition AS TreasuryPosition,
itrlttranspos.TreasuryBusinessTransaction AS TreasuryBusinessTransaction,
itrlttranspos.TreasuryUpdateTypeName AS TreasuryUpdateTypeName,
itrlttranspos.TreasuryUpdateType AS TreasuryUpdateType,
itrlttranspos._TreasuryBusTransCategoryText[1: Language=$session.system_language].TreasuryBusTransCategoryName AS TreasuryBusTransCategoryName,
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,
itrlttranspos._SecurityClassRdmptnSchedule.FixedRedemptionScheduleName AS FixedRedemptionScheduleName,
itrlttranspos._SecurityClassRdmptnSchedule.FixedRedemptionScheduleDesc AS FixedRedemptionScheduleDesc,
I_FinInstrProductGroup.FinInstrProductGroup AS FinInstrProductGroup,
I_FinInstrProductGroup._FinInstrProductGroupText[1: Language=$session.system_language].FinInstrProductGroupName AS FinInstrProductGroupName,
itrlttranspos.TreasuryBusinessTransStatus AS TreasuryBusinessTransStatus,
itrlttranspos.TrsyIntragroupTransacStatus AS TrsyIntragroupTransacStatus,
itrlttranspos.TreasuryBusinessTransCategory AS TreasuryBusinessTransCategory,
itrlttranspos.OriglTrsyBusinessTransaction AS OriglTrsyBusinessTransaction,
itrlttranspos.TrsyDerivedBusTransacIsUpdated AS TrsyDerivedBusTransacIsUpdated,
itrlttranspos.TreasuryPosAssetLiabilityCode AS TreasuryPosAssetLiabilityCode,
itrlttranspos._TrsyPosAssetLbltyCodeText[1: Language=$session.system_language].TrsyPosAssetLiabilityCodeName AS TrsyPosAssetLiabilityCodeName,
itrlttranspos.TrsyPosTransfSourceTargetCode AS TrsyPosTransfSourceTargetCode,
itrlttranspos._Treasurybustransstatustext[1: Language=$session.system_language].TreasuryBusTransStatusName AS TreasuryBusTransStatusName,
itrlttranspos.TreasuryValuationArea AS TreasuryValuationArea,
itrlttranspos.TreasuryValuationAreaName AS TreasuryValuationAreaName,
itrlttranspos.TreasuryValuationClass AS TreasuryValuationClass,
itrlttranspos.TreasuryValuationClassName AS TreasuryValuationClassName,
itrlttranspos.CompanyCode AS CompanyCode,
itrlttranspos.CompanyCodeName AS CompanyCodeName,
itrlttranspos.FinancialInstrumentProductType AS FinancialInstrumentProductType,
itrlttranspos.SecurityAccount AS SecurityAccount,
itrlttranspos.SecurityClass AS SecurityClass,
itrlttranspos.SecurityClassName AS SecurityClassName,
itrlttranspos.SecurityClassDescription AS SecurityClassDescription,
itrlttranspos.FinancialInstrValClassName AS FinancialInstrValClassName,
itrlttranspos.TreasuryPositionLot AS TreasuryPositionLotUUID,
itrlttranspos.SecurityAccountGroup AS SecurityAccountGroup,
itrlttranspos.LoanContract AS LoanContract,
itrlttranspos.LoanContractName AS LoanContractName,
itrlttranspos.TreasuryPositionAccount AS TreasuryPositionAccount,
itrlttranspos.TreasuryPositionLongShortCode AS TreasuryPositionLongShortCode,
_Treasurypositionlot.PosGenFinancialTransaction AS PosGenFinancialTransaction,
_Treasurypositionlot.TrsyPositionLotCreatedByUser AS TrsyPositionLotCreatedByUser,
itrlttranspos.Fund AS Fund,
itrlttranspos.GrantID AS GrantID,
itrlttranspos.WBSElementExternalID AS WBSElementExternalID,
itrlttranspos.FunctionalArea AS FunctionalArea,
itrlttranspos.CostCenter AS CostCenter,
itrlttranspos.ProfitCenter AS ProfitCenter,
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.SecurityAccountName AS SecurityAccountName,
itrlttranspos.SecurityAccountGroupName AS SecurityAccountGroupName,
cast(case _TrsyDistributorBusTrans.ActivityFinancialTransaction when ' ' then _TrdtOrigBusTrans._FinancialTransaction.Portfolio else _TrsyDistributorBusTrans._FinancialTransaction.Portfolio end as rportb) as Portfolio AS PortfolioendasrportbasPortfolio,
itrlttranspos.Issuer AS Issuer,
itrlttranspos.TrsyPosQtyChangeCategoryName AS TrsyPosQtyChangeCategoryName,
itrlttranspos.TreasuryPosChangeCategoryName AS TreasuryPosChangeCategoryName,
itrlttranspos.DifferentiationPortfolio AS DifferentiationPortfolio,
itrlttranspos.DifferentiationPortfolioName AS DifferentiationPortfolioName,
itrlttranspos._TrltPosattrib.TrsyPosFreeDefinedAttribute1 AS TrsyPosFreeDefinedAttribute1,
itrlttranspos._TrltPosattrib.TrsyPosFreeDefinedAttribute2 AS TrsyPosFreeDefinedAttribute2,
itrlttranspos._TrltPosattrib.TrsyPosFreeDefinedAttribute3 AS TrsyPosFreeDefinedAttribute3,
itrlttranspos._TrltPosattrib.TrsyPosFreeDefinedAttribute4 AS TrsyPosFreeDefinedAttribute4,
itrlttranspos._TrltPosattrib.TrsyPosFreeDefinedAttribute5 AS TrsyPosFreeDefinedAttribute5,
itrlttranspos._TrltPosattrib.TrsyPosFreeDefinedAttribute6 AS TrsyPosFreeDefinedAttribute6,
itrlttranspos._TrltPosattrib.TrsyPosFreeDefinedAttribute7 AS TrsyPosFreeDefinedAttribute7,
itrlttranspos._TrltPosattrib.TrsyPosFreeDefinedAttribute8 AS TrsyPosFreeDefinedAttribute8,
itrlttranspos._TrltPosattrib.TrsyPosFreeDefinedAttribute9 AS TrsyPosFreeDefinedAttribute9,
itrlttranspos._TrltPosattrib.TrsyPosFreeDfndAttribute1Name AS TrsyPosFreeDfndAttribute1Name,
itrlttranspos._TrltPosattrib.TrsyPosFreeDfndAttribute2Name AS TrsyPosFreeDfndAttribute2Name,
itrlttranspos._TrltPosattrib.TrsyPosFreeDfndAttribute3Name AS TrsyPosFreeDfndAttribute3Name,
itrlttranspos._TrltPosattrib.TrsyPosFreeDfndAttribute4Name AS TrsyPosFreeDfndAttribute4Name,
itrlttranspos._TrltPosattrib.TrsyPosFreeDfndAttribute5Name AS TrsyPosFreeDfndAttribute5Name,
itrlttranspos._TrltPosattrib.TrsyPosFreeDfndAttribute6Name AS TrsyPosFreeDfndAttribute6Name,
itrlttranspos._TrgtUserData.CreatedByUser AS CreatedByUser,
itrlttranspos._TrgtUserData.CreationDate AS CreationDate,
itrlttranspos._TrgtUserData.CorrespondenceCreationTime AS CorrespondenceCreationTime,
itrlttranspos._TrgtUserData.CreationTransactionCode AS CreationTransactionCode,
itrlttranspos._TrgtUserData.LastChangedByUser AS LastChangedByUser,
itrlttranspos._TrgtUserData.ChangeTransactionCode AS ChangeTransactionCode,
itrlttranspos.FinancialTransaction AS FinancialTransaction,
_TrsyDistributorBusTrans.FinancialInstrActivityCategory AS FinancialInstrActivityCategory,
_TrsyDistributorBusTrans.FinancialInstrCharacteristic AS FinancialInstrCharacteristic,
_TrsyDistributorBusTrans.FinancialInstrumentReference AS FinancialInstrumentReference,
_TrsyDistributorBusTrans.FinancialInstrumentAssignment AS FinancialInstrumentAssignment,
_TrsyDistributorBusTrans.ConditionItemValidityStartDate AS ConditionItemValidityStartDate,
_TrsyDistributorBusTrans.CalcPeriodEndDateIsInclusive AS CalcPeriodEndDateIsInclusive,
_TrsyDistributorBusTrans.InterestCalculationMethod AS InterestCalculationMethod,
itrlttranspos._TreasuryPaymentRequest.HouseBank AS HouseBank,
itrlttranspos._TreasuryPaymentRequest.HouseBankAccount AS HouseBankAccount,
cast(itrlttranspos._TreasuryPaymentRequest._HouseBank._Bank.BankName as ftr_gen_house_bank_name) AS HouseBankName,
cast(itrlttranspos._TreasuryPaymentRequest._HouseBankAccountText.HouseBankAccountDescription as ftr_gen_house_bank_acc_descr) AS HouseBankAccountDescription,
_TrsyDistributorBusTrans.PaymentReason AS PaymentReason,
case when itrlttranspos._TreasuryPaymentRequest.PaymentDate is null then _TrsyDistributorBusTrans.PaymentDate else itrlttranspos._TreasuryPaymentRequest.PaymentDate end as PaymentDate AS PaymentDateendasPaymentDate,
itrlttranspos._TreasuryPaymentRequest.PaymentRequest AS PaymentRequest,
itrlttranspos._TreasuryPaymentRequest.PaytReqOriglReferenceDocument AS PaytReqOriglReferenceDocument,
itrlttranspos._TreasuryPaymentRequest.Customer AS Customer,
cast(itrlttranspos._TreasuryPaymentRequest._Customer.BusinessPartnerName1 as ftr_gen_customer_name) AS CustomerName,
cast(itrlttranspos._TreasuryPaymentRequest.Supplier as ftr_gen_supplier) AS Supplier,
cast(itrlttranspos._TreasuryPaymentRequest._Supplier._AddressDefaultRepresentation.AddresseeName1 as ftr_gen_supplier_name) AS SupplierName,
itrlttranspos._TreasuryPaymentRequest.TreasuryPaymentRequestGrouping AS TreasuryPaymentRequestGrouping,
itrlttranspos._TreasuryPaymentRequest.TrsyPaytRequestReleaseStatus AS TrsyPaytRequestReleaseStatus,
itrlttranspos._TreasuryPaymentRequest.PaymentRequestPaymentGroup AS PaymentRequestPaymentGroup,
itrlttranspos._TreasuryPaymentRequest.PaytReqAdditionalInstructions AS PaytReqAdditionalInstructions,
itrlttranspos._TreasuryPaymentRequest.PaytReqAddlInstructionsName AS PaytReqAddlInstructionsName,
itrlttranspos._TreasuryPaymentRequest.TrsyPaytReqItemAdditionalText AS TrsyPaytReqItemAdditionalText,
itrlttranspos._TreasuryPaymentRequest.DataExchangeInstructionKey AS DataExchangeInstructionKey,
TRAC.DebitGLAccount AS DebitGLAccount,
TRAC.CreditGLAccount AS CreditGLAccount,
TRAC.DebitCustomer AS DebitCustomer,
TRAC.CreditCustomer AS CreditCustomer,
TRAC.FiscalYear AS FiscalYear,
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._TrsyScrtyClScrtyAccountFlow.SecurityCouponDate AS SecurityCouponDate,
itrlttranspos._TrsyScrtyClScrtyAccountFlow.SecurityCouponDelivery AS SecurityCouponDelivery,
itrlttranspos._TrsyScrtyClScrtyAccountFlow.CashFlowCalculationCategory AS CashFlowCalculationCategory,
itrlttranspos._TrsyScrtyClScrtyAccountFlow.CalcPeriodStartDateIsExclusive AS CalcPeriodStartDateIsExclusive,
itrlttranspos._TrsyScrtyClScrtyAccountFlow.CalcPeriodStartDateIsMonthEnd AS CalcPeriodStartDateIsMonthEnd,
itrlttranspos._TrsyScrtyClScrtyAccountFlow.CalcPeriodEndDateIsMonthEnd AS CalcPeriodEndDateIsMonthEnd,
itrlttranspos._TrsyScrtyClScrtyAccountFlow.CalculationDateIsMonthEnd AS CalculationDateIsMonthEnd,
itrlttranspos._TrsyScrtyClScrtyAccountFlow.DueDateIsMonthEnd AS DueDateIsMonthEnd,
_TrsyDistributorBusTrans.NumberOfDays AS NumberOfDays,
itrlttranspos._TrsyScrtyClScrtyAccountFlow.NumberOfCalculationDays AS NumberOfCalculationDays,
itrlttranspos._TrsyScrtyClScrtyAccountFlow.InterestBaseDaysMethod AS InterestBaseDaysMethod,
itrlttranspos._TrsyScrtyClScrtyAccountFlow.PeriodStartDateIsExclusive AS PeriodStartDateIsExclusive,
itrlttranspos._TrsyScrtyClScrtyAccountFlow.PeriodStartDateIsMonthEnd AS PeriodStartDateIsMonthEnd,
itrlttranspos._TrsyScrtyClScrtyAccountFlow.PeriodEndDateIsInclusive AS PeriodEndDateIsInclusive,
itrlttranspos._TrsyScrtyClScrtyAccountFlow.PeriodEndDateIsMonthEnd AS PeriodEndDateIsMonthEnd,
itrlttranspos._TrsyScrtyClScrtyAccountFlow.AccruedInterestMethod AS AccruedInterestMethod,
itrlttranspos._TrsyScrtyClScrtyAccountFlow.AccruedInterestCalcMethod AS AccruedInterestCalcMethod,
itrlttranspos._TrsyScrtyClScrtyAccountFlow.InterestDaysCalendar AS InterestDaysCalendar,
itrlttranspos._TrsyScrtyClScrtyAccountFlow.FinConditionConditionType AS FinConditionConditionType,
itrlttranspos._TrsyScrtyClScrtyAccountFlow.AccruedInterestIsContained AS AccruedInterestIsContained,
itrlttranspos.TreasuryAccountingCode AS TreasuryAccountingCode,
itrlttranspos.FinancialExposureItem AS FinancialExposureItem,
_TrsyFinExpsrItmText.FinancialExposureItemName AS FinancialExposureItemName,
itrlttranspos.FinancialExposureSubItem AS FinancialExposureSubItem,
_TrsyFinExpsrSubitemText.FinancialExposureSubItemName AS FinancialExposureSubItemName
FROM I_TrsyPositionTransactionFlow AS itrlttranspos
INNER JOIN I_FinInstrProductGroup ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_TrsyDistributorBusTrans AS _TrdtOrigBusTrans ON itrlttranspos.OriglTrsyBusinessTransaction = _TrdtOrigBusTrans.TreasuryBusinessTransaction AND itrlttranspos.TreasuryTransactionFlow = _TrdtOrigBusTrans.TreasuryTransactionFlow -- association [0..1]
LEFT OUTER JOIN I_TrsyDistributorBusTrans AS _TrsyDistributorBusTrans ON itrlttranspos.TreasuryBusinessTransaction = _TrsyDistributorBusTrans.TreasuryBusinessTransaction AND itrlttranspos.TreasuryTransactionFlow = _TrsyDistributorBusTrans.TreasuryTransactionFlow -- association [0..1]
LEFT OUTER JOIN I_Treasurypositionlot AS _Treasurypositionlot ON TreasuryPosition = _Treasurypositionlot.TreasuryPosition AND TreasuryPositionLotUUID = _Treasurypositionlot.TreasuryPositionLot -- association [0..1]
LEFT OUTER JOIN I_SecurityAccountGroup AS _SecurityAccountGroup ON SecurityAccountGroup = _SecurityAccountGroup.SecurityAccountGroup AND CompanyCode = _SecurityAccountGroup.CompanyCode -- association [0..1]
LEFT OUTER JOIN I_FinancialTransactionVH AS _FinancialTransactionVH ON FinancialTransaction = _FinancialTransactionVH.FinancialTransaction AND CompanyCode = _FinancialTransactionVH.CompanyCode -- association [0..1]
LEFT OUTER JOIN I_FinancialTransactionVH AS _ActivFinancialTransactionVH ON ActivityFinancialTransaction = _ActivFinancialTransactionVH.FinancialTransaction AND CompanyCode = _ActivFinancialTransactionVH.CompanyCode -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode -- association [0..1]
LEFT OUTER JOIN I_HouseBankAccountVH AS _HouseBankAccountVH ON CompanyCode = _HouseBankAccountVH.CompanyCode AND HouseBank = _HouseBankAccountVH.HouseBank AND HouseBankAccount = _HouseBankAccountVH.HouseBankAccount -- association [0..1]
LEFT OUTER JOIN I_CentralClearingAccountVH AS _CentralClearingAccountVH ON CompanyCode = _CentralClearingAccountVH.CompanyCode AND CentralClearingAccount = _CentralClearingAccountVH.CentralClearingAccount -- 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 itrlttranspos.TrsyPosCustomDiffntnTerm1 = _TrsyPosCustomDiffntnTerm1.TrsyPosCustomDiffntnTerm1 -- association [0..1]
LEFT OUTER JOIN I_TrsyPosCustomDiffntnTerm2 AS _TrsyPosCustomDiffntnTerm2 ON itrlttranspos.TrsyPosCustomDiffntnTerm2 = _TrsyPosCustomDiffntnTerm2.TrsyPosCustomDiffntnTerm2 -- association [0..1]
LEFT OUTER JOIN I_TrsyPosCustomDiffntnTerm3 AS _TrsyPosCustomDiffntnTerm3 ON itrlttranspos.TrsyPosCustomDiffntnTerm3 = _TrsyPosCustomDiffntnTerm3.TrsyPosCustomDiffntnTerm3 -- association [0..1]
LEFT OUTER JOIN I_TrsyPosCustomDiffntnTerm4 AS _TrsyPosCustomDiffntnTerm4 ON itrlttranspos.TrsyPosCustomDiffntnTerm4 = _TrsyPosCustomDiffntnTerm4.TrsyPosCustomDiffntnTerm4 -- association [0..1]
LEFT OUTER JOIN I_TrsyPosCustomDiffntnTerm5 AS _TrsyPosCustomDiffntnTerm5 ON itrlttranspos.TrsyPosCustomDiffntnTerm5 = _TrsyPosCustomDiffntnTerm5.TrsyPosCustomDiffntnTerm5 -- association [0..1]
;