SAP ABAP Table SBPBWBUDGET (Structure for Plan Data Transfer (Only Contains FM Fields))
Hierarchy
☛
EA-PS (Software Component) SAP Enterprise Extension Public Services
⤷ PSM-FM (Application Component) Funds Management
⤷ BPREP_BWRET (Package) Retraction: BW -> R/3
⤷ PSM-FM (Application Component) Funds Management
⤷ BPREP_BWRET (Package) Retraction: BW -> R/3
Basic Data
Table Category | INTTAB | Structure |
Structure | SBPBWBUDGET | Table Relationship Diagram |
Short Description | Structure for Plan Data Transfer (Only Contains FM Fields) |
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 | Header data for Entry document - Method Create | |||||
2 | FM_AREA | FIKRS | FIKRS | CHAR | 4 | 0 | Financial Management Area | FM01 | |
3 | VERSION | BUKU_VERSION | COVERSI | CHAR | 3 | 0 | Budget version | * | |
4 | DOCDATE | BP_BLDAT | DATUM | DATS | 8 | 0 | Document Date | ||
5 | PSTNG_DATE | BUDAT | DATUM | DATS | 8 | 0 | Posting Date in the Document | ||
6 | DOCTYPE | BUED_DOCTYPE | BUED_DOCTYPE | CHAR | 4 | 0 | Budget entry document type | FMEDDOCTYPE | |
7 | DOCSTATE | BUED_DOCSTATE | BUED_DOCSTATE | CHAR | 1 | 0 | Status of a budget entry document | ||
8 | PROCESS | BUKU_PROCESS_UI | BUKU_PROCESS_UI | CHAR | 4 | 0 | Budgeting Process | BUPROCESS_UI | |
9 | EXTERNAL_NUMBER | BUED_EXT_DOCNR | BELNR | CHAR | 10 | 0 | External Number for Budget Entry Document | ||
10 | .INCLUDE | 0 | 0 | Header additionnal data | |||||
11 | PERS_RESP | BP_VERANT | VERAB | CHAR | 20 | 0 | Person Responsible for Planning/Budgeting | ||
12 | HEADER_TEXT | BUED_HDTEXT | TEXT50 | CHAR | 50 | 0 | Header Text for Budget Entry Document | ||
13 | PUBLAW | FM_PUBLAW | FM_PUBLAW | CHAR | 20 | 0 | Public Law Cited | ||
14 | LEGIS | FM_LEGIS | FM_LEGIS | CHAR | 1 | 0 | Type of Legislation | ||
15 | COHORT | FM_COHORT | FM_COHORT | CHAR | 4 | 0 | Reporting Year for Cohort | ||
16 | TEXT_NAME | BP_TDNAM | CHAR32 | CHAR | 32 | 0 | Text Name | ||
17 | REF_ORG_UN | AWORG | AWORG | CHAR | 10 | 0 | Reference organisational units | ||
18 | REF_DOC | AWREF | AWREF | CHAR | 10 | 0 | Reference document number | ||
19 | OBJ_SYS | AWSYS | LOGSYS | CHAR | 10 | 0 | Logical system of source document | * | |
20 | OBJ_TYPE | AWTYP | AWTYP | CHAR | 5 | 0 | Reference procedure | * | |
21 | DOCFAM | BUED_DOCFAM | BELNR | CHAR | 10 | 0 | Document Family Number | ||
22 | DOC_YEAR | BUKU_DOCYEAR | GJAHR | NUMC | 4 | 0 | Document Year | ||
23 | DOCUMENT | BUED_DOCNR | BELNR | CHAR | 10 | 0 | Budget entry document number | ||
24 | GET_ITEM | BAPI_GET_ITEM | XFELD | CHAR | 1 | 0 | Item data required | ||
25 | GET_PERIOD | BAPI_GET_PERIOD | XFELD | CHAR | 1 | 0 | Period data required | ||
26 | GET_LONGTEXT | BAPI_GET_LONGTEXT | XFELD | CHAR | 1 | 0 | Long text required | ||
27 | GET_STDTEXT | BAPI_GET_STDTEXT | XFELD | CHAR | 1 | 0 | Standard text required | ||
28 | LANGUAGE | SYLANGU | SYLANGU | LANG | 1 | 0 | Language Key | ||
29 | BAPIMAXROW | BAPIMAXROW | SYST_LONG | INT4 | 10 | 0 | Maximum number of lines of hits | ||
30 | TESTRUN | TESTRUN | BAPIFLAG | CHAR | 1 | 0 | Switch to Simulation Session for Write BAPIs | ||
31 | .INCLUDE | 0 | 0 | Entry Document - Line item | |||||
32 | ITEM_NUM | BUED_DOCLN | DOCLN6 | CHAR | 6 | 0 | Budget entry document line | ||
33 | FISC_YEAR | GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
34 | BUDCAT | BUKU_BUDCAT | RLDNR | CHAR | 2 | 0 | Budget Category | * | |
35 | BUDTYPE | BUKU_BUDTYPE | CHAR4 | CHAR | 4 | 0 | Budget Type | ||
36 | FUND | BP_GEBER | BP_GEBER | CHAR | 10 | 0 | Fund | FMFINCODE | |
37 | FUNDS_CTR | FISTL | FISTL | CHAR | 16 | 0 | Funds Center | FMFCTR | |
38 | CMMT_ITEM | FM_FIPEX | FM_FIPEX | CHAR | 24 | 0 | Commitment item | FMCI | |
39 | FUNC_AREA | FM_FAREA | FKBER | CHAR | 16 | 0 | Functional Area | TFKB | |
40 | MEASURE | FM_MEASURE | FM_MEASURE | CHAR | 24 | 0 | Funded Program | * | |
41 | GRANT_NBR | GM_GRANT_NBR | GM_GRANT_NBR | CHAR | 20 | 0 | Grant | ||
42 | TRANS_CURR | TWAER | WAERS | CUKY | 5 | 0 | Transaction Currency | TCURC | |
43 | TRANS_CURR_ISO | ISOCD | ISOCD | CHAR | 3 | 0 | ISO currency code | ||
44 | TOTAL_AMOUNT | BAPICURR_D | BAPICURR | DEC | 23 | 4 | Currency amount in BAPI interfaces | ||
45 | DISTKEY | BUKU_SPRED | SPRED | CHAR | 4 | 0 | Distribution Key | T821S | |
46 | ITEM_TEXT | SGTXT | TEXT50 | CHAR | 50 | 0 | Item Text | ||
47 | VALTYPE | BUKU_VALTYPE | BUKU_VALTYPE | CHAR | 2 | 0 | BCS Value Type | * | |
48 | CASH_YEAR | GNJHR | GJAHR | NUMC | 4 | 0 | Year of Cash Effectivity | ||
49 | BUDGETING_PERIOD | BUKU_PERIOD | BUKU_PERIOD | NUMC | 3 | 0 | Budgeting period | ||
50 | PERIOD_AMOUNT | BAPICURR_D | BAPICURR | DEC | 23 | 4 | Currency amount in BAPI interfaces | ||
51 | .INCLUDE | 0 | 0 | Long text | |||||
52 | TEXT_ID | TDID | TDID | CHAR | 4 | 0 | Text ID | TTXID | |
53 | FORMAT_COL | TDFORMAT | TDELEMSTYL | CHAR | 2 | 0 | Tag column | ||
54 | TEXT_LINE | TDLINE | TDSTXLLINE | CHAR | 132 | 0 | Text Line | ||
55 | .INCLUDE | 0 | 0 | Ref. structure for BAPI parameter ExtensionIn/ExtensionOut | |||||
56 | STRUCTURE | TE_STRUC | AS4TAB | CHAR | 30 | 0 | Structure name of BAPI table extension | * | |
57 | VALUEPART1 | VALUEPART | CHAR240 | CHAR | 240 | 0 | Data part of BAPI extension parameter | ||
58 | VALUEPART2 | VALUEPART | CHAR240 | CHAR | 240 | 0 | Data part of BAPI extension parameter | ||
59 | VALUEPART3 | VALUEPART | CHAR240 | CHAR | 240 | 0 | Data part of BAPI extension parameter | ||
60 | VALUEPART4 | VALUEPART | CHAR240 | CHAR | 240 | 0 | Data part of BAPI extension parameter | ||
61 | OVERALL | BP_WGES | X | CHAR | 1 | 0 | Overall values too | ||
62 | AUTORELEASE | FM_BK_AUTORELEASE | X | CHAR | 1 | 0 | Automatic Release | ||
63 | RESPONSIBLE | BP_VERANT | VERAB | CHAR | 20 | 0 | Person Responsible for Planning/Budgeting | ||
64 | RPUBLAW | FM_PUBLAW | FM_PUBLAW | CHAR | 20 | 0 | Public Law Cited | ||
65 | RLEGIS | FM_LEGIS | FM_LEGIS | CHAR | 1 | 0 | Type of Legislation | ||
66 | RCOHORT | FM_COHORT | FM_COHORT | CHAR | 4 | 0 | Reporting Year for Cohort | ||
67 | AWTYP | AWTYP | AWTYP | CHAR | 5 | 0 | Reference procedure | * | |
68 | AWREF | AWREF | AWREF | CHAR | 10 | 0 | Reference document number | ||
69 | AWORG | AWORG | AWORG | CHAR | 10 | 0 | Reference organisational units | ||
70 | AWSYS | AWSYS | LOGSYS | CHAR | 10 | 0 | Logical system of source document | * | |
71 | VALUE_DATE | BD_VADAT | DATUM | DATS | 8 | 0 | Planning/budgeting value date | ||
72 | DOC_DATE | BP_BLDAT | DATUM | DATS | 8 | 0 | Document Date | ||
73 | POSTING_DATE | BUDAT | DATUM | DATS | 8 | 0 | Posting Date in the Document | ||
74 | POSTING_PERIOD | POPER | POPER | NUMC | 3 | 0 | Posting period | ||
75 | DOC_TEXT | SGTXT | TEXT50 | CHAR | 50 | 0 | Item Text | ||
76 | VALKEY | BP_VALKEY | BP_VALKEY | CHAR | 10 | 0 | Validation Key Budget/Planning | ||
77 | VALUE_TYPE | CO_WRTTP | CO_WRTTP | CHAR | 2 | 0 | Value Type | ||
78 | BDGT_TYPE | BP_VORGANG | ACTIVITY | CHAR | 4 | 0 | Budget Type Budgeting/Planning | * | |
79 | BDGT_SUBTYPE | BP_SUBVO | BP_SUBVO | CHAR | 4 | 0 | Budget Subtype | * | |
80 | COMMT_YEAR | GNJHR | GJAHR | NUMC | 4 | 0 | Year of Cash Effectivity | ||
81 | PERIOD | POPER | POPER | NUMC | 3 | 0 | Posting period | ||
82 | DISTR_KEY | SPRED | SPRED | CHAR | 4 | 0 | Distribution Key | * | |
83 | FAREA | FM_FAREA | FKBER | CHAR | 16 | 0 | Functional Area | * | |
84 | LNITEM_GROUP | FM_LNITEM_GROUP | FM_LNITEM_GROUP | NUMC | 3 | 0 | Doc. Line Items Grp | ||
85 | VALUE | BP_WERT3 | WERTV8 | CURR | 15 | 2 | Amount |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | SBPBWBUDGET | CMMT_ITEM | FMCI | GJAHR | |||
2 | SBPBWBUDGET | DISTKEY | T821S | SPRED | |||
3 | SBPBWBUDGET | DOCTYPE | FMEDDOCTYPE | DOCTYPE | |||
4 | SBPBWBUDGET | FM_AREA | FM01 | FIKRS | |||
5 | SBPBWBUDGET | FUNC_AREA | TFKB | FKBER | |||
6 | SBPBWBUDGET | FUND | FMFINCODE | FINCODE | |||
7 | SBPBWBUDGET | FUNDS_CTR | FMFCTR | FICTR | |||
8 | SBPBWBUDGET | PROCESS | BUPROCESS_UI | PROCESS_UI | |||
9 | SBPBWBUDGET | TEXT_ID | TTXID | TDID | |||
10 | SBPBWBUDGET | TRANS_CURR | TCURC | WAERS |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 462 |