I_PurchaseOrderItemAPI01
Purchase Order Item
I_PurchaseOrderItemAPI01 is a Basic CDS View that provides data about "Purchase Order Item" in SAP S/4HANA. It reads from 1 data source (R_PurchaseOrderItem) and exposes 142 fields with key fields PurchaseOrder, PurchaseOrderItem. It has 4 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| R_PurchaseOrderItem | R_PurchaseOrderItem | from |
Associations (4)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..1] | I_PurchaseOrderAPI01 | _PurchaseOrder | $projection.PurchaseOrder = _PurchaseOrder.PurchaseOrder |
| [1..*] | I_PurOrdAccountAssignmentAPI01 | _PurOrdAcctAssignment | _PurOrdAcctAssignment.PurchaseOrder = $projection.PurchaseOrder and _PurOrdAcctAssignment.PurchaseOrderItem = $projection.PurchaseOrderItem |
| [1..*] | I_PurOrdScheduleLineAPI01 | _PurOrdScheduleLine | _PurOrdScheduleLine.PurchaseOrder = $projection.PurchaseOrder and _PurOrdScheduleLine.PurchaseOrderItem = $projection.PurchaseOrderItem ----Extension |
| [1..1] | E_PurchasingDocumentItem | _PurchaseOrderItemExtension | $projection.PurchaseOrder = _PurchaseOrderItemExtension.PurchasingDocument and $projection.PurchaseOrderItem = _PurchaseOrderItemExtension.PurchasingDocumentItem |
Annotations (13)
| Name | Value | Level | Field |
|---|---|---|---|
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| AbapCatalog.sqlViewName | IMMPOITEMAPI01 | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| VDM.viewType | #BASIC | view | |
| EndUserText.label | Purchase Order Item | view | |
| ObjectModel.usageType.serviceQuality | #A | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ObjectModel.representativeKey | PurchaseOrderItem | view | |
| AccessControl.personalData.blocking | #BLOCKED_DATA_EXCLUDED | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| VDM.lifecycle.contract.type | #PUBLIC_LOCAL_API | view |
Fields (142)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | PurchaseOrder | PurchaseOrder | ||
| KEY | PurchaseOrderItem | PurchaseOrderItem | ||
| PurchaseOrderItemUniqueID | PurchaseOrderItemUniqueID | |||
| PurchaseOrderCategory | PurchaseOrderCategory | |||
| DocumentCurrency | DocumentCurrency | |||
| PurchasingDocumentDeletionCode | PurchasingDocumentDeletionCode | |||
| PurchasingDocumentItemOrigin | PurchasingDocumentItemOrigin | |||
| MaterialGroup | MaterialGroup | |||
| Material | Material | |||
| MaterialType | MaterialType | |||
| SupplierMaterialNumber | SupplierMaterialNumber | |||
| SupplierSubrange | SupplierSubrange | |||
| ManufacturerPartNmbr | ManufacturerPartNmbr | |||
| Manufacturer | Manufacturer | |||
| ManufacturerMaterial | ManufacturerMaterial | |||
| PurchaseOrderItemText | PurchaseOrderItemText | |||
| ProductType | ProductType | |||
| CompanyCode | CompanyCode | |||
| Plant | Plant | |||
| ManualDeliveryAddressID | ManualDeliveryAddressID | |||
| ReferenceDeliveryAddressID | ReferenceDeliveryAddressID | |||
| Customer | Customer | |||
| Subcontractor | Subcontractor | |||
| SupplierIsSubcontractor | SupplierIsSubcontractor | |||
| CrossPlantConfigurableProduct | CrossPlantConfigurableProduct | |||
| ArticleCategory | ArticleCategory | |||
| PlndOrderReplnmtElmntType | PlndOrderReplnmtElmntType | |||
| ProductPurchasePointsQtyUnit | ProductPurchasePointsQtyUnit | |||
| ProductPurchasePointsQty | ProductPurchasePointsQty | |||
| StorageLocation | StorageLocation | |||
| PurchaseOrderQuantityUnit | PurchaseOrderQuantityUnit | |||
| OrderItemQtyToBaseQtyNmrtr | OrderItemQtyToBaseQtyNmrtr | |||
| OrderItemQtyToBaseQtyDnmntr | OrderItemQtyToBaseQtyDnmntr | |||
| NetPriceQuantity | NetPriceQuantity | |||
| IsCompletelyDelivered | IsCompletelyDelivered | |||
| IsFinallyInvoiced | IsFinallyInvoiced | |||
| GoodsReceiptIsExpected | GoodsReceiptIsExpected | |||
| InvoiceIsExpected | InvoiceIsExpected | |||
| InvoiceIsGoodsReceiptBased | InvoiceIsGoodsReceiptBased | |||
| PurchaseContractItem | PurchaseContractItem | |||
| PurchaseContract | PurchaseContract | |||
| PurchaseRequisition | PurchaseRequisition | |||
| RequirementTracking | RequirementTracking | |||
| PurchaseRequisitionItem | PurchaseRequisitionItem | |||
| EvaldRcptSettlmtIsAllowed | EvaldRcptSettlmtIsAllowed | |||
| UnlimitedOverdeliveryIsAllowed | UnlimitedOverdeliveryIsAllowed | |||
| OverdelivTolrtdLmtRatioInPct | OverdelivTolrtdLmtRatioInPct | |||
| UnderdelivTolrtdLmtRatioInPct | UnderdelivTolrtdLmtRatioInPct | |||
| RequisitionerName | RequisitionerName | |||
| PlannedDeliveryDurationInDays | PlannedDeliveryDurationInDays | |||
| GoodsReceiptDurationInDays | GoodsReceiptDurationInDays | |||
| PartialDeliveryIsAllowed | PartialDeliveryIsAllowed | |||
| ConsumptionPosting | ConsumptionPosting | |||
| ServicePerformer | ServicePerformer | |||
| BaseUnit | BaseUnit | |||
| PurchaseOrderItemCategory | PurchaseOrderItemCategory | |||
| ProfitCenter | ProfitCenter | |||
| OrderPriceUnit | OrderPriceUnit | |||
| ItemVolumeUnit | ItemVolumeUnit | |||
| ItemWeightUnit | ItemWeightUnit | |||
| MultipleAcctAssgmtDistribution | MultipleAcctAssgmtDistribution | |||
| PartialInvoiceDistribution | PartialInvoiceDistribution | |||
| PricingDateControl | PricingDateControl | |||
| IsStatisticalItem | IsStatisticalItem | |||
| PurchasingParentItem | PurchasingParentItem | |||
| GoodsReceiptLatestCreationDate | GoodsReceiptLatestCreationDate | |||
| IsReturnsItem | IsReturnsItem | |||
| PurchasingOrderReason | PurchasingOrderReason | |||
| IncotermsClassification | IncotermsClassification | |||
| IncotermsTransferLocation | IncotermsTransferLocation | |||
| IncotermsLocation1 | IncotermsLocation1 | |||
| IncotermsLocation2 | IncotermsLocation2 | |||
| PriorSupplier | PriorSupplier | |||
| InternationalArticleNumber | InternationalArticleNumber | |||
| IntrastatServiceCode | IntrastatServiceCode | |||
| CommodityCode | CommodityCode | |||
| MaterialFreightGroup | MaterialFreightGroup | |||
| DiscountInKindEligibility | DiscountInKindEligibility | |||
| PurgItemIsBlockedForDelivery | PurgItemIsBlockedForDelivery | |||
| SupplierConfirmationControlKey | SupplierConfirmationControlKey | |||
| PriceIsToBePrinted | PriceIsToBePrinted | |||
| AccountAssignmentCategory | AccountAssignmentCategory | |||
| PurchasingInfoRecord | PurchasingInfoRecord | |||
| NetAmount | NetAmount | |||
| GrossAmount | GrossAmount | |||
| EffectiveAmount | EffectiveAmount | |||
| Subtotal1Amount | Subtotal1Amount | |||
| Subtotal2Amount | Subtotal2Amount | |||
| Subtotal3Amount | Subtotal3Amount | |||
| Subtotal4Amount | Subtotal4Amount | |||
| Subtotal5Amount | Subtotal5Amount | |||
| Subtotal6Amount | Subtotal6Amount | |||
| OrderQuantity | OrderQuantity | |||
| NetPriceAmount | NetPriceAmount | |||
| ItemVolume | ItemVolume | |||
| ItemGrossWeight | ItemGrossWeight | |||
| ItemNetWeight | ItemNetWeight | |||
| OrderPriceUnitToOrderUnitNmrtr | OrderPriceUnitToOrderUnitNmrtr | |||
| OrdPriceUnitToOrderUnitDnmntr | OrdPriceUnitToOrderUnitDnmntr | |||
| GoodsReceiptIsNonValuated | GoodsReceiptIsNonValuated | |||
| TaxCode | TaxCode | |||
| TaxJurisdiction | TaxJurisdiction | |||
| ShippingInstruction | ShippingInstruction | |||
| ShippingType | ShippingType | |||
| NonDeductibleInputTaxAmount | NonDeductibleInputTaxAmount | |||
| StockType | StockType | |||
| ValuationType | ValuationType | |||
| ValuationCategory | ValuationCategory | |||
| ItemIsRejectedBySupplier | ItemIsRejectedBySupplier | |||
| PurgDocPriceDate | PurgDocPriceDate | |||
| PurgDocReleaseOrderQuantity | PurgDocReleaseOrderQuantity | |||
| EarmarkedFunds | EarmarkedFunds | |||
| EarmarkedFundsDocument | EarmarkedFundsDocument | |||
| EarmarkedFundsItem | EarmarkedFundsItem | |||
| EarmarkedFundsDocumentItem | EarmarkedFundsDocumentItem | |||
| PartnerReportedBusinessArea | PartnerReportedBusinessArea | |||
| InventorySpecialStockType | InventorySpecialStockType | |||
| DeliveryDocumentType | DeliveryDocumentType | |||
| IssuingStorageLocation | IssuingStorageLocation | |||
| AllocationTable | AllocationTable | |||
| AllocationTableItem | AllocationTableItem | |||
| RetailPromotion | RetailPromotion | |||
| DownPaymentType | DownPaymentType | |||
| DownPaymentPercentageOfTotAmt | DownPaymentPercentageOfTotAmt | |||
| DownPaymentAmount | DownPaymentAmount | |||
| DownPaymentDueDate | DownPaymentDueDate | |||
| ExpectedOverallLimitAmount | ExpectedOverallLimitAmount | |||
| OverallLimitAmount | OverallLimitAmount | |||
| RequirementSegment | RequirementSegment | |||
| PurgProdCmplncDngrsGoodsStatus | PurgProdCmplncDngrsGoodsStatus | |||
| PurgProdCmplncSupplierStatus | PurgProdCmplncSupplierStatus | |||
| PurgProductMarketabilityStatus | PurgProductMarketabilityStatus | |||
| PurgSafetyDataSheetStatus | PurgSafetyDataSheetStatus | |||
| SubcontrgCompIsRealTmeCnsmd | SubcontrgCompIsRealTmeCnsmd | |||
| BR_MaterialOrigin | BR_MaterialOrigin | |||
| BR_MaterialUsage | BR_MaterialUsage | |||
| BR_CFOPCategory | BR_CFOPCategory | |||
| BR_NCM | BR_NCM | |||
| BR_IsProducedInHouse | BR_IsProducedInHouse | |||
| _PurchaseOrder | _PurchaseOrder | |||
| _PurOrdScheduleLine | _PurOrdScheduleLine | |||
| _PurOrdAcctAssignment | _PurOrdAcctAssignment |
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'IMMPOITEMAPI01'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType : #BASIC
@EndUserText.label: 'Purchase Order Item'
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.representativeKey: 'PurchaseOrderItem'
@ObjectModel.semanticKey: ['PurchaseOrder','PurchaseOrderItem']
@ObjectModel.supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET ]
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@Metadata.ignorePropagatedAnnotations:true
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
define view I_PurchaseOrderItemAPI01
as select from R_PurchaseOrderItem
association [1..1] to I_PurchaseOrderAPI01 as _PurchaseOrder on $projection.PurchaseOrder = _PurchaseOrder.PurchaseOrder
association [1..*] to I_PurOrdAccountAssignmentAPI01 as _PurOrdAcctAssignment on _PurOrdAcctAssignment.PurchaseOrder = $projection.PurchaseOrder
and _PurOrdAcctAssignment.PurchaseOrderItem = $projection.PurchaseOrderItem
association [1..*] to I_PurOrdScheduleLineAPI01 as _PurOrdScheduleLine on _PurOrdScheduleLine.PurchaseOrder = $projection.PurchaseOrder
and _PurOrdScheduleLine.PurchaseOrderItem = $projection.PurchaseOrderItem
----Extension Association
association [1..1] to E_PurchasingDocumentItem as _PurchaseOrderItemExtension on $projection.PurchaseOrder = _PurchaseOrderItemExtension.PurchasingDocument
and $projection.PurchaseOrderItem = _PurchaseOrderItemExtension.PurchasingDocumentItem
{
//Key
@ObjectModel.foreignKey.association: '_PurchaseOrder'
key PurchaseOrder,
key PurchaseOrderItem,
PurchaseOrderItemUniqueID,
PurchaseOrderCategory,
@Semantics.currencyCode: true
DocumentCurrency,
PurchasingDocumentDeletionCode,
PurchasingDocumentItemOrigin,
//Product
MaterialGroup,
Material,
MaterialType,
SupplierMaterialNumber,
SupplierSubrange,
ManufacturerPartNmbr,
Manufacturer,
ManufacturerMaterial,
PurchaseOrderItemText,
ProductType,
CompanyCode,
Plant,
ManualDeliveryAddressID,
ReferenceDeliveryAddressID,
Customer,
Subcontractor,
SupplierIsSubcontractor,
CrossPlantConfigurableProduct,
ArticleCategory,
PlndOrderReplnmtElmntType,
@Semantics.unitOfMeasure: true
ProductPurchasePointsQtyUnit,
@Semantics.quantity.unitOfMeasure: 'ProductPurchasePointsQtyUnit'
ProductPurchasePointsQty,
StorageLocation,
// main Quantity Unit for PO Item
@Semantics.unitOfMeasure: true
PurchaseOrderQuantityUnit,
OrderItemQtyToBaseQtyNmrtr,
OrderItemQtyToBaseQtyDnmntr,
@Semantics.quantity.unitOfMeasure: 'PurchaseOrderQuantityUnit'
NetPriceQuantity,
IsCompletelyDelivered,
IsFinallyInvoiced,
GoodsReceiptIsExpected,
InvoiceIsExpected,
InvoiceIsGoodsReceiptBased,
PurchaseContractItem,
PurchaseContract,
PurchaseRequisition,
RequirementTracking,
PurchaseRequisitionItem,
EvaldRcptSettlmtIsAllowed,
UnlimitedOverdeliveryIsAllowed,
OverdelivTolrtdLmtRatioInPct,
UnderdelivTolrtdLmtRatioInPct,
RequisitionerName,
PlannedDeliveryDurationInDays,
GoodsReceiptDurationInDays,
PartialDeliveryIsAllowed,
ConsumptionPosting,
ServicePerformer,
BaseUnit,
PurchaseOrderItemCategory,
ProfitCenter,
OrderPriceUnit,
@Semantics.unitOfMeasure: true
ItemVolumeUnit,
@Semantics.unitOfMeasure: true
ItemWeightUnit,
MultipleAcctAssgmtDistribution,
PartialInvoiceDistribution,
PricingDateControl,
IsStatisticalItem,
PurchasingParentItem,
GoodsReceiptLatestCreationDate,
IsReturnsItem,
PurchasingOrderReason,
IncotermsClassification,
IncotermsTransferLocation,
IncotermsLocation1,
IncotermsLocation2,
PriorSupplier,
InternationalArticleNumber,
IntrastatServiceCode,
CommodityCode,
MaterialFreightGroup,
DiscountInKindEligibility,
PurgItemIsBlockedForDelivery,
//ConfirmationControl,
SupplierConfirmationControlKey,
PriceIsToBePrinted,
AccountAssignmentCategory,
PurchasingInfoRecord,
@Semantics.amount.currencyCode: 'DocumentCurrency'
NetAmount,
@Semantics.amount.currencyCode: 'DocumentCurrency'
GrossAmount,
@Semantics.amount.currencyCode: 'DocumentCurrency'
EffectiveAmount,
@Semantics.amount.currencyCode: 'DocumentCurrency'
Subtotal1Amount,
@Semantics.amount.currencyCode: 'DocumentCurrency'
Subtotal2Amount,
@Semantics.amount.currencyCode: 'DocumentCurrency'
Subtotal3Amount,
@Semantics.amount.currencyCode: 'DocumentCurrency'
Subtotal4Amount,
@Semantics.amount.currencyCode: 'DocumentCurrency'
Subtotal5Amount,
@Semantics.amount.currencyCode: 'DocumentCurrency'
Subtotal6Amount,
@Semantics.quantity.unitOfMeasure: 'PurchaseOrderQuantityUnit'
OrderQuantity,
@Semantics.amount.currencyCode: 'DocumentCurrency'
NetPriceAmount,
@Semantics.quantity.unitOfMeasure: 'ItemVolumeUnit'
ItemVolume,
@Semantics.quantity.unitOfMeasure: 'ItemWeightUnit'
ItemGrossWeight,
@Semantics.quantity.unitOfMeasure: 'ItemWeightUnit'
ItemNetWeight,
OrderPriceUnitToOrderUnitNmrtr,
OrdPriceUnitToOrderUnitDnmntr,
GoodsReceiptIsNonValuated,
TaxCode,
TaxJurisdiction,
ShippingInstruction,
ShippingType,
@Semantics.amount.currencyCode: 'DocumentCurrency'
NonDeductibleInputTaxAmount,
StockType,
ValuationType,
ValuationCategory,
ItemIsRejectedBySupplier,
PurgDocPriceDate,
@Semantics.quantity.unitOfMeasure: 'PurchaseOrderQuantityUnit'
PurgDocReleaseOrderQuantity,
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'EarmarkedFundsDocument'
EarmarkedFunds,
EarmarkedFundsDocument,
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'EarmarkedFundsDocumentItem'
EarmarkedFundsItem,
EarmarkedFundsDocumentItem,
PartnerReportedBusinessArea,
InventorySpecialStockType,
DeliveryDocumentType,
IssuingStorageLocation,
AllocationTable,
AllocationTableItem,
RetailPromotion,
// Down Payment
DownPaymentType,
DownPaymentPercentageOfTotAmt,
@Semantics.amount.currencyCode: 'DocumentCurrency'
DownPaymentAmount,
DownPaymentDueDate,
// S/4 Limit
@Semantics.amount.currencyCode: 'DocumentCurrency'
ExpectedOverallLimitAmount,
@Semantics.amount.currencyCode: 'DocumentCurrency'
OverallLimitAmount,
RequirementSegment,
PurgProdCmplncDngrsGoodsStatus,
PurgProdCmplncSupplierStatus,
PurgProductMarketabilityStatus,
PurgSafetyDataSheetStatus,
SubcontrgCompIsRealTmeCnsmd,
// Brazil Extension
BR_MaterialOrigin,
BR_MaterialUsage,
BR_CFOPCategory,
BR_NCM,
BR_IsProducedInHouse,
_PurchaseOrder,
_PurOrdScheduleLine,
_PurOrdAcctAssignment
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"R_PURCHASEORDERITEM"
],
"ASSOCIATED":
[
"E_PURCHASINGDOCUMENTITEM",
"I_PURCHASEORDERAPI01",
"I_PURORDACCOUNTASSIGNMENTAPI01",
"I_PURORDSCHEDULELINEAPI01"
],
"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