I_AnalyzeAccrPostgVislFltr

Analyze Accrual Posting Visual Filter | view: IANALACEVISFLT | Extraction: Not supported | Component: Fiori FXU General Ledger Accounting FI-FIO-GL
Tables used: ACDOCA, T003, T001, TKA02, FINSC_CURTYPE, FINSC_CURTYPET, KNA1, SKB1, FINSC_LEDGER_T, CEPC, LFA1, T077K, TACE_TTYPET, FINSC_LD_CMP, TACE_SLALITTYPE, FINSC_LEDGER_REP, FINSC_FISC_DATE
Column Name Description
SourceLedger FK Source Ledger
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
LedgerGLLineItem Ledger Journal Entry Item
Ledger FK Ledger
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
💲 null (DisplayCurrency):
AmountInDisplayCurrency Amount in Display Currency
Column Name Description
Column Name Description
PostingDate Posting Date
CreationDate Creation Date
DocumentDate Journal Entry Date
Column Name Description
AccountingDocumentCategory Journal Entry Category Show values
IsReversal Indicator: Item is Reversing Another Item Show values
IsReversed Indicator: Item is Reversed Show values
GLAccountType Type of a General Ledger Account Show values
GLAccountLineItemIsAccrual ACE Line Item Indicator Show values
FinancialAccountType Account Type Show values
Column Name Description Domain name
SenderCompanyCode Company Code in Sender System CHAR4
FiscalPeriod Fiscal Period POPER
ReferenceDocument Reference document number AWREF
ReversalReferenceDocument Reversal: Reference Document No. of Document to Be Reversed AWREF
AccrualObject Identifier of the Accrual Object ACE_OBJ_ID
AccrualSubobject Unique Reference for an Accrual Subobject ACE_REF_SUBKEY
AccrualItemType Type of the Item of the Accrual Subobject ACR_ITEM_TYPE
OffsettingAccount Offsetting Account GKONT
CompanyCodeName null
FiscalYearPeriod Fiscal Year Period FIS_JAHRPER_CONV
FinancialAccrTransacTypeName Text TEXT50
ReferenceDocumentItemGroup Group of Reference Document Line Items NUMC6
GLAccountAuthorizationGroup Authorization Group BRGRU
SupplierFinsAuthorizationGrp Authorization Group BRGRU
CustomerFinsAuthorizationGrp Authorization Group BRGRU
SupplierAccountGroup Vendor account group KTOKK
AcctgDocTypeAuthorizationGroup Authorization Group BRGRU
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • I_ANALYZEACCRPOSTGVISLFLTR.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • I_ANALYZEACCRPOSTGVISLFLTR.MANDT == T003.MANDT
Type of the Accrual Object
  • Type of the Accrual Object
  • Client
  • I_ANALYZEACCRPOSTGVISLFLTR.ACCRUALOBJECTTYPE == TACR_OBJ_TYPE.ACROBJ_TYPE
  • I_ANALYZEACCRPOSTGVISLFLTR.MANDT == TACR_OBJ_TYPE.MANDT
Business Area
  • Business Area
  • Client
  • I_ANALYZEACCRPOSTGVISLFLTR.BUSINESSAREA == TGSB.GSBER
  • I_ANALYZEACCRPOSTGVISLFLTR.MANDT == TGSB.MANDT
Business Transaction Category
  • Business Transaction Category
  • Client
  • I_ANALYZEACCRPOSTGVISLFLTR.BUSINESSTRANSACTIONTYPE == FINSC_BTTYPE.BTTYPE
  • I_ANALYZEACCRPOSTGVISLFLTR.MANDT == FINSC_BTTYPE.MANDT
Company Code
  • Company Code
  • Client
  • I_ANALYZEACCRPOSTGVISLFLTR.COMPANYCODE == T001.BUKRS
  • I_ANALYZEACCRPOSTGVISLFLTR.MANDT == T001.MANDT
Company Code Currency
  • Company Code Currency
  • Client
  • I_ANALYZEACCRPOSTGVISLFLTR.COMPANYCODECURRENCY == TCURC.WAERS
  • I_ANALYZEACCRPOSTGVISLFLTR.MANDT == TCURC.MANDT
