P_PurchaseOrderItem
Puchaser Order Item for change document
P_PurchaseOrderItem is a Consumption CDS View that provides data about "Puchaser Order Item for change document" in SAP S/4HANA. It reads from 1 data source (I_PurchaseOrderItem) and exposes 80 fields with key fields PurchaseOrder, PurchaseOrderItem. Part of development package ODATA_MM_ANALYTICS.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_PurchaseOrderItem | I_PurchaseOrderItem | from |
Annotations (10)
| Name | Value | Level | Field |
|---|---|---|---|
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| AbapCatalog.sqlViewName | PPOITEM | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| VDM.private | true | view | |
| AccessControl.authorizationCheck | #NOT_REQUIRED | view | |
| VDM.viewType | #CONSUMPTION | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ObjectModel.usageType.serviceQuality | #A | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| AccessControl.personalData.blocking | #NOT_REQUIRED | view |
Fields (80)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | PurchaseOrder | PurchaseOrder | ||
| KEY | PurchaseOrderItem | PurchaseOrderItem | ||
| SAPClinet | ||||
| PurchaseOrderItemKey | ||||
| PurchaseOrderCategory | PurchaseOrderCategory | |||
| DocumentCurrency | DocumentCurrency | |||
| PurchasingDocumentDeletionCode | PurchasingDocumentDeletionCode | |||
| MaterialGroup | MaterialGroup | |||
| Material | Material | |||
| SupplierMaterialNumber | SupplierMaterialNumber | |||
| ManufacturerPartNmbr | ManufacturerPartNmbr | |||
| ManufacturerMaterial | ManufacturerMaterial | |||
| PurchaseOrderItemText | PurchaseOrderItemText | |||
| ProductType | ProductType | |||
| CompanyCode | CompanyCode | |||
| Plant | Plant | |||
| ManualDeliveryAddressID | ManualDeliveryAddressID | |||
| ReferenceDeliveryAddressID | ReferenceDeliveryAddressID | |||
| Customer | Customer | |||
| 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 | |||
| PurchaseRequisitionItem | PurchaseRequisitionItem | |||
| EvaldRcptSettlmtIsAllowed | EvaldRcptSettlmtIsAllowed | |||
| UnlimitedOverdeliveryIsAllowed | UnlimitedOverdeliveryIsAllowed | |||
| OverdelivTolrtdLmtRatioInPct | OverdelivTolrtdLmtRatioInPct | |||
| UnderdelivTolrtdLmtRatioInPct | UnderdelivTolrtdLmtRatioInPct | |||
| RequisitionerName | RequisitionerName | |||
| ServicePerformer | ServicePerformer | |||
| ServicePackage | ServicePackage | |||
| BaseUnit | BaseUnit | |||
| PurchaseOrderItemCategory | PurchaseOrderItemCategory | |||
| ProfitCenter | ProfitCenter | |||
| OrderPriceUnit | OrderPriceUnit | |||
| ItemVolumeUnit | ItemVolumeUnit | |||
| ItemWeightUnit | ItemWeightUnit | |||
| MultipleAcctAssgmtDistribution | MultipleAcctAssgmtDistribution | |||
| PartialInvoiceDistribution | PartialInvoiceDistribution | |||
| PricingDateControl | PricingDateControl | |||
| IsStatisticalItem | IsStatisticalItem | |||
| IsReturnsItem | IsReturnsItem | |||
| IncotermsClassification | IncotermsClassification | |||
| IncotermsTransferLocation | IncotermsTransferLocation | |||
| IncotermsLocation1 | IncotermsLocation1 | |||
| IncotermsLocation2 | IncotermsLocation2 | |||
| InternationalArticleNumber | InternationalArticleNumber | |||
| ConfirmationControl | SupplierConfirmationControlKey | |||
| PriceIsToBePrinted | PriceIsToBePrinted | |||
| AccountAssignmentCategory | AccountAssignmentCategory | |||
| PurchasingInfoRecord | PurchasingInfoRecord | |||
| NetAmount | NetAmount | |||
| EffectiveAmount | EffectiveAmount | |||
| OrderQuantity | OrderQuantity | |||
| NetPriceAmount | NetPriceAmount | |||
| ItemVolume | ItemVolume | |||
| ItemNetWeight | ItemNetWeight | |||
| OrderPriceUnitToOrderUnitNmrtr | OrderPriceUnitToOrderUnitNmrtr | |||
| OrdPriceUnitToOrderUnitDnmntr | OrdPriceUnitToOrderUnitDnmntr | |||
| GoodsReceiptIsNonValuated | GoodsReceiptIsNonValuated | |||
| TaxCode | TaxCode | |||
| ValuationType | ValuationType | |||
| EarmarkedFunds | EarmarkedFunds | |||
| EarmarkedFundsItem | EarmarkedFundsItem | |||
| _Material | _Material | |||
| _MaterialGroup | _MaterialGroup | |||
| _Plant | _Plant | |||
| _PurchaseOrder | _PurchaseOrder | |||
| _PurchaseOrderItemCalcFields | _PurchaseOrderItemCalcFields | |||
| _PurchaseOrderPricingElement | _PurchaseOrderPricingElement | |||
| _PurgDocumentItemCategory | _PurgDocumentItemCategory |
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'PPOITEM'
@AbapCatalog.compiler.compareFilter: true
@VDM.private : true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
@AccessControl.personalData.blocking: #NOT_REQUIRED
define view P_PurchaseOrderItem as select from I_PurchaseOrderItem {
key PurchaseOrder,
key PurchaseOrderItem,
$session.client as SAPClinet,
Concat(PurchaseOrder, PurchaseOrderItem) as PurchaseOrderItemKey,
PurchaseOrderCategory,
DocumentCurrency,
PurchasingDocumentDeletionCode,
MaterialGroup,
Material,
SupplierMaterialNumber,
ManufacturerPartNmbr,
ManufacturerMaterial,
PurchaseOrderItemText,
ProductType,
CompanyCode,
Plant,
ManualDeliveryAddressID,
ReferenceDeliveryAddressID,
Customer,
StorageLocation,
PurchaseOrderQuantityUnit,
OrderItemQtyToBaseQtyNmrtr,
OrderItemQtyToBaseQtyDnmntr,
NetPriceQuantity,
IsCompletelyDelivered,
IsFinallyInvoiced,
GoodsReceiptIsExpected,
InvoiceIsExpected,
InvoiceIsGoodsReceiptBased,
PurchaseContractItem,
PurchaseContract,
PurchaseRequisition,
PurchaseRequisitionItem,
EvaldRcptSettlmtIsAllowed,
UnlimitedOverdeliveryIsAllowed,
OverdelivTolrtdLmtRatioInPct,
UnderdelivTolrtdLmtRatioInPct,
RequisitionerName,
ServicePerformer,
ServicePackage,
BaseUnit,
PurchaseOrderItemCategory,
ProfitCenter,
OrderPriceUnit,
ItemVolumeUnit,
ItemWeightUnit,
MultipleAcctAssgmtDistribution,
PartialInvoiceDistribution,
PricingDateControl,
IsStatisticalItem,
IsReturnsItem,
IncotermsClassification,
IncotermsTransferLocation,
IncotermsLocation1,
IncotermsLocation2,
InternationalArticleNumber,
SupplierConfirmationControlKey as ConfirmationControl,
PriceIsToBePrinted,
AccountAssignmentCategory,
PurchasingInfoRecord,
NetAmount,
EffectiveAmount,
OrderQuantity,
NetPriceAmount,
ItemVolume,
ItemNetWeight,
OrderPriceUnitToOrderUnitNmrtr,
OrdPriceUnitToOrderUnitDnmntr,
GoodsReceiptIsNonValuated,
TaxCode,
ValuationType,
EarmarkedFunds,
EarmarkedFundsItem,
/* Associations */
_Material,
_MaterialGroup,
_Plant,
_PurchaseOrder,
_PurchaseOrderItemCalcFields,
_PurchaseOrderPricingElement,
_PurgDocumentItemCategory
}
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