C_GLLineItemComprnQuery

Journal Entry Comparison | view: CFIGLITMCMPQ | Extraction: Not supported | Component: Fiori UI for General Ledger Accounting
Tables used: SCAL_TT_DATE, ACDOCA, T004, SKA1, FINSC_LEDGER_REP, FINSC_FISC_DATE
Column Name Description
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
DebitAmountInCoCodeCrcy Debit Amount in Company Code Currency
CreditAmountInCoCodeCrcy Credit Amount in Company Code Currency
ComprnAmountInCoCodeCrcy Comparison Amount in Company Code Currency
ComprnDebitAmtInCoCodeCrcy Comparison Debit Amount in Company Code Currency
ComprnCreditAmtInCoCodeCrcy Comparison Credit Amount in Company Code Currency
DifferenceAmtInCoCodeCrcy Difference Amount In Company Code Currency
💲 Global Currency (GlobalCurrency):
AmountInGlobalCurrency Amount in Global Currency
DebitAmountInGlobalCrcy Debit Amount in Global Currency
CreditAmountInGlobalCrcy Credit Amount in Global Currency
ComprnAmountInGlobalCrcy Comparison Amount in Global Currency
ComprnDebitAmtInGlobalCrcy Comparison Debit Amount in Global Currency
ComprnCreditAmtInGlobalCrcy Comparison Credit Amount in Global Currency
DifferenceAmtInGlobalCrcy Difference Amount In Global Currency
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
DebitAmountInTransCrcy Debit Amount in Transaction Currency
CreditAmountInTransCrcy Credit Amount in Transaction Currency
ComprnAmountInTransCrcy Comparison Amount in Transaction Currency
ComprnDebitAmtInTransCrcy Comparison Debit Amount in Transaction Currency
ComprnCreditAmtInTransCrcy Comparison Credit Amount in Transaction Currency
💲 Balance Transaction Currency (BalanceTransactionCurrency):
AmountInBalanceTransacCrcy Amount in Balance Transaction Currency
DebitAmountInBalanceTransCrcy Debit Amount in Balance Transaction Currency
CreditAmountInBalanceTransCrcy Credit Amount in Balance Transaction Currency
ComprnAmountInBalTransCrcy Comparison Amount in Balance Transaction Currency
ComprnDebitAmtInBalTransCrcy Compariosn Debit Amount in Balance Transaction Currency
ComprnCreditAmtInBalTransCrcy Compariosn Credit Amount in Balance Transaction Currency
💲 Freely Defined Currency 1 (FreeDefinedCurrency1):
AmountInFreeDefinedCurrency1 Amount in Freely Defined Currency 1
DebitAmountInFreeDfndCrcy1 Debit Amount in Free Defined Currency 1
CreditAmountInFreeDfndCrcy1 Credit Amount in Free Defined Currency 1
ComprnAmountInFreeDfndCrcy1 Comparison Amount in Free Defined Currency 1
ComprnDebitAmtInFreeDfndCrcy1 Comparison Debit Amount in Free Defined Currency 1
ComprnCreditAmtInFreeDfndCrcy1 Comparison Credit Amount in Free Defined Currency 1
DifferenceAmtInFreeDfndCrcy1 Difference Amount In Freely Defined Currency 1
DifferenceAmtInFreeDfndCrcy2 Difference Amount In Freely Defined Currency 1
DifferenceAmtInFreeDfndCrcy3 Difference Amount In Freely Defined Currency 1
DifferenceAmtInFreeDfndCrcy4 Difference Amount In Freely Defined Currency 1
DifferenceAmtInFreeDfndCrcy5 Difference Amount In Freely Defined Currency 1
DifferenceAmtInFreeDfndCrcy6 Difference Amount In Freely Defined Currency 1
DifferenceAmtInFreeDfndCrcy7 Difference Amount In Freely Defined Currency 1
DifferenceAmtInFreeDfndCrcy8 Difference Amount In Freely Defined Currency 1
💲 Freely Defined Currency 2 (FreeDefinedCurrency2):
AmountInFreeDefinedCurrency2 Amount in Freely Defined Currency 2
DebitAmountInFreeDfndCrcy2 Debit Amount in Free Defined Currency 2
CreditAmountInFreeDfndCrcy2 Credit Amount in Free Defined Currency 2
ComprnAmountInFreeDfndCrcy2 Comparison Amount in Free Defined Currency 2
ComprnDebitAmtInFreeDfndCrcy2 Comparison Debit Amount in Free Defined Currency 2
ComprnCreditAmtInFreeDfndCrcy2 Comparison Credit Amount in Free Defined Currency 2
💲 Freely Defined Currency 3 (FreeDefinedCurrency3):
AmountInFreeDefinedCurrency3 Amount in Freely Defined Currency 3
DebitAmountInFreeDfndCrcy3 Debit Amount in Free Defined Currency 3
CreditAmountInFreeDfndCrcy3 Credit Amount in Free Defined Currency 3
ComprnAmountInFreeDfndCrcy3 Comparison Amount in Free Defined Currency 3
ComprnDebitAmtInFreeDfndCrcy3 Comparison Debit Amount in Free Defined Currency 3
ComprnCreditAmtInFreeDfndCrcy3 Comparison Credit Amount in Free Defined Currency 3
💲 Freely Defined Currency 4 (FreeDefinedCurrency4):
AmountInFreeDefinedCurrency4 Amount in Freely Defined Currency 4
DebitAmountInFreeDfndCrcy4 Debit Amount in Free Defined Currency 4
CreditAmountInFreeDfndCrcy4 Credit Amount in Free Defined Currency 4
ComprnAmountInFreeDfndCrcy4 Comparison Amount in Free Defined Currency 4
ComprnDebitAmtInFreeDfndCrcy4 Comparison Debit Amount in Free Defined Currency 4
ComprnCreditAmtInFreeDfndCrcy4 Comparison Credit Amount in Free Defined Currency 4
💲 Freely Defined Currency 5 (FreeDefinedCurrency5):
AmountInFreeDefinedCurrency5 Amount in Freely Defined Currency 5
DebitAmountInFreeDfndCrcy5 Debit Amount in Free Defined Currency 5
CreditAmountInFreeDfndCrcy5 Credit Amount in Free Defined Currency 5
ComprnAmountInFreeDfndCrcy5 Comparison Amount in Free Defined Currency 5
ComprnDebitAmtInFreeDfndCrcy5 Comparison Debit Amount in Free Defined Currency 5
ComprnCreditAmtInFreeDfndCrcy5 Comparison Credit Amount in Free Defined Currency 5
💲 Freely Defined Currency 6 (FreeDefinedCurrency6):
AmountInFreeDefinedCurrency6 Amount in Freely Defined Currency 6
DebitAmountInFreeDfndCrcy6 Debit Amount in Free Defined Currency 6
CreditAmountInFreeDfndCrcy6 Credit Amount in Free Defined Currency 6
ComprnAmountInFreeDfndCrcy6 Comparison Amount in Free Defined Currency 6
ComprnDebitAmtInFreeDfndCrcy6 Comparison Debit Amount in Free Defined Currency 6
ComprnCreditAmtInFreeDfndCrcy6 Comparison Credit Amount in Free Defined Currency 6
💲 Freely Defined Currency 7 (FreeDefinedCurrency7):
AmountInFreeDefinedCurrency7 Amount in Freely Defined Currency 7
DebitAmountInFreeDfndCrcy7 Debit Amount in Free Defined Currency 7
CreditAmountInFreeDfndCrcy7 Credit Amount in Free Defined Currency 7
ComprnAmountInFreeDfndCrcy7 Comparison Amount in Free Defined Currency 7
ComprnDebitAmtInFreeDfndCrcy7 Comparison Debit Amount in Free Defined Currency 7
ComprnCreditAmtInFreeDfndCrcy7 Comparison Credit Amount in Free Defined Currency 7
💲 Freely Defined Currency 8 (FreeDefinedCurrency8):
AmountInFreeDefinedCurrency8 Amount in Freely Defined Currency 8
DebitAmountInFreeDfndCrcy8 Debit Amount in Free Defined Currency 8
CreditAmountInFreeDfndCrcy8 Credit Amount in Free Defined Currency 8
ComprnAmountInFreeDfndCrcy8 Comparison Amount in Free Defined Currency 8
ComprnDebitAmtInFreeDfndCrcy8 Comparison Debit Amount in Free Defined Currency 8
ComprnCreditAmtInFreeDfndCrcy8 Comparison Credit Amount in Free Defined Currency 8
Column Name Description
Column Name Description
PostingDate Posting Date
DocumentDate Journal Entry Date
CreationDate Creation Date
ClearingDate Clearing Date
AssetValueDate Asset Value Date
SettlementReferenceDate Settlement Reference Date
Column Name Description
GLRecordType Record Type Show values
DebitCreditCode Debit/Credit Code Show values
ReferencePurchaseOrderCategory Category of Reference Purchase Order Show values
FinancialAccountType Account Type Show values
IsOpenItemManaged Managed on an Open Item Basis Show values
InventorySpecialStockValnType Inventory Special Stock Valuation Type Show values
OffsettingAccountType Offsetting Account Type Show values
LineItemIsCompleted Indicator: Line Item is Completed Show values
OrderCategory Order category Show values
AccountingDocumentCategory Journal Entry Category Show values
ControllingObjectDebitType Controlling Object Debit Type Show values
DepreciationFiscalPeriod Fiscal Period of Depreciation Show values
GLAccountType Type of a General Ledger Account Show values
IsReversal Indicator: Item is Reversing Another Item Show values
IsReversed Indicator: Item is Reversed Show values
IsSettled Indicator: Line Item is Settled or Transferred Show values
IsSettlement Indicator: Item is Settling or Transferring Another Item Show values
OriginObjectType Type of Origin Object Show values
PartnerOrderCategory Partner Order Category Show values
QuantityIsIncomplete Indicator: Quantity Is Incomplete Show values
Column Name Description Domain name
LedgerFiscalYear Ledger Fiscal Year GJAHR
FiscalPeriod Fiscal Period POPER
ReportingFiscalPeriod Reporting Fiscal Period POPER
AccountingDocument Journal Entry BELNR
CoCodeCrcyDifferencePct Difference Percentage in Company Code Currency FISD_PERCENT_2
GlobalCrcyDifferencePct Difference Percentage in Global Currency FISD_PERCENT_2
FreeDfndCrcy1DifferencePct Difference Percentage in Freely Defined Currency 1 FISD_PERCENT_2
FreeDfndCrcy2DifferencePct Difference Percentage in Freely Defined Currency 1 FISD_PERCENT_2
FreeDfndCrcy3DifferencePct Difference Percentage in Freely Defined Currency 1 FISD_PERCENT_2
FreeDfndCrcy4DifferencePct Difference Percentage in Freely Defined Currency 1 FISD_PERCENT_2
FreeDfndCrcy5DifferencePct Difference Percentage in Freely Defined Currency 1 FISD_PERCENT_2
FreeDfndCrcy6DifferencePct Difference Percentage in Freely Defined Currency 1 FISD_PERCENT_2
FreeDfndCrcy7DifferencePct Difference Percentage in Freely Defined Currency 1 FISD_PERCENT_2
FreeDfndCrcy8DifferencePct Difference Percentage in Freely Defined Currency 1 FISD_PERCENT_2
OffsettingChartOfAccounts Offsetting Chart of Accounts KTOPL
OffsettingAccount Offsetting Account GKONT
AssignmentReference Assignment Reference ZUONR
AccountingDocumentItem Journal Entry Posting View Item BUZEI
LedgerGLLineItem Ledger Journal Entry Item DOCLN6
TransactionTypeDetermination Transaction Key CHAR3
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
ClearingAccountingDocument Clearing Journal Entry BELNR
ClearingDocFiscalYear Fiscal Year of Clearing Journal Entry GJAHR
InventorySpecialStockType Inventory Special Stock Type SOBKZ
PersonnelNumber Personnel Number PERNR
WBSElementInternalID WBS Element Internal ID FIS_WBSINT_NO_CONV
AccountAssignment Account Assignment ACCAS
CostEstimate Cost Estimate CK_KALNR
GrantID Grant GM_GRANT_NBR
InventorySpclStkSalesDocItm Inventory Special Stock Sales Document Item POSNR
InventorySpclStkSalesDocument Inventory Special Stock Sales Document VBELN
InvtrySpclStockWBSElmntIntID Inventory Special Stock WBS Element Internal ID FIS_WBSINT_NO_CONV
InventorySpecialStockSupplier Supplier of Inventory Special Stock LIFNR
PartnerAccountAssignment Partner Account Assignment ACCAS
PartnerGrant Partner Grant GM_GRANT_NBR
PredecessorReferenceDocCntxt Predecessor Reference Document Context AWORG
PredecessorReferenceDocItem Predecessor Reference Document Item NUMC6
PredecessorReferenceDocument Predecessor Reference Document AWREF
ReferenceDocument Reference document number AWREF
ReferenceDocumentContext Reference Document Context AWORG
ReferenceDocumentItem Reference Document Item NUMC6
ReferenceDocumentItemGroup Reference Document Item Group NUMC6
ReversalReferenceDocument Reversal Reference Document AWREF
ReversalReferenceDocumentCntxt Reversal Reference Document Context AWORG
FiscalYear Fiscal Year GJAHR
FiscalYearPeriod Fiscal Year Period FIS_JAHRPER_CONV
ReportingFiscalYearPeriod Reporting Fiscal Year Period
LastChangeDateTime Time Stamp of Last Change TZNTSTMPS
CreationDateTime Time Stamp of Creation TZNTSTMPS
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • C_GLLINEITEMCOMPRNQUERY.MANDT == T003.MANDT
  • C_GLLINEITEMCOMPRNQUERY.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Alternative G/L Account Number In Company Code
  • Alternative Chart of Accounts for Country/Region
  • Client
  • Alternative G/L Account Number In Company Code
  • C_GLLINEITEMCOMPRNQUERY.COUNTRYCHARTOFACCOUNTS == SKA1.KTOPL
  • C_GLLINEITEMCOMPRNQUERY.MANDT == SKA1.MANDT
  • C_GLLINEITEMCOMPRNQUERY.ALTERNATIVEGLACCOUNT == SKA1.SAKNR
