I_GroupReportingValidation

Group Reporting Validation View | view: IGPVEC | Extraction: Not supported | Component: Validation Engine

Tables used: FINCS_REF_VERS_R, ACDOCU, ACDOCU, ACDOCU, ACDOCU, ACDOCU, FINCS_GRPSTR, TF200, TF001

🔑 Keys
💰 Amounts (8)
∑ Quantities (1)
📅 Dates
☰ Categorical (5)
Other (13)
🔗 Relations (41)

Column Name	Description

Column Name	Description
💲 Currency key of the local currency (Currency):
OpeningBalanceAmount	Value in Local Currency
YearToDateAmount	Value in Local Currency
YearToDateAmountInPriorPeriod	Value in Local Currency
YearToDateAmountInPriorYear	Value in Local Currency
CurrentPeriodAmount	Value in Local Currency
PeriodAmountInPriorPeriod	Value in Local Currency
PeriodAmountInPriorYear	Value in Local Currency
💲 Currency Key (TransactionCurrency):
PeriodAmountInTransacCrcy	Value in Transaction Currency

Column Name	Description
📏 Base Unit of Measure (BaseUnit):
CurrentPeriodQuantity	Quantity

Column Name	Description

Column Name	Description
DocumentCategory	Document Category	Show values
RecordType	Record Type	Show values
PostingLevel	Posting Level	Show values
RefConsolidationDocumentType	Document Category	Show values
InvestmentActivityType	Consolidation of Investments Activity	Show values

Column Name	Description	Domain name
ConsolidationDocumentNumber	Document Number of an Accounting Document	BELNR
ConsolidationPostingItem	Six-Character Posting Item for Ledger	DOCLN6
PostingFiscalPeriod	Posting period	POPER
FiscalYear	Fiscal Year	GJAHR
ConsolidationGroup	Consolidation Group	FC_CONGR
ConsolidationAcquisitionYear	Year of Acquisition	GJAHR
ConsolidationAcquisitionPeriod	Period of Acquisition	NUM03
ConsolidationPostgItemAutoFlag	Indicator: Automatic posting lines	TEXT1
InvestmentActivity	Consolidation of Investments Activity Number	BELNR
WBSElementExternalID	Work Breakdown Structure Element (WBS Element)	PS_POSID
Project	Project definition	PS_PSPID
CustomerSupplierCorporateGroup	Group key	KONZS
CreationDateTime	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	TZNTSTMPS

