P_AnalyzeAccrualPosting

Analyze Accrual Postings | view: PANALACCRPOSTG | Extraction: Not supported | Component: Fiori FXU General Ledger Accounting FI-FIO-GL
Tables used: ACDOCA, TACE_TTYPET, TACE_SLALITTYPE, FINSC_LEDGER_REP
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
💲 Global Currency (GlobalCurrency):
AmountInGlobalCurrency Amount in Global Currency
💲 Freely Defined Currency 1 (FreeDefinedCurrency1):
AmountInFreeDefinedCurrency1 Amount in Freely Defined Currency 1
Column Name Description
Column Name Description
PostingDate Posting Date
DocumentDate Journal Entry Date
CreationDate Creation Date
ClearingDate Clearing Date
AccrualValueDate Accrual Value 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
IsOpenItemManaged Indicator: Open Item Management? Show values
OrderCategory Order category Show values
FinancialAccountType Account Type Show values
GLAccountType Type of a General Ledger Account Show values
GLAccountLineItemIsAccrual ACE Line Item Indicator 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
AccrualObjectLogicalSystem Logical System of the Accrual Object LOGSYS
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
ReferenceDocumentItemGroup Group of Reference Document Line Items NUMC6
FiscalYearPeriod Fiscal Year Period FIS_JAHRPER_CONV
LastChangeDateTime Time Stamp of Last Change TZNTSTMPS
CreationDateTime Time Stamp of Creation TZNTSTMPS
ClearingAccountingDocument Document Number of the Clearing Document BELNR
ClearingDocFiscalYear Fiscal Year of Clearing Document GJAHR
AccountAssignmentNumber Sequential Number of Account Assignment NUM02
DocumentItemText Item Text TEXT50
AccountAssignment Account Assignment ACCAS
SalesOrderItem Item number in Sales Order NUM06
SalesDocumentItem Sales Document Item POSNR
WBSElementInternalID WBS Element Internal ID FIS_WBSINT_NO_CONV
Project Project FIS_PROJECT
WorkPackage Plan Item /CPD/PLAN_ITEM_ID
RelatedNetworkActivity Network activity VORNR
OffsettingAccount Offsetting Account GKONT
JrnlEntrShiftedFYConsecutiveID Ledger specific Accounting Document Number BELNR
FinancialAccrTransacTypeName Text TEXT50
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • P_ANALYZEACCRUALPOSTING.MANDT == T003.MANDT
  • P_ANALYZEACCRUALPOSTING.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Type of the Accrual Object
  • Type of the Accrual Object
  • Client
Alternative Account Number in Company Code
  • Alternative Chart of Accounts
  • Alternative Account Number in Company Code
  • Client
  • P_ANALYZEACCRUALPOSTING.COUNTRYCHARTOFACCOUNTS == SKA1.KTOPL
  • P_ANALYZEACCRUALPOSTING.ALTERNATIVEGLACCOUNT == SKA1.SAKNR
  • P_ANALYZEACCRUALPOSTING.MANDT == SKA1.MANDT
Business Area
  • Business Area
  • Client
  • P_ANALYZEACCRUALPOSTING.BUSINESSAREA == TGSB.GSBER
  • P_ANALYZEACCRUALPOSTING.MANDT == TGSB.MANDT
Business Process
  • ?
  • Controlling Area
  • Client
  • Business Process
  • P_ANALYZEACCRUALPOSTING.[column in domain "DATBI"] == CBPR.DATBI
  • P_ANALYZEACCRUALPOSTING.CONTROLLINGAREA == CBPR.KOKRS
  • P_ANALYZEACCRUALPOSTING.MANDT == CBPR.MANDT
  • P_ANALYZEACCRUALPOSTING.BUSINESSPROCESS == CBPR.PRZNR
Business Transaction Category
  • Business Transaction Category
  • Client
  • P_ANALYZEACCRUALPOSTING.BUSINESSTRANSACTIONTYPE == FINSC_BTTYPE.BTTYPE
  • P_ANALYZEACCRUALPOSTING.MANDT == FINSC_BTTYPE.MANDT
