P_PurgInfoRecordWithOrgData

@AbapCatalog.sqlViewName: 'PINFRECWITHORG'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@ClientHandling.algorithm: #SESSION_VARIABLE
//@Metadata.ignorePropagatedAnnotations: true

@VDM.private: true
@VDM.viewType: #COMPOSITE
@ObjectModel.semanticKey: ['Plant', 'PurchasingInfoRecordCategory', 'PurchasingOrganization', 'PurchasingInfoRecord']
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
define view P_PurgInfoRecordWithOrgData as select from I_PurgInfoRecordWithOrgData {

      Plant,
      PurchasingInfoRecordCategory,  
      PurchasingOrganization,  
      PurchasingInfoRecord,
      Supplier,
      Material,
      MaterialGroup,
      CreationDate,
      IsDeleted,
      PurchasingInfoRecordDesc,
      PurgDocOrderQuantityUnit,
      OrderItemQtyToBaseQtyNmrtr,
      OrderItemQtyToBaseQtyDnmntr,
      SupplierMaterialNumber,
      SupplierRespSalesPersonName,
      SupplierPhoneNumber,
      BaseUnit,
      SupplierMaterialGroup,
      PriorSupplier,
      AvailabilityStartDate,
      AvailabilityEndDate,
      VarblPurOrdUnitIsActive,
      Manufacturer,
      IsRegularSupplier,
      CreatedByUser,
      IsMarkedForDeletion,
      PurchasingGroup,
      Currency, 
      MinimumPurchaseOrderQuantity,
      StandardPurchaseOrderQuantity,
      MaterialPlannedDeliveryDurn,
      OverdelivTolrtdLmtRatioInPct,
      UnderdelivTolrtdLmtRatioInPct,
      UnlimitedOverdeliveryIsAllowed,
      LastReferencingPurchaseOrder,
      LastReferencingPurOrderItem,
      NetPriceAmount,
      MaterialPriceUnitQty,
      PurchaseOrderPriceUnit,
      PriceValidityEndDate,
      OrderPriceUnitToOrderUnitNmrtr,
      OrdPriceUnitToOrderUnitDnmntr,
      InvoiceIsGoodsReceiptBased,
      TaxCode,
      TimeDependentTaxValidFromDate,
      TaxCountry,
      IncotermsClassification,
      IncotermsTransferLocation,
      IncotermsLocation1,
  //    PurgInfoRecordIncotermsLocID1,

  //    PurgInfoRecordIncotermsLocID2,

  //    PurgInfoRecordDvtgDestID,

      IncotermsSupChnLoc1AddlUUID,
      IncotermsSupChnLoc2AddlUUID,
      IncotermsSupChnDvtgLocAddlUUID,
      MaximumOrderQuantity,
      IsRelevantForAutomSrcg,
      NoDaysReminder1,
      NoDaysReminder2,
      NoDaysReminder3,
      ProductPurchasePointsQty,
      ProductPurchasePointsQtyUnit,
      ReturnAgreement,
      SupplierCertOriginCat,
      SupplierCertOriginNumber,
      SupplierCertValidityEndDate,
      SupplierCertOriginCountry,
      SupplierCertOriginRegion,
      SuplrCertOriginClassfctnNumber,
      SupplierQuotation,
      SupplierQuotationDate,
      MinRemainingShelfLife,
      ShippingInstruction,
      IsEvaluatedRcptSettlmtAllowed,
      IsPurOrderAllwdForInbDeliv,
      IsOrderAcknRqd,
      SupplierConfirmationControlKey,
      MaterialRoundingProfile,
      MaterialStagingTime,
      ProductUnitGroup,
      IsRetMatlAuthznRqdBySupplier,
      IsCashDiscountGranted,
      MaterialConditionGroup,
      PricingDateControl,
      IncotermsLocation2,
      IncotermsVersion,
      SupplierSubrange,
      PurchasingDocumentDate,
      SupplierSubrangeSortNumber,
      ShelfLifeExpirationDatePeriod,
      LastChangeDateTime,
      cast( 'X' as sdraft_is_active preserving type ) as IsActiveEntity,
      cast( hextobin( '00000000000000000000000000000000' ) as /bobf/uuid ) as PurgInfoRecdDrftID,
      //Sort Term

      PurgInfoRecNonStockItmSortTerm,
      
      
      _PurInfCndPeriod,
      _PurchasingOrganization,
      _Plant,
      _PurchaseOrderPriceUnit,
      _Currency,
      _PurchasingGroup,
      _TaxCode,
      _IncotermsClassification,
      _CreatedByUser,
      _PurgInfoRecdOrgPlantData,
      _Material,
      _MaterialGroup,
      _Supplier,
      _BaseUnit,
      _PurgDocOrderQuantityUnit,
      _Country
            
  
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURGINFORECORDWITHORGDATA"
],
"ASSOCIATED":
[
"I_COUNTRY",
"I_CURRENCY",
"I_INCOTERMSCLASSIFICATION",
"I_MATERIAL",
"I_MATERIALGROUP",
"I_PLANT",
"I_PURCHASINGGROUP",
"I_PURCHASINGORGANIZATION",
"I_PURGINFORECDORGPLANTDATA",
"I_PURINFCNDPERIOD",
"I_SUPPLIER",
"I_TAXCODE",
"I_UNITOFMEASURE",
"I_USER"
],
"BASE":
[
"I_PURGINFORECORDWITHORGDATA"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/