SAP Table TCACS_VAL
Comn.: Valuation Types
TCACS_VAL (Comn.: Valuation Types) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link TCACS_VAL to other SAP tables.
TCACS_VAL table fields
Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||||||||||||
APPL | Commission Application (ICM) | CACSAPPL | TCACS_APPLDEF | CHAR | 6 | 0 | ||||||||||||||||||
VALUE | Valuation Type | CACSVAL | CHAR | 4 | 0 | |||||||||||||||||||
VERSION | Version of Master Data or Customizing Object | CACSVERSION | NUMC | 6 | 0 | |||||||||||||||||||
TRI_OBJ_TYPE | Triggering Subobject Type | CACSTRIOBJ | CHAR | 5 | 0 | |||||||||||||||||||
LOG_SERVICE | Logical Service for Agreement Rules | CACS_RULE_LOG_SERVICE | TCACS_RULESERV | CHAR | 10 | 0 | ||||||||||||||||||
VALUE_TYPE | Valuation Result Category | CACSVALRESULTTYPE | NUMC | 1 | 0 |
Possible values
|
||||||||||||||||||
COMPLX | Complexity of Valuation | CACS_COMPLEXITY | NUMC | 4 | 0 | |||||||||||||||||||
BUSI_BEGIN | Effective from | CACS_BUSITIME_B | NUMC | 14 | 0 | |||||||||||||||||||
BUSI_END | Effective Until (Time Stamp: YYYY.MM.DD hh:mm:ss) | CACS_BUSITIME_E | NUMC | 14 | 0 | |||||||||||||||||||
TECH_BEGIN | Technically Valid From | CACS_TECHTIME_B | NUMC | 14 | 0 | |||||||||||||||||||
TECH_END | Technically Valid To (Time Stamp: JJJJ.MM.TT hh:mm:ss) | CACS_TECHTIME_E | NUMC | 14 | 0 | |||||||||||||||||||
FLG_CANCEL_OBJ | Indicator: Object is Invalid | CACSCANCOBJ | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
FLG_CANCEL_VERS | Indicator: Version is Invalid | CACSCANCVERS | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
CHG_TCODE | Transaction in Which the Change Was Made | CACSCDTC | CHAR | 20 | 0 | |||||||||||||||||||
CHG_USR | Last user to change object | CACSCHUSR | CHAR | 12 | 0 | |||||||||||||||||||
TRI_METH_TYP | Triggering Method | CACSTRIMETHTYP | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
TRI_METH_TARGET | Processing Target of Triggering Method | CACSTRIMETHTAR | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
STATUS_VERSION | Object Version Status | CACSSTATUSVERS | TCACS_VALSTAT1 | CHAR | 1 | 0 | ||||||||||||||||||
STATUS_WORK | Object Version Processing Status | CACSSTATUSWORK | TCACS_VALSTAT1 | CHAR | 1 | 0 |
TCACS_VAL foreign key relationships
Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
---|---|---|---|---|---|---|
TCACS_VAL | APPL | TCACS_VAL | APPL | TCACS_APPLDEF | All Commission Applications | APPL |
TCACS_VAL | LOG_SERVICE | TCACS_VAL | MANDT | TCACS_RULESERV | Agreement Rules Services | MANDT |
TCACS_VAL | LOG_SERVICE | TCACS_VAL | APPL | TCACS_RULESERV | Agreement Rules Services | APPL |
TCACS_VAL | LOG_SERVICE | TCACS_VAL | LOG_SERVICE | TCACS_RULESERV | Agreement Rules Services | LOG_SERVICE |
TCACS_VAL | LOG_SERVICE | * | TCACS_RULESERV | Agreement Rules Services | VERSION | |
TCACS_VAL | MANDT | TCACS_VAL | MANDT | T000 | Clients | MANDT |
TCACS_VAL | STATUS_VERSION | TCACS_VAL | STATUS_WORK | TCACS_VALSTAT1 | Allowed Status Combinations Process/Version | STATUS_WORK |
TCACS_VAL | STATUS_VERSION | '0' | TCACS_VALSTAT1 | Allowed Status Combinations Process/Version | STATUSCLASS | |
TCACS_VAL | STATUS_VERSION | TCACS_VAL | STATUS_VERSION | TCACS_VALSTAT1 | Allowed Status Combinations Process/Version | STATUS_VERSION |
TCACS_VAL | STATUS_WORK | '0' | TCACS_VALSTAT1 | Allowed Status Combinations Process/Version | STATUSCLASS | |
TCACS_VAL | STATUS_WORK | TCACS_VAL | STATUS_VERSION | TCACS_VALSTAT1 | Allowed Status Combinations Process/Version | STATUS_VERSION |
TCACS_VAL | STATUS_WORK | TCACS_VAL | STATUS_WORK | TCACS_VALSTAT1 | Allowed Status Combinations Process/Version | STATUS_WORK |