C_PurchaseContractItem

@AbapCatalog.sqlViewName: 'CMMPURITEM'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #CONSUMPTION
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.serviceQuality:#C
@EndUserText.label: 'Purchase Contract Item Consumption View'
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL

@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED

define view C_PurchaseContractItem
  as select from I_PurchaseContractItem

  // association [0..1] to I_PurchasingDocumentItem   as _PurDocItem on  $projection.PurchaseContract     = _PurDocItem.PurchasingDocument

  //                                                                and $projection.PurchaseContractItem = _PurDocItem.PurchasingDocumentItem


  association [1..*] to I_PurgDocAccountAssignment as _PurgDoc          on  $projection.PurchaseContract     = _PurgDoc.PurchasingDocument
                                                                        and $projection.PurchaseContractItem = _PurgDoc.PurchasingDocumentItem

  association [1..*] to C_PurCtrItemAdrs           as _ItemAdrs         on  $projection.PurchaseContract     = _ItemAdrs.PurchaseContract
                                                                        and $projection.PurchaseContractItem = _ItemAdrs.PurchaseContractItem

  association [1..*] to I_PurCtrCondItem           as _ItemCond         on  $projection.PurchaseContract     = _ItemCond.PurchaseContract
                                                                        and $projection.PurchaseContractItem = _ItemCond.PurchaseContractItem
  association [1..1] to C_PurchaseContractHdr      as _PurchaseContract on  $projection.PurchaseContract = _PurchaseContract.PurchaseContract

  association [0..1] to C_ContractPrdTypeVH        as _ContractPrdTypeVH  on  $projection.ProductTypeCode = _ContractPrdTypeVH.ProductType
{
      //Key

  key PurchaseContract,
  key PurchaseContractItem,
      PurchaseContractItem           as PurchasingDocumentItem,
      PurchaseContractItemText,
      Material,
      TargetQuantity,
      // _PurDocItem.NetPriceAmount              as NetPriceAmount,

      OrderPriceUnit,
      TargetAmount,
      //  _PurDocItem.ManufacturerPartNmbr        as ManufacturerPartNmbr,

      // _PurDocItem.Manufacturer                as Manufacturer,

      PurgDocReleaseOrderQuantity,
      SupplierMaterialNumber,
      // _PurDocItem.ManufacturerMaterial,

      Plant,

      // It is fix for Duplicate Checkman Issue

      cast  ('0' as abap.dec(3,1))   as MultipleAcctAssgmtDistribution,

      OrderQuantityUnit,
      NetPriceQuantity,
      DocumentCurrency,
      // _PurgDoc.GoodsRecepientName             as GoodsRecipientName,

      cast ( '' as abap.char( 12 ) ) as GoodsRecipientName,
      //_PurReqn.MaterialRevisionLevel          as MaterialRevisionLevel,

      //_PurReqn.PurchaseContract               as PrincipalPurchaseAgreement,

      //_PurReqn.PurchaseContractItem           as PrincipalPurchaseAgreementNum,

      // _PurDocItem,

      //..............**For avoiding avoiding self join**..........//

      ContractNetPriceAmount         as NetPriceAmount,
      ManufacturerMaterial,
      ManufacturerPartNmbr,
      Manufacturer,
      //Added for Item hierarchy

      @Feature: 'MM_PUR_OA_CON_HEIR_ITEM'
      PurgConfigurableItemNumber,
      @Feature: 'MM_PUR_OA_CON_HEIR_ITEM'
      PurgExternalSortNumber,
      @Feature: 'MM_PUR_OA_CON_HEIR_ITEM'
      PurchasingParentItem,
      @Feature: 'MM_PUR_OA_CON_HEIR_ITEM'
      PurgDocAggrgdSubitemCategory,
      
      ProductType as ProductTypeCode, //ATC as ProductType GFN has different dataelement length than the DB

      
      _ContractPrdTypeVH.ProductTypeName as ProductTypeName,

      _PurgDoc,
      _ItemAdrs,
      _ItemCond,
      _PurchaseContract

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"C_CONTRACTPRDTYPEVH",
"I_PURCHASECONTRACTITEM"
],
"ASSOCIATED":
[
"C_CONTRACTPRDTYPEVH",
"C_PURCHASECONTRACTHDR",
"C_PURCTRITEMADRS",
"I_PURCTRCONDITEM",
"I_PURGDOCACCOUNTASSIGNMENT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/