P_PurOrdItm

DDL: P_PURORDITM SQL: PPURORDITM Type: view CONSUMPTION Package: ODATA_MM_PUR_MYPURGDOCITEMS
77 Fields 1 Data Sources 2 Associations

Purchase Order Item Details

P_PurOrdItm is a Consumption CDS View that provides data about "Purchase Order Item Details" in SAP S/4HANA. It reads from 1 data source (P_PurOrderItemCalculation) and exposes 77 fields with key fields PurchaseOrder, PurchaseOrderItem, AccountAssignmentNumber, PurgDocMigrtnIsCmpltdForAnlyts. It has 2 associations to related views. Part of development package ODATA_MM_PUR_MYPURGDOCITEMS.

Data Sources (1)

SourceAliasJoin Type
P_PurOrderItemCalculation PurchaseOrderItem from

Associations (2)

CardinalityTargetAliasCondition
[1..1] C_PurchasingDocStatus _PurchaseOrderItmStatus $projection.PurchaseOrder = _PurchaseOrderItmStatus.PurchaseOrder
[0..*] P_PurOrdItmAccountAssignment _PurOrdAccountAssignment $projection.PurchaseOrder = _PurOrdAccountAssignment.PurchaseOrder and $projection.PurchaseOrderItem = _PurOrdAccountAssignment.PurchaseOrderItem

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName PPURORDITM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Purchase Order Item Details view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
VDM.private true view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view

Fields (77)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder PurchaseOrder Purchasing Document
KEY PurchaseOrderItem PurchaseOrderItem Purchasing Document Item
KEY AccountAssignmentNumber _PurOrdAccountAssignment AccountAssignmentNumber Account Assgmt No.
KEY PurgDocMigrtnIsCmpltdForAnlyts PurgDocMigrtnIsCmpltdForAnlyts
PurchaseOrderItemUniqueID PurchaseOrderItemUniqueID Document Item
FormattedPurchaseOrderItem FormattedPurchaseOrderItem
PurchaseOrderItemText PurchaseOrderItemText Short Text
AccountAssignmentCategory AccountAssignmentCategory Acct Assgmt Cat
MaterialGroup MaterialGroup Product Group
Material Material Vehicle Model
CompanyCode CompanyCode Receiver Company Code
CompanyCodeName CompanyCodeName Company Name
Plant Plant Valuation Area
StorageLocation StorageLocation StorageLocation
StorageLocationName StorageLocationName Storage Loc. Name
ServicePerformer ServicePerformer Service Performer
ProductType ProductType Product Type Group
IsReturnsItem IsReturnsItem Returns Item
ObjectType ObjectType Type
OrderQuantity OrderQuantity Quantity
NetPriceAmount NetPriceAmount Net Price
NetPriceQuantity NetPriceQuantity Price Unit
NetAmountInCoCodeCurrency NetAmountInCoCodeCurrency
OrderPriceUnit OrderPriceUnit Order Price Un.
PurchaseOrderQuantityUnit PurchaseOrderQuantityUnit Order Unit
PurchaseOrderItemCategory PurchaseOrderItemCategory Item Category
DocumentCurrency DocumentCurrency Document Currency
CompanyCodeCurrency CompanyCodeCurrency Local Currency
WorkItem WorkItem Work Item ID
GoodsReceiptIsExpected GoodsReceiptIsExpected Goods Receipt
IsCompletelyDelivered IsCompletelyDelivered Is completely delivered
InvoiceIsExpected InvoiceIsExpected Invoice Receipt
IsFinallyInvoiced IsFinallyInvoiced Final Invoice
MultipleAcctAssgmtDistribution MultipleAcctAssgmtDistribution Distribution
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingGroup PurchasingGroup Purchasing Group
PurchasingGroupName PurchasingGroupName Purchasing Grp. Name
SupplyingPlant SupplyingPlant Supplying Plant
Supplier Supplier Supplier
SupplierName SupplierName Supplier Name
PurchaseOrderDate PurchaseOrderDate PO Date
PurchasingDocumentType PurchasingDocumentType RFQ Type
CreationDate CreationDate Time Stamp
NetAmount NetAmount Stated Amount
GoodsReceiptQuantity GoodsReceiptQuantity Delivered
GoodsReceiptAmount GoodsReceiptAmount
StillToBeDeliveredQuantity StillToBeDeliveredQuantity
StillToBeDeliveredValue StillToBeDeliveredValue
InvoiceReceiptQty InvoiceReceiptQty
InvoiceRcptAmtInCoCodeCrcy InvoiceRcptAmtInCoCodeCrcy
StillToInvoiceQuantity StillToInvoiceQuantity
StillToInvoiceValue StillToInvoiceValue
DeliveryDate DeliveryDate Delivery Date
ScheduleLineOpenQty ScheduleLineOpenQty
PurchaseOrderType PurchaseOrderType PO Type
Status _PurchaseOrderItmStatus PurchasingDocumentStatus Short Description
PurchasingDocumentStatusName _PurchaseOrderItmStatus PurchasingDocumentStatusName
PurgDocExternalItemCategory PurgDocExternalItemCategory Item Category
CreatedByUser CreatedByUser User Name
PlantName PlantName Plant Name
SupplyingPlantName SupplyingPlantName Plant Name
PurgDocItemCategoryName PurgDocItemCategoryName Text for ItCat.
PurchasingDocumentTypeName PurchasingDocumentTypeName Description
IsBusinessPurposeCompleted IsBusinessPurposeCompleted Purpose Completed
CostCenter _PurOrdAccountAssignment CostCenter Cost Center
CostCenterName _PurOrdAccountAssignment CostCenterName Name
SalesOrder _PurOrdAccountAssignment SalesOrder SD Document
SalesOrderItem _PurOrdAccountAssignment SalesOrderItem Sales Order Item
WBSElementExternalID _PurOrdAccountAssignment WBSElementExternalID WBS Element External ID
WBSElementObject _PurOrdAccountAssignment WBSElementObject Object number
Quantity _PurOrdAccountAssignment Quantity Value
MultipleAcctAssgmtDistrPercent _PurOrdAccountAssignment MultipleAcctAssgmtDistrPercent Distribution
PurgDocNetAmount _PurOrdAccountAssignment PurgDocNetAmount Net Value
_PurchaseOrderItmStatus _PurchaseOrderItmStatus
_PurchaseOrder _PurchaseOrder
_ProductType _ProductType
_PurOrdAccountAssignment _PurOrdAccountAssignment

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 P_PurOrdItm.
-- 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.
-- SQL view name: PPURORDITM