Transaction Type Category C_GLLINEITEMCOMPRNQUERY.ASSETACCTTRANSCLASSFCTN == FAAI_MOVCAT.MOVCAT
Asset Transaction Type
  • Client
  • Asset Transaction Type
  • C_GLLINEITEMCOMPRNQUERY.MANDT == TABW.MANDT
  • C_GLLINEITEMCOMPRNQUERY.ASSETTRANSACTIONTYPE == TABW.BWASL
Balance Transaction Currency
  • Client
  • Balance Transaction Currency
  • C_GLLINEITEMCOMPRNQUERY.MANDT == TCURC.MANDT
  • C_GLLINEITEMCOMPRNQUERY.BALANCETRANSACTIONCURRENCY == TCURC.WAERS
Billing Type
  • Client
  • Billing Type
  • C_GLLINEITEMCOMPRNQUERY.MANDT == TVFK.MANDT
  • C_GLLINEITEMCOMPRNQUERY.BILLINGDOCUMENTTYPE == TVFK.FKART
Budget Period
  • Client
  • Fund
  • Financial Management Area
  • Budget Period
  • C_GLLINEITEMCOMPRNQUERY.MANDT == FMFUNDBPD.MANDT
  • C_GLLINEITEMCOMPRNQUERY.FUND == FMFUNDBPD.FINCODE
  • C_GLLINEITEMCOMPRNQUERY.FINANCIALMANAGEMENTAREA == FMFUNDBPD.FIKRS
  • C_GLLINEITEMCOMPRNQUERY.BUDGETPERIOD == FMFUNDBPD.BUDGET_PD
