I_CntrlPurContrDistribution

@AbapCatalog.sqlViewName: 'ICNTRLPCONDSTR'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Central PC Distribution Basic View'
@VDM.viewType : #BASIC

@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL

@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #REQUIRED

define view I_CntrlPurContrDistribution
  as select from R_CntrlPurContrDistribution

  association [1..1] to I_CentralPurchaseContract      as _CentralPurchaseContract      on  _CentralPurchaseContract.CentralPurchaseContract = $projection.CentralPurchaseContract

  association [1..1] to I_CntrlPurchaseContractItem    as _CntrlPurchaseContractItem    on  $projection.CentralPurchaseContract     = _CntrlPurchaseContractItem.CentralPurchaseContract
                                                                                        and $projection.CentralPurchaseContractItem = _CntrlPurchaseContractItem.CentralPurchaseContractItem

  association [0..*] to I_CntrlPurchaseContractPartner as _CntrlPurchaseContractPartner on  $projection.CentralPurchaseContract     = _CntrlPurchaseContractPartner.CentralPurchaseContract
                                                                                        and $projection.CentralPurchaseContractItem = _CntrlPurchaseContractPartner.CentralPurchaseContractItem
                                                                                        and $projection.DistributionKey             = _CntrlPurchaseContractPartner.DistributionKey

  association [0..1] to I_CentralPurContrDistrAddress  as _CentralPurContrDistrAddress  on  _CentralPurContrDistrAddress.CentralPurchaseContract     = $projection.CentralPurchaseContract
                                                                                        and _CentralPurContrDistrAddress.CentralPurchaseContractItem = $projection.CentralPurchaseContractItem
                                                                                        and _CentralPurContrDistrAddress.DistributionKey             = $projection.DistributionKey


{
  key CentralPurchaseContract,
  key CentralPurchaseContractItem,
  key DistributionKey,
      PurchasingDocumentCategory,
      PurchasingDocumentType,
      PurchasingOrganization,
      CompanyCode,
      Plant,
      LogicalSystem,
      DocumentCurrency,
      Currency,
      PurchasingGroup,
      StorageLocation,
      PaymentTerms,
      CashDiscount1Days,
      CashDiscount2Days,
      NetPaymentDays,
      CashDiscount1Percent,
      CashDiscount2Percent,
      Material,
      MaterialGroup,
      CntrlPurContrDistributionPct,
      TargetQuantity,
      @Semantics.amount.currencyCode: 'DocumentCurrency'
      TargetAmount,

      ExtContractForPurg,
      ExtContractItemForPurg,
      ExtContractItemDistrForPurg,

      @VDM.lifecycle.status: #DEPRECATED
      @VDM.lifecycle.successor: 'PurgDocItemDistributionStatus'
      PurgDocItemDistributionStatus                                    as ItemDistributionStatus,
       PurgDocItemDistributionStatus,
       
      //casting to bool, because of VDM checkmen.This is a known issue. Consumers should cast back to xfeld.

      cast(IsDeleted as bool)                                          as IsDeleted,
      OrderQuantityUnit,
      DistributionType,
      DistrResponseMessageUUID,
      
      //casting to bool, because of VDM checkmen.This is a known issue. Consumers should cast back to xfeld.

      cast(ItemDistributionIsRelevant as bool)                         as ItemDistributionIsRelevant, 
      ReferenceHeaderDistributionKey,
      
      //casting to bool, because of VDM checkmen.This is a known issue. Consumers should cast back to xfeld.

      cast(CntrlPurContrItmDistrIsBlocked  as mmpur_itemdistr_blocked) as CntrlPurContrItmDistrIsBlocked,
      CntrlPurContrDistributionLevel,
      ManualDeliveryAddressID,
      ProcmtHubDelivAddressTypeCode                                    as AddressType,
      ProcmtHubDelivAddressTypeCode,
      ProcurementHubSourceSystem,
      ExternalReferenceDocument,
      ExternalReferenceDocumentItem,
      ExternalRefDocCategory,
      PurchasingInfoRecordUpdateCode,
      ProcmtHubPredecessorDocument,
      ProcmtHubPredecessorDocItem,
      ProcmtHubPredecessorDocCat,
      ProcmtHubPurchaseRequisition,
      ProcmtHubPurRequisitionItem,
      SourceListIsUpdated,
      SourceListRestriction,
      SrceListResponseMsgUUID,
      SourceListChangeConfStatus,
      ProcmtHubCompanyCodeGroupingID,
      OutlineAgrmtItmIsBlocked,
      PurgDocItmBlkRsnCode,
      IncotermsClassification,
      IncotermsLocation1,
      ShippingInstruction,
      CntrlPurContrDistrTrggrDteTime,
      ProcmtHubSubcontractor,      
      ProcmtHubSuplrIsSubcontractor,
      ReferenceDeliveryAddressID,
      FormOfAddress,
      ProcmtHubBusinessPartnerName1,
      ProcmtHubBusinessPartnerName2,
      ProcmtHubBusinessPartnerName3,
      ProcmtHubBusinessPartnerName4,
      ProcmtHubStreetName,
      ProcmtHubHouseNumber,
      ProcmtHubPostalCode,
      ProcmtHubCityName,
      ProcmtHubCountry,
      ProcmtHubRegion,
      
      /* The fields with predecessor document information */
      ProcmtHubPrdcssrDocUUID, 
      ProcmtHubPrdcssrDocItemUUID,
      ProcmtHubPrdcssrDocObjType,
      ProcmtHubPrdcssrDocObjNodeType,     

      /* Associations */
      @ObjectModel.association.type:  [ #TO_COMPOSITION_ROOT ]
      _CentralPurchaseContract,
      @ObjectModel.association.type:  [ #TO_COMPOSITION_PARENT ]
      _CntrlPurchaseContractItem,

      @ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
      _CntrlPurchaseContractPartner,

      @ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
      _CentralPurContrDistrAddress

}