SAP WRFT_BUDG_TYPE Budget Type Table
Overview
WRFT_BUDG_TYPE is a standard SAP S/4HANA table that stores Budget Type data. There are total 28 fields in the WRFT_BUDG_TYPE table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table WRFT_BUDG_TYPE belongs to Open-to-buy (LO-RFM-PUR-OTB) module and is located in the package Framework: Budget Processes (WRF_BUDGET).
In addition, following links provide an overview of foreign key relationships, if any, that link WRFT_BUDG_TYPE to other SAP tables and standard CDS views available based on WRFT_BUDG_TYPE table in S/4HANA 2020.
Techincal Settings of WRFT_BUDG_TYPE
Below are technical details of the table WRFT_BUDG_TYPE
- Buffering switched on
- Full table is passed to buffer
- Storage type is Column Store
List of WRFT_BUDG_TYPE Fields
The following table gives you an overview of the fields available in WRFT_BUDG_TYPE
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT | 3 |
| APPL | Application with Usage of Budget Function | WRF_BUDG_APPL | NUMC | 2 | |
| TYPE | Budget Type | WRF_BUDG_TYPE | CHAR | 2 | |
| DATE_FROM | Start Date of a Budget Planning Period | WRF_BUDG_DATE_FROM | DATS | 8 | |
| DATE_TO | End Date of a Budget Planning Period | WRF_BUDG_DATE_TO | DATS | 8 | |
| BUDG_LEVEL | Budget Level | WRF_BUDG_LEVEL | WRFT_BUDG_LEV | CHAR | 10 |
| KEYFIG_SET | Set of Key Figures | WRF_BUDG_KEYFIG_SET | WRFT_BUDG_KS | CHAR | 10 |
| TABNAME_PLAN | Table Name | WRF_BUDG_TABNAME | CHAR | 30 | |
| TABNAME_ACT | Table Name | WRF_BUDG_TABNAME | CHAR | 30 | |
| TABNAME_OS | Table Name | WRF_BUDG_TABNAME | CHAR | 30 | |
| TABNAME_UG | Table Name | WRF_BUDG_TABNAME | CHAR | 30 | |
| STATUS_BW | Status of Budget Type | WRF_BUDG_TYPE_STATUS | CHAR | 1 | |
| STATUS_R3 | Status of Budget Type | WRF_BUDG_TYPE_STATUS | CHAR | 1 | |
| BADI_IMPL | Business Add-In Implementation | EXIT_IMP | SXC_EXIT | CHAR | 20 |
| PRIO | Prioritization of Budget Value Cannot Be Uniquely Determined | WRF_BUDG_TYPE_PRIO | NUMC | 2 | |
| CURRENCY | Budget Currency | WRF_BUDG_CURRENCY | TCURC | CUKY | 5 |
| TS_DATE_TIME | Time Stamp: Date and Time | WRF_BUDG_DATE_TIME | DEC | 15 | |
| TS_PROG | ABAP Program Name | PROGRAMM | * | CHAR | 40 |
| TS_USER | User Name in User Master Record | XUBNAME | * | CHAR | 12 |
| TS_DATE_TIME_BW | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | RSTIMESTMP | DEC | 15 | |
| TS_PROG_BW | ABAP Program Name | PROGRAMM | * | CHAR | 40 |
| TS_USER_BW | CHAR12 for SYST | SYCHAR12 | CHAR | 12 | |
| CHECK_TYPE | Type of OTB Check | WRF_BUDG_OTB_CHECK | CHAR | 1 | |
| OTB_ALLOC | Indicator: OTB Allocation for Order Time Period | WRF_BUDG_OTB_ALLOC | CHAR | 1 | |
| DEAC_OP_DOC | Deactivate Budgets | WRF_BUDG_OTB_DEAC_OP_DOC | CHAR | 1 | |
| ORDER_PERIOD | Name of Info Object | WRF_BUDG_IO_NAME | CHAR | 30 | |
| OTB_COND_TYPE | OTB Condition Type | WRF_POTB_COND_TYPE | T685 | CHAR | 4 |
| SYS_EXTERNAL | External System | WRF_BUDG_TYPE_EXT | CHAR | 1 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for WRFT_BUDG_TYPE
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| WRFT_BUDG_TYPE | BADI_IMPL | : | SXC_EXIT |
| WRFT_BUDG_TYPE | BUDG_LEVEL | 1: CN | WRFT_BUDG_LEV |
| WRFT_BUDG_TYPE | CURRENCY | 1: CN | TCURC |
| WRFT_BUDG_TYPE | KEYFIG_SET | 1: CN | WRFT_BUDG_KS |
| WRFT_BUDG_TYPE | OTB_COND_TYPE | : | T685 |