SAP ABAP Table FMBLEXTBS (Source for Budgets in Derivation Tool for BL Extensions)

Hierarchy

☛ EA-PS (Software Component) SAP Enterprise Extension Public Services
   ⤷ PSM-FM (Application Component) Funds Management
     ⤷ FMBL_EXT_E (Package) Budgetary Ledger Extensions

Basic Data

Table Category	INTTAB	Structure
Structure	FMBLEXTBS	Table Relationship Diagram
Short Description	Source for Budgets in Derivation Tool for BL Extensions

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	FM_AREA	☐	FIKRS	FIKRS	CHAR	4	0	Financial Management Area	FM01
2	FISC_YEAR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
3	CASH_YEAR	☐	GNJHR	GJAHR	NUMC	4	0	Year of Cash Effectivity
4	CATEGORY	☐	FM_BUCAT	FM_BUCAT	NUMC	1	0	Budget Category in Funds Management
5	TRANSAC	☐	BUKU_PROCESS_UI	BUKU_PROCESS_UI	CHAR	4	0	Budgeting Process	BUPROCESS_UI
6	COMP_CODE	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
7	VALUE_TYPE	☐	BUKU_VALTYPE	BUKU_VALTYPE	CHAR	2	0	BCS Value Type	BUVALTYPE
8	BDGT_SUBTYPE	☐	BUKU_BUDTYPE	CHAR4	CHAR	4	0	Budget Type
9	FUND	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
10	FUNDS_CTR	☐	FISTL	FISTL	CHAR	16	0	Funds Center	*
11	CMMT_ITEM	☐	FM_FIPEX	FM_FIPEX	CHAR	24	0	Commitment item	*
12	FUNC_AREA	☐	FKBER	FKBER	CHAR	16	0	Functional Area	TFKB
13	MEASURE	☐	FM_MEASURE	FM_MEASURE	CHAR	24	0	Funded Program	*
14	CISTRID	☐	FM_CISTRID	CHAR10	CHAR	10	0	Commitment Item Subdivision ID	FMMDSTRID
15	CISUB1	☐	FM_CISUB1	CHAR10	CHAR	10	0	Substring 1 of Commitment Item
16	CISUB2	☐	FM_CISUB2	CHAR10	CHAR	10	0	Substring 2 of Commitment Item
17	CISUB3	☐	FM_CISUB3	CHAR10	CHAR	10	0	Substring 3 of Commitment Item
18	CISUB4	☐	FM_CISUB4	CHAR10	CHAR	10	0	Substring 4 of Commitment Item
19	CISUB5	☐	FM_CISUB5	CHAR10	CHAR	10	0	Substring 5 of Commitment Item
20	FCSTRID	☐	FM_FCSTRID	CHAR10	CHAR	10	0	Funds Center Subdivision ID	FMMDSTRID
21	FCSUB1	☐	FM_FCSUB1	CHAR10	CHAR	10	0	Substring 1 of Funds Center
22	FCSUB2	☐	FM_FCSUB2	CHAR10	CHAR	10	0	Substring 2 of Funds Center
23	FCSUB3	☐	FM_FCSUB3	CHAR10	CHAR	10	0	Substring 3 of Funds Center
24	FDSTRID	☐	FM_FDSTRID	CHAR10	CHAR	10	0	Fund Subdivision ID	FMMDSTRID
25	FDSUB1	☐	FM_FDSUB1	CHAR10	CHAR	10	0	Substring 1 of Fund
26	FDSUB2	☐	FM_FDSUB2	CHAR10	CHAR	10	0	Substring 2 of Fund
27	FNSTRID	☐	FM_FNSTRID	CHAR10	CHAR	10	0	Functional Area Subdivision ID	FMMDSTRID
28	FNSUB1	☐	FM_FNSUB1	CHAR10	CHAR	10	0	Substring 1 of Functional Area
29	FNSUB2	☐	FM_FNSUB2	CHAR10	CHAR	10	0	Substring 2 of Functional Area
30	FNSUB3	☐	FM_FNSUB3	CHAR10	CHAR	10	0	Substring 3 of Functional Area
31	BLDOCSEQ	☐	FMBLDOCSEQ	NUM02	NUMC	2	0	Sequence of Budgetary Ledger Documents
32	TARGET1	☐	FMBLTARGET1	CHAR30	CHAR	30	0	First Intermediate Target for Derivation Tool
33	TARGET2	☐	FMBLTARGET2	CHAR30	CHAR	30	0	Second Intermediate Target for Derivation Tool
34	.INCLUDE	☐				0	0	Special fields for Budget BL derivation tool
35	DIFF_CASHFISC	☐	FMBLEXTCFY	NUMC2	NUMC	2	0	Difference between Year of Cash Effectivity and Fiscal Year
36	AMTSIGN	☐	FMBLEXTSIGN	FMBLEXTSIGN	CHAR	1	0	Amount Sign ( + or - )

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FMBLEXTBS	CISTRID	FMMDSTRID	STR_ID
2	FMBLEXTBS	COMP_CODE	T001	BUKRS
3	FMBLEXTBS	FCSTRID	FMMDSTRID	STR_ID
4	FMBLEXTBS	FDSTRID	FMMDSTRID	STR_ID
5	FMBLEXTBS	FM_AREA	FM01	FIKRS
6	FMBLEXTBS	FNSTRID	FMMDSTRID	STR_ID
7	FMBLEXTBS	FUNC_AREA	TFKB	FKBER
8	FMBLEXTBS	TRANSAC	BUPROCESS_UI	PROCESS_UI
9	FMBLEXTBS	VALUE_TYPE	BUVALTYPE	VALTYPE

History

Last changed by/on	SAP	20060703
SAP Release Created in	110