A_OpeningBalance

API Opening Balance | view: AFIOPENBALANCE | Extraction: Not supported | Component: Information System
Tables used: SCAL_TT_DATE, PRTE, ACDOCA, TGSB, TGSBT, T004, T001, TKA02, TKA01, CSKS, CSLA, CSLA, CSLT, CSKS, CSKT, T005, T005T, KNA1, T151, T151T, TVTW, TVTWT, TFKB, TFKBT, SKA1, FINSC_LEDGER, FINSC_LEDGER_T, MARA, T023, T023T, MAKT, CEPC, CEPC, CEPCT, PROJ, PROJ, T171, T171T, TVKO, TVKOT, T000, FAGL_SEGM, FAGL_SEGMT, LFA1, PRPS, PRPS, SKAT, T004, FINSC_ACTVE_APPL, FINSC_LEDGER_REP, FINSC_FISC_DATE
Column Name Description
Column Name Description
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
💲 Global Currency (GlobalCurrency):
AmountInGlobalCurrency Amount in Global Currency
Column Name Description
📏 Cost Source Unit (CostSourceUnit):
ValuationQuantity Valuation Quantity
Column Name Description
Column Name Description
ControllingDebitCreditCode Controlling Debit Credit Code Show values
Column Name Description Domain name
LedgerName Ledger Name TEXT30
LedgerFiscalYear Ledger Fiscal Year GJAHR
ControllingAreaName Controlling Area Name TEXT25
CompanyCodeName Name of Company Code or Company TEXT25
CostCenterName Cost Center Name TEXT20
ProfitCenterName Description of Profit Center TEXT20
FunctionalAreaName Name of the Functional Area TEXT25
BusinessAreaName Business Area Description TEXT30
SegmentName Segment Name TEXT50
PartnerBusinessAreaName Business Area Description TEXT30
FiscalPeriod null
FiscalYearPeriod Fiscal Year Period FIS_JAHRPER_C
Project Project FIS_PROJECT
ProjectDescription Project Definition Name TEXT40
WBSElement WBS Element FIS_WBS
WBSElementDescription WBS Element Name TEXT40
PartnerCompanyCodeName Name of Company Code or Company TEXT25
CostCtrActivityTypeName General Name TEXT20
PartnerCostCtrActivityTypeName General Name TEXT20
PartnerProject Partner Project FIS_PROJECT
PartnerProjectDescription Project Definition Name TEXT40
PartnerWBSElement Partner WBS Element FIS_WBS
PartnerWBSElementDescription WBS Element Name TEXT40
SalesOrganizationName Sales Organization Description TEXT20
DistributionChannelName Distribution Channel Description TEXT20
SoldMaterialName Material Description TEXT40
MaterialGroupName Product Group Description TEXT20
CustomerGroupName Name TEXT20
CustomerSupplierCountryName Country/Region Name TEXT50
SalesDistrictName Name of the district TEXT20
Master Data Relations Join Conditions
Business Area
  • Business Area
  • Client
  • A_OPENINGBALANCE.BUSINESSAREA == TGSB.GSBER
  • A_OPENINGBALANCE.MANDT == TGSB.MANDT
Chart of Accounts
  • Client
  • Chart of Accounts
  • A_OPENINGBALANCE.MANDT == T004.MANDT
  • A_OPENINGBALANCE.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Client
  • Company Code
  • A_OPENINGBALANCE.MANDT == T001.MANDT
  • A_OPENINGBALANCE.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Company Code Currency
  • Client
  • A_OPENINGBALANCE.COMPANYCODECURRENCY == TCURC.WAERS
  • A_OPENINGBALANCE.MANDT == TCURC.MANDT
Controlling Area
  • Controlling Area
  • Client
  • A_OPENINGBALANCE.CONTROLLINGAREA == TKA01.KOKRS
  • A_OPENINGBALANCE.MANDT == TKA01.MANDT
