@AbapCatalog.sqlViewName: 'PTRDGCTRHDR'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.type: #INHERITED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #COMPOSITE
@VDM.private: true
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
define view P_TradingContractHeader
as select distinct from I_ContractHead as Header
inner join I_ACMTrdgContrShadowItemDets as Shadow on Header.tkonn = Shadow.ContractNum
// left outer join I_ACMTradingContractStatus as Status on Header.btbsta = Status.ContractStatus
left outer join I_TradingContractStatusDesc as Status on Header.btbsta = Status.ContractStatus
and Status.Language = $session.system_language
left outer join I_ACMTradingContractTypeVH as ContractType on Header.tctyp = ContractType.TradingContractType
left outer join I_CreatedByUser as CreatedbyDetails on Header.ernam = CreatedbyDetails.UserName
left outer join I_CreatedByUser as personresponsibledetails on Header.tksachb = personresponsibledetails.UserName
left outer join I_CreatedByUser as ChangedbyDetails on Header.aenam = ChangedbyDetails.UserName
left outer join I_ACMDistributionChnlValueHelp as DistributionChannelText on Header.vtweg = DistributionChannelText.DistributionChannel
left outer join I_ACMSalesDivisionValueHelp as OrganizationDivisionName on Header.spart = OrganizationDivisionName.Division
left outer join I_ACMSalesOrganizationValHelp as SalesOrganizationText on Header.vkorg = SalesOrganizationText.SalesOrganization
//Begin of change for CHS 1909 FPS 02, Adding Trader Id and Amending Trader Id to the list.
left outer join I_ACMTrdgContrHdrAddlDets as TrdgContrHdrAddDets on Header.tkonn = TrdgContrHdrAddDets.TradingContractNumber
//End of change.
{
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,
//Begin of change for Adding Contract Closure With CDOTE Indicator.
TrdgContrHdrAddDets.ACMTrdgContrIsStatusClosed as ACMTrdgContrIsStatusClosed,
//End of change.
//Begin of change for CHS 1909 FPS 02, Adding Trader Id and Amending Trader Id to the list.
TrdgContrHdrAddDets.ACMAmendingTraderID as resp_trader_id,
TrdgContrHdrAddDets.ACMOriginalTraderID as orig_resp_trader_id,
TrdgContrHdrAddDets.TradingContractTradeOffice,
TrdgContrHdrAddDets.TradingContractCreditSales,
TrdgContrHdrAddDets.ACMSignedStatus,
//End of change.
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,
Shadow.DocumentSide as Side
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ACMDISTRIBUTIONCHNLVALUEHELP",
"I_ACMSALESDIVISIONVALUEHELP",
"I_ACMSALESORGANIZATIONVALHELP",
"I_ACMTRADINGCONTRACTTYPEVH",
"I_ACMTRDGCONTRHDRADDLDETS",
"I_ACMTRDGCONTRSHADOWITEMDETS",
"I_CONTRACTHEAD",
"I_CREATEDBYUSER",
"I_TRADINGCONTRACTSTATUSDESC"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/