A_TrsyPosFlow

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_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.
-- SQL view name: ATRSYPOSFLOW

CREATE VIEW A_TrsyPosFlow AS
SELECT
  TreasuryTransactionFlow,
  BusinessTransactionDocUUID,
  TreasuryPosition,
  TreasuryBusinessTransaction,
  TreasuryUpdateTypeName,
  TreasuryUpdateType,
  AmountInPositionCurrency,
  PositionCurrency,
  AmountInValuationCurrency,
  ValuationCurrency,
  TreasuryPositionLedgerDate,
  TreasuryPositionTransferGroup,
  TreasuryPositionTransferFactor,
  TrsyPosQuantityChangeCategory,
  TrsyPosAmountChangeCategory,
  cast( round(QuantityInPieces, 6) as tpm_units) AS QuantityInPieces,
  IndexCleanAmountInPositionCrcy,
  NominalAmountInNominalCurrency,
  OriglNominalAmtInNominalCrcy,
  NominalCurrency,
  CalculationDate,
  CalcDateIsAsEndDateInclusive,
  DueDate,
  CalculationPeriodStartDate,
  CalculationPeriodEndDate,
  EffectiveInterestRate,
  EffctvIntrstRateRdmptnSched,
  NextEffectiveInterestRate,
  FixedRedemptionSchedule,
  CalculationBasis,
  FinInstrProductGroup,
  TreasuryBusinessTransStatus,
  TrsyIntragroupTransacStatus,
  TreasuryBusinessTransCategory,
  OriglTrsyBusinessTransaction,
  TrsyDerivedBusTransacIsUpdated,
  TreasuryPosAssetLiabilityCode,
  TrsyPosTransfSourceTargetCode,
  TreasuryValuationArea,
  TreasuryValuationAreaName,
  TreasuryValuationClass,
  TreasuryValuationClassName,
  CompanyCode,
  FinancialInstrumentProductType,
  SecurityAccount,
  SecurityClass,
  SecurityClassName,
  SecurityClassDescription,
  FinancialInstrValClassName,
  TreasuryPositionLot,
  SecurityAccountGroup,
  LoanContract,
  LoanContractName,
  TreasuryPositionAccount,
  TreasuryPositionLongShortCode,
  Fund,
  GrantID,
  CostCenter,
  ProfitCenter,
  WBSElementExternalID,
  WBSDescription,
  FunctionalArea,
  TrsyPosCustomDiffntnTerm1,
  TrsyPosCustomDiffntnTerm1Name,
  TrsyPosCustomDiffntnTerm2,
  TrsyPosCustomDiffntnTerm2Name,
  TrsyPosCustomDiffntnTerm3,
  TrsyPosCustomDiffntnTerm3Name,
  TrsyPosCustomDiffntnTerm4,
  TrsyPosCustomDiffntnTerm4Name,
  TrsyPosCustomDiffntnTerm5,
  TrsyPosCustomDiffntnTerm5Name,
  CentralClearingAccount,
  CentralClearingAccountName,
  CompanyCodeName,
  SecurityAccountName,
  SecurityAccountGroupName,
  ActivityFinancialTransaction,
  FinancialInstrTransactionType,
  TreasuryFacilityCompanyCode,
  TreasuryFacility,
  ' ' AS TreasuryMasterAgreement,
  TreasuryFinanceProject,
  Counterparty,
  LetterOfCredit,
  FinancialInstrumentStatus,
  Portfolio,
  PortfolioName,
  Issuer,
  TrsyPosQtyChangeCategoryName,
  TreasuryPosChangeCategoryName,
  DifferentiationPortfolio,
  DifferentiationPortfolioName,
  FinancialTransaction,
  FinancialInstrActivityCategory,
  FinancialInstrCharacteristic,
  FinancialInstrumentReference,
  FinancialInstrumentAssignment,
  ConditionItemValidityStartDate,
  CalcPeriodEndDateIsInclusive,
  InterestCalculationMethod,
  DebitGLAccount,
  CreditGLAccount,
  DebitCustomer,
  CreditCustomer,
  FiscalYear,
  FiscalPeriod,
  PostingDate,
  TreasuryGLAccountAssignmentRef,
  ReferenceDocument,
  ReferenceDocumentContext,
  ReverseDocumentFiscalYear,
  ReverseDocumentFiscalPeriod,
  ReverseDocumentPostingDate,
  ReversalReferenceDocument,
  ReversalReferenceDocumentCntxt,
  AccountingDocument,
  ReverseDocument,
  FinancialExposureItem,
  FinancialExposureSubItem,
  TreasuryAccountingCode
FROM P_TrsyPosFlow
;