I_CnsldtnFinStmntItemTP

Model: Financial Statement Item | view: ICSFSITEMTP | Extraction: Not supported | Component: Master Data

Tables used: FINCS_FSITEMT, FINCS_FSITEM, FINCS_FSITGTASGN, TF107AV, TF108A

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

Column Name	Description
ConsolidationChartOfAccounts	Consolidation Chart of Accounts
FinancialStatementItem	Financial Statement Item

Column Name	Description

Column Name	Description

Column Name	Description

Column Name	Description
FinancialStatementItemType	Financial Statement Item Type	Show values
IsConsolidationItem	Is Consolidation Item	Show values
FinancialStatementItemIsBlkd	Blocked for Posting	Show values
NetBalanceIsCarriedForward	Carry Forward Balances (For Statistical FS Items)	Show values

Column Name	Description	Domain name
CnsldtnChartOfAccountsForEdit	Consolidation Chart of Accounts	FC_ITCLG
FinancialStatementItemForEdit	Financial Statement Item	FINCS_FSI_ITEM
BreakdownCategory	Breakdown Category	FC_ITGRP
FSItemEliminationAttributeName	FS Item Attribute Value Name	FINCS_FSI_ATTRIBUTE_VALUE_NAME
FSItemCrcyTrnsltnAttributeName	FS Item Attribute Value Name	FINCS_FSI_ATTRIBUTE_VALUE_NAME
FSItemRoleName	FS Item Attribute Value Name	FINCS_FSI_ATTRIBUTE_VALUE_NAME
FSItemDataCollection	Data Collection Attribute	FINCS_FSI_ATTRIBUTE_VALUE_NAME
FSItemCashFlow	Cash Flow Attribute	FINCS_FSI_ATTRIBUTE_VALUE_NAME
FSItemScope	Scope Attribute	FINCS_FSI_ATTRIBUTE_VALUE_NAME
FSItemCustomerSpecific	Other Selection Attribute	FINCS_FSI_ATTRIBUTE_VALUE_NAME
EliminationTargetFSItem	Elimination Target Item	FC_ITEM
NCITargetFSItem	Non-Controlling Interest (NCI) Target Item	FC_ITEM
PlanningTargetFSItem	Planning Target Item	FC_ITEM
FSItemLink	URL	FINCS_LINK
FSItemLinkLabel	Label for Link	FINCS_LINK_LABEL
FinancialStatementItemText	Name	TEXT15
FinancialStatementItemMdmText	Description	TEXT50
FinancialStatementItemLongText	Long Description	TEXT_250

Master Data Relations	Join Conditions
FS Item Attribute Value ID FS Item Attribute Value ID FS Item Attribute Value ID FS Item Attribute Value ID FS Item Attribute Value ID FS Item Attribute Value ID FS Item Attribute Value ID FS Item Attribute Value ID ? Client	`I_CNSLDTNFINSTMNTITEMTP.FINANCIALSTATEMENTITEMROLE == TF107AV.IAVID` `I_CNSLDTNFINSTMNTITEMTP.FSITEMELIMINATIONATTRIBUTEID == TF107AV.IAVID` `I_CNSLDTNFINSTMNTITEMTP.FSITEMCUSTOMERSPECIFICID == TF107AV.IAVID` `I_CNSLDTNFINSTMNTITEMTP.FSITEMDATACOLLECTIONID == TF107AV.IAVID` `I_CNSLDTNFINSTMNTITEMTP.FSITEMCASHFLOWID == TF107AV.IAVID` `I_CNSLDTNFINSTMNTITEMTP.FSITEMCRCYTRNSLTNATTRIBUTEID == TF107AV.IAVID` `I_CNSLDTNFINSTMNTITEMTP.FSITEMSCOPEID == TF107AV.IAVID` `I_CNSLDTNFINSTMNTITEMTP.[column in domain "FC_IATID"] == TF107AV.IATID` `I_CNSLDTNFINSTMNTITEMTP.MANDT == TF107AV.MANDT`
FS Item Attribute Value ID FS Item Attribute Value ID FS Item Attribute Value ID FS Item Attribute Value ID FS Item Attribute Value ID FS Item Attribute Value ID FS Item Attribute Value ID FS Item Attribute Value ID ? Client	`I_CNSLDTNFINSTMNTITEMTP.FINANCIALSTATEMENTITEMROLE == TF107AV.IAVID` `I_CNSLDTNFINSTMNTITEMTP.FSITEMELIMINATIONATTRIBUTEID == TF107AV.IAVID` `I_CNSLDTNFINSTMNTITEMTP.FSITEMCUSTOMERSPECIFICID == TF107AV.IAVID` `I_CNSLDTNFINSTMNTITEMTP.FSITEMDATACOLLECTIONID == TF107AV.IAVID` `I_CNSLDTNFINSTMNTITEMTP.FSITEMCASHFLOWID == TF107AV.IAVID` `I_CNSLDTNFINSTMNTITEMTP.FSITEMCRCYTRNSLTNATTRIBUTEID == TF107AV.IAVID` `I_CNSLDTNFINSTMNTITEMTP.FSITEMSCOPEID == TF107AV.IAVID` `I_CNSLDTNFINSTMNTITEMTP.[column in domain "FC_IATID"] == TF107AV.IATID` `I_CNSLDTNFINSTMNTITEMTP.MANDT == TF107AV.MANDT`
FS Item Attribute Value ID FS Item Attribute Value ID FS Item Attribute Value ID FS Item Attribute Value ID FS Item Attribute Value ID FS Item Attribute Value ID FS Item Attribute Value ID FS Item Attribute Value ID ? Client	`I_CNSLDTNFINSTMNTITEMTP.FINANCIALSTATEMENTITEMROLE == TF107AV.IAVID` `I_CNSLDTNFINSTMNTITEMTP.FSITEMELIMINATIONATTRIBUTEID == TF107AV.IAVID` `I_CNSLDTNFINSTMNTITEMTP.FSITEMCUSTOMERSPECIFICID == TF107AV.IAVID` `I_CNSLDTNFINSTMNTITEMTP.FSITEMDATACOLLECTIONID == TF107AV.IAVID` `I_CNSLDTNFINSTMNTITEMTP.FSITEMCASHFLOWID == TF107AV.IAVID` `I_CNSLDTNFINSTMNTITEMTP.FSITEMCRCYTRNSLTNATTRIBUTEID == TF107AV.IAVID` `I_CNSLDTNFINSTMNTITEMTP.FSITEMSCOPEID == TF107AV.IAVID` `I_CNSLDTNFINSTMNTITEMTP.[column in domain "FC_IATID"] == TF107AV.IATID` `I_CNSLDTNFINSTMNTITEMTP.MANDT == TF107AV.MANDT`
FS Item Attribute Value ID FS Item Attribute Value ID FS Item Attribute Value ID FS Item Attribute Value ID FS Item Attribute Value ID FS Item Attribute Value ID FS Item Attribute Value ID FS Item Attribute Value ID ? Client	`I_CNSLDTNFINSTMNTITEMTP.FINANCIALSTATEMENTITEMROLE == TF107AV.IAVID` `I_CNSLDTNFINSTMNTITEMTP.FSITEMELIMINATIONATTRIBUTEID == TF107AV.IAVID` `I_CNSLDTNFINSTMNTITEMTP.FSITEMCUSTOMERSPECIFICID == TF107AV.IAVID` `I_CNSLDTNFINSTMNTITEMTP.FSITEMDATACOLLECTIONID == TF107AV.IAVID` `I_CNSLDTNFINSTMNTITEMTP.FSITEMCASHFLOWID == TF107AV.IAVID` `I_CNSLDTNFINSTMNTITEMTP.FSITEMCRCYTRNSLTNATTRIBUTEID == TF107AV.IAVID` `I_CNSLDTNFINSTMNTITEMTP.FSITEMSCOPEID == TF107AV.IAVID` `I_CNSLDTNFINSTMNTITEMTP.[column in domain "FC_IATID"] == TF107AV.IATID` `I_CNSLDTNFINSTMNTITEMTP.MANDT == TF107AV.MANDT`
FS Item Attribute Value ID FS Item Attribute Value ID FS Item Attribute Value ID FS Item Attribute Value ID FS Item Attribute Value ID FS Item Attribute Value ID FS Item Attribute Value ID FS Item Attribute Value ID ? Client	`I_CNSLDTNFINSTMNTITEMTP.FINANCIALSTATEMENTITEMROLE == TF107AV.IAVID` `I_CNSLDTNFINSTMNTITEMTP.FSITEMELIMINATIONATTRIBUTEID == TF107AV.IAVID` `I_CNSLDTNFINSTMNTITEMTP.FSITEMCUSTOMERSPECIFICID == TF107AV.IAVID` `I_CNSLDTNFINSTMNTITEMTP.FSITEMDATACOLLECTIONID == TF107AV.IAVID` `I_CNSLDTNFINSTMNTITEMTP.FSITEMCASHFLOWID == TF107AV.IAVID` `I_CNSLDTNFINSTMNTITEMTP.FSITEMCRCYTRNSLTNATTRIBUTEID == TF107AV.IAVID` `I_CNSLDTNFINSTMNTITEMTP.FSITEMSCOPEID == TF107AV.IAVID` `I_CNSLDTNFINSTMNTITEMTP.[column in domain "FC_IATID"] == TF107AV.IATID` `I_CNSLDTNFINSTMNTITEMTP.MANDT == TF107AV.MANDT`
FS Item Attribute Value ID FS Item Attribute Value ID FS Item Attribute Value ID FS Item Attribute Value ID FS Item Attribute Value ID FS Item Attribute Value ID FS Item Attribute Value ID FS Item Attribute Value ID ? Client	`I_CNSLDTNFINSTMNTITEMTP.FINANCIALSTATEMENTITEMROLE == TF107AV.IAVID` `I_CNSLDTNFINSTMNTITEMTP.FSITEMELIMINATIONATTRIBUTEID == TF107AV.IAVID` `I_CNSLDTNFINSTMNTITEMTP.FSITEMCUSTOMERSPECIFICID == TF107AV.IAVID` `I_CNSLDTNFINSTMNTITEMTP.FSITEMDATACOLLECTIONID == TF107AV.IAVID` `I_CNSLDTNFINSTMNTITEMTP.FSITEMCASHFLOWID == TF107AV.IAVID` `I_CNSLDTNFINSTMNTITEMTP.FSITEMCRCYTRNSLTNATTRIBUTEID == TF107AV.IAVID` `I_CNSLDTNFINSTMNTITEMTP.FSITEMSCOPEID == TF107AV.IAVID` `I_CNSLDTNFINSTMNTITEMTP.[column in domain "FC_IATID"] == TF107AV.IATID` `I_CNSLDTNFINSTMNTITEMTP.MANDT == TF107AV.MANDT`
FS Item Attribute Value ID FS Item Attribute Value ID FS Item Attribute Value ID FS Item Attribute Value ID FS Item Attribute Value ID FS Item Attribute Value ID FS Item Attribute Value ID FS Item Attribute Value ID ? Client	`I_CNSLDTNFINSTMNTITEMTP.FINANCIALSTATEMENTITEMROLE == TF107AV.IAVID` `I_CNSLDTNFINSTMNTITEMTP.FSITEMELIMINATIONATTRIBUTEID == TF107AV.IAVID` `I_CNSLDTNFINSTMNTITEMTP.FSITEMCUSTOMERSPECIFICID == TF107AV.IAVID` `I_CNSLDTNFINSTMNTITEMTP.FSITEMDATACOLLECTIONID == TF107AV.IAVID` `I_CNSLDTNFINSTMNTITEMTP.FSITEMCASHFLOWID == TF107AV.IAVID` `I_CNSLDTNFINSTMNTITEMTP.FSITEMCRCYTRNSLTNATTRIBUTEID == TF107AV.IAVID` `I_CNSLDTNFINSTMNTITEMTP.FSITEMSCOPEID == TF107AV.IAVID` `I_CNSLDTNFINSTMNTITEMTP.[column in domain "FC_IATID"] == TF107AV.IATID` `I_CNSLDTNFINSTMNTITEMTP.MANDT == TF107AV.MANDT`