C_Trialbalanceq0001

Trial Balance | view: CFITRIALBALQ0001 | Extraction: Not supported | Component: Fiori UI for General Ledger Accounting
Tables used: SCAL_TT_DATE, PRTE, ACDOCA, MARA, T003, T003T, TGSB, TGSBT, T004, T001, TKA02, TKA01, CSKS, CSKS, CSKT, KNA1, T151, T151T, TFKB, TFKBT, SKA1, T001W, TBSL, TBSLT, MARA, T023T, T023, MAKT, CEPC, CEPC, CEPCT, PROJ, T000, FAGL_SEGM, FAGL_SEGMT, LFA1, USR21, PRPS, PRPS, SKAT, T004, USR05, FINSC_LD_CMP, FINSC_LEDGER_REP, FINSC_FISC_DATE, FINSC_PERIOD
Column Name Description
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
StartingBalanceAmtInCoCodeCrcy Starting Balance Amount In Company Code Currency
DebitAmountInCoCodeCrcy Debit Balance in Company Code Currency
CreditAmountInCoCodeCrcy Credit Balance in Company Code Currency
EndingBalanceAmtInCoCodeCrcy Ending Balance in Company Code Currency
IntmdEndingBalAmtInCoCodeCrcy Ending Balance in Company Code Currency
GLAcctDebitAmtInCoCodeCrcy Debit Amount in Company Code Currency
GLAcctCreditAmtInCoCodeCrcy Credit Amount in Company Code Currency
💲 Global Currency (GlobalCurrency):
StartingBalanceAmtInGlobalCrcy Starting Balance Amount In Global Currency
DebitAmountInGlobalCrcy Debit Balance in Global Currency
CreditAmountInGlobalCrcy Credit Balance in Global Currency
EndingBalanceAmtInGlobalCrcy Ending Balance in Global Currency
IntmdEndingBalAmtInGlobalCrcy Ending Balance in Global Currency
IntmdDebitAmountInGlobalCrcy Debit Amount in Global Currency
IntmdCreditAmountInGlobalCrcy Credit Amount in Global Currency
IntmdDebitAmountInFuncnlCrcy Debit Amount in Functional Currency
IntmdCreditAmountInFuncnlCrcy Credit Amount in Functional Currency
💲 Functional Currency (FunctionalCurrency):
StartingBalanceAmtInFuncnlCrcy Starting Balance Amount In Functional Currency
DebitAmountInFunctionalCrcy Debit Amount in Functional Currency
CreditAmountInFunctionalCrcy Credit Amount in Functional Currency
EndingBalanceAmtInFuncnlCrcy Ending Balance in Functional Currency
IntmdEndingBalAmtInFuncnlCrcy Ending Balance in Functional Currency
💲 Freely Defined Currency 1 (FreeDefinedCurrency1):
StartingBalAmtInFreeDfndCrcy1 Starting Balance Amount In Freely Defined Currency 1
DebitAmountInFreeDefinedCrcy1 Debit Balance in Freely Defined Currency 1
CreditAmountInFreeDefinedCrcy1 Credit Balance in Freely Defined Currency 1
EndingBalAmtInFreeDfndCrcy1 Ending Balance in Freely Defined Currency 1
IntmdEndingBalInFreeDfndCrcy1 Ending Balance in Free Defined Currency 1
IntmdDebitAmtInFreeDfndCrcy1 Debit Amount in Free Defined Currency 1
IntmdCreditAmtInFreeDfndCrcy1 Credit Amount in Free Defined Currency 1
💲 Freely Defined Currency 2 (FreeDefinedCurrency2):
StartingBalAmtInFreeDfndCrcy2 Starting Balance Amount In Freely Defined Currency 2
DebitAmountInFreeDefinedCrcy2 Debit Balance in Freely Defined Currency 2
CreditAmountInFreeDefinedCrcy2 Credit Balance in Freely Defined Currency 2
EndingBalAmtInFreeDfndCrcy2 Ending Balance in Freely Defined Currency 2
IntmdEndingBalInFreeDfndCrcy2 Ending Balance in Free Defined Currency 2
IntmdDebitAmtInFreeDfndCrcy2 Debit Amount in Free Defined Currency 2
IntmdCreditAmtInFreeDfndCrcy2 Credit Amount in Free Defined Currency 2
💲 Freely Defined Currency 3 (FreeDefinedCurrency3):
StartingBalAmtInFreeDfndCrcy3 Starting Balance Amount In Freely Defined Currency 3
DebitAmountInFreeDefinedCrcy3 Debit Balance in Freely Defined Currency 3
CreditAmountInFreeDefinedCrcy3 Credit Balance in Freely Defined Currency 3
EndingBalAmtInFreeDfndCrcy3 Ending Balance in Freely Defined Currency 3
IntmdEndingBalInFreeDfndCrcy3 Ending Balance in Free Defined Currency 3
IntmdDebitAmtInFreeDfndCrcy3 Debit Amount in Free Defined Currency 3
IntmdCreditAmtInFreeDfndCrcy3 Credit Amount in Free Defined Currency 3
💲 Freely Defined Currency 4 (FreeDefinedCurrency4):
StartingBalAmtInFreeDfndCrcy4 Starting Balance Amount In Freely Defined Currency 4
DebitAmountInFreeDefinedCrcy4 Debit Balance in Freely Defined Currency 4
CreditAmountInFreeDefinedCrcy4 Credit Balance in Freely Defined Currency 4
EndingBalAmtInFreeDfndCrcy4 Ending Balance in Freely Defined Currency 4
IntmdEndingBalInFreeDfndCrcy4 Ending Balance in Free Defined Currency 4
IntmdDebitAmtInFreeDfndCrcy4 Debit Amount in Free Defined Currency 4
IntmdCreditAmtInFreeDfndCrcy4 Credit Amount in Free Defined Currency 4
💲 Freely Defined Currency 5 (FreeDefinedCurrency5):
StartingBalAmtInFreeDfndCrcy5 Starting Balance Amount In Freely Defined Currency 5
DebitAmountInFreeDefinedCrcy5 Debit Balance in Freely Defined Currency 5
CreditAmountInFreeDefinedCrcy5 Credit Balance in Freely Defined Currency 5
EndingBalAmtInFreeDfndCrcy5 Ending Balance in Freely Defined Currency 5
IntmdEndingBalInFreeDfndCrcy5 Ending Balance in Free Defined Currency 5
IntmdDebitAmtInFreeDfndCrcy5 Debit Amount in Free Defined Currency 5
IntmdCreditAmtInFreeDfndCrcy5 Credit Amount in Free Defined Currency 5
💲 Freely Defined Currency 6 (FreeDefinedCurrency6):
StartingBalAmtInFreeDfndCrcy6 Starting Balance Amount In Freely Defined Currency 6
DebitAmountInFreeDefinedCrcy6 Debit Balance in Freely Defined Currency 6
CreditAmountInFreeDefinedCrcy6 Credit Balance in Freely Defined Currency 6
EndingBalAmtInFreeDfndCrcy6 Ending Balance in Freely Defined Currency 6
IntmdEndingBalInFreeDfndCrcy6 Ending Balance in Free Defined Currency 6
IntmdDebitAmtInFreeDfndCrcy6 Debit Amount in Free Defined Currency 6
IntmdCreditAmtInFreeDfndCrcy6 Credit Amount in Free Defined Currency 6
💲 Freely Defined Currency 7 (FreeDefinedCurrency7):
StartingBalAmtInFreeDfndCrcy7 Starting Balance Amount In Freely Defined Currency 7
DebitAmountInFreeDefinedCrcy7 Debit Balance in Freely Defined Currency 7
CreditAmountInFreeDefinedCrcy7 Credit Balance in Freely Defined Currency 7
EndingBalAmtInFreeDfndCrcy7 Ending Balance in Freely Defined Currency 7
IntmdEndingBalInFreeDfndCrcy7 Ending Balance in Free Defined Currency 7
IntmdDebitAmtInFreeDfndCrcy7 Debit Amount in Free Defined Currency 7
IntmdCreditAmtInFreeDfndCrcy7 Credit Amount in Free Defined Currency 7
💲 Freely Defined Currency 8 (FreeDefinedCurrency8):
StartingBalAmtInFreeDfndCrcy8 Starting Balance Amount In Freely Defined Currency 8
DebitAmountInFreeDefinedCrcy8 Debit Balance in Freely Defined Currency 8
CreditAmountInFreeDefinedCrcy8 Credit Balance in Freely Defined Currency 8
EndingBalAmtInFreeDfndCrcy8 Ending Balance in Freely Defined Currency 8
IntmdEndingBalInFreeDfndCrcy8 Ending Balance in Free Defined Currency 8
IntmdDebitAmtInFreeDfndCrcy8 Debit Amount in Free Defined Currency 8
IntmdCreditAmtInFreeDfndCrcy8 Credit Amount in Free Defined Currency 8
💲 Balance Transaction Currency (BalanceTransactionCurrency):
StartingBalAmtInBalTransCrcy Starting Balance Amount In Balance Transaction Currency
DebitAmountInBalanceTransCrcy Debit Balance in Balance Transaction Currency
CreditAmountInBalanceTransCrcy Credit Balance in Balance Transaction Currency
EndingBalanceAmtInBalTransCrcy Ending Balance in Balance Transaction Currency
IntmdEndingBalInBalTransCrcy Ending Balance in Balance Transaction Currency
IntmdDebitAmtInBalTransCrcy Debit Amount in Balance Transaction Currency
IntmdCreditAmtInBalTransCrcy Credit Amount in Balance Transaction Currency
💲 Transaction Currency (TransactionCurrency):
StartingBalanceAmtInTransCrcy Starting Balance Amount In Transaction Currency
DebitAmountInTransCrcy Debit Balance in Transaction Currency
CreditAmountInTransCrcy Credit Balance in Transaction Currency
EndingBalanceAmtInTransCrcy Ending Balance in Transaction Currency
IntmdEndingBalanceInTransCrcy Ending Balance in Transaction Currency
IntmdDebitAmtInTransCrcy Debit Amount in Transaction Currency
IntmdCreditAmountInTransCrcy Credit Amount in Transaction Currency
Column Name Description
Column Name Description
PostingDate Posting Date
AssetValueDate Asset Value Date
SettlementReferenceDate Settlement Reference Date
ClearingDate Clearing Date
Column Name Description
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
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
FinancialAccountType Account Type Show values
IsOpenItemManaged Managed on an Open Item Basis 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
PartnerOrderCategory Partner Order Category Show values
OrderCategory Order category Show values
IsBalanceSheetAccount Indicator: Account is a balance sheet account? Show values
Column Name Description Domain name
CompanyCodeName Name of Company Code or Company TEXT25
GLAccountHierarchyName G/L Account Short Text TEXT20
FiscalYear Fiscal Year GJAHR
LedgerFiscalYear Ledger Fiscal Year GJAHR
ReferenceDocumentItemGroup Reference Document Item Group NUMC6
ProfitCenterName Description of Profit Center TEXT20
FunctionalAreaName Name of the Functional Area TEXT25
BusinessAreaName Business Area Description TEXT30
ControllingAreaName Controlling Area Name TEXT25
SegmentName Segment Name TEXT50
SenderCostCenterName Cost Center Name TEXT20
PartnerProfitCenterName Description of Profit Center TEXT20
PartnerFunctionalAreaName Name of the Functional Area TEXT25
PartnerBusinessAreaName Business Area Description TEXT30
PartnerSegmentName Segment Name TEXT50
DebitCreditCodeName Debit/Credit Code Name DDTEXT
FiscalYearPeriod Fiscal Year Period FIS_JAHRPER_CONV
AccountingDocumentTypeName Document Type Name TEXT20
AssignmentReference Assignment Reference ZUONR
PostingKeyName Posting Key Name TEXT20
TransactionTypeDetermination Transaction Key CHAR3
EliminationProfitCenterName Description of Profit Center TEXT20
AccountAssignmentNumber Account Assignment Number NUM02
MaterialName Product Description TEXT40
PlantName Plant Name TEXT30
SupplierName Name of Supplier TEXT80
CustomerName Name of Customer TEXT80
FinancialAccountTypeName Financial Account Type Name DDTEXT
ClearingAccountingDocument Clearing Journal Entry BELNR
ClearingDocFiscalYear Fiscal Year of Clearing Journal Entry GJAHR
InventorySpecialStockType Inventory Special Stock Type SOBKZ
InventorySpclStkSalesDocument Inventory Special Stock Sales Document VBELN
InventorySpclStkSalesDocItm Inventory Special Stock Sales Document Item POSNR
InventorySpclStockWBSElement WBS Element (external) of Valuated Special Inventory PS_POSID
InvtrySpclStockWBSElmntExtID Inventory Special Stock WBS Element External ID FIS_WBSEXT_NO_CONV
InventorySpecialStockSupplier Supplier of Inventory Special Stock LIFNR
InvtrySpecialStockSupplierName Name of Supplier TEXT80
SenderGLAccount Sender G/L Account CHAR10
SenderAccountAssignment Sender Account Assignment ACCAS
OffsettingAccount Offsetting Account GKONT
PersonnelNumber Personnel Number PERNR
AccountAssignment Account Assignment ACCAS
RelatedNetworkActivity Network activity VORNR
PartnerAccountAssignment Partner Account Assignment ACCAS
PartnerWBSElement Partner WBS Element FIS_WBS
PartnerWBSElementExternalID Partner WBS Element External ID FIS_WBSEXT_NO_CONV
PartnerProject Partner Project FIS_PROJECT
PartnerProjectExternalID Partner Project External ID FIS_PROJECTEXT_NO_CONV
PartnerProjectNetworkActivity Partner Project Network Activity VORNR
PartnerServiceDocumentItem Partner Service Document Item
TimeSheetOvertimeCategory Overtime Category CATS_OVERTIME_CATEGORY
MaterialGroupName Product Group Description TEXT20
CustomerGroupName Name TEXT20
GrantID Grant GM_GRANT_NBR
PartnerGrant Partner Grant GM_GRANT_NBR
CostCenterName Cost Center Name TEXT20
WBSElement Work Breakdown Structure Element (WBS Element) PS_POSID
WBSElementExternalID WBS Element External ID FIS_WBSEXT_NO_CONV
Project Project definition PS_PSPID
ProjectExternalID Project External ID FIS_PROJECTEXT_NO_CONV
SalesOrderItem Sales Order Item POSNR
SalesDocumentItem Sales Document Item POSNR
FiscalPeriodDate Fiscal Period Date FIS_FISCALPERIOD_DATE
CalendarYear Calendar Year NUM4
CalendarQuarter Calendar Quarter NUM1
CalendarYearQuarter Year Quarter NUM5
CalendarMonth Calendar Month NUM2
CalendarYearMonth Year Month NUM6
CalendarWeek Calendar Week NUM2
CalendarYearWeek Year Week NUM6
FiscalQuarter Fiscal Quarter FINS_FSCALQUARTER
FiscalWeek Fiscal Week FINS_FISCALWEEK
FiscalYearQuarter Fiscal Year + Fiscal Quarter FINS_FYEARQUARTER
FiscalYearWeek Fiscal Year + Fiscal Week FINS_FYEARWEEK
FlowOfFundsLedgerFiscalYear Funds of Flow Ledger Fiscal Year
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • C_TRIALBALANCEQ0001.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • C_TRIALBALANCEQ0001.MANDT == T003.MANDT
Alternative G/L Account Number In Company Code
  • Alternative G/L Account Number In Company Code
  • Alternative Chart of Accounts for Country/Region
  • Client
  • C_TRIALBALANCEQ0001.ALTERNATIVEGLACCOUNT == SKA1.SAKNR
  • C_TRIALBALANCEQ0001.COUNTRYCHARTOFACCOUNTS == SKA1.KTOPL
  • C_TRIALBALANCEQ0001.MANDT == SKA1.MANDT
