TVFSCB SAP (Scale Bases) Table details
Dictionary Type: Table
Description: Scale Bases
Description: Scale Bases
Table field list including key, data, relationships and ABAP select examples
TVFSCB is a standard SAP Table which is used to store Scale Bases data and is available within R/3 SAP systems depending on the version and release level.
The TVFSCB table consists of various fields, each holding specific information or linking keys about Scale Bases data available in SAP. These include KAPPL (Application), SCABAS (Scale basis), TABNAME (Table Name (Database) for Scale Items), ASS_FIELD (Internal field assignment of scale basis re: struct VFSCAIYY).. 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: S - System table, maint. only by SAP, change = modificationDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified
SAP TVFSCB table 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 |
| KAPPL | Application | KAPPL | CHAR | 2 | T681A | KAPPL | KAP | ||
| SCABAS | Scale basis | REFQUAN | CHAR | 2 | TVFRFQ | REFQUAN | |||
| TABNAME | Table Name (Database) for Scale Items | SB_TABNAME | CHAR | 30 | Assigned to domain | AS4TAB | DTB | ||
| ASS_FIELD | Internal field assignment of scale basis re: struct VFSCAIYY | SB_ASSIGN_FIELD | CHAR | 30 | Assigned to domain | FDNAME | |||
| REF_FIELD | Reference field name for F1 or F4 help for scale basis | SB_REF_FIELD | CHAR | 30 | Assigned to domain | FDNAME | |||
| REF_TAB | Reference table for F1 and F4 help for scale basis | SB_REF_TAB | CHAR | 30 | Assigned to domain | AS4TAB | DTB | ||
| COMMSTR | Ref. to communication structure | CT_COMMSTR | CHAR | 1 | CT_COMMSTR | ||||
| FLDNAME1 | Reference field 1 for scale or for calculation type | CT_FLDNAME | CHAR | 30 | Assigned to domain | FDNAME | |||
| UNITNAME1 | Name of unit-of-measure field for reference field 1 | CT_FLDNAME_UNIT | CHAR | 30 | Assigned to domain | FDNAME | |||
| FLDNAME2 | Reference field 2 for scale or for calculation type | CT_FLDNAME2 | CHAR | 30 | Assigned to domain | FDNAME | |||
| UNITNAME2 | Name of unit-of-measure field for reference field 2 | CT_FLDNAME_UNIT2 | CHAR | 30 | Assigned to domain | FDNAME | |||
| FLDNAME3 | Reference field for calculation using EXIT routines | CT_FLDNAME3 | CHAR | 30 | Assigned to domain | FDNAME | |||
| UNITNAME3 | Name of unit-of-measure field for reference field (EXIT) | CT_FLDNAME_UNIT3 | CHAR | 30 | Assigned to domain | FDNAME | |||
| VARLEN | Indicator for variable input length for scale values | SB_LENMOD | CHAR | 1 | SB_LENMOD | ||||
| BEZGR | Scale basis corresponding to standard pricing (KZBZG) | VF_KZBZG | CHAR | 1 | KZBZG | ||||
| UEXFLG | Indicator for handling user exits | VFUEXFLG | CHAR | 1 | VFUEXFLG | ||||
| VFSCBF | Formula for scale base value | VFSCBF | NUMC | 3 | KOFRM | ||||
| VFCTYF | Condition formula for condition base value | VFCTYF | NUMC | 3 | KOFRM | ||||
| USE_FLAG | Indicator for usage as calculation type | SB_KRECH | CHAR | 1 | SB_KRECH | ||||
| UNIT_CHECK | Check unit of measure for a scale basis | SB_UNITCHECK | CHAR | 1 | SB_UNITCHECK | ||||
| DIMID | Dimension key | DIMID | CHAR | 6 | T006D | DIMID | |||
| TAB_CONTROL | Name of the scale items control | SB_CONTROL | CHAR | 30 | Assigned to domain | AS4TAB | |||
| SCR_PROG | Program for scale item screen | SB_PROGNAME | CHAR | 40 | PROGNAME | ||||
| SCR_NR | Number of screen for scale items | SB_DYNNR | CHAR | 4 | SYCHAR04 | ||||
| SCTEXT | Indicator for usage of texts for scale values | SCTEXT | CHAR | 1 | SCTEXT | ||||
| SCSORT | Indicator for sorting a scale | SCSORT | CHAR | 1 | SCSORT | ||||
| RNDRL_CHECK | Indicator rounding rule allowed | SB_RNDRL | CHAR | 1 | SB_RNDRL | ||||
| INTGEN | Indicator for generating scale values | SB_INTG | CHAR | 1 | SB_INTG | ||||
| CATYP_0 | Calculation Type | CATYP | CHAR | 1 | CATYP | ||||
| CATYP_1 | Calculation Type | CATYP | CHAR | 1 | CATYP | ||||
| CATYP_2 | Calculation Type | CATYP | CHAR | 1 | CATYP | ||||
| CATYP_3 | Calculation Type | CATYP | CHAR | 1 | CATYP | ||||
| CATYP_4 | Calculation Type | CATYP | CHAR | 1 | CATYP | ||||
| SCATYP_0 | Scale type | SCATYP | CHAR | 1 | SCATYP | ||||
| SCATYP_1 | Scale type | SCATYP | CHAR | 1 | SCATYP | ||||
| SCATYP_2 | Scale type | SCATYP | CHAR | 1 | SCATYP | ||||
| SCATYP_3 | Scale type | SCATYP | CHAR | 1 | SCATYP | ||||
| SCATYP_4 | Scale type | SCATYP | CHAR | 1 | SCATYP | ||||
| SCATYP_5 | Scale type | SCATYP | CHAR | 1 | SCATYP | ||||
| SCATYP_6 | Scale type | SCATYP | CHAR | 1 | SCATYP | ||||
| SCATYP_7 | Scale type | SCATYP | CHAR | 1 | SCATYP | ||||
| SCATYP_8 | Scale type | SCATYP | CHAR | 1 | SCATYP | ||||
| SCATYP_9 | Scale type | SCATYP | CHAR | 1 | SCATYP | ||||
| BERGL_0 | Calculation Base | BERGL | CHAR | 1 | BERGL | ||||
| BERGL_1 | Calculation Base | BERGL | CHAR | 1 | BERGL | ||||
| BERGL_2 | Calculation Base | BERGL | CHAR | 1 | BERGL | ||||
| BERGL_3 | Calculation Base | BERGL | CHAR | 1 | BERGL | ||||
| BERGL_4 | Calculation Base | BERGL | CHAR | 1 | BERGL | ||||
| BERGL_5 | Calculation Base | BERGL | CHAR | 1 | BERGL | ||||
| BERGL_6 | Calculation Base | BERGL | CHAR | 1 | BERGL | ||||
| BERGL_7 | Calculation Base | BERGL | CHAR | 1 | BERGL | ||||
| BERGL_8 | Calculation Base | BERGL | CHAR | 1 | BERGL | ||||
| BERGL_9 | Calculation Base | BERGL | CHAR | 1 | BERGL | ||||
| PROG_MAINT | Program name for scale checks | SB_CHECK_PROG | CHAR | 40 | PROGNAME | ||||
| FORM_MAINT | Form name for scale checks | SB_CHECK_FORM | CHAR | 30 | SYCHAR30 | ||||
| PROG_COND | Program name for scale checks | SB_CHECK_PROG | CHAR | 40 | PROGNAME | ||||
| FORM_COND | Form name for scale checks | SB_CHECK_FORM | CHAR | 30 | SYCHAR30 |
| Key field | Non-key field |
How do I retrieve data from SAP table TVFSCB using ABAP code
The following ABAP code Example will allow you to do a basic selection on TVFSCB to SELECT all data from the tableDATA: WA_TVFSCB TYPE TVFSCB.
SELECT SINGLE *
FROM TVFSCB
INTO CORRESPONDING FIELDS OF WA_TVFSCB
WHERE...
How to access SAP table TVFSCB
Within an ECC or HANA version of SAP you can also view further information about TVFSCB 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