I_OrglChgTransfPostgCube

Organizational Change Transfer Postings - Cube | view: IORGCHGTRPOCUBE | TRAN | Extraction: Not supported | Component: General Ledger Reorganization
Tables used: SCAL_TT_DATE, ACDOCA, BKPF, MARA, T004, T001, TKA02, TKA01, CSKS, CSLA, CSLA, CSLT, CSKS, CSKT, KNA1, T151, T151T, TVTW, TVTWT, TSPA, TSPAT, TFKB, TFKBT, SKA1, T880, FINSC_LEDGER, FINSC_LEDGER_T, MARA, MAKT, CEPC, CEPC, CEPCT, PROJ, TVKO, TVKOT, T000, FAGL_SEGM, FAGL_SEGMT, PRPS, SKAT, T004, FINSC_ACTVE_APPL, FINSC_LEDGER_REP, FINSC_FISC_DATE
Column Name Description
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
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
BeforeOrglChangeAmountInCCCrcy Amount in Global Currency
OrglChgTransferAmountInCCCrcy Amount in Global Currency
AmountAfterOrglChangeInCCCrcy Amount in Global Currency
💲 Global Currency (GlobalCurrency):
AmountInGlobalCurrency Amount in Global Currency
BeforeOrglChangeAmtInGlobCrcy Amount in Global Currency
OrglChgTransfAmountInGlobCrcy Amount in Global Currency
AfterOrglChgAmountInGlobalCrcy Amount in Global Currency
💲 Functional Currency (FunctionalCurrency):
AmountInFunctionalCurrency Amount in Functional Currency
BeforeOrglChgAmtInFuncnlCrcy Amount in Global Currency
OrglChgTransfAmtInFuncnlCrcy Amount in Global Currency
AfterOrglChgAmountInFuncnlCrcy Amount in Global Currency
Column Name Description
Column Name Description
OrglChangeEffectiveDate null
PostingDate Posting Date
Column Name Description
ControllingDebitCreditCode Controlling Debit Credit Code Show values
Column Name Description Domain name
LedgerFiscalYear Ledger Fiscal Year GJAHR
LedgerName Ledger Name TEXT30
CompanyCodeName Company Code Name TEXT25
ControllingAreaName Controlling Area Name TEXT25
GLAccountName G/L Account Name CHAR30
GLAccountLongName G/L Account Long Name CHAR50
CostCenterName Cost Center Name TEXT20
ProfitCenterName Description of Profit Center TEXT20
FunctionalAreaName Functional Area Name CHAR30
SegmentName Segment Name TEXT50
FiscalPeriod Fiscal Period POPER
FiscalYearPeriod Fiscal Year Period FIS_JAHRPER_CONV
CustomerName Name of Customer TEXT80
WBSElementInternalID WBS Element Internal ID FIS_WBSINT_NO_CONV
PartnerWBSElementInternalID Partner WBS Element Internal ID FIS_WBSINT_NO_CONV
PartnerWBSElementExternalID Partner WBS Element External ID FIS_WBSEXT_NO_CONV
WBSElementExternalID WBS Element External ID FIS_WBSEXT_NO_CONV
ProjectExternalID Project External ID FIS_PROJECTEXT_NO_CONV
PartnerProjectExternalID Partner Project External ID FIS_PROJECTEXT_NO_CONV
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
SenderAccountingDocument Sender Journal Entry BELNR
SenderFiscalYear Fiscal Year of an Accounting Document in the Sender System GJAHR
SenderLogicalSystem Logical System of the Sender LOGSYS
CostCtrActivityTypeName Activity Type Name DDTEXT
CustomerGroupName Name of Customer Group TEXT30
DistributionChannelName Distribution Channel Name TEXT20
DivisionName Name of Division TEXT30
ProductName Product Description TEXT40
PartnerCompanyName Company Name TEXT30
PartnerCostCenterName Partner Cost Center Name TEXT20
PartnerCostCtrActivityTypeName Partner Activity Type Name DDTEXT
PartnerFunctionalAreaName Partner Functional Area Name CHAR30
PartnerProfitCenterName Partner Profit Center Name CHAR50
PartnerProjectDescription Partner Project Description (1st text line) TEXT40
PartnerWBSElementDescription Partner WBS Element Description TEXT40
ProjectDescription Project Description TEXT40
SalesOrganizationName Sales Organization Name TEXT20
SoldProductName Sold Material Name TEXT40
WBSElementDescription WBS Element Name TEXT40
GLAccountAuthorizationGroup G/L Account Authorization Group BRGRU
SupplierBasicAuthorizationGrp Supplier Basic Authorization Group BRGRU
CustomerBasicAuthorizationGrp Customer Basic Authorization Group BRGRU
AcctgDocTypeAuthorizationGroup Accounting Document Type Authorization Group BRGRU
OrderType Order Type AUFART
SalesOrderType Sales Document Type AUART
Master Data Relations Join Conditions
Business Transaction Type
  • Client
  • Business Transaction Type
