A_PurchaseOrderItem_2

DDL: A_PURCHASEORDERITEM_2 Type: view_entity CONSUMPTION Package: ODATA_MM_PUR_PO_API_2
166 Fields 1 Data Sources 1 OData Services

Purchase Order Item

A_PurchaseOrderItem_2 is a Consumption CDS View that provides data about "Purchase Order Item" in SAP S/4HANA. It reads from 1 data source (R_PurchaseOrderItemTP) and exposes 166 fields with key fields PurchaseOrder, PurchaseOrderItem. It is exposed through 1 OData service (API_PURCHASEORDER_2). Part of development package ODATA_MM_PUR_PO_API_2.

Data Sources (1)

SourceAliasJoin Type
R_PurchaseOrderItemTP R_PurchaseOrderItemTP projection

Annotations (10)

NameValueLevelField
EndUserText.label Purchase Order Item view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view
OData.entityType.name PurchaseOrderItem_Type view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
VDM.viewType #CONSUMPTION view

OData Services (1)

ServiceBindingVersionContractRelease
API_PURCHASEORDER_2 API_PURCHASEORDER_2 V4 C2 C1

Fields (166)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder PurchaseOrder Purchasing Document
KEY PurchaseOrderItem PurchaseOrderItem Purchasing Document Item
PurchaseOrderCategory PurchaseOrderCategory Doc. Category
DocumentCurrency DocumentCurrency Document Currency
PurchasingDocumentDeletionCode PurchasingDocumentDeletionCode Del. Indicator
MaterialGroup MaterialGroup Product Group
Material Material Vehicle Model
MaterialType MaterialType Material Type
SupplierMaterialNumber SupplierMaterialNumber Supp. Mat. No.
SupplierSubrange SupplierSubrange Suppl. Subrange
ManufacturerPartNmbr ManufacturerPartNmbr Mfr Part Number
Manufacturer Manufacturer Manufacturer
ManufacturerMaterial ManufacturerMaterial MPN: Material
PurchaseOrderItemText PurchaseOrderItemText Short Text
ProductTypeCode ProductTypeCode Product Type Group
CompanyCode CompanyCode Receiver Company Code
Plant Plant Valuation Area
ManualDeliveryAddressID ManualDeliveryAddressID Address Number
ReferenceDeliveryAddressID ReferenceDeliveryAddressID Reference Address
Customer Customer Sold-to Party
Subcontractor Subcontractor Supplier
SupplierIsSubcontractor SupplierIsSubcontractor SC Supplier
CrossPlantConfigurableProduct CrossPlantConfigurableProduct Cross-plant CP
ArticleCategory ArticleCategory Prod Category
PlndOrderReplnmtElmntType PlndOrderReplnmtElmntType Kanban Indicat.
ProductPurchasePointsQtyUnit ProductPurchasePointsQtyUnit Points Unit
ProductPurchasePointsQty ProductPurchasePointsQty Points
StorageLocation StorageLocation StorageLocation
PurchaseOrderQuantityUnit PurchaseOrderQuantityUnit Order Unit
OrderItemQtyToBaseQtyNmrtr OrderItemQtyToBaseQtyNmrtr Equal To
OrderItemQtyToBaseQtyDnmntr OrderItemQtyToBaseQtyDnmntr Denominator
NetPriceQuantity NetPriceQuantity Price Unit
IsCompletelyDelivered IsCompletelyDelivered Is completely delivered
IsFinallyInvoiced IsFinallyInvoiced Final Invoice
GoodsReceiptIsExpected GoodsReceiptIsExpected Goods Receipt
InvoiceIsExpected InvoiceIsExpected Invoice Receipt
IsOrderAcknRqd IsOrderAcknRqd Acknowl. Reqd.
InvoiceIsGoodsReceiptBased InvoiceIsGoodsReceiptBased GR-Based IV
PurchaseContract PurchaseContract Purchasing Doc.
PurchaseContractItem PurchaseContractItem Item
PurchaseRequisition PurchaseRequisition Requisition
PurchaseRequisitionItem PurchaseRequisitionItem Requisn. item
RequirementTracking RequirementTracking Tracking Number
SupplierQuotation SupplierQuotation RFQ
SupplierQuotationItem SupplierQuotationItem Supplier Quotation Item
EvaldRcptSettlmtIsAllowed EvaldRcptSettlmtIsAllowed ERS
UnlimitedOverdeliveryIsAllowed UnlimitedOverdeliveryIsAllowed Unlimited Tol.
OverdelivTolrtdLmtRatioInPct OverdelivTolrtdLmtRatioInPct Overdeliv. Tol.
UnderdelivTolrtdLmtRatioInPct UnderdelivTolrtdLmtRatioInPct Underdel. Tol.
RequisitionerName RequisitionerName Requisitioner
PlannedDeliveryDurationInDays PlannedDeliveryDurationInDays Plnd dely time
GoodsReceiptDurationInDays GoodsReceiptDurationInDays GR proc. time
PartialDeliveryIsAllowed PartialDeliveryIsAllowed Partial Deliv.
ConsumptionPosting ConsumptionPosting Consumption Posting
ServicePerformer ServicePerformer Service Performer
ServicePackage ServicePackage Package number
BaseUnit BaseUnit Unit of Measure
PurchaseOrderItemCategory PurchaseOrderItemCategory Item Category
ProfitCenter ProfitCenter Profit Center
OrderPriceUnit OrderPriceUnit Order Price Un.
ItemVolumeUnit ItemVolumeUnit Volume Unit
ItemWeightUnit ItemWeightUnit Unit of Weight
MultipleAcctAssgmtDistribution MultipleAcctAssgmtDistribution Distribution
PartialInvoiceDistribution PartialInvoiceDistribution Partial invoice
PricingDateControl PricingDateControl Pr. Date Cat.
IsStatisticalItem IsStatisticalItem Statisticl.Indicator
PurchasingParentItem PurchasingParentItem Parent Item No
GoodsReceiptLatestCreationDate GoodsReceiptLatestCreationDate Latest GR Date
IsReturnsItem IsReturnsItem Returns Item
PurchasingOrderReason PurchasingOrderReason Reason for Ord.
IncotermsClassification IncotermsClassification Incoterms
IncotermsTransferLocation IncotermsTransferLocation Incoterms 2
IncotermsLocation1 IncotermsLocation1 Inco. Location1
IncotermsLocation2 IncotermsLocation2 Inco. Location2
PriorSupplier PriorSupplier Prior Supplier
InternationalArticleNumber InternationalArticleNumber EAN/UPC
IntrastatServiceCode IntrastatServiceCode Intrastat Srvc. Code
CommodityCode CommodityCode Commodity Code
MaterialFreightGroup MaterialFreightGroup Mat.Freight Grp
DiscountInKindEligibility DiscountInKindEligibility Disc. in kind
PurgItemIsBlockedForDelivery PurgItemIsBlockedForDelivery Shipping block
SupplierConfirmationControlKey SupplierConfirmationControlKey Conf. Control
PurgDocOrderAcknNumber PurgDocOrderAcknNumber Order Acknowl.
PriceIsToBePrinted PriceIsToBePrinted Print Price
AccountAssignmentCategory AccountAssignmentCategory Acct Assgmt Cat
PurchasingInfoRecord PurchasingInfoRecord Info Record
NetAmount NetAmount Stated Amount
GrossAmount GrossAmount Gross value
EffectiveAmount EffectiveAmount Effective value
Subtotal1Amount Subtotal1Amount Subtotal 1 Amount
Subtotal2Amount Subtotal2Amount Subtotal 2 Amount
Subtotal3Amount Subtotal3Amount Subtotal 3 Amount
Subtotal4Amount Subtotal4Amount Subtotal 4 Amount
Subtotal5Amount Subtotal5Amount Subtotal 5 Amount
Subtotal6Amount Subtotal6Amount Subtotal 6 Amount
OrderQuantity OrderQuantity Quantity
NetPriceAmount NetPriceAmount Net Price
ItemVolume ItemVolume Volume
ItemGrossWeight ItemGrossWeight Gross Weight
ItemNetWeight ItemNetWeight Net Weight
OrderPriceUnitToOrderUnitNmrtr OrderPriceUnitToOrderUnitNmrtr Quantity Conversion Numerator
OrdPriceUnitToOrderUnitDnmntr OrdPriceUnitToOrderUnitDnmntr Quantity Conversion Denominator
GoodsReceiptIsNonValuated GoodsReceiptIsNonValuated GR Non-Valuated
IsToBeAcceptedAtOrigin IsToBeAcceptedAtOrigin Origin Accept.
TaxCode TaxCode Tax Code
TaxJurisdiction TaxJurisdiction Tax Jurisdiction
TaxCountry TaxCountry Tax Ctry/Reg.
TaxDeterminationDate TaxDeterminationDate Tx Determination Dte
ShippingInstruction ShippingInstruction Shipping Instr.
MaterialRevisionLevel MaterialRevisionLevel Revision Level
NonDeductibleInputTaxAmount NonDeductibleInputTaxAmount Non-deductible
StockType StockType Stock Type
ValuationType ValuationType Valuation Type
ValuationCategory ValuationCategory Valuation Cat.
ItemIsRejectedBySupplier ItemIsRejectedBySupplier Rejection Ind.
PurgDocPriceDate PurgDocPriceDate Price Date
PurchasingInfoRecordUpdateCode PurchasingInfoRecordUpdateCode InfoUpdate
PurchasingPriceIsEstimated PurchasingPriceIsEstimated Estimated Price
InvoiceIsMMServiceEntryBased InvoiceIsMMServiceEntryBased Srv.-Based Inv. Ver.
InventorySpecialStockType InventorySpecialStockType Special Stock Type
DeliveryDocumentType DeliveryDocumentType Delivery Type
IssuingStorageLocation IssuingStorageLocation Iss. Stor. Loc.
AllocationTable AllocationTable Alloc. Table
AllocationTableItem AllocationTableItem Item
RetailPromotion RetailPromotion Promotion
PurgConfigurableItemNumber PurgConfigurableItemNumber Hierarchy Number
PurgDocAggrgdSubitemCategory PurgDocAggrgdSubitemCategory Sub-items
PurgExternalSortNumber PurgExternalSortNumber External Sort No.
Batch Batch Lot No.
PurchasingItemIsFreeOfCharge PurchasingItemIsFreeOfCharge Free of Charge
DownPaymentType DownPaymentType Down Payment
DownPaymentPercentageOfTotAmt DownPaymentPercentageOfTotAmt Down Payment %
DownPaymentAmount DownPaymentAmount Downpayment
DownPaymentDueDate DownPaymentDueDate Due Date for DP
ExpectedOverallLimitAmount ExpectedOverallLimitAmount Expected Value
OverallLimitAmount OverallLimitAmount Overall Limit
PurContractForOverallLimit PurContractForOverallLimit Contract For Limit
PurContractItemForOverallLimit PurContractItemForOverallLimit PurCon Itm for Limit
PurgProdCmplncSupplierStatus PurgProdCmplncSupplierStatus Supplier Check Sts
PurgProductMarketabilityStatus PurgProductMarketabilityStatus Prod. Marktablty Sts
PurgSafetyDataSheetStatus PurgSafetyDataSheetStatus Sfty Data Sheet Sts
PurgProdCmplncDngrsGoodsStatus PurgProdCmplncDngrsGoodsStatus Dangerous Goods Sts
BR_MaterialOrigin BR_MaterialOrigin Material Origin
BR_MaterialUsage BR_MaterialUsage Material Usage
BR_CFOPCategory BR_CFOPCategory Mat. category
BR_NCM BR_NCM NCM Code
ConsumptionTaxCtrlCode ConsumptionTaxCtrlCode Taxes F.Trade
BR_IsProducedInHouse BR_IsProducedInHouse Prod. in-house
ProductSeasonYear ProductSeasonYear Season Year
ProductSeason ProductSeason Season
ProductCollection ProductCollection Collection
ProductTheme ProductTheme Theme
SeasonCompletenessStatus SeasonCompletenessStatus Season Comp.Ind
ShippingGroupRule ShippingGroupRule PSST Grouping Rule
ShippingGroupNumber ShippingGroupNumber PSST Group
ProductCharacteristic1 ProductCharacteristic1 Characteristic 1
ProductCharacteristic2 ProductCharacteristic2 Characteristic 2
ProductCharacteristic3 ProductCharacteristic3 Characteristic 3
PurgDocSubitemCategory PurgDocSubitemCategory Subitem Cat.
DiversionStatus DiversionStatus Diversion Status
ReferenceDocumentNumber ReferenceDocumentNumber
ReferenceDocumentItem ReferenceDocumentItem Reference item
PurchaseOrderReferenceType PurchaseOrderReferenceType Reference Action
ItemHasValueAddedService ItemHasValueAddedService VAS Relevant
ValAddedSrvcParentItmNumber ValAddedSrvcParentItmNumber Item
StockSegment StockSegment Stock Segment

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view A_PurchaseOrderItem_2.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW A_PurchaseOrderItem_2 AS
SELECT
  PurchaseOrder,
  PurchaseOrderItem,
  PurchaseOrderCategory,
  DocumentCurrency,
  PurchasingDocumentDeletionCode,
  MaterialGroup,
  Material,
  MaterialType,
  SupplierMaterialNumber,
  SupplierSubrange,
  ManufacturerPartNmbr,
  Manufacturer,
  ManufacturerMaterial,
  PurchaseOrderItemText,
  ProductTypeCode,
  CompanyCode,
  Plant,
  ManualDeliveryAddressID,
  ReferenceDeliveryAddressID,
  Customer,
  Subcontractor,
  SupplierIsSubcontractor,
  CrossPlantConfigurableProduct,
  ArticleCategory,
  PlndOrderReplnmtElmntType,
  ProductPurchasePointsQtyUnit,
  ProductPurchasePointsQty,
  StorageLocation,
  PurchaseOrderQuantityUnit,
  OrderItemQtyToBaseQtyNmrtr,
  OrderItemQtyToBaseQtyDnmntr,
  NetPriceQuantity,
  IsCompletelyDelivered,
  IsFinallyInvoiced,
  GoodsReceiptIsExpected,
  InvoiceIsExpected,
  IsOrderAcknRqd,
  InvoiceIsGoodsReceiptBased,
  PurchaseContract,
  PurchaseContractItem,
  PurchaseRequisition,
  PurchaseRequisitionItem,
  RequirementTracking,
  SupplierQuotation,
  SupplierQuotationItem,
  EvaldRcptSettlmtIsAllowed,
  UnlimitedOverdeliveryIsAllowed,
  OverdelivTolrtdLmtRatioInPct,
  UnderdelivTolrtdLmtRatioInPct,
  RequisitionerName,
  PlannedDeliveryDurationInDays,
  GoodsReceiptDurationInDays,
  PartialDeliveryIsAllowed,
  ConsumptionPosting,
  ServicePerformer,
  ServicePackage,
  BaseUnit,
  PurchaseOrderItemCategory,
  ProfitCenter,
  OrderPriceUnit,
  ItemVolumeUnit,
  ItemWeightUnit,
  MultipleAcctAssgmtDistribution,
  PartialInvoiceDistribution,
  PricingDateControl,
  IsStatisticalItem,
  PurchasingParentItem,
  GoodsReceiptLatestCreationDate,
  IsReturnsItem,
  PurchasingOrderReason,
  IncotermsClassification,
  IncotermsTransferLocation,
  IncotermsLocation1,
  IncotermsLocation2,
  PriorSupplier,
  InternationalArticleNumber,
  IntrastatServiceCode,
  CommodityCode,
  MaterialFreightGroup,
  DiscountInKindEligibility,
  PurgItemIsBlockedForDelivery,
  SupplierConfirmationControlKey,
  PurgDocOrderAcknNumber,
  PriceIsToBePrinted,
  AccountAssignmentCategory,
  PurchasingInfoRecord,
  NetAmount,
  GrossAmount,
  EffectiveAmount,
  Subtotal1Amount,
  Subtotal2Amount,
  Subtotal3Amount,
  Subtotal4Amount,
  Subtotal5Amount,
  Subtotal6Amount,
  OrderQuantity,
  NetPriceAmount,
  ItemVolume,
  ItemGrossWeight,
  ItemNetWeight,
  OrderPriceUnitToOrderUnitNmrtr,
  OrdPriceUnitToOrderUnitDnmntr,
  GoodsReceiptIsNonValuated,
  IsToBeAcceptedAtOrigin,
  TaxCode,
  TaxJurisdiction,
  TaxCountry,
  TaxDeterminationDate,
  ShippingInstruction,
  MaterialRevisionLevel,
  NonDeductibleInputTaxAmount,
  StockType,
  ValuationType,
  ValuationCategory,
  ItemIsRejectedBySupplier,
  PurgDocPriceDate,
  PurchasingInfoRecordUpdateCode,
  PurchasingPriceIsEstimated,
  InvoiceIsMMServiceEntryBased,
  InventorySpecialStockType,
  DeliveryDocumentType,
  IssuingStorageLocation,
  AllocationTable,
  AllocationTableItem,
  RetailPromotion,
  PurgConfigurableItemNumber,
  PurgDocAggrgdSubitemCategory,
  PurgExternalSortNumber,
  Batch,
  PurchasingItemIsFreeOfCharge,
  DownPaymentType,
  DownPaymentPercentageOfTotAmt,
  DownPaymentAmount,
  DownPaymentDueDate,
  ExpectedOverallLimitAmount,
  OverallLimitAmount,
  PurContractForOverallLimit,
  PurContractItemForOverallLimit,
  PurgProdCmplncSupplierStatus,
  PurgProductMarketabilityStatus,
  PurgSafetyDataSheetStatus,
  PurgProdCmplncDngrsGoodsStatus,
  BR_MaterialOrigin,
  BR_MaterialUsage,
  BR_CFOPCategory,
  BR_NCM,
  ConsumptionTaxCtrlCode,
  BR_IsProducedInHouse,
  ProductSeasonYear,
  ProductSeason,
  ProductCollection,
  ProductTheme,
  SeasonCompletenessStatus,
  ShippingGroupRule,
  ShippingGroupNumber,
  ProductCharacteristic1,
  ProductCharacteristic2,
  ProductCharacteristic3,
  PurgDocSubitemCategory,
  DiversionStatus,
  ReferenceDocumentNumber,
  ReferenceDocumentItem,
  PurchaseOrderReferenceType,
  ItemHasValueAddedService,
  ValAddedSrvcParentItmNumber,
  StockSegment
FROM R_PurchaseOrderItemTP
;

Learn More