I_PURCHASEREQUISITIONITEMAPI01

CDS View

Purchase Requisition Item

I_PURCHASEREQUISITIONITEMAPI01 is a CDS View in S/4HANA. Purchase Requisition Item. It contains 4 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 4 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_PurchaseRequisitionItemDEX view from CONSUMPTION Data Extraction for Purchase Requisition Item
I_PurRequisitionEmailTemplate view left_outer COMPOSITE Email Template for Purchase Requisition

Fields (4)

KeyField CDS FieldsUsed in Views
PurchaseRequisition PurchaseRequisition 1
PurchaseRequisitionItem PurchaseRequisitionItem 1
PurchaseRequisitionItemText PurchaseRequisitionItemText 1
RequisitionerName RequisitionerName 1 
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L //Inserted by VDM CDS Suite Plugin

@ObjectModel.semanticKey:['PurchaseRequisition', 'PurchaseRequisitionItem']
@ObjectModel.representativeKey: 'PurchaseRequisitionItem'
@AbapCatalog.sqlViewName: 'IPRITMAPI01' 
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Purchase Requisition Item'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #COMPOSITE
@ObjectModel.supportedCapabilities: [#SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET]
@Metadata.ignorePropagatedAnnotations: true
@AbapCatalog.preserveKey: true
@VDM.lifecycle.contract.type :#PUBLIC_LOCAL_API
define view I_PurchaseRequisitionItemAPI01
  as select from I_Purchaserequisitionitem
  
  association [1..1] to I_PurchaseRequisitionAPI01 as _PurchaseRequisition on $projection.PurchaseRequisition = _PurchaseRequisition.PurchaseRequisition

  association [0..*] to I_PurReqnAcctAssgmtAPI01  as _PurReqnAcctAssgmt on  $projection.PurchaseRequisition     = _PurReqnAcctAssgmt.PurchaseRequisition
                                                                        and $projection.PurchaseRequisitionItem = _PurReqnAcctAssgmt.PurchaseRequisitionItem
  association [0..1] to E_Purchaserequisitionitem as _Extension         on  $projection.PurchaseRequisition     = _Extension.PurchaseRequisition
                                                                        and $projection.PurchaseRequisitionItem = _Extension.PurchaseRequisitionItem

{
  //Key

  @ObjectModel.foreignKey.association: '_PurchaseRequisition'
  key I_Purchaserequisitionitem.PurchaseRequisition      as PurchaseRequisition,
  key I_Purchaserequisitionitem.PurchaseRequisitionItem  as PurchaseRequisitionItem,
      I_Purchaserequisitionitem.PurchaseReqnItemUniqueID as PurchaseReqnItemUniqueID,
      I_Purchaserequisitionitem.PurchasingDocument,
      I_Purchaserequisitionitem.PurchasingDocumentItem,
      I_Purchaserequisitionitem.PurReqnReleaseStatus,
      I_Purchaserequisitionitem.PurchaseRequisitionType,
      I_Purchaserequisitionitem.PurchasingDocumentSubtype,
      I_Purchaserequisitionitem.PurchasingDocumentItemCategory,
      I_Purchaserequisitionitem.PurchaseRequisitionItemText,
      I_Purchaserequisitionitem.AccountAssignmentCategory,
      I_Purchaserequisitionitem.Material,
      I_Purchaserequisitionitem.MaterialGroup,
      I_Purchaserequisitionitem.PurchasingDocumentCategory,
       @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      I_Purchaserequisitionitem.RequestedQuantity,
       @Semantics.unitOfMeasure: true
      I_Purchaserequisitionitem.BaseUnit,
       @Semantics.amount.currencyCode: 'PurReqnItemCurrency'
      I_Purchaserequisitionitem.PurchaseRequisitionPrice,
      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      I_Purchaserequisitionitem.PurReqnPriceQuantity,
      I_Purchaserequisitionitem.MaterialGoodsReceiptDuration,
      I_Purchaserequisitionitem.ReleaseCode,
      I_Purchaserequisitionitem.PurchaseRequisitionReleaseDate,
      I_Purchaserequisitionitem.PurchasingOrganization,
      I_Purchaserequisitionitem.PurchasingGroup,
      I_Purchaserequisitionitem.Plant,
      I_Purchaserequisitionitem.SourceOfSupplyIsAssigned,
      I_Purchaserequisitionitem.SupplyingPlant,
      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      I_Purchaserequisitionitem.OrderedQuantity,
      @Semantics.amount.currencyCode: 'PurReqnItemCurrency'
      I_Purchaserequisitionitem.PurReqnLimitConsumptionAmt,
      I_Purchaserequisitionitem.DeliveryDate,
      I_Purchaserequisitionitem.CreationDate,
      I_Purchaserequisitionitem.ProcessingStatus,
      I_Purchaserequisitionitem.PurchasingInfoRecord,
      I_Purchaserequisitionitem.Supplier,
      @Semantics.booleanIndicator:true
      I_Purchaserequisitionitem.IsDeleted,
      I_Purchaserequisitionitem.FixedSupplier,
      I_Purchaserequisitionitem.RequisitionerName,
      I_Purchaserequisitionitem.CreatedByUser,
      I_Purchaserequisitionitem.PurReqCreationDate,
      I_Purchaserequisitionitem.DeliveryAddressID,
      I_Purchaserequisitionitem.ManualDeliveryAddressID,
      @Semantics.currencyCode: true
      I_Purchaserequisitionitem.PurReqnItemCurrency,
      I_Purchaserequisitionitem.MaterialPlannedDeliveryDurn,
      I_Purchaserequisitionitem.DelivDateCategory,
      I_Purchaserequisitionitem.MultipleAcctAssgmtDistribution,
      I_Purchaserequisitionitem.StorageLocation,
      I_Purchaserequisitionitem.PurReqnSSPRequestor,
      I_Purchaserequisitionitem.PurReqnSSPAuthor,
      I_Purchaserequisitionitem.PurchaseContract,
      I_Purchaserequisitionitem.PurReqnSourceOfSupplyType,
      I_Purchaserequisitionitem.PurchaseContractItem,
      I_Purchaserequisitionitem.ConsumptionPosting,
      I_Purchaserequisitionitem.PurReqnOrigin,
      I_Purchaserequisitionitem.PurReqnSSPCatalog,
      I_Purchaserequisitionitem.PurReqnSSPCatalogItem,
      I_Purchaserequisitionitem.PurReqnSSPCrossCatalogItem,
      @Semantics.booleanIndicator:true
      I_Purchaserequisitionitem.IsPurReqnBlocked,
      I_Purchaserequisitionitem.ItemDeliveryAddressID,
      I_Purchaserequisitionitem.Language,
      I_Purchaserequisitionitem.IsClosed,
      I_Purchaserequisitionitem.Reservation,
      I_Purchaserequisitionitem.ReleaseIsNotCompleted,
      I_Purchaserequisitionitem.ServicePerformer,
      I_Purchaserequisitionitem.ProductType,
      I_Purchaserequisitionitem.PurchaseRequisitionStatus,
      I_Purchaserequisitionitem.ReleaseStrategy,
      I_Purchaserequisitionitem.PerformancePeriodStartDate,
      I_Purchaserequisitionitem.PerformancePeriodEndDate,
      I_Purchaserequisitionitem.CompanyCode,
      I_Purchaserequisitionitem.SupplierMaterialNumber,
      I_Purchaserequisitionitem.Batch,
      
      @API.element.releaseState:#DEPRECATED
      @API.element.successor:'MaterialRevisionLevel_2'
      cast( I_Purchaserequisitionitem.MaterialRevisionLevel as revlv ) as MaterialRevisionLevel,
      I_Purchaserequisitionitem.MaterialRevisionLevel as MaterialRevisionLevel_2,
      
      I_Purchaserequisitionitem.MinRemainingShelfLife,
      @Semantics.amount.currencyCode: 'PurReqnItemCurrency'
      I_Purchaserequisitionitem.ItemNetAmount,
      I_Purchaserequisitionitem.GoodsReceiptIsExpected,
      I_Purchaserequisitionitem.InvoiceIsExpected,
      I_Purchaserequisitionitem.GoodsReceiptIsNonValuated,
      I_Purchaserequisitionitem.RequirementTracking,  
      @Feature: 'MM_PUR_PR_ITEM_CDS_API_BERID'  
      I_Purchaserequisitionitem.MRPArea,    // CFD 2302.3

      I_Purchaserequisitionitem.MRPController,
      I_Purchaserequisitionitem.TaxCode,
      I_Purchaserequisitionitem.PurchaseRequisitionIsFixed,
      I_Purchaserequisitionitem.AddressID,
      I_Purchaserequisitionitem.LastChangeDateTime,
      I_Purchaserequisitionitem.PurContractForOverallLimit,
      I_Purchaserequisitionitem.PurContractItemForOverallLimit,
      I_Purchaserequisitionitem.ProcurementHubSourceSystem,
      I_Purchaserequisitionitem.ExtPurgOrgForPurg,
      I_Purchaserequisitionitem.ExtCompanyCodeForPurg,
      I_Purchaserequisitionitem.ExtPlantForPurg,
      I_Purchaserequisitionitem.ExtInfoRecordForPurg,
      I_Purchaserequisitionitem.ExtContractItemForPurg,
      I_Purchaserequisitionitem.ExtContractForPurg,
      I_Purchaserequisitionitem.ExtDesiredSupplierForPurg,
      I_Purchaserequisitionitem.ExtFixedSupplierForPurg,
      I_Purchaserequisitionitem.ExtMaterialForPurg,
      
      I_Purchaserequisitionitem.IsOutline,
      I_Purchaserequisitionitem.PurchasingParentItem,
      I_Purchaserequisitionitem.PurgConfigurableItemNumber,
      I_Purchaserequisitionitem.PurgExternalSortNumber,
               
      /* Associations */
      _PurchaseRequisition,
      _PurReqnAcctAssgmt
}

Learn More