P_TRADINGCONTRACTHEADER

@AbapCatalog:
{
    sqlViewName: 'PTRDGCTRHDR',
    compiler.compareFilter: true,
    preserveKey: true
}
@AccessControl.authorizationCheck: #CHECK
@ClientHandling:
{
    type: #INHERITED,
    algorithm: #SESSION_VARIABLE
}
@VDM:
{
    viewType: #COMPOSITE,
    private: true
}
@ObjectModel.usageType:
{
    dataClass: #TRANSACTIONAL,
    serviceQuality: #C,
    sizeCategory: #L
}
define view P_TradingContractHeader
  as select from           I_ContractHead                 as Header
    left outer to one join I_TradingContractStatusDesc    as Status                   on  Header.btbsta   = Status.ContractStatus
                                                                                      and Status.Language = $session.system_language
    left outer to one join I_ACMTradingContractTypeVH     as ContractType             on Header.tctyp = ContractType.TradingContractType
    left outer to one join I_ACMCreatedByUser             as CreatedbyDetails         on Header.ernam = CreatedbyDetails.UserName
    left outer to one join I_ACMCreatedByUser             as personresponsibledetails on Header.tksachb = personresponsibledetails.UserName
    left outer to one join I_ACMCreatedByUser             as ChangedbyDetails         on Header.aenam = ChangedbyDetails.UserName
    left outer to one join I_ACMSalesOrganizationValHelp  as SalesOrganizationText    on Header.vkorg = SalesOrganizationText.SalesOrganization
    left outer to one join I_ACMDistributionChnlValueHelp as DistributionChannelText  on  Header.vkorg = DistributionChannelText.SalesOrganization
                                                                                      and Header.vtweg = DistributionChannelText.DistributionChannel
    left outer to one join I_ACMSalesDivisionValueHelp    as OrganizationDivisionName on  Header.vkorg = OrganizationDivisionName.SalesOrganization
                                                                                      and Header.vtweg = OrganizationDivisionName.DistributionChannel
                                                                                      and Header.spart = OrganizationDivisionName.Division
    left outer to one join I_ACMTrdgContrHdrAddlDets      as AdditionalHeader         on Header.tkonn = AdditionalHeader.TradingContractNumber
{
  key Header.tkonn,
      Header.tctyp,
      Header.kunnr,
      Header.btbsta,
      Header.tkwaers,
      Header.tkrate,
      Header.ernam,
      Header.erdat,
      Header.erzeit,
      Header.aenam,
      Header.aedat,
      Header.aezeit,
      Header.vkorg,
      Header.vtweg,
      Header.spart,
      Header.tksachb,
      Header.bstnk,
      Header.bstdk,
      Header.sdwrs,
      Header.tkrate_sd,
      Header.kurst_sd,
      Header.budat,
      Header.prsdt_sd,
      Header.kurst,
      Header.augru,
      Header.abssc,
      Header.lcnum,
      Header.akprz,
      Header.logsys,
      Header.audat,
      Header.exnum,
      Header.ft_header_com,
      Header.complete,
      Header.angdt_sd,
      Header.bnddt_sd,
      Header.submi_sd,
      Header.lifsk_sd,
      Header.faksk_sd,
      Header.netwr_sd,
      Header.vkgrp,
      Header.vkbur,
      Header.autlf_sd,
      Header.vsbed_sd,
      Header.bsark_sd,
      Header.bstzd_sd,
      Header.ihrez_sd,
      Header.bname_sd,
      Header.telf1_sd,
      Header.mahza_sd,
      Header.mahdt_sd,
      Header.taxk1_sd,
      Header.taxk2_sd,
      Header.taxk3_sd,
      Header.taxk4_sd,
      Header.taxk5_sd,
      Header.taxk6_sd,
      Header.taxk7_sd,
      Header.taxk8_sd,
      Header.taxk9_sd,
      Header.xblnr_sd,
      Header.vbtyp_sd,
      Header.stceg_l_sd,
      Header.andtx_sd,
      Header.kvgr1_sd,
      Header.kvgr2_sd,
      Header.kvgr3_sd,
      Header.kvgr4_sd,
      Header.kvgr5_sd,
      Header.auart,
      Header.quan_complete,
      Header.kokrs,
      Header.kkber,
      Header.knkli,
      Header.grupp,
      Header.sbgrp,
      Header.ctlpc,
      Header.cmwae,
      Header.cmfre,
      Header.cmnup,
      Header.cmngv,
      Header.amtbl,
      Header.lfspg,
      Header.wkurs_dat,
      Header.wbpch,
      Header.kurrf,
      Header.tc_released,
      Header.tkonn_ex,
      Header.tccat,
      Header.we_kunnr,
      Header.stceg_l,
      Header.landtx,
      Header.xegdr,
      Header.use_case,
      Header._dataaging,
      Header.dummy_wbhk_incl_eew_ps,
      Header.tew_type,
      Header.succ_arch,
      Header.abrvw,
      Header.knumv_sd,
      Header.pricing_type,
      Header.kalsm_sd,
      Header.ps_psp_pnr,
      Header.last_change_uuid,
      Header.created_from,
      Header.company_code,
      Header.guebg,
      Header.gueen,
      Header.consol_it_exist,
      Header.set_variant,
      Header.in_approval,
      Header.kalsm_ch,
      Header.purpose,
      Header.pf_status,
      Header.pf_last_action,
      Header.pf_last_order,
      AdditionalHeader.ACMTrdgContrIsStatusClosed     as ACMTrdgContrIsStatusClosed,
      AdditionalHeader.ACMAmendingTraderID            as resp_trader_id,
      AdditionalHeader.ACMOriginalTraderID            as orig_resp_trader_id,
      AdditionalHeader.TradingContractTradeOffice,
      AdditionalHeader.TradingContractCreditSales,
      AdditionalHeader.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
}