C_FR_StRpFECContrAcctItemQuery

France Audit File FEC FICA - Query | view: CFRSTRBAUDITCAQ | 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 Ledger in General Ledger Accounting
StatryRptgEntity FK Reporting Entity
StatryRptCategory FK Report Category ID
StatryRptRunID Report Run ID
Column Name Description
💲 Currency Key (CompanyCodeCurrency):
AmountInCompanyCodeCurrency null
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency with +/- Sign
💲 Foreign Currency (ForeignCurrency):
FR_FECAmountInForeignCurrency Foreign Currency Amount for FEC-reporting
Column Name Description
Column Name Description
PostingDate Posting Date in the Document
DocumentDate Journal Entry Date
AccountingDocumentCreationDate Accounting Document Entry Date
ClearingDate null
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 Number of a FI-CA Document OPBEL_KK
CAClearingDocumentNumber Clearing Document or Printed Document AUGBL_KK
GLAccount G/L Account SAKNR
AlternativeGLAccount Alternative 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_STRPFECCONTRACCTITEMQUERY.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • C_FR_STRPFECCONTRACCTITEMQUERY.MANDT == T003.MANDT
Company Code
  • Company Code
  • Client
  • C_FR_STRPFECCONTRACCTITEMQUERY.COMPANYCODE == T001.BUKRS
  • C_FR_STRPFECCONTRACCTITEMQUERY.MANDT == T001.MANDT
Currency Key
  • Client
  • Transaction Currency
  • Currency Key
  • C_FR_STRPFECCONTRACCTITEMQUERY.MANDT == TCURC.MANDT
  • C_FR_STRPFECCONTRACCTITEMQUERY.TRANSACTIONCURRENCY == TCURC.WAERS
  • C_FR_STRPFECCONTRACCTITEMQUERY.COMPANYCODECURRENCY == TCURC.WAERS
Reporting Entity
  • Reporting Entity
  • Client
  • C_FR_STRPFECCONTRACCTITEMQUERY.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY
  • C_FR_STRPFECCONTRACCTITEMQUERY.MANDT == SRF_RPG_ENT.MANDT