Asset Transaction Type
  • Asset Transaction Type
  • Client
  • C_TRIALBALANCEQ0001.ASSETTRANSACTIONTYPE == TABW.BWASL
  • C_TRIALBALANCEQ0001.MANDT == TABW.MANDT
Balance Transaction Currency
  • Client
  • Balance Transaction Currency
  • C_TRIALBALANCEQ0001.MANDT == TCURC.MANDT
  • C_TRIALBALANCEQ0001.BALANCETRANSACTIONCURRENCY == TCURC.WAERS
Billing Type
  • Billing Type
  • Client
  • C_TRIALBALANCEQ0001.BILLINGDOCUMENTTYPE == TVFK.FKART
  • C_TRIALBALANCEQ0001.MANDT == TVFK.MANDT
Budget Period
  • Financial Management Area
  • Fund
  • Budget Period
  • Client
  • C_TRIALBALANCEQ0001.FINANCIALMANAGEMENTAREA == FMFUNDBPD.FIKRS
  • C_TRIALBALANCEQ0001.FUND == FMFUNDBPD.FINCODE
  • C_TRIALBALANCEQ0001.BUDGETPERIOD == FMFUNDBPD.BUDGET_PD
  • C_TRIALBALANCEQ0001.MANDT == FMFUNDBPD.MANDT
Business Area
  • Business Area
  • Client
  • C_TRIALBALANCEQ0001.BUSINESSAREA == TGSB.GSBER
  • C_TRIALBALANCEQ0001.MANDT == TGSB.MANDT
Business Process
  • Business Process
  • ?
  • Controlling Area
  • Client
  • C_TRIALBALANCEQ0001.BUSINESSPROCESS == CBPR.PRZNR
  • C_TRIALBALANCEQ0001.[column in domain "DATBI"] == CBPR.DATBI
  • C_TRIALBALANCEQ0001.CONTROLLINGAREA == CBPR.KOKRS
  • C_TRIALBALANCEQ0001.MANDT == CBPR.MANDT
Business Transaction Type
  • Business Transaction Type
  • Client
Chart of Accounts
  • Chart of Accounts
  • Client
  • C_TRIALBALANCEQ0001.CHARTOFACCOUNTS == T004.KTOPL
  • C_TRIALBALANCEQ0001.MANDT == T004.MANDT
Company Code
  • Company Code
  • Client
  • C_TRIALBALANCEQ0001.COMPANYCODE == T001.BUKRS
  • C_TRIALBALANCEQ0001.MANDT == T001.MANDT
Company Code Currency
  • Company Code Currency
  • Client
  • C_TRIALBALANCEQ0001.COMPANYCODECURRENCY == TCURC.WAERS
  • C_TRIALBALANCEQ0001.MANDT == TCURC.MANDT
