I_PurchaseRequisition_Api01
Purchase Requisition Item
I_PurchaseRequisition_Api01 is a Composite CDS View that provides data about "Purchase Requisition Item" in SAP S/4HANA. It reads from 1 data source (I_Purchaserequisitionitem) and exposes 91 fields with key fields PurchaseRequisition, PurchaseRequisitionItem. It has 2 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_Purchaserequisitionitem | I_Purchaserequisitionitem | from |
Associations (2)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..*] | I_PurReqnAcctAssgmt_Api01 | _PurReqnAcctAssgmt | $projection.PurchaseRequisition = _PurReqnAcctAssgmt.PurchaseRequisition and $projection.PurchaseRequisitionItem = _PurReqnAcctAssgmt.PurchaseRequisitionItem |
| [0..1] | E_Purchaserequisitionitem | _Extension | $projection.PurchaseRequisition = _Extension.PurchaseRequisition and $projection.PurchaseRequisitionItem = _Extension.PurchaseRequisitionItem |
Annotations (13)
| Name | Value | Level | Field |
|---|---|---|---|
| ObjectModel.usageType.dataClass | #MIXED | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| AbapCatalog.sqlViewName | IPRITEMAPI01 | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| EndUserText.label | Purchase Requisition Item | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| VDM.viewType | #COMPOSITE | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| VDM.lifecycle.contract.type | #PUBLIC_LOCAL_API | view | |
| VDM.lifecycle.status | #DEPRECATED | view | |
| VDM.lifecycle.successor | I_PurchaseRequisitionItemAPI01 | view |
Fields (91)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | PurchaseRequisition | I_Purchaserequisitionitem | PurchaseRequisition | |
| KEY | PurchaseRequisitionItem | I_Purchaserequisitionitem | PurchaseRequisitionItem | |
| PurchaseReqnItemUniqueID | I_Purchaserequisitionitem | PurchaseReqnItemUniqueID | ||
| PurchasingDocument | I_Purchaserequisitionitem | PurchasingDocument | ||
| PurchasingDocumentItem | I_Purchaserequisitionitem | PurchasingDocumentItem | ||
| PurReqnReleaseStatus | I_Purchaserequisitionitem | PurReqnReleaseStatus | ||
| PurchaseRequisitionType | I_Purchaserequisitionitem | PurchaseRequisitionType | ||
| PurchasingDocumentSubtype | I_Purchaserequisitionitem | PurchasingDocumentSubtype | ||
| PurchasingDocumentItemCategory | I_Purchaserequisitionitem | PurchasingDocumentItemCategory | ||
| PurchaseRequisitionItemText | I_Purchaserequisitionitem | PurchaseRequisitionItemText | ||
| AccountAssignmentCategory | I_Purchaserequisitionitem | AccountAssignmentCategory | ||
| Material | I_Purchaserequisitionitem | Material | ||
| MaterialGroup | I_Purchaserequisitionitem | MaterialGroup | ||
| PurchasingDocumentCategory | I_Purchaserequisitionitem | PurchasingDocumentCategory | ||
| RequestedQuantity | I_Purchaserequisitionitem | RequestedQuantity | ||
| BaseUnit | I_Purchaserequisitionitem | BaseUnit | ||
| PurchaseRequisitionPrice | I_Purchaserequisitionitem | PurchaseRequisitionPrice | ||
| PurReqnPriceQuantity | I_Purchaserequisitionitem | PurReqnPriceQuantity | ||
| MaterialGoodsReceiptDuration | I_Purchaserequisitionitem | MaterialGoodsReceiptDuration | ||
| ReleaseCode | I_Purchaserequisitionitem | ReleaseCode | ||
| PurchaseRequisitionReleaseDate | I_Purchaserequisitionitem | PurchaseRequisitionReleaseDate | ||
| PurchasingOrganization | I_Purchaserequisitionitem | PurchasingOrganization | ||
| PurchasingGroup | I_Purchaserequisitionitem | PurchasingGroup | ||
| Plant | I_Purchaserequisitionitem | Plant | ||
| SourceOfSupplyIsAssigned | I_Purchaserequisitionitem | SourceOfSupplyIsAssigned | ||
| SupplyingPlant | I_Purchaserequisitionitem | SupplyingPlant | ||
| OrderedQuantity | I_Purchaserequisitionitem | OrderedQuantity | ||
| DeliveryDate | I_Purchaserequisitionitem | DeliveryDate | ||
| CreationDate | I_Purchaserequisitionitem | CreationDate | ||
| ProcessingStatus | I_Purchaserequisitionitem | ProcessingStatus | ||
| PurchasingInfoRecord | I_Purchaserequisitionitem | PurchasingInfoRecord | ||
| Supplier | I_Purchaserequisitionitem | Supplier | ||
| IsDeleted | I_Purchaserequisitionitem | IsDeleted | ||
| FixedSupplier | I_Purchaserequisitionitem | FixedSupplier | ||
| RequisitionerName | I_Purchaserequisitionitem | RequisitionerName | ||
| CreatedByUser | I_Purchaserequisitionitem | CreatedByUser | ||
| PurReqCreationDate | I_Purchaserequisitionitem | PurReqCreationDate | ||
| DeliveryAddressID | I_Purchaserequisitionitem | DeliveryAddressID | ||
| ManualDeliveryAddressID | I_Purchaserequisitionitem | ManualDeliveryAddressID | ||
| PurReqnItemCurrency | I_Purchaserequisitionitem | PurReqnItemCurrency | ||
| MaterialPlannedDeliveryDurn | I_Purchaserequisitionitem | MaterialPlannedDeliveryDurn | ||
| DelivDateCategory | I_Purchaserequisitionitem | DelivDateCategory | ||
| MultipleAcctAssgmtDistribution | I_Purchaserequisitionitem | MultipleAcctAssgmtDistribution | ||
| StorageLocation | I_Purchaserequisitionitem | StorageLocation | ||
| PurReqnSSPRequestor | I_Purchaserequisitionitem | PurReqnSSPRequestor | ||
| PurReqnSSPAuthor | I_Purchaserequisitionitem | PurReqnSSPAuthor | ||
| PurchaseContract | I_Purchaserequisitionitem | PurchaseContract | ||
| PurReqnSourceOfSupplyType | I_Purchaserequisitionitem | PurReqnSourceOfSupplyType | ||
| PurchaseContractItem | I_Purchaserequisitionitem | PurchaseContractItem | ||
| ConsumptionPosting | I_Purchaserequisitionitem | ConsumptionPosting | ||
| PurReqnOrigin | I_Purchaserequisitionitem | PurReqnOrigin | ||
| PurReqnSSPCatalog | I_Purchaserequisitionitem | PurReqnSSPCatalog | ||
| PurReqnSSPCatalogItem | I_Purchaserequisitionitem | PurReqnSSPCatalogItem | ||
| PurReqnSSPCrossCatalogItem | I_Purchaserequisitionitem | PurReqnSSPCrossCatalogItem | ||
| IsPurReqnBlocked | I_Purchaserequisitionitem | IsPurReqnBlocked | ||
| ItemDeliveryAddressID | I_Purchaserequisitionitem | ItemDeliveryAddressID | ||
| Language | I_Purchaserequisitionitem | Language | ||
| IsClosed | I_Purchaserequisitionitem | IsClosed | ||
| ReleaseIsNotCompleted | I_Purchaserequisitionitem | ReleaseIsNotCompleted | ||
| ServicePerformer | I_Purchaserequisitionitem | ServicePerformer | ||
| ProductType | I_Purchaserequisitionitem | ProductType | ||
| PurchaseRequisitionStatus | I_Purchaserequisitionitem | PurchaseRequisitionStatus | ||
| ReleaseStrategy | I_Purchaserequisitionitem | ReleaseStrategy | ||
| PerformancePeriodStartDate | I_Purchaserequisitionitem | PerformancePeriodStartDate | ||
| PerformancePeriodEndDate | I_Purchaserequisitionitem | PerformancePeriodEndDate | ||
| CompanyCode | I_Purchaserequisitionitem | CompanyCode | ||
| SupplierMaterialNumber | I_Purchaserequisitionitem | SupplierMaterialNumber | ||
| Batch | I_Purchaserequisitionitem | Batch | ||
| MaterialRevisionLevel | ||||
| MaterialRevisionLevel_2 | I_Purchaserequisitionitem | MaterialRevisionLevel | ||
| MinRemainingShelfLife | I_Purchaserequisitionitem | MinRemainingShelfLife | ||
| ItemNetAmount | I_Purchaserequisitionitem | ItemNetAmount | ||
| GoodsReceiptIsExpected | I_Purchaserequisitionitem | GoodsReceiptIsExpected | ||
| InvoiceIsExpected | I_Purchaserequisitionitem | InvoiceIsExpected | ||
| GoodsReceiptIsNonValuated | I_Purchaserequisitionitem | GoodsReceiptIsNonValuated | ||
| RequirementTracking | I_Purchaserequisitionitem | RequirementTracking | ||
| MRPController | I_Purchaserequisitionitem | MRPController | ||
| PurchaseRequisitionIsFixed | I_Purchaserequisitionitem | PurchaseRequisitionIsFixed | ||
| AddressID | I_Purchaserequisitionitem | AddressID | ||
| LastChangeDateTime | I_Purchaserequisitionitem | LastChangeDateTime | ||
| ProcurementHubSourceSystem | I_Purchaserequisitionitem | ProcurementHubSourceSystem | ||
| ExtPurgOrgForPurg | I_Purchaserequisitionitem | ExtPurgOrgForPurg | ||
| ExtCompanyCodeForPurg | I_Purchaserequisitionitem | ExtCompanyCodeForPurg | ||
| ExtPlantForPurg | I_Purchaserequisitionitem | ExtPlantForPurg | ||
| ExtInfoRecordForPurg | I_Purchaserequisitionitem | ExtInfoRecordForPurg | ||
| ExtContractItemForPurg | I_Purchaserequisitionitem | ExtContractItemForPurg | ||
| ExtContractForPurg | I_Purchaserequisitionitem | ExtContractForPurg | ||
| ExtDesiredSupplierForPurg | I_Purchaserequisitionitem | ExtDesiredSupplierForPurg | ||
| ExtFixedSupplierForPurg | I_Purchaserequisitionitem | ExtFixedSupplierForPurg | ||
| ExtMaterialForPurg | I_Purchaserequisitionitem | ExtMaterialForPurg | ||
| _PurReqnAcctAssgmt | _PurReqnAcctAssgmt |
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L //Inserted by VDM CDS Suite Plugin
@ObjectModel.semanticKey:['PurchaseRequisition', 'PurchaseRequisitionItem']
@AbapCatalog.sqlViewName: 'IPRITEMAPI01'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Purchase Requisition Item'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #COMPOSITE
@Metadata.ignorePropagatedAnnotations: true
@VDM.lifecycle.contract.type :#PUBLIC_LOCAL_API
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'I_PurchaseRequisitionItemAPI01'
define view I_PurchaseRequisition_Api01 as select from I_Purchaserequisitionitem
association [0..*] to I_PurReqnAcctAssgmt_Api01 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 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,
I_Purchaserequisitionitem.DeliveryDate,
I_Purchaserequisitionitem.CreationDate,
I_Purchaserequisitionitem.ProcessingStatus,
I_Purchaserequisitionitem.PurchasingInfoRecord,
I_Purchaserequisitionitem.Supplier,
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,
I_Purchaserequisitionitem.IsPurReqnBlocked,
I_Purchaserequisitionitem.ItemDeliveryAddressID,
I_Purchaserequisitionitem.Language,
I_Purchaserequisitionitem.IsClosed,
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,
I_Purchaserequisitionitem.MRPController,
I_Purchaserequisitionitem.PurchaseRequisitionIsFixed,
I_Purchaserequisitionitem.AddressID,
I_Purchaserequisitionitem.LastChangeDateTime,
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,
/* Associations */
_PurReqnAcctAssgmt
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURCHASEREQUISITIONITEM"
],
"ASSOCIATED":
[
"E_PURCHASEREQUISITIONITEM",
"I_PURREQNACCTASSGMT_API01"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA