C_FinancialPositionQuery

Financial Status Query | view: CFINPOSQ | Extraction: Not supported | Component: Treasury and Risk Management
Tables used: T001TKA02TZBZ
Column Name Description
Column Name Description
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Financial Position Amount In Transaction Currency
💲 Display Currency (DisplayCurrency):
BookValueAmountInDC Book Value in Display Currency
NominalAmountInDisplayCurrency Nominal Amount in Display Currency
AmountInDisplayCurrency Financial Position Amount in Display Currency
Column Name Description
Column Name Description
Column Name Description
CompanyCodeIsTreasuryCenter Treasury Center Indicator Show values
FinPositionAssetLiabilityCode Assets or Liabilities Show values
FinancialPositionDataSource Data Source Show values
Column Name Description Domain name
CompanyCode Company Code BUKRS
TreasuryCenterSortSequenceVal Treasury Center Ranking
FinancialPositionGroup Financial Position Group FTR_GEN_FIN_POS_GRP
FinancialPosition Financial Position FTR_GEN_FIN_POS
GLAccount G/L Account SAKNR
HouseBank House Bank Key HBKID
HouseBankAccount House Bank Account HKTID
BusinessArea Business Area GSBER
Issuer Issuer Identity Key BU_PARTNER
Counterparty Counterparty number BU_PARTNER
FinancialInstrumentProductType Product Type VVSART
FinancialInstrTransactionType Financial Transaction Type T_SFHAART
FinancialTransaction Financial Transaction T_RFHA
TreasuryValuationClass Valuation Class TPM_VAL_CLASS
Portfolio Portfolio RPORTB
SecurityAccount Security Account RLDEPO
SecurityClass Security Class WP_RANL
TreasuryPositionAccount Futures Account for Listed Options and Futures TPM_POS_ACCOUNT_FUT
TreasuryValuationArea Treasury Valuation Area TPM_VAL_AREA
Ledger Ledger in General Ledger Accounting FINS_LEDGER
FiscalYear Fiscal Year GJAHR
AccountingDocumentType Journal Entry Type BLART
AccountingDocument Document Number of an Accounting Document BELNR
Master Data Relations Join Conditions
Country/Region Key
  • Country/Region Key
  • Client
  • C_FINANCIALPOSITIONQUERY.COUNTRY == T005.LAND1
  • C_FINANCIALPOSITIONQUERY.MANDT == T005.MANDT