C_FR_StRpFECFinanceUnionCACube

France Audit File FICA union FI - Cube | view: CFRAUDITFIANDCAC | TRAN | 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
StatryRptCategory FK Report Category ID
StatryRptgEntity FK Reporting Entity
StatryRptRunID Report Run ID
Column Name Description
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code 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
ClearingDate Clearing Date
AccountingDocumentCreationDate Accounting Document Entry 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
FiscalPeriod Fiscal Period POPER
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
FR_FECPieceReference Reference Document XBLNR
DocumentItemText Journal Entry Item Text TEXT50
CAClearingDocumentNumber Clearing Document or Printed Document AUGBL_KK
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • C_FR_STRPFECFINANCEUNIONCACUBE.MANDT == T003.MANDT
  • C_FR_STRPFECFINANCEUNIONCACUBE.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Chart of Accounts
  • Client
  • Chart of Accounts
  • C_FR_STRPFECFINANCEUNIONCACUBE.MANDT == T004.MANDT
  • C_FR_STRPFECFINANCEUNIONCACUBE.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Client
  • Company Code
  • C_FR_STRPFECFINANCEUNIONCACUBE.MANDT == T001.MANDT
  • C_FR_STRPFECFINANCEUNIONCACUBE.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Client
  • Company Code Currency
  • C_FR_STRPFECFINANCEUNIONCACUBE.MANDT == TCURC.MANDT
  • C_FR_STRPFECFINANCEUNIONCACUBE.COMPANYCODECURRENCY == TCURC.WAERS
G/L Account
  • Client
  • G/L Account
  • Company Code
  • C_FR_STRPFECFINANCEUNIONCACUBE.MANDT == SKB1.MANDT
  • C_FR_STRPFECFINANCEUNIONCACUBE.GLACCOUNT == SKB1.SAKNR
  • C_FR_STRPFECFINANCEUNIONCACUBE.COMPANYCODE == SKB1.BUKRS
Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
  • Client
Reporting Entity
  • Reporting Entity
  • Client
  • C_FR_STRPFECFINANCEUNIONCACUBE.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY
  • C_FR_STRPFECFINANCEUNIONCACUBE.MANDT == SRF_RPG_ENT.MANDT
Transaction Currency
  • Client
  • Transaction Currency
  • C_FR_STRPFECFINANCEUNIONCACUBE.MANDT == TCURC.MANDT
  • C_FR_STRPFECFINANCEUNIONCACUBE.TRANSACTIONCURRENCY == TCURC.WAERS