Business Area
  • Business Area
  • Client
  • C_GLLINEITEMCOMPRNQUERY.BUSINESSAREA == TGSB.GSBER
  • C_GLLINEITEMCOMPRNQUERY.MANDT == TGSB.MANDT
Business Process
  • Client
  • Controlling Area
  • Business Process
  • ?
  • C_GLLINEITEMCOMPRNQUERY.MANDT == CBPR.MANDT
  • C_GLLINEITEMCOMPRNQUERY.CONTROLLINGAREA == CBPR.KOKRS
  • C_GLLINEITEMCOMPRNQUERY.BUSINESSPROCESS == CBPR.PRZNR
  • C_GLLINEITEMCOMPRNQUERY.[column in domain "DATBI"] == CBPR.DATBI
Business Transaction Type
  • Client
  • Business Transaction Type
Chart of Accounts
  • Client
  • Chart of Accounts
  • C_GLLINEITEMCOMPRNQUERY.MANDT == T004.MANDT
  • C_GLLINEITEMCOMPRNQUERY.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Client
  • Company Code
  • C_GLLINEITEMCOMPRNQUERY.MANDT == T001.MANDT
  • C_GLLINEITEMCOMPRNQUERY.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Client
  • Company Code Currency
  • C_GLLINEITEMCOMPRNQUERY.MANDT == TCURC.MANDT
  • C_GLLINEITEMCOMPRNQUERY.COMPANYCODECURRENCY == TCURC.WAERS