Cost Center
  • ?
  • Controlling Area
  • Client
  • Cost Center
  • A_OPENINGBALANCE.[column in domain "DATBI"] == CSKS.DATBI
  • A_OPENINGBALANCE.CONTROLLINGAREA == CSKS.KOKRS
  • A_OPENINGBALANCE.MANDT == CSKS.MANDT
  • A_OPENINGBALANCE.COSTCENTER == CSKS.KOSTL
Activity Type
  • ?
  • Controlling Area
  • Activity Type
  • Client
  • A_OPENINGBALANCE.[column in domain "DATBI"] == CSLA.DATBI
  • A_OPENINGBALANCE.CONTROLLINGAREA == CSLA.KOKRS
  • A_OPENINGBALANCE.COSTCTRACTIVITYTYPE == CSLA.LSTAR
  • A_OPENINGBALANCE.MANDT == CSLA.MANDT
Cost Source Unit
  • Client
  • Cost Source Unit
  • A_OPENINGBALANCE.MANDT == T006.MANDT
  • A_OPENINGBALANCE.COSTSOURCEUNIT == T006.MSEHI
Customer Number
  • Customer Number
  • Client
  • A_OPENINGBALANCE.CUSTOMER == KNA1.KUNNR
  • A_OPENINGBALANCE.MANDT == KNA1.MANDT
Customer Group
  • Client
  • Customer Group
  • A_OPENINGBALANCE.MANDT == T151.MANDT
  • A_OPENINGBALANCE.CUSTOMERGROUP == T151.KDGRP
Customer or Supplier Country/Region
  • Customer or Supplier Country/Region
  • Client
  • A_OPENINGBALANCE.CUSTOMERSUPPLIERCOUNTRY == T005.LAND1
  • A_OPENINGBALANCE.MANDT == T005.MANDT
Customer Supplier Industry
  • Customer Supplier Industry
  • Client
  • A_OPENINGBALANCE.CUSTOMERSUPPLIERINDUSTRY == T016.BRSCH
  • A_OPENINGBALANCE.MANDT == T016.MANDT
Distribution Channel
  • Distribution Channel
  • Client
  • A_OPENINGBALANCE.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • A_OPENINGBALANCE.MANDT == TVTW.MANDT
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • A_OPENINGBALANCE.FISCALYEARVARIANT == T009.PERIV
  • A_OPENINGBALANCE.MANDT == T009.MANDT
Functional Area
  • Functional Area
  • Client
  • A_OPENINGBALANCE.FUNCTIONALAREA == TFKB.FKBER
  • A_OPENINGBALANCE.MANDT == TFKB.MANDT
G/L Account
  • Client
  • G/L Account
  • Company Code
  • A_OPENINGBALANCE.MANDT == SKB1.MANDT
  • A_OPENINGBALANCE.GLACCOUNT == SKB1.SAKNR
  • A_OPENINGBALANCE.COMPANYCODE == SKB1.BUKRS
Global Currency
  • Global Currency
  • Client
  • A_OPENINGBALANCE.GLOBALCURRENCY == TCURC.WAERS
  • A_OPENINGBALANCE.MANDT == TCURC.MANDT
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
Product Sold Group
  • Product Sold Group
  • Client
  • A_OPENINGBALANCE.MATERIALGROUP == T023.MATKL
  • A_OPENINGBALANCE.MANDT == T023.MANDT
Order ID
  • Order ID
  • Client
  • A_OPENINGBALANCE.ORDERID == AUFK.AUFNR
  • A_OPENINGBALANCE.MANDT == AUFK.MANDT
Division
  • Division
  • Client
  • A_OPENINGBALANCE.ORGANIZATIONDIVISION == TSPA.SPART
  • A_OPENINGBALANCE.MANDT == TSPA.MANDT
Partner Business Area
  • Partner Business Area
  • Client
  • A_OPENINGBALANCE.PARTNERBUSINESSAREA == TGSB.GSBER
  • A_OPENINGBALANCE.MANDT == TGSB.MANDT
Company ID of Trading Partner
  • Company ID of Trading Partner
  • Client
  • A_OPENINGBALANCE.PARTNERCOMPANY == T880.RCOMP
  • A_OPENINGBALANCE.MANDT == T880.MANDT
