P_JrnlEntrItmToBOPFormItmUnion

Union of FICA and FI Item to BOP Form Item | view: PJEBOPFIUNION | Extraction: Not supported | Component: Statutory Reporting
Column Name Description
Ledger FK Ledger in General Ledger Accounting
SourceLedger FK Source Ledger
CompanyCode FK Company Code
AccountingDocument Journal Entry
CADocumentNumber Number of a FI-CA Document
CASubItemNumber Subitem for a Partial Clearing in Document
CABPItemNumber Item Number in FI-CA Document
CAGLItemNumber Item Number in FI-CA Document
FiscalYear Fiscal Year
LedgerGLLineItem Ledger Journal Entry Item
BOPRptgCntry Reporting Country/Region
BOPForm Form
BOPFormItem FK Form Item
StatryRptCategory FK Report Category ID
StatryRptgEntity FK Reporting Entity
StatryRptRunID Report Run ID
Column Name Description
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
DebitAmountInTransCrcy Debit Amount in Transaction Currency
CreditAmountInTransCrcy Credit Amount in Transaction Currency
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
DebitAmountInCoCodeCrcy Debit Amount in Company Code Currency
CreditAmountInCoCodeCrcy Credit Amount in Company Code Currency
Column Name Description
Column Name Description
UniqueAcctgDocClrgDate Clearing Date
PostingDate Posting Date
ClearingDate Clearing Date
Column Name Description
IsEUTriangularDeal Indicator: Triangular Deal Within the EU Show values
DebitCreditCode Debit/Credit Code 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
CAReconciliationKey Reconciliation Key for General Ledger FIKEY_KK
BusinessPartner Business Partner Number BU_PARTNER
CADocumentType Document Type BLART_KK
CompanyCodeCountry null
BOPPartnerCntry null
HasUniqueClrgDate null
ClearingAccountingDocument Clearing Journal Entry BELNR
CAClearingAccountingDocument Clearing Document or Printed Document AUGBL_KK
ClearingDocFiscalYear Fiscal Year of Clearing Journal Entry GJAHR
OffsettingAccount Offsetting Account GKONT
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • P_JRNLENTRITMTOBOPFORMITMUNION.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • P_JRNLENTRITMTOBOPFORMITMUNION.MANDT == T003.MANDT
Form Item
  • Reporting Country/Region
  • Form Item
  • Form
  • Client
Chart of Accounts
  • Chart of Accounts
  • Client
  • P_JRNLENTRITMTOBOPFORMITMUNION.CHARTOFACCOUNTS == T004.KTOPL
  • P_JRNLENTRITMTOBOPFORMITMUNION.MANDT == T004.MANDT
Company Code
  • Company Code
  • Client
  • P_JRNLENTRITMTOBOPFORMITMUNION.COMPANYCODE == T001.BUKRS
  • P_JRNLENTRITMTOBOPFORMITMUNION.MANDT == T001.MANDT
Company Code Currency
  • Company Code Currency
  • Client
  • P_JRNLENTRITMTOBOPFORMITMUNION.COMPANYCODECURRENCY == TCURC.WAERS
  • P_JRNLENTRITMTOBOPFORMITMUNION.MANDT == TCURC.MANDT
Customer Number
  • Customer Number
  • Client
  • P_JRNLENTRITMTOBOPFORMITMUNION.CUSTOMER == KNA1.KUNNR
  • P_JRNLENTRITMTOBOPFORMITMUNION.MANDT == KNA1.MANDT
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • P_JRNLENTRITMTOBOPFORMITMUNION.FISCALYEARVARIANT == T009.PERIV
  • P_JRNLENTRITMTOBOPFORMITMUNION.MANDT == T009.MANDT
G/L Account
  • G/L Account
  • Company Code
  • Client
  • P_JRNLENTRITMTOBOPFORMITMUNION.GLACCOUNT == SKB1.SAKNR
  • P_JRNLENTRITMTOBOPFORMITMUNION.COMPANYCODE == SKB1.BUKRS
  • P_JRNLENTRITMTOBOPFORMITMUNION.MANDT == SKB1.MANDT
Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
  • Source Ledger
  • Client
  • P_JRNLENTRITMTOBOPFORMITMUNION.LEDGER == FINSC_LEDGER.RLDNR
  • P_JRNLENTRITMTOBOPFORMITMUNION.SOURCELEDGER == FINSC_LEDGER.RLDNR
  • P_JRNLENTRITMTOBOPFORMITMUNION.MANDT == FINSC_LEDGER.MANDT
Company ID of Trading Partner
  • Company ID of Trading Partner
  • Client
  • P_JRNLENTRITMTOBOPFORMITMUNION.PARTNERCOMPANY == T880.RCOMP
  • P_JRNLENTRITMTOBOPFORMITMUNION.MANDT == T880.MANDT
Source Ledger
  • Ledger in General Ledger Accounting
  • Source Ledger
  • Client
  • P_JRNLENTRITMTOBOPFORMITMUNION.LEDGER == FINSC_LEDGER.RLDNR
  • P_JRNLENTRITMTOBOPFORMITMUNION.SOURCELEDGER == FINSC_LEDGER.RLDNR
  • P_JRNLENTRITMTOBOPFORMITMUNION.MANDT == FINSC_LEDGER.MANDT
Special G/L Indicator
  • Account Type
  • Client
  • Special G/L Indicator
  • P_JRNLENTRITMTOBOPFORMITMUNION.FINANCIALACCOUNTTYPE == T074U.KOART
  • P_JRNLENTRITMTOBOPFORMITMUNION.MANDT == T074U.MANDT
  • P_JRNLENTRITMTOBOPFORMITMUNION.SPECIALGLCODE == T074U.UMSKZ
Reporting Entity
  • Client
  • Reporting Entity
  • P_JRNLENTRITMTOBOPFORMITMUNION.MANDT == SRF_RPG_ENT.MANDT
  • P_JRNLENTRITMTOBOPFORMITMUNION.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY
Supplier
  • Supplier
  • Client
  • P_JRNLENTRITMTOBOPFORMITMUNION.SUPPLIER == LFA1.LIFNR
  • P_JRNLENTRITMTOBOPFORMITMUNION.MANDT == LFA1.MANDT
Tax on Sales/Purchases Code
  • Client
  • ?
  • Tax on Sales/Purchases Code
  • P_JRNLENTRITMTOBOPFORMITMUNION.MANDT == T007A.MANDT
  • P_JRNLENTRITMTOBOPFORMITMUNION.[column in domain "KALSM_D"] == T007A.KALSM
  • P_JRNLENTRITMTOBOPFORMITMUNION.TAXCODE == T007A.MWSKZ
Transaction Currency
  • Client
  • Transaction Currency
  • P_JRNLENTRITMTOBOPFORMITMUNION.MANDT == TCURC.MANDT
  • P_JRNLENTRITMTOBOPFORMITMUNION.TRANSACTIONCURRENCY == TCURC.WAERS