Controlling Area
  • Client
  • Controlling Area
  • C_GLLINEITEMCOMPRNQUERY.MANDT == TKA01.MANDT
  • C_GLLINEITEMCOMPRNQUERY.CONTROLLINGAREA == TKA01.KOKRS
Group Account Number
  • Client
  • Group Chart of Accts
  • Group Account Number
  • C_GLLINEITEMCOMPRNQUERY.MANDT == SKA1.MANDT
  • C_GLLINEITEMCOMPRNQUERY.CORPORATEGROUPCHARTOFACCOUNTS == SKA1.KTOPL
  • C_GLLINEITEMCOMPRNQUERY.CORPORATEGROUPACCOUNT == SKA1.SAKNR
Group Chart of Accts
  • Client
  • Group Chart of Accts
  • C_GLLINEITEMCOMPRNQUERY.MANDT == T004.MANDT
  • C_GLLINEITEMCOMPRNQUERY.CORPORATEGROUPCHARTOFACCOUNTS == T004.KTOPL
Cost Center
  • Client
  • Controlling Area
  • ?
  • Cost Center
  • C_GLLINEITEMCOMPRNQUERY.MANDT == CSKS.MANDT
  • C_GLLINEITEMCOMPRNQUERY.CONTROLLINGAREA == CSKS.KOKRS
  • C_GLLINEITEMCOMPRNQUERY.[column in domain "DATBI"] == CSKS.DATBI
  • C_GLLINEITEMCOMPRNQUERY.COSTCENTER == CSKS.KOSTL
Activity Type
  • Client
  • Controlling Area
  • Activity Type
  • ?
  • C_GLLINEITEMCOMPRNQUERY.MANDT == CSLA.MANDT
  • C_GLLINEITEMCOMPRNQUERY.CONTROLLINGAREA == CSLA.KOKRS
  • C_GLLINEITEMCOMPRNQUERY.COSTCTRACTIVITYTYPE == CSLA.LSTAR
  • C_GLLINEITEMCOMPRNQUERY.[column in domain "DATBI"] == CSLA.DATBI
Cost Object
  • Client
  • Cost Object
  • ?
  • C_GLLINEITEMCOMPRNQUERY.MANDT == CKPH.MANDT
  • C_GLLINEITEMCOMPRNQUERY.COSTOBJECT == CKPH.KSTRG
  • C_GLLINEITEMCOMPRNQUERY.[column in domain "DATBI"] == CKPH.DATBI
Alternative Chart of Accounts for Country/Region
  • Alternative Chart of Accounts for Country/Region
  • Client
  • C_GLLINEITEMCOMPRNQUERY.COUNTRYCHARTOFACCOUNTS == T004.KTOPL
  • C_GLLINEITEMCOMPRNQUERY.MANDT == T004.MANDT
Customer Number
  • Client
  • Customer Number
  • C_GLLINEITEMCOMPRNQUERY.MANDT == KNA1.MANDT
  • C_GLLINEITEMCOMPRNQUERY.CUSTOMER == KNA1.KUNNR
Customer Group
  • Client
  • Customer Group
  • C_GLLINEITEMCOMPRNQUERY.MANDT == T151.MANDT
  • C_GLLINEITEMCOMPRNQUERY.CUSTOMERGROUP == T151.KDGRP
