C_FR_StRpAuditFECItemCube

France Audit File (FEC) – Cube | view: CFRSTRBAUDITFECC | 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
💲 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
AccountingDocumentCategory Journal Entry Category Show values
Column Name Description Domain name
LedgerFiscalYear Ledger Fiscal Year GJAHR
AccountingDocumentItem Journal Entry Posting View Item BUZEI
AccountingDocumentTypeName Document Type Name TEXT20
DocumentReferenceID Document Reference ID XBLNR1
FR_FECPieceReference Reference Document XBLNR
FiscalPeriod Fiscal Period POPER
DocumentItemText Journal Entry Item Text TEXT50
AssignmentReference Assignment Reference ZUONR
ClearingAccountingDocument Clearing Journal Entry BELNR
GLAccountName G/L Account Short Text TEXT20
GLAccountLongName G/L Account Long Text TEXT50
AlternativeGLAccount Alternative G/L Account Number In Company Code SAKNR
AlternativeGLAccountName G/L Account Short Text TEXT20
AlternativeGLAccountLongName G/L Account Long Text TEXT50
OperationalChartOfAccounts Chart of Accounts used in French audit file FEC KTOPL
OperationalGLAccount General Ledger Account used in FEC-Fille SAKNR
OperationalGLAccountName General Ledger Account Name used in FEC-Fille TEXT20
OperationalGLAccountLongName General Ledger Account Long Name used in FEC-Fille TEXT50
BusinessPartner Business Partner Number BU_PARTNER
BusinessPartnerName Business Partner Name TEXT80
FR_FECSubledgerAccount FEC File: Subledger Account (CompAuxNum Field) KUNNR
FR_FECSubledgerAccountName FEC File: Subledger Account Description (CompAuxLib Field) TEXT35
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • C_FR_STRPAUDITFECITEMCUBE.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • C_FR_STRPAUDITFECITEMCUBE.MANDT == T003.MANDT
Chart of Accounts
  • Chart of Accounts
  • Client
  • C_FR_STRPAUDITFECITEMCUBE.CHARTOFACCOUNTS == T004.KTOPL
  • C_FR_STRPAUDITFECITEMCUBE.MANDT == T004.MANDT
Company Code
  • Company Code
  • Client
  • C_FR_STRPAUDITFECITEMCUBE.COMPANYCODE == T001.BUKRS
  • C_FR_STRPAUDITFECITEMCUBE.MANDT == T001.MANDT
Company Code Currency
  • Company Code Currency
  • Client
  • C_FR_STRPAUDITFECITEMCUBE.COMPANYCODECURRENCY == TCURC.WAERS
  • C_FR_STRPAUDITFECITEMCUBE.MANDT == TCURC.MANDT
Alternative Chart of Accounts for Country/Region
  • Alternative Chart of Accounts for Country/Region
  • Client
  • C_FR_STRPAUDITFECITEMCUBE.COUNTRYCHARTOFACCOUNTS == T004.KTOPL
  • C_FR_STRPAUDITFECITEMCUBE.MANDT == T004.MANDT
G/L Account
  • G/L Account
  • Company Code
  • Client
  • C_FR_STRPAUDITFECITEMCUBE.GLACCOUNT == SKB1.SAKNR
  • C_FR_STRPAUDITFECITEMCUBE.COMPANYCODE == SKB1.BUKRS
  • C_FR_STRPAUDITFECITEMCUBE.MANDT == SKB1.MANDT
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger
Source Ledger
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger
Reporting Entity
  • Client
  • Reporting Entity
  • C_FR_STRPAUDITFECITEMCUBE.MANDT == SRF_RPG_ENT.MANDT
  • C_FR_STRPAUDITFECITEMCUBE.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY
Transaction Currency
  • Transaction Currency
  • Client
  • C_FR_STRPAUDITFECITEMCUBE.TRANSACTIONCURRENCY == TCURC.WAERS
  • C_FR_STRPAUDITFECITEMCUBE.MANDT == TCURC.MANDT