CACS_DET_VARIANT SAP (Characteristics of Determination Variant) Table details
Dictionary Type: Table
Description: Characteristics of Determination Variant
Description: Characteristics of Determination Variant
ABAP Code to SELECT data from CACS_DET_VARIANT
Related tables to CACS_DET_VARIANT
Access table CACS_DET_VARIANT
Related tables to CACS_DET_VARIANT
Access table CACS_DET_VARIANT
Table field list including key, data, relationships and ABAP select examples
CACS_DET_VARIANT is a standard SAP Table which is used to store Characteristics of Determination Variant data and is available within R/3 SAP systems depending on the version and release level.
The CACS_DET_VARIANT table consists of various fields, each holding specific information or linking keys about Characteristics of Determination Variant data available in SAP. These include APPL (Commission Application (ICM)), VARNAME (Name of Variant), ERNAM (Last user to change object), ERDAT (Date on Which Object was Created).. 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: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)
SAP CACS_DET_VARIANT 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 |
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
APPL | Commission Application (ICM) | CACSAPPL | CHAR | 6 | Assigned to domain | CACSAPPL | CACSAPPL | CACS_APPLCL | |
VARNAME | Name of Variant | CACSDETVARIANTNAME | CHAR | 30 | CACSDETVARIANTNAME | ||||
ERNAM | Last user to change object | CACSCHUSR | CHAR | 12 | USNAM | ||||
ERDAT | Date on Which Object was Created | CACSCHGDAT | DATS | 8 | DATUM | ||||
ERZZT | Time at Which Object was Created | CACSCHGTIM | TIMS | 6 | UZEIT | ||||
VARDESC | Variant Description | CACSDETVARIANTDESC | STRG | 0 | CACSDETVARIANTDESC | ||||
ENTRY_POINT | Entry Point | CACSDETENTRYPOINT | CHAR | 2 | Assigned to domain | CACSDETENTRYPOINT | |||
SELTAB | Name of Selection Table for Commission Contract | CACS_SELTAB | CHAR | 30 | Assigned to domain | AS4TAB | |||
OLD_DET | Boolean Variables (X=true, space=false) | BOOLEAN_FLG | CHAR | 1 | BOOLEAN_FLG | ||||
NEW_DET | Boolean Variables (X=true, space=false) | BOOLEAN_FLG | CHAR | 1 | BOOLEAN_FLG | ||||
BUSI_NOW | Boolean Variables (X=true, space=false) | BOOLEAN_FLG | CHAR | 1 | BOOLEAN_FLG | ||||
BUSI_OTHER | Boolean Variables (X=true, space=false) | BOOLEAN_FLG | CHAR | 1 | BOOLEAN_FLG | ||||
BUSI | Effective Validity (Time Stamp YYYY.MM.DD hh:mm:ss) | CACSBUSITIME | NUMC | 14 | TSTPS | CACSTIMESTAMP | |||
TECH_NOW | Boolean Variables (X=true, space=false) | BOOLEAN_FLG | CHAR | 1 | BOOLEAN_FLG | ||||
TECH_OTHER | Boolean Variables (X=true, space=false) | BOOLEAN_FLG | CHAR | 1 | BOOLEAN_FLG | ||||
TECH | Technical Validity (Time Stamp: YYYY.MM.DD hh:mm:ss) | CACSTECHTIME | NUMC | 14 | TSTPS | CACSTIMESTAMP | |||
FLT_CTRT_TYPE | Filter of Commission Contract Type for Determination | CACSDETFLTCTRTTYPE | CHAR | 3 | CHAR3 | ||||
FLT_CTRTST_ID | Filter of Standard Commission Contract for Determination | CACSDETFLTCTRTSTID | CHAR | 20 | ALPHA | ISIS_CONTRACT_ID | |||
COMBTP_ID | Number of Characteristics Combination Type | CACS_COMBTP_ID | CHAR | 12 | CACS_COMBTP_ID | CACS_DET_COMBINATION | |||
CTRTBU_ID | Commission Contract Number | CACS_CTRTBU_ID | CHAR | 20 | ALPHA | ISIS_CONTRACT_ID | CACSCTBU | CACS | |
CTRTST_ID | Number of Standard Commission Contract | CACS_CTRTST_ID | CHAR | 20 | ALPHA | ISIS_CONTRACT_ID | CACST | ||
AGR_TYP | Agreement Type | CACS_AGR_TYP | CHAR | 2 | Assigned to domain | CACS_AGR_TYP | |||
STCAGR_ID | Standard Agreement Number | CACS_STCAGR_ID | CHAR | 12 | ALPHA | CACS_STCAGR_ID | |||
BUSOBJ_TYPE | Business Object Category that Triggers Commission | CACSBUSOBJTYP | CHAR | 3 | Assigned to domain | BOBJ0 | CACSBUSOBJTYP | OBJ | |
SELRULE_ID | Identification of Selection Rule in Remuneration Clearing | CACSSELRULEID | CHAR | 4 | ALPHA | CACSRULEID | |||
RGOAID | FOA Connection: Rule Group for Object Assignment | CACSRGOAID | CHAR | 2 | CHAR02 | ||||
STMTYPE_ID | Identification of Settlement Type | CACS_STMTYPE_ID | CHAR | 4 | Assigned to domain | CACSSTMTY | |||
OATYID | FOA: ID of Assignment Type | CACSOATYID | CHAR | 4 | Assigned to domain | CACSOATYID | CACS_OATYID | ||
OARUID | FOA: ID of Assignment Rule | CACSOARUID | CHAR | 4 | Assigned to domain | CACSOARUID | CACS_OARUID | ||
REMTYPE | Remuneration Type | CACSREM | CHAR | 4 | Assigned to domain | CACSREM | CACS_REM | ||
BOBJTYPE | Credentialing: Object Types | CRDOBJTYPE | CHAR | 3 | CRDOBJTYPED | ||||
EVENTTYPE | Transaction Type | CRDEVENTTYPE | CHAR | 3 | CRDEVENTTYPED | ||||
CONTEXT | Context of Credentials Check | CRDCONTEXT | CHAR | 5 | Assigned to domain | CRDCONTEXTD | CRD_CONTEXT | ||
SELGRIDVARIANT | Layout | SLIS_VARI | CHAR | 12 | SLIS_VARI |
Key field | Non-key field |
How do I retrieve data from SAP table CACS_DET_VARIANT using ABAP code
The following ABAP code Example will allow you to do a basic selection on CACS_DET_VARIANT to SELECT all data from the tableDATA: WA_CACS_DET_VARIANT TYPE CACS_DET_VARIANT.
SELECT SINGLE *
FROM CACS_DET_VARIANT
INTO CORRESPONDING FIELDS OF WA_CACS_DET_VARIANT
WHERE...
How to access SAP table CACS_DET_VARIANT
Within an ECC or HANA version of SAP you can also view further information about CACS_DET_VARIANT 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