P_PurchaseOrderItem

DDL: P_PURCHASEORDERITEM SQL: PPOITEM Type: view CONSUMPTION

P_PurchaseOrderItem is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (I_PurchaseOrderItem) and exposes 80 fields with key fields PurchaseOrder, PurchaseOrderItem.

Data Sources (1)

SourceAliasJoin Type
I_PurchaseOrderItem I_PurchaseOrderItem from

Annotations (10)

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

KeyFieldSource TableSource FieldDescription
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
} 
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURCHASEORDERITEM"
],
"ASSOCIATED":
[
"I_MATERIAL",
"I_MATERIALGROUP",
"I_PLANT",
"I_PURCHASEORDER",
"I_PURCHASEORDERITEMCALCFIELDS",
"I_PURGDOCUMENTITEMCATEGORY",
"I_PURORDPRICINGELEMENT"
],
"BASE":
[
"I_PURCHASEORDERITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/