A_GLAccountLineItem

API G/L Account Line Item | view: AFIGLACCTLIT | Extraction: Not supported | Component: Information System
Tables used: ACDOCA, 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 in General Ledger Accounting
Column Name Description
💲 Balance Transaction Currency (BalanceTransactionCurrency):
AmountInBalanceTransacCrcy Amount in Balance Transaction Currency
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
FixedAmountInCoCodeCrcy Fixed Amount in Company Currency
💲 Global Currency (GlobalCurrency):
AmountInGlobalCurrency Amount in Global Currency
FixedAmountInGlobalCrcy Fixed Amount in Global Currency
GrpValnFixedAmtInGlobCrcy Group Valuation Fixed Amount in Global Currency
PrftCtrValnFxdAmtInGlobCrcy Profit Center Valuation Fixed Amount in Global Currency
TotalPriceVarcInGlobalCrcy Total Price Variance in Global Currency
GrpValnTotPrcVarcInGlobCrcy Group Valuation Total Price Variance in Global Currency
PrftCtrValnTotPrcVarcInGlbCrcy Profit Center Valuation Total Price Variance in Global Cur.
FixedPriceVarcInGlobalCrcy Fixed Price Variance in Global Currency
GrpValnFixedPrcVarcInGlobCrcy Group Valuation Fixed Price Variance in Global Currency
PrftCtrValnFxdPrcVarcInGlbCrcy Profit Center Valuation Fixed Price Variance in Global Cur.
💲 Freely Defined Currency 1 (FreeDefinedCurrency1):
AmountInFreeDefinedCurrency1 Amount in Freely Defined Currency 1
💲 Freely Defined Currency 2 (FreeDefinedCurrency2):
AmountInFreeDefinedCurrency2 Amount in Freely Defined Currency 2
💲 Freely Defined Currency 3 (FreeDefinedCurrency3):
AmountInFreeDefinedCurrency3 Amount in Freely Defined Currency 3
💲 Freely Defined Currency 4 (FreeDefinedCurrency4):
AmountInFreeDefinedCurrency4 Amount in Freely Defined Currency 4
💲 Freely Defined Currency 5 (FreeDefinedCurrency5):
AmountInFreeDefinedCurrency5 Amount in Freely Defined Currency 5
💲 Freely Defined Currency 6 (FreeDefinedCurrency6):
AmountInFreeDefinedCurrency6 Amount in Freely Defined Currency 6
💲 Freely Defined Currency 7 (FreeDefinedCurrency7):
AmountInFreeDefinedCurrency7 Amount in Freely Defined Currency 7
💲 Freely Defined Currency 8 (FreeDefinedCurrency8):
AmountInFreeDefinedCurrency8 Amount in Freely Defined Currency 8
💲 CO Object Currency (ControllingObjectCurrency):
AmountInObjectCurrency Amount in Object Currency
Column Name Description
📏 Base Unit of Measure (BaseUnit):
Quantity Quantity
FixedQuantity Fixed Quantity
📏 Cost Source Unit (CostSourceUnit):
ValuationQuantity Valuation Quantity
ValuationFixedQuantity Valuation Fixed Quantity
📏 Additional Quantity 1 Unit (AdditionalQuantity1Unit):
AdditionalQuantity1 Additional Quantity 1
📏 Additional Quantity 2 Unit (AdditionalQuantity2Unit):
AdditionalQuantity2 Additional Quantity 2
📏 Additional Quantity 3 Unit (AdditionalQuantity3Unit):
AdditionalQuantity3 Additional Quantity 3
Column Name Description
PostingDate Posting Date
DocumentDate Journal Entry Date
CreationDate Creation Date
ServicesRenderedDate Date on which services are rendered
ClearingDate Clearing Date
ValueDate Value date
AssetValueDate Asset Value Date
Column Name Description
GLRecordType Record Type Show values
IsReversal Indicator: Item is Reversing Another Item Show values
IsReversed Indicator: Item is Reversed Show values
IsSettlement Indicator: Item is Settling or Transferring Another Item Show values
IsSettled Indicator: Line Item is Settled or Transferred Show values
IsCommitment Indicator: Is Commitment Show values
JrnlEntryItemObsoleteReason Journal Entry Item Obsolete Reason Show values
DebitCreditCode Debit/Credit Code Show values
AccountingDocumentCategory Journal Entry Category Show values
OriginObjectType Type of Origin Object Show values
GLAccountType Type of a General Ledger Account Show values
ItemIsSplit Item changed by document splitting Show values
ReferencePurchaseOrderCategory Category of Reference Purchase Order Show values
FinancialAccountType Account Type Show values
IsOpenItemManaged Managed on an Open Item Basis Show values
DepreciationFiscalPeriod Fiscal Period of Depreciation Show values
InventorySpecialStockValnType Inventory Special Stock Valuation Type Show values
ControllingObjectDebitType Controlling Object Debit Type Show values
QuantityIsIncomplete Indicator: Quantity Is Incomplete Show values
OffsettingAccountType Offsetting Account Type Show values
LineItemIsCompleted Indicator: Line Item is Completed Show values
ControllingObjectClass Object Class Show values
PartnerControllingObjectClass Partner object class Show values
OrderCategory Order category Show values
PartnerOrderCategory Partner Order Category Show values
Column Name Description Domain name
LedgerFiscalYear Ledger Fiscal Year GJAHR
ReferenceDocumentContext Reference Document Context AWORG
ReferenceDocument Reference document number AWREF
ReferenceDocumentItem Reference Document Item NUMC6
ReferenceDocumentItemGroup Reference Document Item Group NUMC6
TransactionSubitem Partial Document to be balanced to zero NUMC6
ReversalReferenceDocumentCntxt Reversal Reference Document Context AWORG
ReversalReferenceDocument Reversal Reference Document AWREF
PredecessorReferenceDocCntxt Predecessor Reference Document Context AWORG
PredecessorReferenceDocument Predecessor Reference Document AWREF
PredecessorReferenceDocItem Predecessor Reference Document Item NUMC6
PrdcssrJournalEntryFiscalYear Preceding Journal Entry Fiscal Year GJAHR
PredecessorJournalEntry Preceding Journal Entry Document Number BELNR
PredecessorJournalEntryItem Preceding Journal Entry Line Item DOCLN6
SourceReferenceDocumentCntxt Source Reference Document Context AWORG
SourceReferenceDocument Source Reference Document AWREF
SourceReferenceDocumentItem Source Reference Document Item NUMC6
SourceReferenceDocSubitem Source Reference Document Subitem NUMC6
JrnlPeriodEndClosingRunLogUUID UUID of Financial Closing Run UUID
FiscalPeriod Fiscal Period POPER
FiscalYearPeriod Fiscal Year Period FIS_JAHRPER_CONV
AccountingDocumentItem Journal Entry Posting View Item BUZEI
AssignmentReference Assignment Reference ZUONR
TransactionTypeDetermination Transaction Key CHAR3
LastChangeDateTime Time Stamp of Last Change TZNTSTMPS
CreationDateTime Time Stamp of Creation TZNTSTMPS
InvoiceReference Invoice Reference BELNR
InvoiceReferenceFiscalYear Invoice Reference Fiscal Year GJAHR
FollowOnDocumentType Follow-On Document Type REBZT
InvoiceItemReference Invoice Item Reference BUZEI
AccountAssignmentNumber Account Assignment Number NUM02
DocumentItemText Item Text TEXT50
SalesDocumentItem Sales Document Item POSNR
ConditionContract Condition Contract WCB_COCO_NUM
ClearingAccountingDocument Clearing Journal Entry BELNR
ClearingDocFiscalYear Fiscal Year of Clearing Journal Entry GJAHR
CostEstimate Cost Estimate CK_KALNR
InventorySpecialStockType Inventory Special Stock Type SOBKZ
InventorySpclStkSalesDocument Inventory Special Stock Sales Document VBELN
InventorySpclStkSalesDocItm Inventory Special Stock Sales Document Item POSNR
InvtrySpclStockWBSElmntIntID Inventory Special Stock WBS Element Internal ID FIS_WBSINT_NO_CONV
InventorySpecialStockSupplier Supplier of Inventory Special Stock LIFNR
OffsettingAccount Offsetting Account GKONT
OffsettingChartOfAccounts Offsetting Chart of Accounts KTOPL
PersonnelNumber Personnel Number PERNR
AccountAssignment Account Assignment ACCAS
WBSElementInternalID WBS Element Internal ID FIS_WBSINT_NO_CONV
PartnerWBSElementInternalID Partner WBS Element Internal ID FIS_WBSINT_NO_CONV
PartnerServiceDocumentItem Partner Service Document Item
TimeSheetOvertimeCategory Overtime Category CATS_OVERTIME_CATEGORY
PartnerAccountAssignment Partner Account Assignment ACCAS
ControllingDocumentItem Controlling Document Item BUZEI
CustomerSupplierCorporateGroup Customer Supplier Corporate Group KONZS
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • A_GLACCOUNTLINEITEM.MANDT == T003.MANDT
  • A_GLACCOUNTLINEITEM.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Additional Quantity 1 Unit
  • Client
  • Additional Quantity 1 Unit
  • A_GLACCOUNTLINEITEM.MANDT == T006.MANDT
  • A_GLACCOUNTLINEITEM.ADDITIONALQUANTITY1UNIT == T006.MSEHI
