/ACCGO/T_CC_CANC
Commodity Contract Cancellation Information
/ACCGO/T_CC_CANC is an SAP database table in S/4HANA. Commodity Contract Cancellation Information. It contains 31 fields. 3 CDS views read from this table.
CDS Views using this table (3)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_ACMCancMigrationTargetData | view_entity | from | BASIC | Cancellation Migration Target Data |
| I_ACMCmmdtyContrCancln_1 | view_entity | from | BASIC | ACM Commdty Contract Cancellation |
| I_ACMContractCancMigrationSts | view_entity | inner | BASIC | Contract Cancellation Mig Status |
Fields (31)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | tkonn | TKONN | Trading Contract | |||
| KEY | tposn | TPOSN | Item Number | |||
| KEY | tposn_com | WLF_TPOSN_COM | Com. item num. | |||
| KEY | cancl_guid | /ACCGO/E_CNTRCT_GUID | Contract GUID | |||
| KEY | new_plot_id | /ACCGO/E_PRICINGLOT_ID | Pricing Lot ID | |||
| cancl_typ | /ACCGO/E_CANCL_TYP | Cancellation Type | ||||
| created_by | ERNAM | Created By | ||||
| created_on | TIMESTAMP | Time Stamp | ||||
| changed_by | AENAM | Changed By | ||||
| changed_on | TIMESTAMP | Time Stamp | ||||
| underfill_id | /ACCGO/E_UNDERFILL_ID | Underfill ID | ||||
| src_plot_id | /ACCGO/E_SRC_PLOT_ID | Source Prc. Lot ID | ||||
| group_id | CMM_CPE_GRPID | Group ID Prc Fix Grp | ||||
| prcfixgrp_guid | CMM_CPE_PRCFIXGRP_GUID | Price Fix Group ID | ||||
| absgr | ABSGR | Reas. for Canc. | ||||
| ob_linkid | /ACCGO/E_OBLIG_LINK_ID | Obligtn LinkID | ||||
| settlmt_indi | /ACCGO/E_SETTLMNT_IND | Settlement | ||||
| seq_no | /ACCGO/E_CANC_SEQ_NO | Sequence No. | ||||
| side | /ACCGO/E_CANC_SIDE | Side | ||||
| total_cancld_qty | /ACCGO/E_TOT_CANC_QTY_DEC_14 | |||||
| cancl_unit | MEINS | Base Unit | ||||
| number_of_vehicles | /ACCGO/E_NUMBER_OF_VEHICLES | Number of Vehicles | ||||
| cancld_qty | /ACCGO/E_CANC_QTY_DEC_14 | |||||
| cancld_qty_uom | MEINS | Base Unit | ||||
| prlink_id | /ACCGO/E_PLOT_LINK_ID | Plot Link ID | ||||
| cond_type_1 | /ACCGO/E_CANC_CONDTYPE1 | Canc. Price Cond. 1 | ||||
| cond_type_2 | /ACCGO/E_CANC_CONDTYPE2 | Canc. Price Cond. 2 | ||||
| assgn_guid | WLF_ASSGMT_GUID | Assignment GUID | ||||
| psmguid | CPET_PSMGUID | PSM GUID | ||||
| psmstatus | CPET_PSMSTATUS | PSM Status |
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.
-- Commodity Contract Cancellation Information
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE /ACCGO/T_CC_CANC (
MANDT, -- Client [MANDT]
TKONN, -- Trading Contract [TKONN]
TPOSN, -- Item Number [TPOSN]
TPOSN_COM, -- Com. item num. [WLF_TPOSN_COM]
CANCL_GUID, -- Contract GUID [/ACCGO/E_CNTRCT_GUID]
NEW_PLOT_ID, -- Pricing Lot ID [/ACCGO/E_PRICINGLOT_ID]
CANCL_TYP, -- Cancellation Type [/ACCGO/E_CANCL_TYP]
CREATED_BY, -- Created By [ERNAM]
CREATED_ON, -- Time Stamp [TIMESTAMP]
CHANGED_BY, -- Changed By [AENAM]
CHANGED_ON, -- Time Stamp [TIMESTAMP]
UNDERFILL_ID, -- Underfill ID [/ACCGO/E_UNDERFILL_ID]
SRC_PLOT_ID, -- Source Prc. Lot ID [/ACCGO/E_SRC_PLOT_ID]
GROUP_ID, -- Group ID Prc Fix Grp [CMM_CPE_GRPID]
PRCFIXGRP_GUID, -- Price Fix Group ID [CMM_CPE_PRCFIXGRP_GUID]
ABSGR, -- Reas. for Canc. [ABSGR]
OB_LINKID, -- Obligtn LinkID [/ACCGO/E_OBLIG_LINK_ID]
SETTLMT_INDI, -- Settlement [/ACCGO/E_SETTLMNT_IND]
SEQ_NO, -- Sequence No. [/ACCGO/E_CANC_SEQ_NO]
SIDE, -- Side [/ACCGO/E_CANC_SIDE]
TOTAL_CANCLD_QTY, -- /ACCGO/E_TOT_CANC_QTY_DEC_14
CANCL_UNIT, -- Base Unit [MEINS]
NUMBER_OF_VEHICLES, -- Number of Vehicles [/ACCGO/E_NUMBER_OF_VEHICLES]
CANCLD_QTY, -- /ACCGO/E_CANC_QTY_DEC_14
CANCLD_QTY_UOM, -- Base Unit [MEINS]
PRLINK_ID, -- Plot Link ID [/ACCGO/E_PLOT_LINK_ID]
COND_TYPE_1, -- Canc. Price Cond. 1 [/ACCGO/E_CANC_CONDTYPE1]
COND_TYPE_2, -- Canc. Price Cond. 2 [/ACCGO/E_CANC_CONDTYPE2]
ASSGN_GUID, -- Assignment GUID [WLF_ASSGMT_GUID]
PSMGUID, -- PSM GUID [CPET_PSMGUID]
PSMSTATUS, -- PSM Status [CPET_PSMSTATUS]
PRIMARY KEY (MANDT, TKONN, TPOSN, TPOSN_COM, CANCL_GUID, NEW_PLOT_ID)
);
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