C_AnalyzeAccrualPosting

Analyze Accrual Postings | view: CANALACCRPOSTG | Extraction: Not supported | Component: Fiori FXU General Ledger Accounting FI-FIO-GL
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
TotalAccrAmtInCompanyCodeCrcy Total Accrual/Deferral Amount in Company Code Currency
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
TotalAccrAmountInTransCrcy Total Accrual/Deferral Amount in Transaction Currency
💲 Global Currency (GlobalCurrency):
AmountInGlobalCurrency Amount in Global Currency
TotalAccrAmountInGlobalCrcy Total Accrual/Deferral Amount in Global Currency
💲 Freely Defined Currency 1 (FreeDefinedCurrency1):
AmountInFreeDefinedCurrency1 Amount in Freely Defined Currency 1
TotalAccrAmountInFreeDfndCrcy1 Total Accrual/Deferral Amount in Freely Defined Currency 1
💲 Display Currency (DisplayCurrency):
AmountInDisplayCurrency Amount in Display Currency
💲 Freely Defined Currency 2 (FreeDefinedCurrency2):
TotalAccrAmountInFreeDfndCrcy2 Total Accrual/Deferral Amount in Freely Defined Currency 2
💲 Freely Defined Currency 3 (FreeDefinedCurrency3):
TotalAccrAmountInFreeDfndCrcy3 Total Accrual/Deferral Amount in Freely Defined Currency 3
💲 Freely Defined Currency 4 (FreeDefinedCurrency4):
TotalAccrAmountInFreeDfndCrcy4 Total Accrual/Deferral Amount in Freely Defined Currency 4
💲 Freely Defined Currency 5 (FreeDefinedCurrency5):
TotalAccrAmountInFreeDfndCrcy5 Total Accrual/Deferral Amount in Freely Defined Currency 5
💲 Freely Defined Currency 6 (FreeDefinedCurrency6):
TotalAccrAmountInFreeDfndCrcy6 Total Accrual/Deferral Amount in Freely Defined Currency 6
💲 Freely Defined Currency 7 (FreeDefinedCurrency7):
TotalAccrAmountInFreeDfndCrcy7 Total Accrual/Deferral Amount in Freely Defined Currency 7
💲 Freely Defined Currency 8 (FreeDefinedCurrency8):
TotalAccrAmountInFreeDfndCrcy8 Total Accrual/Deferral Amount in Freely Defined Currency 8
Column Name Description
📏 Unit of Measure for Accrual Items (TotalAccrualQuantityUnit):
TotalAccrualQuantity Total Quantity to Accrue
Column Name Description
PostingDate Posting Date
CreationDate Creation Date
DocumentDate Journal Entry Date
ClearingDate Clearing Date
AccrualValueDate Accrual Value Date
AccrSubobjPauseDate Pause Date
AccrSubobjSuspensionDate Suspension Date
AccrSubobjPrematureFinishDate Premature Finish Date
AccrSubobjHdrStartOfLifeDate Start of Life of an Accrual Subobject or Item
AccrSubobjHdrEndOfLifeDate End of Life of an Accrual Subobject or Item
AccrualSubobjectCreationDate Created On
AccrualSubobjectCreationTime Created At
AccrualSubobjectLastChangeDate Changed On
AccrualSubobjectLastChangeTime Changed At
AccrSubobjectItmValdtyEndDte To Date of Accrual Item
AccrSubobjectItmValdtyStrtDte From Date of an Entry
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
IsOpenItemManaged Indicator: Open Item Management? Show values
OrderCategory Order category Show values
AccrSubobjectLifeCycleStatus Lifecycle Status of an Accrual Subobject Show values
AccrualItemIsObsolete Accrual Item is Obsolete Show values
Column Name Description Domain name
LedgerName Ledger Name TEXT30
AccountingDocCreatedByUserName User Description SUIDTECHDESC
GlobalCurrencyRoleName Global Currency Role Name TEXT60
FreeDefinedCurrency1RoleName Freely Defined Currency 1 Role Name TEXT60
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
GLAccountName G/L Account Name TEXT20
OffsettingAccount Offsetting Account GKONT
CostCenterName Cost Center Name TEXT20
CompanyCodeName Name of Company Code or Company TEXT25
FullName Full Name of Person TEXT80
GLAccountLineItemTypeName Short Text for Fixed Values DDTEXT
FiscalYearPeriod Fiscal Year Period FIS_JAHRPER_CONV
JrnlEntrShiftedFYConsecutiveID Ledger specific Accounting Document Number BELNR
FinancialAccrTransacTypeName Text TEXT50
ReferenceDocumentItemGroup Group of Reference Document Line Items NUMC6
GLAccountAuthorizationGroup Authorization Group BRGRU
SupplierFinsAuthorizationGrp Authorization Group BRGRU
CustomerFinsAuthorizationGrp Authorization Group BRGRU
AcctgDocTypeAuthorizationGroup Authorization Group BRGRU
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
WBSDescription WBS Element Name TEXT40
WBSElementExternalID Work Breakdown Structure Element (WBS Element) Edited PS_POSID_EDIT
AccrualClosingFiscalYear Accrual Closing Fiscal Year GJAHR
AccrualClosingFiscalPeriod Accrual Closing Fiscal Period POPER
ControllingAreaName Controlling Area Name TEXT25
AttachmentDocumentUUID Hash Value SRT_WSP_HASH_VALUE
AccrualObjectLogicalSystem Logical System of the Accrual Object LOGSYS
AccrualObjectInternalID Accrual Object (Internal Display in Form of a GUID)
AccrualSubobjectInternalID Accrual Subobject (Internal Display, Sequence Number)
AccrualSubobjectCreatedByUser Created By UNAME
AccrSubobjectCreatedByUserName User Description SUIDTECHDESC
AccrSubobjLastChangedByUser Changed By UNAME
AccrSubobjLastChgdByUserName User Description SUIDTECHDESC
AccrSubobjLastChangeDateTime Accrual Subobject Last Change DateTime TZNTSTMPS
AccrualMethod Accrual/Deferral Method ACE_ACCMETHOD
PlanAccrualItemType Accrual Item Type for Planned Costs ACE_ITEMTYPE
PlanAccrualMethod Planned Accrual Method ACE_ACCMETHOD
ActualAccrualItemType Accrual Item Type for Costs Posted by Invoices or Goods Rcpt ACE_ITEMTYPE
ActualAccrualMethod Actual Accrual Method ACE_ACCMETHOD
AccrOpngPostgDocumentType Document Type for Opening Posting
AccrPerdcPostgDocumentType Document Type for Periodic Accrual Posting
AccrClsgPostgDocumentType Document Type for Closing Posting
AccrOpngPostgAccrAccount Accrual/Deferral Account for Opening Posting
AccrOpngPostgOffstgAccount Offsetting Account for Opening Posting
AccrPerdcPostgAccrAccount Accrual/Deferral Account for Periodic Posting
AccrPerdcPostgOffstgAcct Offsetting Account for Periodic Posting
AccrClsgPostgAccrAccount Accrual/Deferral Account for Closing Posting
AccrClsgPostgOffstgAccount Offsetting Account for Closing Posting
AccrualItemLastChangeDateTime Accrual Item Last Change DateTime TZNTSTMPS
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • C_ANALYZEACCRUALPOSTING.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • C_ANALYZEACCRUALPOSTING.MANDT == T003.MANDT
Accrual Engine Application Component
  • Accrual Engine Application Component
  • Client
  • C_ANALYZEACCRUALPOSTING.ACCRUALENGINEACCRUALOBJECTTYPE == TACECOMP.COMP
  • C_ANALYZEACCRUALPOSTING.MANDT == TACECOMP.MANDT