Controlling Area
  • Controlling Area
  • Client
  • C_TRIALBALANCEQ0001.CONTROLLINGAREA == TKA01.KOKRS
  • C_TRIALBALANCEQ0001.MANDT == TKA01.MANDT
Group Account Number
  • Client
  • Group Chart of Accts
  • Group Account Number
  • C_TRIALBALANCEQ0001.MANDT == SKA1.MANDT
  • C_TRIALBALANCEQ0001.CORPORATEGROUPCHARTOFACCOUNTS == SKA1.KTOPL
  • C_TRIALBALANCEQ0001.CORPORATEGROUPACCOUNT == SKA1.SAKNR
Group Chart of Accts
  • Client
  • Group Chart of Accts
  • C_TRIALBALANCEQ0001.MANDT == T004.MANDT
  • C_TRIALBALANCEQ0001.CORPORATEGROUPCHARTOFACCOUNTS == T004.KTOPL
Cost Center
  • ?
  • Controlling Area
  • Client
  • Cost Center
  • C_TRIALBALANCEQ0001.[column in domain "DATBI"] == CSKS.DATBI
  • C_TRIALBALANCEQ0001.CONTROLLINGAREA == CSKS.KOKRS
  • C_TRIALBALANCEQ0001.MANDT == CSKS.MANDT
  • C_TRIALBALANCEQ0001.COSTCENTER == CSKS.KOSTL
Activity Type
  • ?
  • Activity Type
  • Controlling Area
  • Client
  • C_TRIALBALANCEQ0001.[column in domain "DATBI"] == CSLA.DATBI
  • C_TRIALBALANCEQ0001.COSTCTRACTIVITYTYPE == CSLA.LSTAR
  • C_TRIALBALANCEQ0001.CONTROLLINGAREA == CSLA.KOKRS
  • C_TRIALBALANCEQ0001.MANDT == CSLA.MANDT
Cost Object
  • Cost Object
  • ?
  • Client
  • C_TRIALBALANCEQ0001.COSTOBJECT == CKPH.KSTRG
  • C_TRIALBALANCEQ0001.[column in domain "DATBI"] == CKPH.DATBI
  • C_TRIALBALANCEQ0001.MANDT == CKPH.MANDT
Alternative Chart of Accounts for Country/Region
  • Alternative Chart of Accounts for Country/Region
  • Client
  • C_TRIALBALANCEQ0001.COUNTRYCHARTOFACCOUNTS == T004.KTOPL
  • C_TRIALBALANCEQ0001.MANDT == T004.MANDT
Customer Number
  • Customer Number
  • Client
  • C_TRIALBALANCEQ0001.CUSTOMER == KNA1.KUNNR
  • C_TRIALBALANCEQ0001.MANDT == KNA1.MANDT
Customer Group
  • Customer Group
  • Client
  • C_TRIALBALANCEQ0001.CUSTOMERGROUP == T151.KDGRP
  • C_TRIALBALANCEQ0001.MANDT == T151.MANDT
Distribution Channel
  • Distribution Channel
  • Client
  • C_TRIALBALANCEQ0001.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • C_TRIALBALANCEQ0001.MANDT == TVTW.MANDT
Elimination Profit Center
  • ?
  • Elimination Profit Center
  • Controlling Area
  • Client
  • C_TRIALBALANCEQ0001.[column in domain "DATBI"] == CEPC.DATBI
  • C_TRIALBALANCEQ0001.ELIMINATIONPROFITCENTER == CEPC.PRCTR
  • C_TRIALBALANCEQ0001.CONTROLLINGAREA == CEPC.KOKRS
  • C_TRIALBALANCEQ0001.MANDT == CEPC.MANDT
Financial Management Area
  • Financial Management Area
  • Client
  • C_TRIALBALANCEQ0001.FINANCIALMANAGEMENTAREA == FM01.FIKRS
  • C_TRIALBALANCEQ0001.MANDT == FM01.MANDT
Financial Transaction Type
  • Financial Transaction Type
  • Client
  • C_TRIALBALANCEQ0001.FINANCIALTRANSACTIONTYPE == T856.TRTYP
  • C_TRIALBALANCEQ0001.MANDT == T856.MANDT
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • C_TRIALBALANCEQ0001.FISCALYEARVARIANT == T009.PERIV
  • C_TRIALBALANCEQ0001.MANDT == T009.MANDT
Asset Subnumber
  • Fixed Asset
  • Asset Subnumber
  • ?
  • Client
  • C_TRIALBALANCEQ0001.MASTERFIXEDASSET == ANLA.ANLN1
  • C_TRIALBALANCEQ0001.FIXEDASSET == ANLA.ANLN2
  • C_TRIALBALANCEQ0001.[column in domain "BUKRS"] == ANLA.BUKRS
  • C_TRIALBALANCEQ0001.MANDT == ANLA.MANDT
Freely Defined Currency 1
  • Client
  • Freely Defined Currency 1
  • C_TRIALBALANCEQ0001.MANDT == TCURC.MANDT
  • C_TRIALBALANCEQ0001.FREEDEFINEDCURRENCY1 == TCURC.WAERS
