C_BE_BoPF01MERQry

BOP Reporting Belgium - F01MER Format | view: CBEBOPF01MERQ | Extraction: Not supported | Component: Financials Belgium
Column Name Description
Ledger Ledger in General Ledger Accounting
SourceLedger Source Ledger
CompanyCode Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
LedgerGLLineItem Ledger Journal Entry Item
BOPRptgCntry Reporting Country/Region
BOPForm Form
BOPFormItem FK Form Item
BOPPartnerCntry Country/Region Key
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
Column Name Description
Column Name Description
PostingDate Posting Date
Column Name Description
IsEUTriangularDeal Indicator: Triangular Deal Within the EU Show values
IsReversal Indicator: Item is Reversing Another Item Show values
IsReversed Indicator: Item is Reversed Show values
FinancialAccountType Account Type Show values
OffsettingAccountType Offsetting Account Type Show values
Column Name Description Domain name
CompanyCodeCountry Company Code Country/Region LAND1
ClearingAccountingDocument Clearing Journal Entry BELNR
ClearingDocFiscalYear Fiscal Year of Clearing Journal Entry GJAHR
OffsettingAccount Offsetting Account GKONT
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • C_BE_BOPF01MERQRY.MANDT == T003.MANDT
  • C_BE_BOPF01MERQRY.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Form Item
  • ?
  • Form Item
  • Client
  • ?
Chart of Accounts
  • Client
  • Chart of Accounts
  • C_BE_BOPF01MERQRY.MANDT == T004.MANDT
  • C_BE_BOPF01MERQRY.CHARTOFACCOUNTS == T004.KTOPL
Company Code Currency
  • Company Code Currency
  • Client
  • C_BE_BOPF01MERQRY.COMPANYCODECURRENCY == TCURC.WAERS
  • C_BE_BOPF01MERQRY.MANDT == TCURC.MANDT
Customer Number
  • Customer Number
  • Client
  • C_BE_BOPF01MERQRY.CUSTOMER == KNA1.KUNNR
  • C_BE_BOPF01MERQRY.MANDT == KNA1.MANDT
Fiscal Year Variant
  • Client
  • Fiscal Year Variant
  • C_BE_BOPF01MERQRY.MANDT == T009.MANDT
  • C_BE_BOPF01MERQRY.FISCALYEARVARIANT == T009.PERIV
G/L Account
  • G/L Account
  • ?
  • Client
  • C_BE_BOPF01MERQRY.GLACCOUNT == SKB1.SAKNR
  • C_BE_BOPF01MERQRY.[column in domain "BUKRS"] == SKB1.BUKRS
  • C_BE_BOPF01MERQRY.MANDT == SKB1.MANDT
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • C_BE_BOPF01MERQRY.MANDT == T880.MANDT
  • C_BE_BOPF01MERQRY.PARTNERCOMPANY == T880.RCOMP
Special G/L Indicator
  • Account Type
  • Client
  • Special G/L Indicator
  • C_BE_BOPF01MERQRY.FINANCIALACCOUNTTYPE == T074U.KOART
  • C_BE_BOPF01MERQRY.MANDT == T074U.MANDT
  • C_BE_BOPF01MERQRY.SPECIALGLCODE == T074U.UMSKZ
Reporting Entity
  • Client
  • Reporting Entity
  • C_BE_BOPF01MERQRY.MANDT == SRF_RPG_ENT.MANDT
  • C_BE_BOPF01MERQRY.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY
Supplier
  • Supplier
  • Client
  • C_BE_BOPF01MERQRY.SUPPLIER == LFA1.LIFNR
  • C_BE_BOPF01MERQRY.MANDT == LFA1.MANDT
Tax on Sales/Purchases Code
  • ?
  • Tax on Sales/Purchases Code
  • Client
  • C_BE_BOPF01MERQRY.[column in domain "KALSM_D"] == T007A.KALSM
  • C_BE_BOPF01MERQRY.TAXCODE == T007A.MWSKZ
  • C_BE_BOPF01MERQRY.MANDT == T007A.MANDT
Transaction Currency
  • Client
  • Transaction Currency
  • C_BE_BOPF01MERQRY.MANDT == TCURC.MANDT
  • C_BE_BOPF01MERQRY.TRANSACTIONCURRENCY == TCURC.WAERS