Type of the Accrual Object
  • Type of the Accrual Object
  • Client
Alternative Account Number in Company Code
  • Alternative Account Number in Company Code
  • Alternative Chart of Accounts
  • Client
  • C_ANALYZEACCRUALPOSTING.ALTERNATIVEGLACCOUNT == SKA1.SAKNR
  • C_ANALYZEACCRUALPOSTING.COUNTRYCHARTOFACCOUNTS == SKA1.KTOPL
  • C_ANALYZEACCRUALPOSTING.MANDT == SKA1.MANDT
Business Area
  • Business Area
  • Client
  • C_ANALYZEACCRUALPOSTING.BUSINESSAREA == TGSB.GSBER
  • C_ANALYZEACCRUALPOSTING.MANDT == TGSB.MANDT
Business Process
  • Business Process
  • ?
  • Controlling Area
  • Client
  • C_ANALYZEACCRUALPOSTING.BUSINESSPROCESS == CBPR.PRZNR
  • C_ANALYZEACCRUALPOSTING.[column in domain "DATBI"] == CBPR.DATBI
  • C_ANALYZEACCRUALPOSTING.CONTROLLINGAREA == CBPR.KOKRS
  • C_ANALYZEACCRUALPOSTING.MANDT == CBPR.MANDT
Business Transaction Category
  • Business Transaction Category
  • Client
  • C_ANALYZEACCRUALPOSTING.BUSINESSTRANSACTIONTYPE == FINSC_BTTYPE.BTTYPE
  • C_ANALYZEACCRUALPOSTING.MANDT == FINSC_BTTYPE.MANDT