Distribution Channel
  • Client
  • Distribution Channel
  • C_GLLINEITEMCOMPRNQUERY.MANDT == TVTW.MANDT
  • C_GLLINEITEMCOMPRNQUERY.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Elimination Profit Center
  • Client
  • Controlling Area
  • Elimination Profit Center
  • ?
  • C_GLLINEITEMCOMPRNQUERY.MANDT == CEPC.MANDT
  • C_GLLINEITEMCOMPRNQUERY.CONTROLLINGAREA == CEPC.KOKRS
  • C_GLLINEITEMCOMPRNQUERY.ELIMINATIONPROFITCENTER == CEPC.PRCTR
  • C_GLLINEITEMCOMPRNQUERY.[column in domain "DATBI"] == CEPC.DATBI
Financial Management Area
  • Client
  • Financial Management Area
  • C_GLLINEITEMCOMPRNQUERY.MANDT == FM01.MANDT
  • C_GLLINEITEMCOMPRNQUERY.FINANCIALMANAGEMENTAREA == FM01.FIKRS
Financial Transaction Type
  • Client
  • Financial Transaction Type
  • C_GLLINEITEMCOMPRNQUERY.MANDT == T856.MANDT
  • C_GLLINEITEMCOMPRNQUERY.FINANCIALTRANSACTIONTYPE == T856.TRTYP
Fiscal Year Variant
  • Client
  • Fiscal Year Variant
  • C_GLLINEITEMCOMPRNQUERY.MANDT == T009.MANDT
  • C_GLLINEITEMCOMPRNQUERY.FISCALYEARVARIANT == T009.PERIV
Asset Subnumber
  • Client
  • Asset Subnumber
  • Fixed Asset
  • ?
  • C_GLLINEITEMCOMPRNQUERY.MANDT == ANLA.MANDT
  • C_GLLINEITEMCOMPRNQUERY.FIXEDASSET == ANLA.ANLN2
  • C_GLLINEITEMCOMPRNQUERY.MASTERFIXEDASSET == ANLA.ANLN1
  • C_GLLINEITEMCOMPRNQUERY.[column in domain "BUKRS"] == ANLA.BUKRS
Freely Defined Currency 1
  • Client
  • Freely Defined Currency 1
  • C_GLLINEITEMCOMPRNQUERY.MANDT == TCURC.MANDT
  • C_GLLINEITEMCOMPRNQUERY.FREEDEFINEDCURRENCY1 == TCURC.WAERS
Freely Defined Currency 2
  • Client
  • Freely Defined Currency 2
  • C_GLLINEITEMCOMPRNQUERY.MANDT == TCURC.MANDT
  • C_GLLINEITEMCOMPRNQUERY.FREEDEFINEDCURRENCY2 == TCURC.WAERS
Freely Defined Currency 3
  • Freely Defined Currency 3
  • Client
  • C_GLLINEITEMCOMPRNQUERY.FREEDEFINEDCURRENCY3 == TCURC.WAERS
  • C_GLLINEITEMCOMPRNQUERY.MANDT == TCURC.MANDT
Freely Defined Currency 4
  • Freely Defined Currency 4
  • Client
  • C_GLLINEITEMCOMPRNQUERY.FREEDEFINEDCURRENCY4 == TCURC.WAERS
  • C_GLLINEITEMCOMPRNQUERY.MANDT == TCURC.MANDT
Freely Defined Currency 5
  • Client
  • Freely Defined Currency 5
  • C_GLLINEITEMCOMPRNQUERY.MANDT == TCURC.MANDT
  • C_GLLINEITEMCOMPRNQUERY.FREEDEFINEDCURRENCY5 == TCURC.WAERS
Freely Defined Currency 6
  • Client
  • Freely Defined Currency 6
  • C_GLLINEITEMCOMPRNQUERY.MANDT == TCURC.MANDT
  • C_GLLINEITEMCOMPRNQUERY.FREEDEFINEDCURRENCY6 == TCURC.WAERS
Freely Defined Currency 7
  • Client
  • Freely Defined Currency 7
  • C_GLLINEITEMCOMPRNQUERY.MANDT == TCURC.MANDT
  • C_GLLINEITEMCOMPRNQUERY.FREEDEFINEDCURRENCY7 == TCURC.WAERS
Freely Defined Currency 8
  • Client
  • Freely Defined Currency 8
  • C_GLLINEITEMCOMPRNQUERY.MANDT == TCURC.MANDT
  • C_GLLINEITEMCOMPRNQUERY.FREEDEFINEDCURRENCY8 == TCURC.WAERS
Functional Area
  • Client
  • Functional Area
  • C_GLLINEITEMCOMPRNQUERY.MANDT == TFKB.MANDT
  • C_GLLINEITEMCOMPRNQUERY.FUNCTIONALAREA == TFKB.FKBER
Fund
  • Client
  • Fund
  • Financial Management Area
  • C_GLLINEITEMCOMPRNQUERY.MANDT == FMFINCODE.MANDT
  • C_GLLINEITEMCOMPRNQUERY.FUND == FMFINCODE.FINCODE
  • C_GLLINEITEMCOMPRNQUERY.FINANCIALMANAGEMENTAREA == FMFINCODE.FIKRS
G/L Account
  • Client
  • G/L Account
  • Company Code
  • C_GLLINEITEMCOMPRNQUERY.MANDT == SKB1.MANDT
  • C_GLLINEITEMCOMPRNQUERY.GLACCOUNT == SKB1.SAKNR
  • C_GLLINEITEMCOMPRNQUERY.COMPANYCODE == SKB1.BUKRS
