I_FundsCenterBasic

Funds Center Basic | view: IFUNDSCENTERB | ATTR | Extraction: Full only | Component: Master Data

Tables used: FMFCTR

🔑 Keys (3)
💰 Amounts
∑ Quantities
📅 Dates (5)
☰ Categorical
Other (7)
🔗 Relations (13)

Column Name	Description
FinancialManagementArea FK	Financial Management Area
FundsCenter	Funds Center
ValidityEndDate	Funds Center Validity End Date

Column Name	Description

Column Name	Description

Column Name	Description
ValidityEndDate	Funds Center Validity End Date
ValidityStartDate	Funds Center Validity Start Date
CreationDate	Funds Center Created on Date
LastChangeDate	Funds Center Last Changed on Date
FundsCenterExpirationDate	Funds Center Expiration Date

Column Name	Description

Column Name	Description	Domain name
CreatedByUser	Funds Center Created by User	USNAM
LastChangeUser	Funds Center Last Changed by User	USNAM
FundsCenterResponsible	Funds Center Manager in Organization Model	HROBJID_12
FundsCenterManager	Funds Center Manager	HROBJID_12
FundsCenterResponsibleName	Name of Person Responsible	TEXT20
FundsCenterAuthznGrp	Funds Center Authorization Group	CHAR10
FndsCenterFinMgmtAreaForAuthzn	FM Area for Auth Grp for Funds Center	CHAR04

