A_TrsyPostgJrnlEntrItm

Treasury Posting Journal Entry | view: APSTGJRNLENTRITM | Extraction: Not supported | Component: Treasury and Risk Management
Tables used: TLCT_ACTIVITY, DIFT_POS_IDENT, TRGT_USER_DATA, TOET_EXP_ITEM, THXT_HITEM, TRACT_DOCUMENT, TRACT_POSCONTEXT, T003T, ADCP, ADRC, TGSBT, BUT000, TREAT_EXT_ACC, T001, TKA02, CSKS, CSKT, T005T, TWPOB_T, TZPAT, AT10, AT10T, TRGC_COM_VALCL_T, VTBFHA, T856T, TZAF, TZPA, T880, VDARL, T008T, T042H, TBSL, TBSLT, TWD01, VWPANLA, T074T, TRDTS_BT_CAT_T, TRACC_AA_REF_T, TRAC_ACCSYMB_T, TOEC_CLASS, TRFT_POS_ACCOUNT, TRDC_DFLOWTYPE_T, TRGC_VAL_CLASS_T, TRLT_SUBPOSITION, TOEC_CLASS_T, BUT020, SKAT, T004, T042ZT, TRACT_ACCITEM, TRGT_SECACCGRP, TRGC_VAL_AREA
Column Name Description
TrsyAccountingDocumentUUID FK Object Identity in Database Format
AccountingDocumentItemRef Accounting Document Line Item Number
TrsyPositionContextUUID FK Object Identity in Database Format
Column Name Description
💲 Position Currency (PositionCurrency):
AmountInPositionCurrency Amount in Position Currency
💲 Local Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount (Local Currency)
Column Name Description
Column Name Description
PaymentDate Payment Date
PostingDate Posting Date in the Document
ReverseDocumentPostingDate Reverse Document Posting Date
DocumentDate Document Date in Document
CreationDate First Entered On
LastChangeDate Last Edited On
Column Name Description
TreasuryBusinessTransStatus Posting Status Show values
IsUsedInPaymentTransaction Payment Transaction Show values
TreasuryPostingCategory Posting Category Show values
TreasuryAcctgPostingCategory Update to Financial Accounting Category Show values
TreasuryPositionLongShortCode Code: Long or Short Position Show values
Column Name Description Domain name
TreasuryBusTransStatusName Name of the Posting Status TEXT15
TreasuryUpdateTypeName Name of the Update Type FTR_GEN_DESCRIPTION
TreasuryGLAccountAssignmentRef Account Assignment Reference of Position Management TPM_AA_REF
TreasuryGLAccountAssignRefName Name of the Account Assignment Reference FTR_GEN_DESCRIPTION
TreasuryPostingCategoryName Name of the Posting Category DDTEXT
TreasuryGLAccountSymbolName Name of the Account Symbol FTR_GEN_DESCRIPTION
PostingKey Posting Key BSCHL
PostingKeyName Posting Key Name TEXT20
GLAccount G/L Account Number SAKNR
TreasuryTransactionFlow Number of a Distributor Flow TPM_TRDFLOWNR
AccountingDocument Document Number of an Accounting Document BELNR
ReverseDocument Reverse Document BELNR
JournalEntryType Document Type BLART
AccountingDocumentTypeName Document Type Name TEXT20
Customer Customer Number KUNNR
PaymentTerms Terms of payment key ZTERM
PaymentMethod Payment Method ZLSCH
PaymentMethodName Payment Method Name TEXT30
PaymentMethodSupplement Payment method supplement UZAWE
PaymentMethodSupplementName Name of the Payment Method Supplement TEXT30
PaymentBlockingReason Payment Block Key ZAHLS
PaymentBlockingReasonName Name of a Payment Block Reason TEXT20
PayerPayeeFullName Full Name of the Payer / Payee TEXT80
HouseBank Short Key for Own House Bank HBKID
StateCentralBankPaymentReason State Central Bank Indicator LZBKZ
SupplyingCountry Supplying Country/Region LAND1
CountryName Country/Region Name TEXT50
AssignmentReference Assignment number ZUONR
JournalEntryItemText Journal Entry Item Text TEXT50
BusinessArea Business Area GSBER
BusinessAreaName Business Area Description TEXT30
CostCenter Cost Center KOSTL
FinancialTransactionType Transaction Type (FI) RMVCT
FinancialTransactionTypeName Name of a Transaction Type (FI) TEXT20
PartnerCompany Company ID RCOMP
CompanyName Company name TEXT30
Counterparty Counterparty number BU_PARTNER
CounterpartyFullName Full Name of the Counterparty TEXT80
Issuer Issuer Identity Key BU_PARTNER
IssuerFullName Full Name of the Issuer TEXT80
SpecialGLCode Special G/L Indicator UMSKZ
SpecialGLCodeName Name of a Special GL Code TEXT30
TreasuryBusinessTransaction Identifier of the Distributor Business Transaction SYSUUID
TreasuryValuationArea Treasury Valuation Area TPM_VAL_AREA
TreasuryValuationAreaName Name of the Valuation Area FTR_GEN_DESCRIPTION
ReferenceDocument Reference document number AWREF
ReferenceDocumentContext Reference Organizational Units AWORG
FiscalPeriod Fiscal period MONAT
FiscalYear Fiscal Year GJAHR
ReversalReferenceDocument Reversal: Reference Document No. of Document to Be Reversed AWREF
ReversalReferenceDocumentCntxt Reversal: Reference Organizations of Document to Be Reversed AWORG
ReverseDocumentFiscalPeriod Reverse Document Fiscal Period MONAT
ReverseDocumentFiscalYear Reverse Document Fiscal Year GJAHR
Ledger Ledger RLDNR
AccountingPrinciple Accounting Principle ACCOUNTING_PRINCIPLE
TreasuryBusTransCategoryName Name of Business Transaction Category TPM_DESCRIPTION
DocumentHeaderText Document Header Text TEXT25
DocumentReferenceID Reference Document Number XBLNR1
FinancialInstrValClassName Name of the Financial Instrument Valuation Class FTR_GEN_DESCRIPTION
TreasuryValuationClassName Name of the Valuation Class FTR_GEN_DESCRIPTION
FinancialInstrProdTypeName Name of the Product Type TEXT30
SecurityAccountName Name of the Security Account XLDEPO
SecurityClassName Name of the Security Class XKBEZ
SecurityClassDescription Description of the Security Class XLBEZ
DifferentiationPortfolioName Name of the Portfolio as Differentiation Characteristic TEXT30
SecurityAccountGroupName Name of Securities Account Group FTR_GEN_DESCRIPTION
LoanContractName Name of the Loan Contract XTEXT50
TreasuryPositionAccountName Name of the Futures Account for Listed Options and Futures TEXT30
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
ActivityFinancialTransaction Activity-Triggering Financial Transaction T_RFHA
CreatedByUser Entered By SYCHAR12
LastChangedByUser Employee ID SYCHAR12
GLAccountLongName Description of a GL Account TEXT50
CostCenterName Name of a Cost Center TEXT20
FinancialInstrTransTypeName Name of Financial Instrument Transaction Type T_XTEXT30
FinancialInstrCharacteristic Financial Instrument Free Characteristic CHAR25
FinancialInstrumentReference Financial Instrument Free Internal Reference CHAR16
FinancialInstrumentAssignment Free Assignment of Financial Transaction TEXT18
LetterOfCredit Letter of Credit Number FTR_LC_NUMBER
HedgingClassificationName Name of the Hedging Classification FTR_GEN_DESCRIPTION
FinancialExposureItem Exposure Item ID TOE_EXPOSURE_ITEM_ID
FinancialExposureItemName Exposure Item Description TOE_DESCRIPTION
FinancialExposureSubItem Exposure Subitem ID TOE_EXPOSURE_SUBITEM_ID
FinancialExposureSubItemName Exposure Subitem Name TOE_EXPOSURE_SUBITEM_DESCR
Master Data Relations | to Other Relations ↓ Join Conditions
Company Code
  • Company Code
  • Client
  • A_TRSYPOSTGJRNLENTRITM.COMPANYCODE == T001.BUKRS
  • A_TRSYPOSTGJRNLENTRITM.MANDT == T001.MANDT
