FINCS_SELECTION

Selection | view: FINCSSELECTION | Extraction: Not supported | Component: Master Data
Tables used: ACDOCU, FINCS_REF_VERS_R, ACDOCU, FINCS_GRPSTR, TF200, HRRP_NODE, FINSC_FISC_DATE, FINSC_PERIOD
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description
CurrencyConversionsDiffType Currency Translation Indicator Show values
InvestmentActivityType Consolidation of Investments Activity Show values
PostingLevel Posting Level Show values
RefConsolidationDocumentType Document Category Show values
Column Name Description Domain name
ConsolidationAcquisitionPeriod Period of Acquisition NUM03
ConsolidationAcquisitionYear Year of Acquisition GJAHR
ConsolidationPostgItemAutoFlag Indicator: Automatic posting lines TEXT1
CustomerSupplierCorporateGroup Group key KONZS
InvestmentActivity Consolidation of Investments Activity Number BELNR
Project Project Definition PS_PSPID
WBSElementExternalID Work Breakdown Structure Element (WBS Element) PS_POSID
Master Data Relations Join Conditions
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • FINCS_SELECTION.BASEUNIT == T006.MSEHI
  • FINCS_SELECTION.MANDT == T006.MANDT
Business Area
  • Client
  • Business Area
  • FINCS_SELECTION.MANDT == TGSB.MANDT
  • FINCS_SELECTION.BUSINESSAREA == TGSB.GSBER
Chart of Accounts
  • Chart of Accounts
  • Client
  • FINCS_SELECTION.CHARTOFACCOUNTS == T004.KTOPL
  • FINCS_SELECTION.MANDT == T004.MANDT
Company
  • Client
  • Company
  • FINCS_SELECTION.MANDT == T880.MANDT
  • FINCS_SELECTION.COMPANY == T880.RCOMP
Company Code
  • Client
  • Company Code
  • FINCS_SELECTION.MANDT == T001.MANDT
  • FINCS_SELECTION.COMPANYCODE == T001.BUKRS
Consolidation Chart of Accounts
  • Client
  • Consolidation Chart of Accounts
  • FINCS_SELECTION.MANDT == TF120.MANDT
  • FINCS_SELECTION.CONSOLIDATIONCHARTOFACCOUNTS == TF120.ITCLG
Dimension
  • Client
  • Dimension
  • FINCS_SELECTION.MANDT == TF150.MANDT
  • FINCS_SELECTION.CONSOLIDATIONDIMENSION == TF150.DIMEN
Document Type
  • Document Type
  • Client
  • Dimension
  • FINCS_SELECTION.CONSOLIDATIONDOCUMENTTYPE == TF500.DOCTY
  • FINCS_SELECTION.MANDT == TF500.MANDT
  • FINCS_SELECTION.CONSOLIDATIONDIMENSION == TF500.DIMEN
Consolidation Group
  • Client
  • Consolidation Group
  • Dimension
  • FINCS_SELECTION.MANDT == TF180.MANDT
  • FINCS_SELECTION.CONSOLIDATIONGROUP == TF180.CONGR
  • FINCS_SELECTION.CONSOLIDATIONDIMENSION == TF180.DIMEN
Consolidation Unit
  • Client
  • Consolidation Unit
  • Dimension
  • FINCS_SELECTION.MANDT == TF160.MANDT
  • FINCS_SELECTION.CONSOLIDATIONUNIT == TF160.BUNIT
  • FINCS_SELECTION.CONSOLIDATIONDIMENSION == TF160.DIMEN
Controlling Area
  • Client
  • Controlling Area
  • FINCS_SELECTION.MANDT == TKA01.MANDT
  • FINCS_SELECTION.CONTROLLINGAREA == TKA01.KOKRS
Cost Center
  • Client
  • ?
  • Controlling Area
  • Cost Center
  • FINCS_SELECTION.MANDT == CSKS.MANDT
  • FINCS_SELECTION.[column in domain "DATBI"] == CSKS.DATBI
  • FINCS_SELECTION.CONTROLLINGAREA == CSKS.KOKRS
  • FINCS_SELECTION.COSTCENTER == CSKS.KOSTL
Customer Group
  • Customer Group
  • Client
  • FINCS_SELECTION.CUSTOMERGROUP == T151.KDGRP
  • FINCS_SELECTION.MANDT == T151.MANDT
Country/Region
  • Country/Region
  • Client
  • FINCS_SELECTION.CUSTOMERSUPPLIERCOUNTRY == T005.LAND1
  • FINCS_SELECTION.MANDT == T005.MANDT
Industry key
  • Industry key
  • Client
  • FINCS_SELECTION.CUSTOMERSUPPLIERINDUSTRY == T016.BRSCH
  • FINCS_SELECTION.MANDT == T016.MANDT
Distribution Channel
  • Client
  • Distribution Channel
  • FINCS_SELECTION.MANDT == TVTW.MANDT
  • FINCS_SELECTION.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Financial Statement Item
  • Client
  • Consolidation Chart of Accounts
  • Financial Statement Item
  • FINCS_SELECTION.MANDT == TF100.MANDT
  • FINCS_SELECTION.CONSOLIDATIONCHARTOFACCOUNTS == TF100.ITCLG
  • FINCS_SELECTION.FINANCIALSTATEMENTITEM == TF100.ITEM
Transaction type
  • Transaction type
  • Client
  • FINCS_SELECTION.FINANCIALTRANSACTIONTYPE == T856.TRTYP
  • FINCS_SELECTION.MANDT == T856.MANDT
