Search SAP tables
Structure field list including key, data, relationships and ABAP select examples OBJ_VAR_ALV 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 "Variances, Results List (ALV Format)" 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_OBJ_VAR_ALV TYPE OBJ_VAR_ALV.
The OBJ_VAR_ALV table consists of various fields, each holding specific information or linking keys about Variances, Results List (ALV Format) data available in SAP. These include OBJNR (Object number), GJAHR (Fiscal Year), PERIOD (Period), VERSN (Target Cost 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: Can be enhanced (character-type or numeric)
SAP OBJ_VAR_ALV 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
OBJNR Object number J_OBJNR CHAR 22 Assigned to domain J_OBJNR ONR GJAHR Fiscal Year GJAHR NUMC 4 GJAHR GJAHR GJR PERIOD Period CO_PERIO NUMC 3 PERBL VPE VERSN Target Cost Version AWVRS CHAR 3 Assigned to domain ALPHA AWVRS VAV CURRTYP Currency Type CURRTYP CHAR 2 CURRTYP VALUTYP Valuation View VALUTYP NUMC 1 VALUTYP VTP WAERS Currency Key WAERS CUKY 5 Assigned to domain WAERS FWS KSTAR Cost Element KSTAR CHAR 10 Assigned to domain ALPHA KSTAR KAT HRKFT CO key subnumber CO_SUBKEY CHAR 14 Assigned to domain CO_SUBKEY PAROB Partner Object PAROB CHAR 22 Assigned to domain J_OBJNR USPOB Source Object (Cost Center/Activity Type) USPOB CHAR 22 Assigned to domain J_OBJNR VRGNG CO Business Transaction CO_VORGANG CHAR 4 Assigned to domain J_VORGANG BEKNZ Debit/credit indicator BEKNZ CHAR 1 BEKNZ BEKNZ AWBEL Variances: Debit/Credit AWBEL CHAR 1 AWBEL MEINH Unit of Measure for Display MEINH UNIT 3 Assigned to domain CUNIT MEINS .INCLU-_RF 0 CST_T_RF Total Costs OBJ_COSTS_TOTAL CURR 15(2) WERTV8 CST_F_RF Fixed Costs OBJ_COSTS_FIXED CURR 15(2) WERTV8 CST_V_RF Variable Costs OBJ_COSTS_VARIABLE CURR 15(2) WERTV8 CALCULATED_RF Category Calculated OBJ_CALCULATED CHAR 1 OBJ_CALCULATED_STATUS .INCLU-_RF 0 QTY_T_RF Quantity, Total OBJ_ALV_QUANTITY_TOTAL QUAN 15(3) MENGV8 QTY_F_RF Quantity, Fixed OBJ_ALV_QUANTITY_FIXED QUAN 15(3) MENGV8 QTY_V_RF Quantity, Variable OBJ_ALV_QUANTITY_VARIABLE QUAN 15(3) MENGV8 .INCLU-_CT 0 CST_T_CT Total Costs OBJ_COSTS_TOTAL CURR 15(2) WERTV8 CST_F_CT Fixed Costs OBJ_COSTS_FIXED CURR 15(2) WERTV8 CST_V_CT Variable Costs OBJ_COSTS_VARIABLE CURR 15(2) WERTV8 CALCULATED_CT Category Calculated OBJ_CALCULATED CHAR 1 OBJ_CALCULATED_STATUS .INCLU-_CT 0 QTY_T_CT Quantity, Total OBJ_ALV_QUANTITY_TOTAL QUAN 15(3) MENGV8 QTY_F_CT Quantity, Fixed OBJ_ALV_QUANTITY_FIXED QUAN 15(3) MENGV8 QTY_V_CT Quantity, Variable OBJ_ALV_QUANTITY_VARIABLE QUAN 15(3) MENGV8 .INCLU-_SC 0 CST_T_SC Total Costs OBJ_COSTS_TOTAL CURR 15(2) WERTV8 CST_F_SC Fixed Costs OBJ_COSTS_FIXED CURR 15(2) WERTV8 CST_V_SC Variable Costs OBJ_COSTS_VARIABLE CURR 15(2) WERTV8 CALCULATED_SC Category Calculated OBJ_CALCULATED CHAR 1 OBJ_CALCULATED_STATUS .INCLU-_SC 0 QTY_T_SC Quantity, Total OBJ_ALV_QUANTITY_TOTAL QUAN 15(3) MENGV8 QTY_F_SC Quantity, Fixed OBJ_ALV_QUANTITY_FIXED QUAN 15(3) MENGV8 QTY_V_SC Quantity, Variable OBJ_ALV_QUANTITY_VARIABLE QUAN 15(3) MENGV8 .INCLU-_WP 0 CST_T_WP Total Costs OBJ_COSTS_TOTAL CURR 15(2) WERTV8 CST_F_WP Fixed Costs OBJ_COSTS_FIXED CURR 15(2) WERTV8 CST_V_WP Variable Costs OBJ_COSTS_VARIABLE CURR 15(2) WERTV8 CALCULATED_WP Category Calculated OBJ_CALCULATED CHAR 1 OBJ_CALCULATED_STATUS .INCLU-_WP 0 QTY_T_WP Quantity, Total OBJ_ALV_QUANTITY_TOTAL QUAN 15(3) MENGV8 QTY_F_WP Quantity, Fixed OBJ_ALV_QUANTITY_FIXED QUAN 15(3) MENGV8 QTY_V_WP Quantity, Variable OBJ_ALV_QUANTITY_VARIABLE QUAN 15(3) MENGV8 .INCLU-_P1 0 CST_T_P1 Total Costs OBJ_COSTS_TOTAL CURR 15(2) WERTV8 CST_F_P1 Fixed Costs OBJ_COSTS_FIXED CURR 15(2) WERTV8 CST_V_P1 Variable Costs OBJ_COSTS_VARIABLE CURR 15(2) WERTV8 CST_LF_P1 Lot-Size-Independent Costs OBJ_COSTS_LOT_FIXED CURR 15(2) WERTV8 CST_LV_P1 Lot-Size-Dependent Costs OBJ_COSTS_LOT_VARIABLE CURR 15(2) WERTV8 CALCULATED_P1 Category Calculated OBJ_CALCULATED CHAR 1 OBJ_CALCULATED_STATUS .INCLU-_P1 0 QTY_T_P1 Quantity, Total OBJ_ALV_QUANTITY_TOTAL QUAN 15(3) MENGV8 QTY_F_P1 Quantity, Fixed OBJ_ALV_QUANTITY_FIXED QUAN 15(3) MENGV8 QTY_V_P1 Quantity, Variable OBJ_ALV_QUANTITY_VARIABLE QUAN 15(3) MENGV8 .INCLU-_P2 0 CST_T_P2 Total Costs OBJ_COSTS_TOTAL CURR 15(2) WERTV8 CST_F_P2 Fixed Costs OBJ_COSTS_FIXED CURR 15(2) WERTV8 CST_V_P2 Variable Costs OBJ_COSTS_VARIABLE CURR 15(2) WERTV8 CST_LF_P2 Lot-Size-Independent Costs OBJ_COSTS_LOT_FIXED CURR 15(2) WERTV8 CST_LV_P2 Lot-Size-Dependent Costs OBJ_COSTS_LOT_VARIABLE CURR 15(2) WERTV8 CALCULATED_P2 Category Calculated OBJ_CALCULATED CHAR 1 OBJ_CALCULATED_STATUS .INCLU-_P2 0 QTY_T_P2 Quantity, Total OBJ_ALV_QUANTITY_TOTAL QUAN 15(3) MENGV8 QTY_F_P2 Quantity, Fixed OBJ_ALV_QUANTITY_FIXED QUAN 15(3) MENGV8 QTY_V_P2 Quantity, Variable OBJ_ALV_QUANTITY_VARIABLE QUAN 15(3) MENGV8 .INCLU-_P3 0 CST_T_P3 Total Costs OBJ_COSTS_TOTAL CURR 15(2) WERTV8 CST_F_P3 Fixed Costs OBJ_COSTS_FIXED CURR 15(2) WERTV8 CST_V_P3 Variable Costs OBJ_COSTS_VARIABLE CURR 15(2) WERTV8 CST_LF_P3 Lot-Size-Independent Costs OBJ_COSTS_LOT_FIXED CURR 15(2) WERTV8 CST_LV_P3 Lot-Size-Dependent Costs OBJ_COSTS_LOT_VARIABLE CURR 15(2) WERTV8 CALCULATED_P3 Category Calculated OBJ_CALCULATED CHAR 1 OBJ_CALCULATED_STATUS .INCLU-_P3 0 QTY_T_P3 Quantity, Total OBJ_ALV_QUANTITY_TOTAL QUAN 15(3) MENGV8 QTY_F_P3 Quantity, Fixed OBJ_ALV_QUANTITY_FIXED QUAN 15(3) MENGV8 QTY_V_P3 Quantity, Variable OBJ_ALV_QUANTITY_VARIABLE QUAN 15(3) MENGV8 .INCLU-_T1 0 CST_T_T1 Total Costs OBJ_COSTS_TOTAL CURR 15(2) WERTV8 CST_F_T1 Fixed Costs OBJ_COSTS_FIXED CURR 15(2) WERTV8 CST_V_T1 Variable Costs OBJ_COSTS_VARIABLE CURR 15(2) WERTV8 CST_LF_T1 Lot-Size-Independent Costs OBJ_COSTS_LOT_FIXED CURR 15(2) WERTV8 CST_LV_T1 Lot-Size-Dependent Costs OBJ_COSTS_LOT_VARIABLE CURR 15(2) WERTV8 CALCULATED_T1 Category Calculated OBJ_CALCULATED CHAR 1 OBJ_CALCULATED_STATUS .INCLU-_T1 0 QTY_T_T1 Quantity, Total OBJ_ALV_QUANTITY_TOTAL QUAN 15(3) MENGV8 QTY_F_T1 Quantity, Fixed OBJ_ALV_QUANTITY_FIXED QUAN 15(3) MENGV8 QTY_V_T1 Quantity, Variable OBJ_ALV_QUANTITY_VARIABLE QUAN 15(3) MENGV8 .INCLU-_T2 0 CST_T_T2 Total Costs OBJ_COSTS_TOTAL CURR 15(2) WERTV8 CST_F_T2 Fixed Costs OBJ_COSTS_FIXED CURR 15(2) WERTV8 CST_V_T2 Variable Costs OBJ_COSTS_VARIABLE CURR 15(2) WERTV8 CST_LF_T2 Lot-Size-Independent Costs OBJ_COSTS_LOT_FIXED CURR 15(2) WERTV8 CST_LV_T2 Lot-Size-Dependent Costs OBJ_COSTS_LOT_VARIABLE CURR 15(2) WERTV8 CALCULATED_T2 Category Calculated OBJ_CALCULATED CHAR 1 OBJ_CALCULATED_STATUS .INCLU-_T3 0 CST_T_T3 Total Costs OBJ_COSTS_TOTAL CURR 15(2) WERTV8 CST_F_T3 Fixed Costs OBJ_COSTS_FIXED CURR 15(2) WERTV8 CST_V_T3 Variable Costs OBJ_COSTS_VARIABLE CURR 15(2) WERTV8 CST_LF_T3 Lot-Size-Independent Costs OBJ_COSTS_LOT_FIXED CURR 15(2) WERTV8 CST_LV_T3 Lot-Size-Dependent Costs OBJ_COSTS_LOT_VARIABLE CURR 15(2) WERTV8 CALCULATED_T3 Category Calculated OBJ_CALCULATED CHAR 1 OBJ_CALCULATED_STATUS .INCLU-_TR 0 CST_T_TR Total Costs OBJ_COSTS_TOTAL CURR 15(2) WERTV8 CST_F_TR Fixed Costs OBJ_COSTS_FIXED CURR 15(2) WERTV8 CST_V_TR Variable Costs OBJ_COSTS_VARIABLE CURR 15(2) WERTV8 CALCULATED_TR Category Calculated OBJ_CALCULATED CHAR 1 OBJ_CALCULATED_STATUS .INCLU-_01 0 CST_T_01 Total Costs OBJ_COSTS_TOTAL CURR 15(2) WERTV8 CST_F_01 Fixed Costs OBJ_COSTS_FIXED CURR 15(2) WERTV8 CST_V_01 Variable Costs OBJ_COSTS_VARIABLE CURR 15(2) WERTV8 CALCULATED_01 Category Calculated OBJ_CALCULATED CHAR 1 OBJ_CALCULATED_STATUS .INCLU-_02 0 CST_T_02 Total Costs OBJ_COSTS_TOTAL CURR 15(2) WERTV8 CST_F_02 Fixed Costs OBJ_COSTS_FIXED CURR 15(2) WERTV8 CST_V_02 Variable Costs OBJ_COSTS_VARIABLE CURR 15(2) WERTV8 CALCULATED_02 Category Calculated OBJ_CALCULATED CHAR 1 OBJ_CALCULATED_STATUS .INCLU-_03 0 CST_T_03 Total Costs OBJ_COSTS_TOTAL CURR 15(2) WERTV8 CST_F_03 Fixed Costs OBJ_COSTS_FIXED CURR 15(2) WERTV8 CST_V_03 Variable Costs OBJ_COSTS_VARIABLE CURR 15(2) WERTV8 CALCULATED_03 Category Calculated OBJ_CALCULATED CHAR 1 OBJ_CALCULATED_STATUS .INCLU-_04 0 CST_T_04 Total Costs OBJ_COSTS_TOTAL CURR 15(2) WERTV8 CST_F_04 Fixed Costs OBJ_COSTS_FIXED CURR 15(2) WERTV8 CST_V_04 Variable Costs OBJ_COSTS_VARIABLE CURR 15(2) WERTV8 CALCULATED_04 Category Calculated OBJ_CALCULATED CHAR 1 OBJ_CALCULATED_STATUS .INCLU-_05 0 CST_T_05 Total Costs OBJ_COSTS_TOTAL CURR 15(2) WERTV8 CST_F_05 Fixed Costs OBJ_COSTS_FIXED CURR 15(2) WERTV8 CST_V_05 Variable Costs OBJ_COSTS_VARIABLE CURR 15(2) WERTV8 CALCULATED_05 Category Calculated OBJ_CALCULATED CHAR 1 OBJ_CALCULATED_STATUS .INCLU-_06 0 CST_T_06 Total Costs OBJ_COSTS_TOTAL CURR 15(2) WERTV8 CST_F_06 Fixed Costs OBJ_COSTS_FIXED CURR 15(2) WERTV8 CST_V_06 Variable Costs OBJ_COSTS_VARIABLE CURR 15(2) WERTV8 CALCULATED_06 Category Calculated OBJ_CALCULATED CHAR 1 OBJ_CALCULATED_STATUS .INCLU-_07 0 CST_T_07 Total Costs OBJ_COSTS_TOTAL CURR 15(2) WERTV8 CST_F_07 Fixed Costs OBJ_COSTS_FIXED CURR 15(2) WERTV8 CST_V_07 Variable Costs OBJ_COSTS_VARIABLE CURR 15(2) WERTV8 CALCULATED_07 Category Calculated OBJ_CALCULATED CHAR 1 OBJ_CALCULATED_STATUS .INCLU-_08 0 CST_T_08 Total Costs OBJ_COSTS_TOTAL CURR 15(2) WERTV8 CST_F_08 Fixed Costs OBJ_COSTS_FIXED CURR 15(2) WERTV8 CST_V_08 Variable Costs OBJ_COSTS_VARIABLE CURR 15(2) WERTV8 CALCULATED_08 Category Calculated OBJ_CALCULATED CHAR 1 OBJ_CALCULATED_STATUS .INCLU-_09 0 CST_T_09 Total Costs OBJ_COSTS_TOTAL CURR 15(2) WERTV8 CST_F_09 Fixed Costs OBJ_COSTS_FIXED CURR 15(2) WERTV8 CST_V_09 Variable Costs OBJ_COSTS_VARIABLE CURR 15(2) WERTV8 CALCULATED_09 Category Calculated OBJ_CALCULATED CHAR 1 OBJ_CALCULATED_STATUS .INCLU-_10 0 CST_T_10 Total Costs OBJ_COSTS_TOTAL CURR 15(2) WERTV8 CST_F_10 Fixed Costs OBJ_COSTS_FIXED CURR 15(2) WERTV8 CST_V_10 Variable Costs OBJ_COSTS_VARIABLE CURR 15(2) WERTV8 CALCULATED_10 Category Calculated OBJ_CALCULATED CHAR 1 OBJ_CALCULATED_STATUS .INCLU-_AC 0 CST_T_AC Total Costs OBJ_COSTS_TOTAL CURR 15(2) WERTV8 CST_F_AC Fixed Costs OBJ_COSTS_FIXED CURR 15(2) WERTV8 CST_V_AC Variable Costs OBJ_COSTS_VARIABLE CURR 15(2) WERTV8 CALCULATED_AC Category Calculated OBJ_CALCULATED CHAR 1 OBJ_CALCULATED_STATUS .INCLU-_TM 0 CST_T_TM Total Costs OBJ_COSTS_TOTAL CURR 15(2) WERTV8 CST_F_TM Fixed Costs OBJ_COSTS_FIXED CURR 15(2) WERTV8 CST_V_TM Variable Costs OBJ_COSTS_VARIABLE CURR 15(2) WERTV8 CALCULATED_TM Category Calculated OBJ_CALCULATED CHAR 1 OBJ_CALCULATED_STATUS .INCLU-_VI 0 CST_T_VI Total Costs OBJ_COSTS_TOTAL CURR 15(2) WERTV8 CST_F_VI Fixed Costs OBJ_COSTS_FIXED CURR 15(2) WERTV8 CST_V_VI Variable Costs OBJ_COSTS_VARIABLE CURR 15(2) WERTV8 CALCULATED_VI Category Calculated OBJ_CALCULATED CHAR 1 OBJ_CALCULATED_STATUS .INCLU-_VO 0 CST_T_VO Total Costs OBJ_COSTS_TOTAL CURR 15(2) WERTV8 CST_F_VO Fixed Costs OBJ_COSTS_FIXED CURR 15(2) WERTV8 CST_V_VO Variable Costs OBJ_COSTS_VARIABLE CURR 15(2) WERTV8 CALCULATED_VO Category Calculated OBJ_CALCULATED CHAR 1 OBJ_CALCULATED_STATUS .INCLU-_VT 0 CST_T_VT Total Costs OBJ_COSTS_TOTAL CURR 15(2) WERTV8 CST_F_VT Fixed Costs OBJ_COSTS_FIXED CURR 15(2) WERTV8 CST_V_VT Variable Costs OBJ_COSTS_VARIABLE CURR 15(2) WERTV8 CALCULATED_VT Category Calculated OBJ_CALCULATED CHAR 1 OBJ_CALCULATED_STATUS .INCLU-_VK 0 CST_T_VK Total Costs OBJ_COSTS_TOTAL CURR 15(2) WERTV8 CST_F_VK Fixed Costs OBJ_COSTS_FIXED CURR 15(2) WERTV8 CST_V_VK Variable Costs OBJ_COSTS_VARIABLE CURR 15(2) WERTV8 CALCULATED_VK Category Calculated OBJ_CALCULATED CHAR 1 OBJ_CALCULATED_STATUS BSG Operating Rate CO_BSG DEC 7(2) DEC5_2 OBJTXT Description KLTXT CHAR 40 TEXT40 AUFTYP Order category AUFTYP NUMC 2 AUFTYP AUFART Order Type AUFART CHAR 4 Assigned to domain AUFART AAT WERKS Plant WERKS_D CHAR 4 Assigned to domain WERKS WRK H_T001W_C PROCNR Production Process CKML_F_PROCNR NUMC 12 Assigned to domain CK_KALNR CKML_PROCNR PROCNR_TEXT Production Process: Generated/Changeable Name CKML_N_FPROC CHAR 50 TEXT50 FIXVO_S Predistribution of fixed costs for acty type/bus. process CO_FIXVO CHAR 1 XFELD FIXVO_E Predistribution of fixed costs for acty type/bus. process CO_FIXVO CHAR 1 XFELD MEGPLA Variances: Planned Quantity of Output Side AWMEGPLA QUAN 15(3) MENGV8 MEGACT Variances: Actual Quantity of Output Side AWMEGACT QUAN 15(3) MENGV8 MEGDIS Variances: Allocated Actual Quantity AWMEGDIS QUAN 15(3) MENGV8 RAKDF Variances: Minor Differences in Remaining Variance AWKDFR CHAR 1 CHAR1 OBJID Cost Object (Cost Accounting Object) CO_OBJID CHAR 62 TEXT62 VARPERC Total of all variances as % of target costs AWGKG_PROZ DEC 9(2) PRZ72 ACT_SALDO Actual Cost Balance (Actual Cost - Allocated Actual Cost) OBJ_ALV_COSTS_ACT_SALDO CURR 15(2) WERTV8 CALC_REMAIN Idle-Capacity Costs OBJ_ALV_COSTS_ACT_REMAIN CURR 15(2) WERTV8 CALC_VOLUME Volume Variance (CO-OM) OBJ_ALV_COSTS_ACT_VOLUME CURR 15(2) WERTV8 CALC_SECFIX Secondary Fixed-Cost Variance (CO-OM) OBJ_ALV_COSTS_ACT_SECFIX CURR 15(2) WERTV8 KOSTL Cost Center KOSTL CHAR 10 Assigned to domain ALPHA KOSTL KOS LSTAR Activity Type LSTAR CHAR 6 Assigned to domain LSTAR LAR LART_EMPTY PRZNR Business Process CO_PRZNR CHAR 12 Assigned to domain ALPHA CO_PRZNR KWP
How do I retrieve data from SAP structure OBJ_VAR_ALV using ABAP code?
As OBJ_VAR_ALV 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 OBJ_VAR_ALV as there is no data to select.
How to access SAP table OBJ_VAR_ALV
Within an ECC or HANA version of SAP you can also view further information about OBJ_VAR_ALV and the data within it using relevant transactions such as
SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects
What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!