I_CONTRACTHEAD
Contract header
I_CONTRACTHEAD is a CDS View in S/4HANA. Contract header. It contains 115 fields. 4 CDS views read from this table.
CDS Views using this table (4)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_ACMApplicationOverview | view | left_outer | TRANSACTIONAL | Interface Layer for ACM Application Overview |
| I_ACMTrdgContrHdrForPrcgCndn | view | inner | COMPOSITE | Trading Contract Header Details for Pricing Condition |
| I_FBO | view | from | COMPOSITE | FBO Details |
| P_TradingContractHeader | view | from | COMPOSITE |
Fields (115)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | tkonn | tkonn | 1 |
| _dataaging | _dataaging | 1 | |
| abrvw | abrvw | 1 | |
| abssc | abssc | 1 | |
| aedat | aedat | 1 | |
| aenam | aenam | 1 | |
| aezeit | aezeit | 1 | |
| akprz | akprz | 1 | |
| amtbl | amtbl | 1 | |
| andtx_sd | andtx_sd | 1 | |
| angdt_sd | angdt_sd | 1 | |
| auart | auart | 1 | |
| audat | audat | 1 | |
| augru | augru | 1 | |
| autlf_sd | autlf_sd | 1 | |
| bname_sd | bname_sd | 1 | |
| bnddt_sd | bnddt_sd | 1 | |
| bsark_sd | bsark_sd | 1 | |
| bstdk | bstdk | 1 | |
| bstnk | bstnk | 1 | |
| bstzd_sd | bstzd_sd | 1 | |
| btbsta | btbsta | 1 | |
| budat | budat | 1 | |
| cmfre | cmfre | 1 | |
| cmngv | cmngv | 1 | |
| cmnup | cmnup | 1 | |
| cmwae | cmwae | 1 | |
| company_code | company_code | 1 | |
| complete | complete | 1 | |
| consol_it_exist | consol_it_exist | 1 | |
| created_from | created_from | 1 | |
| ctlpc | ctlpc | 1 | |
| dummy_wbhk_incl_eew_ps | dummy_wbhk_incl_eew_ps | 1 | |
| erdat | erdat | 1 | |
| ernam | ernam | 1 | |
| erzeit | erzeit | 1 | |
| exnum | exnum | 1 | |
| faksk_sd | faksk_sd | 1 | |
| ft_header_com | ft_header_com | 1 | |
| grupp | grupp | 1 | |
| guebg | guebg | 1 | |
| gueen | gueen | 1 | |
| ihrez_sd | ihrez_sd | 1 | |
| in_approval | in_approval | 1 | |
| kalsm_ch | kalsm_ch | 1 | |
| kalsm_sd | kalsm_sd | 1 | |
| kkber | kkber | 1 | |
| knkli | knkli | 1 | |
| knumv_sd | knumv_sd | 1 | |
| kokrs | kokrs | 1 | |
| kunnr | kunnr | 1 | |
| kurrf | kurrf | 1 | |
| kurst | kurst | 1 | |
| kurst_sd | kurst_sd | 1 | |
| kvgr1_sd | kvgr1_sd | 1 | |
| kvgr2_sd | kvgr2_sd | 1 | |
| kvgr3_sd | kvgr3_sd | 1 | |
| kvgr4_sd | kvgr4_sd | 1 | |
| kvgr5_sd | kvgr5_sd | 1 | |
| landtx | landtx | 1 | |
| last_change_uuid | last_change_uuid | 1 | |
| lcnum | lcnum | 1 | |
| lfspg | lfspg | 1 | |
| lifsk_sd | lifsk_sd | 1 | |
| logsys | logsys | 1 | |
| mahdt_sd | mahdt_sd | 1 | |
| mahza_sd | mahza_sd | 1 | |
| netwr_sd | netwr_sd | 1 | |
| pf_last_action | pf_last_action | 1 | |
| pf_last_order | pf_last_order | 1 | |
| pf_status | pf_status | 1 | |
| pricing_type | pricing_type | 1 | |
| prsdt_sd | prsdt_sd | 1 | |
| ps_psp_pnr | ps_psp_pnr | 1 | |
| purpose | purpose | 1 | |
| quan_complete | quan_complete | 1 | |
| sbgrp | sbgrp | 1 | |
| sdwrs | sdwrs | 1 | |
| set_variant | set_variant | 1 | |
| spart | Division,spart | 2 | |
| stceg_l | stceg_l | 1 | |
| stceg_l_sd | stceg_l_sd | 1 | |
| submi_sd | submi_sd | 1 | |
| succ_arch | succ_arch | 1 | |
| taxk1_sd | taxk1_sd | 1 | |
| taxk2_sd | taxk2_sd | 1 | |
| taxk3_sd | taxk3_sd | 1 | |
| taxk4_sd | taxk4_sd | 1 | |
| taxk5_sd | taxk5_sd | 1 | |
| taxk6_sd | taxk6_sd | 1 | |
| taxk7_sd | taxk7_sd | 1 | |
| taxk8_sd | taxk8_sd | 1 | |
| taxk9_sd | taxk9_sd | 1 | |
| tc_released | tc_released | 1 | |
| tccat | tccat | 1 | |
| tctyp | tctyp,TradingContractType | 2 | |
| telf1_sd | telf1_sd | 1 | |
| tew_type | tew_type | 1 | |
| tkonn_ex | tkonn_ex | 1 | |
| tkrate | tkrate | 1 | |
| tkrate_sd | tkrate_sd | 1 | |
| tksachb | tksachb | 1 | |
| tkwaers | tkwaers | 1 | |
| use_case | use_case | 1 | |
| vbtyp_sd | vbtyp_sd | 1 | |
| vkbur | vkbur | 1 | |
| vkgrp | vkgrp | 1 | |
| vkorg | SalesOrganization,vkorg | 2 | |
| vsbed_sd | vsbed_sd | 1 | |
| vtweg | DistributionChannel,vtweg | 2 | |
| wbpch | wbpch | 1 | |
| we_kunnr | we_kunnr | 1 | |
| wkurs_dat | wkurs_dat | 1 | |
| xblnr_sd | xblnr_sd | 1 | |
| xegdr | xegdr | 1 |
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.
-- Contract header
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CONTRACTHEAD (
TKONN,
_DATAAGING,
ABRVW,
ABSSC,
AEDAT,
AENAM,
AEZEIT,
AKPRZ,
AMTBL,
ANDTX_SD,
ANGDT_SD,
AUART,
AUDAT,
AUGRU,
AUTLF_SD,
BNAME_SD,
BNDDT_SD,
BSARK_SD,
BSTDK,
BSTNK,
BSTZD_SD,
BTBSTA,
BUDAT,
CMFRE,
CMNGV,
CMNUP,
CMWAE,
COMPANY_CODE,
COMPLETE,
CONSOL_IT_EXIST,
CREATED_FROM,
CTLPC,
DUMMY_WBHK_INCL_EEW_PS,
ERDAT,
ERNAM,
ERZEIT,
EXNUM,
FAKSK_SD,
FT_HEADER_COM,
GRUPP,
GUEBG,
GUEEN,
IHREZ_SD,
IN_APPROVAL,
KALSM_CH,
KALSM_SD,
KKBER,
KNKLI,
KNUMV_SD,
KOKRS,
KUNNR,
KURRF,
KURST,
KURST_SD,
KVGR1_SD,
KVGR2_SD,
KVGR3_SD,
KVGR4_SD,
KVGR5_SD,
LANDTX,
LAST_CHANGE_UUID,
LCNUM,
LFSPG,
LIFSK_SD,
LOGSYS,
MAHDT_SD,
MAHZA_SD,
NETWR_SD,
PF_LAST_ACTION,
PF_LAST_ORDER,
PF_STATUS,
PRICING_TYPE,
PRSDT_SD,
PS_PSP_PNR,
PURPOSE,
QUAN_COMPLETE,
SBGRP,
SDWRS,
SET_VARIANT,
SPART,
STCEG_L,
STCEG_L_SD,
SUBMI_SD,
SUCC_ARCH,
TAXK1_SD,
TAXK2_SD,
TAXK3_SD,
TAXK4_SD,
TAXK5_SD,
TAXK6_SD,
TAXK7_SD,
TAXK8_SD,
TAXK9_SD,
TC_RELEASED,
TCCAT,
TCTYP,
TELF1_SD,
TEW_TYPE,
TKONN_EX,
TKRATE,
TKRATE_SD,
TKSACHB,
TKWAERS,
USE_CASE,
VBTYP_SD,
VKBUR,
VKGRP,
VKORG,
VSBED_SD,
VTWEG,
WBPCH,
WE_KUNNR,
WKURS_DAT,
XBLNR_SD,
XEGDR,
PRIMARY KEY (TKONN)
);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