SAP ABAP Table FMED_S_DRILLDOWN (Structure to search entry documents based on line data)
Hierarchy
☛
EA-PS (Software Component) SAP Enterprise Extension Public Services
⤷ PSM-FM-BCS-BU (Application Component) Budgeting
⤷ FMBPA_E (Package) New budgeting: FM application part
⤷ PSM-FM-BCS-BU (Application Component) Budgeting
⤷ FMBPA_E (Package) New budgeting: FM application part
Basic Data
Table Category | INTTAB | Structure |
Structure | FMED_S_DRILLDOWN | Table Relationship Diagram |
Short Description | Structure to search entry documents based on line data |
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 | .INCLUDE | 0 | 0 | Funds management budget header (entry documents) | |||||
2 | CLIENT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
3 | FM_AREA | FIKRS | FIKRS | CHAR | 4 | 0 | Financial Management Area | * | |
4 | DOCYEAR | BUKU_DOCYEAR | GJAHR | NUMC | 4 | 0 | Document Year | ||
5 | DOCNR | BUED_DOCNR | BELNR | CHAR | 10 | 0 | Budget entry document number | ||
6 | DOCFAM | BUED_DOCFAM | BELNR | CHAR | 10 | 0 | Document Family Number | ||
7 | TECHORG | BUKU_TECHORG | BUKU_TECHORG | CHAR | 10 | 0 | Original Application | BUTECHORG | |
8 | PROCESS_UI | BUKU_PROCESS_UI | BUKU_PROCESS_UI | CHAR | 4 | 0 | Budgeting Process | BUPROCESS_UI | |
9 | VERSION | BUKU_VERSION | COVERSI | CHAR | 3 | 0 | Budget version | * | |
10 | CRTUSER | BUKU_CRTUSER | USERNAME | CHAR | 12 | 0 | User who created the object | ||
11 | CRTDATE | BUKU_CRTDATE | DATE | DATS | 8 | 0 | Date on which the object was created | ||
12 | CRTTIME | BUKU_CRTTIME | TIME | TIMS | 6 | 0 | Time at which the object was created | ||
13 | DOCDATE | BP_BLDAT | DATUM | DATS | 8 | 0 | Document Date | ||
14 | POSTDATE | BUDAT | DATUM | DATS | 8 | 0 | Posting Date in the Document | ||
15 | RESPPERS | BP_VERANT | VERAB | CHAR | 20 | 0 | Person Responsible for Planning/Budgeting | ||
16 | TEXT50 | BUED_HDTEXT | TEXT50 | CHAR | 50 | 0 | Header Text for Budget Entry Document | ||
17 | TEXTNAME | BP_TDNAM | CHAR32 | CHAR | 32 | 0 | Text Name | ||
18 | LTXT_IND | BP_LTEXT | XFELD | CHAR | 1 | 0 | Long Text Exists | ||
19 | DOCSTATE | BUED_DOCSTATE | BUED_DOCSTATE | CHAR | 1 | 0 | Status of a budget entry document | ||
20 | REVSTATE | BP_RSTAT | BP_RSTAT | CHAR | 1 | 0 | Reversal status | ||
21 | REV_REFNR | BUED_REV_REFNR | BELNR | CHAR | 10 | 0 | Reversal Reference Document Number | ||
22 | DOCTYPE | BUED_DOCTYPE | BUED_DOCTYPE | CHAR | 4 | 0 | Budget entry document type | FMEDDOCTYPE | |
23 | LOGSYS | LOGSYS | LOGSYS | CHAR | 10 | 0 | Logical system | * | |
24 | COHORT | FM_COHORT | FM_COHORT | CHAR | 4 | 0 | Reporting Year for Cohort | ||
25 | PUBLAW | FM_PUBLAW | FM_PUBLAW | CHAR | 20 | 0 | Public Law Cited | ||
26 | LEGIS | FM_LEGIS | FM_LEGIS | CHAR | 1 | 0 | Type of Legislation | ||
27 | AWORG | AWORG | AWORG | CHAR | 10 | 0 | Reference organisational units | ||
28 | AWREF | AWREF | AWREF | CHAR | 10 | 0 | Reference document number | ||
29 | AWSYS | AWSYS | LOGSYS | CHAR | 10 | 0 | Logical system of source document | * | |
30 | AWTYP | AWTYP | AWTYP | CHAR | 5 | 0 | Reference procedure | * | |
31 | XBLNR | XBLNR1 | XBLNR1 | CHAR | 16 | 0 | Reference Document Number | ||
32 | LAYOUTVAR | FMLA_LAYOUTVAR | FMLA_LAYOUTVAR | CHAR | 6 | 0 | Layout variant - Layout management in budgeting | FMLA | |
33 | .INCLUDE | 0 | 0 | ||||||
34 | .INCLU--AP | 0 | 0 | F15 Append FMBH | |||||
35 | /SAPF15/STATUS | /SAPF15/STATUS | /SAPF15/STATUS | CHAR | 1 | 0 | Document Status | ||
36 | DOCLN | BUED_DOCLN | DOCLN6 | CHAR | 6 | 0 | Budget entry document line | ||
37 | CTEM_CATEGORY | FM_POTYP | FM_POTYP | NUMC | 1 | 0 | Commitment Item Category | ||
38 | FISCYEAR | GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
39 | CEFFYEAR | GNJHR | GJAHR | NUMC | 4 | 0 | Year of Cash Effectivity | ||
40 | FUND | BP_GEBER | BP_GEBER | CHAR | 10 | 0 | Fund | * | |
41 | FUNDSCTR | FISTL | FISTL | CHAR | 16 | 0 | Funds Center | * | |
42 | CMMTITEM | FM_FIPEX | FM_FIPEX | CHAR | 24 | 0 | Commitment item | * | |
43 | FUNCAREA | FM_FAREA | FKBER | CHAR | 16 | 0 | Functional Area | * | |
44 | GRANT_NBR | GM_GRANT_NBR | GM_GRANT_NBR | CHAR | 20 | 0 | Grant | ||
45 | MEASURE | FM_MEASURE | FM_MEASURE | CHAR | 24 | 0 | Funded Program | * | |
46 | USERDIM | FM_USERDIM | CHAR10 | CHAR | 10 | 0 | Customer Field for FM Actual and Commitment Data | ||
47 | BUDCAT | BUKU_BUDCAT | RLDNR | CHAR | 2 | 0 | Budget Category | * | |
48 | VALTYPE | BUKU_VALTYPE | BUKU_VALTYPE | CHAR | 2 | 0 | BCS Value Type | * | |
49 | PROCESS | BUKU_PROCESS | BUKU_PROCESS | CHAR | 4 | 0 | Internal Budgeting Process | * | |
50 | BUDTYPE | BUKU_BUDTYPE | CHAR4 | CHAR | 4 | 0 | Budget Type | ||
51 | TCURR | TWAER | WAERS | CUKY | 5 | 0 | Transaction Currency | * | |
52 | DISTKEY | SPRED | SPRED | CHAR | 4 | 0 | Distribution Key | * | |
53 | LINE_TEXT | SGTXT | TEXT50 | CHAR | 50 | 0 | Item Text | ||
54 | LVALUE | LVALXX9 | WERTV9 | CURR | 17 | 2 | Budget amount in local currency | ||
55 | BUDCATT | TEXT15 | TEXT15 | CHAR | 15 | 0 | Text (15 characters) | ||
56 | DOCSTATE_TXT | TEXT17 | TEXT17 | CHAR | 17 | 0 | Text (length 17) | ||
57 | REVSTATE_TXT | TEXT15 | TEXT15 | CHAR | 15 | 0 | Text (15 characters) | ||
58 | PROCESS_TXT | TEXT15 | TEXT15 | CHAR | 15 | 0 | Text (15 characters) | ||
59 | BUDTYPE_TXT | TEXT30 | TEXT30 | CHAR | 30 | 0 | Text (30 Characters) |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | FMED_S_DRILLDOWN | DOCTYPE | FMEDDOCTYPE | DOCTYPE | |||
2 | FMED_S_DRILLDOWN | LAYOUTVAR | FMLA | LAYOUTVAR | |||
3 | FMED_S_DRILLDOWN | PROCESS_UI | BUPROCESS_UI | PROCESS_UI | |||
4 | FMED_S_DRILLDOWN | TECHORG | BUTECHORG | TECHORG |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 200 |