Portfolio as Differentiation Characteristic
  • Company Code
  • Portfolio as Differentiation Characteristic
  • Client
  • A_TRSYPOSTGJRNLENTRITM.COMPANYCODE == TWPOB.BUKRS
  • A_TRSYPOSTGJRNLENTRITM.DIFFERENTIATIONPORTFOLIO == TWPOB.RPORTB
  • A_TRSYPOSTGJRNLENTRITM.MANDT == TWPOB.MANDT
Financial Instrument Transaction Type
  • Client
  • ?
  • Financial Instrument Transaction Type
  • A_TRSYPOSTGJRNLENTRITM.MANDT == AT10.MANDT
  • A_TRSYPOSTGJRNLENTRITM.[column in domain "VVSART"] == AT10.SGSART
  • A_TRSYPOSTGJRNLENTRITM.FINANCIALINSTRTRANSACTIONTYPE == AT10.SFHAART
Product Type
  • Client
  • Product Type
  • A_TRSYPOSTGJRNLENTRITM.MANDT == TZPA.MANDT
  • A_TRSYPOSTGJRNLENTRITM.FINANCIALINSTRUMENTPRODUCTTYPE == TZPA.GSART
Financial Instrument Valuation Class
  • Financial Instrument Valuation Class
  • Client
Transaction Number
  • Company Code
  • Client
  • Activity-Triggering Financial Transaction
  • Financial Transaction
  • A_TRSYPOSTGJRNLENTRITM.COMPANYCODE == VTBFHA.BUKRS
  • A_TRSYPOSTGJRNLENTRITM.MANDT == VTBFHA.MANDT
  • A_TRSYPOSTGJRNLENTRITM.ACTIVITYFINANCIALTRANSACTION == VTBFHA.RFHA
  • A_TRSYPOSTGJRNLENTRITM.FINANCIALTRANSACTION == VTBFHA.RFHA
