P_CntrlPurContrDistribution

@AbapCatalog.sqlViewName: 'PCNTRLPCONDSTR'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED 
@VDM.viewType: #BASIC
@VDM.private: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L

define view P_CntrlPurContrDistribution as select from ekpo_distr {
    
 
  key purchasingdocument                                as CentralPurchaseContract,
  key purchasingdocumentitem                            as CentralPurchaseContractItem,
  key ekpo_distr.distributionnumber                     as DistributionKey,
      ekpo_distr.purchasingdocumentcategory             as PurchasingDocumentCategory,
      ekpo_distr.purchasingdocumenttype                 as PurchasingDocumentType,
      ekpo_distr.purchasingorganization                 as PurchasingOrganization,
      ekpo_distr.companycode                            as CompanyCode,
      ekpo_distr.plant                                  as Plant,
      ekpo_distr.logicalsystem                          as LogicalSystem,
      ekpo_distr.documentcurrency                       as DocumentCurrency,
      ekpo_distr.documentcurrency                       as Currency,
      ekpo_distr.purchasinggroup                        as PurchasingGroup,
      ekpo_distr.storagelocation                        as StorageLocation,
      ekpo_distr.paymentterms                           as PaymentTerms,
      ekpo_distr.cashdiscount1days                      as CashDiscount1Days,
      ekpo_distr.cashdiscount2days                      as CashDiscount2Days,
      ekpo_distr.netpaymentdays                         as NetPaymentDays,
      ekpo_distr.cashdiscount1percent                   as CashDiscount1Percent,
      ekpo_distr.cashdiscount2percent                   as CashDiscount2Percent,
      ekpo_distr.material                               as Material,
      ekpo_distr.materialgroup                          as MaterialGroup,
      ekpo_distr.purchasingdocumentdistrpct             as CntrlPurContrDistributionPct,
      ekpo_distr.targetquantity                         as TargetQuantity,
      ekpo_distr.targetvalue                            as TargetAmount,

      ekpo_distr.extcontractforpurg                     as ExtContractForPurg,
      ekpo_distr.extcontractitemforpurg                 as ExtContractItemForPurg,
      case
      when ekpo_distr.extcontractitemdistrstatus = '01' and ekpo_distr.extcontractforpurg <> ''
        then '04'
        else
          ekpo_distr.extcontractitemdistrstatus end     as ItemDistributionStatus,
      //ekpo_distr.extcontractitemdistrstatus                   as                             ItemDistributionStatus,

      ekpo_distr.isdeleted                              as IsDeleted,
      ekpo_distr.orderquantityunit                      as OrderQuantityUnit,
      ekpo_distr.distributiontype                       as DistributionType,
      ekpo_distr.responsemessageguid                    as DistrResponseMessageUUID,
      ekpo_distr.itemdistributionisrelevant             as ItemDistributionIsRelevant,
      ekpo_distr.referencedhdrdistrnumber               as ReferenceHeaderDistributionKey,
      ekpo_distr.isitemdistributionblocked              as CntrlPurContrItmDistrIsBlocked,
      ekpo_distr.distributionlevel                      as CntrlPurContrDistributionLevel,
 
      ekpo_distr.manualdeliveryaddressid                as ManualDeliveryAddressID,
      ekpo_distr.deliveryaddresstype                    as AddressType,
      case
      when ekpo_distr.procurementhubsourcesystem is not initial
      then ekpo_distr.procurementhubsourcesystem
      else
      ekpo_distr.logicalsystem
       end                                              as ProcurementHubSourceSystem,
      ekpo_distr.externalreferencedocument              as ExternalReferenceDocument,
      ekpo_distr.externalreferencedocumentitem          as ExternalReferenceDocumentItem,
      ekpo_distr.externalrefdoccategory                 as ExternalRefDocCategory,
      ekpo_distr.purchasinginforecordupdatecode         as PurchasingInfoRecordUpdateCode,
      ekpo_distr.procmthubpredecessordocument           as ProcmtHubPredecessorDocument,
      ekpo_distr.procmthubpredecessordocitem            as ProcmtHubPredecessorDocItem,
      ekpo_distr.procmthubpredecessordoccat             as ProcmtHubPredecessorDocCat,
      ekpo_distr.procmthubpurchaserequisition           as ProcmtHubPurchaseRequisition,
      ekpo_distr.procmthubpurrequisitionitem            as ProcmtHubPurRequisitionItem,
      
      /*sourcelist related */
      ekpo_distr.sourcelistisupdated                    as SourceListIsUpdated,
      ekpo_distr.sourcelistrestriction                  as SourceListRestriction,
      ekpo_distr.srcelistresponsemsguuid                as SrceListResponseMsgUUID,   
      ekpo_distr.sourcelistchangeconfstatus             as SourceListChangeConfStatus,   
      ekpo_distr.procmthubcompanycodegroupingid         as ProcmtHubCompanyCodeGroupingID
       

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