I_PurchaseOrderItemAPI01

DDL: I_PURCHASEORDERITEMAPI01 SQL: IMMPOITEMAPI01 Type: view BASIC

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)

SourceAliasJoin Type
R_PurchaseOrderItem R_PurchaseOrderItem from

Associations (4)

CardinalityTargetAliasCondition
[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)

NameValueLevelField
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)

KeyFieldSource TableSource FieldDescription
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":""
}
}*/