P_FR_AuditFECContrAcctLineItem

France Audit File (FEC) – FICA data | view: PFRAUDITCALINITM | 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 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 with +/- Sign
💲 Currency Key (CompanyCodeCurrency):
AmountInCompanyCodeCurrency null
💲 Foreign Currency (ForeignCurrency):
FR_FECAmountInForeignCurrency Foreign Currency Amount for FEC-reporting
Column Name Description
Column Name Description
CAPostingDate Posting Date in the Document
DocumentDate Journal Entry Date
ClearingDate null
AccountingDocumentCreationDate Accounting Document Entry Date
Column Name Description
DebitCreditCode Debit/Credit Code Show values
FinancialAccountType Account Type Show values
Column Name Description Domain name
AccountingDocumentTypeName Document Type Name TEXT20
FiscalPeriod Fiscal Period POPER
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
FR_FECPieceReference Reference Document XBLNR
DocumentItemText Number of a FI-CA Document OPBEL_KK
CAClearingDocumentNumber null
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • P_FR_AUDITFECCONTRACCTLINEITEM.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • P_FR_AUDITFECCONTRACCTLINEITEM.MANDT == T003.MANDT
Chart of Accounts
  • Chart of Accounts
  • Client
  • P_FR_AUDITFECCONTRACCTLINEITEM.CHARTOFACCOUNTS == T004.KTOPL
  • P_FR_AUDITFECCONTRACCTLINEITEM.MANDT == T004.MANDT
Company Code
  • Company Code
  • Client
  • P_FR_AUDITFECCONTRACCTLINEITEM.COMPANYCODE == T001.BUKRS
  • P_FR_AUDITFECCONTRACCTLINEITEM.MANDT == T001.MANDT
Currency Key
  • Currency Key
  • Transaction Currency
  • Client
  • P_FR_AUDITFECCONTRACCTLINEITEM.COMPANYCODECURRENCY == TCURC.WAERS
  • P_FR_AUDITFECCONTRACCTLINEITEM.TRANSACTIONCURRENCY == TCURC.WAERS
  • P_FR_AUDITFECCONTRACCTLINEITEM.MANDT == TCURC.MANDT
Reporting Entity
  • Client
  • Reporting Entity
  • P_FR_AUDITFECCONTRACCTLINEITEM.MANDT == SRF_RPG_ENT.MANDT
  • P_FR_AUDITFECCONTRACCTLINEITEM.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY