R_PurchaseContractItem

@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'RPURCHASECTRITM'
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'Purchase Contract Item Base view'
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@VDM.viewType : #BASIC
@ObjectModel.representativeKey: 'PurchaseContractItem'
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@AbapCatalog.preserveKey:true
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API

define view R_PurchaseContractItem
  as select from R_PurchasingDocumentItem as Item
  inner join R_PurchaseContract    as Header   on  Item.PurchasingDocument = Header.PurchaseContract
  //association [1..1] to R_PurchaseContract    as _PurchaseContract   on  $projection.PurchaseContract = _PurchaseContract.PurchaseContract

  
{
  key cast (Item.PurchasingDocument as vdm_purchasecontract preserving type)         as PurchaseContract,

  key cast (Item.PurchasingDocumentItem as vdm_purchasecontractitem preserving type) as PurchaseContractItem,

      Item.PurchasingDocumentItemUniqueID                                            as PurchaseContractItemUniqueID,

      Item.CompanyCode,

      Item.PurchasingDocumentCategory,

      Item.Material,

      Item.ManufacturerMaterial,

      @Semantics.text: true
      Item.PurchasingDocumentItemText                                                as PurchaseContractItemText,

      @Semantics.amount.currencyCode: 'DocumentCurrency'
      @DefaultAggregation: #NONE
      Item.NetPriceAmount                                                            as ContractNetPriceAmount,

      @Semantics.unitOfMeasure: true
      Item.OrderPriceUnit,

      @Semantics.unitOfMeasure: true
      Item.VolumeUnit,

      @Semantics.unitOfMeasure: true
      Item.OrderQuantityUnit,

      Item.MaterialGroup,

      Item.Customer,
      Item.Subcontractor,

      --cast needed to change the default description
      cast (Item.ReferenceDeliveryAddressID as mm_oa_ref_address)                    as ReferenceDeliveryAddressID,

      case
      when Item.ManualDeliveryAddressID = '' and Item.ReferenceDeliveryAddressID = ''
        then _Plant.AddressID
      when Item.ReferenceDeliveryAddressID <> ''
        then Item.ReferenceDeliveryAddressID
      else
      Item.ManualDeliveryAddressID
      end                                                                       as ManualDeliveryAddressID,

      cast ('' as adrnr )                                                       as DeliveryAddressID,

      Item.Plant,

      Item.StorageLocation,

      Item.AccountAssignmentCategory,

      Item.GoodsReceiptIsExpected,
      
      Item.IsToBeAcceptedAtOrigin,

      // @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'

      // @DefaultAggregation: #NONE

      Item.NetPriceQuantity,

      Item.MultipleAcctAssgmtDistribution,

      //   @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'

      //   @DefaultAggregation: #NONE

      Item.TargetQuantity,

      @Semantics.amount.currencyCode: 'DocumentCurrency'
      @DefaultAggregation: #NONE
      Item.TargetAmount,

      @Semantics.currencyCode: true
      Item.DocumentCurrency,

      Item.OrdPriceUnitToOrderUnitDnmntr, // price conversion from


      --cast needed to change the default description
      cast (Item.OrderPriceUnitToOrderUnitNmrtr as mm_oa_conv_unit_nmrtr)            as OrderPriceUnitToOrderUnitNmrtr, // price conversion to


      Item.PurchasingDocumentItemCategory,

      Item.SupplierMaterialNumber,

      Item.EvaldRcptSettlmtIsAllowed,

      Item.UnderdelivTolrtdLmtRatioInPct,

      Item.PriceIsToBePrinted,

      Item.SupplierConfirmationControlKey,

      Item.OverdelivTolrtdLmtRatioInPct,

      Item.UnlimitedOverdeliveryIsAllowed,

      Item.IncotermsClassification,

      Item.IncotermsLocation1,
      
      Item.IncotermsLocation2,
      
      Item.IncotermsSupChnLoc1AddlUUID,
      
      Item.IncotermsSupChnLoc2AddlUUID,
      
      Item.IncotermsSupChnDvtgLocAddlUUID,

      Item.InvoiceIsExpected,

      Item.InvoiceIsGoodsReceiptBased,

      Item.PurgDocPriceDate,

      Item.PurchasingInfoRecordUpdateCode,

      Item.PurchasingInfoRecord,

      Item.PurgDocReleaseOrderQuantity,

      Item.PurgDocOrderAcknNumber,

      Item.PurchasingPriceIsEstimated,

      cast (Item.IsInfoAtRegistration as mm_oa_infoatregn)                           as IsInfoAtRegistration,
      
      Item.SupplierSubrange,

      Item.NoDaysReminder1,

      Item.NoDaysReminder2,

      Item.NoDaysReminder3,

      Item.PlannedDeliveryDurationInDays,

      Item.StockType,

      Item.TaxCode,

      Item.TaxCountry,

      Item.TaxDeterminationDate,

      Item.RequirementTracking,

      Item.IsOrderAcknRqd,

      Item.ShippingInstruction,
      
      Item.ShippingType,

      Item.GoodsReceiptIsNonValuated,

      Item.ServicePerformer,

      Item.ProductType                                                               as ProductTypeCode,

      Item.MaterialType,

      Item.PurchasingDocumentDeletionCode                                            as PurchasingContractDeletionCode,
      //_PurchaseContract.PurchasingDocumentDeletionCode,


      Item.PurchaseRequisition,

      Item.PurchaseRequisitionItem,

      Item.PartialInvoiceDistribution,

      Item.ManufacturerPartNmbr                                                      as ManufacturerPartNmbr,

      Item.Manufacturer                                                              as Manufacturer,

      Item.IsEndOfPurposeBlocked,

      Item.ProductCharacteristic1,

      Item.ProductCharacteristic2,

      Item.ProductCharacteristic3,

      Item.ProductCollection,

      Item.ProductSeason,

      Item.ProductSeasonYear,

      Item.ProductTheme,

      Item.PurchasingParentItem,

      Item.StockSegment,

      Item.PlndOrderReplnmtElmntType,
      
      Header.CreatedByUser               as PurchaseContractCreatedByUser,

      Header.ValidityStartDate           as PurContrValidityStartDate,

      Header.ValidityEndDate             as PurContrValidityEndDate,

      Header.PurchasingGroup,

      Header.PurchaseContractTargetAmount as OutlineAgreementTargetAmount,

      Header.PurchaseContractType,    


      //Added for Item hierarchy

      Item.IsStatisticalItem,
      Item.PurgConfigurableItemNumber,
      Item.PurgDocAggrgdSubitemCategory,
      Item.PurgExternalSortNumber,

      // fields from product compliance

      Item.PurgProdCmplncSupplierStatus,
      Item.PurgProductMarketabilityStatus,
      Item.PurgSafetyDataSheetStatus,
      Item.PurgProdCmplncDngrsGoodsStatus,
      
      Item.PurchasingIsCatalogRelevant,
    
      _MaterialGroup,

      _Plant,

      _StorageLocation,

      _Material,

      //_ManualDeliveryAddress ,


      _OrderQuantityUnit,

      _VolumeUnit,

      _OrderPriceUnit,

      _DocumentCurrency

}    
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PLANT",
"R_PURCHASECONTRACT",
"R_PURCHASINGDOCUMENTITEM"
],
"ASSOCIATED":
[
"I_CURRENCY",
"I_MATERIAL",
"I_MATERIALGROUP",
"I_PLANT",
"I_STORAGELOCATION",
"I_UNITOFMEASURE"
],
"BASE":
[
"R_PURCHASINGDOCUMENTITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/