A_TrsyPosFlow

Treasury Position Flow | view: ATRSYPOSFLOW | Extraction: Not supported | Component: Treasury and Risk Management
Tables used: TLCT_ACTIVITY, DIFT_POS_IDENT, TRLT_FLOW, TRLT_POSITION, TRLT_TRANSACTION, TRACT_DOCUMENT, TRACT_POSCONTEXT, TRDT_TRDBUSTRANS, TRDT_FLOW, TRDT_SEC_FLOW, TREAT_EXT_ACC, T001, TKA02, TWPOB_T, TZPAT, TRGC_COM_VALCL_T, VTBFHA, TZAF, TZPA, VDARL, TWD01, VWPANLA, TWPOB, TRFT_POS_ACCOUNT, TRDC_DFLOWTYPE_T, TRGC_VAL_CLASS_T, TRACT_ACCITEM, TRLTS_PMCAT_T, TRGT_SECACCGRP, TRGC_VAL_AREA
Column Name Description
TreasuryTransactionFlow Number of TRL Flow
BusinessTransactionDocUUID FK Business Transaction (GUID)
Column Name Description
💲 Position Currency (PositionCurrency):
AmountInPositionCurrency Amount in Position Currency
IndexCleanAmountInPositionCrcy Index Clean Amount in Position Currency
CalculationBasis Calculation Base Amount
💲 Valuation Currency (ValuationCurrency):
AmountInValuationCurrency Amount in Valuation Currency
💲 Nominal Currency (NominalCurrency):
NominalAmountInNominalCurrency Nominal Amount
OriglNominalAmtInNominalCrcy Original Nominal Amount
Column Name Description
Column Name Description
TreasuryPositionLedgerDate Treasury Ledger Date
CalculationDate Key Date of Last Interest Calculation
DueDate Due Date
CalculationPeriodStartDate Start of Calculation Period
CalculationPeriodEndDate End of Calculation Period
ConditionItemValidityStartDate Condition Item Effective From
PostingDate Posting Date in the Document
ReverseDocumentPostingDate Reverse Document Posting Date
Column Name Description
TrsyPosQuantityChangeCategory Position Change Category (Quantity) Show values
CalcDateIsAsEndDateInclusive Incl./Excl. Indicator for Beginning and End of a Period Show values
FinInstrProductGroup Financial Instrument Product Group Show values
TreasuryBusinessTransStatus Posting Status Treasury Ledger Business Transaction Show values
TrsyIntragroupTransacStatus Intragroup Transaction Status Show values
TrsyDerivedBusTransacIsUpdated Status of Treasury Ledger Business Transaction Show values
TreasuryPosAssetLiabilityCode Assets/Liabilities Position Show values
TrsyPosTransfSourceTargetCode Position Transfer Show values
TreasuryPositionLongShortCode Code: Long or Short Position Show values
FinancialInstrumentStatus Active Status of Transaction or Activity Show values
CalcPeriodEndDateIsInclusive Inclusive Indicator for the End of a Calculation Period Show values
InterestCalculationMethod Interest Calculation Method Show values
Column Name Description Domain name
TreasuryBusinessTransaction Identifier of the Distributor Business Transaction SYSUUID
TreasuryUpdateTypeName Name of the Update Type FTR_GEN_DESCRIPTION
TreasuryUpdateType Update Type TPM_DIS_FLOWTYPE
TreasuryPositionTransferGroup Position Transfer Group TPM_SYSTEM_KEY
TreasuryPositionTransferFactor Position Transfer Coefficient TPM_AMOUNT_FACTOR
TrsyPosAmountChangeCategory Position Change Category (Amount) TPM_PM_CAT
QuantityInPieces Quantity in Pieces FTR_GEN_UNITS
EffectiveInterestRate For Calculation of Amortization Amts (SAC) for Used EffInR DEC3_7
EffctvIntrstRateRdmptnSched Redemption Schedule that Explains Effective Interest Rate
NextEffectiveInterestRate Valid Effective Interest Rate for the Next Amortization DEC3_7
FixedRedemptionSchedule Fixed Redemption Schedule
OriglTrsyBusinessTransaction Original Business Transaction SYSUUID
TreasuryValuationAreaName Name of the Valuation Area FTR_GEN_DESCRIPTION
TreasuryValuationClassName Name of the Valuation Class FTR_GEN_DESCRIPTION
SecurityClassName Name of the Security Class XKBEZ
SecurityClassDescription Description of the Security Class XLBEZ
FinancialInstrValClassName Name of the Financial Instrument Valuation Class FTR_GEN_DESCRIPTION
TreasuryPositionLot Identifier of the Lot SYSUUID
LoanContractName Name of the Loan Contract XTEXT50
Fund Fund BP_GEBER
GrantID Grant GM_GRANT_NBR
CentralClearingAccount Central Clearing Account FTR_GEN_CNTRL_CLEARING_ACCOUNT
CentralClearingAccountName Name of the Central Clearing Account TEXT30
CompanyCodeName Name of Company Code or Company TEXT25
SecurityAccountName Name of the Security Account XLDEPO
SecurityAccountGroupName Name of Securities Account Group FTR_GEN_DESCRIPTION
ActivityFinancialTransaction Activity-Triggering Financial Transaction T_RFHA
FinancialInstrTransactionType Financial Instrument Transaction Type T_SFHAART
TreasuryFacilityCompanyCode Company Code of Facility BUKRS
TreasuryFacility Transaction Number of Facility T_RFHA
TreasuryMasterAgreement null
TreasuryFinanceProject Finance Project T_TFPROJ
Counterparty Counterparty number BU_PARTNER
LetterOfCredit Letter of Credit Number FTR_LC_NUMBER
Portfolio Portfolio RPORTB
PortfolioName Name of the Portfolio TEXT30
Issuer Issuer Identity Key BU_PARTNER
TrsyPosQtyChangeCategoryName Position Change Category: Quantity (Text) TPM_DESCRIPTION
TreasuryPosChangeCategoryName Name of the Position Change Category FTR_GEN_DESCRIPTION
DifferentiationPortfolioName Name of the Portfolio as Differentiation Characteristic TEXT30
FinancialInstrActivityCategory Transaction Activity Category T_SFGZUTY
FinancialInstrCharacteristic Financial Instrument Free Characteristic CHAR25
FinancialInstrumentReference Financial Instrument Free Internal Reference CHAR16
FinancialInstrumentAssignment Free Assignment of Financial Transaction TEXT18
DebitGLAccount G/L Account Number (Debit) SAKNR
CreditGLAccount G/L Account Number (Credit) SAKNR
DebitCustomer Customer (Debit) KUNNR
CreditCustomer Customer (Credit) KUNNR
FiscalYear Fiscal Year GJAHR
FiscalPeriod Fiscal period MONAT
TreasuryGLAccountAssignmentRef Account Assignment Reference of Position Management TPM_AA_REF
ReferenceDocument Reference document number AWREF
ReferenceDocumentContext Reference Organizational Units AWORG
ReverseDocumentFiscalYear Reverse Document Fiscal Year GJAHR
ReverseDocumentFiscalPeriod Reverse Document Fiscal Period MONAT
ReversalReferenceDocument Reversal: Reference Document No. of Document to Be Reversed AWREF
ReversalReferenceDocumentCntxt Reversal: Reference Organizations of Document to Be Reversed AWORG
AccountingDocument Document Number of an Accounting Document BELNR
ReverseDocument Reverse Document Number BELNR
FinancialExposureItem Exposure Item ID TOE_EXPOSURE_ITEM_ID
FinancialExposureSubItem Exposure Subitem ID TOE_EXPOSURE_SUBITEM_ID
Master Data Relations | to Other Relations ↓ Join Conditions
Company Code
  • Client
  • Company Code
  • A_TRSYPOSFLOW.MANDT == T001.MANDT
  • A_TRSYPOSFLOW.COMPANYCODE == T001.BUKRS