Company Code
  • Company Code
  • Client
  • C_ANALYZEACCRUALPOSTING.COMPANYCODE == T001.BUKRS
  • C_ANALYZEACCRUALPOSTING.MANDT == T001.MANDT
Company Code Currency
  • Company Code Currency
  • Client
  • C_ANALYZEACCRUALPOSTING.COMPANYCODECURRENCY == TCURC.WAERS
  • C_ANALYZEACCRUALPOSTING.MANDT == TCURC.MANDT
Controlling Area
  • Controlling Area
  • Client
  • C_ANALYZEACCRUALPOSTING.CONTROLLINGAREA == TKA01.KOKRS
  • C_ANALYZEACCRUALPOSTING.MANDT == TKA01.MANDT
Cost Center
  • Cost Center
  • ?
  • Controlling Area
  • Client
  • C_ANALYZEACCRUALPOSTING.COSTCENTER == CSKS.KOSTL
  • C_ANALYZEACCRUALPOSTING.[column in domain "DATBI"] == CSKS.DATBI
  • C_ANALYZEACCRUALPOSTING.CONTROLLINGAREA == CSKS.KOKRS
  • C_ANALYZEACCRUALPOSTING.MANDT == CSKS.MANDT
Cost Object
  • ?
  • Cost Object
  • Client
  • C_ANALYZEACCRUALPOSTING.[column in domain "DATBI"] == CKPH.DATBI
  • C_ANALYZEACCRUALPOSTING.COSTOBJECT == CKPH.KSTRG
  • C_ANALYZEACCRUALPOSTING.MANDT == CKPH.MANDT
Origin Group as Subdivision of Cost Element
  • ?
  • Controlling Area
  • Origin Group as Subdivision of Cost Element
  • Client
  • C_ANALYZEACCRUALPOSTING.[column in domain "HRKTYP"] == TKKH1.KOATY
  • C_ANALYZEACCRUALPOSTING.CONTROLLINGAREA == TKKH1.KOKRS
  • C_ANALYZEACCRUALPOSTING.COSTORIGINGROUP == TKKH1.HRKFT
  • C_ANALYZEACCRUALPOSTING.MANDT == TKKH1.MANDT
Alternative Chart of Accounts
  • Alternative Chart of Accounts
  • Client
  • C_ANALYZEACCRUALPOSTING.COUNTRYCHARTOFACCOUNTS == T004.KTOPL
  • C_ANALYZEACCRUALPOSTING.MANDT == T004.MANDT
Customer Number
  • Customer Number
  • Client
  • C_ANALYZEACCRUALPOSTING.CUSTOMER == KNA1.KUNNR
  • C_ANALYZEACCRUALPOSTING.MANDT == KNA1.MANDT
Customer Account Group
  • Customer Account Group
  • Client
  • C_ANALYZEACCRUALPOSTING.CUSTOMERACCOUNTGROUP == T077D.KTOKD
  • C_ANALYZEACCRUALPOSTING.MANDT == T077D.MANDT
ACE Posting Type C_ANALYZEACCRUALPOSTING.FINANCIALACCRUALTRANSACTYPE == TACE_TTYPE.TTYPE
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • C_ANALYZEACCRUALPOSTING.FISCALYEARVARIANT == T009.PERIV
  • C_ANALYZEACCRUALPOSTING.MANDT == T009.MANDT
Freely Defined Currency 1
  • Client
  • Freely Defined Currency 1
  • C_ANALYZEACCRUALPOSTING.MANDT == TCURC.MANDT
  • C_ANALYZEACCRUALPOSTING.FREEDEFINEDCURRENCY1 == TCURC.WAERS
Freely Defined Currency 1 Role (Currency Type)
  • Freely Defined Currency 1 Role (Currency Type)
  • Client
Functional Area
  • Functional Area
  • Client
  • C_ANALYZEACCRUALPOSTING.FUNCTIONALAREA == TFKB.FKBER
  • C_ANALYZEACCRUALPOSTING.MANDT == TFKB.MANDT
G/L Account
  • G/L Account
  • Company Code
  • Client
  • C_ANALYZEACCRUALPOSTING.GLACCOUNT == SKB1.SAKNR
  • C_ANALYZEACCRUALPOSTING.COMPANYCODE == SKB1.BUKRS
  • C_ANALYZEACCRUALPOSTING.MANDT == SKB1.MANDT
Global Currency
  • Client
  • Global Currency
  • C_ANALYZEACCRUALPOSTING.MANDT == TCURC.MANDT
  • C_ANALYZEACCRUALPOSTING.GLOBALCURRENCY == TCURC.WAERS
Global Currency Role
  • Global Currency Role
  • Client
Ledger
  • Ledger
  • Source Ledger
  • Client