Chart of Accounts
  • Client
  • Chart of Accounts
  • P_ANALYZEACCRUALPOSTING.MANDT == T004.MANDT
  • P_ANALYZEACCRUALPOSTING.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Company Code
  • Client
  • P_ANALYZEACCRUALPOSTING.COMPANYCODE == T001.BUKRS
  • P_ANALYZEACCRUALPOSTING.MANDT == T001.MANDT
Company Code Currency
  • Client
  • Company Code Currency
  • P_ANALYZEACCRUALPOSTING.MANDT == TCURC.MANDT
  • P_ANALYZEACCRUALPOSTING.COMPANYCODECURRENCY == TCURC.WAERS
Controlling Area
  • Controlling Area
  • Client
  • P_ANALYZEACCRUALPOSTING.CONTROLLINGAREA == TKA01.KOKRS
  • P_ANALYZEACCRUALPOSTING.MANDT == TKA01.MANDT
Cost Center
  • ?
  • Controlling Area
  • Client
  • Cost Center
  • P_ANALYZEACCRUALPOSTING.[column in domain "DATBI"] == CSKS.DATBI
  • P_ANALYZEACCRUALPOSTING.CONTROLLINGAREA == CSKS.KOKRS
  • P_ANALYZEACCRUALPOSTING.MANDT == CSKS.MANDT
  • P_ANALYZEACCRUALPOSTING.COSTCENTER == CSKS.KOSTL
Cost Object
  • ?
  • Client
  • Cost Object
  • P_ANALYZEACCRUALPOSTING.[column in domain "DATBI"] == CKPH.DATBI
  • P_ANALYZEACCRUALPOSTING.MANDT == CKPH.MANDT
  • P_ANALYZEACCRUALPOSTING.COSTOBJECT == CKPH.KSTRG
Origin Group as Subdivision of Cost Element
  • ?
  • Controlling Area
  • Client
  • Origin Group as Subdivision of Cost Element
  • P_ANALYZEACCRUALPOSTING.[column in domain "HRKTYP"] == TKKH1.KOATY
  • P_ANALYZEACCRUALPOSTING.CONTROLLINGAREA == TKKH1.KOKRS
  • P_ANALYZEACCRUALPOSTING.MANDT == TKKH1.MANDT
  • P_ANALYZEACCRUALPOSTING.COSTORIGINGROUP == TKKH1.HRKFT
Alternative Chart of Accounts
  • Alternative Chart of Accounts
  • Client
  • P_ANALYZEACCRUALPOSTING.COUNTRYCHARTOFACCOUNTS == T004.KTOPL
  • P_ANALYZEACCRUALPOSTING.MANDT == T004.MANDT
Customer Number
  • Customer Number
  • Client
  • P_ANALYZEACCRUALPOSTING.CUSTOMER == KNA1.KUNNR
  • P_ANALYZEACCRUALPOSTING.MANDT == KNA1.MANDT
ACE Posting Type P_ANALYZEACCRUALPOSTING.FINANCIALACCRUALTRANSACTYPE == TACE_TTYPE.TTYPE
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • P_ANALYZEACCRUALPOSTING.FISCALYEARVARIANT == T009.PERIV
  • P_ANALYZEACCRUALPOSTING.MANDT == T009.MANDT
Freely Defined Currency 1
  • Client
  • Freely Defined Currency 1
  • P_ANALYZEACCRUALPOSTING.MANDT == TCURC.MANDT
  • P_ANALYZEACCRUALPOSTING.FREEDEFINEDCURRENCY1 == TCURC.WAERS
Functional Area
  • Functional Area
  • Client
  • P_ANALYZEACCRUALPOSTING.FUNCTIONALAREA == TFKB.FKBER
  • P_ANALYZEACCRUALPOSTING.MANDT == TFKB.MANDT
G/L Account
  • Company Code
  • Client
  • G/L Account
  • P_ANALYZEACCRUALPOSTING.COMPANYCODE == SKB1.BUKRS
  • P_ANALYZEACCRUALPOSTING.MANDT == SKB1.MANDT
  • P_ANALYZEACCRUALPOSTING.GLACCOUNT == SKB1.SAKNR
Global Currency
  • Global Currency
  • Client
  • P_ANALYZEACCRUALPOSTING.GLOBALCURRENCY == TCURC.WAERS
  • P_ANALYZEACCRUALPOSTING.MANDT == TCURC.MANDT
