CKF_S_CE_SIMPLE_HIERARCHY SAP (Row Type for ALV Tree Costing Hierarchy) Structure details
Description: Row Type for ALV Tree Costing Hierarchy
Related tables to CKF_S_CE_SIMPLE_HIERARCHY
Access table CKF_S_CE_SIMPLE_HIERARCHY
Structure field list including key, data, relationships and ABAP select examples
CKF_S_CE_SIMPLE_HIERARCHY is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Row Type for ALV Tree Costing Hierarchy" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_CKF_S_CE_SIMPLE_HIERARCHY TYPE CKF_S_CE_SIMPLE_HIERARCHY.
The CKF_S_CE_SIMPLE_HIERARCHY table consists of various fields, each holding specific information or linking keys about Row Type for ALV Tree Costing Hierarchy data available in SAP. These include REF_OBJECT (Reference Object), COSTING_VARIANT (Costing Variant), COSTING_VERSION (Costing Version), CO_VERSION (Version).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified
SAP CKF_S_CE_SIMPLE_HIERARCHY structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
REF_OBJECT | Reference Object | CK_OBJ | CHAR | 1 | Assigned to domain | CK_OBJ | |||
COSTING_VARIANT | Costing Variant | CK_KLVAR | CHAR | 4 | Assigned to domain | KLVAR | KRT | ||
COSTING_VERSION | Costing Version | CK_TVERS | NUMC | 2 | CK_VERSION | VSN | |||
CO_VERSION | Version | VERSN | CHAR | 3 | Assigned to domain | ALPHA | COVERSI | KVS | |
DEF_CO_VERSION | New Input Values | XFLAG | CHAR | 1 | XFLAG | ||||
QUANTITY | Quantity | MENGE_POS | QUAN | 15(3) | CQUA8 | ||||
UNIT_OF_MEASURE | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
COSTING_SHEET | Costing Sheet for Calculating Overhead | CK_KALSM | CHAR | 6 | Assigned to domain | KALSM | |||
DEF_COSTING_SHEET | New Input Values | XFLAG | CHAR | 1 | XFLAG | ||||
OVERHEAD_KEY | Overhead key | AUFZSCHL | CHAR | 6 | CHAR6 | ||||
TEMPLATE | Template | ABC_TEMPL | CHAR | 10 | Assigned to domain | ABC_TEMPL | ABT | ||
CONTROLLING_AREA | Controlling Area | KOKRS | CHAR | 4 | Assigned to domain | CACCD | CAC | ||
COMPANY_CODE | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
PLANT | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
VALUATION_AREA | Valuation Area | BWKEY | CHAR | 4 | Assigned to domain | BWKEY | BWK | ||
PROFIT_CENTER | Profit Center | PRCTR | CHAR | 10 | Assigned to domain | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
DIVISION | Division | SPART | CHAR | 2 | Assigned to domain | SPART | SPA | C_SPART | |
BUSINESS_AREA | Business Area | GSBER | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
VALUATION_DATE | Valuation Date of a Cost Estimate | CK_BWDAT | DATS | 8 | CK_KADAT | ||||
QUANTITY_STRUCTURE_DATE | Quantity Structure Date for Costing | CK_BRDAT | DATS | 8 | CK_KADAT | ||||
DATE_FROM | Costing Date From | CK_ABDAT | DATS | 8 | CK_KADAT | KDA | |||
DATE_TO | Costing Date To | CK_BIDAT | DATS | 8 | CK_KADAT | KDB | |||
POSTING_DATE | Date on Which Cost Estimate Was Created | CK_CPUDT | DATS | 8 | DATUM | ||||
CHANGE_DATE | Date of last change | AENDT | DATS | 8 | DATUM | ||||
CLOSE_DATE | Close date | ABSDT | DATS | 8 | DATUM | ||||
POSTING_TIME | System Time | SYUZEIT | TIMS | 6 | SYTIME | ||||
DATE_FROM_ADD_ON_COSTS | Costing Date From | CK_ABDAT | DATS | 8 | CK_KADAT | KDA | |||
DATE_TO_ADD_ON_COSTS | Costing Date To | CK_BIDAT | DATS | 8 | CK_KADAT | KDB | |||
POSTING_DATE_ADD_ON_COSTS | Date on Which Additive Cost Estimate Was Saved | CK_CPUDM | DATS | 8 | DATUM | ||||
DATE_OF_RATES | Exchange Rate Date | KRSDT | DATS | 8 | DATUM | ||||
FISCAL_YEAR | Posting Date YYYY | BDATJ | NUMC | 4 | GJAHR | GJAHR | BDTJ | ||
POSTING_PERIOD | Posting period | POPER | NUMC | 3 | POPER | POPR | |||
OBJECT_CURRENCY | Object Currency | CK_OWAER | CUKY | 5 | Assigned to domain | WAERS | |||
OBJECT_CURRENCY_TYPE | Currency Type | CURRTYP | CHAR | 2 | CURRTYP | ||||
CO_AREA_CURRENCY | Controlling Area Currency | CK_KWAER | CUKY | 5 | Assigned to domain | WAERS | |||
CO_AREA_CURRENCY_TYPE | Currency Type | CURRTYP | CHAR | 2 | CURRTYP | ||||
TRANSACTION_CURRENCY | Transaction Currency | CK_TWAER | CUKY | 5 | Assigned to domain | WAERS | |||
TRANSACTION_CURRENCY_TYPE | Currency Type | CURRTYP | CHAR | 2 | CURRTYP | ||||
STATE | Costing Status | CK_FEH_STA | CHAR | 2 | CK_STATUS | FEHSTA | |||
NO_MESSAGES | Number of System Messages in Costing | CK_FEH_ANK | INT4 | 10 | CK_INT4 | ||||
MAX_MESSAGE_TYPE | Message Type | SYMSGTY | CHAR | 1 | SYCHAR01 | ||||
ERROR_MANAGEMENT_NUMBER | Error Management Number | CMF_NR | NUMC | 12 | NUMC12 | ||||
COSTED_BY_USER | Costed by User | CK_KALKUSR | CHAR | 12 | USNAM | ||||
CHANGED_BY_USER | Last changed by | AENNM | CHAR | 12 | USNAM | ||||
CLOSED_BY_USER | User ID of the person who closed the cost estimate | ABSNM | CHAR | 12 | USNAM | ||||
SPRAS | Language Key | SPRAS | LANG | 1 | Assigned to domain | ISOLA | SPRAS | SPR | H_T002 |
KTEXT | General Name | KTEXT | CHAR | 20 | TEXT20 | ||||
LTEXT | Description | KLTXT | CHAR | 40 | TEXT40 | ||||
EXTTX | Name of Ad Hoc Cost Estimate for External Object | CK_ADHOC_EXTTX | CHAR | 66 | PC_PATH | CK_ADHOC_EXTTEXT | |||
PARTNER | Partner number for costing | NKPRTN | NUMC | 6 | NUM6 | ||||
OBJECT_NUMBER | Object number | J_OBJNR | CHAR | 22 | Assigned to domain | J_OBJNR | ONR | ||
NUMBER_OF_ITEMS | Number of Costing Items | CK_PSANZ | NUMC | 5 | Assigned to domain | CK_POSNR | |||
COSTING_MODEL_VALUATION | Costing Model: Model Instance | CKI_MODELINSTANCE | NUMC | 15 | CKI_MODELINSTANCE | ||||
COSTING_MODEL | Costing Model | CK_COSTMODEL | CHAR | 10 | Assigned to domain | ABC_TEMPL | CK_COSTMODEL | ||
LOG_HANDLE | Application Log: Log Handle | BALLOGHNDL | CHAR | 22 | SYSUUID_22 | ||||
.INCLU--AP | 0 | ||||||||
TARGET_OW | Target OC | CKTC_TARGET_OW | CURR | 15(2) | WERTV8 | ||||
TARGET_HW | Target CAC | CKTC_TARGET_HW | CURR | 15(2) | WERTV8 | ||||
CHANCE_OW | Chance (in Object Currency) | CKTC_CHANCE_OW | CURR | 15(2) | WERTV8 | ||||
CHANCE_HW | Chance (in Controlling Area Currency) | CKTC_CHANCE_HW | CURR | 15(2) | WERTV8 | ||||
RISIKO_OW | Risk (in Object Currency) | CKTC_RISIKO_OW | CURR | 15(2) | WERTV8 | ||||
RISIKO_HW | Risk (in Controlling Area Currency) | CKTC_RISIKO_HW | CURR | 15(2) | WERTV8 | ||||
CMDGUID | GUID in 'RAW' format | GUID_16 | RAW | 16 | SYSUUID | ||||
FOCUS_GUID | Internal Identification of Focus Record | FOC_GUID | RAW | 16 | SYSUUID | ||||
ENTRY_GUID | Internal Identification for PVS Objects | PVS_GUID | RAW | 16 | SYSUUID | ||||
STRING | Free Characteristic | CKTC_STRING | CHAR | 20 | TEXT20 | ||||
CURTP | Currency and Valuation Type | CVTYP | CHAR | 2 | Assigned to domain | CVTYP | |||
CURRENCY | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
.INCLU-_PR | 0 | ||||||||
TOTAL_PR | PCP: Total Price | CK_PRICE_TOTAL | CURR | 15(2) | WERTV8 | ||||
FIXED_PR | PCP: Price Fixed | CK_PRICE_FIXED | CURR | 15(2) | WERTV8 | ||||
.INCLU-_PR | 0 | ||||||||
QUANTITY_PR | PCP: Price Unit (Base Quantity) of the Price | CK_PRICE_QUANTITY_UNIT | DEC | 5 | PACK3 | ||||
UNIT_OF_MEASURE_PR | Price Quantity Unit | PMEHT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
.INCLU-_VA | 0 | ||||||||
TOTAL_VA | PCP: Total Value | CK_VALUE_TOTAL | CURR | 15(2) | WERTV8 | ||||
FIXED_VA | PCP: Fixed Value | CK_VALUE_FIXED | CURR | 15(2) | WERTV8 | ||||
.INCLU-_DC | 0 | ||||||||
TOTAL_DC | PCP: Value Delta Profit - Legal View | CK_DELTA_C_TOTAL | CURR | 15(2) | WERTV8 | ||||
FIXED_DC | PCP: Value Fixed Delta Profit - Legal View | CK_DELTA_C_FIXED | CURR | 15(2) | WERTV8 | ||||
.INCLU-_DP | 0 | ||||||||
TOTAL_DP | PCP: Total Value Delta Profit - Profit Center View | CK_DELTA_PC_TOTAL | CURR | 15(2) | WERTV8 | ||||
FIXED_DP | PCP: Fixed Value Delta Profit - Profit Center View | CK_DELTA_PC_FIXED | CURR | 15(2) | WERTV8 | ||||
RATE_TYPE | Exchange Rate Type | KURST | CHAR | 4 | Assigned to domain | KURST | KUT | ||
SOURCE_CURRENCY | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
RATE1 | Exchange Rate | CKRATE | DEC | 16(8) | CKRATE | ||||
TRANSFER_CURRENCY | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
RATE2 | Exchange Rate | CKRATE | DEC | 16(8) | CKRATE |
Key field | Non-key field |
How do I retrieve data from SAP structure CKF_S_CE_SIMPLE_HIERARCHY using ABAP code?
As CKF_S_CE_SIMPLE_HIERARCHY is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on CKF_S_CE_SIMPLE_HIERARCHY as there is no data to select.How to access SAP table CKF_S_CE_SIMPLE_HIERARCHY
Within an ECC or HANA version of SAP you can also view further information about CKF_S_CE_SIMPLE_HIERARCHY and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects