R_PPS_PurchaseContractTP

@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #REQUIRED
@EndUserText.label: 'Purchase Contract Header'
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@ObjectModel.semanticKey:  [ 'PurchaseContract' ]
@ObjectModel.representativeKey: 'PurchaseContract'

@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #L,
  dataClass: #TRANSACTIONAL
}
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.sapObjectNodeType.name: 'PurchaseContract'

define root view entity R_PPS_PurchaseContractTP
  as select from I_PurchaseContract as PurchaseContract
  association [1..1] to I_PurContrCnsmpnInPercentage   as _PurContrCnsmpnInPercentage   on  PurchaseContract.ActivePurchasingDocument = _PurContrCnsmpnInPercentage.PurchaseContract

  composition [1..*] of R_PPS_PurchaseContractItemTP   as _PurchaseContractItem
  composition [1..*] of R_PPS_PurContrHdrCndnValdtyTP  as _PurchaseContractHeaderPricing
  composition [0..*] of R_PPS_PurContractPartnerTP     as _PurContrPartner
  composition [0..*] of R_PPS_PurContractHeaderNoteTP  as _PurContrHdrNote
  composition [1..*] of R_PPS_PurContractContactTP     as _PurchaseContractContact // @JIRA-KEY<S4PPS-10167,S4PPS-12772,S4PPS-10168>

  association [1..1] to I_ContractTransientField       as _ContractTransientField       on  $projection.PurchaseContract = _ContractTransientField.PurchaseContract
  association [1..1] to I_PurchaseContractStatus       as _PurchaseContractStatus       on  $projection.PurchasingProcessingStatus = _PurchaseContractStatus.PurchasingProcessingStatus
                                                                                        and _PurchaseContractStatus.Language       = $session.system_language
  association [1..1] to I_Purchasecontracttype_Vh      as _PurContrTypeVH               on  $projection.PurchaseContractType = _PurContrTypeVH.PurchasingDocumentType
  association [1..1] to R_PPS_PurContractHdrExtension  as _PurchaseContractHdrExtension on  $projection.PurchaseContract = _PurchaseContractHdrExtension.PurchaseContract
  association [0..1] to I_PPS_PurgDocVersionReasonVH   as _VersionReasonValHelp         on  $projection.PurchasingDocVersionReasonCode = _VersionReasonValHelp.PurchasingDocVersionReasonCode
  association [0..1] to I_PPS_PurgDocModifTypeVH       as _ModificationType             on  $projection.ppsmodificationtype = _ModificationType.PPSModificationType
  association [0..1] to I_PPS_PurgDocModifTypeText     as _ModificationTypeText         on  $projection.ppsmodificationtype = _ModificationTypeText.PPSModificationType
                                                                                        and _ModificationTypeText.Language  = $session.system_language
  association [0..1] to I_PPS_PurContrChgVersDrft      as _Draft                        on  $projection.ActivePurchasingDocument = _Draft.ActivePurchasingDocument
  association [1..1] to I_PPS_PurContrDocType          as _PurchaseContractDoc          on  PurchaseContract.PurchaseContractType       = _PurchaseContractDoc.PurchaseContractType
                                                                                        and PurchaseContract.PurchasingDocumentCategory = _PurchaseContractDoc.PurchasingDocumentCategory
  association [1..1] to I_PPS_PurgDocClassificationTxt as _Classification               on  $projection.PPSPurgDocClassfctnCode = _Classification.PPSPurgDocClassfctnCode
                                                                                        and _Classification.Language         = $session.system_language
  association [1..1] to I_PPS_PurgDocHdrStatusText     as _PurContrStatusText           on  $projection.ppspurcontrheaderstatus = _PurContrStatusText.PurchasingDocumentStatus //@JIRA_KEY: <S4PPS-14333>

                                                                                        and _PurContrStatusText.Language        = $session.system_language
  ---Extension Association
  association [1..1] to E_PurchasingDocument           as _PurchaseContractExtension    on  $projection.PurchaseContract = _PurchaseContractExtension.PurchasingDocument

  ---Extension Draft Association
  association [1..1] to E_PurchasingDocument           as _PurchaseCtrDraftExtension    on  $projection.PurchaseContract = _PurchaseCtrDraftExtension.PurchasingDocument //dummy


  {
      @ObjectModel.text.element: ['PurchasingDocumentName']
      // @UI.textArrangement: #TEXT_LAST


  key PurchaseContract.PurchaseContract,
      cast ( hextobin( '00000000000000000000000000000000' ) as sysuuid_x16 )                                                                                                                                                                                                                                                      as PurchaseContractUUID,
      PurchaseContract.PurchaseContractType,
      PurchaseContract.PurchasingDocumentCategory,
      PurchaseContract.LastChangeDateTime,
      PurchaseContract.CreationDate,
      PurchaseContract.Supplier,
      PurchaseContract.CompanyCode,
      PurchaseContract.PurchasingOrganization,
      PurchaseContract.PurchasingGroup,
      PurchaseContract.DocumentCurrency,
      PurchaseContract.IncotermsClassification,
      PurchaseContract.IncotermsTransferLocation,
      PurchaseContract.PaymentTerms,
      PurchaseContract.CashDiscount1Days,
      PurchaseContract.CashDiscount2Days,
      PurchaseContract.NetPaymentDays,
      PurchaseContract.CashDiscount1Percent,
      PurchaseContract.CashDiscount2Percent,

      @Semantics.amount.currencyCode:'DocumentCurrency'
      PurchaseContract.PurchaseContractTargetAmount,
      PurchaseContract.ValidityStartDate,
      PurchaseContract.ValidityEndDate,

      @ObjectModel.foreignKey.association: '_ReleaseCode'
      PurchaseContract.ReleaseCode,
      PurchaseContract.PurchasingDocumentVersion,

      PurchaseContract.CreatedByUser,
      PurchaseContract.PurchasingDocumentDeletionCode,
      PurchaseContract.SupplyingSupplier,
      PurchaseContract.InvoicingParty,
      PurchaseContract.PurgDocIsChgVers,

      cast(abs(PurchaseContract.ExchangeRate) as fis_absolute_exchangerate preserving type)                                                                                                                                                                                                                                       as AbsoluteExchangeRate,
      cast(case
            when PurchaseContract.ExchangeRate < 0 then 'X'
             else ''
             end as fis_indirect_quotation preserving type)                                                                                                                                                                                                                                                                       as ExchRateIsIndirectQuotation,
      cast(case
            when PurchaseContract.ExchangeRate < 0 then division(1,abs(PurchaseContract.ExchangeRate),5)
            else PurchaseContract.ExchangeRate
            end as fis_effective_exchangerate)                                                                                                                                                                                                                                                                                    as EffectiveExchangeRate,

      PurchaseContract.ExchangeRateIsFixed,
      PurchaseContract.QuotationSubmissionDate,
      PurchaseContract.SupplierQuotation,
      PurchaseContract.CorrespncExternalReference,
      PurchaseContract.CorrespncInternalReference,
      PurchaseContract.SupplierRespSalesPersonName,
      PurchaseContract.SupplierPhoneNumber,
      PurchaseContract.IncotermsVersion,
      PurchaseContract.IncotermsLocation1,
      PurchaseContract.IncotermsLocation2,
      PurchaseContract.ActivePurchasingDocument,
      //BOC @JIRA-KEY <S4PPS-9893>

      PurchaseContract.PurchasingDocVersionReasonCode,
      _PurchaseContractHdrExtension.PPSRevisionComment,
      //EOC @JIRA-KEY <S4PPS-9893>

      @Semantics.text: true
      PurchaseContract.PurchasingDocumentName,
      PurchaseContract.PurchasingDocumentOrigin,
      PurchaseContract.ReleaseIsNotCompleted,
      PurchaseContract.PurchasingProcessingStatus,
      case _Draft.PPSPurgDocHasChgVersDrft
        when '1' then (cast('X' as boolean)) //Hide Target Value

        else (cast('' as boolean))
      end                                                                                                                                                                                                                                                                                                                         as PPSPurgDocHasChgVersDrft,
      PurchaseContract.PurgDocChangeRequestStatus,
      PurchaseContract.PurgAggrgdProdCmplncSuplrSts,
      PurchaseContract.SupplierAddressID,
      PurchaseContract.PurgHasCatalogRelevantItems,
      @Semantics.booleanIndicator: true
      PurchaseContract.IsEndOfPurposeBlocked,
      _ContractTransientField.IsPurContrTemplate,
      /* Confidential field on header */
      _PurchaseContractHdrExtension.PPSPurgDocClassfctnCode                                                                                                                                                                                                                                                                          as PPSPurgDocClassfctnCode,

      cast ('' as boolean)                                                                                                                                                                                                                                                                                                        as PurgContractIsInPreparation,

   @Semantics.quantity.unitOfMeasure:'PurContrConsumptionUnit'
      cast( _PurContrCnsmpnInPercentage.ContractConsumptionInPct as abap.dec(18,3) )                                                                                                                                                                                                                                              as PurContractConsumptionInPct  ,
    @Semantics.quantity.unitOfMeasure:'PurContrConsumptionUnit'
      cast( _PurContrCnsmpnInPercentage.ContractConsumptionInPct as abap.dec(18,3))                                                                                                                                                                                                                                               as ContractConsumptionInPct, // @JIRA-KEY<S4PPS-5049>

      cast( '%' as abap.unit( 3 ) )                                                                                                                                                                                                                                                                                               as PurContrConsumptionUnit,
      cast ('' as boolean)                                                                                                                                                                                                                                                                                                        as PurContrHasAdvncdUsrInterface,
      cast( _ContractTransientField.PurContrOutputCtrlType as mm_oa_oc_type )                                                                                                                                                                                                                                                     as PurContrOutputCtrlType,
      cast( _ContractTransientField.PurContrOutputCtrlStatus as mm_oa_oc_status )                                                                                                                                                                                                                                                 as PurContrOutputCtrlStatus,
      cast( _ContractTransientField.PurContrOutputCtrlStatusTxt as mm_oa_oc_status_txt )                                                                                                                                                                                                                                          as PurContrOutputCtrlStatusTxt,
      cast( _ContractTransientField.PurContrOutputCtrlDateTime as mm_oa_oc_time )                                                                                                                                                                                                                                                 as PurContrOutputCtrlDateTime,
      cast( _ContractTransientField.AccWorkflowApprover as mm_oa_approver_id )                                                                                                                                                                                                                                                    as AccWorkflowApprover,
      cast( _ContractTransientField.AccWorkflowApproverFirstName as mm_oa_approver_name )                                                                                                                                                                                                                                         as AccWorkflowApproverFirstName,
      cast( _ContractTransientField.ApprovalStatusName as val_text )                                                                                                                                                                                                                                                              as ApprovalStatusName,
      //    _PurchasingDocument.smart_number_hdr                                                as SmartNumberHeader,

      cast ( '' as pps_e_control_string )                                                                                                                                                                                                                                                                                         as PPS_PurContrHdrControlString,
//      cast ( hextobin( '00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000' ) as pps_e_control_flag preserving type ) as PPSFieldChangeIndicatorBinary,

      cast ( ' '  as knumh )                                                                                                                                                                                                                                                                                                      as ConditionRecord,
      _PurchaseContractHdrExtension.PPSFieldChangeIndicatorString as PPSFieldChangeIndicatorString,
      cast ( hextobin( _PurchaseContractHdrExtension.PPSFieldChangeIndicatorString ) as pps_e_control_flag preserving type )  as PPSFieldChangeIndicatorBinary,
   //   cast ( hextobin( '00000000000000000000000000000000' ) as sysuuid_x16 )                                                                                                                                                                                                                                                      as PurchaseContractDraftUUID,

      _PurchaseContractHdrExtension.PPSPerdOfPerfStartDate,
      _PurchaseContractHdrExtension.PPSPerdOfPerfEndDate,
      //       JIRA KEY:10051

      _PurchaseContractHdrExtension.PPSSmartNumberHeader, //@JIRA-KEY<S4PPS-10051>

      _PurchaseContractHdrExtension.PPSSmartNumberHeaderIsManual, //@JIRA-KEY<S4PPS-10862>

      _PurchaseContractHdrExtension.PPSSmartDocumentNumber, //@JIRA-KEY<S4PPS-10054>

      _PurchaseContractHdrExtension.PPSModificationType,
      _PurchaseContractHdrExtension.PPSNumberOfModification                                                                                                                                                                                                                                                                       as PPSNumberOfModification,
      _PurchaseContractHdrExtension.PPSModificationTypeText,
      _PurchaseContractHdrExtension.PPSModificationIdentifierCode, //@JIRA_KEY: <S4PPS-15688>

      _PurchaseContractHdrExtension.PPSPurContrHeaderStatus, //@JIRA_KEY: <S4PPS-14333>

      case  _PurchaseContractHdrExtension.PPSPurContrHeaderStatus //@JIRA_KEY: <S4PPS-14333>

      when '02' then 3 // Active - Green

      when '03' then 1 // Deleted - Red

      when '04' then 1 // Rejected - Red

      when '05' then 2 // Awaiting Approval - Yellow

      else  null
      end                                                                                                                                                                                                                                                                                                                         as ProcessingStatusCriticality,
      /* Associations */
      _PurchaseContractItem,
      _PurchaseContractDoc,
      _PurContrPartner,
      _PurContrHdrNote,
      _PurchaseContractContact, //@JIRA-KEY<S4PPS-10167,S4PPS-12772,S4PPS-10168>

      _ContractTransientField,
      _PurchaseContractStatus,
      _PurContrStatusText, //@JIRA_KEY: <S4PPS-14333>

      _PurContrTypeVH,
      _PurchaseContractHdrExtension,
      _PurchaseContractHeaderPricing,
      _VersionReasonValHelp,
      _ModificationType,
      _ModificationTypeText,


      /* Foreign key associations */
      PurchaseContract._CompanyCode,
      PurchaseContract._CreatedByUser,
      PurchaseContract._DocumentCurrency,
      PurchaseContract._IncotermsClassification,
      PurchaseContract._InvoicingParty,
      PurchaseContract._PaymentTerms,
      PurchaseContract._PurchasingDocumentCategory,
      PurchaseContract._PurchasingGroup,
      PurchaseContract._PurchasingOrganization,
      PurchaseContract._PurCtrPartners,
      PurchaseContract._ReleaseCode,
      PurchaseContract._Supplier,
      PurchaseContract._SupplyingSupplier,
     // _Draft,

      _Classification
}
where
  PurchaseContract.PurchaseContractType = _PurchaseContractDoc.PurchaseContractType
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CONTRACTTRANSIENTFIELD",
"I_PPS_PURCONTRCHGVERSDRFT",
"I_PPS_PURCONTRDOCTYPE",
"I_PURCHASECONTRACT",
"I_PURCONTRCNSMPNINPERCENTAGE",
"R_PPS_PURCONTRACTHDREXTENSION"
],
"ASSOCIATED":
[
"I_COMPANYCODE",
"I_CONTRACTTRANSIENTFIELD",
"I_CURRENCY",
"I_INCOTERMSCLASSIFICATION",
"I_PAYMENTTERMS",
"I_PPS_PURCONTRDOCTYPE",
"I_PPS_PURGDOCCLASSIFICATIONTXT",
"I_PPS_PURGDOCHDRSTATUSTEXT",
"I_PPS_PURGDOCMODIFTYPETEXT",
"I_PPS_PURGDOCMODIFTYPEVH",
"I_PPS_PURGDOCVERSIONREASONVH",
"I_PURCHASECONTRACTSTATUS",
"I_PURCHASECONTRACTTYPE_VH",
"I_PURCHASINGDOCUMENTCATEGORY",
"I_PURCHASINGGROUP",
"I_PURCHASINGORGANIZATION",
"I_PURCTRPARTNERS",
"I_RELEASECODE",
"I_SUPPLIER",
"I_USER",
"R_PPS_PURCHASECONTRACTITEMTP",
"R_PPS_PURCONTRACTCONTACTTP",
"R_PPS_PURCONTRACTHDREXTENSION",
"R_PPS_PURCONTRACTHEADERNOTETP",
"R_PPS_PURCONTRACTPARTNERTP",
"R_PPS_PURCONTRHDRCNDNVALDTYTP"
],
"BASE":
[
"I_PURCHASECONTRACT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/