R_PPS_PurchaseOrderTP

//@JIRA-KEY<S4PPS-5457>

@AccessControl: {
  authorizationCheck: #MANDATORY,
  personalData.blocking: #BLOCKED_DATA_EXCLUDED,
  privilegedAssociations: ['_SupplierAddress','_PurchaseOrderPartner', '_PurchaseOrderHeaderExtension', '_User', '_PurchaseOrderNote' ] }
@EndUserText.label: 'Purchase Order Transactional View'
@ObjectModel: {
  usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #MASTER},
  sapObjectNodeType.name: 'PurchaseOrder',
  semanticKey: ['PurchaseOrder' ],
  representativeKey: 'PurchaseOrder' }
@VDM: {
  lifecycle.contract.type: #SAP_INTERNAL_API,
  viewType: #TRANSACTIONAL }
@Metadata.ignorePropagatedAnnotations: true



define root view entity R_PPS_PurchaseOrderTP
  //as select from R_PurchaseOrder as PurchaseOrder //R_PurchaseOrder R_PPS_PurchaseOrder

  as select from R_PPS_PurchaseOrder as PurchaseOrder //R_PurchaseOrder R_PPS_PurchaseOrder


  composition [1..*] of R_PPS_PurchaseOrderItemTP      as _PurchaseOrderItem
  //  composition [1..*] of R_PPS_PurOrderItemHierarchyTP  as _PurchaseOrderItemHier



  composition [1..1] of R_PPS_PurOrdSupplierAddressTP  as _SupplierAddress
  association [0..1] to R_PurOrdHasItemHierarchy       as _PurOrdHasItemHierarchy       on  $projection.PurchaseOrder = _PurOrdHasItemHierarchy.PurchaseOrder

  composition [1..*] of R_PPS_PurchaseOrderNoteTP      as _PurchaseOrderNote
  composition [1..*] of R_PPS_PurchaseOrderPartnerTP   as _PurchaseOrderPartner
  composition [1..*] of R_PPS_PurchaseOrderContactTP   as _PurchaseOrderContact
  //  composition [1..*] of R_PPS_PurchaseOrderPubPSTP     as _PurchaseOrderPubPS  //@JIRA-KEY<S4PPS-11741>


  association [1..1] to I_PurchaseOrderNetAmount       as _PurchaseOrderNetAmount       on  _PurchaseOrderNetAmount.PurchaseOrder = $projection.PurchaseOrder
  association [0..1] to I_PurchasingDocumentTypeText   as _PurchaseOrderTypeText        on  _PurchaseOrderTypeText.PurchasingDocumentType     = $projection.PurchaseOrderType
                                                                                        and _PurchaseOrderTypeText.PurchasingDocumentCategory = 'F'
                                                                                        and _PurchaseOrderTypeText.Language                   = $session.system_language

  association [0..1] to I_User                         as _User                         on  _User.UserID = $projection.CreatedByUser
  association [1..1] to I_PurchasingDocumentType       as _PurchaseOrderType            on  $projection.PurchaseOrderType                 = _PurchaseOrderType.PurchasingDocumentType
                                                                                        and _PurchaseOrderType.PurchasingDocumentCategory = 'F'
  //  association [0..1] to I_PurchaseOrderStatus          as _PurchaseOrderStatus          on  $projection.PurchaseOrder = _PurchaseOrderStatus.PurchaseOrder

  association [0..1] to I_PPS_PurchaseOrderStatus      as _PurchaseOrderStatus          on  $projection.PurchaseOrder = _PurchaseOrderStatus.PurchaseOrder
  //  association [0..1] to I_PPS_PurgDocHdrStatusVH       as _PurchaseOrderStatus          on  $projection.ppspurorderheaderstatus = _PurchaseOrderStatus.


  association [1..1] to I_PPS_PurgDocHdrStatusText     as _PurOrderStatusText           on  $projection.ppspurorderheaderstatus = _PurOrderStatusText.PurchasingDocumentStatus //@JIRA_KEY: <S4PPS-9359>

                                                                                        and _PurOrderStatusText.Language        = $session.system_language

  //@JIRA-KEY<S4PPS-9402>

  association [1..*] to I_PPS_PurOrdChgVersDrft        as _ChgDocDraft                  on  $projection.ActivePurchasingDocument = _ChgDocDraft.ActivePurchasingDocument
  //  association [1..*] to C_PPS_PurContrChgDocDraft      as _Draft                        on  $projection.ActivePurchasingDocument = _Draft.ActiveId

  --Extension Association
  association [1..1] to E_PurchasingDocument           as _PurchaseOrderExtension       on  $projection.PurchaseOrder = _PurchaseOrderExtension.PurchasingDocument
  --VH Association
  //  association [0..1] to R_PPS_DocumentConfidentialVH  as _DocConfidentialValueHelp on  $projection.PurchaseOrderIsConfidential = _DocConfidentialValueHelp.PPSDocumentConfidentialValue


  association [1..1] to R_PPS_PurOrderHeaderExtension  as _PurchaseOrderHeaderExtension on  $projection.PurchaseOrder = _PurchaseOrderHeaderExtension.PurchaseOrder
  association [1..1] to I_PPS_PurgDocClassificationTxt as _Classification               on  $projection.PPSPurgDocClassfctnCode = _Classification.PPSPurgDocClassfctnCode
                                                                                        and _Classification.Language            = $session.system_language
  association [0..1] to I_PPS_PurgDocVersionReasonVH   as _VersionReasonValHelp         on  $projection.purchasingdocversionreasoncode = _VersionReasonValHelp.PurchasingDocVersionReasonCode
  // @JIRA-KEY <S4PPS-7397>

  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
  // @JIRA-KEY <S4PPS-7397>

  // @JIRA-KEY <S4PPS-8723>

  association [1..1] to I_PPS_PurOrdDocType            as _PurchaseOrderDocType         on  _PurchaseOrderDocType.PurchaseOrderType          = $projection.PurchaseOrderType
                                                                                        and _PurchaseOrderDocType.PurchasingDocumentCategory = 'F'

   // @JIRA-KEY <S4PPS-15829>

   association [0..1] to I_PPS_FedSystApprvlStatusVH       as _FedSystApprvlStatus      on  $projection.ppsmodificationtype = _FedSystApprvlStatus.PPSFedSystStatus
   association [1..1] to I_PPS_FedSystApprvlStatusText  as _FedSystApprvlStatusText     on  $projection.ppsfedsyststatus    = _FedSystApprvlStatusText.PPSFedSystStatus
                                                                                        and _FedSystApprvlStatusText.Language = $session.system_language
  // testing for side effects

  // association [0..*] to R_PPS_PurOrdVersionHistory     as _PurOrdVersionHistory1         on  $projection.ActivePurchasingDocument = _PurOrdVersionHistory1.ActivePurchasingDocument


{

  key PurchaseOrder.PurchaseOrder,

      cast ( hextobin( '00000000000000000000000000000000' ) as sysuuid_x16 )                   as PurchaseOrderUUID,

      //      _PurchaseOrderItemHier,


      PurchaseOrder.PurchaseOrderType,
      _PurchaseOrderTypeText.PurchasingDocumentTypeName                                        as PurchaseOrderTypeName,
      PurchaseOrder.PurchaseOrderSubtype,
      PurchaseOrder.PurchasingDocumentOrigin,

      PurchaseOrder.CreatedByUser,
      @Semantics.text: true
      _User.UserDescription                                                                    as CreatedByUserFullName,
      PurchaseOrder.CreationDate,
      PurchaseOrder.PurchaseOrderDate,
      PurchaseOrder.LastChangeDateTime,

      @Semantics.amount.currencyCode: 'DocumentCurrency'
      cast(_PurchaseOrderNetAmount.PurchaseOrderNetAmount as mm_pur_order_tot_net_amount)      as PurchaseOrderNetAmount,

      PurchaseOrder.ValidityStartDate,
      PurchaseOrder.ValidityEndDate,
      PurchaseOrder.Language,

      PurchaseOrder.PurchaseOrderDeletionCode,
      cast ( case PurchaseOrderDeletionCode
             when 'L' then 'X'
            else ' '
             end  as boolean )                                                                 as IsDeleted,

      PurchaseOrder.ReleaseIsNotCompleted,
      PurchaseOrder.PurchasingCompletenessStatus,
      PurchaseOrder.PurchasingProcessingStatus,
      PurchaseOrder.PurgReleaseSequenceStatus,
      PurchaseOrder.ReleaseCode,
      PurchaseOrder.PurchasingReleaseStrategy,
      PurchaseOrder.PurgReasonForDocCancellation,
      PurchaseOrder.ActivePurchasingDocument, //AMRAJBS

      PurchaseOrder.PurgDocChangeRequestStatus,
      PurchaseOrder.PurchasingDocumentVersion,
      //@JIRA-KEY<S4PPS-9402>

      case PurgDocChangeRequestStatus
       when '2' then cast( 'X' as xfeld preserving type )
       else cast( '' as xfeld preserving type ) end                                            as PurgDocIsChgVers,
      //@JIRA-KEY<S4PPS-9402>

      case _ChgDocDraft.PPSPurgDocHasChgVersDrft
         when '1' then (cast('X' as boolean preserving type )) //Hide Target Value

         else (cast('' as boolean preserving type ))
      end                                                                                      as PPSPurgDocHasChgVersDrft,

      PurchaseOrder.CompanyCode,
      PurchaseOrder.PurchasingOrganization,
      PurchaseOrder.PurchasingGroup,

      PurchaseOrder.Supplier,
      PurchaseOrder.ManualSupplierAddressID,
      PurchaseOrder.SupplierAddressID,
      PurchaseOrder.SupplierRespSalesPersonName,
      PurchaseOrder.SupplierPhoneNumber,
      PurchaseOrder.SupplyingSupplier,
      PurchaseOrder.SupplyingPlant,
      PurchaseOrder.InvoicingParty,
      PurchaseOrder.Customer,

      PurchaseOrder.PurchaseContract,
      PurchaseOrder.SupplierQuotationExternalID,
      PurchaseOrder.QuotationSubmissionDate,
      PurchaseOrder.ItemNumberIntervalForSubItems,

      PurchaseOrder.PaymentTerms,
      _PaymentTerms._Text[ 1: Language = $session.system_language ].PaymentTermsName, // adding for description

      PurchaseOrder.CashDiscount1Days,
      PurchaseOrder.CashDiscount2Days,
      PurchaseOrder.NetPaymentDays,
      PurchaseOrder.CashDiscount1Percent,
      PurchaseOrder.CashDiscount2Percent,
      PurchaseOrder.DownPaymentType,
      PurchaseOrder.DownPaymentPercentageOfTotAmt,

      @Semantics.amount.currencyCode: 'DocumentCurrency'
      PurchaseOrder.DownPaymentAmount,
      PurchaseOrder.DownPaymentDueDate,

      PurchaseOrder.IncotermsClassification,
      PurchaseOrder.IncotermsTransferLocation,
      PurchaseOrder.IncotermsVersion,
      PurchaseOrder.IncotermsLocation1,
      PurchaseOrder.IncotermsLocation2,


      PurchaseOrder.IsIntrastatReportingRelevant,
      PurchaseOrder.IsIntrastatReportingExcluded,
      PurchaseOrder.CorrespncExternalReference,
      PurchaseOrder.CorrespncInternalReference,

      PurchaseOrder.PricingDocument,
      PurchaseOrder.PricingProcedure,
      PurchaseOrder.DocumentCurrency,
      cast( PurchaseOrder.ExchangeRate as fis_exchange_rate preserving type )                  as ExchangeRate,
      PurchaseOrder.ExchangeRateIsFixed,
      @Semantics.amount.currencyCode: 'DocumentCurrency'
      PurchaseOrder.PurgReleaseTimeTotalAmount,
      PurchaseOrder.TaxReturnCountry,
      PurchaseOrder.VATRegistrationCountry,

      PurchaseOrder.PurgAggrgdProdCmplncSuplrSts,
      PurchaseOrder.PurgAggrgdProdMarketabilitySts,
      PurchaseOrder.PurgAggrgdSftyDataSheetStatus,
      PurchaseOrder.PurgProdCmplncTotDngrsGoodsSts,

      // fields added


      cast( '' as tminco_loc_1_id )                                                            as IncotermsLocation1Identifier,
      cast( '' as tminco_loc_2_id )                                                            as IncotermsLocation2Identifier,
      cast( '' as tminco_loc_d_id )                                                            as IncotermsDvtgLocIdentifier,
      cast( '' as tminco_loc_d_descr )                                                         as IncotermsDvtgLocDescription,

      PurchaseOrder.IncotermsSupChnLoc1AddlUUID,
      PurchaseOrder.IncotermsSupChnLoc2AddlUUID,
      PurchaseOrder.IncotermsSupChnDvtgLocAddlUUID,

      @ObjectModel.editableFieldFor: 'ExchangeRateForEdit'
      cast(PurchaseOrder.ExchangeRate as abap.char( 12 ))                                      as ExchangeRateForEdit,

      PurchaseOrder.RequestForQuotation,
      //@UI.hidden: true // it was there in I view, not sure if needed here

      @Semantics.booleanIndicator: true
      IsEndOfPurposeBlocked,

      cast ('' as boolean)                                                                     as PPSPurOrdIsInPrep, //PurchaseOrderIsInPreparation,

      cast ( '' as podraftisreverted )                                                         as PODraftIsReverted,

      //      cast ( '' as podraftisreverted )                                        as PODraftIsReverted,

      cast ( '' as purchaseorderhascommitmentitem )                                            as PurchaseOrderHasCommitmentItem,
      cast ( '' as mm_rework_comment )                                                         as POReworkCommentText,
      cast ( '' as purchaseorderapprovalstatus )                                               as ApprovalStatus,
      cast ( '' as mm_approval_status )                                                        as ApprovalStatusName,
      //      cast ( '00000000' as abap.dats )                                                    as POApprovalDate,


      _PurOrdHasItemHierarchy.PurchasingHasItemHierarchy,
      // @JIRA-KEY<S4PPS-15387>

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

      cast ( hextobin( PPSFieldChangeIndicatorString ) as pps_e_control_flag preserving type ) as PPSFieldChangeIndicatorBinary,

      PPSFieldChangeIndicatorString,


      /* Compositions */
      _PurchaseOrderItem,
      //      _PurchaseOrderItemHier,

      _SupplierAddress,
      @ObjectModel.filter.enabled: false
      @ObjectModel.sort.enabled: false
      _PurchaseOrderNote,
      _PurchaseOrderPartner,
      _PurchaseOrderContact,
      //      _PurchaseOrderPubPS,  //@JIRA-KEY<S4PPS-11741>

      //      _PurchaseOrderExtension.smart_number_hdr                                            as SmartNumberHeader,

      //      _PurchaseOrderExtension.milestone_plan_id                                           as MilestonePlanID,


      /* Field for PO description */
      _PurchaseOrderHeaderExtension.PPSPurchaseOrderDescription                                as PPSPurchaseOrderDescription,

      /* Confidential field on header */
      _PurchaseOrderHeaderExtension.PPSPurgDocClassfctnCode                                    as PPSPurgDocClassfctnCode,

      /* Associations */
      PurchaseOrder._CompanyCode,
      PurchaseOrder._CreatedByUser,
      PurchaseOrder._DocumentCurrency,
      PurchaseOrder._IncotermsClassification,
      PurchaseOrder._IncotermsVersion,
      PurchaseOrder._InvoicingParty,
      PurchaseOrder._Language,
      PurchaseOrder._PaymentTerms,
      PurchaseOrder._PurchaseOrderCalcFields,
      PurchaseOrder._PurchaseOrderDeletionCode,
      _PurchaseOrderType,
      PurchaseOrder._PurchasingGroup,
      PurchaseOrder._PurchasingOrganization,
      PurchaseOrder._Supplier,
      PurchaseOrder._SupplyingPlant,
      PurchaseOrder._SupplyingSupplier,
      _PurchaseOrderStatus,
      _PurchaseOrderTypeText,


      //      _DocConfidentialValueHelp,

      _User,

      // PPS Specific Fields

      _PurchaseOrderHeaderExtension.PPSFuturePostingDate,
      _PurchaseOrderHeaderExtension.PPSPerdOfPerfStartDate,
      _PurchaseOrderHeaderExtension.PPSPerdOfPerfEndDate,
      _PurchaseOrderHeaderExtension.PPSSmartNumberHeader,
      _PurchaseOrderHeaderExtension.PPSSmartNumberHeaderIsManual, //@JIRA-KEY<S4PPS-10861>

      //      _PurchaseOrderHeaderExtension.ActivePurchasingDocument, //AMRAJBS

      _PurchaseOrderHeaderExtension.PurchasingDocVersionReasonCode, //amrajbs

      _PurchaseOrderHeaderExtension.PPSRevisionComment,
      _PurchaseOrderHeaderExtension.PPSSmartDocumentNumber, //@JIRA-KEY <S4PPS-9998>

      // @JIRA-KEY <S4PPS-7397>

      _PurchaseOrderHeaderExtension.PPSNumberOfModification,
      //       lpad( _PurchaseOrderHeaderExtension.ModificationNumber, 5, '0' ) as ModificationNumber,

      _PurchaseOrderHeaderExtension.PPSModificationType,
      _PurchaseOrderHeaderExtension.PPSModificationTypeText,
      _PurchaseOrderHeaderExtension.PPSModificationIdentifierCode, //@JIRA_KEY<S4PPS-15688

      // @JIRA-KEY <S4PPS-9359>

      _PurchaseOrderHeaderExtension.PPSPurOrderHeaderStatus,

      case  _PurchaseOrderHeaderExtension.PPSPurOrderHeaderStatus //@JIRA_KEY: <S4PPS-9359>

      when '01' then 0 // In Preparation - Grey

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

      when '02' then 3 // Active - Green

      when '04' then 1 // Rejected - Red

      when '03' then 1 // Deleted - Red

      when '06' then 3 // Follow On Document - Green

      when '07' then 0 // Completed - Grey // TODO: To be checked

      else  0 // Default - Grey

      end                                                                                      as PPSPurOrdHdrStatusCriticality,

      // @JIRA-KEY <S4PPS-7397>

      //       do not expose the assoication

      //BOC @JIRA-KEY <S4PPS-11741> <C5256742>

      _PurchaseOrderHeaderExtension.PPSFedSystApprvlDate,
      _PurchaseOrderHeaderExtension.PPSFedSystStatus,
      _PurchaseOrderHeaderExtension.PPSFedSystLogHandle,
      //EOC @JIRA-KEY <S4PPS-11741> <C5256742>


      _PurchaseOrderHeaderExtension,
      _Classification,
      _VersionReasonValHelp,
      // @JIRA-KEY <S4PPS-7397>

      _ModificationType,
      _ModificationTypeText,
      // @JIRA-KEY <S4PPS-7397>

      _PurOrderStatusText, // @JIRA-KEY <S4PPS-9359>

      _FedSystApprvlStatus,
      _FedSystApprvlStatusText // @JIRA-KEY <S4PPS-15829>

      // _PurOrdVersionHistory1 // testing side effects

}
//@JIRA-KEY<S4PPS-9402>

where
  (
       PurgDocChangeRequestStatus      = ''
    or PurgDocChangeRequestStatus      = '2'

  )
  and  PurchaseOrder.PurchaseOrderType = _PurchaseOrderDocType.PurchaseOrderType
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PAYMENTTERMS",
"I_PAYMENTTERMSTEXT",
"I_PPS_PURORDCHGVERSDRFT",
"I_PPS_PURORDDOCTYPE",
"I_PURCHASEORDERNETAMOUNT",
"I_PURCHASINGDOCUMENTTYPETEXT",
"I_USER",
"R_PPS_PURCHASEORDER",
"R_PPS_PURORDERHEADEREXTENSION",
"R_PURORDHASITEMHIERARCHY"
],
"ASSOCIATED":
[
"I_COMPANYCODE",
"I_CURRENCY",
"I_INCOTERMSCLASSIFICATION",
"I_INCOTERMSVERSION",
"I_LANGUAGE",
"I_PAYMENTTERMS",
"I_PLANT",
"I_PPS_FEDSYSTAPPRVLSTATUSTEXT",
"I_PPS_FEDSYSTAPPRVLSTATUSVH",
"I_PPS_PURCHASEORDERSTATUS",
"I_PPS_PURGDOCCLASSIFICATIONTXT",
"I_PPS_PURGDOCHDRSTATUSTEXT",
"I_PPS_PURGDOCMODIFTYPETEXT",
"I_PPS_PURGDOCMODIFTYPEVH",
"I_PPS_PURGDOCVERSIONREASONVH",
"I_PURCHASEORDERCALCFIELDS",
"I_PURCHASEORDERDELETIONCODE",
"I_PURCHASINGDOCUMENTTYPE",
"I_PURCHASINGDOCUMENTTYPETEXT",
"I_PURCHASINGGROUP",
"I_PURCHASINGORGANIZATION",
"I_SUPPLIER",
"I_USER",
"R_PPS_PURCHASEORDERCONTACTTP",
"R_PPS_PURCHASEORDERITEMTP",
"R_PPS_PURCHASEORDERNOTETP",
"R_PPS_PURCHASEORDERPARTNERTP",
"R_PPS_PURORDERHEADEREXTENSION",
"R_PPS_PURORDSUPPLIERADDRESSTP"
],
"BASE":
[
"R_PPS_PURCHASEORDER"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/