Chart of Accounts
  • Chart of Accounts
  • Client
  • I_ORGLCHGTRANSFPOSTGCUBE.CHARTOFACCOUNTS == T004.KTOPL
  • I_ORGLCHGTRANSFPOSTGCUBE.MANDT == T004.MANDT
Company Code
  • Company Code
  • Client
  • I_ORGLCHGTRANSFPOSTGCUBE.COMPANYCODE == T001.BUKRS
  • I_ORGLCHGTRANSFPOSTGCUBE.MANDT == T001.MANDT
Company Code Currency
  • Client
  • Company Code Currency
  • I_ORGLCHGTRANSFPOSTGCUBE.MANDT == TCURC.MANDT
  • I_ORGLCHGTRANSFPOSTGCUBE.COMPANYCODECURRENCY == TCURC.WAERS
Controlling Area
  • Controlling Area
  • Client
  • I_ORGLCHGTRANSFPOSTGCUBE.CONTROLLINGAREA == TKA01.KOKRS
  • I_ORGLCHGTRANSFPOSTGCUBE.MANDT == TKA01.MANDT
Cost Center
  • Controlling Area
  • Client
  • Cost Center
  • ?
  • I_ORGLCHGTRANSFPOSTGCUBE.CONTROLLINGAREA == CSKS.KOKRS
  • I_ORGLCHGTRANSFPOSTGCUBE.MANDT == CSKS.MANDT
  • I_ORGLCHGTRANSFPOSTGCUBE.COSTCENTER == CSKS.KOSTL
  • I_ORGLCHGTRANSFPOSTGCUBE.[column in domain "DATBI"] == CSKS.DATBI
Activity Type
  • Controlling Area
  • Client
  • ?
  • Activity Type
  • I_ORGLCHGTRANSFPOSTGCUBE.CONTROLLINGAREA == CSLA.KOKRS
  • I_ORGLCHGTRANSFPOSTGCUBE.MANDT == CSLA.MANDT
  • I_ORGLCHGTRANSFPOSTGCUBE.[column in domain "DATBI"] == CSLA.DATBI
  • I_ORGLCHGTRANSFPOSTGCUBE.COSTCTRACTIVITYTYPE == CSLA.LSTAR
Customer Number
  • Customer Number
  • Client
  • I_ORGLCHGTRANSFPOSTGCUBE.CUSTOMER == KNA1.KUNNR
  • I_ORGLCHGTRANSFPOSTGCUBE.MANDT == KNA1.MANDT
Customer Group
  • Customer Group
  • Client
  • I_ORGLCHGTRANSFPOSTGCUBE.CUSTOMERGROUP == T151.KDGRP
  • I_ORGLCHGTRANSFPOSTGCUBE.MANDT == T151.MANDT
Distribution Channel
  • Distribution Channel
  • Client
  • I_ORGLCHGTRANSFPOSTGCUBE.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • I_ORGLCHGTRANSFPOSTGCUBE.MANDT == TVTW.MANDT
Fiscal Year Variant
  • Client
  • Fiscal Year Variant
  • I_ORGLCHGTRANSFPOSTGCUBE.MANDT == T009.MANDT
  • I_ORGLCHGTRANSFPOSTGCUBE.FISCALYEARVARIANT == T009.PERIV
Functional Area
  • Functional Area
  • Client
  • I_ORGLCHGTRANSFPOSTGCUBE.FUNCTIONALAREA == TFKB.FKBER
  • I_ORGLCHGTRANSFPOSTGCUBE.MANDT == TFKB.MANDT
Functional Currency
  • Functional Currency
  • Client
  • I_ORGLCHGTRANSFPOSTGCUBE.FUNCTIONALCURRENCY == TCURC.WAERS
  • I_ORGLCHGTRANSFPOSTGCUBE.MANDT == TCURC.MANDT
G/L Account
  • G/L Account
  • Company Code
  • Client
  • I_ORGLCHGTRANSFPOSTGCUBE.GLACCOUNT == SKB1.SAKNR
  • I_ORGLCHGTRANSFPOSTGCUBE.COMPANYCODE == SKB1.BUKRS
  • I_ORGLCHGTRANSFPOSTGCUBE.MANDT == SKB1.MANDT
Global Currency
  • Global Currency
  • Client
  • I_ORGLCHGTRANSFPOSTGCUBE.GLOBALCURRENCY == TCURC.WAERS
  • I_ORGLCHGTRANSFPOSTGCUBE.MANDT == TCURC.MANDT
Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
  • Client
Order ID
  • Order ID
  • Client
  • I_ORGLCHGTRANSFPOSTGCUBE.ORDERID == AUFK.AUFNR
  • I_ORGLCHGTRANSFPOSTGCUBE.MANDT == AUFK.MANDT
Organizational Change
  • Client
  • Organizational Change
Division
  • Division
  • Client
  • I_ORGLCHGTRANSFPOSTGCUBE.ORGANIZATIONDIVISION == TSPA.SPART
  • I_ORGLCHGTRANSFPOSTGCUBE.MANDT == TSPA.MANDT
Origin Profit Center
  • Controlling Area
  • Client
  • Origin Profit Center
  • ?
  • I_ORGLCHGTRANSFPOSTGCUBE.CONTROLLINGAREA == CEPC.KOKRS
  • I_ORGLCHGTRANSFPOSTGCUBE.MANDT == CEPC.MANDT
  • I_ORGLCHGTRANSFPOSTGCUBE.ORIGINPROFITCENTER == CEPC.PRCTR
  • I_ORGLCHGTRANSFPOSTGCUBE.[column in domain "DATBI"] == CEPC.DATBI
Company ID of Trading Partner
  • Company ID of Trading Partner
  • Client
  • I_ORGLCHGTRANSFPOSTGCUBE.PARTNERCOMPANY == T880.RCOMP
  • I_ORGLCHGTRANSFPOSTGCUBE.MANDT == T880.MANDT
Partner Cost Center
  • Controlling Area
  • Client
  • ?
  • Partner Cost Center
  • I_ORGLCHGTRANSFPOSTGCUBE.CONTROLLINGAREA == CSKS.KOKRS
  • I_ORGLCHGTRANSFPOSTGCUBE.MANDT == CSKS.MANDT
  • I_ORGLCHGTRANSFPOSTGCUBE.[column in domain "DATBI"] == CSKS.DATBI
  • I_ORGLCHGTRANSFPOSTGCUBE.PARTNERCOSTCENTER == CSKS.KOSTL
Partner Cost Center Activity Type
  • Partner Cost Center Activity Type
  • Controlling Area
  • Client
  • ?
  • I_ORGLCHGTRANSFPOSTGCUBE.PARTNERCOSTCTRACTIVITYTYPE == CSLA.LSTAR
  • I_ORGLCHGTRANSFPOSTGCUBE.CONTROLLINGAREA == CSLA.KOKRS
  • I_ORGLCHGTRANSFPOSTGCUBE.MANDT == CSLA.MANDT
  • I_ORGLCHGTRANSFPOSTGCUBE.[column in domain "DATBI"] == CSLA.DATBI
