I_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 I_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.
-- SQL view name: IPURORDITMTP

CREATE VIEW I_PurchaseOrderItemTP AS
SELECT
  Document.PurchaseOrder AS PurchaseOrder,
  cast (Document.PurchaseOrderItem as ebelp preserving type) AS PurchaseOrderItem,
  PurchaseOrderItemUniqueID,
  Document.NetPriceAmount AS NetPriceAmount,
  Document.PurchaseOrderItemCategory AS PurchaseOrderItemCategory,
  _PurgDocumentItemCategoryText.PurgDocExternalItemCategory AS PurOrdExternalItemCategory,
  _PurgDocumentItemCategoryText.PurgDocItemCategoryName AS PurOrdItemCategoryName,
  Document.ProductType AS ProductType,
  _ProductTypeCodeText.Name AS ProductTypeName,
  Document.Material AS Material,
  Document.SupplierMaterialNumber AS SupplierMaterialNumber,
  Document.ManufacturerPartNmbr AS ManufacturerPartNmbr,
  Document.ManufacturerMaterial AS ManufacturerMaterial,
  Document.MaterialGroup AS MaterialGroup,
  Document.Plant AS Plant,
  Document.PurchaseOrderItemText AS PurchaseOrderItemText,
  Document.CompanyCode AS CompanyCode,
  Document.PurchasingDocumentDeletionCode AS PurchasingDocumentDeletionCode,
  _PurchaseOrderItemStatus.PurchaseOrderItemStatus AS PurchaseOrderItemStatus,
  Document.IsReturnsItem AS IsReturnsItem,
  Document.IsStatisticalItem AS IsStatisticalItem,
  Document.IsCompletelyDelivered AS IsCompletelyDelivered,
  Document.IsFinallyInvoiced AS IsFinallyInvoiced,
  Document.GoodsReceiptIsExpected AS GoodsReceiptIsExpected,
  Document.GoodsReceiptIsNonValuated AS GoodsReceiptIsNonValuated,
  Document.IsToBeAcceptedAtOrigin AS IsToBeAcceptedAtOrigin,
  Document.InvoiceIsExpected AS InvoiceIsExpected,
  Document.InvoiceIsGoodsReceiptBased AS InvoiceIsGoodsReceiptBased,
  Document.EvaldRcptSettlmtIsAllowed AS EvaldRcptSettlmtIsAllowed,
  Document.PriceChangeInSESIsAllowed AS PriceChangeInSESIsAllowed,
  Document.UnlimitedOverdeliveryIsAllowed AS UnlimitedOverdeliveryIsAllowed,
  Document.OverdelivTolrtdLmtRatioInPct AS OverdelivTolrtdLmtRatioInPct,
  Document.UnderdelivTolrtdLmtRatioInPct AS UnderdelivTolrtdLmtRatioInPct,
  Document.PurchaseContract AS PurchaseContract,
  Document.PurchaseContractItem AS PurchaseContractItem,
  Document.PurchaseRequisition AS PurchaseRequisition,
  Document.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  Document.IsOrderAcknRqd AS IsOrderAcknRqd,
  Document.RequestForQuotation AS RequestForQuotation,
  Document.RequestForQuotationItem AS RequestForQuotationItem,
  Document.SupplierQuotation AS SupplierQuotation,
  Document.SupplierQuotationItem AS SupplierQuotationItem,
  Document.MultipleAcctAssgmtDistribution AS MultipleAcctAssgmtDistribution,
  Document.PartialInvoiceDistribution AS PartialInvoiceDistribution,
  Document.PricingDateControl AS PricingDateControl,
  Document.RequisitionerName AS RequisitionerName,
  Document.PlannedDeliveryDurationInDays AS PlannedDeliveryDurationInDays,
  Document.ConsumptionPosting AS ConsumptionPosting,
  Document.ServicePerformer AS ServicePerformer,
  Document.ServicePackage AS ServicePackage,
  Document.AccountAssignmentCategory AS AccountAssignmentCategory,
  Document.CostCenter AS CostCenter,
  Document.GLAccount AS GLAccount,
  Document.WBSElementInternalID AS WBSElementInternalID,
  _WBSElement.WBSElement AS WBSElementExternalID,
  _WBSElement.WBSDescription AS WBSDescription,
  Document.Fund AS Fund,
  Document.BudgetPeriod AS BudgetPeriod,
  Document.FundsCenter AS FundsCenter,
  Document.CommitmentItem AS CommitmentItem,
  Document.FunctionalArea AS FunctionalArea,
  Document.GrantID AS GrantID,
  Document.EarmarkedFunds AS EarmarkedFunds,
  Document.EarmarkedFundsDocument AS EarmarkedFundsDocument,
  Document.EarmarkedFundsItem AS EarmarkedFundsItem,
  Document.EarmarkedFundsDocumentItem AS EarmarkedFundsDocumentItem,
  Document.ProfitCenter AS ProfitCenter,
  Document.StorageLocation AS StorageLocation,
  Document.OrderQuantity AS OrderQuantity,
  Document.PurchaseOrderQuantityUnit AS PurchaseOrderQuantityUnit,
  Document.PurchasingInfoRecord AS PurchasingInfoRecord,
  Document.IncotermsClassification AS IncotermsClassification,
  Document.IncotermsTransferLocation AS IncotermsTransferLocation,
  Document.IncotermsLocation1 AS IncotermsLocation1,
  Document.IncotermsLocation2 AS IncotermsLocation2,
  cast( ' ' as tminco_loc_1_id ) AS IncotermsLocation1Identifier,
  cast( ' ' as tminco_loc_2_id ) AS IncotermsLocation2Identifier,
  cast( ' ' as tminco_loc_d_id ) AS IncotermsDvtgLocIdentifier,
  cast( ' ' as tminco_loc_d_descr ) AS IncotermsDvtgLocDescription,
  Document.IncotermsSupChnLoc1AddlUUID AS IncotermsSupChnLoc1AddlUUID,
  Document.IncotermsSupChnLoc2AddlUUID AS IncotermsSupChnLoc2AddlUUID,
  Document.IncotermsSupChnDvtgLocAddlUUID AS IncotermsSupChnDvtgLocAddlUUID,
  Document.InternationalArticleNumber AS InternationalArticleNumber,
  Document.IntrastatServiceCode AS IntrastatServiceCode,
  Document.CommodityCode AS CommodityCode,
  Document.SupplierConfirmationControlKey AS SupplierConfirmationControlKey,
  Document.PriceIsToBePrinted AS PriceIsToBePrinted,
  Document.TaxCode AS TaxCode,
  Document.TaxJurisdiction AS TaxJurisdiction,
  Document.TaxCodeValidFromDate AS TaxCodeValidFromDate,
  Document.TaxCountry AS TaxCountry,
  Document.TaxDeterminationDate AS TaxDeterminationDate,
  Document.ShippingInstruction AS ShippingInstruction,
  Document.ItemIsRejectedBySupplier AS ItemIsRejectedBySupplier,
  Document.PurchasingInfoRecordUpdateCode AS IsInfoRecordUpdated,
  Document.PurgDocOrderAcknNumber AS PurgDocOrderAcknNumber,
  Document.OrderPriceUnit AS OrderPriceUnit,
  Document.NetPriceQuantity AS NetPriceQuantity,
  Document.OrderPriceUnitToOrderUnitNmrtr AS OrderPriceUnitToOrderUnitNmrtr,
  Document.OrdPriceUnitToOrderUnitDnmntr AS OrdPriceUnitToOrderUnitDnmntr,
  Document.OrderItemQtyToBaseQtyNmrtr AS OrderItemQtyToBaseQtyNmrtr,
  Document.OrderItemQtyToBaseQtyDnmntr AS OrderItemQtyToBaseQtyDnmntr,
  Document.ItemVolumeUnit AS ItemVolumeUnit,
  Document.ItemWeightUnit AS ItemWeightUnit,
  Document.BaseUnit AS BaseUnit,
  Document.DocumentCurrency AS DocumentCurrency,
  Document.NetAmount AS NetAmount,
  Document.EffectiveAmount AS EffectiveAmount,
  PFMTransDataFootprintUUID,
  Document.PurgConfigurableItemNumber AS PurgConfigurableItemNumber,
  Document.PurgDocAggrgdSubitemCategory AS PurgDocAggrgdSubitemCategory,
  Document.PurchasingParentItem AS PurchasingParentItem,
  Document.PurgDocSubitemCategory AS PurgDocSubitemCategory,
  Document.PurgExternalSortNumber AS PurgExternalSortNumber,
  cast( '' as rsnodeext ) AS PurchasingHierarchyNode,
  cast( '' as rsnodeext ) AS HierarchyParentNode,
  cast( 0 as abap.int4 ) AS HierarchyLevel,
  cast( 0 as abap.int4 ) AS HierarchyNodeSubTreeSize,
  cast( '' as abap.char(22) ) AS HierarchyDrillState,
  cast( 0 as abap.int8 ) AS HierarchyNodeOrdinalNumber,
  Document.ManualDeliveryAddressID AS ManualDeliveryAddressID,
  Document.ReferenceDeliveryAddressID AS ReferenceDeliveryAddressID,
  Document.Customer AS Customer,
  Document.ExpectedOverallLimitAmount AS ExpectedOverallLimitAmount,
  Document.OverallLimitAmount AS OverallLimitAmount,
  Document.PurContractForOverallLimit AS PurContractForOverallLimit,
  Document.PurContractItemForOverallLimit AS PurContractItemForOverallLimit,
  Document.PurgProdCmplncSupplierStatus AS PurgProdCmplncSupplierStatus,
  Document.PurgProductMarketabilityStatus AS PurgProductMarketabilityStatus,
  Document.PurgSafetyDataSheetStatus AS PurgSafetyDataSheetStatus,
  Document.PurgProdCmplncDngrsGoodsStatus AS PurgProdCmplncDngrsGoodsStatus,
  cast ('' as charg_d) AS Batch,
  cast ('' as lichn) AS BatchBySupplier,
  Document.BR_MaterialOrigin AS BR_MaterialOrigin,
  Document.BR_MaterialUsage AS BR_MaterialUsage,
  Document.BR_CFOPCategory AS BR_CFOPCategory,
  BR_NCM,
  IN_GSTControlCode,
  Document.BR_IsProducedInHouse AS BR_IsProducedInHouse,
  cast ('' as hghstmsgsvrtylvl) AS HighestMessageSeverityLevel,
  cast ('' as poitmacctassgmtfieldsareenbld ) AS POItmAcctAssgmtFieldsAreEnbld,
  _PurchaseOrderTP.IncotermsVersion AS IncotermsVersion,
  _PurchaseOrderTP.PurchasingOrganization AS PurchasingOrganization,
  _PurchaseOrderTP.PurchasingGroup AS PurchasingGroup,
  _PurchaseOrderTP.PurchaseOrderType AS PurchaseOrderType,
  _PurchaseOrderTP._IncotermsVersion AS _IncotermsVersion,
  _PurchaseOrderTP._PurchasingGroup AS _PurchasingGroup,
  _PurchaseOrderTP._PurchasingOrganization AS _PurchasingOrganization