Order Number
  • Order Number
  • Client
  • C_ANALYZEACCRUALPOSTING.ORDERID == AUFK.AUFNR
  • C_ANALYZEACCRUALPOSTING.MANDT == AUFK.MANDT
Plant
  • Plant
  • Client
  • C_ANALYZEACCRUALPOSTING.PLANT == T001W.WERKS
  • C_ANALYZEACCRUALPOSTING.MANDT == T001W.MANDT
Posting Key
  • Posting Key
  • Client
  • C_ANALYZEACCRUALPOSTING.POSTINGKEY == TBSL.BSCHL
  • C_ANALYZEACCRUALPOSTING.MANDT == TBSL.MANDT
Product Number
  • Product Number
  • Client
  • C_ANALYZEACCRUALPOSTING.PRODUCT == MARA.MATNR
  • C_ANALYZEACCRUALPOSTING.MANDT == MARA.MANDT
Profit Center
  • ?
  • Controlling Area
  • Profit Center
  • Client
  • C_ANALYZEACCRUALPOSTING.[column in domain "DATBI"] == CEPC.DATBI
  • C_ANALYZEACCRUALPOSTING.CONTROLLINGAREA == CEPC.KOKRS
  • C_ANALYZEACCRUALPOSTING.PROFITCENTER == CEPC.PRCTR
  • C_ANALYZEACCRUALPOSTING.MANDT == CEPC.MANDT
Address key assignment to users
  • User Responsible for the Profit Center
  • Client
  • C_ANALYZEACCRUALPOSTING.PROFITCTRRESPONSIBLEUSER == USR02.BNAME
  • C_ANALYZEACCRUALPOSTING.MANDT == USR02.MANDT
Project Internal ID
  • Project Internal ID
  • Client
  • C_ANALYZEACCRUALPOSTING.PROJECTINTERNALID == PROJ.PSPNR
  • C_ANALYZEACCRUALPOSTING.MANDT == PROJ.MANDT
Network Number for Account Assignment
  • Network Number for Account Assignment
  • Client
  • C_ANALYZEACCRUALPOSTING.PROJECTNETWORK == AUFK.AUFNR
  • C_ANALYZEACCRUALPOSTING.MANDT == AUFK.MANDT
Reference Document Type C_ANALYZEACCRUALPOSTING.REFERENCEDOCUMENTTYPE == TTYP.AWTYP
Segment for Segmental Reporting
  • Segment for Segmental Reporting
  • Client
  • C_ANALYZEACCRUALPOSTING.SEGMENT == FAGL_SEGM.SEGMENT
  • C_ANALYZEACCRUALPOSTING.MANDT == FAGL_SEGM.MANDT
Service Document ID
  • Service Document Type
  • Client
  • Service Document ID
  • ?
  • C_ANALYZEACCRUALPOSTING.SERVICEDOCUMENTTYPE == FCO_SRVDOC.SERVICE_DOC_TYPE
  • C_ANALYZEACCRUALPOSTING.MANDT == FCO_SRVDOC.MANDT
  • C_ANALYZEACCRUALPOSTING.SERVICEDOCUMENT == FCO_SRVDOC.SERVICE_DOC_ID
  • C_ANALYZEACCRUALPOSTING.[column in domain "FCO_SRVDOC_ITEM_ID"] == FCO_SRVDOC.SERVICE_DOC_ITEM_ID
Service Document Type
  • Service Document Type
  • Client
Source Ledger
  • Ledger
  • Source Ledger
  • Client
Subledger-Specific Line Item Type C_ANALYZEACCRUALPOSTING.SUBLEDGERACCTLINEITEMTYPE == FINSTS_SLALITTY.SLALITTYPE
Supplier
  • Supplier
  • Client
  • C_ANALYZEACCRUALPOSTING.SUPPLIER == LFA1.LIFNR
  • C_ANALYZEACCRUALPOSTING.MANDT == LFA1.MANDT
Vendor account group
  • Vendor account group
  • Client
  • C_ANALYZEACCRUALPOSTING.SUPPLIERACCOUNTGROUP == T077K.KTOKK
  • C_ANALYZEACCRUALPOSTING.MANDT == T077K.MANDT
Tax on sales/purchases code
  • ?
  • Tax on sales/purchases code
  • Client
  • C_ANALYZEACCRUALPOSTING.[column in domain "KALSM_D"] == T007A.KALSM
  • C_ANALYZEACCRUALPOSTING.TAXCODE == T007A.MWSKZ
  • C_ANALYZEACCRUALPOSTING.MANDT == T007A.MANDT
Transaction Currency
  • Transaction Currency
  • Client
  • C_ANALYZEACCRUALPOSTING.TRANSACTIONCURRENCY == TCURC.WAERS
  • C_ANALYZEACCRUALPOSTING.MANDT == TCURC.MANDT