I_PurgInfoRecordWithOrgData

@AbapCatalog.sqlViewName: 'IINFRECWITHORG'
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Info Record with Org Plant Data'
@VDM.viewType: #BASIC
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API

define view I_PurgInfoRecordWithOrgData
  as select from    I_PurchasingInfoRecord     as eina

    left outer join I_PurgInfoRecdOrgPlantData as _PurgInfoRecdOrgPlantData on eina.PurchasingInfoRecord = _PurgInfoRecdOrgPlantData.PurchasingInfoRecord

  association [0..*] to I_PurInfCndPeriod as _PurInfCndPeriod on  $projection.PurchasingInfoRecord         = _PurInfCndPeriod.PurchasingInfoRecord
                                                              and $projection.Plant                        = _PurInfCndPeriod.Plant
                                                              and $projection.PurchasingOrganization       = _PurInfCndPeriod.PurchasingOrganization
                                                              and $projection.PurchasingInfoRecordCategory = _PurInfCndPeriod.PurchasingInfoRecordCategory
  
  association [0..1] to E_PurchasingInforecord     as _PurchasingInforecordExtension on  _PurchasingInforecordExtension.PurchasingInfoRecord = $projection.PurchasingInfoRecord            
              
{
  key eina.PurchasingInfoRecord                              as PurchasingInfoRecord,

  key _PurgInfoRecdOrgPlantData.PurchasingOrganization       as PurchasingOrganization,

  key _PurgInfoRecdOrgPlantData.PurchasingInfoRecordCategory as PurchasingInfoRecordCategory,

  key _PurgInfoRecdOrgPlantData.Plant,

      Supplier,

      Material,

      MaterialGroup,

//      @Semantics.businessDate.createdAt

      _PurgInfoRecdOrgPlantData.CreationDate,

      IsDeleted,

      PurchasingInfoRecordDesc,

      @Semantics.unitOfMeasure: true
      PurgDocOrderQuantityUnit,

      OrderItemQtyToBaseQtyNmrtr,

      OrderItemQtyToBaseQtyDnmntr,

      SupplierMaterialNumber,

      SupplierRespSalesPersonName,

      SupplierPhoneNumber,

      @Semantics.unitOfMeasure: true
      BaseUnit,

      SupplierMaterialGroup,

      PriorSupplier,

      @Semantics.businessDate.from
      AvailabilityStartDate,

//      @Semantics.businessDate.to

      AvailabilityEndDate,

      VarblPurOrdUnitIsActive,

      Manufacturer,

      IsRegularSupplier,

      SupplierSubrange,

      NoDaysReminder1,

      NoDaysReminder2,

      NoDaysReminder3,

      ProductPurchasePointsQty,

      ProductPurchasePointsQtyUnit,

      ReturnAgreement,

      SupplierCertOriginCat,

      SupplierCertOriginNumber,

      SupplierCertValidityEndDate,

      SupplierCertOriginCountry,

      SupplierCertOriginRegion,

      SuplrCertOriginClassfctnNumber,

      SupplierSubrangeSortNumber,

      LastChangeDateTime,
      
      //Sort Term

      PurgInfoRecNonStockItmSortTerm,

      _PurgInfoRecdOrgPlantData.SupplierQuotation,

      _PurgInfoRecdOrgPlantData.SupplierQuotationDate,

      _PurgInfoRecdOrgPlantData.MinRemainingShelfLife,

      _PurgInfoRecdOrgPlantData.ShippingInstruction,

      _PurgInfoRecdOrgPlantData.IsEvaluatedRcptSettlmtAllowed,

      _PurgInfoRecdOrgPlantData.IsPurOrderAllwdForInbDeliv,

      _PurgInfoRecdOrgPlantData.IsOrderAcknRqd,

      _PurgInfoRecdOrgPlantData.SupplierConfirmationControlKey,

      _PurgInfoRecdOrgPlantData.MaterialRoundingProfile,

      _PurgInfoRecdOrgPlantData.MaterialStagingTime,

      _PurgInfoRecdOrgPlantData.ProductUnitGroup,

      _PurgInfoRecdOrgPlantData.IsRetMatlAuthznRqdBySupplier,

      _PurgInfoRecdOrgPlantData.IsCashDiscountGranted,

      _PurgInfoRecdOrgPlantData.MaterialConditionGroup,

      _PurgInfoRecdOrgPlantData.PricingDateControl,

      _PurgInfoRecdOrgPlantData.IncotermsLocation2,

      _PurgInfoRecdOrgPlantData.IncotermsVersion,

      _PurgInfoRecdOrgPlantData.PurchasingDocumentDate,

      _PurgInfoRecdOrgPlantData.CreatedByUser,

      _PurgInfoRecdOrgPlantData.IsMarkedForDeletion,

      _PurgInfoRecdOrgPlantData.PurchasingGroup,

      _PurgInfoRecdOrgPlantData.ShelfLifeExpirationDatePeriod,

      @Semantics.currencyCode:true
      _PurgInfoRecdOrgPlantData.Currency,

      @Semantics.quantity.unitOfMeasure: 'PurchaseOrderPriceUnit'
//      @DefaultAggregation: #NONE

      _PurgInfoRecdOrgPlantData.MinimumPurchaseOrderQuantity,

      @Semantics.quantity.unitOfMeasure: 'PurchaseOrderPriceUnit'
//      @DefaultAggregation: #NONE

      _PurgInfoRecdOrgPlantData.StandardPurchaseOrderQuantity,

      _PurgInfoRecdOrgPlantData.MaterialPlannedDeliveryDurn,

      _PurgInfoRecdOrgPlantData.OverdelivTolrtdLmtRatioInPct,

      _PurgInfoRecdOrgPlantData.UnderdelivTolrtdLmtRatioInPct,

      _PurgInfoRecdOrgPlantData.UnlimitedOverdeliveryIsAllowed,

      _PurgInfoRecdOrgPlantData.LastReferencingPurchaseOrder,

      _PurgInfoRecdOrgPlantData.LastReferencingPurOrderItem,

      @Semantics.amount.currencyCode: 'Currency'
//      @DefaultAggregation: #NONE

      _PurgInfoRecdOrgPlantData.NetPriceAmount,

      @Semantics.quantity.unitOfMeasure: 'PurchaseOrderPriceUnit'
//      @DefaultAggregation: #NONE

      _PurgInfoRecdOrgPlantData.MaterialPriceUnitQty,

      @Semantics.unitOfMeasure: true
      _PurgInfoRecdOrgPlantData.PurchaseOrderPriceUnit,

      //      @Semantics.businessDate.to

      _PurgInfoRecdOrgPlantData.PriceValidityEndDate,

      _PurgInfoRecdOrgPlantData.OrderPriceUnitToOrderUnitNmrtr,

      _PurgInfoRecdOrgPlantData.OrdPriceUnitToOrderUnitDnmntr,

      _PurgInfoRecdOrgPlantData.InvoiceIsGoodsReceiptBased,

      _PurgInfoRecdOrgPlantData.TaxCode,
      
      _PurgInfoRecdOrgPlantData.TimeDependentTaxValidFromDate,
      
      _PurgInfoRecdOrgPlantData.TaxCountry,

      _PurgInfoRecdOrgPlantData.IncotermsClassification,

      _PurgInfoRecdOrgPlantData.IncotermsTransferLocation,

      _PurgInfoRecdOrgPlantData.IncotermsLocation1,
      
  //    _PurgInfoRecdOrgPlantData.PurgInfoRecordIncotermsLocID1,

      _PurgInfoRecdOrgPlantData.IncotermsSupChnLoc1AddlUUID,
      _PurgInfoRecdOrgPlantData.IncotermsSupChnLoc2AddlUUID,
      _PurgInfoRecdOrgPlantData.IncotermsSupChnDvtgLocAddlUUID,
  //    _PurgInfoRecdOrgPlantData.PurgInfoRecordIncotermsLocID2,

      
   //   _PurgInfoRecdOrgPlantData.PurgInfoRecordDvtgDestID,

      
      @Semantics.quantity.unitOfMeasure: 'PurchaseOrderPriceUnit'
//      @DefaultAggregation: #NONE

      _PurgInfoRecdOrgPlantData.MaximumOrderQuantity,

      _PurgInfoRecdOrgPlantData.IsRelevantForAutomSrcg,

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

      _PurchasingOrganization,
      _Plant,
      _PurchaseOrderPriceUnit,
      _Currency,
      _PurchasingGroup,
      _TaxCode,
     
      _IncotermsClassification,
      _CreatedByUser,

      _PurgInfoRecdOrgPlantData,
      _Material,
      _MaterialGroup,
      _Supplier,
      _BaseUnit,
      _PurgDocOrderQuantityUnit,
      _Country
}