Portfolio as Differentiation Characteristic
  • Client
  • Portfolio as Differentiation Characteristic
  • Company Code
  • A_TRSYPOSFLOW.MANDT == TWPOB.MANDT
  • A_TRSYPOSFLOW.DIFFERENTIATIONPORTFOLIO == TWPOB.RPORTB
  • A_TRSYPOSFLOW.COMPANYCODE == TWPOB.BUKRS
Product Type
  • Client
  • Product Type
  • A_TRSYPOSFLOW.MANDT == TZPA.MANDT
  • A_TRSYPOSFLOW.FINANCIALINSTRUMENTPRODUCTTYPE == TZPA.GSART
Transaction Number
  • Financial Transaction
  • Client
  • Company Code
  • A_TRSYPOSFLOW.FINANCIALTRANSACTION == VTBFHA.RFHA
  • A_TRSYPOSFLOW.MANDT == VTBFHA.MANDT
  • A_TRSYPOSFLOW.COMPANYCODE == VTBFHA.BUKRS
Loan Contract Number
  • ?
  • Client
  • Company Code
  • Loan Contract Number
  • A_TRSYPOSFLOW.[column in domain "SARCHIV"] == VDARL.SARCHIV
  • A_TRSYPOSFLOW.MANDT == VDARL.MANDT
  • A_TRSYPOSFLOW.COMPANYCODE == VDARL.BUKRS
  • A_TRSYPOSFLOW.LOANCONTRACT == VDARL.RANL
Security Account
  • Client
  • Security Account
  • Company Code
  • A_TRSYPOSFLOW.MANDT == TWD01.MANDT
  • A_TRSYPOSFLOW.SECURITYACCOUNT == TWD01.RLDEPO
  • A_TRSYPOSFLOW.COMPANYCODE == TWD01.BUKRS
Security Class
  • Client
  • Security Class
  • A_TRSYPOSFLOW.MANDT == VWPANLA.MANDT
  • A_TRSYPOSFLOW.SECURITYCLASS == VWPANLA.RANL
Business Transaction Category A_TRSYPOSFLOW.TREASURYBUSINESSTRANSCATEGORY == TRDTS_BT_CAT.BUSTRANSCAT
Foreign Key Futures Account
  • Client
  • Futures Account for Listed Options and Futures
  • Company Code
Valuation Class
  • Treasury Valuation Area
  • Client
  • Valuation Class
Other Relations | to Master Data Relations ↑ Join Conditions
Securities Account Group
  • Securities Account Group
  • Client
  • Company Code
Accounting Code
  • Client
  • Accounting Code
Treasury Valuation Area
  • Treasury Valuation Area
  • Client