Partner Company Code
  • Client
  • Partner Company Code
  • A_OPENINGBALANCE.MANDT == T001.MANDT
  • A_OPENINGBALANCE.PARTNERCOMPANYCODE == T001.BUKRS
Partner Cost Center
  • ?
  • Partner Cost Center
  • Controlling Area
  • Client
  • A_OPENINGBALANCE.[column in domain "DATBI"] == CSKS.DATBI
  • A_OPENINGBALANCE.PARTNERCOSTCENTER == CSKS.KOSTL
  • A_OPENINGBALANCE.CONTROLLINGAREA == CSKS.KOKRS
  • A_OPENINGBALANCE.MANDT == CSKS.MANDT
Partner Cost Center Activity Type
  • Partner Cost Center Activity Type
  • ?
  • Controlling Area
  • Client
  • A_OPENINGBALANCE.PARTNERCOSTCTRACTIVITYTYPE == CSLA.LSTAR
  • A_OPENINGBALANCE.[column in domain "DATBI"] == CSLA.DATBI
  • A_OPENINGBALANCE.CONTROLLINGAREA == CSLA.KOKRS
  • A_OPENINGBALANCE.MANDT == CSLA.MANDT
Partner Functional Area
  • Client
  • Partner Functional Area
  • A_OPENINGBALANCE.MANDT == TFKB.MANDT
  • A_OPENINGBALANCE.PARTNERFUNCTIONALAREA == TFKB.FKBER
Partner Order
  • Client
  • Partner Order
  • A_OPENINGBALANCE.MANDT == AUFK.MANDT
  • A_OPENINGBALANCE.PARTNERORDER == AUFK.AUFNR
Partner Profit Center
  • ?
  • Controlling Area
  • Client
  • Partner Profit Center
  • A_OPENINGBALANCE.[column in domain "DATBI"] == CEPC.DATBI
  • A_OPENINGBALANCE.CONTROLLINGAREA == CEPC.KOKRS
  • A_OPENINGBALANCE.MANDT == CEPC.MANDT
  • A_OPENINGBALANCE.PARTNERPROFITCENTER == CEPC.PRCTR
Partner Segment for Segmental Reporting
  • Partner Segment for Segmental Reporting
  • Client
  • A_OPENINGBALANCE.PARTNERSEGMENT == FAGL_SEGM.SEGMENT
  • A_OPENINGBALANCE.MANDT == FAGL_SEGM.MANDT
Plant
  • Plant
  • Client
  • A_OPENINGBALANCE.PLANT == T001W.WERKS
  • A_OPENINGBALANCE.MANDT == T001W.MANDT
Profit Center
  • ?
  • Profit Center
  • Controlling Area
  • Client
  • A_OPENINGBALANCE.[column in domain "DATBI"] == CEPC.DATBI
  • A_OPENINGBALANCE.PROFITCENTER == CEPC.PRCTR
  • A_OPENINGBALANCE.CONTROLLINGAREA == CEPC.KOKRS
  • A_OPENINGBALANCE.MANDT == CEPC.MANDT
Sales District
  • Sales District
  • Client
  • A_OPENINGBALANCE.SALESDISTRICT == T171.BZIRK
  • A_OPENINGBALANCE.MANDT == T171.MANDT
Sales Organization
  • Sales Organization
  • Client
  • A_OPENINGBALANCE.SALESORGANIZATION == TVKO.VKORG
  • A_OPENINGBALANCE.MANDT == TVKO.MANDT
Segment for Segmental Reporting
  • Segment for Segmental Reporting
  • Client
Sold Material
  • Client
  • Sold Material
  • A_OPENINGBALANCE.MANDT == MARA.MANDT
  • A_OPENINGBALANCE.SOLDMATERIAL == MARA.MATNR
Transaction Currency
  • Client
  • Transaction Currency
  • A_OPENINGBALANCE.MANDT == TCURC.MANDT
  • A_OPENINGBALANCE.TRANSACTIONCURRENCY == TCURC.WAERS