Partner Functional Area
  • Client
  • Partner Functional Area
  • I_ORGLCHGTRANSFPOSTGCUBE.MANDT == TFKB.MANDT
  • I_ORGLCHGTRANSFPOSTGCUBE.PARTNERFUNCTIONALAREA == TFKB.FKBER
Partner Order
  • Partner Order
  • Client
  • I_ORGLCHGTRANSFPOSTGCUBE.PARTNERORDER == AUFK.AUFNR
  • I_ORGLCHGTRANSFPOSTGCUBE.MANDT == AUFK.MANDT
Partner Profit Center
  • Controlling Area
  • Client
  • ?
  • Partner Profit Center
  • I_ORGLCHGTRANSFPOSTGCUBE.CONTROLLINGAREA == CEPC.KOKRS
  • I_ORGLCHGTRANSFPOSTGCUBE.MANDT == CEPC.MANDT
  • I_ORGLCHGTRANSFPOSTGCUBE.[column in domain "DATBI"] == CEPC.DATBI
  • I_ORGLCHGTRANSFPOSTGCUBE.PARTNERPROFITCENTER == CEPC.PRCTR
Partner Project Internal ID
  • Partner Project Internal ID
  • Client
  • I_ORGLCHGTRANSFPOSTGCUBE.PARTNERPROJECTINTERNALID == PROJ.PSPNR
  • I_ORGLCHGTRANSFPOSTGCUBE.MANDT == PROJ.MANDT
Product Number
  • Product Number
  • Client
  • I_ORGLCHGTRANSFPOSTGCUBE.PRODUCT == MARA.MATNR
  • I_ORGLCHGTRANSFPOSTGCUBE.MANDT == MARA.MANDT
Profit Center
  • Profit Center
  • Controlling Area
  • Client
  • ?
  • I_ORGLCHGTRANSFPOSTGCUBE.PROFITCENTER == CEPC.PRCTR
  • I_ORGLCHGTRANSFPOSTGCUBE.CONTROLLINGAREA == CEPC.KOKRS
  • I_ORGLCHGTRANSFPOSTGCUBE.MANDT == CEPC.MANDT
  • I_ORGLCHGTRANSFPOSTGCUBE.[column in domain "DATBI"] == CEPC.DATBI
Project Internal ID
  • Client
  • Project Internal ID
  • I_ORGLCHGTRANSFPOSTGCUBE.MANDT == PROJ.MANDT
  • I_ORGLCHGTRANSFPOSTGCUBE.PROJECTINTERNALID == PROJ.PSPNR
Sales Organization
  • Sales Organization
  • Client
  • I_ORGLCHGTRANSFPOSTGCUBE.SALESORGANIZATION == TVKO.VKORG
  • I_ORGLCHGTRANSFPOSTGCUBE.MANDT == TVKO.MANDT
Segment for Segmental Reporting
  • Segment for Segmental Reporting
  • Client
  • I_ORGLCHGTRANSFPOSTGCUBE.SEGMENT == FAGL_SEGM.SEGMENT
  • I_ORGLCHGTRANSFPOSTGCUBE.MANDT == FAGL_SEGM.MANDT
Product Sold
  • Product Sold
  • Client
  • I_ORGLCHGTRANSFPOSTGCUBE.SOLDPRODUCT == MARA.MATNR
  • I_ORGLCHGTRANSFPOSTGCUBE.MANDT == MARA.MANDT
Product Sold Group
  • Product Sold Group
  • Client
  • I_ORGLCHGTRANSFPOSTGCUBE.SOLDPRODUCTGROUP == T023.MATKL
  • I_ORGLCHGTRANSFPOSTGCUBE.MANDT == T023.MANDT
Transaction Currency
  • Client
  • Transaction Currency
  • I_ORGLCHGTRANSFPOSTGCUBE.MANDT == TCURC.MANDT
  • I_ORGLCHGTRANSFPOSTGCUBE.TRANSACTIONCURRENCY == TCURC.WAERS