Freely Defined Currency 2
  • Freely Defined Currency 2
  • Client
  • C_TRIALBALANCEQ0001.FREEDEFINEDCURRENCY2 == TCURC.WAERS
  • C_TRIALBALANCEQ0001.MANDT == TCURC.MANDT
Freely Defined Currency 3
  • Freely Defined Currency 3
  • Client
  • C_TRIALBALANCEQ0001.FREEDEFINEDCURRENCY3 == TCURC.WAERS
  • C_TRIALBALANCEQ0001.MANDT == TCURC.MANDT
Freely Defined Currency 4
  • Freely Defined Currency 4
  • Client
  • C_TRIALBALANCEQ0001.FREEDEFINEDCURRENCY4 == TCURC.WAERS
  • C_TRIALBALANCEQ0001.MANDT == TCURC.MANDT
Freely Defined Currency 5
  • Freely Defined Currency 5
  • Client
  • C_TRIALBALANCEQ0001.FREEDEFINEDCURRENCY5 == TCURC.WAERS
  • C_TRIALBALANCEQ0001.MANDT == TCURC.MANDT
Freely Defined Currency 6
  • Freely Defined Currency 6
  • Client
  • C_TRIALBALANCEQ0001.FREEDEFINEDCURRENCY6 == TCURC.WAERS
  • C_TRIALBALANCEQ0001.MANDT == TCURC.MANDT
Freely Defined Currency 7
  • Freely Defined Currency 7
  • Client
  • C_TRIALBALANCEQ0001.FREEDEFINEDCURRENCY7 == TCURC.WAERS
  • C_TRIALBALANCEQ0001.MANDT == TCURC.MANDT
Freely Defined Currency 8
  • Freely Defined Currency 8
  • Client
  • C_TRIALBALANCEQ0001.FREEDEFINEDCURRENCY8 == TCURC.WAERS
  • C_TRIALBALANCEQ0001.MANDT == TCURC.MANDT
Functional Area
  • Client
  • Functional Area
  • C_TRIALBALANCEQ0001.MANDT == TFKB.MANDT
  • C_TRIALBALANCEQ0001.FUNCTIONALAREA == TFKB.FKBER
Functional Currency
  • Functional Currency
  • Client
  • C_TRIALBALANCEQ0001.FUNCTIONALCURRENCY == TCURC.WAERS
  • C_TRIALBALANCEQ0001.MANDT == TCURC.MANDT
Fund
  • Financial Management Area
  • Fund
  • Client
  • C_TRIALBALANCEQ0001.FINANCIALMANAGEMENTAREA == FMFINCODE.FIKRS
  • C_TRIALBALANCEQ0001.FUND == FMFINCODE.FINCODE
  • C_TRIALBALANCEQ0001.MANDT == FMFINCODE.MANDT
Funds Management Center
  • ?
  • Financial Management Area
  • Funds Management Center
  • Client
  • C_TRIALBALANCEQ0001.[column in domain "FM_DATBIS"] == FMFCTR.DATBIS
  • C_TRIALBALANCEQ0001.FINANCIALMANAGEMENTAREA == FMFCTR.FIKRS
  • C_TRIALBALANCEQ0001.FUNDSCENTER == FMFCTR.FICTR
  • C_TRIALBALANCEQ0001.MANDT == FMFCTR.MANDT
G/L Account
  • G/L Account
  • G/L Account
  • Company Code
  • Client
  • C_TRIALBALANCEQ0001.GLACCOUNT == SKB1.SAKNR
  • C_TRIALBALANCEQ0001.GLACCOUNTHIERARCHY == SKB1.SAKNR
  • C_TRIALBALANCEQ0001.COMPANYCODE == SKB1.BUKRS
  • C_TRIALBALANCEQ0001.MANDT == SKB1.MANDT
G/L Account
  • G/L Account
  • G/L Account
  • Company Code
  • Client
  • C_TRIALBALANCEQ0001.GLACCOUNT == SKB1.SAKNR
  • C_TRIALBALANCEQ0001.GLACCOUNTHIERARCHY == SKB1.SAKNR
  • C_TRIALBALANCEQ0001.COMPANYCODE == SKB1.BUKRS
  • C_TRIALBALANCEQ0001.MANDT == SKB1.MANDT
Global Currency
  • Global Currency
  • Client
  • C_TRIALBALANCEQ0001.GLOBALCURRENCY == TCURC.WAERS
  • C_TRIALBALANCEQ0001.MANDT == TCURC.MANDT
Group Asset Subnumber
  • ?
  • Group Asset
  • Group Asset Subnumber
  • Client
  • C_TRIALBALANCEQ0001.[column in domain "BUKRS"] == ANLA.BUKRS
  • C_TRIALBALANCEQ0001.GROUPMASTERFIXEDASSET == ANLA.ANLN1
  • C_TRIALBALANCEQ0001.GROUPFIXEDASSET == ANLA.ANLN2
  • C_TRIALBALANCEQ0001.MANDT == ANLA.MANDT
House Bank Key
  • ?
  • House Bank Key
  • Client
  • C_TRIALBALANCEQ0001.[column in domain "BUKRS"] == T012.BUKRS
  • C_TRIALBALANCEQ0001.HOUSEBANK == T012.HBKID
  • C_TRIALBALANCEQ0001.MANDT == T012.MANDT
House Bank Account
  • ?
  • House Bank Key
  • House Bank Account
  • Client
  • C_TRIALBALANCEQ0001.[column in domain "BUKRS"] == T012K.BUKRS
  • C_TRIALBALANCEQ0001.HOUSEBANK == T012K.HBKID
  • C_TRIALBALANCEQ0001.HOUSEBANKACCOUNT == T012K.HKTID
  • C_TRIALBALANCEQ0001.MANDT == T012K.MANDT
Inventory Valuation Type
  • Inventory Valuation Type
  • Client
  • C_TRIALBALANCEQ0001.INVENTORYVALUATIONTYPE == T149D.BWTAR
  • C_TRIALBALANCEQ0001.MANDT == T149D.MANDT
