I_PurchaseOrderItemTP_2

DDL: I_PURCHASEORDERITEMTP_2 Type: view_entity TRANSACTIONAL Package: APPL_MM_PUR_PO_API
222 Fields 1 Data Sources

Purchase Order Item Projection

I_PurchaseOrderItemTP_2 is a Transactional CDS View that provides data about "Purchase Order Item Projection" in SAP S/4HANA. It reads from 1 data source (R_PurchaseOrderItemTP) and exposes 222 fields with key fields PurchaseOrder, PurchaseOrderItem. Part of development package APPL_MM_PUR_PO_API.

Data Sources (1)

SourceAliasJoin Type
R_PurchaseOrderItemTP R_PurchaseOrderItemTP projection

Annotations (11)

NameValueLevelField
EndUserText.label Purchase Order Item Projection view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.modelingPattern #TRANSACTIONAL_INTERFACE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.sapObjectNodeType.name PurchaseOrderItem view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #TRANSACTIONAL view

Fields (222)

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.
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
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
RefDocNmbrForTrcblyInPO RefDocNmbrForTrcblyInPO Reference Document
ReferenceDocumentItem ReferenceDocumentItem Reference item
PurchaseOrderReferenceType PurchaseOrderReferenceType Reference Action
ItemHasValueAddedService ItemHasValueAddedService VAS Relevant
ValAddedSrvcParentItmNumber ValAddedSrvcParentItmNumber Item
StockSegment StockSegment Stock Segment
_AllocationTable _AllocationTable
_AllocationTableItem _AllocationTableItem
_BR_CFOPCategory _BR_CFOPCategory
_BR_MaterialOrigin _BR_MaterialOrigin
_BR_MaterialUsage _BR_MaterialUsage
_BR_NCM _BR_NCM
_CompanyCode _CompanyCode
_ConfigurableProduct _ConfigurableProduct
_ConsumptionPosting _ConsumptionPosting
_Customer _Customer
_DocumentCurrency _DocumentCurrency
_IncotermsClassification _IncotermsClassification
_ManufacturerMaterial _ManufacturerMaterial
_Material _Material
_MaterialGroup _MaterialGroup
_OrderPriceUnit _OrderPriceUnit
_OrderQuantityUnit _OrderQuantityUnit
_Plant _Plant
_PriorSupplier _PriorSupplier
_PurchaseContract _PurchaseContract
_PurchaseContractItem _PurchaseContractItem
_PurchaseRequisition _PurchaseRequisition
_PurchaseRequisitionItem _PurchaseRequisitionItem
_PurchasingInfoRecord _PurchasingInfoRecord
_PurgDocumentCategory _PurgDocumentCategory
_PurgDocumentItemCategory _PurgDocumentItemCategory
_ReferenceDeliveryAddress _ReferenceDeliveryAddress
_RetailPromotion _RetailPromotion
_ServicePerformer _ServicePerformer
_StorageLocation _StorageLocation
_Subcontractor _Subcontractor
_PurgDocumentCategoryText _PurgDocumentCategoryText
_DocumentCurrencyText _DocumentCurrencyText
_ProductGroupText _ProductGroupText
_ProductText _ProductText
_ProductTypeText _ProductTypeText
_ManufacturerMaterialText _ManufacturerMaterialText
_ProductTypeCodeText _ProductTypeCodeText
_ArticleCategoryText _ArticleCategoryText
_OrderQuantityUnitText _OrderQuantityUnitText
_BaseUnitText _BaseUnitText
_PurgDocumentItemCategoryText _PurgDocumentItemCategoryText
_OrderPriceUnitText _OrderPriceUnitText
_ItemVolumeUnitText _ItemVolumeUnitText
_ItemWeightUnitText _ItemWeightUnitText
_AcctAssgmtDistrIndicatorText _AcctAssgmtDistrIndicatorText
_PricingDateControlText _PricingDateControlText
_IncotermsClassificationText _IncotermsClassificationText
_SupplierConfControlKeyText _SupplierConfControlKeyText
_AcctAssignmentCategoryText _AcctAssignmentCategoryText
_TaxCountryText _TaxCountryText
_ShippingInstructionText _ShippingInstructionText
_ValuationCategoryText _ValuationCategoryText
_PurgProdCmplncDngrsGoodsStsT _PurgProdCmplncDngrsGoodsStsT
_PurgProdCmplncSupplierStsT _PurgProdCmplncSupplierStsT
_PurgProductMarketabilityStsT _PurgProductMarketabilityStsT
_PurgSafetyDataSheetStatusT _PurgSafetyDataSheetStatusT

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 I_PurchaseOrderItemTP_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 I_PurchaseOrderItemTP_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,
  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,
  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,
  RefDocNmbrForTrcblyInPO,
  ReferenceDocumentItem,
  PurchaseOrderReferenceType,
  ItemHasValueAddedService,
  ValAddedSrvcParentItmNumber,
  StockSegment
FROM R_PurchaseOrderItemTP
;

Learn More