/ACCGO/T_CC_CANC

Transparent Table Application Table

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)

ViewTypeJoinVDMDescription
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)

KeyField Data ElementDescription DomainTypeLength
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)
);