Joint venture
  • Joint venture
  • ?
  • Client
  • C_TRIALBALANCEQ0001.JOINTVENTURE == T8JV.VNAME
  • C_TRIALBALANCEQ0001.[column in domain "BUKRS"] == T8JV.BUKRS
  • C_TRIALBALANCEQ0001.MANDT == T8JV.MANDT
Joint Venture Cost Recovery Code
  • Joint Venture Cost Recovery Code
  • ?
  • Client
  • C_TRIALBALANCEQ0001.JOINTVENTURECOSTRECOVERYCODE == T8JJ.RECID
  • C_TRIALBALANCEQ0001.[column in domain "BUKRS"] == T8JJ.BUKRS
  • C_TRIALBALANCEQ0001.MANDT == T8JJ.MANDT
Joint Venture Equity Group
  • Joint venture
  • ?
  • Joint Venture Equity Group
  • Client
  • C_TRIALBALANCEQ0001.JOINTVENTURE == T8JF.VNAME
  • C_TRIALBALANCEQ0001.[column in domain "BUKRS"] == T8JF.BUKRS
  • C_TRIALBALANCEQ0001.JOINTVENTUREEQUITYGROUP == T8JF.EGRUP
  • C_TRIALBALANCEQ0001.MANDT == T8JF.MANDT
Joint Venture Equity Type
  • ?
  • Joint Venture Equity Type
  • Client
  • C_TRIALBALANCEQ0001.[column in domain "BUKRS"] == T8JE.BUKRS
  • C_TRIALBALANCEQ0001.JOINTVENTUREEQUITYTYPE == T8JE.ETYPE
  • C_TRIALBALANCEQ0001.MANDT == T8JE.MANDT
Ledger
  • Client
  • Source Ledger
  • Ledger
Logical System C_TRIALBALANCEQ0001.LOGICALSYSTEM == TBDLS.LOGSYS
Product (Deprecated)
  • Product (Deprecated)
  • Product Number
  • Client
  • C_TRIALBALANCEQ0001.MATERIAL == MARA.MATNR
  • C_TRIALBALANCEQ0001.PRODUCT == MARA.MATNR
  • C_TRIALBALANCEQ0001.MANDT == MARA.MANDT
Product Sold Group (Deprecated)
  • Product Sold Group (Deprecated)
  • Product Sold Group
  • Client
  • C_TRIALBALANCEQ0001.MATERIALGROUP == T023.MATKL
  • C_TRIALBALANCEQ0001.SOLDPRODUCTGROUP == T023.MATKL
  • C_TRIALBALANCEQ0001.MANDT == T023.MANDT
Operating concern
  • Operating concern
  • Client
  • C_TRIALBALANCEQ0001.OPERATINGCONCERN == TKEB.ERKRS
  • C_TRIALBALANCEQ0001.MANDT == TKEB.MANDT
Order ID
  • Order ID
  • Client
  • C_TRIALBALANCEQ0001.ORDERID == AUFK.AUFNR
  • C_TRIALBALANCEQ0001.MANDT == AUFK.MANDT
Division
  • Division
  • Client
  • C_TRIALBALANCEQ0001.ORGANIZATIONDIVISION == TSPA.SPART
  • C_TRIALBALANCEQ0001.MANDT == TSPA.MANDT
Origin Cost Center
  • ?
  • Origin Cost Center
  • Controlling Area
  • Client
  • C_TRIALBALANCEQ0001.[column in domain "DATBI"] == CSKS.DATBI
  • C_TRIALBALANCEQ0001.ORIGINCOSTCENTER == CSKS.KOSTL
  • C_TRIALBALANCEQ0001.CONTROLLINGAREA == CSKS.KOKRS
  • C_TRIALBALANCEQ0001.MANDT == CSKS.MANDT
Origin Cost Center Activity Type
  • ?
  • Origin Cost Center Activity Type
  • Controlling Area
  • Client
  • C_TRIALBALANCEQ0001.[column in domain "DATBI"] == CSLA.DATBI
  • C_TRIALBALANCEQ0001.ORIGINCOSTCTRACTIVITYTYPE == CSLA.LSTAR
  • C_TRIALBALANCEQ0001.CONTROLLINGAREA == CSLA.KOKRS
  • C_TRIALBALANCEQ0001.MANDT == CSLA.MANDT
FM: Partner Budget Period
  • FM: Partner Budget Period
  • Partner Fund
  • Financial Management Area
  • Client
  • C_TRIALBALANCEQ0001.PARTNERBUDGETPERIOD == FMFUNDBPD.BUDGET_PD
  • C_TRIALBALANCEQ0001.PARTNERFUND == FMFUNDBPD.FINCODE
  • C_TRIALBALANCEQ0001.FINANCIALMANAGEMENTAREA == FMFUNDBPD.FIKRS
  • C_TRIALBALANCEQ0001.MANDT == FMFUNDBPD.MANDT
Partner Business Area
  • Partner Business Area
  • Client
  • C_TRIALBALANCEQ0001.PARTNERBUSINESSAREA == TGSB.GSBER
  • C_TRIALBALANCEQ0001.MANDT == TGSB.MANDT
Partner Business Process
  • ?
  • Partner Business Process
  • Controlling Area
  • Client
  • C_TRIALBALANCEQ0001.[column in domain "DATBI"] == CBPR.DATBI
  • C_TRIALBALANCEQ0001.PARTNERBUSINESSPROCESS == CBPR.PRZNR
  • C_TRIALBALANCEQ0001.CONTROLLINGAREA == CBPR.KOKRS
  • C_TRIALBALANCEQ0001.MANDT == CBPR.MANDT
Company ID of Trading Partner
  • Company ID of Trading Partner
  • Client
  • C_TRIALBALANCEQ0001.PARTNERCOMPANY == T880.RCOMP
  • C_TRIALBALANCEQ0001.MANDT == T880.MANDT