Additional Quantity 2 Unit
  • Client
  • Additional Quantity 2 Unit
  • A_GLACCOUNTLINEITEM.MANDT == T006.MANDT
  • A_GLACCOUNTLINEITEM.ADDITIONALQUANTITY2UNIT == T006.MSEHI
Additional Quantity 3 Unit
  • Additional Quantity 3 Unit
  • Client
  • A_GLACCOUNTLINEITEM.ADDITIONALQUANTITY3UNIT == T006.MSEHI
  • A_GLACCOUNTLINEITEM.MANDT == T006.MANDT
Alternative G/L Account Number In Company Code
  • Alternative Chart of Accounts for Country/Region
  • Client
  • Alternative G/L Account Number In Company Code
  • A_GLACCOUNTLINEITEM.COUNTRYCHARTOFACCOUNTS == SKA1.KTOPL
  • A_GLACCOUNTLINEITEM.MANDT == SKA1.MANDT
  • A_GLACCOUNTLINEITEM.ALTERNATIVEGLACCOUNT == SKA1.SAKNR
Transaction Type Category A_GLACCOUNTLINEITEM.ASSETACCTTRANSCLASSFCTN == FAAI_MOVCAT.MOVCAT
Asset Class
  • Asset Class
  • Client
  • A_GLACCOUNTLINEITEM.ASSETCLASS == ANKA.ANLKL
  • A_GLACCOUNTLINEITEM.MANDT == ANKA.MANDT
