TCACS_REM
Commission Remuneration Types
TCACS_REM is an SAP database table in S/4HANA. Commission Remuneration Types. It contains 22 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_CommsnRemunerationTypeVH | view_entity | from | BASIC | Commission Remuneration Type |
Fields (22)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | mandt | Client | |||
| KEY | appl | cacsappl | Commission Appl | |||
| KEY | remuneration | cacsrem | RemuneratType | |||
| KEY | version | cacsversion | Version | |||
| rem_form | cacsremform | Remuner. Form | ||||
| remun_class | cacsrem_class | Remun. Group | ||||
| remun_mark | cacsrem_mark | ID:Remuneration | ||||
| rem_obj_type | cacsremobj | ObjTyp Remun. | ||||
| value | cacsval | Valuation type | ||||
| value_type | cacsvaltype | Valn ResultCat | ||||
| resulttype | cacsresulttype | Result type | ||||
| accas_tyid | cacs_accas_tyid | AccAssignmntTyp | ||||
| duedate_mark | cacsduedatem | Due Date | ||||
| rcalc_type | cacsrcalctyp | Calculat. Type | ||||
| rcalc_path | cacsrcalcpath | Calc. method | ||||
| comm_cost_mk | cacscommcost | Acquis.Costs | ||||
| flg_special | cacsflgspec | Special Type | ||||
| resp_rule_id | cacsresprule | Liability Type | ||||
| inst_plan_id | cacsinstplid | LegalRightRules | ||||
| log_service | cacs_rule_log_service | LogService | ||||
| combtp_id | cacs_combtp_id | CombTypeNo. | ||||
| proof_debt_flg | cacs_proof_debt_flg | Stmnt Required |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Commission Remuneration Types
-- Category TRANSPARENT · Delivery class E
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TCACS_REM (
MANDT, -- Client [mandt]
APPL, -- Commission Appl [cacsappl]
REMUNERATION, -- RemuneratType [cacsrem]
VERSION, -- Version [cacsversion]
REM_FORM, -- Remuner. Form [cacsremform]
REMUN_CLASS, -- Remun. Group [cacsrem_class]
REMUN_MARK, -- ID:Remuneration [cacsrem_mark]
REM_OBJ_TYPE, -- ObjTyp Remun. [cacsremobj]
VALUE, -- Valuation type [cacsval]
VALUE_TYPE, -- Valn ResultCat [cacsvaltype]
RESULTTYPE, -- Result type [cacsresulttype]
ACCAS_TYID, -- AccAssignmntTyp [cacs_accas_tyid]
DUEDATE_MARK, -- Due Date [cacsduedatem]
RCALC_TYPE, -- Calculat. Type [cacsrcalctyp]
RCALC_PATH, -- Calc. method [cacsrcalcpath]
COMM_COST_MK, -- Acquis.Costs [cacscommcost]
FLG_SPECIAL, -- Special Type [cacsflgspec]
RESP_RULE_ID, -- Liability Type [cacsresprule]
INST_PLAN_ID, -- LegalRightRules [cacsinstplid]
LOG_SERVICE, -- LogService [cacs_rule_log_service]
COMBTP_ID, -- CombTypeNo. [cacs_combtp_id]
PROOF_DEBT_FLG, -- Stmnt Required [cacs_proof_debt_flg]
PRIMARY KEY (MANDT, APPL, REMUNERATION, VERSION)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA