I_PPS_PURCHASEORDERITEM

CDS View

Interface for purchase order items

I_PPS_PURCHASEORDERITEM is a CDS View in S/4HANA. Interface for purchase order items. It contains 3 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 3 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PPS_PurReqnProcessFlow view_entity inner COMPOSITE Interface for PPS Process Flow

Fields (3)

KeyField CDS FieldsUsed in Views
KEY PurchaseOrder SubsequentDocument 1
KEY PurchaseOrderItem SubsequentDocumentItem 1
PurchaseOrderCategory SubsequentDocumentCategory 1 
@EndUserText.label: 'Interface for purchase order items'
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #MANDATORY
@ObjectModel.representativeKey: 'PurchaseOrderItem'
@ObjectModel.uniqueIdField: 'PurchaseOrderItemUniqueID'
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
//@JIRA-KEY S4PPS- 7110

//Incident ID 2380131799

define view entity I_PPS_PurchaseOrderItem
  as select from R_PurchasingDocumentItem

  association [1..1] to I_PPS_PurchaseOrder as _PurchaseOrder on $projection.PurchaseOrder = _PurchaseOrder.PurchaseOrder
  association [0..1] to I_Material          as _Material      on $projection.Material = _Material.Material

{
      //Key

      @ObjectModel.foreignKey.association: '_PurchaseOrder'
  key PurchasingDocument                                                     as PurchaseOrder,

  key cast (PurchasingDocumentItem as vdm_purchaseorderitem preserving type) as PurchaseOrderItem,
      PurchasingDocumentItemUniqueID                                         as PurchaseOrderItemUniqueID,

      @ObjectModel.foreignKey.association: '_PurgDocumentCategory'
      PurchasingDocumentCategory                                             as PurchaseOrderCategory,

      DocumentCurrency,

      PurchasingDocumentDeletionCode,

      //Product

      @ObjectModel.foreignKey.association: '_MaterialGroup'
      MaterialGroup,

      @ObjectModel.foreignKey.association: '_Material'
      Material,
      MaterialType,
      SupplierMaterialNumber,
      SupplierSubrange,
      ManufacturerPartNmbr,
      Manufacturer,

      @ObjectModel.foreignKey.association: '_ManufacturerMaterial'
      ManufacturerMaterial,

      PurchasingDocumentItemText                                             as PurchaseOrderItemText,

      //      @ObjectModel.foreignKey.association: '_ProductType'

      //      ProductType,


      @ObjectModel.foreignKey.association: '_CompanyCode'
      CompanyCode,

      @ObjectModel.foreignKey.association: '_Plant'
      Plant,

      @ObjectModel.foreignKey.association: '_Customer'
      Customer,

      @ObjectModel.foreignKey.association: '_Subcontractor'
      Subcontractor,

      SupplierIsSubcontractor,

      @ObjectModel.foreignKey.association: '_ConfigurableProduct'
      CrossPlantConfigurableProduct,

      ArticleCategory,

      PlndOrderReplnmtElmntType,

      ProductPurchasePointsQtyUnit,

      @Semantics.quantity.unitOfMeasure: 'ProductPurchasePointsQtyUnit'
      @DefaultAggregation: #NONE
      ProductPurchasePointsQty,

      @ObjectModel.foreignKey.association: '_StorageLocation'
      StorageLocation,

      @ObjectModel.foreignKey.association: '_OrderQuantityUnit'
      OrderQuantityUnit                                                      as PurchaseOrderQuantityUnit,

      OrderItemQtyToBaseQtyNmrtr,

      OrderItemQtyToBaseQtyDnmntr,

      @Semantics.quantity.unitOfMeasure: 'OrderPriceUnit'
      NetPriceQuantity,

      IsCompletelyDelivered,

      IsFinallyInvoiced,

      GoodsReceiptIsExpected,

      OutwardDeliveryIsComplete,

      InvoiceIsExpected,

      InvoiceIsGoodsReceiptBased,

      @ObjectModel.foreignKey.association: '_PurchaseContractItem'
      PurchaseContractItem,

      @ObjectModel.foreignKey.association: '_PurchaseContract'
      PurchaseContract,

      @ObjectModel.foreignKey.association: '_PurchaseRequisition'
      PurchaseRequisition,

      RequirementTracking,

      IsOrderAcknRqd,

      @ObjectModel.foreignKey.association: '_PurchaseRequisitionItem'
      PurchaseRequisitionItem,

      RequestForQuotation,

      RequestForQuotationItem,

      SupplierQuotation,

      SupplierQuotationItem,

      EvaldRcptSettlmtIsAllowed,

      UnlimitedOverdeliveryIsAllowed,

      OverdelivTolrtdLmtRatioInPct,

      UnderdelivTolrtdLmtRatioInPct,

      RequisitionerName,

      MRPArea,

      PurchasingDocumentCreationTime                                         as CreationTime,

      PurchasingDocumentCreationDate                                         as CreationDate,

      PlannedDeliveryDurationInDays,

      GoodsReceiptDurationInDays,

      PartialDeliveryIsAllowed,

      ConsumptionPosting,

      @ObjectModel.foreignKey.association: '_ServicePerformer'
      ServicePerformer,

      ServicePackage,

      BaseUnit,

      @ObjectModel.foreignKey.association: '_PurgDocumentItemCategory'
      PurchasingDocumentItemCategory                                         as PurchaseOrderItemCategory,

      ProfitCenter,

      @ObjectModel.foreignKey.association: '_OrderPriceUnit'
      OrderPriceUnit,

      VolumeUnit                                                             as ItemVolumeUnit,

      WeightUnit                                                             as ItemWeightUnit,

      MultipleAcctAssgmtDistribution,

      PartialInvoiceDistribution,

      PricingDateControl,

      IsStatisticalItem,

      PurchasingParentItem,

      GoodsReceiptLatestCreationDate,

      IsReturnsItem,

      PurchasingOrderReason,

      @ObjectModel.foreignKey.association: '_IncotermsClassification'
      IncotermsClassification,

      IncotermsTransferLocation,

      IncotermsLocation1,

      IncotermsLocation2,

      @ObjectModel.foreignKey.association: '_PriorSupplier'
      PriorSupplier,

      InternationalArticleNumber,

      IntrastatServiceCode,

      CommodityCode,

      MaterialFreightGroup,

      DiscountInKindEligibility,

      PurgItemIsBlockedForDelivery,

      //ConfirmationControl,


      SupplierConfirmationControlKey,

      PriceIsToBePrinted,

      AccountAssignmentCategory,

      @ObjectModel.foreignKey.association: '_PurchasingInfoRecord'
      PurchasingInfoRecord,

      @Semantics.amount.currencyCode: 'DocumentCurrency'
      NetAmount,

      @Semantics.amount.currencyCode: 'DocumentCurrency'
      GrossAmount,

      @Semantics.amount.currencyCode: 'DocumentCurrency'
      EffectiveAmount,

      @Semantics.amount.currencyCode: 'DocumentCurrency'
      Subtotal1Amount,

      @Semantics.amount.currencyCode: 'DocumentCurrency'
      Subtotal2Amount,

      @Semantics.amount.currencyCode: 'DocumentCurrency'
      Subtotal3Amount,

      @Semantics.amount.currencyCode: 'DocumentCurrency'
      Subtotal4Amount,

      @Semantics.amount.currencyCode: 'DocumentCurrency'
      Subtotal5Amount,

      @Semantics.amount.currencyCode: 'DocumentCurrency'
      Subtotal6Amount,

      //    ekpo.ktmng as TargetQuantity,


      @Semantics.quantity.unitOfMeasure: 'PurchaseOrderQuantityUnit'
      OrderQuantity,

      @Semantics.amount.currencyCode: 'DocumentCurrency'
      NetPriceAmount,

      //    ekpo.zwert as OutlineAgreementTargetAmount,


      @Semantics.quantity.unitOfMeasure: 'ItemVolumeUnit'
      ItemVolume,

      @Semantics.quantity.unitOfMeasure: 'ItemWeightUnit'
      ItemGrossWeight,

      @Semantics.quantity.unitOfMeasure: 'ItemWeightUnit'
      ItemNetWeight,


      OrdPriceUnitToOrderUnitDnmntr,

      GoodsReceiptIsNonValuated,

      TaxCode,

      TaxJurisdiction,

      ShippingInstruction,

      @Semantics.amount.currencyCode: 'DocumentCurrency'
      NonDeductibleInputTaxAmount,

      //      StockType,


      ValuationType,

      ValuationCategory,

      ItemIsRejectedBySupplier,

      PurgDocPriceDate,

      PurchasingInfoRecordUpdateCode, //                                 as IsInfoRecordUpdated,


      PurgDocReleaseOrderQuantity,

      PurgDocOrderAcknNumber,

      CostCenter,

      GLAccount,

      cast (WBSElementInternalID as ps_s4_pspnr preserving type )            as WBSElementInternalID,

      Fund,

      BudgetPeriod,

      FundsCenter,

      @VDM.lifecycle.status: #DEPRECATED
      @VDM.lifecycle.successor: 'CommitmentItemShortID'
      CommitmentItem,

      cast( CommitmentItem as fmis_ci_internalname preserving type )         as CommitmentItemShortID,

      FunctionalArea,

      GrantID,

      EarmarkedFundsDocument,

      EarmarkedFundsDocumentItem,

      InventorySpecialStockType,

      DeliveryDocumentType,

      IssuingStorageLocation,

      AllocationTable,


      PurgConfigurableItemNumber,

      RetailPromotion,

      // Down Payment

      DownPaymentType,

      DownPaymentPercentageOfTotAmt,

      @Semantics.amount.currencyCode: 'DocumentCurrency'
      DownPaymentAmount,

      DownPaymentDueDate,

      // S/4 Limit

      ExpectedOverallLimitAmount,
      OverallLimitAmount,
      PurContractForOverallLimit,

      RequirementSegment,

      // Brazil Extension

      @ObjectModel.foreignKey.association: '_BR_MaterialOrigin'
      BR_MaterialOrigin,

      @ObjectModel.foreignKey.association: '_BR_MaterialUsage'
      BR_MaterialUsage,

      @ObjectModel.foreignKey.association: '_BR_CFOPCategory'
      BR_CFOPCategory,

      ConsumptionTaxCtrlCode,

      BR_IsProducedInHouse,

      ThirdPtyOrdProcgExtReference,

      ThirdPtyOrdProcgExtRefItem,

      PurgDocAggrgdSubitemCategory,

      _PurchaseOrder,
      _DocumentCurrency,
      _CompanyCode,
      _Plant,
      _StorageLocation,
      _Material,
      _ManufacturerMaterial,
      _MaterialGroup,
      _OrderPriceUnit,
      _PurgDocumentCategory,
      _PurgDocumentItemCategory,
      _IncotermsClassification,
      _PriorSupplier,
      _ConsumptionPosting,
      _PurchaseRequisitionItem,
      _PurchasingInfoRecord,
      _Customer,
      _Subcontractor,
      _ConfigurableProduct,
      _PurchaseRequisition,
      _PurchaseContract,
      _PurchaseContractItem,
      _ServicePerformer,
      _OrderQuantityUnit,
      _AllocationTable,
      _RetailPromotion,

      //Associations for Brazilian specific fields

      _BR_MaterialOrigin,
      _BR_MaterialUsage,
      _BR_CFOPCategory
      //      _BR_NCM


}
where
      PurchasingDocumentCategory = 'F'
  and IsEndOfPurposeBlocked      = ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"R_PURCHASINGDOCUMENTITEM"
],
"ASSOCIATED":
[
"I_ALLOCATIONTABLE",
"I_BR_CFOPCATEGORY",
"I_BR_MATERIALORIGIN",
"I_BR_MATERIALUSAGE",
"I_BUSINESSPARTNER",
"I_COMPANYCODE",
"I_CONSUMPTIONPOSTING",
"I_CURRENCY",
"I_CUSTOMER",
"I_INCOTERMSCLASSIFICATION",
"I_MATERIAL",
"I_MATERIALGROUP",
"I_PLANT",
"I_PPS_PURCHASEORDER",
"I_PURCHASECONTRACT",
"I_PURCHASECONTRACTITEM",
"I_PURCHASEREQUISITION",
"I_PURCHASEREQUISITIONITEM",
"I_PURCHASINGDOCUMENTCATEGORY",
"I_PURCHASINGINFORECORDAPI01",
"I_PURGDOCUMENTITEMCATEGORY",
"I_RETAILPROMOTION",
"I_STORAGELOCATION",
"I_SUPPLIER",
"I_UNITOFMEASURE"
],
"BASE":
[
"R_PURCHASINGDOCUMENTITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More