Global Currency
  • Client
  • Global Currency
  • C_GLLINEITEMCOMPRNQUERY.MANDT == TCURC.MANDT
  • C_GLLINEITEMCOMPRNQUERY.GLOBALCURRENCY == TCURC.WAERS
Group Asset Subnumber
  • Client
  • Group Asset
  • Group Asset Subnumber
  • ?
  • C_GLLINEITEMCOMPRNQUERY.MANDT == ANLA.MANDT
  • C_GLLINEITEMCOMPRNQUERY.GROUPMASTERFIXEDASSET == ANLA.ANLN1
  • C_GLLINEITEMCOMPRNQUERY.GROUPFIXEDASSET == ANLA.ANLN2
  • C_GLLINEITEMCOMPRNQUERY.[column in domain "BUKRS"] == ANLA.BUKRS
House Bank Key
  • Client
  • House Bank Key
  • ?
  • C_GLLINEITEMCOMPRNQUERY.MANDT == T012.MANDT
  • C_GLLINEITEMCOMPRNQUERY.HOUSEBANK == T012.HBKID
  • C_GLLINEITEMCOMPRNQUERY.[column in domain "BUKRS"] == T012.BUKRS
House Bank Account
  • Client
  • House Bank Key
  • House Bank Account
  • ?
  • C_GLLINEITEMCOMPRNQUERY.MANDT == T012K.MANDT
  • C_GLLINEITEMCOMPRNQUERY.HOUSEBANK == T012K.HBKID
  • C_GLLINEITEMCOMPRNQUERY.HOUSEBANKACCOUNT == T012K.HKTID
  • C_GLLINEITEMCOMPRNQUERY.[column in domain "BUKRS"] == T012K.BUKRS
Inventory Valuation Type
  • Inventory Valuation Type
  • Client
  • C_GLLINEITEMCOMPRNQUERY.INVENTORYVALUATIONTYPE == T149D.BWTAR
  • C_GLLINEITEMCOMPRNQUERY.MANDT == T149D.MANDT
Joint venture
  • Client
  • Joint venture
  • ?
  • C_GLLINEITEMCOMPRNQUERY.MANDT == T8JV.MANDT
  • C_GLLINEITEMCOMPRNQUERY.JOINTVENTURE == T8JV.VNAME
  • C_GLLINEITEMCOMPRNQUERY.[column in domain "BUKRS"] == T8JV.BUKRS
Joint Venture Cost Recovery Code
  • Client
  • Joint Venture Cost Recovery Code
  • ?
  • C_GLLINEITEMCOMPRNQUERY.MANDT == T8JJ.MANDT
  • C_GLLINEITEMCOMPRNQUERY.JOINTVENTURECOSTRECOVERYCODE == T8JJ.RECID
  • C_GLLINEITEMCOMPRNQUERY.[column in domain "BUKRS"] == T8JJ.BUKRS
Joint Venture Equity Group
  • Client
  • Joint venture
  • ?
  • Joint Venture Equity Group
  • C_GLLINEITEMCOMPRNQUERY.MANDT == T8JF.MANDT
  • C_GLLINEITEMCOMPRNQUERY.JOINTVENTURE == T8JF.VNAME
  • C_GLLINEITEMCOMPRNQUERY.[column in domain "BUKRS"] == T8JF.BUKRS
  • C_GLLINEITEMCOMPRNQUERY.JOINTVENTUREEQUITYGROUP == T8JF.EGRUP
Joint Venture Equity Type
  • Joint Venture Equity Type
  • Client
  • ?
  • C_GLLINEITEMCOMPRNQUERY.JOINTVENTUREEQUITYTYPE == T8JE.ETYPE
  • C_GLLINEITEMCOMPRNQUERY.MANDT == T8JE.MANDT
  • C_GLLINEITEMCOMPRNQUERY.[column in domain "BUKRS"] == T8JE.BUKRS
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
Logical System C_GLLINEITEMCOMPRNQUERY.LOGICALSYSTEM == TBDLS.LOGSYS
Operating concern
  • Operating concern
  • Client
  • C_GLLINEITEMCOMPRNQUERY.OPERATINGCONCERN == TKEB.ERKRS
  • C_GLLINEITEMCOMPRNQUERY.MANDT == TKEB.MANDT
Order ID
  • Client
  • Order ID
  • C_GLLINEITEMCOMPRNQUERY.MANDT == AUFK.MANDT
  • C_GLLINEITEMCOMPRNQUERY.ORDERID == AUFK.AUFNR
Division
  • Client
  • Division
  • C_GLLINEITEMCOMPRNQUERY.MANDT == TSPA.MANDT
  • C_GLLINEITEMCOMPRNQUERY.ORGANIZATIONDIVISION == TSPA.SPART
Origin Cost Center
  • Client
  • Origin Cost Center
  • Controlling Area
  • ?
  • C_GLLINEITEMCOMPRNQUERY.MANDT == CSKS.MANDT
  • C_GLLINEITEMCOMPRNQUERY.ORIGINCOSTCENTER == CSKS.KOSTL
  • C_GLLINEITEMCOMPRNQUERY.CONTROLLINGAREA == CSKS.KOKRS
  • C_GLLINEITEMCOMPRNQUERY.[column in domain "DATBI"] == CSKS.DATBI
