Application Platform (AP)
Basis Components (BC)
Business Mobile (MOB)
Business Network Solutions (BNS)
Controlling (CO)
Cross-Application Components (CA)
- Asset Retirement Obligation Management for Oil & Gas (CA-ARO)
- Available to Promise (ATP) (CA-ATP)
- Bank (CA-BK)
- CA-VCM: Value Chain Management (CA-VCM)
- Classification (CA-CL)
- Commercial Project Management (CA-CPD)
- Cross functional developments in Asset Intell. N/W (CA-AIN)
- Cross-Application Objects in HR (CA-HR)
- Data Transformation (CA-DT)
- Document Management System (CA-DMS)
- Field Logistics (CA-FL)
- General Application Functions (CA-GTF)
  - Business Document Flow (CA-GTF-BPF)
  - Business Event Handling (CA-GTF-BEH)
  - Business Event Logging (CA-GTF-BEL)
  - Business User Management (CA-GTF-BUM)
  - Commodity Pricing Engine (CA-GTF-CPE)
  - Consent Administration (CA-GTF-CON)
  - Contextual Business Navigation (CA-GTF-CBN)
  - Country/Region-Specific Application Interface Objects (CA-GTF-CSC)
  - Cross-Application Services General Ledger (CA-GTF-GL)
  - DART (Data Retention Tool) (CA-GTF-DRT)
  - Date Function (CA-GTF-DF)
  - Digital Access (CA-GTF-DA)
  - Feature Management (CA-GTF-FM)
  - Financial Closing cockpit Add-on (CA-GTF-FCC)
  - Fiori Xperience Unit (FXU) (CA-GTF-FXU)
    - Fiori FXU Finance (CA-GTF-FXU-FI)
    - Fiori FXU Procurement (CA-GTF-FXU-MM)
    - UX - Fiori Xperience Unit (FXU) - General Topics (CA-GTF-FXU-GEN)
  - HANA Search for Business Suite (CA-GTF-HSB)
  - Responsibility Management (CA-GTF-RM)
  - S/4HANA Extensibility and Integration (CA-GTF-EI)
  - SAP S/4HANA Data Migration Cockpit Content (LTMC) (CA-GTF-MIG)
  - SAP Smart Business for S/4HANA (CA-GTF-ANA)
  - Virtual Data Model (CA-GTF-VDM)
  - s-Innovations Output Management (CA-GTF-OC)
- Integration from S/4HC to Master Data for Worker (CA-WFD)
- Issue & Activity Management (CA-IAM)
- Joint Venture und Production Sharing Accounting (CA-JVA)
- Landscape Transformation (CA-LT)
- Machine Learning (CA-ML)
- Master Data Governance. (CA-MDG)
- Master Data Integration Services (CA-MDI)
- PLM Audit Management (CA-AUD)
- Prepayment agreements (CA-PPA)
- Processes and Tools for Enterprise Applications (CA-EPT)
- Production Volume Capture (CA-PVL)
- Resource Scheduling (CA-RSH)
- SAP UI development toolkit for HTML5 - Rendering library (CA-UI5)
- Situation handling across applications, generic (CA-SIT)
- Time Sheet (CA-TS)
Cross-Application Components (CA)
- Asset Retirement Obligation Management for Oil & Gas (CA-ARO)
- Available to Promise (ATP) (CA-ATP)
- Bank (CA-BK)
- CA-VCM: Value Chain Management (CA-VCM)
- Classification (CA-CL)
- Commercial Project Management (CA-CPD)
- Cross functional developments in Asset Intell. N/W (CA-AIN)
- Cross-Application Objects in HR (CA-HR)
- Data Transformation (CA-DT)
- Document Management System (CA-DMS)
- Field Logistics (CA-FL)
- General Application Functions (CA-GTF)
  - Business Document Flow (CA-GTF-BPF)
  - Business Event Handling (CA-GTF-BEH)
  - Business Event Logging (CA-GTF-BEL)
  - Business User Management (CA-GTF-BUM)
  - Commodity Pricing Engine (CA-GTF-CPE)
  - Consent Administration (CA-GTF-CON)
  - Contextual Business Navigation (CA-GTF-CBN)
  - Country/Region-Specific Application Interface Objects (CA-GTF-CSC)
  - Cross-Application Services General Ledger (CA-GTF-GL)
  - DART (Data Retention Tool) (CA-GTF-DRT)
  - Date Function (CA-GTF-DF)
  - Digital Access (CA-GTF-DA)
  - Feature Management (CA-GTF-FM)
  - Financial Closing cockpit Add-on (CA-GTF-FCC)
  - Fiori Xperience Unit (FXU) (CA-GTF-FXU)
    - Fiori FXU Finance (CA-GTF-FXU-FI)
    - Fiori FXU Procurement (CA-GTF-FXU-MM)
    - UX - Fiori Xperience Unit (FXU) - General Topics (CA-GTF-FXU-GEN)
  - HANA Search for Business Suite (CA-GTF-HSB)
  - Responsibility Management (CA-GTF-RM)
  - S/4HANA Extensibility and Integration (CA-GTF-EI)
  - SAP S/4HANA Data Migration Cockpit Content (LTMC) (CA-GTF-MIG)
  - SAP Smart Business for S/4HANA (CA-GTF-ANA)
  - Virtual Data Model (CA-GTF-VDM)
  - s-Innovations Output Management (CA-GTF-OC)
- Integration from S/4HC to Master Data for Worker (CA-WFD)
- Issue & Activity Management (CA-IAM)
- Joint Venture und Production Sharing Accounting (CA-JVA)
- Landscape Transformation (CA-LT)
- Machine Learning (CA-ML)
- Master Data Governance. (CA-MDG)
- Master Data Integration Services (CA-MDI)
- PLM Audit Management (CA-AUD)
- Prepayment agreements (CA-PPA)
- Processes and Tools for Enterprise Applications (CA-EPT)
- Production Volume Capture (CA-PVL)
- Resource Scheduling (CA-RSH)
- SAP UI development toolkit for HTML5 - Rendering library (CA-UI5)
- Situation handling across applications, generic (CA-SIT)
- Time Sheet (CA-TS)
Customer Relationship Management (CRM)
Enterprise Contract Management (CM)
Enterprise Controlling (EC)
Enterprise information management solutions (EIM)
Environment, Health, and Safety / Product Compliance (EHS)
Financial Accounting (FI)
Financial Services (FS)
Global Trade Services (SLL)
Investment Management (IM)
LOD Components (LOD)
Legal Content Management (LCM)
Logistics - General (LO)
Logistics Execution (LE)
Materials Management (MM)
Occasional Platform User (OPU)
Payroll (PY)
Personnel Management (PA)
Plant Maintenance (PM)
Portfolio and Project Management (PPM)
Product Lifecycle Management (PLM)
Production Planning and Control (PP)
Project System (PS)
Public Sector Management (PSM)
Purchasing SAP Cloud (PUR)
Quality Management (QM)
Real Estate Management (RE)
SAP Business Warehouse (BW)
SAP Supplier Lifecycle Management (SLC)
Sales and Distribution (SD)
Service (SV)
Supply Chain Management (SCM)
Sustainability management (SUS)
Transportation Management (TM)

I_AccrualLineItem

Accrual Line Item | view: IACELINEITM | Extraction: Not supported | Component: Fiori FXU General Ledger Accounting FI-FIO-GL

Tables used: ACDOCA, T003, FINSC_CURTYPE, FINSC_CURTYPET, KNA1, SKB1, FINSC_LEDGER_T, CEPC, LFA1, T077K, TACE_TTYPET, FINSC_LD_CMP, TACE_SLALITTYPE, FINSC_LEDGER_REP

🔑 Keys (6)
💰 Amounts (4)
∑ Quantities
📅 Dates (5)
☰ Categorical (8)
Other (33)
🔗 Relations (44)

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
💲 Freely Defined Currency 1 (FreeDefinedCurrency1):
AmountInCompanyCodeCurrency	Amount in Company Code Currency
AmountInTransactionCurrency	Amount in Transaction Currency
AmountInFreeDefinedCurrency1	Amount in Freely Defined Currency 1
💲 Global Currency (GlobalCurrency):
AmountInGlobalCurrency	Amount in Global Currency