Controlling Area
  • Controlling Area
  • Client
  • I_ANALYZEACCRPOSTGVISLFLTR.CONTROLLINGAREA == TKA01.KOKRS
  • I_ANALYZEACCRPOSTGVISLFLTR.MANDT == TKA01.MANDT
Cost Center
  • Controlling Area
  • ?
  • Cost Center
  • Client
  • I_ANALYZEACCRPOSTGVISLFLTR.CONTROLLINGAREA == CSKS.KOKRS
  • I_ANALYZEACCRPOSTGVISLFLTR.[column in domain "DATBI"] == CSKS.DATBI
  • I_ANALYZEACCRPOSTGVISLFLTR.COSTCENTER == CSKS.KOSTL
  • I_ANALYZEACCRPOSTGVISLFLTR.MANDT == CSKS.MANDT
Customer Account Group
  • Client
  • Customer Account Group
  • I_ANALYZEACCRPOSTGVISLFLTR.MANDT == T077D.MANDT
  • I_ANALYZEACCRPOSTGVISLFLTR.CUSTOMERACCOUNTGROUP == T077D.KTOKD
ACE Posting Type I_ANALYZEACCRPOSTGVISLFLTR.FINANCIALACCRUALTRANSACTYPE == TACE_TTYPE.TTYPE
G/L Account
  • Company Code
  • G/L Account
  • Client
  • I_ANALYZEACCRPOSTGVISLFLTR.COMPANYCODE == SKB1.BUKRS
  • I_ANALYZEACCRPOSTGVISLFLTR.GLACCOUNT == SKB1.SAKNR
  • I_ANALYZEACCRPOSTGVISLFLTR.MANDT == SKB1.MANDT
Ledger
  • Client
  • Source Ledger
  • Ledger
Posting Key
  • Posting Key
  • Client
  • I_ANALYZEACCRPOSTGVISLFLTR.POSTINGKEY == TBSL.BSCHL
  • I_ANALYZEACCRPOSTGVISLFLTR.MANDT == TBSL.MANDT
Profit Center
  • Controlling Area
  • Profit Center
  • ?
  • Client
  • I_ANALYZEACCRPOSTGVISLFLTR.CONTROLLINGAREA == CEPC.KOKRS
  • I_ANALYZEACCRPOSTGVISLFLTR.PROFITCENTER == CEPC.PRCTR
  • I_ANALYZEACCRPOSTGVISLFLTR.[column in domain "DATBI"] == CEPC.DATBI
  • I_ANALYZEACCRPOSTGVISLFLTR.MANDT == CEPC.MANDT
Address key assignment to users
  • Client
  • User Responsible for the Profit Center
  • I_ANALYZEACCRPOSTGVISLFLTR.MANDT == USR02.MANDT
  • I_ANALYZEACCRPOSTGVISLFLTR.PROFITCTRRESPONSIBLEUSER == USR02.BNAME
Reference Document Type I_ANALYZEACCRPOSTGVISLFLTR.REFERENCEDOCUMENTTYPE == TTYP.AWTYP
Segment for Segmental Reporting
  • Segment for Segmental Reporting
  • Client
  • I_ANALYZEACCRPOSTGVISLFLTR.SEGMENT == FAGL_SEGM.SEGMENT
  • I_ANALYZEACCRPOSTGVISLFLTR.MANDT == FAGL_SEGM.MANDT
Source Ledger
  • Client
  • Source Ledger
  • Ledger
Subledger-Specific Line Item Type I_ANALYZEACCRPOSTGVISLFLTR.SUBLEDGERACCTLINEITEMTYPE == FINSTS_SLALITTY.SLALITTYPE
Transaction Currency
  • Transaction Currency
  • Client
  • I_ANALYZEACCRPOSTGVISLFLTR.TRANSACTIONCURRENCY == TCURC.WAERS
  • I_ANALYZEACCRPOSTGVISLFLTR.MANDT == TCURC.MANDT