Partner Company Code
  • Partner Company Code
  • Client
  • C_TRIALBALANCEQ0001.PARTNERCOMPANYCODE == T001.BUKRS
  • C_TRIALBALANCEQ0001.MANDT == T001.MANDT
Partner Cost Center
  • ?
  • Partner Cost Center
  • Controlling Area
  • Client
  • C_TRIALBALANCEQ0001.[column in domain "DATBI"] == CSKS.DATBI
  • C_TRIALBALANCEQ0001.PARTNERCOSTCENTER == CSKS.KOSTL
  • C_TRIALBALANCEQ0001.CONTROLLINGAREA == CSKS.KOKRS
  • C_TRIALBALANCEQ0001.MANDT == CSKS.MANDT
Partner Cost Center Activity Type
  • ?
  • Controlling Area
  • Partner Cost Center Activity Type
  • Client
  • C_TRIALBALANCEQ0001.[column in domain "DATBI"] == CSLA.DATBI
  • C_TRIALBALANCEQ0001.CONTROLLINGAREA == CSLA.KOKRS
  • C_TRIALBALANCEQ0001.PARTNERCOSTCTRACTIVITYTYPE == CSLA.LSTAR
  • C_TRIALBALANCEQ0001.MANDT == CSLA.MANDT
Partner Cost Object
  • ?
  • Partner Cost Object
  • Client
  • C_TRIALBALANCEQ0001.[column in domain "DATBI"] == CKPH.DATBI
  • C_TRIALBALANCEQ0001.PARTNERCOSTOBJECT == CKPH.KSTRG
  • C_TRIALBALANCEQ0001.MANDT == CKPH.MANDT
Partner Functional Area
  • Partner Functional Area
  • Client
  • C_TRIALBALANCEQ0001.PARTNERFUNCTIONALAREA == TFKB.FKBER
  • C_TRIALBALANCEQ0001.MANDT == TFKB.MANDT
Partner Fund
  • Partner Fund
  • Financial Management Area
  • Client
  • C_TRIALBALANCEQ0001.PARTNERFUND == FMFINCODE.FINCODE
  • C_TRIALBALANCEQ0001.FINANCIALMANAGEMENTAREA == FMFINCODE.FIKRS
  • C_TRIALBALANCEQ0001.MANDT == FMFINCODE.MANDT
Partner Order
  • Partner Order
  • Client
  • C_TRIALBALANCEQ0001.PARTNERORDER == AUFK.AUFNR
  • C_TRIALBALANCEQ0001.MANDT == AUFK.MANDT
Partner Profit Center
  • ?
  • Controlling Area
  • Partner Profit Center
  • Client
  • C_TRIALBALANCEQ0001.[column in domain "DATBI"] == CEPC.DATBI
  • C_TRIALBALANCEQ0001.CONTROLLINGAREA == CEPC.KOKRS
  • C_TRIALBALANCEQ0001.PARTNERPROFITCENTER == CEPC.PRCTR
  • C_TRIALBALANCEQ0001.MANDT == CEPC.MANDT
Partner Project Network
  • Partner Project Network
  • Client
  • C_TRIALBALANCEQ0001.PARTNERPROJECTNETWORK == AUFK.AUFNR
  • C_TRIALBALANCEQ0001.MANDT == AUFK.MANDT
Partner Segment for Segmental Reporting
  • Partner Segment for Segmental Reporting
  • Client
  • C_TRIALBALANCEQ0001.PARTNERSEGMENT == FAGL_SEGM.SEGMENT
  • C_TRIALBALANCEQ0001.MANDT == FAGL_SEGM.MANDT
Partner Service Document
  • Partner Service Document
  • Partner Service Document Item
  • Partner Service Document Type
  • Client
  • C_TRIALBALANCEQ0001.PARTNERSERVICEDOCUMENT == FCO_SRVDOC.SERVICE_DOC_ID
  • C_TRIALBALANCEQ0001.PARTNERSERVICEDOCUMENTITEM == FCO_SRVDOC.SERVICE_DOC_ITEM_ID
  • C_TRIALBALANCEQ0001.PARTNERSERVICEDOCUMENTTYPE == FCO_SRVDOC.SERVICE_DOC_TYPE
  • C_TRIALBALANCEQ0001.MANDT == FCO_SRVDOC.MANDT
Partner Service Document Type
  • Partner Service Document Type
  • Client
Plant
  • Plant
  • Client
  • C_TRIALBALANCEQ0001.PLANT == T001W.WERKS
  • C_TRIALBALANCEQ0001.MANDT == T001W.MANDT
Posting Key
  • Posting Key
  • Client
  • C_TRIALBALANCEQ0001.POSTINGKEY == TBSL.BSCHL
  • C_TRIALBALANCEQ0001.MANDT == TBSL.MANDT
Predecessor Reference Document Type C_TRIALBALANCEQ0001.PREDECESSORREFERENCEDOCTYPE == TTYP.AWTYP
Product Number
  • Product (Deprecated)
  • Product Number
  • Client
  • C_TRIALBALANCEQ0001.MATERIAL == MARA.MATNR
  • C_TRIALBALANCEQ0001.PRODUCT == MARA.MATNR
  • C_TRIALBALANCEQ0001.MANDT == MARA.MANDT
Product Group
  • Product Group
  • Client
  • C_TRIALBALANCEQ0001.PRODUCTGROUP == T023.MATKL
  • C_TRIALBALANCEQ0001.MANDT == T023.MANDT
Profit Center
  • ?
  • Controlling Area
  • Profit Center
  • Client
  • C_TRIALBALANCEQ0001.[column in domain "DATBI"] == CEPC.DATBI
  • C_TRIALBALANCEQ0001.CONTROLLINGAREA == CEPC.KOKRS
  • C_TRIALBALANCEQ0001.PROFITCENTER == CEPC.PRCTR
  • C_TRIALBALANCEQ0001.MANDT == CEPC.MANDT
Network Number for Account Assignment
  • Network Number for Account Assignment
  • Client
  • C_TRIALBALANCEQ0001.PROJECTNETWORK == AUFK.AUFNR
  • C_TRIALBALANCEQ0001.MANDT == AUFK.MANDT
