P_ForeignCurrencyAggregate

Foreign Currency Suspicious Aggregate | view: PFCSAGGRG | Extraction: Not supported | Component: Fiori UI for Accounts Payable
Tables used: BKPFBSEGLFA1LFA1T005
Column Name Description
CompanyCode FK Company Code
AccountingDocument Document Number of an Accounting Document
Column Name Description
InvoiceDocumentAmount Amount in document currency
Column Name Description
Column Name Description
PostingDate Posting Date
InvoiceDate Journal Entry Date
CreateOn Accounting Document Entry Date
CreationTime Creation Time
Column Name Description
Column Name Description Domain name
AccountingDocumentItem Number of Line Item Within Accounting Document BUZEI
InvoiceNumber null
FiscalYear Fiscal Year GJAHR
InvoiceReference Reference Document Number XBLNR1
CreateBy User that created the journal entry
SupplierName Name 1 NAME
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • P_FOREIGNCURRENCYAGGREGATE.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • P_FOREIGNCURRENCYAGGREGATE.MANDT == T003.MANDT
Company Code
  • Company Code
  • Client
  • P_FOREIGNCURRENCYAGGREGATE.COMPANYCODE == T001.BUKRS
  • P_FOREIGNCURRENCYAGGREGATE.MANDT == T001.MANDT
Currency Key
  • Currency Key
  • Client
  • P_FOREIGNCURRENCYAGGREGATE.DOCUMENTCURRENCY == TCURC.WAERS
  • P_FOREIGNCURRENCYAGGREGATE.MANDT == TCURC.MANDT
Account Number of Supplier
  • Account Number of Supplier
  • Client
  • P_FOREIGNCURRENCYAGGREGATE.SUPPLIER == LFA1.LIFNR
  • P_FOREIGNCURRENCYAGGREGATE.MANDT == LFA1.MANDT
Vendor account group
  • Vendor account group
  • Client
  • P_FOREIGNCURRENCYAGGREGATE.SUPPLIERACCOUNTGROUP == T077K.KTOKK
  • P_FOREIGNCURRENCYAGGREGATE.MANDT == T077K.MANDT
Country/Region Key
  • Country/Region Key
  • Client
  • P_FOREIGNCURRENCYAGGREGATE.SUPPLIERCOUNTRY == T005.LAND1
  • P_FOREIGNCURRENCYAGGREGATE.MANDT == T005.MANDT
Reporting Currency
  • Reporting Currency
  • Client
  • P_FOREIGNCURRENCYAGGREGATE.SUPPLIERCURRENCY == TCURC.WAERS
  • P_FOREIGNCURRENCYAGGREGATE.MANDT == TCURC.MANDT