CREATE VIEW P_PurOrdItm AS
SELECT
  PurchaseOrder,
  PurchaseOrderItem,
  _PurOrdAccountAssignment.AccountAssignmentNumber AS AccountAssignmentNumber,
  PurgDocMigrtnIsCmpltdForAnlyts,
  PurchaseOrderItemUniqueID,
  FormattedPurchaseOrderItem,
  PurchaseOrderItemText,
  AccountAssignmentCategory,
  MaterialGroup,
  Material,
  CompanyCode,
  CompanyCodeName,
  Plant,
  StorageLocation,
  StorageLocationName,
  ServicePerformer,
  ProductType,
  IsReturnsItem,
  ObjectType,
  OrderQuantity,
  NetPriceAmount,
  NetPriceQuantity,
  NetAmountInCoCodeCurrency,
  OrderPriceUnit,
  PurchaseOrderQuantityUnit,
  PurchaseOrderItemCategory,
  DocumentCurrency,
  CompanyCodeCurrency,
  WorkItem,
  GoodsReceiptIsExpected,
  IsCompletelyDelivered,
  InvoiceIsExpected,
  IsFinallyInvoiced,
  MultipleAcctAssgmtDistribution,
  PurchasingOrganization,
  PurchasingGroup,
  PurchasingGroupName,
  SupplyingPlant,
  Supplier,
  SupplierName,
  PurchaseOrderDate,
  PurchasingDocumentType,
  CreationDate,
  NetAmount,
  GoodsReceiptQuantity,
  GoodsReceiptAmount,
  StillToBeDeliveredQuantity,
  StillToBeDeliveredValue,
  InvoiceReceiptQty,
  InvoiceRcptAmtInCoCodeCrcy,
  StillToInvoiceQuantity,
  StillToInvoiceValue,
  DeliveryDate,
  ScheduleLineOpenQty,
  PurchaseOrderType,
  _PurchaseOrderItmStatus.PurchasingDocumentStatus AS Status,
  _PurchaseOrderItmStatus.PurchasingDocumentStatusName AS PurchasingDocumentStatusName,
  PurgDocExternalItemCategory,
  CreatedByUser,
  PlantName,
  SupplyingPlantName,
  PurgDocItemCategoryName,
  PurchasingDocumentTypeName,
  IsBusinessPurposeCompleted,
  _PurOrdAccountAssignment.CostCenter AS CostCenter,
  _PurOrdAccountAssignment.CostCenterName AS CostCenterName,
  _PurOrdAccountAssignment.SalesOrder AS SalesOrder,
  _PurOrdAccountAssignment.SalesOrderItem AS SalesOrderItem,
  _PurOrdAccountAssignment.WBSElementExternalID AS WBSElementExternalID,
  _PurOrdAccountAssignment.WBSElementObject AS WBSElementObject,
  _PurOrdAccountAssignment.Quantity AS Quantity,
  _PurOrdAccountAssignment.MultipleAcctAssgmtDistrPercent AS MultipleAcctAssgmtDistrPercent,
  _PurOrdAccountAssignment.PurgDocNetAmount AS PurgDocNetAmount
FROM P_PurOrderItemCalculation AS PurchaseOrderItem
LEFT OUTER JOIN C_PurchasingDocStatus AS _PurchaseOrderItmStatus ON PurchaseOrder = _PurchaseOrderItmStatus.PurchaseOrder  -- association [1..1]
LEFT OUTER JOIN P_PurOrdItmAccountAssignment AS _PurOrdAccountAssignment ON PurchaseOrder = _PurOrdAccountAssignment.PurchaseOrder AND PurchaseOrderItem = _PurOrdAccountAssignment.PurchaseOrderItem  -- association [0..*]
;

Learn More