P_Trltranspos

P_View for table FLOW,TRANSACTION,POSOITION | view: PTRLTTRANSPOS | Extraction: Not supported | Component: Treasury and Risk Management
Tables used: DIFT_POS_IDENT, TRLT_FLOW, TRLT_POSITION, TRLT_TRANSACTION, TREAT_EXT_ACC, T001, TKA02, TWPOB_T, TRGC_COM_VALCL_T, VDARL, TWD01, VWPANLA, TRFT_POS_ACCOUNT, TRDC_DFLOWTYPE_T, TRGC_VAL_CLASS_T, 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
CalculationDate Key Date of Last Interest Calculation
DueDate Due Date
CalculationPeriodStartDate Start of Calculation Period
CalculationPeriodEndDate End of Calculation Period
TreasuryPositionLedgerDate Treasury Ledger Date
CreationDate Creation Date of the Operative Business Transaction
CreationTime Creation Time of the Operative Business Transaction
FirstResponseByDate First Entered On
CorrespondenceCreationTime Time of Creation
LastEditedOn Last Edited On
LastEditedAt Last Edited At
DateOfZeroPosition Date of Zero Position
Column Name Description
TrsyPosTransfSourceTargetCode Position Transfer Show values
TrsyPosQuantityChangeCategory Position Change Category (Quantity) Show values
CalcDateIsAsEndDateInclusive Incl./Excl. Indicator for Beginning and End of a Period Show values
TreasuryParameterUsage Parameter Usage Show values
SubpositionSourceTargetIndctr Source or Target of Subposition Transfer Show values
FinInstrProductGroup Product Group Show values
TrsyDerivedBusTransacIsUpdated Status of Treasury Ledger Business Transaction Show values
TreasuryBusinessTransStatus Status of a Business Transaction Show values
BusinessTransactionFromMigratn Bus. Transaction Originated from Migration/Initialization Show values
TrsyIntragroupTransacStatus Intragroup Transaction Status Show values
IsFlowBackpackRequired Flow Backpack Required? Show values
IsFlowAddOnAvailable Flow Add-On Is Available (Hedge Accounting) Show values
EffectivenessTestBusTrans effectiveness test existent for business transaction Show values
TreasuryPosAssetLiabilityCode Assets/Liabilities Position Show values
PositionGrouping Position Grouping Acc. Article 14 GBA (Sec. and Loans) Show values
PositionHasSubpositions Indicator: Position has Subpositions Show values
TreasuryPositionLongShortCode Code: Long or Short Position Show values
Column Name Description Domain name
TreasurySubpositionUUID Globally Unique Identifier SYSUUID
TreasuryDocumentId Distributor Document ID SYSUUID
TreasuryUpdateTypeName Name of the Update Type FTR_GEN_DESCRIPTION
TreasuryUpdateType Update Type TPM_DIS_FLOWTYPE
TreasuryPosChangeCategoryName Name of the Position Change Category FTR_GEN_DESCRIPTION
TreasuryPositionTransferGroup Position Transfer Group TPM_SYSTEM_KEY
TreasuryPositionTransferFactor Position Transfer Coefficient TPM_AMOUNT_FACTOR
TrsyPosQtyChangeCategoryName Position Change Category: Quantity (Text) TPM_DESCRIPTION
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
SubpositionGroupOfFlows Group of Flows in Subposition Transfer TPM_SYSTEM_KEY
TreasuryBusinessTransaction Identifier of the Distributor Business Transaction SYSUUID
OriglTrsyBusinessTransaction Original Business Transaction SYSUUID
OSGUID Object Identity in Database Format TPM_DB_OS_GUID
BalanceSheetIndicator Balance Sheet Indicator SBILK
CreatedByUser Entered By SYCHAR12
SourceInitEnty Source of Initial Entry CHAR10
EmployeeID Employee ID SYCHAR12
EditingSource Editing Source CHAR10
ObjIdentityInDatabaseFormatCLS Object Identity in Database Format TPM_DB_OS_GUID
ObjNr Object number J_OBJNR
Fund Fund BP_GEBER
GrantID Grant GM_GRANT_NBR
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
DifferentiationPortfolioName Name of the Portfolio as Differentiation Characteristic TEXT30
TreasuryPositionLot Identifier of the Lot SYSUUID
LoanContractName Name of the Loan Contract XTEXT50
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
TreasuryPositionAccountName Name of the Futures Account for Listed Options and Futures TEXT30
Issuer Issuer Identity Key BU_PARTNER
FinancialInstrValClassName Name of the Financial Instrument Valuation Class FTR_GEN_DESCRIPTION
FinancialExposureItem Exposure Item ID TOE_EXPOSURE_ITEM_ID
FinancialExposureSubItem Exposure Subitem ID TOE_EXPOSURE_SUBITEM_ID
Master Data Relations | to Other Relations ↓ Join Conditions
Central Clearing Account Currency
  • Client
  • Central Clearing Account Currency
  • P_TRLTRANSPOS.MANDT == TCURC.MANDT
  • P_TRLTRANSPOS.CENTRALCLEARINGACCOUNTCURRENCY == TCURC.WAERS