Asset Transaction Type
  • Client
  • Asset Transaction Type
  • A_GLACCOUNTLINEITEM.MANDT == TABW.MANDT
  • A_GLACCOUNTLINEITEM.ASSETTRANSACTIONTYPE == TABW.BWASL
Balance Transaction Currency
  • Client
  • Balance Transaction Currency
  • A_GLACCOUNTLINEITEM.MANDT == TCURC.MANDT
  • A_GLACCOUNTLINEITEM.BALANCETRANSACTIONCURRENCY == TCURC.WAERS
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • A_GLACCOUNTLINEITEM.MANDT == T006.MANDT
  • A_GLACCOUNTLINEITEM.BASEUNIT == T006.MSEHI
Billable Control
  • Billable Control
  • Client
  • A_GLACCOUNTLINEITEM.BILLABLECONTROL == TBMOT.BEMOT
  • A_GLACCOUNTLINEITEM.MANDT == TBMOT.MANDT
Billing Type
  • Billing Type
  • Client
  • A_GLACCOUNTLINEITEM.BILLINGDOCUMENTTYPE == TVFK.FKART
  • A_GLACCOUNTLINEITEM.MANDT == TVFK.MANDT
Bill-to Party
  • Client
  • Bill-to Party
  • A_GLACCOUNTLINEITEM.MANDT == KNA1.MANDT
  • A_GLACCOUNTLINEITEM.BILLTOPARTY == KNA1.KUNNR
Business Area
  • Client
  • Business Area
  • A_GLACCOUNTLINEITEM.MANDT == TGSB.MANDT
  • A_GLACCOUNTLINEITEM.BUSINESSAREA == TGSB.GSBER
Business Process
  • Controlling Area
  • Client
  • Business Process
  • ?
  • A_GLACCOUNTLINEITEM.CONTROLLINGAREA == CBPR.KOKRS
  • A_GLACCOUNTLINEITEM.MANDT == CBPR.MANDT
  • A_GLACCOUNTLINEITEM.BUSINESSPROCESS == CBPR.PRZNR
  • A_GLACCOUNTLINEITEM.[column in domain "DATBI"] == CBPR.DATBI
Business Transaction Type
  • Client
  • Business Transaction Type
Chart of Accounts
  • Client
  • Chart of Accounts
  • A_GLACCOUNTLINEITEM.MANDT == T004.MANDT
  • A_GLACCOUNTLINEITEM.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Client
  • Company Code
  • A_GLACCOUNTLINEITEM.MANDT == T001.MANDT
  • A_GLACCOUNTLINEITEM.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Client
  • Company Code Currency
  • A_GLACCOUNTLINEITEM.MANDT == TCURC.MANDT
  • A_GLACCOUNTLINEITEM.COMPANYCODECURRENCY == TCURC.WAERS
Controlling Area
  • Controlling Area
  • Client
  • A_GLACCOUNTLINEITEM.CONTROLLINGAREA == TKA01.KOKRS
  • A_GLACCOUNTLINEITEM.MANDT == TKA01.MANDT
CO Object Currency
  • Client
  • CO Object Currency
  • A_GLACCOUNTLINEITEM.MANDT == TCURC.MANDT
  • A_GLACCOUNTLINEITEM.CONTROLLINGOBJECTCURRENCY == TCURC.WAERS
Cost Analysis Resource
  • Controlling Area
  • Client
  • Cost Analysis Resource
  • ?
  • A_GLACCOUNTLINEITEM.CONTROLLINGAREA == CSKR.KOKRS
  • A_GLACCOUNTLINEITEM.MANDT == CSKR.MANDT
  • A_GLACCOUNTLINEITEM.COSTANALYSISRESOURCE == CSKR.RESRC
  • A_GLACCOUNTLINEITEM.[column in domain "DATBI"] == CSKR.DATBI
Cost Center
  • Controlling Area
  • Client
  • ?
  • Cost Center
  • A_GLACCOUNTLINEITEM.CONTROLLINGAREA == CSKS.KOKRS
  • A_GLACCOUNTLINEITEM.MANDT == CSKS.MANDT
  • A_GLACCOUNTLINEITEM.[column in domain "DATBI"] == CSKS.DATBI
  • A_GLACCOUNTLINEITEM.COSTCENTER == CSKS.KOSTL