Reference Document Type C_TRIALBALANCEQ0001.REFERENCEDOCUMENTTYPE == TTYP.AWTYP
Sales Organization
  • Client
  • Sales Organization
  • C_TRIALBALANCEQ0001.MANDT == TVKO.MANDT
  • C_TRIALBALANCEQ0001.SALESORGANIZATION == TVKO.VKORG
Segment for Segmental Reporting
  • Segment for Segmental Reporting
  • Client
  • C_TRIALBALANCEQ0001.SEGMENT == FAGL_SEGM.SEGMENT
  • C_TRIALBALANCEQ0001.MANDT == FAGL_SEGM.MANDT
Service Contract ID
  • Service Contract Type
  • Service Contract ID
  • Service Contract Item ID
  • Client
  • C_TRIALBALANCEQ0001.SERVICECONTRACTTYPE == FCO_SRVDOC.SERVICE_DOC_TYPE
  • C_TRIALBALANCEQ0001.SERVICECONTRACT == FCO_SRVDOC.SERVICE_DOC_ID
  • C_TRIALBALANCEQ0001.SERVICECONTRACTITEM == FCO_SRVDOC.SERVICE_DOC_ITEM_ID
  • C_TRIALBALANCEQ0001.MANDT == FCO_SRVDOC.MANDT
Service Contract Item ID
  • Service Contract Type
  • Service Contract ID
  • Service Contract Item ID
  • Client
  • C_TRIALBALANCEQ0001.SERVICECONTRACTTYPE == FCO_SRVDOC.SERVICE_DOC_TYPE
  • C_TRIALBALANCEQ0001.SERVICECONTRACT == FCO_SRVDOC.SERVICE_DOC_ID
  • C_TRIALBALANCEQ0001.SERVICECONTRACTITEM == FCO_SRVDOC.SERVICE_DOC_ITEM_ID
  • C_TRIALBALANCEQ0001.MANDT == FCO_SRVDOC.MANDT
Service Contract Type
  • Service Contract Type
  • Client
Service Document ID
  • Service Document Type
  • Service Document ID
  • Service Document Item ID
  • Client
  • C_TRIALBALANCEQ0001.SERVICEDOCUMENTTYPE == FCO_SRVDOC.SERVICE_DOC_TYPE
  • C_TRIALBALANCEQ0001.SERVICEDOCUMENT == FCO_SRVDOC.SERVICE_DOC_ID
  • C_TRIALBALANCEQ0001.SERVICEDOCUMENTITEM == FCO_SRVDOC.SERVICE_DOC_ITEM_ID
  • C_TRIALBALANCEQ0001.MANDT == FCO_SRVDOC.MANDT
Service Document Item ID
  • Service Document Type
  • Service Document ID
  • Service Document Item ID
  • Client
  • C_TRIALBALANCEQ0001.SERVICEDOCUMENTTYPE == FCO_SRVDOC.SERVICE_DOC_TYPE
  • C_TRIALBALANCEQ0001.SERVICEDOCUMENT == FCO_SRVDOC.SERVICE_DOC_ID
  • C_TRIALBALANCEQ0001.SERVICEDOCUMENTITEM == FCO_SRVDOC.SERVICE_DOC_ITEM_ID
  • C_TRIALBALANCEQ0001.MANDT == FCO_SRVDOC.MANDT
Service Document Type
  • Service Document Type
  • Client
Product Sold (Deprecated)
  • Product Sold (Deprecated)
  • Product Sold
  • Client
  • C_TRIALBALANCEQ0001.SOLDMATERIAL == MARA.MATNR
  • C_TRIALBALANCEQ0001.SOLDPRODUCT == MARA.MATNR
  • C_TRIALBALANCEQ0001.MANDT == MARA.MANDT
Product Sold
  • Product Sold (Deprecated)
  • Product Sold
  • Client
  • C_TRIALBALANCEQ0001.SOLDMATERIAL == MARA.MATNR
  • C_TRIALBALANCEQ0001.SOLDPRODUCT == MARA.MATNR
  • C_TRIALBALANCEQ0001.MANDT == MARA.MANDT
Product Sold Group
  • Product Sold Group (Deprecated)
  • Product Sold Group
  • Client
  • C_TRIALBALANCEQ0001.MATERIALGROUP == T023.MATKL
  • C_TRIALBALANCEQ0001.SOLDPRODUCTGROUP == T023.MATKL
  • C_TRIALBALANCEQ0001.MANDT == T023.MANDT
Source Ledger
  • Source Ledger
  • Ledger
  • Client
Special G/L Indicator
  • Account Type
  • Client
  • Special G/L Indicator
  • C_TRIALBALANCEQ0001.FINANCIALACCOUNTTYPE == T074U.KOART
  • C_TRIALBALANCEQ0001.MANDT == T074U.MANDT
  • C_TRIALBALANCEQ0001.SPECIALGLCODE == T074U.UMSKZ
Supplier
  • Supplier
  • Client
  • C_TRIALBALANCEQ0001.SUPPLIER == LFA1.LIFNR
  • C_TRIALBALANCEQ0001.MANDT == LFA1.MANDT
Tax on Sales/Purchases Code
  • ?
  • Tax on Sales/Purchases Code
  • Client
  • C_TRIALBALANCEQ0001.[column in domain "KALSM_D"] == T007A.KALSM
  • C_TRIALBALANCEQ0001.TAXCODE == T007A.MWSKZ
  • C_TRIALBALANCEQ0001.MANDT == T007A.MANDT
Transaction Currency
  • Transaction Currency
  • Client
  • C_TRIALBALANCEQ0001.TRANSACTIONCURRENCY == TCURC.WAERS
  • C_TRIALBALANCEQ0001.MANDT == TCURC.MANDT
Valuation area
  • Valuation area
  • Client
  • C_TRIALBALANCEQ0001.VALUATIONAREA == T001K.BWKEY
  • C_TRIALBALANCEQ0001.MANDT == T001K.MANDT