CACS_SESAGR
(Individual) Settlement Schedule Agreement in CommnContract
CACS_SESAGR is an SAP database table in S/4HANA. (Individual) Settlement Schedule Agreement in CommnContract. It contains 9 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_CommsnSchedulingAgreement | view_entity | from | BASIC | Settlement scheduling agreement |
Fields (9)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | mandt | Client | |||
| KEY | appl | cacsappl | Commission Appl | |||
| KEY | ctrtbu_id | cacs_ctrtbu_id | Contract Number | |||
| KEY | sesagr_id | cacs_sesagr_id | No.SchedAgr | |||
| KEY | version | cacsversion | Version | |||
| sesru_id | cacssesruid | Scheduling Rule | ||||
| sesru_begin | cacs_sesru_begin | St.ValiditySchedAgrt | ||||
| sesru_end | cacs_sesru_end | EndValiditySchedAgm | ||||
| priority | cacspriority | Priority |
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.
-- (Individual) Settlement Schedule Agreement in CommnContract
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CACS_SESAGR (
MANDT, -- Client [mandt]
APPL, -- Commission Appl [cacsappl]
CTRTBU_ID, -- Contract Number [cacs_ctrtbu_id]
SESAGR_ID, -- No.SchedAgr [cacs_sesagr_id]
VERSION, -- Version [cacsversion]
SESRU_ID, -- Scheduling Rule [cacssesruid]
SESRU_BEGIN, -- St.ValiditySchedAgrt [cacs_sesru_begin]
SESRU_END, -- EndValiditySchedAgm [cacs_sesru_end]
PRIORITY, -- Priority [cacspriority]
PRIMARY KEY (MANDT, APPL, CTRTBU_ID, SESAGR_ID, 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