Activity Type
  • Controlling Area
  • Client
  • ?
  • Activity Type
  • A_GLACCOUNTLINEITEM.CONTROLLINGAREA == CSLA.KOKRS
  • A_GLACCOUNTLINEITEM.MANDT == CSLA.MANDT
  • A_GLACCOUNTLINEITEM.[column in domain "DATBI"] == CSLA.DATBI
  • A_GLACCOUNTLINEITEM.COSTCTRACTIVITYTYPE == CSLA.LSTAR
Cost Object
  • Client
  • ?
  • Cost Object
  • A_GLACCOUNTLINEITEM.MANDT == CKPH.MANDT
  • A_GLACCOUNTLINEITEM.[column in domain "DATBI"] == CKPH.DATBI
  • A_GLACCOUNTLINEITEM.COSTOBJECT == CKPH.KSTRG
Origin Group as Subdivision of Cost Element
  • Origin Group as Subdivision of Cost Element
  • Controlling Area
  • Client
  • ?
  • A_GLACCOUNTLINEITEM.COSTORIGINGROUP == TKKH1.HRKFT
  • A_GLACCOUNTLINEITEM.CONTROLLINGAREA == TKKH1.KOKRS
  • A_GLACCOUNTLINEITEM.MANDT == TKKH1.MANDT
  • A_GLACCOUNTLINEITEM.[column in domain "HRKTYP"] == TKKH1.KOATY
Cost Source Unit
  • Client
  • Cost Source Unit
  • A_GLACCOUNTLINEITEM.MANDT == T006.MANDT
  • A_GLACCOUNTLINEITEM.COSTSOURCEUNIT == T006.MSEHI
Alternative Chart of Accounts for Country/Region
  • Alternative Chart of Accounts for Country/Region
  • Client
  • A_GLACCOUNTLINEITEM.COUNTRYCHARTOFACCOUNTS == T004.KTOPL
  • A_GLACCOUNTLINEITEM.MANDT == T004.MANDT
Customer Number
  • Client
  • Customer Number
  • A_GLACCOUNTLINEITEM.MANDT == KNA1.MANDT
  • A_GLACCOUNTLINEITEM.CUSTOMER == KNA1.KUNNR
Customer Group
  • Client
  • Customer Group
  • A_GLACCOUNTLINEITEM.MANDT == T151.MANDT
  • A_GLACCOUNTLINEITEM.CUSTOMERGROUP == T151.KDGRP
Customer or Supplier Country/Region
  • Customer or Supplier Country/Region
  • Client
  • A_GLACCOUNTLINEITEM.CUSTOMERSUPPLIERCOUNTRY == T005.LAND1
  • A_GLACCOUNTLINEITEM.MANDT == T005.MANDT
Customer Supplier Industry
  • Client
  • Customer Supplier Industry
  • A_GLACCOUNTLINEITEM.MANDT == T016.MANDT
  • A_GLACCOUNTLINEITEM.CUSTOMERSUPPLIERINDUSTRY == T016.BRSCH
Distribution Channel
  • Client
  • Distribution Channel
  • A_GLACCOUNTLINEITEM.MANDT == TVTW.MANDT
  • A_GLACCOUNTLINEITEM.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Elimination Profit Center
  • Controlling Area
  • Client
  • ?
  • Elimination Profit Center
  • A_GLACCOUNTLINEITEM.CONTROLLINGAREA == CEPC.KOKRS
  • A_GLACCOUNTLINEITEM.MANDT == CEPC.MANDT
  • A_GLACCOUNTLINEITEM.[column in domain "DATBI"] == CEPC.DATBI
  • A_GLACCOUNTLINEITEM.ELIMINATIONPROFITCENTER == CEPC.PRCTR
Financial Transaction Type
  • Client
  • Financial Transaction Type
  • A_GLACCOUNTLINEITEM.MANDT == T856.MANDT
  • A_GLACCOUNTLINEITEM.FINANCIALTRANSACTIONTYPE == T856.TRTYP
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • A_GLACCOUNTLINEITEM.FISCALYEARVARIANT == T009.PERIV
  • A_GLACCOUNTLINEITEM.MANDT == T009.MANDT
Asset Subnumber
  • Asset Subnumber
  • Client
  • Fixed Asset
  • ?
  • A_GLACCOUNTLINEITEM.FIXEDASSET == ANLA.ANLN2
  • A_GLACCOUNTLINEITEM.MANDT == ANLA.MANDT
  • A_GLACCOUNTLINEITEM.MASTERFIXEDASSET == ANLA.ANLN1
  • A_GLACCOUNTLINEITEM.[column in domain "BUKRS"] == ANLA.BUKRS
Freely Defined Currency 1
  • Client
  • Freely Defined Currency 1
  • A_GLACCOUNTLINEITEM.MANDT == TCURC.MANDT
  • A_GLACCOUNTLINEITEM.FREEDEFINEDCURRENCY1 == TCURC.WAERS
