P_FINCS_USELECTION

Unified Selection | view: PFINCSUSEL | Extraction: Not supported | Component: Master Data

Tables used: ACDOCU, FINCS_REF_VERS_R, ACDOCU, FINCS_GRPSTR, TF200, HRRP_NODE, FINSC_FISC_DATE, FINSC_PERIOD

🔑 Keys
💰 Amounts
∑ Quantities
📅 Dates
☰ Categorical (4)
Other (7)
🔗 Relations (40)

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 Client Base Unit of Measure	`P_FINCS_USELECTION.MANDT == T006.MANDT` `P_FINCS_USELECTION.BASEUNIT == T006.MSEHI`
Business Area Business Area Client	`P_FINCS_USELECTION.BUSINESSAREA == TGSB.GSBER` `P_FINCS_USELECTION.MANDT == TGSB.MANDT`
Chart of Accounts Client Chart of Accounts	`P_FINCS_USELECTION.MANDT == T004.MANDT` `P_FINCS_USELECTION.CHARTOFACCOUNTS == T004.KTOPL`
Company Client Company	`P_FINCS_USELECTION.MANDT == T880.MANDT` `P_FINCS_USELECTION.COMPANY == T880.RCOMP`
Company Code Client Company Code	`P_FINCS_USELECTION.MANDT == T001.MANDT` `P_FINCS_USELECTION.COMPANYCODE == T001.BUKRS`
Consolidation Chart of Accounts Consolidation Chart of Accounts Client	`P_FINCS_USELECTION.CONSOLIDATIONCHARTOFACCOUNTS == TF120.ITCLG` `P_FINCS_USELECTION.MANDT == TF120.MANDT`
Dimension Dimension Client	`P_FINCS_USELECTION.CONSOLIDATIONDIMENSION == TF150.DIMEN` `P_FINCS_USELECTION.MANDT == TF150.MANDT`
Document Type Dimension Document Type Client	`P_FINCS_USELECTION.CONSOLIDATIONDIMENSION == TF500.DIMEN` `P_FINCS_USELECTION.CONSOLIDATIONDOCUMENTTYPE == TF500.DOCTY` `P_FINCS_USELECTION.MANDT == TF500.MANDT`
Consolidation Group Dimension Client Consolidation Group	`P_FINCS_USELECTION.CONSOLIDATIONDIMENSION == TF180.DIMEN` `P_FINCS_USELECTION.MANDT == TF180.MANDT` `P_FINCS_USELECTION.CONSOLIDATIONGROUP == TF180.CONGR`
Consolidation Unit Dimension Consolidation Unit Client	`P_FINCS_USELECTION.CONSOLIDATIONDIMENSION == TF160.DIMEN` `P_FINCS_USELECTION.CONSOLIDATIONUNIT == TF160.BUNIT` `P_FINCS_USELECTION.MANDT == TF160.MANDT`
Controlling Area Controlling Area Client	`P_FINCS_USELECTION.CONTROLLINGAREA == TKA01.KOKRS` `P_FINCS_USELECTION.MANDT == TKA01.MANDT`
Cost Center ? Controlling Area Client Cost Center	`P_FINCS_USELECTION.[column in domain "DATBI"] == CSKS.DATBI` `P_FINCS_USELECTION.CONTROLLINGAREA == CSKS.KOKRS` `P_FINCS_USELECTION.MANDT == CSKS.MANDT` `P_FINCS_USELECTION.COSTCENTER == CSKS.KOSTL`
Customer Group Customer Group Client	`P_FINCS_USELECTION.CUSTOMERGROUP == T151.KDGRP` `P_FINCS_USELECTION.MANDT == T151.MANDT`
Country/Region Client Country/Region	`P_FINCS_USELECTION.MANDT == T005.MANDT` `P_FINCS_USELECTION.CUSTOMERSUPPLIERCOUNTRY == T005.LAND1`
Industry key Client Industry key	`P_FINCS_USELECTION.MANDT == T016.MANDT` `P_FINCS_USELECTION.CUSTOMERSUPPLIERINDUSTRY == T016.BRSCH`
Distribution Channel Client Distribution Channel	`P_FINCS_USELECTION.MANDT == TVTW.MANDT` `P_FINCS_USELECTION.DISTRIBUTIONCHANNEL == TVTW.VTWEG`
Financial Statement Item Consolidation Chart of Accounts Financial Statement Item Client	`P_FINCS_USELECTION.CONSOLIDATIONCHARTOFACCOUNTS == TF100.ITCLG` `P_FINCS_USELECTION.FINANCIALSTATEMENTITEM == TF100.ITEM` `P_FINCS_USELECTION.MANDT == TF100.MANDT`
Transaction type Client Transaction type	`P_FINCS_USELECTION.MANDT == T856.MANDT` `P_FINCS_USELECTION.FINANCIALTRANSACTIONTYPE == T856.TRTYP`
Functional Area Client Functional Area	`P_FINCS_USELECTION.MANDT == TFKB.MANDT` `P_FINCS_USELECTION.FUNCTIONALAREA == TFKB.FKBER`
G/L Account G/L Account Client Company Code	`P_FINCS_USELECTION.GLACCOUNT == SKB1.SAKNR` `P_FINCS_USELECTION.MANDT == SKB1.MANDT` `P_FINCS_USELECTION.COMPANYCODE == SKB1.BUKRS`
Internal Order Internal Order Client	`P_FINCS_USELECTION.INTERNALORDER == AUFK.AUFNR` `P_FINCS_USELECTION.MANDT == AUFK.MANDT`
Investee Unit Investee Unit Dimension Client	`P_FINCS_USELECTION.INVESTEECONSOLIDATIONUNIT == TF160.BUNIT` `P_FINCS_USELECTION.CONSOLIDATIONDIMENSION == TF160.DIMEN` `P_FINCS_USELECTION.MANDT == TF160.MANDT`
Material Group Client Material Group	`P_FINCS_USELECTION.MANDT == T023.MANDT` `P_FINCS_USELECTION.MATERIALGROUP == T023.MATKL`
Division Division Client	`P_FINCS_USELECTION.ORGANIZATIONDIVISION == TSPA.SPART` `P_FINCS_USELECTION.MANDT == TSPA.MANDT`
Partner Business Area Client Partner Business Area	`P_FINCS_USELECTION.MANDT == TGSB.MANDT` `P_FINCS_USELECTION.PARTNERBUSINESSAREA == TGSB.GSBER`
Partner Company Client Partner Company	`P_FINCS_USELECTION.MANDT == T880.MANDT` `P_FINCS_USELECTION.PARTNERCOMPANY == T880.RCOMP`
Partner Unit Dimension Partner Unit Client	`P_FINCS_USELECTION.CONSOLIDATIONDIMENSION == TF160.DIMEN` `P_FINCS_USELECTION.PARTNERCONSOLIDATIONUNIT == TF160.BUNIT` `P_FINCS_USELECTION.MANDT == TF160.MANDT`
Partner Cost Center ? Controlling Area Partner Cost Center Client	`P_FINCS_USELECTION.[column in domain "DATBI"] == CSKS.DATBI` `P_FINCS_USELECTION.CONTROLLINGAREA == CSKS.KOKRS` `P_FINCS_USELECTION.PARTNERCOSTCENTER == CSKS.KOSTL` `P_FINCS_USELECTION.MANDT == CSKS.MANDT`
Partner Functional Area Client Partner Functional Area	`P_FINCS_USELECTION.MANDT == TFKB.MANDT` `P_FINCS_USELECTION.PARTNERFUNCTIONALAREA == TFKB.FKBER`
Partner Profit Center ? Controlling Area Partner Profit Center Client	`P_FINCS_USELECTION.[column in domain "DATBI"] == CEPC.DATBI` `P_FINCS_USELECTION.CONTROLLINGAREA == CEPC.KOKRS` `P_FINCS_USELECTION.PARTNERPROFITCENTER == CEPC.PRCTR` `P_FINCS_USELECTION.MANDT == CEPC.MANDT`
Partner Segment for Segmental Reporting Client Partner Segment for Segmental Reporting	`P_FINCS_USELECTION.MANDT == FAGL_SEGM.MANDT` `P_FINCS_USELECTION.PARTNERSEGMENT == FAGL_SEGM.SEGMENT`
Plant Client Plant	`P_FINCS_USELECTION.MANDT == T001W.MANDT` `P_FINCS_USELECTION.PLANT == T001W.WERKS`
Profit Center ? Controlling Area Client Profit Center	`P_FINCS_USELECTION.[column in domain "DATBI"] == CEPC.DATBI` `P_FINCS_USELECTION.CONTROLLINGAREA == CEPC.KOKRS` `P_FINCS_USELECTION.MANDT == CEPC.MANDT` `P_FINCS_USELECTION.PROFITCENTER == CEPC.PRCTR`
Sales District Client Sales District	`P_FINCS_USELECTION.MANDT == T171.MANDT` `P_FINCS_USELECTION.SALESDISTRICT == T171.BZIRK`
Sales Organization Client Sales Organization	`P_FINCS_USELECTION.MANDT == TVKO.MANDT` `P_FINCS_USELECTION.SALESORGANIZATION == TVKO.VKORG`
Segment for Segmental Reporting Segment for Segmental Reporting Client	`P_FINCS_USELECTION.SEGMENT == FAGL_SEGM.SEGMENT` `P_FINCS_USELECTION.MANDT == FAGL_SEGM.MANDT`
Product Sold Group Client Product Sold Group	`P_FINCS_USELECTION.MANDT == T023.MANDT` `P_FINCS_USELECTION.SOLDPRODUCTGROUP == T023.MATKL`
Subitem Client Subitem Category Subitem	`P_FINCS_USELECTION.MANDT == TF115.MANDT` `P_FINCS_USELECTION.SUBITEMCATEGORY == TF115.SITYP` `P_FINCS_USELECTION.SUBITEM == TF115.SITEM`
Subitem Category Client Subitem Category	`P_FINCS_USELECTION.MANDT == TF110.MANDT` `P_FINCS_USELECTION.SUBITEMCATEGORY == TF110.SITYP`
Currency Key Client Currency Key	`P_FINCS_USELECTION.MANDT == TCURC.MANDT` `P_FINCS_USELECTION.TRANSACTIONCURRENCY == TCURC.WAERS`