P_ACMContractHeader
P_ACMContractHeader is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (wbhk) and exposes 108 fields.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| wbhk | wbhk | from |
Annotations (10)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | PCONTRHEAD | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AccessControl.authorizationCheck | #NOT_REQUIRED | view | |
| ClientHandling.type | #INHERITED | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| VDM.viewType | #BASIC | view | |
| VDM.private | true | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #L | view |
Fields (108)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| tkonn | wbhk | tkonn | ||
| tctyp | wbhk | tctyp | ||
| kunnr | wbhk | kunnr | ||
| btbsta | wbhk | btbsta | ||
| tkwaers | wbhk | tkwaers | ||
| tkrate | wbhk | tkrate | ||
| ernam | wbhk | ernam | ||
| erdat | wbhk | erdat | ||
| erzeit | wbhk | erzeit | ||
| aenam | wbhk | aenam | ||
| aedat | wbhk | aedat | ||
| aezeit | wbhk | aezeit | ||
| vkorg | wbhk | vkorg | ||
| vtweg | wbhk | vtweg | ||
| spart | wbhk | spart | ||
| tksachb | wbhk | tksachb | ||
| bstnk | wbhk | bstnk | ||
| bstdk | wbhk | bstdk | ||
| sdwrs | wbhk | sdwrs | ||
| tkrate_sd | wbhk | tkrate_sd | ||
| kurst_sd | wbhk | kurst_sd | ||
| budat | wbhk | budat | ||
| prsdt_sd | wbhk | prsdt_sd | ||
| kurst | wbhk | kurst | ||
| augru | wbhk | augru | ||
| abssc | wbhk | abssc | ||
| lcnum | wbhk | lcnum | ||
| akprz | wbhk | akprz | ||
| logsys | wbhk | logsys | ||
| audat | wbhk | audat | ||
| exnum | wbhk | exnum | ||
| complete | wbhk | complete | ||
| angdt_sd | wbhk | angdt_sd | ||
| bnddt_sd | wbhk | bnddt_sd | ||
| submi_sd | wbhk | submi_sd | ||
| lifsk_sd | wbhk | lifsk_sd | ||
| faksk_sd | wbhk | faksk_sd | ||
| netwr_sd | wbhk | netwr_sd | ||
| vkgrp | wbhk | vkgrp | ||
| vkbur | wbhk | vkbur | ||
| autlf_sd | wbhk | autlf_sd | ||
| vsbed_sd | wbhk | vsbed_sd | ||
| bsark_sd | wbhk | bsark_sd | ||
| bstzd_sd | wbhk | bstzd_sd | ||
| ihrez_sd | wbhk | ihrez_sd | ||
| bname_sd | wbhk | bname_sd | ||
| telf1_sd | wbhk | telf1_sd | ||
| mahza_sd | wbhk | mahza_sd | ||
| mahdt_sd | wbhk | mahdt_sd | ||
| taxk1_sd | wbhk | taxk1_sd | ||
| taxk2_sd | wbhk | taxk2_sd | ||
| taxk3_sd | wbhk | taxk3_sd | ||
| taxk4_sd | wbhk | taxk4_sd | ||
| taxk5_sd | wbhk | taxk5_sd | ||
| taxk6_sd | wbhk | taxk6_sd | ||
| taxk7_sd | wbhk | taxk7_sd | ||
| taxk8_sd | wbhk | taxk8_sd | ||
| taxk9_sd | wbhk | taxk9_sd | ||
| xblnr_sd | wbhk | xblnr_sd | ||
| vbtyp_sd | wbhk | vbtyp_sd | ||
| stceg_l_sd | wbhk | stceg_l_sd | ||
| andtx_sd | wbhk | andtx_sd | ||
| kvgr1_sd | wbhk | kvgr1_sd | ||
| kvgr2_sd | wbhk | kvgr2_sd | ||
| kvgr3_sd | wbhk | kvgr3_sd | ||
| kvgr4_sd | wbhk | kvgr4_sd | ||
| kvgr5_sd | wbhk | kvgr5_sd | ||
| auart | wbhk | auart | ||
| kokrs | wbhk | kokrs | ||
| kkber | wbhk | kkber | ||
| knkli | wbhk | knkli | ||
| grupp | wbhk | grupp | ||
| sbgrp | wbhk | sbgrp | ||
| ctlpc | wbhk | ctlpc | ||
| cmwae | wbhk | cmwae | ||
| cmfre | wbhk | cmfre | ||
| cmnup | wbhk | cmnup | ||
| cmngv | wbhk | cmngv | ||
| amtbl | wbhk | amtbl | ||
| lfspg | wbhk | lfspg | ||
| wkurs_dat | wbhk | wkurs_dat | ||
| wbpch | wbhk | wbpch | ||
| kurrf | wbhk | kurrf | ||
| tc_released | wbhk | tc_released | ||
| tkonn_ex | wbhk | tkonn_ex | ||
| tccat | wbhk | tccat | ||
| we_kunnr | wbhk | we_kunnr | ||
| stceg_l | wbhk | stceg_l | ||
| landtx | wbhk | landtx | ||
| xegdr | wbhk | xegdr | ||
| use_case | wbhk | use_case | ||
| _dataaging | wbhk | _dataaging | ||
| tew_type | wbhk | tew_type | ||
| succ_arch | wbhk | succ_arch | ||
| abrvw | wbhk | abrvw | ||
| knumv_sd | wbhk | knumv_sd | ||
| pricing_type | wbhk | pricing_type | ||
| kalsm_sd | wbhk | kalsm_sd | ||
| ps_psp_pnr | wbhk | ps_psp_pnr | ||
| created_from | wbhk | created_from | ||
| company_code | wbhk | company_code | ||
| guebg | wbhk | guebg | ||
| gueen | wbhk | gueen | ||
| set_variant | wbhk | set_variant | ||
| in_approval | wbhk | in_approval | ||
| kalsm_ch | wbhk | kalsm_ch | ||
| purpose | wbhk | purpose | ||
| pf_status | wbhk | pf_status |
@AbapCatalog.sqlViewName: 'PCONTRHEAD'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.type: #INHERITED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
@VDM.private: true
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
define view P_ACMContractHeader as select from wbhk as wbhk //left outer join /accgo/t_cakhdr as link
//on wbhk.tkonn = link.linkid
{
wbhk.tkonn,
wbhk.tctyp,
wbhk.kunnr,
wbhk.btbsta,
wbhk.tkwaers,
wbhk.tkrate,
wbhk.ernam,
wbhk.erdat,
wbhk.erzeit,
wbhk.aenam,
wbhk.aedat,
wbhk.aezeit,
wbhk.vkorg,
wbhk.vtweg,
wbhk.spart,
wbhk.tksachb,
wbhk.bstnk,
wbhk.bstdk,
wbhk.sdwrs,
wbhk.tkrate_sd,
wbhk.kurst_sd,
wbhk.budat,
wbhk.prsdt_sd,
wbhk.kurst,
wbhk.augru,
wbhk.abssc,
wbhk.lcnum,
wbhk.akprz,
wbhk.logsys,
wbhk.audat,
wbhk.exnum,
wbhk.ft_header_com,
wbhk.complete,
wbhk.angdt_sd,
wbhk.bnddt_sd,
wbhk.submi_sd,
wbhk.lifsk_sd,
wbhk.faksk_sd,
wbhk.netwr_sd,
wbhk.vkgrp,
wbhk.vkbur,
wbhk.autlf_sd,
wbhk.vsbed_sd,
wbhk.bsark_sd,
wbhk.bstzd_sd,
wbhk.ihrez_sd,
wbhk.bname_sd,
wbhk.telf1_sd,
wbhk.mahza_sd,
wbhk.mahdt_sd,
wbhk.taxk1_sd,
wbhk.taxk2_sd,
wbhk.taxk3_sd,
wbhk.taxk4_sd,
wbhk.taxk5_sd,
wbhk.taxk6_sd,
wbhk.taxk7_sd,
wbhk.taxk8_sd,
wbhk.taxk9_sd,
wbhk.xblnr_sd,
wbhk.vbtyp_sd,
wbhk.stceg_l_sd,
wbhk.andtx_sd,
wbhk.kvgr1_sd,
wbhk.kvgr2_sd,
wbhk.kvgr3_sd,
wbhk.kvgr4_sd,
wbhk.kvgr5_sd,
wbhk.auart,
wbhk.quan_complete,
wbhk.kokrs,
wbhk.kkber,
wbhk.knkli,
wbhk.grupp,
wbhk.sbgrp,
wbhk.ctlpc,
wbhk.cmwae,
wbhk.cmfre,
wbhk.cmnup,
wbhk.cmngv,
wbhk.amtbl,
wbhk.lfspg,
wbhk.wkurs_dat,
wbhk.wbpch,
wbhk.kurrf,
wbhk.tc_released,
wbhk.tkonn_ex,
wbhk.tccat,
wbhk.we_kunnr,
wbhk.stceg_l,
wbhk.landtx,
wbhk.xegdr,
wbhk.use_case,
wbhk._dataaging,
wbhk.dummy_wbhk_incl_eew_ps,
wbhk.tew_type,
wbhk.succ_arch,
wbhk.abrvw,
wbhk.knumv_sd,
wbhk.pricing_type,
wbhk.kalsm_sd,
wbhk.ps_psp_pnr,
wbhk.last_change_uuid,
wbhk.created_from,
wbhk.company_code,
wbhk.guebg,
wbhk.gueen,
wbhk.consol_it_exist,
wbhk.set_variant,
wbhk.in_approval,
wbhk.kalsm_ch,
wbhk.purpose,
wbhk.pf_status,
wbhk.pf_last_action,
wbhk.pf_last_order
// link.tkonn as link_tkonn,
// link.linkid,
// link.int_tctyp
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"WBHK"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA