V_CMDT_CC SAP (Generated Table for View) Table View details
Dictionary Type: Table View
Description: Generated Table for View
Description: Generated Table for View
Table View field list including key, data, relationships and ABAP select examples
V_CMDT_CC is a standard SAP Table View which is used to store Generated Table for View data and is available within R/3 SAP systems depending on the version and release level.
The V_CMDT_CC table consists of various fields, each holding specific information or linking keys about Generated Table for View data available in SAP. These include OBJNR (Object number), DATBI (Valid To Date), STATUS (Activation Status of Generic Master Record), DATAB (Valid-From Date).. 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 V_CMDT_CC table view 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 |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
OBJNR | Object number | J_OBJNR | CHAR | 22 | ONR00 | J_OBJNR | ONR | ||
DATBI | Valid To Date | DATBI | DATS | 8 | DATUM | ||||
STATUS | Activation Status of Generic Master Record | CMDT_STATUS | CHAR | 1 | CMDT_STATUS | ||||
DATAB | Valid-From Date | DATAB | DATS | 8 | DATUM | ||||
LOGSYSTEM | Logical System | LOGSYSTEM | CHAR | 10 | TBDLS | ALPHA | LOGSYS | ||
ERSDA | Created on | ERFDT | DATS | 8 | DATUM | ||||
USNAM | Entered by | ERFNM | CHAR | 12 | USNAM | ||||
LAND1 | Country Key | LAND1 | CHAR | 3 | T005 | LAND1 | LND | ||
ANRED | Title | ANRED | CHAR | 15 | TEXT15 | ||||
NAME1 | Name 1 | NAME1_GP | CHAR | 35 | NAME | ||||
NAME2 | Name 2 | NAME2_GP | CHAR | 35 | NAME | ||||
NAME3 | Name 3 | NAME3_GP | CHAR | 35 | NAME | ||||
NAME4 | Name 4 | NAME4_GP | CHAR | 35 | NAME | ||||
ORT01 | City | ORT01_GP | CHAR | 35 | TEXT35 | ||||
ORT02 | District | ORT02_GP | CHAR | 35 | TEXT35 | ||||
STRAS | House number and street | STRAS_GP | CHAR | 35 | TEXT35 | ||||
PFACH | PO Box | PFACH | CHAR | 10 | PFACH | ||||
PSTLZ | Postal Code | PSTLZ | CHAR | 10 | PSTLZ | ||||
PSTL2 | P.O. Box Postal Code | PSTL2 | CHAR | 10 | PSTLZ | ||||
REGIO | STATE (State, Province, County) | REGIO | CHAR | 3 | T005S | REGIO | |||
SPRAS | Language Key | SPRAS | LANG | 1 | T002 | ISOLA | SPRAS | SPR | H_T002 |
TELBX | Telebox number | TELBX | CHAR | 15 | TEXT15 | ||||
TELF1 | First telephone number | TELF1 | CHAR | 16 | TEXT16 | ||||
TELF2 | Second telephone number | TELF2 | CHAR | 16 | TEXT16 | ||||
TELFX | Fax Number | TELFX | CHAR | 31 | TEXT31 | ||||
TELTX | Teletex number | TELTX | CHAR | 30 | TEXT30 | ||||
TELX1 | Telex number | TELX1 | CHAR | 30 | TEXT30 | ||||
DATLT | Data communication line no. | DATLT | CHAR | 14 | TEXT14 | ||||
DRNAM | Printer destination for CCtr report | KDNAM | CHAR | 4 | DRNAM | ||||
TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | TTXJ | TXJCD | TXJ | ||
KOKRS | Controlling Area | KOKRS | CHAR | 4 | TKA01 | CACCD | CAC | ||
KOSTL | Cost Center | KEO_COST_CENTER | CHAR | 10 | ALPHA | KOSTL | KOS | KEO_CC_SAMP | |
KHINR | Standard Hierarchy Area | CMDT_HIERAREA | CHAR | 12 | SETNR | ||||
VERAK | Person responsible | RESP_PERS | CHAR | 20 | VERAK | ||||
VERAK_USER | User Responsible | VERAK_USER | CHAR | 12 | USR02 | XUBNAME | XUS | USER_COMP | |
WAERS | Currency Key | WAERS | CUKY | 5 | WAERS | FWS | |||
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
GSBER | Business Area | GSBER | CHAR | 4 | TGSB | GSBER | GSB | ||
KOSAR | Cost Center Category | KOSAR | CHAR | 1 | TKA05 | KOSAR | PCA_KOSAR | ||
PRCTR | Profit Center | PRCTR | CHAR | 10 | ALPHA | PRCTR | PRC | PRCTR_EMPTY | |
FUNC_AREA | Functional Area | FKBER | CHAR | 16 | TFKB | FKBER | FBE | ||
ABTEI | Department | ABTEI | CHAR | 12 | ABTEI | ||||
CPI_TEMPL | Template for Activity-Independent Formula Planning | CCA_TEMPL_CPI | CHAR | 10 | COTPL | ABC_TEMPL | ABT | ||
CPD_TEMPL | Template for Activity-Dependent Formula Planning | CCA_TEMPL_CPD | CHAR | 10 | COTPL | ABC_TEMPL | ABT | ||
SCI_TEMPL | Template: Activity-Independent Allocation to Cost Center | CCA_TEMPL_SCI | CHAR | 10 | COTPL | ABC_TEMPL | ABT | ||
SCD_TEMPL | Template: Activity-Dependent Allocation to Cost Center | CCA_TEMPL_SCD | CHAR | 10 | COTPL | ABC_TEMPL | ABT | ||
KALSM | Costing Sheet | AUFKALSM | CHAR | 6 | T683 | KALSM | |||
BKZKP | Lock Indicator for Actual Primary Postings | BKZKP | CHAR | 1 | YNFLG | ||||
PKZKP | Lock Indicator for Plan Primary Costs | PKZKP | CHAR | 1 | YNFLG | ||||
BKZKS | Lock Indicator for Actual Secondary Costs | BKZKS | CHAR | 1 | YNFLG | ||||
BKZER | Lock Indicator for Actual Revenue Postings | BKZER | CHAR | 1 | YNFLG | ||||
BKZOB | Lock Indicator for Commitment Update | BKZOB | CHAR | 1 | YNFLG | ||||
PKZKS | Lock Indicator for Plan Secondary Costs | PKZKS | CHAR | 1 | YNFLG | ||||
PKZER | Lock Indicator for Planning Revenues | PKZER | CHAR | 1 | YNFLG | ||||
MGEFL | Indicator for Recording Consumption Quantities | MGEFL | CHAR | 1 | YNFLG | ||||
VNAME | Joint Venture | JV_NAME | CHAR | 6 | T8JV | ALPHA | JV_NAME | JVV | |
RECID | Recovery Indicator | JV_RECIND | CHAR | 2 | T8JJ | ALPHA | JV_RECIND | ||
ETYPE | Equity type | JV_ETYPE | CHAR | 3 | T8JG | ALPHA | JV_ETYPE | ||
JV_OTYPE | Joint Venture Object Type | JV_OTYPE | CHAR | 4 | ALPHA | JV_OTYPE | |||
JV_JIBCL | JIB/JIBE Class | JV_JIBCL | CHAR | 3 | T8J6A | JV_JIBCL | JIB | ||
JV_JIBSA | JIB/JIBE Subclass A | JV_JIBSA | CHAR | 5 | T8J6C | JV_JIBSA | JBS |
Key field | Non-key field |
How do I retrieve data from SAP table V_CMDT_CC using ABAP code
The following ABAP code Example will allow you to do a basic selection on V_CMDT_CC to SELECT all data from the tableDATA: WA_V_CMDT_CC TYPE V_CMDT_CC.
SELECT SINGLE *
FROM V_CMDT_CC
INTO CORRESPONDING FIELDS OF WA_V_CMDT_CC
WHERE...
How to access SAP table V_CMDT_CC
Within an ECC or HANA version of SAP you can also view further information about V_CMDT_CC 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