Master Data Relations	Join Conditions
Base Unit of Measure Client Base Unit of Measure	`I_GROUPREPORTINGVALIDATION.MANDT == T006.MANDT` `I_GROUPREPORTINGVALIDATION.BASEUNIT == T006.MSEHI`
Billing Type Client Billing Type	`I_GROUPREPORTINGVALIDATION.MANDT == TVFK.MANDT` `I_GROUPREPORTINGVALIDATION.BILLINGDOCUMENTTYPE == TVFK.FKART`
Business Area Client Business Area	`I_GROUPREPORTINGVALIDATION.MANDT == TGSB.MANDT` `I_GROUPREPORTINGVALIDATION.BUSINESSAREA == TGSB.GSBER`
Consolidation Unit Consolidation Unit Consolidation Unit Client Dimension	`I_GROUPREPORTINGVALIDATION.CONSOLIDATIONUNIT == TF160.BUNIT` `I_GROUPREPORTINGVALIDATION.BUSINESSENTITY == TF160.BUNIT` `I_GROUPREPORTINGVALIDATION.MANDT == TF160.MANDT` `I_GROUPREPORTINGVALIDATION.CONSOLIDATIONDIMENSION == TF160.DIMEN`
Chart of Accounts Client Chart of Accounts	`I_GROUPREPORTINGVALIDATION.MANDT == T004.MANDT` `I_GROUPREPORTINGVALIDATION.CHARTOFACCOUNTS == T004.KTOPL`
Company Client Company	`I_GROUPREPORTINGVALIDATION.MANDT == T880.MANDT` `I_GROUPREPORTINGVALIDATION.COMPANY == T880.RCOMP`
Original company code Client Original company code	`I_GROUPREPORTINGVALIDATION.MANDT == T001.MANDT` `I_GROUPREPORTINGVALIDATION.COMPANYCODE == T001.BUKRS`
Consolidation Chart of Accounts Client Consolidation Chart of Accounts	`I_GROUPREPORTINGVALIDATION.MANDT == TF120.MANDT` `I_GROUPREPORTINGVALIDATION.CONSOLIDATIONCHARTOFACCOUNTS == TF120.ITCLG`
Dimension Client Dimension	`I_GROUPREPORTINGVALIDATION.MANDT == TF150.MANDT` `I_GROUPREPORTINGVALIDATION.CONSOLIDATIONDIMENSION == TF150.DIMEN`
Document Type Client Document Type Dimension	`I_GROUPREPORTINGVALIDATION.MANDT == TF500.MANDT` `I_GROUPREPORTINGVALIDATION.CONSOLIDATIONDOCUMENTTYPE == TF500.DOCTY` `I_GROUPREPORTINGVALIDATION.CONSOLIDATIONDIMENSION == TF500.DIMEN`
Ledger Client Ledger	`I_GROUPREPORTINGVALIDATION.MANDT == T881.MANDT` `I_GROUPREPORTINGVALIDATION.CONSOLIDATIONLEDGER == T881.RLDNR`
Consolidation Unit Consolidation Unit Consolidation Unit Client Dimension	`I_GROUPREPORTINGVALIDATION.CONSOLIDATIONUNIT == TF160.BUNIT` `I_GROUPREPORTINGVALIDATION.BUSINESSENTITY == TF160.BUNIT` `I_GROUPREPORTINGVALIDATION.MANDT == TF160.MANDT` `I_GROUPREPORTINGVALIDATION.CONSOLIDATIONDIMENSION == TF160.DIMEN`
Controlling Area Client Controlling Area	`I_GROUPREPORTINGVALIDATION.MANDT == TKA01.MANDT` `I_GROUPREPORTINGVALIDATION.CONTROLLINGAREA == TKA01.KOKRS`
Cost Center Client ? Controlling Area Cost Center	`I_GROUPREPORTINGVALIDATION.MANDT == CSKS.MANDT` `I_GROUPREPORTINGVALIDATION.[column in domain "DATBI"] == CSKS.DATBI` `I_GROUPREPORTINGVALIDATION.CONTROLLINGAREA == CSKS.KOKRS` `I_GROUPREPORTINGVALIDATION.COSTCENTER == CSKS.KOSTL`
Customer Group Customer Group Client	`I_GROUPREPORTINGVALIDATION.CUSTOMERGROUP == T151.KDGRP` `I_GROUPREPORTINGVALIDATION.MANDT == T151.MANDT`
Country/Region Key Client Country/Region Key	`I_GROUPREPORTINGVALIDATION.MANDT == T005.MANDT` `I_GROUPREPORTINGVALIDATION.CUSTOMERSUPPLIERCOUNTRY == T005.LAND1`
Industry key Client Industry key	`I_GROUPREPORTINGVALIDATION.MANDT == T016.MANDT` `I_GROUPREPORTINGVALIDATION.CUSTOMERSUPPLIERINDUSTRY == T016.BRSCH`
Distribution Channel Client Distribution Channel	`I_GROUPREPORTINGVALIDATION.MANDT == TVTW.MANDT` `I_GROUPREPORTINGVALIDATION.DISTRIBUTIONCHANNEL == TVTW.VTWEG`
Financial Statement Item Client Consolidation Chart of Accounts Financial Statement Item	`I_GROUPREPORTINGVALIDATION.MANDT == TF100.MANDT` `I_GROUPREPORTINGVALIDATION.CONSOLIDATIONCHARTOFACCOUNTS == TF100.ITCLG` `I_GROUPREPORTINGVALIDATION.FINANCIALSTATEMENTITEM == TF100.ITEM`
Transaction type Client Transaction type	`I_GROUPREPORTINGVALIDATION.MANDT == T856.MANDT` `I_GROUPREPORTINGVALIDATION.FINANCIALTRANSACTIONTYPE == T856.TRTYP`
Functional Area Client Functional Area	`I_GROUPREPORTINGVALIDATION.MANDT == TFKB.MANDT` `I_GROUPREPORTINGVALIDATION.FUNCTIONALAREA == TFKB.FKBER`
Account Number Client Account Number Original company code	`I_GROUPREPORTINGVALIDATION.MANDT == SKB1.MANDT` `I_GROUPREPORTINGVALIDATION.GLACCOUNT == SKB1.SAKNR` `I_GROUPREPORTINGVALIDATION.COMPANYCODE == SKB1.BUKRS`
Investee Unit Client Investee Unit Dimension	`I_GROUPREPORTINGVALIDATION.MANDT == TF160.MANDT` `I_GROUPREPORTINGVALIDATION.INVESTEECONSOLIDATIONUNIT == TF160.BUNIT` `I_GROUPREPORTINGVALIDATION.CONSOLIDATIONDIMENSION == TF160.DIMEN`
Material Group Client Material Group	`I_GROUPREPORTINGVALIDATION.MANDT == T023.MANDT` `I_GROUPREPORTINGVALIDATION.MATERIALGROUP == T023.MATKL`
Division Client Division	`I_GROUPREPORTINGVALIDATION.MANDT == TSPA.MANDT` `I_GROUPREPORTINGVALIDATION.ORGANIZATIONDIVISION == TSPA.SPART`
Trading partner's business area Client Trading partner's business area	`I_GROUPREPORTINGVALIDATION.MANDT == TGSB.MANDT` `I_GROUPREPORTINGVALIDATION.PARTNERBUSINESSAREA == TGSB.GSBER`
Company ID of Trading Partner Client Company ID of Trading Partner	`I_GROUPREPORTINGVALIDATION.MANDT == T880.MANDT` `I_GROUPREPORTINGVALIDATION.PARTNERCOMPANY == T880.RCOMP`
Partner Unit Client Dimension Partner Unit	`I_GROUPREPORTINGVALIDATION.MANDT == TF160.MANDT` `I_GROUPREPORTINGVALIDATION.CONSOLIDATIONDIMENSION == TF160.DIMEN` `I_GROUPREPORTINGVALIDATION.PARTNERCONSOLIDATIONUNIT == TF160.BUNIT`
Sender cost center Client ? Controlling Area Sender cost center	`I_GROUPREPORTINGVALIDATION.MANDT == CSKS.MANDT` `I_GROUPREPORTINGVALIDATION.[column in domain "DATBI"] == CSKS.DATBI` `I_GROUPREPORTINGVALIDATION.CONTROLLINGAREA == CSKS.KOKRS` `I_GROUPREPORTINGVALIDATION.PARTNERCOSTCENTER == CSKS.KOSTL`
Partner Functional Area Client Partner Functional Area	`I_GROUPREPORTINGVALIDATION.MANDT == TFKB.MANDT` `I_GROUPREPORTINGVALIDATION.PARTNERFUNCTIONALAREA == TFKB.FKBER`
Partner Profit Center Client ? Partner Profit Center Controlling Area	`I_GROUPREPORTINGVALIDATION.MANDT == CEPC.MANDT` `I_GROUPREPORTINGVALIDATION.[column in domain "DATBI"] == CEPC.DATBI` `I_GROUPREPORTINGVALIDATION.PARTNERPROFITCENTER == CEPC.PRCTR` `I_GROUPREPORTINGVALIDATION.CONTROLLINGAREA == CEPC.KOKRS`
Partner Segment for Segmental Reporting Client Partner Segment for Segmental Reporting	`I_GROUPREPORTINGVALIDATION.MANDT == FAGL_SEGM.MANDT` `I_GROUPREPORTINGVALIDATION.PARTNERSEGMENT == FAGL_SEGM.SEGMENT`
Plant Client Plant	`I_GROUPREPORTINGVALIDATION.MANDT == T001W.MANDT` `I_GROUPREPORTINGVALIDATION.PLANT == T001W.WERKS`
Profit Center Profit Center Client ? Controlling Area	`I_GROUPREPORTINGVALIDATION.PROFITCENTER == CEPC.PRCTR` `I_GROUPREPORTINGVALIDATION.MANDT == CEPC.MANDT` `I_GROUPREPORTINGVALIDATION.[column in domain "DATBI"] == CEPC.DATBI` `I_GROUPREPORTINGVALIDATION.CONTROLLINGAREA == CEPC.KOKRS`
Sales District Client Sales District	`I_GROUPREPORTINGVALIDATION.MANDT == T171.MANDT` `I_GROUPREPORTINGVALIDATION.SALESDISTRICT == T171.BZIRK`
Sales Organization Client Sales Organization	`I_GROUPREPORTINGVALIDATION.MANDT == TVKO.MANDT` `I_GROUPREPORTINGVALIDATION.SALESORGANIZATION == TVKO.VKORG`
Segment for Segmental Reporting Client Segment for Segmental Reporting	`I_GROUPREPORTINGVALIDATION.MANDT == FAGL_SEGM.MANDT` `I_GROUPREPORTINGVALIDATION.SEGMENT == FAGL_SEGM.SEGMENT`
Product Sold Group Client Product Sold Group	`I_GROUPREPORTINGVALIDATION.MANDT == T023.MANDT` `I_GROUPREPORTINGVALIDATION.SOLDPRODUCTGROUP == T023.MATKL`
Subitem Client Subitem Subitem Category	`I_GROUPREPORTINGVALIDATION.MANDT == TF115.MANDT` `I_GROUPREPORTINGVALIDATION.SUBITEM == TF115.SITEM` `I_GROUPREPORTINGVALIDATION.SUBITEMCATEGORY == TF115.SITYP`
Subitem Category Client Subitem Category	`I_GROUPREPORTINGVALIDATION.MANDT == TF110.MANDT` `I_GROUPREPORTINGVALIDATION.SUBITEMCATEGORY == TF110.SITYP`
Currency Key Client Currency Key	`I_GROUPREPORTINGVALIDATION.MANDT == TCURC.MANDT` `I_GROUPREPORTINGVALIDATION.TRANSACTIONCURRENCY == TCURC.WAERS`