Origin Cost Center Activity Type
  • Client
  • Controlling Area
  • ?
  • Origin Cost Center Activity Type
  • C_GLLINEITEMCOMPRNQUERY.MANDT == CSLA.MANDT
  • C_GLLINEITEMCOMPRNQUERY.CONTROLLINGAREA == CSLA.KOKRS
  • C_GLLINEITEMCOMPRNQUERY.[column in domain "DATBI"] == CSLA.DATBI
  • C_GLLINEITEMCOMPRNQUERY.ORIGINCOSTCTRACTIVITYTYPE == CSLA.LSTAR
FM: Partner Budget Period
  • Client
  • Partner Fund
  • FM: Partner Budget Period
  • Financial Management Area
  • C_GLLINEITEMCOMPRNQUERY.MANDT == FMFUNDBPD.MANDT
  • C_GLLINEITEMCOMPRNQUERY.PARTNERFUND == FMFUNDBPD.FINCODE
  • C_GLLINEITEMCOMPRNQUERY.PARTNERBUDGETPERIOD == FMFUNDBPD.BUDGET_PD
  • C_GLLINEITEMCOMPRNQUERY.FINANCIALMANAGEMENTAREA == FMFUNDBPD.FIKRS
Partner Business Area
  • Client
  • Partner Business Area
  • C_GLLINEITEMCOMPRNQUERY.MANDT == TGSB.MANDT
  • C_GLLINEITEMCOMPRNQUERY.PARTNERBUSINESSAREA == TGSB.GSBER
Partner Business Process
  • Client
  • Controlling Area
  • Partner Business Process
  • ?
  • C_GLLINEITEMCOMPRNQUERY.MANDT == CBPR.MANDT
  • C_GLLINEITEMCOMPRNQUERY.CONTROLLINGAREA == CBPR.KOKRS
  • C_GLLINEITEMCOMPRNQUERY.PARTNERBUSINESSPROCESS == CBPR.PRZNR
  • C_GLLINEITEMCOMPRNQUERY.[column in domain "DATBI"] == CBPR.DATBI
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • C_GLLINEITEMCOMPRNQUERY.MANDT == T880.MANDT
  • C_GLLINEITEMCOMPRNQUERY.PARTNERCOMPANY == T880.RCOMP
Partner Company Code
  • Client
  • Partner Company Code
  • C_GLLINEITEMCOMPRNQUERY.MANDT == T001.MANDT
  • C_GLLINEITEMCOMPRNQUERY.PARTNERCOMPANYCODE == T001.BUKRS
Partner Cost Center
  • Client
  • Controlling Area
  • Partner Cost Center
  • ?
  • C_GLLINEITEMCOMPRNQUERY.MANDT == CSKS.MANDT
  • C_GLLINEITEMCOMPRNQUERY.CONTROLLINGAREA == CSKS.KOKRS
  • C_GLLINEITEMCOMPRNQUERY.PARTNERCOSTCENTER == CSKS.KOSTL
  • C_GLLINEITEMCOMPRNQUERY.[column in domain "DATBI"] == CSKS.DATBI
Partner Cost Center Activity Type
  • Client
  • Controlling Area
  • Partner Cost Center Activity Type
  • ?
  • C_GLLINEITEMCOMPRNQUERY.MANDT == CSLA.MANDT
  • C_GLLINEITEMCOMPRNQUERY.CONTROLLINGAREA == CSLA.KOKRS
  • C_GLLINEITEMCOMPRNQUERY.PARTNERCOSTCTRACTIVITYTYPE == CSLA.LSTAR
  • C_GLLINEITEMCOMPRNQUERY.[column in domain "DATBI"] == CSLA.DATBI
Partner Cost Object
  • Client
  • Partner Cost Object
  • ?
  • C_GLLINEITEMCOMPRNQUERY.MANDT == CKPH.MANDT
  • C_GLLINEITEMCOMPRNQUERY.PARTNERCOSTOBJECT == CKPH.KSTRG
  • C_GLLINEITEMCOMPRNQUERY.[column in domain "DATBI"] == CKPH.DATBI
Partner Functional Area
  • Client
  • Partner Functional Area
  • C_GLLINEITEMCOMPRNQUERY.MANDT == TFKB.MANDT
  • C_GLLINEITEMCOMPRNQUERY.PARTNERFUNCTIONALAREA == TFKB.FKBER
Partner Fund
  • Client
  • Partner Fund
  • Financial Management Area
  • C_GLLINEITEMCOMPRNQUERY.MANDT == FMFINCODE.MANDT
  • C_GLLINEITEMCOMPRNQUERY.PARTNERFUND == FMFINCODE.FINCODE
  • C_GLLINEITEMCOMPRNQUERY.FINANCIALMANAGEMENTAREA == FMFINCODE.FIKRS
Partner Order
  • Client
  • Partner Order
  • C_GLLINEITEMCOMPRNQUERY.MANDT == AUFK.MANDT
  • C_GLLINEITEMCOMPRNQUERY.PARTNERORDER == AUFK.AUFNR