Master Data Relations	Join Conditions
Business Area Business Area Client	`I_FUNDSCENTERBASIC.BUSINESSAREA == TGSB.GSBER` `I_FUNDSCENTERBASIC.MANDT == TGSB.MANDT`
Company Code Client Company Code	`I_FUNDSCENTERBASIC.MANDT == T001.MANDT` `I_FUNDSCENTERBASIC.COMPANYCODE == T001.BUKRS`
FIFM: FM Area Financial Management Area Client	`I_FUNDSCENTERBASIC.FINANCIALMANAGEMENTAREA == FM01.FIKRS` `I_FUNDSCENTERBASIC.MANDT == FM01.MANDT`
Default Fund Value in a Funds Center Financial Management Area Default Fund Value in a Funds Center Client	`I_FUNDSCENTERBASIC.FINANCIALMANAGEMENTAREA == FMFINCODE.FIKRS` `I_FUNDSCENTERBASIC.FUNDSCENTERDEFAULTFUND == FMFINCODE.FINCODE` `I_FUNDSCENTERBASIC.MANDT == FMFINCODE.MANDT`
Fund Center organization Fund Center organization Client	`I_FUNDSCENTERBASIC.PT_FUNDCENTERORGANIZATION == PFM_01TP27.ORGAN` `I_FUNDSCENTERBASIC.MANDT == PFM_01TP27.MANDT`
Fund Center area Client Fund Center area	`I_FUNDSCENTERBASIC.MANDT == PFM_01TP25.MANDT` `I_FUNDSCENTERBASIC.PT_FUNDSCENTERAREA == PFM_01TP25.AREA`
Budget type Secretary of State Budget type Chapter ? Client Ministry Subdivision Business area	`I_FUNDSCENTERBASIC.PT_FUNDSCENTERSECRETARYOFSTATE == PFM_TSUBD.SECEST` `I_FUNDSCENTERBASIC.PT_FUNDSCENTERBUDGETTYPE == PFM_TSUBD.TORC` `I_FUNDSCENTERBASIC.PT_FUNDSCENTERCHAPTER == PFM_TSUBD.CAPI` `I_FUNDSCENTERBASIC.[column in domain "BEGDA"] == PFM_TSUBD.BEGDA` `I_FUNDSCENTERBASIC.MANDT == PFM_TSUBD.MANDT` `I_FUNDSCENTERBASIC.PT_FUNDSCENTERMINISTRY == PFM_TSUBD.MINIS` `I_FUNDSCENTERBASIC.PT_FUNDSCENTERSUBDIVISION == PFM_TSUBD.SUBD` `I_FUNDSCENTERBASIC.PT_FUNDSCENTERBUSINESSAREA == PFM_TSUBD.DIVI`
Business area Secretary of State Chapter ? Client Ministry Business area	`I_FUNDSCENTERBASIC.PT_FUNDSCENTERSECRETARYOFSTATE == PFM_TDIVI.SECEST` `I_FUNDSCENTERBASIC.PT_FUNDSCENTERCHAPTER == PFM_TDIVI.CAPI` `I_FUNDSCENTERBASIC.[column in domain "BEGDA"] == PFM_TDIVI.BEGDA` `I_FUNDSCENTERBASIC.MANDT == PFM_TDIVI.MANDT` `I_FUNDSCENTERBASIC.PT_FUNDSCENTERMINISTRY == PFM_TDIVI.MINIS` `I_FUNDSCENTERBASIC.PT_FUNDSCENTERBUSINESSAREA == PFM_TDIVI.DIVI`
Chapter Secretary of State Chapter ? Client Ministry	`I_FUNDSCENTERBASIC.PT_FUNDSCENTERSECRETARYOFSTATE == PFM_TCAPI.SECEST` `I_FUNDSCENTERBASIC.PT_FUNDSCENTERCHAPTER == PFM_TCAPI.CAPI` `I_FUNDSCENTERBASIC.[column in domain "BEGDA"] == PFM_TCAPI.BEGDA` `I_FUNDSCENTERBASIC.MANDT == PFM_TCAPI.MANDT` `I_FUNDSCENTERBASIC.PT_FUNDSCENTERMINISTRY == PFM_TCAPI.MINIS`
Ministry ? Client Ministry	`I_FUNDSCENTERBASIC.[column in domain "BEGDA"] == PFM_TMINIS.BEGDA` `I_FUNDSCENTERBASIC.MANDT == PFM_TMINIS.MANDT` `I_FUNDSCENTERBASIC.PT_FUNDSCENTERMINISTRY == PFM_TMINIS.MINIS`
Secretary of State Secretary of State ? Client Ministry	`I_FUNDSCENTERBASIC.PT_FUNDSCENTERSECRETARYOFSTATE == PFM_TSECEST.SECEST` `I_FUNDSCENTERBASIC.[column in domain "BEGDA"] == PFM_TSECEST.BEGDA` `I_FUNDSCENTERBASIC.MANDT == PFM_TSECEST.MANDT` `I_FUNDSCENTERBASIC.PT_FUNDSCENTERMINISTRY == PFM_TSECEST.MINIS`
Services and independent funds Services and independent funds Client	`I_FUNDSCENTERBASIC.PT_FUNDSCENTERSRVCINDEPFUNDS == PFM_01TP26.SERFA` `I_FUNDSCENTERBASIC.MANDT == PFM_01TP26.MANDT`
Subdivision Secretary of State Budget type Chapter ? Client Ministry Subdivision Business area	`I_FUNDSCENTERBASIC.PT_FUNDSCENTERSECRETARYOFSTATE == PFM_TSUBD.SECEST` `I_FUNDSCENTERBASIC.PT_FUNDSCENTERBUDGETTYPE == PFM_TSUBD.TORC` `I_FUNDSCENTERBASIC.PT_FUNDSCENTERCHAPTER == PFM_TSUBD.CAPI` `I_FUNDSCENTERBASIC.[column in domain "BEGDA"] == PFM_TSUBD.BEGDA` `I_FUNDSCENTERBASIC.MANDT == PFM_TSUBD.MANDT` `I_FUNDSCENTERBASIC.PT_FUNDSCENTERMINISTRY == PFM_TSUBD.MINIS` `I_FUNDSCENTERBASIC.PT_FUNDSCENTERSUBDIVISION == PFM_TSUBD.SUBD` `I_FUNDSCENTERBASIC.PT_FUNDSCENTERBUSINESSAREA == PFM_TSUBD.DIVI`