SAP table PFM_TSUBD (Fund Center additional data - Sub-division)

SAP table PFM_TSUBD has 8 primary key fields being MANDT,MINIS,SECEST,CAPI,DIVI,SUBD,TORC,BEGDA.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
MINIS Ministry CHAR 2 0 PFM_TMINIS PFM_01MINISTERIO
SECEST Secretary of State CHAR 1 0 PFM_TSECEST PFM_01SEC_ESTADO
CAPI Chapter CHAR 2 0 PFM_TCAPI PFM_01CAPITULO
DIVI Business area CHAR 2 0 PFM_TDIVI PFM_01DIVISAO
SUBD Subdivision CHAR 2 0 PFM_01SUBDIVISAO
TORC Budget type CHAR 1 0 PFM_TORC
F Operation
I Investment
BEGDA Start Date DATS 8 0 BEGDA
ENDDA End Date DATS 8 0 ENDDA
DESCR Description CHAR 50 0 PFM_01DESCRICAO50

PFM_TSUBD foreign key relationships

Table Field Check Table Check Field
0 PFM_TSUBD CAPI PFM_TCAPI Fund Center additional data - Chapter MANDT
0 PFM_TSUBD CAPI PFM_TCAPI Fund Center additional data - Chapter MINIS
0 PFM_TSUBD CAPI PFM_TCAPI Fund Center additional data - Chapter CAPI
0 PFM_TSUBD CAPI PFM_TCAPI Fund Center additional data - Chapter BEGDA
1 PFM_TSUBD DIVI PFM_TDIVI Fund Center additional data - Division MANDT
1 PFM_TSUBD DIVI PFM_TDIVI Fund Center additional data - Division MINIS
1 PFM_TSUBD DIVI PFM_TDIVI Fund Center additional data - Division CAPI
1 PFM_TSUBD DIVI PFM_TDIVI Fund Center additional data - Division DIVI
1 PFM_TSUBD DIVI PFM_TDIVI Fund Center additional data - Division BEGDA
0 PFM_TSUBD MANDT T000 Clients MANDT
1 PFM_TSUBD MINIS PFM_TMINIS Fund Center Additional Data - Ministries MANDT
1 PFM_TSUBD MINIS PFM_TMINIS Fund Center Additional Data - Ministries MINIS
1 PFM_TSUBD MINIS PFM_TMINIS Fund Center Additional Data - Ministries BEGDA
0 PFM_TSUBD SECEST PFM_TSECEST Fund Center additional data - Secretaries of State MANDT
0 PFM_TSUBD SECEST PFM_TSECEST Fund Center additional data - Secretaries of State MINIS
0 PFM_TSUBD SECEST PFM_TSECEST Fund Center additional data - Secretaries of State BEGDA