Partner Profit Center
  • Client
  • Controlling Area
  • Partner Profit Center
  • ?
  • C_GLLINEITEMCOMPRNQUERY.MANDT == CEPC.MANDT
  • C_GLLINEITEMCOMPRNQUERY.CONTROLLINGAREA == CEPC.KOKRS
  • C_GLLINEITEMCOMPRNQUERY.PARTNERPROFITCENTER == CEPC.PRCTR
  • C_GLLINEITEMCOMPRNQUERY.[column in domain "DATBI"] == CEPC.DATBI
Partner Segment for Segmental Reporting
  • Partner Segment for Segmental Reporting
  • Client
  • C_GLLINEITEMCOMPRNQUERY.PARTNERSEGMENT == FAGL_SEGM.SEGMENT
  • C_GLLINEITEMCOMPRNQUERY.MANDT == FAGL_SEGM.MANDT
Plant
  • Client
  • Plant
  • C_GLLINEITEMCOMPRNQUERY.MANDT == T001W.MANDT
  • C_GLLINEITEMCOMPRNQUERY.PLANT == T001W.WERKS
Posting Key
  • Posting Key
  • Client
  • C_GLLINEITEMCOMPRNQUERY.POSTINGKEY == TBSL.BSCHL
  • C_GLLINEITEMCOMPRNQUERY.MANDT == TBSL.MANDT
Predecessor Reference Document Type C_GLLINEITEMCOMPRNQUERY.PREDECESSORREFERENCEDOCTYPE == TTYP.AWTYP
Product Number
  • Client
  • Product Number
  • C_GLLINEITEMCOMPRNQUERY.MANDT == MARA.MANDT
  • C_GLLINEITEMCOMPRNQUERY.PRODUCT == MARA.MATNR
Profit Center
  • Client
  • Controlling Area
  • Profit Center
  • ?
  • C_GLLINEITEMCOMPRNQUERY.MANDT == CEPC.MANDT
  • C_GLLINEITEMCOMPRNQUERY.CONTROLLINGAREA == CEPC.KOKRS
  • C_GLLINEITEMCOMPRNQUERY.PROFITCENTER == CEPC.PRCTR
  • C_GLLINEITEMCOMPRNQUERY.[column in domain "DATBI"] == CEPC.DATBI
Network Number for Account Assignment
  • Client
  • Network Number for Account Assignment
  • C_GLLINEITEMCOMPRNQUERY.MANDT == AUFK.MANDT
  • C_GLLINEITEMCOMPRNQUERY.PROJECTNETWORK == AUFK.AUFNR
Reference Document Type C_GLLINEITEMCOMPRNQUERY.REFERENCEDOCUMENTTYPE == TTYP.AWTYP
Sales Organization
  • Client
  • Sales Organization
  • C_GLLINEITEMCOMPRNQUERY.MANDT == TVKO.MANDT
  • C_GLLINEITEMCOMPRNQUERY.SALESORGANIZATION == TVKO.VKORG
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • C_GLLINEITEMCOMPRNQUERY.MANDT == FAGL_SEGM.MANDT
  • C_GLLINEITEMCOMPRNQUERY.SEGMENT == FAGL_SEGM.SEGMENT
Product Sold
  • Client
  • Product Sold
  • C_GLLINEITEMCOMPRNQUERY.MANDT == MARA.MANDT
  • C_GLLINEITEMCOMPRNQUERY.SOLDPRODUCT == MARA.MATNR
Product Sold Group
  • Product Sold Group
  • Client
  • C_GLLINEITEMCOMPRNQUERY.SOLDPRODUCTGROUP == T023.MATKL
  • C_GLLINEITEMCOMPRNQUERY.MANDT == T023.MANDT
Special G/L Indicator
  • Client
  • Account Type
  • Special G/L Indicator
  • C_GLLINEITEMCOMPRNQUERY.MANDT == T074U.MANDT
  • C_GLLINEITEMCOMPRNQUERY.FINANCIALACCOUNTTYPE == T074U.KOART
  • C_GLLINEITEMCOMPRNQUERY.SPECIALGLCODE == T074U.UMSKZ
Supplier
  • Client
  • Supplier
  • C_GLLINEITEMCOMPRNQUERY.MANDT == LFA1.MANDT
  • C_GLLINEITEMCOMPRNQUERY.SUPPLIER == LFA1.LIFNR
Tax on Sales/Purchases Code
  • Client
  • ?
  • Tax on Sales/Purchases Code
  • C_GLLINEITEMCOMPRNQUERY.MANDT == T007A.MANDT
  • C_GLLINEITEMCOMPRNQUERY.[column in domain "KALSM_D"] == T007A.KALSM
  • C_GLLINEITEMCOMPRNQUERY.TAXCODE == T007A.MWSKZ
Transaction Currency
  • Client
  • Transaction Currency
  • C_GLLINEITEMCOMPRNQUERY.MANDT == TCURC.MANDT
  • C_GLLINEITEMCOMPRNQUERY.TRANSACTIONCURRENCY == TCURC.WAERS
Valuation area
  • Valuation area
  • Client
  • C_GLLINEITEMCOMPRNQUERY.VALUATIONAREA == T001K.BWKEY
  • C_GLLINEITEMCOMPRNQUERY.MANDT == T001K.MANDT