Freely Defined Currency 2
  • Client
  • Freely Defined Currency 2
  • A_GLACCOUNTLINEITEM.MANDT == TCURC.MANDT
  • A_GLACCOUNTLINEITEM.FREEDEFINEDCURRENCY2 == TCURC.WAERS
Freely Defined Currency 3
  • Client
  • Freely Defined Currency 3
  • A_GLACCOUNTLINEITEM.MANDT == TCURC.MANDT
  • A_GLACCOUNTLINEITEM.FREEDEFINEDCURRENCY3 == TCURC.WAERS
Freely Defined Currency 4
  • Freely Defined Currency 4
  • Client
  • A_GLACCOUNTLINEITEM.FREEDEFINEDCURRENCY4 == TCURC.WAERS
  • A_GLACCOUNTLINEITEM.MANDT == TCURC.MANDT
Freely Defined Currency 5
  • Client
  • Freely Defined Currency 5
  • A_GLACCOUNTLINEITEM.MANDT == TCURC.MANDT
  • A_GLACCOUNTLINEITEM.FREEDEFINEDCURRENCY5 == TCURC.WAERS
Freely Defined Currency 6
  • Client
  • Freely Defined Currency 6
  • A_GLACCOUNTLINEITEM.MANDT == TCURC.MANDT
  • A_GLACCOUNTLINEITEM.FREEDEFINEDCURRENCY6 == TCURC.WAERS
Freely Defined Currency 7
  • Client
  • Freely Defined Currency 7
  • A_GLACCOUNTLINEITEM.MANDT == TCURC.MANDT
  • A_GLACCOUNTLINEITEM.FREEDEFINEDCURRENCY7 == TCURC.WAERS
Freely Defined Currency 8
  • Client
  • Freely Defined Currency 8
  • A_GLACCOUNTLINEITEM.MANDT == TCURC.MANDT
  • A_GLACCOUNTLINEITEM.FREEDEFINEDCURRENCY8 == TCURC.WAERS
Functional Area
  • Client
  • Functional Area
  • A_GLACCOUNTLINEITEM.MANDT == TFKB.MANDT
  • A_GLACCOUNTLINEITEM.FUNCTIONALAREA == TFKB.FKBER
G/L Account
  • Client
  • G/L Account
  • Company Code
  • A_GLACCOUNTLINEITEM.MANDT == SKB1.MANDT
  • A_GLACCOUNTLINEITEM.GLACCOUNT == SKB1.SAKNR
  • A_GLACCOUNTLINEITEM.COMPANYCODE == SKB1.BUKRS
Global Currency
  • Client
  • Global Currency
  • A_GLACCOUNTLINEITEM.MANDT == TCURC.MANDT
  • A_GLACCOUNTLINEITEM.GLOBALCURRENCY == TCURC.WAERS
Group Asset Subnumber
  • Client
  • Group Asset Subnumber
  • Group Asset
  • ?
  • A_GLACCOUNTLINEITEM.MANDT == ANLA.MANDT
  • A_GLACCOUNTLINEITEM.GROUPFIXEDASSET == ANLA.ANLN2
  • A_GLACCOUNTLINEITEM.GROUPMASTERFIXEDASSET == ANLA.ANLN1
  • A_GLACCOUNTLINEITEM.[column in domain "BUKRS"] == ANLA.BUKRS
House Bank Key
  • House Bank Key
  • Client
  • ?
  • A_GLACCOUNTLINEITEM.HOUSEBANK == T012.HBKID
  • A_GLACCOUNTLINEITEM.MANDT == T012.MANDT
  • A_GLACCOUNTLINEITEM.[column in domain "BUKRS"] == T012.BUKRS
House Bank Account
  • House Bank Key
  • House Bank Account
  • Client
  • ?
  • A_GLACCOUNTLINEITEM.HOUSEBANK == T012K.HBKID
  • A_GLACCOUNTLINEITEM.HOUSEBANKACCOUNT == T012K.HKTID
  • A_GLACCOUNTLINEITEM.MANDT == T012K.MANDT
  • A_GLACCOUNTLINEITEM.[column in domain "BUKRS"] == T012K.BUKRS
Inventory Valuation Type
  • Client
  • Inventory Valuation Type
  • A_GLACCOUNTLINEITEM.MANDT == T149D.MANDT
  • A_GLACCOUNTLINEITEM.INVENTORYVALUATIONTYPE == T149D.BWTAR
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger
Logical System A_GLACCOUNTLINEITEM.LOGICALSYSTEM == TBDLS.LOGSYS
Operating concern
  • Operating concern
  • Client
  • A_GLACCOUNTLINEITEM.OPERATINGCONCERN == TKEB.ERKRS
  • A_GLACCOUNTLINEITEM.MANDT == TKEB.MANDT
Order ID
  • Order ID
  • Client
  • A_GLACCOUNTLINEITEM.ORDERID == AUFK.AUFNR
  • A_GLACCOUNTLINEITEM.MANDT == AUFK.MANDT
Division
  • Client
  • Division
  • A_GLACCOUNTLINEITEM.MANDT == TSPA.MANDT
  • A_GLACCOUNTLINEITEM.ORGANIZATIONDIVISION == TSPA.SPART
