P_TradingContractHeader

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_TradingContractHeader.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW P_TradingContractHeader AS
SELECT
  Header.tkonn AS tkonn,
  Header.tctyp AS tctyp,
  Header.kunnr AS kunnr,
  Header.btbsta AS btbsta,
  Header.tkwaers AS tkwaers,
  Header.tkrate AS tkrate,
  Header.ernam AS ernam,
  Header.erdat AS erdat,
  Header.erzeit AS erzeit,
  Header.aenam AS aenam,
  Header.aedat AS aedat,
  Header.aezeit AS aezeit,
  Header.vkorg AS vkorg,
  Header.vtweg AS vtweg,
  Header.spart AS spart,
  Header.tksachb AS tksachb,
  Header.bstnk AS bstnk,
  Header.bstdk AS bstdk,
  Header.sdwrs AS sdwrs,
  Header.tkrate_sd AS tkrate_sd,
  Header.kurst_sd AS kurst_sd,
  Header.budat AS budat,
  Header.prsdt_sd AS prsdt_sd,
  Header.kurst AS kurst,
  Header.augru AS augru,
  Header.abssc AS abssc,
  Header.lcnum AS lcnum,
  Header.akprz AS akprz,
  Header.logsys AS logsys,
  Header.audat AS audat,
  Header.exnum AS exnum,
  Header.complete AS complete,
  Header.angdt_sd AS angdt_sd,
  Header.bnddt_sd AS bnddt_sd,
  Header.submi_sd AS submi_sd,
  Header.lifsk_sd AS lifsk_sd,
  Header.faksk_sd AS faksk_sd,
  Header.netwr_sd AS netwr_sd,
  Header.vkgrp AS vkgrp,
  Header.vkbur AS vkbur,
  Header.autlf_sd AS autlf_sd,
  Header.vsbed_sd AS vsbed_sd,
  Header.bsark_sd AS bsark_sd,
  Header.bstzd_sd AS bstzd_sd,
  Header.ihrez_sd AS ihrez_sd,
  Header.bname_sd AS bname_sd,
  Header.telf1_sd AS telf1_sd,
  Header.mahza_sd AS mahza_sd,
  Header.mahdt_sd AS mahdt_sd,
  Header.taxk1_sd AS taxk1_sd,
  Header.taxk2_sd AS taxk2_sd,
  Header.taxk3_sd AS taxk3_sd,
  Header.taxk4_sd AS taxk4_sd,
  Header.taxk5_sd AS taxk5_sd,
  Header.taxk6_sd AS taxk6_sd,
  Header.taxk7_sd AS taxk7_sd,
  Header.taxk8_sd AS taxk8_sd,
  Header.taxk9_sd AS taxk9_sd,
  Header.xblnr_sd AS xblnr_sd,
  Header.vbtyp_sd AS vbtyp_sd,
  Header.stceg_l_sd AS stceg_l_sd,
  Header.andtx_sd AS andtx_sd,
  Header.kvgr1_sd AS kvgr1_sd,
  Header.kvgr2_sd AS kvgr2_sd,
  Header.kvgr3_sd AS kvgr3_sd,
  Header.kvgr4_sd AS kvgr4_sd,
  Header.kvgr5_sd AS kvgr5_sd,
  Header.auart AS auart,
  Header.kokrs AS kokrs,
  Header.kkber AS kkber,
  Header.knkli AS knkli,
  Header.grupp AS grupp,
  Header.sbgrp AS sbgrp,
  Header.ctlpc AS ctlpc,
  Header.cmwae AS cmwae,
  Header.cmfre AS cmfre,
  Header.cmnup AS cmnup,
  Header.cmngv AS cmngv,
  Header.amtbl AS amtbl,
  Header.lfspg AS lfspg,
  Header.wkurs_dat AS wkurs_dat,
  Header.wbpch AS wbpch,
  Header.kurrf AS kurrf,
  Header.tc_released AS tc_released,
  Header.tkonn_ex AS tkonn_ex,
  Header.tccat AS tccat,
  Header.we_kunnr AS we_kunnr,
  Header.stceg_l AS stceg_l,
  Header.landtx AS landtx,
  Header.xegdr AS xegdr,
  Header.use_case AS use_case,
  Header._dataaging AS _dataaging,
  Header.tew_type AS tew_type,
  Header.succ_arch AS succ_arch,
  Header.abrvw AS abrvw,
  Header.knumv_sd AS knumv_sd,
  Header.pricing_type AS pricing_type,
  Header.kalsm_sd AS kalsm_sd,
  Header.ps_psp_pnr AS ps_psp_pnr,
  Header.created_from AS created_from,
  Header.company_code AS company_code,
  Header.guebg AS guebg,
  Header.gueen AS gueen,
  Header.set_variant AS set_variant,
  Header.in_approval AS in_approval,
  Header.kalsm_ch AS kalsm_ch,
  Header.purpose AS purpose,
  Header.pf_status AS pf_status,
  AdditionalHeader.ACMTrdgContrIsStatusClosed AS ACMTrdgContrIsStatusClosed,
  AdditionalHeader.TradingContractTradeOffice AS TradingContractTradeOffice,
  AdditionalHeader.TradingContractCreditSales AS TradingContractCreditSales,
  AdditionalHeader.ACMSignedStatus AS ACMSignedStatus,
  Status.TrdgContrApplStsName AS bezei,
  ContractType.TradingContractTypeName AS tctyp_descr,
  CreatedbyDetails.UserDescription AS CreatedBy,
  DistributionChannelText.DistributionChannelText AS DistributionChannelDescr,
  OrganizationDivisionName.DivisionName AS SalesDivisionDescr,
  SalesOrganizationText.SalesOrganizationText AS SalesOrgDescr,
  personresponsibledetails.UserDescription AS PersonResponsible,
  ChangedbyDetails.UserDescription AS ChangedBy
FROM I_ContractHead AS Header
;