P_TradingContractOverview

@AbapCatalog.sqlViewName: 'PTRDGCTROVW'
@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: #XL
define view P_TradingContractOverview
  as select from P_TradingContractHeader as Header
  inner join P_TradingContractBusinessDets as Business   on  Header.tkonn = Business.TradingContractNumber
  //inner join I_TrdgContractGenDocInfo      as GenDocInfo on  Header.tkonn = GenDocInfo.TradingContractNumber

//  inner join P_TradingContractCounterparty as Counterparty on Header.kunnr = Counterparty.Counterparty

  left outer join P_TradingContractCounterparty as Counterparty on Header.kunnr = Counterparty.Counterparty /*" To get Contracts without Vendor/Customer(Template)*/
                                                           or Business.PurchaseOrderSupplier = Counterparty.Counterparty
  left outer join I_CmmdtyDrvtvGenericDomainVH  as Side    on Header.Side = Side.DomainValue
                                                          and Side.SAPDataDictionaryDomain = 'WLF_PR_SIDE'
{
  key Header.tkonn                          as TradingContractNumber,
      Header.tctyp                          as TradingContractType,
      Header.tctyp_descr                    as TradingContractTypeName,
      Header.Side                           as Side,
      Header.btbsta                         as ContractStatus,
      Header.bezei                          as TrdgContrApplStsName,

      case Header.Side
        when 'M'
         then Business.TradingContractCurrency
        else
          Header.sdwrs

        end as TradingContractCurrency,


      Header.vkorg                          as SalesOrganization,
      Header.vtweg                          as DistributionChannel,
      Header.spart                          as Division,
      Business.PurchasingOrganization       as PurchasingOrganization,
      Business.ekotx,
      Business.PurchasingGroup              as PurchasingGroup,
      Business.eknam,
      Header.tkonn_ex                       as TradingContractExternalID,
      Header.erdat                          as TradingContrCreatedOnDate,
      Header.budat                          as DocumentDate,
      Header.tksachb                        as PersonResponsible,
      Header.PersonResponsible              as PersonResponsibleName,
      Header.ernam                          as TradingContractCreatedBy,
      Header.CreatedBy                      as TradingContractCreatedByName,
      Header.aenam                          as TradingContractChangedBy,
      Header.ChangedBy                      as TradingContractChangedByName,
      Header.aedat                          as TradingContractChangedOnDate,
      Header.DistributionChannelDescr,
      Header.SalesDivisionDescr,
      Header.SalesOrgDescr,
      Side.DomainText as DocumentSide,

      Counterparty.Counterparty as Counterparty,

      case Header.Side
      when 'M'
        then Business.ACMPurgIncotermsPart1
      else
        Business.ACMSlsIncotermsPart1
      end                                   as Incoterms,

      Business.IncotermsClassificationName as IncotermsClassificationName,
      case Header.Side
      when 'M'
       then Business.TrdgContrPurgIncotermsLoc1Text
      else
       Business.TrdgContrSlsIncotermsLoc1Text
      end                                   as IncotermsLocation1,

      Business.TrdgContrPurgIncotermsLoc1Text,//+Free Text Search

      Business.TrdgContrSlsIncotermsLoc1Text,//+Free Text Search


      company_code as CompanyCode,

// Begin of changes for OP2020FPS01_new_development

//Below case is added as AlternativePaymentTerm was blank for Sales scenario

      case Header.Side
      when 'M'
        then Business.TrdgContrPurgPaymentTerms
      else   Business.TrdgContrSalesPaymentTerms
      end                                   as AlternatePaymentTerm,
// End of changes for OP2020FPS01_new_development



//Begin of change for CHS 1909 FPS 02, Adding Trader Id and Amending Trader Id to the list.

      Header.resp_trader_id,
      Header.orig_resp_trader_id,
      Header.TradingContractTradeOffice,
      Header.TradingContractCreditSales,
      Header.ACMSignedStatus,
//End of change.

//Begin of change for Adding Contract Closure With CDOTE Indicator.

      Header.ACMTrdgContrIsStatusClosed,
//End of change.


      //Added

      Business.ACMSupplyingPlant,
      Business.ACMReferencePO,
      Business.ACMCustomerReference,
      Business.ACMYourReference


}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CMMDTYDRVTVGENERICDOMAINVH",
"P_TRADINGCONTRACTBUSINESSDETS",
"P_TRADINGCONTRACTCOUNTERPARTY",
"P_TRADINGCONTRACTHEADER"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/