Origin Cost Center
  • Controlling Area
  • Client
  • ?
  • Origin Cost Center
  • A_GLACCOUNTLINEITEM.CONTROLLINGAREA == CSKS.KOKRS
  • A_GLACCOUNTLINEITEM.MANDT == CSKS.MANDT
  • A_GLACCOUNTLINEITEM.[column in domain "DATBI"] == CSKS.DATBI
  • A_GLACCOUNTLINEITEM.ORIGINCOSTCENTER == CSKS.KOSTL
Origin Cost Center Activity Type
  • Controlling Area
  • Client
  • Origin Cost Center Activity Type
  • ?
  • A_GLACCOUNTLINEITEM.CONTROLLINGAREA == CSLA.KOKRS
  • A_GLACCOUNTLINEITEM.MANDT == CSLA.MANDT
  • A_GLACCOUNTLINEITEM.ORIGINCOSTCTRACTIVITYTYPE == CSLA.LSTAR
  • A_GLACCOUNTLINEITEM.[column in domain "DATBI"] == CSLA.DATBI
Origin Profit Center
  • Controlling Area
  • Client
  • ?
  • Origin Profit Center
  • A_GLACCOUNTLINEITEM.CONTROLLINGAREA == CEPC.KOKRS
  • A_GLACCOUNTLINEITEM.MANDT == CEPC.MANDT
  • A_GLACCOUNTLINEITEM.[column in domain "DATBI"] == CEPC.DATBI
  • A_GLACCOUNTLINEITEM.ORIGINPROFITCENTER == CEPC.PRCTR
Partner Business Area
  • Client
  • Partner Business Area
  • A_GLACCOUNTLINEITEM.MANDT == TGSB.MANDT
  • A_GLACCOUNTLINEITEM.PARTNERBUSINESSAREA == TGSB.GSBER
Partner Business Process
  • Controlling Area
  • Partner Business Process
  • Client
  • ?
  • A_GLACCOUNTLINEITEM.CONTROLLINGAREA == CBPR.KOKRS
  • A_GLACCOUNTLINEITEM.PARTNERBUSINESSPROCESS == CBPR.PRZNR
  • A_GLACCOUNTLINEITEM.MANDT == CBPR.MANDT
  • A_GLACCOUNTLINEITEM.[column in domain "DATBI"] == CBPR.DATBI
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • A_GLACCOUNTLINEITEM.MANDT == T880.MANDT
  • A_GLACCOUNTLINEITEM.PARTNERCOMPANY == T880.RCOMP
Partner Company Code
  • Client
  • Partner Company Code
  • A_GLACCOUNTLINEITEM.MANDT == T001.MANDT
  • A_GLACCOUNTLINEITEM.PARTNERCOMPANYCODE == T001.BUKRS
Partner Cost Center
  • Controlling Area
  • Client
  • ?
  • Partner Cost Center
  • A_GLACCOUNTLINEITEM.CONTROLLINGAREA == CSKS.KOKRS
  • A_GLACCOUNTLINEITEM.MANDT == CSKS.MANDT
  • A_GLACCOUNTLINEITEM.[column in domain "DATBI"] == CSKS.DATBI
  • A_GLACCOUNTLINEITEM.PARTNERCOSTCENTER == CSKS.KOSTL
Partner Cost Center Activity Type
  • Controlling Area
  • Client
  • ?
  • Partner Cost Center Activity Type
  • A_GLACCOUNTLINEITEM.CONTROLLINGAREA == CSLA.KOKRS
  • A_GLACCOUNTLINEITEM.MANDT == CSLA.MANDT
  • A_GLACCOUNTLINEITEM.[column in domain "DATBI"] == CSLA.DATBI
  • A_GLACCOUNTLINEITEM.PARTNERCOSTCTRACTIVITYTYPE == CSLA.LSTAR
Partner Cost Object
  • Client
  • ?
  • Partner Cost Object
  • A_GLACCOUNTLINEITEM.MANDT == CKPH.MANDT
  • A_GLACCOUNTLINEITEM.[column in domain "DATBI"] == CKPH.DATBI
  • A_GLACCOUNTLINEITEM.PARTNERCOSTOBJECT == CKPH.KSTRG
Partner Functional Area
  • Client
  • Partner Functional Area
  • A_GLACCOUNTLINEITEM.MANDT == TFKB.MANDT
  • A_GLACCOUNTLINEITEM.PARTNERFUNCTIONALAREA == TFKB.FKBER
Partner Order
  • Client
  • Partner Order
  • A_GLACCOUNTLINEITEM.MANDT == AUFK.MANDT
  • A_GLACCOUNTLINEITEM.PARTNERORDER == AUFK.AUFNR
Partner Profit Center
  • Controlling Area
  • Client
  • ?
  • Partner Profit Center
  • A_GLACCOUNTLINEITEM.CONTROLLINGAREA == CEPC.KOKRS
  • A_GLACCOUNTLINEITEM.MANDT == CEPC.MANDT
  • A_GLACCOUNTLINEITEM.[column in domain "DATBI"] == CEPC.DATBI
  • A_GLACCOUNTLINEITEM.PARTNERPROFITCENTER == CEPC.PRCTR
Partner Project Internal ID
  • Client
  • Partner Project Internal ID
  • A_GLACCOUNTLINEITEM.MANDT == PROJ.MANDT
  • A_GLACCOUNTLINEITEM.PARTNERPROJECTINTERNALID == PROJ.PSPNR
Partner Project Network
  • Partner Project Network
  • Client
  • A_GLACCOUNTLINEITEM.PARTNERPROJECTNETWORK == AUFK.AUFNR
  • A_GLACCOUNTLINEITEM.MANDT == AUFK.MANDT
Partner Segment for Segmental Reporting
  • Client
  • Partner Segment for Segmental Reporting
  • A_GLACCOUNTLINEITEM.MANDT == FAGL_SEGM.MANDT
  • A_GLACCOUNTLINEITEM.PARTNERSEGMENT == FAGL_SEGM.SEGMENT
Partner Service Document
  • Partner Service Document Item
  • Client
  • Partner Service Document Type
  • Partner Service Document
  • A_GLACCOUNTLINEITEM.PARTNERSERVICEDOCUMENTITEM == FCO_SRVDOC.SERVICE_DOC_ITEM_ID
  • A_GLACCOUNTLINEITEM.MANDT == FCO_SRVDOC.MANDT
  • A_GLACCOUNTLINEITEM.PARTNERSERVICEDOCUMENTTYPE == FCO_SRVDOC.SERVICE_DOC_TYPE
  • A_GLACCOUNTLINEITEM.PARTNERSERVICEDOCUMENT == FCO_SRVDOC.SERVICE_DOC_ID
Partner Service Document Type
  • Client
  • Partner Service Document Type
Plant
  • Client
  • Plant
  • A_GLACCOUNTLINEITEM.MANDT == T001W.MANDT
  • A_GLACCOUNTLINEITEM.PLANT == T001W.WERKS
Posting Key
  • Client
  • Posting Key
  • A_GLACCOUNTLINEITEM.MANDT == TBSL.MANDT
  • A_GLACCOUNTLINEITEM.POSTINGKEY == TBSL.BSCHL
Preceding Journal Entry Company Code
  • Client
  • Preceding Journal Entry Company Code
  • A_GLACCOUNTLINEITEM.MANDT == T001.MANDT
  • A_GLACCOUNTLINEITEM.PRDCSSRJOURNALENTRYCOMPANYCODE == T001.BUKRS
Predecessor Reference Document Type A_GLACCOUNTLINEITEM.PREDECESSORREFERENCEDOCTYPE == TTYP.AWTYP
Product Number
  • Client
  • Product Number
  • A_GLACCOUNTLINEITEM.MANDT == MARA.MANDT
  • A_GLACCOUNTLINEITEM.PRODUCT == MARA.MATNR
Profit Center
  • Controlling Area
  • Client
  • Profit Center
  • ?
  • A_GLACCOUNTLINEITEM.CONTROLLINGAREA == CEPC.KOKRS
  • A_GLACCOUNTLINEITEM.MANDT == CEPC.MANDT
  • A_GLACCOUNTLINEITEM.PROFITCENTER == CEPC.PRCTR
  • A_GLACCOUNTLINEITEM.[column in domain "DATBI"] == CEPC.DATBI
Project Internal ID
  • Client
  • Project Internal ID
  • A_GLACCOUNTLINEITEM.MANDT == PROJ.MANDT
  • A_GLACCOUNTLINEITEM.PROJECTINTERNALID == PROJ.PSPNR
Network Number for Account Assignment
  • Network Number for Account Assignment
  • Client
  • A_GLACCOUNTLINEITEM.PROJECTNETWORK == AUFK.AUFNR
  • A_GLACCOUNTLINEITEM.MANDT == AUFK.MANDT
Reference Document Type A_GLACCOUNTLINEITEM.REFERENCEDOCUMENTTYPE == TTYP.AWTYP
Sales District
  • Client
  • Sales District
  • A_GLACCOUNTLINEITEM.MANDT == T171.MANDT
  • A_GLACCOUNTLINEITEM.SALESDISTRICT == T171.BZIRK
Sales Organization
  • Client
  • Sales Organization
  • A_GLACCOUNTLINEITEM.MANDT == TVKO.MANDT
  • A_GLACCOUNTLINEITEM.SALESORGANIZATION == TVKO.VKORG
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • A_GLACCOUNTLINEITEM.MANDT == FAGL_SEGM.MANDT
  • A_GLACCOUNTLINEITEM.SEGMENT == FAGL_SEGM.SEGMENT
Service Contract ID
  • Client
  • Service Contract Type
  • Service Contract ID
  • Service Contract Item ID
  • A_GLACCOUNTLINEITEM.MANDT == FCO_SRVDOC.MANDT
  • A_GLACCOUNTLINEITEM.SERVICECONTRACTTYPE == FCO_SRVDOC.SERVICE_DOC_TYPE
  • A_GLACCOUNTLINEITEM.SERVICECONTRACT == FCO_SRVDOC.SERVICE_DOC_ID
  • A_GLACCOUNTLINEITEM.SERVICECONTRACTITEM == FCO_SRVDOC.SERVICE_DOC_ITEM_ID
Service Contract Item ID
  • Client
  • Service Contract Type
  • Service Contract ID
  • Service Contract Item ID
  • A_GLACCOUNTLINEITEM.MANDT == FCO_SRVDOC.MANDT
  • A_GLACCOUNTLINEITEM.SERVICECONTRACTTYPE == FCO_SRVDOC.SERVICE_DOC_TYPE
  • A_GLACCOUNTLINEITEM.SERVICECONTRACT == FCO_SRVDOC.SERVICE_DOC_ID
  • A_GLACCOUNTLINEITEM.SERVICECONTRACTITEM == FCO_SRVDOC.SERVICE_DOC_ITEM_ID
Service Contract Type
  • Client
  • Service Contract Type
Service Document ID
  • Client
  • Service Document Type
  • Service Document ID
  • Service Document Item ID
  • A_GLACCOUNTLINEITEM.MANDT == FCO_SRVDOC.MANDT
  • A_GLACCOUNTLINEITEM.SERVICEDOCUMENTTYPE == FCO_SRVDOC.SERVICE_DOC_TYPE
  • A_GLACCOUNTLINEITEM.SERVICEDOCUMENT == FCO_SRVDOC.SERVICE_DOC_ID
  • A_GLACCOUNTLINEITEM.SERVICEDOCUMENTITEM == FCO_SRVDOC.SERVICE_DOC_ITEM_ID
Service Document Item ID
  • Client
  • Service Document Type
  • Service Document ID
  • Service Document Item ID
  • A_GLACCOUNTLINEITEM.MANDT == FCO_SRVDOC.MANDT
  • A_GLACCOUNTLINEITEM.SERVICEDOCUMENTTYPE == FCO_SRVDOC.SERVICE_DOC_TYPE
  • A_GLACCOUNTLINEITEM.SERVICEDOCUMENT == FCO_SRVDOC.SERVICE_DOC_ID
  • A_GLACCOUNTLINEITEM.SERVICEDOCUMENTITEM == FCO_SRVDOC.SERVICE_DOC_ITEM_ID
Service Document Type
  • Client
  • Service Document Type
Ship-to Party
  • Client
  • Ship-to Party
  • A_GLACCOUNTLINEITEM.MANDT == KNA1.MANDT
  • A_GLACCOUNTLINEITEM.SHIPTOPARTY == KNA1.KUNNR
Product Sold
  • Client
  • Product Sold
  • A_GLACCOUNTLINEITEM.MANDT == MARA.MANDT
  • A_GLACCOUNTLINEITEM.SOLDPRODUCT == MARA.MATNR
Product Sold Group
  • Product Sold Group
  • Client
  • A_GLACCOUNTLINEITEM.SOLDPRODUCTGROUP == T023.MATKL
  • A_GLACCOUNTLINEITEM.MANDT == T023.MANDT
Source Ledger
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger
Source Logical System A_GLACCOUNTLINEITEM.SOURCELOGICALSYSTEM == TBDLS.LOGSYS
Source Reference Document Type A_GLACCOUNTLINEITEM.SOURCEREFERENCEDOCUMENTTYPE == TTYP.AWTYP
Special G/L Indicator
  • Client
  • Special G/L Indicator
  • Account Type
  • A_GLACCOUNTLINEITEM.MANDT == T074U.MANDT
  • A_GLACCOUNTLINEITEM.SPECIALGLCODE == T074U.UMSKZ
  • A_GLACCOUNTLINEITEM.FINANCIALACCOUNTTYPE == T074U.KOART
Subledger-Specific Line Item Type A_GLACCOUNTLINEITEM.SUBLEDGERACCTLINEITEMTYPE == FINSTS_SLALITTY.SLALITTYPE
Supplier
  • Client
  • Supplier
  • A_GLACCOUNTLINEITEM.MANDT == LFA1.MANDT
  • A_GLACCOUNTLINEITEM.SUPPLIER == LFA1.LIFNR
Tax on Sales/Purchases Code
  • Tax on Sales/Purchases Code
  • Client
  • ?
  • A_GLACCOUNTLINEITEM.TAXCODE == T007A.MWSKZ
  • A_GLACCOUNTLINEITEM.MANDT == T007A.MANDT
  • A_GLACCOUNTLINEITEM.[column in domain "KALSM_D"] == T007A.KALSM
Transaction Currency
  • Client
  • Transaction Currency
  • A_GLACCOUNTLINEITEM.MANDT == TCURC.MANDT
  • A_GLACCOUNTLINEITEM.TRANSACTIONCURRENCY == TCURC.WAERS
Valuation area
  • Valuation area
  • Client
  • A_GLACCOUNTLINEITEM.VALUATIONAREA == T001K.BWKEY
  • A_GLACCOUNTLINEITEM.MANDT == T001K.MANDT