FROM R_PurchaseOrderItem AS Document
LEFT OUTER JOIN I_PurchaseOrderTP AS _PurchaseOrderTP ON _PurchaseOrderTP.PurchaseOrder = PurchaseOrder  -- association [1..1]
LEFT OUTER JOIN I_PurOrdAcctAssignmentTP AS _PurOrdAcctAssignmentTP ON _PurOrdAcctAssignmentTP.PurchaseOrder = PurchaseOrder AND _PurOrdAcctAssignmentTP.PurchaseOrderItem = PurchaseOrderItem  -- association [1..*]
LEFT OUTER JOIN I_PurOrdPricingElementTP AS _PurOrdPricingElementTP ON _PurOrdPricingElementTP.PurchaseOrder = PurchaseOrder AND _PurOrdPricingElementTP.PurchaseOrderItem = PurchaseOrderItem  -- association [1..*]
LEFT OUTER JOIN I_PurOrdScheduleLineTP AS _PurOrdScheduleLineTP ON _PurOrdScheduleLineTP.PurchaseOrder = PurchaseOrder AND _PurOrdScheduleLineTP.PurchaseOrderItem = PurchaseOrderItem  -- association [1..*]
LEFT OUTER JOIN I_PurOrdDeliveryAddressTP AS _PurOrdDeliveryAddressTP ON _PurOrdDeliveryAddressTP.PurchaseOrder = PurchaseOrder AND _PurOrdDeliveryAddressTP.PurchaseOrderItem = PurchaseOrderItem  -- association [1..1]
LEFT OUTER JOIN I_PurgDocumentItemCategoryText AS _PurgDocumentItemCategoryText ON _PurgDocumentItemCategoryText.Language = $session.system_language AND _PurgDocumentItemCategoryText.PurchasingDocumentItemCategory = PurchaseOrderItemCategory  -- association [1..1]
LEFT OUTER JOIN I_ProductTypeCodeText AS _ProductTypeCodeText ON _ProductTypeCodeText.ProductTypeCode = ProductType AND _ProductTypeCodeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_PurchaseOrderItemStatus AS _PurchaseOrderItemStatus ON _PurchaseOrderItemStatus.PurchaseOrder = PurchaseOrder AND _PurchaseOrderItemStatus.PurchaseOrderItem = PurchaseOrderItem  -- association [0..1]
LEFT OUTER JOIN E_PurchasingDocumentItem AS _PurchaseOrderItemExtension ON PurchaseOrder = _PurchaseOrderItemExtension.PurchasingDocument AND PurchaseOrderItem = _PurchaseOrderItemExtension.PurchasingDocumentItem  -- association [1..1]
LEFT OUTER JOIN I_PurchaseOrderItemNoteTP AS _PurchaseOrderItemNoteTP ON _PurchaseOrderItemNoteTP.PurchaseOrder = PurchaseOrder AND _PurchaseOrderItemNoteTP.PurchaseOrderItem = PurchaseOrderItem  -- association [0..*]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElement ON _WBSElement.WBSElementInternalID = WBSElementInternalID  -- association [0..1]
;