Hedging Classification
  • Hedging Classification
  • Client
  • A_TRSYPOSTGJRNLENTRITM.HEDGINGCLASSIFICATION == TOEC_CLASS.HEDGING_CLASSIFICATION
  • A_TRSYPOSTGJRNLENTRITM.MANDT == TOEC_CLASS.CLIENT
Loan Contract Number
  • ?
  • Company Code
  • Loan Contract Number
  • Client
  • A_TRSYPOSTGJRNLENTRITM.[column in domain "SARCHIV"] == VDARL.SARCHIV
  • A_TRSYPOSTGJRNLENTRITM.COMPANYCODE == VDARL.BUKRS
  • A_TRSYPOSTGJRNLENTRITM.LOANCONTRACT == VDARL.RANL
  • A_TRSYPOSTGJRNLENTRITM.MANDT == VDARL.MANDT
Portfolio
  • Client
  • ?
  • Portfolio
  • A_TRSYPOSTGJRNLENTRITM.MANDT == TWPOB.MANDT
  • A_TRSYPOSTGJRNLENTRITM.[column in domain "BUKRS"] == TWPOB.BUKRS
  • A_TRSYPOSTGJRNLENTRITM.PORTFOLIO == TWPOB.RPORTB
Security Account
  • Company Code
  • Client
  • Security Account
  • A_TRSYPOSTGJRNLENTRITM.COMPANYCODE == TWD01.BUKRS
  • A_TRSYPOSTGJRNLENTRITM.MANDT == TWD01.MANDT
  • A_TRSYPOSTGJRNLENTRITM.SECURITYACCOUNT == TWD01.RLDEPO
Security Class
  • Client
  • Security Class
  • A_TRSYPOSTGJRNLENTRITM.MANDT == VWPANLA.MANDT
  • A_TRSYPOSTGJRNLENTRITM.SECURITYCLASS == VWPANLA.RANL
Business Transaction Category A_TRSYPOSTGJRNLENTRITM.TREASURYBUSINESSTRANSCATEGORY == TRDTS_BT_CAT.BUSTRANSCAT
Account Symbol for Account Assignment Reference
  • Account Symbol for Account Assignment Reference
  • Client
  • A_TRSYPOSTGJRNLENTRITM.TREASURYGLACCOUNTSYMBOL == TRAC_ACCSYMB.ACC_SYMBOL
  • A_TRSYPOSTGJRNLENTRITM.MANDT == TRAC_ACCSYMB.MANDT
Foreign Key Futures Account
  • Company Code
  • Client
  • Futures Account for Listed Options and Futures
Foreign Key for Update Type
  • Update Type
  • Client
Valuation Class
  • Valuation Class
  • Treasury Valuation Area
  • Client
  • A_TRSYPOSTGJRNLENTRITM.TREASURYVALUATIONCLASS == TRGC_VAL_CLASS.VALUATION_CLASS
  • A_TRSYPOSTGJRNLENTRITM.TREASURYVALUATIONAREA == TRGC_VAL_CLASS.VALUATION_AREA
  • A_TRSYPOSTGJRNLENTRITM.MANDT == TRGC_VAL_CLASS.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Securities Account Group
  • Company Code
  • Client
  • Securities Account Group
Accounting Code
  • Accounting Code
  • Client