Functional Area
  • Functional Area
  • Client
  • FINCS_SELECTION.FUNCTIONALAREA == TFKB.FKBER
  • FINCS_SELECTION.MANDT == TFKB.MANDT
G/L Account
  • Client
  • Company Code
  • G/L Account
  • FINCS_SELECTION.MANDT == SKB1.MANDT
  • FINCS_SELECTION.COMPANYCODE == SKB1.BUKRS
  • FINCS_SELECTION.GLACCOUNT == SKB1.SAKNR
Internal Order
  • Client
  • Internal Order
  • FINCS_SELECTION.MANDT == AUFK.MANDT
  • FINCS_SELECTION.INTERNALORDER == AUFK.AUFNR
Investee Unit
  • Client
  • Dimension
  • Investee Unit
  • FINCS_SELECTION.MANDT == TF160.MANDT
  • FINCS_SELECTION.CONSOLIDATIONDIMENSION == TF160.DIMEN
  • FINCS_SELECTION.INVESTEECONSOLIDATIONUNIT == TF160.BUNIT
Material Group
  • Material Group
  • Client
  • FINCS_SELECTION.MATERIALGROUP == T023.MATKL
  • FINCS_SELECTION.MANDT == T023.MANDT
Division
  • Division
  • Client
  • FINCS_SELECTION.ORGANIZATIONDIVISION == TSPA.SPART
  • FINCS_SELECTION.MANDT == TSPA.MANDT
Partner Business Area
  • Client
  • Partner Business Area
  • FINCS_SELECTION.MANDT == TGSB.MANDT
  • FINCS_SELECTION.PARTNERBUSINESSAREA == TGSB.GSBER
Partner Company
  • Client
  • Partner Company
  • FINCS_SELECTION.MANDT == T880.MANDT
  • FINCS_SELECTION.PARTNERCOMPANY == T880.RCOMP
Partner Unit
  • Partner Unit
  • Client
  • Dimension
  • FINCS_SELECTION.PARTNERCONSOLIDATIONUNIT == TF160.BUNIT
  • FINCS_SELECTION.MANDT == TF160.MANDT
  • FINCS_SELECTION.CONSOLIDATIONDIMENSION == TF160.DIMEN
Partner Cost Center
  • Client
  • Partner Cost Center
  • ?
  • Controlling Area
  • FINCS_SELECTION.MANDT == CSKS.MANDT
  • FINCS_SELECTION.PARTNERCOSTCENTER == CSKS.KOSTL
  • FINCS_SELECTION.[column in domain "DATBI"] == CSKS.DATBI
  • FINCS_SELECTION.CONTROLLINGAREA == CSKS.KOKRS
Partner Functional Area
  • Client
  • Partner Functional Area
  • FINCS_SELECTION.MANDT == TFKB.MANDT
  • FINCS_SELECTION.PARTNERFUNCTIONALAREA == TFKB.FKBER
Partner Profit Center
  • Partner Profit Center
  • Client
  • ?
  • Controlling Area
  • FINCS_SELECTION.PARTNERPROFITCENTER == CEPC.PRCTR
  • FINCS_SELECTION.MANDT == CEPC.MANDT
  • FINCS_SELECTION.[column in domain "DATBI"] == CEPC.DATBI
  • FINCS_SELECTION.CONTROLLINGAREA == CEPC.KOKRS
Partner Segment for Segmental Reporting
  • Partner Segment for Segmental Reporting
  • Client
  • FINCS_SELECTION.PARTNERSEGMENT == FAGL_SEGM.SEGMENT
  • FINCS_SELECTION.MANDT == FAGL_SEGM.MANDT
Plant
  • Client
  • Plant
  • FINCS_SELECTION.MANDT == T001W.MANDT
  • FINCS_SELECTION.PLANT == T001W.WERKS
Profit Center
  • Profit Center
  • Client
  • ?
  • Controlling Area
  • FINCS_SELECTION.PROFITCENTER == CEPC.PRCTR
  • FINCS_SELECTION.MANDT == CEPC.MANDT
  • FINCS_SELECTION.[column in domain "DATBI"] == CEPC.DATBI
  • FINCS_SELECTION.CONTROLLINGAREA == CEPC.KOKRS
Sales District
  • Sales District
  • Client
  • FINCS_SELECTION.SALESDISTRICT == T171.BZIRK
  • FINCS_SELECTION.MANDT == T171.MANDT
Sales Organization
  • Client
  • Sales Organization
  • FINCS_SELECTION.MANDT == TVKO.MANDT
  • FINCS_SELECTION.SALESORGANIZATION == TVKO.VKORG
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
Product Sold
  • Client
  • Product Sold
  • FINCS_SELECTION.MANDT == MARA.MANDT
  • FINCS_SELECTION.SOLDPRODUCT == MARA.MATNR
Product Sold Group
  • Product Sold Group
  • Client
  • FINCS_SELECTION.SOLDPRODUCTGROUP == T023.MATKL
  • FINCS_SELECTION.MANDT == T023.MANDT
Subitem
  • Subitem Category
  • Client
  • Subitem
  • FINCS_SELECTION.SUBITEMCATEGORY == TF115.SITYP
  • FINCS_SELECTION.MANDT == TF115.MANDT
  • FINCS_SELECTION.SUBITEM == TF115.SITEM
Subitem Category
  • Subitem Category
  • Client
  • FINCS_SELECTION.SUBITEMCATEGORY == TF110.SITYP
  • FINCS_SELECTION.MANDT == TF110.MANDT
Currency Key
  • Client
  • Currency Key
  • FINCS_SELECTION.MANDT == TCURC.MANDT
  • FINCS_SELECTION.TRANSACTIONCURRENCY == TCURC.WAERS