Column Name	Description

Column Name	Description
PostingDate	Posting Date
CreationDate	Creation Date
DocumentDate	Journal Entry 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
GLAccountLineItemIsAccrual	ACE Line Item Indicator	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

Column Name	Description	Domain name
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
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
OffsettingAccount	Offsetting Account	GKONT
FinancialAccrTransacTypeName	Text	TEXT50
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
GLAccountAuthorizationGroup	Authorization Group	BRGRU
SupplierFinsAuthorizationGrp	Authorization Group	BRGRU
CustomerFinsAuthorizationGrp	Authorization Group	BRGRU
SupplierAccountGroup	Vendor account group	KTOKK
AcctgDocTypeAuthorizationGroup	Authorization Group	BRGRU
LedgerName	Ledger Name	TEXT30

Master Data Relations	Join Conditions
Journal Entry Type Client Journal Entry Type	`I_ACCRUALLINEITEM.MANDT == T003.MANDT` `I_ACCRUALLINEITEM.ACCOUNTINGDOCUMENTTYPE == T003.BLART`
Type of the Accrual Object Type of the Accrual Object Client	`I_ACCRUALLINEITEM.ACCRUALOBJECTTYPE == TACR_OBJ_TYPE.ACROBJ_TYPE` `I_ACCRUALLINEITEM.MANDT == TACR_OBJ_TYPE.MANDT`
Alternative Account Number in Company Code Client Alternative Chart of Accounts Alternative Account Number in Company Code	`I_ACCRUALLINEITEM.MANDT == SKA1.MANDT` `I_ACCRUALLINEITEM.COUNTRYCHARTOFACCOUNTS == SKA1.KTOPL` `I_ACCRUALLINEITEM.ALTERNATIVEGLACCOUNT == SKA1.SAKNR`
Business Area Client Business Area	`I_ACCRUALLINEITEM.MANDT == TGSB.MANDT` `I_ACCRUALLINEITEM.BUSINESSAREA == TGSB.GSBER`
Business Process ? Client Business Process Controlling Area	`I_ACCRUALLINEITEM.[column in domain "DATBI"] == CBPR.DATBI` `I_ACCRUALLINEITEM.MANDT == CBPR.MANDT` `I_ACCRUALLINEITEM.BUSINESSPROCESS == CBPR.PRZNR` `I_ACCRUALLINEITEM.CONTROLLINGAREA == CBPR.KOKRS`
Business Transaction Category Client Business Transaction Category	`I_ACCRUALLINEITEM.MANDT == FINSC_BTTYPE.MANDT` `I_ACCRUALLINEITEM.BUSINESSTRANSACTIONTYPE == FINSC_BTTYPE.BTTYPE`
Company Code Company Code Client	`I_ACCRUALLINEITEM.COMPANYCODE == T001.BUKRS` `I_ACCRUALLINEITEM.MANDT == T001.MANDT`
Company Code Currency Client Company Code Currency	`I_ACCRUALLINEITEM.MANDT == TCURC.MANDT` `I_ACCRUALLINEITEM.COMPANYCODECURRENCY == TCURC.WAERS`
Controlling Area Client Controlling Area	`I_ACCRUALLINEITEM.MANDT == TKA01.MANDT` `I_ACCRUALLINEITEM.CONTROLLINGAREA == TKA01.KOKRS`
Cost Center ? Client Cost Center Controlling Area	`I_ACCRUALLINEITEM.[column in domain "DATBI"] == CSKS.DATBI` `I_ACCRUALLINEITEM.MANDT == CSKS.MANDT` `I_ACCRUALLINEITEM.COSTCENTER == CSKS.KOSTL` `I_ACCRUALLINEITEM.CONTROLLINGAREA == CSKS.KOKRS`
Cost Object ? Cost Object Client	`I_ACCRUALLINEITEM.[column in domain "DATBI"] == CKPH.DATBI` `I_ACCRUALLINEITEM.COSTOBJECT == CKPH.KSTRG` `I_ACCRUALLINEITEM.MANDT == CKPH.MANDT`
Origin Group as Subdivision of Cost Element ? Client Origin Group as Subdivision of Cost Element Controlling Area	`I_ACCRUALLINEITEM.[column in domain "HRKTYP"] == TKKH1.KOATY` `I_ACCRUALLINEITEM.MANDT == TKKH1.MANDT` `I_ACCRUALLINEITEM.COSTORIGINGROUP == TKKH1.HRKFT` `I_ACCRUALLINEITEM.CONTROLLINGAREA == TKKH1.KOKRS`
Alternative Chart of Accounts Client Alternative Chart of Accounts	`I_ACCRUALLINEITEM.MANDT == T004.MANDT` `I_ACCRUALLINEITEM.COUNTRYCHARTOFACCOUNTS == T004.KTOPL`
Customer Number Customer Number Client	`I_ACCRUALLINEITEM.CUSTOMER == KNA1.KUNNR` `I_ACCRUALLINEITEM.MANDT == KNA1.MANDT`
Customer Account Group Customer Account Group Client	`I_ACCRUALLINEITEM.CUSTOMERACCOUNTGROUP == T077D.KTOKD` `I_ACCRUALLINEITEM.MANDT == T077D.MANDT`
ACE Posting Type	`I_ACCRUALLINEITEM.FINANCIALACCRUALTRANSACTYPE == TACE_TTYPE.TTYPE`
Fiscal Year Variant Client Fiscal Year Variant	`I_ACCRUALLINEITEM.MANDT == T009.MANDT` `I_ACCRUALLINEITEM.FISCALYEARVARIANT == T009.PERIV`
Freely Defined Currency 1 Client Freely Defined Currency 1	`I_ACCRUALLINEITEM.MANDT == TCURC.MANDT` `I_ACCRUALLINEITEM.FREEDEFINEDCURRENCY1 == TCURC.WAERS`
Freely Defined Currency 1 Role (Currency Type) Freely Defined Currency 1 Role (Currency Type) Client	`I_ACCRUALLINEITEM.FREEDEFINEDCURRENCY1ROLE == FINSC_CURTYPE.CURTYPE` `I_ACCRUALLINEITEM.MANDT == FINSC_CURTYPE.MANDT`
Functional Area Client Functional Area	`I_ACCRUALLINEITEM.MANDT == TFKB.MANDT` `I_ACCRUALLINEITEM.FUNCTIONALAREA == TFKB.FKBER`
G/L Account Company Code Client G/L Account	`I_ACCRUALLINEITEM.COMPANYCODE == SKB1.BUKRS` `I_ACCRUALLINEITEM.MANDT == SKB1.MANDT` `I_ACCRUALLINEITEM.GLACCOUNT == SKB1.SAKNR`
Global Currency Client Global Currency	`I_ACCRUALLINEITEM.MANDT == TCURC.MANDT` `I_ACCRUALLINEITEM.GLOBALCURRENCY == TCURC.WAERS`
Global Currency Role Global Currency Role Client	`I_ACCRUALLINEITEM.GLOBALCURRENCYROLE == FINSC_CURTYPE.CURTYPE` `I_ACCRUALLINEITEM.MANDT == FINSC_CURTYPE.MANDT`
Ledger Client Ledger Source Ledger	`I_ACCRUALLINEITEM.MANDT == FINSC_LEDGER.MANDT` `I_ACCRUALLINEITEM.LEDGER == FINSC_LEDGER.RLDNR` `I_ACCRUALLINEITEM.SOURCELEDGER == FINSC_LEDGER.RLDNR`
Order Number Client Order Number	`I_ACCRUALLINEITEM.MANDT == AUFK.MANDT` `I_ACCRUALLINEITEM.ORDERID == AUFK.AUFNR`
Plant Client Plant	`I_ACCRUALLINEITEM.MANDT == T001W.MANDT` `I_ACCRUALLINEITEM.PLANT == T001W.WERKS`
Posting Key Client Posting Key	`I_ACCRUALLINEITEM.MANDT == TBSL.MANDT` `I_ACCRUALLINEITEM.POSTINGKEY == TBSL.BSCHL`
Product Number Client Product Number	`I_ACCRUALLINEITEM.MANDT == MARA.MANDT` `I_ACCRUALLINEITEM.PRODUCT == MARA.MATNR`
Profit Center ? Client Controlling Area Profit Center	`I_ACCRUALLINEITEM.[column in domain "DATBI"] == CEPC.DATBI` `I_ACCRUALLINEITEM.MANDT == CEPC.MANDT` `I_ACCRUALLINEITEM.CONTROLLINGAREA == CEPC.KOKRS` `I_ACCRUALLINEITEM.PROFITCENTER == CEPC.PRCTR`
Address key assignment to users Client User Responsible for the Profit Center	`I_ACCRUALLINEITEM.MANDT == USR02.MANDT` `I_ACCRUALLINEITEM.PROFITCTRRESPONSIBLEUSER == USR02.BNAME`
Project Internal ID Client Project Internal ID	`I_ACCRUALLINEITEM.MANDT == PROJ.MANDT` `I_ACCRUALLINEITEM.PROJECTINTERNALID == PROJ.PSPNR`
Network Number for Account Assignment Client Network Number for Account Assignment	`I_ACCRUALLINEITEM.MANDT == AUFK.MANDT` `I_ACCRUALLINEITEM.PROJECTNETWORK == AUFK.AUFNR`
Reference Document Type	`I_ACCRUALLINEITEM.REFERENCEDOCUMENTTYPE == TTYP.AWTYP`
Segment for Segmental Reporting Client Segment for Segmental Reporting	`I_ACCRUALLINEITEM.MANDT == FAGL_SEGM.MANDT` `I_ACCRUALLINEITEM.SEGMENT == FAGL_SEGM.SEGMENT`
Service Document ID Client Service Document ID Service Document Type ?	`I_ACCRUALLINEITEM.MANDT == FCO_SRVDOC.MANDT` `I_ACCRUALLINEITEM.SERVICEDOCUMENT == FCO_SRVDOC.SERVICE_DOC_ID` `I_ACCRUALLINEITEM.SERVICEDOCUMENTTYPE == FCO_SRVDOC.SERVICE_DOC_TYPE` `I_ACCRUALLINEITEM.[column in domain "FCO_SRVDOC_ITEM_ID"] == FCO_SRVDOC.SERVICE_DOC_ITEM_ID`
Service Document Type Client Service Document Type	`I_ACCRUALLINEITEM.MANDT == CRMC_PROC_TYPE.CLIENT` `I_ACCRUALLINEITEM.SERVICEDOCUMENTTYPE == CRMC_PROC_TYPE.PROCESS_TYPE`
Source Ledger Client Ledger Source Ledger	`I_ACCRUALLINEITEM.MANDT == FINSC_LEDGER.MANDT` `I_ACCRUALLINEITEM.LEDGER == FINSC_LEDGER.RLDNR` `I_ACCRUALLINEITEM.SOURCELEDGER == FINSC_LEDGER.RLDNR`
Subledger-Specific Line Item Type	`I_ACCRUALLINEITEM.SUBLEDGERACCTLINEITEMTYPE == FINSTS_SLALITTY.SLALITTYPE`
Supplier Client Supplier	`I_ACCRUALLINEITEM.MANDT == LFA1.MANDT` `I_ACCRUALLINEITEM.SUPPLIER == LFA1.LIFNR`
Tax on sales/purchases code Tax on sales/purchases code Client ?	`I_ACCRUALLINEITEM.TAXCODE == T007A.MWSKZ` `I_ACCRUALLINEITEM.MANDT == T007A.MANDT` `I_ACCRUALLINEITEM.[column in domain "KALSM_D"] == T007A.KALSM`
Transaction Currency Client Transaction Currency	`I_ACCRUALLINEITEM.MANDT == TCURC.MANDT` `I_ACCRUALLINEITEM.TRANSACTIONCURRENCY == TCURC.WAERS`