R_PurchaseOrderItemTP

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 R_PurchaseOrderItemTP.
-- 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 R_PurchaseOrderItemTP AS
SELECT
  PurchaseOrder,
  PurchaseOrderItem,
  PurchaseOrderCategory,
  DocumentCurrency,
  PurchasingDocumentDeletionCode,
  MaterialGroup,
  Material,
  MaterialType,
  SupplierMaterialNumber,
  SupplierSubrange,
  ManufacturerPartNmbr,
  Manufacturer,
  ManufacturerMaterial,
  PurchaseOrderItemText,
  ProductType AS 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,
  InvoicingPlan,
  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,
  PurgDocSubitemCategory,
  PurgExternalSortNumber,
  MaterialRevisionLevel,
  _PurchaseOrderItemAddFields.Batch AS Batch,
  _PurchaseOrderItemAddFields.PurchasingItemIsFreeOfCharge AS PurchasingItemIsFreeOfCharge,
  DownPaymentType,
  DownPaymentPercentageOfTotAmt,
  DownPaymentAmount,
  DownPaymentDueDate,
  ExpectedOverallLimitAmount,
  OverallLimitAmount,
  PurContractForOverallLimit,
  PurContractItemForOverallLimit,
  PurgProdCmplncSupplierStatus,
  PurgProductMarketabilityStatus,
  PurgSafetyDataSheetStatus,
  PurgProdCmplncDngrsGoodsStatus,
  RequirementSegment,
  Fund,
  BudgetPeriod,
  FundsCenter,
  CommitmentItem,
  CommitmentItemShortID,
  FunctionalArea,
  GrantID,
  EarmarkedFundsDocument,
  EarmarkedFundsDocumentItem,
  CostCenter,
  GLAccount,
  cast( WBSElementInternalID as ps_s4_pspnr preserving type ) AS WBSElementInternalID,
  BR_MaterialOrigin,
  BR_MaterialUsage,
  BR_CFOPCategory,
  BR_NCM,
  ConsumptionTaxCtrlCode,
  BR_IsProducedInHouse,
  ProductSeasonYear,
  ProductSeason,
  ProductCollection,
  ProductTheme,
  SeasonCompletenessStatus,
  ShippingGroupRule,
  ShippingGroupNumber,
  ProductCharacteristic1,
  ProductCharacteristic2,
  ProductCharacteristic3,
  DiversionStatus,
  ReferenceDocumentNumber,
  RefDocNmbrForTrcblyInPO,
  ReferenceDocumentItem,
  PurchaseOrderReferenceType,
  ItemHasValueAddedService,
  ValAddedSrvcParentItmNumber,
  StockSegment
FROM R_PurchaseOrderItem
LEFT OUTER JOIN E_PurchasingDocumentItem AS _PurchaseOrderItemExtension ON PurchaseOrder = _PurchaseOrderItemExtension.PurchasingDocument AND PurchaseOrderItem = _PurchaseOrderItemExtension.PurchasingDocumentItem  -- association [1..1]
LEFT OUTER JOIN P_PurchaseOrderItemAddFields AS _PurchaseOrderItemAddFields ON PurchaseOrder = _PurchaseOrderItemAddFields.PurchaseOrder AND PurchaseOrderItem = _PurchaseOrderItemAddFields.PurchaseOrderItem  -- association [1..1]
LEFT OUTER JOIN R_PurOrdItemDeliveryAddressTP AS _DeliveryAddress ON /* condition not available in parsed metadata */  -- association [1..1]
LEFT OUTER JOIN R_PurchaseOrderInvoicingPlanTP AS _PurchaseOrderInvoicingPlan ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_PurchaseOrderItemNoteTP AS _PurchaseOrderItemNote ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_PurOrdAccountAssignmentTP AS _PurOrdAccountAssignment ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_PurOrderItemPricingElementTP AS _PurOrdPricingElement ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN R_PurchaseOrderScheduleLineTP AS _PurchaseOrderScheduleLineTP ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN R_POItemExternalReferenceTP AS _ItemExternalReference ON /* condition not available in parsed metadata */  -- association [0..*]
;