C_FR_StRpFECFinanceUnionCAQry

France Audit File FICA union FI - Query | view: CFRAUDITFIANDCAQ | Extraction: Not supported | Component: Financials France
Column Name Description
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
LedgerGLLineItem Ledger Journal Entry Item
Ledger FK Ledger in General Ledger Accounting
StatryRptgEntity FK Reporting Entity
StatryRptCategory FK Report Category ID
StatryRptRunID Report Run ID
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
💲 Foreign Currency (ForeignCurrency):
FR_FECAmountInForeignCurrency Foreign Currency Amount for FEC-reporting
Column Name Description
Column Name Description
PostingDate Posting Date
DocumentDate Journal Entry Date
AccountingDocumentCreationDate Accounting Document Entry Date
ClearingDate Clearing Date
Column Name Description
FinancialAccountType Account Type Show values
DebitCreditCode Debit/Credit Code Show values
Column Name Description Domain name
AccountingDocumentTypeName Document Type Name TEXT20
FR_FECPieceReference Reference Document XBLNR
FiscalPeriod Fiscal Period POPER
DocumentItemText Journal Entry Item Text TEXT50
CAClearingDocumentNumber Clearing Document or Printed Document AUGBL_KK
AlternativeGLAccount Alternative G/L Account Number In Company Code SAKNR
OperationalGLAccount General Ledger Account used in FEC-Fille SAKNR
OperationalGLAccountName General Ledger Account Name used in FEC-Fille TEXT20
BusinessPartner Business Partner Number BU_PARTNER
BusinessPartnerName Business Partner Name TEXT80
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • C_FR_STRPFECFINANCEUNIONCAQRY.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • C_FR_STRPFECFINANCEUNIONCAQRY.MANDT == T003.MANDT
Company Code
  • Client
  • Company Code
  • C_FR_STRPFECFINANCEUNIONCAQRY.MANDT == T001.MANDT
  • C_FR_STRPFECFINANCEUNIONCAQRY.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Client
  • Company Code Currency
  • C_FR_STRPFECFINANCEUNIONCAQRY.MANDT == TCURC.MANDT
  • C_FR_STRPFECFINANCEUNIONCAQRY.COMPANYCODECURRENCY == TCURC.WAERS
G/L Account
  • Client
  • G/L Account
  • Company Code
  • C_FR_STRPFECFINANCEUNIONCAQRY.MANDT == SKB1.MANDT
  • C_FR_STRPFECFINANCEUNIONCAQRY.GLACCOUNT == SKB1.SAKNR
  • C_FR_STRPFECFINANCEUNIONCAQRY.COMPANYCODE == SKB1.BUKRS
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
Reporting Entity
  • Client
  • Reporting Entity
  • C_FR_STRPFECFINANCEUNIONCAQRY.MANDT == SRF_RPG_ENT.MANDT
  • C_FR_STRPFECFINANCEUNIONCAQRY.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY
Transaction Currency
  • Client
  • Transaction Currency
  • C_FR_STRPFECFINANCEUNIONCAQRY.MANDT == TCURC.MANDT
  • C_FR_STRPFECFINANCEUNIONCAQRY.TRANSACTIONCURRENCY == TCURC.WAERS