Company Code
  • Client
  • Company Code
  • P_TRLTRANSPOS.MANDT == T001.MANDT
  • P_TRLTRANSPOS.COMPANYCODE == T001.BUKRS
Portfolio as Differentiation Characteristic
  • Client
  • Portfolio as Differentiation Characteristic
  • Company Code
  • P_TRLTRANSPOS.MANDT == TWPOB.MANDT
  • P_TRLTRANSPOS.DIFFERENTIATIONPORTFOLIO == TWPOB.RPORTB
  • P_TRLTRANSPOS.COMPANYCODE == TWPOB.BUKRS
Product Type
  • Client
  • Product Type
  • P_TRLTRANSPOS.MANDT == TZPA.MANDT
  • P_TRLTRANSPOS.FINANCIALINSTRUMENTPRODUCTTYPE == TZPA.GSART
Financial Instrument Valuation Class
  • Client
  • Financial Instrument Valuation Class
Transaction Number
  • Client
  • Financial Transaction
  • Company Code
  • P_TRLTRANSPOS.MANDT == VTBFHA.MANDT
  • P_TRLTRANSPOS.FINANCIALTRANSACTION == VTBFHA.RFHA
  • P_TRLTRANSPOS.COMPANYCODE == VTBFHA.BUKRS
Loan Contract Number
  • Client
  • Loan Contract Number
  • ?
  • Company Code
  • P_TRLTRANSPOS.MANDT == VDARL.MANDT
  • P_TRLTRANSPOS.LOANCONTRACT == VDARL.RANL
  • P_TRLTRANSPOS.[column in domain "SARCHIV"] == VDARL.SARCHIV
  • P_TRLTRANSPOS.COMPANYCODE == VDARL.BUKRS
Position Management Procedure
  • Client
  • Position Management Procedure
Security Account
  • Client
  • Security Account
  • Company Code
  • P_TRLTRANSPOS.MANDT == TWD01.MANDT
  • P_TRLTRANSPOS.SECURITYACCOUNT == TWD01.RLDEPO
  • P_TRLTRANSPOS.COMPANYCODE == TWD01.BUKRS
Security Class
  • Client
  • Security Class
  • P_TRLTRANSPOS.MANDT == VWPANLA.MANDT
  • P_TRLTRANSPOS.SECURITYCLASS == VWPANLA.RANL
Business Transaction Category P_TRLTRANSPOS.TREASURYBUSINESSTRANSCATEGORY == TRDTS_BT_CAT.BUSTRANSCAT
Foreign Key Futures Account
  • Client
  • Futures Account for Listed Options and Futures
  • Company Code
Valuation Class
  • Client
  • Treasury Valuation Area
  • Valuation Class
Other Relations | to Master Data Relations ↑ Join Conditions
Securities Account Group
  • Client
  • Securities Account Group
  • Company Code
Trader
  • Client
  • Company Code
  • Trader
  • P_TRLTRANSPOS.MANDT == TZDEA.MANDT
  • P_TRLTRANSPOS.COMPANYCODE == TZDEA.BUKRS
  • P_TRLTRANSPOS.TRADER == TZDEA.RDEALER
Accounting Code
  • Accounting Code
  • Client
Treasury Valuation Area
  • Client
  • Treasury Valuation Area