Ledger
  • Ledger
  • Source Ledger
  • Client
Order Number
  • Order Number
  • Client
  • P_ANALYZEACCRUALPOSTING.ORDERID == AUFK.AUFNR
  • P_ANALYZEACCRUALPOSTING.MANDT == AUFK.MANDT
Plant
  • Client
  • Plant
  • P_ANALYZEACCRUALPOSTING.MANDT == T001W.MANDT
  • P_ANALYZEACCRUALPOSTING.PLANT == T001W.WERKS
Posting Key
  • Posting Key
  • Client
  • P_ANALYZEACCRUALPOSTING.POSTINGKEY == TBSL.BSCHL
  • P_ANALYZEACCRUALPOSTING.MANDT == TBSL.MANDT
Product Number
  • Product Number
  • Client
  • P_ANALYZEACCRUALPOSTING.PRODUCT == MARA.MATNR
  • P_ANALYZEACCRUALPOSTING.MANDT == MARA.MANDT
Profit Center
  • ?
  • Controlling Area
  • Profit Center
  • Client
  • P_ANALYZEACCRUALPOSTING.[column in domain "DATBI"] == CEPC.DATBI
  • P_ANALYZEACCRUALPOSTING.CONTROLLINGAREA == CEPC.KOKRS
  • P_ANALYZEACCRUALPOSTING.PROFITCENTER == CEPC.PRCTR
  • P_ANALYZEACCRUALPOSTING.MANDT == CEPC.MANDT
Project Internal ID
  • Client
  • Project Internal ID
  • P_ANALYZEACCRUALPOSTING.MANDT == PROJ.MANDT
  • P_ANALYZEACCRUALPOSTING.PROJECTINTERNALID == PROJ.PSPNR
Network Number for Account Assignment
  • Network Number for Account Assignment
  • Client
  • P_ANALYZEACCRUALPOSTING.PROJECTNETWORK == AUFK.AUFNR
  • P_ANALYZEACCRUALPOSTING.MANDT == AUFK.MANDT
Reference Document Type P_ANALYZEACCRUALPOSTING.REFERENCEDOCUMENTTYPE == TTYP.AWTYP
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • P_ANALYZEACCRUALPOSTING.MANDT == FAGL_SEGM.MANDT
  • P_ANALYZEACCRUALPOSTING.SEGMENT == FAGL_SEGM.SEGMENT
Service Document ID
  • ?
  • Client
  • Service Document Type
  • Service Document ID
  • P_ANALYZEACCRUALPOSTING.[column in domain "FCO_SRVDOC_ITEM_ID"] == FCO_SRVDOC.SERVICE_DOC_ITEM_ID
  • P_ANALYZEACCRUALPOSTING.MANDT == FCO_SRVDOC.MANDT
  • P_ANALYZEACCRUALPOSTING.SERVICEDOCUMENTTYPE == FCO_SRVDOC.SERVICE_DOC_TYPE
  • P_ANALYZEACCRUALPOSTING.SERVICEDOCUMENT == FCO_SRVDOC.SERVICE_DOC_ID
Service Document Type
  • Client
  • Service Document Type
Source Ledger
  • Ledger
  • Source Ledger
  • Client
Subledger-Specific Line Item Type P_ANALYZEACCRUALPOSTING.SUBLEDGERACCTLINEITEMTYPE == FINSTS_SLALITTY.SLALITTYPE
Supplier
  • Client
  • Supplier
  • P_ANALYZEACCRUALPOSTING.MANDT == LFA1.MANDT
  • P_ANALYZEACCRUALPOSTING.SUPPLIER == LFA1.LIFNR
Tax on sales/purchases code
  • ?
  • Tax on sales/purchases code
  • Client
  • P_ANALYZEACCRUALPOSTING.[column in domain "KALSM_D"] == T007A.KALSM
  • P_ANALYZEACCRUALPOSTING.TAXCODE == T007A.MWSKZ
  • P_ANALYZEACCRUALPOSTING.MANDT == T007A.MANDT
Transaction Currency
  • Client
  • Transaction Currency
  • P_ANALYZEACCRUALPOSTING.MANDT == TCURC.MANDT
  • P_ANALYZEACCRUALPOSTING.TRANSACTIONCURRENCY == TCURC.WAERS