P_PurchaseOrderItemPAI_04

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 P_PurchaseOrderItemPAI_04.
-- 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: PPOITEMPAI4

CREATE VIEW P_PurchaseOrderItemPAI_04 AS
SELECT
  P_PurchaseOrderItemPAI_03.PurchaseOrder AS PurchaseOrder,
  P_PurchaseOrderItemPAI_03.PurchaseOrderItem AS PurchaseOrderItem,
  P_PurchaseOrderItemPAI_03.PurchaseContractItem AS PurchaseContractItem,
  P_PurchaseOrderItemPAI_03.PurchaseContract AS PurchaseContract,
  cast ( CONT_LEN as mm_a_contract_length) AS CONT_LEN,
  cast ( CONT_DAYS_LEFT as mm_a_contract_days_left ) AS CONT_DAYS_LEFT,
  cast ( RUNNING_TOTAL as mm_a_cntr_consumded_qty ) AS RUNNING_TOTAL,
  cast ( RUNNING_PERCENTAGE as mm_a_cntr_consumption_pct ) AS RUNNING_PERCENTAGE,
  I_CalendarDate.CalendarMonth AS PODATE_MONTH,
  I_CalendarDate.WeekDay AS PODATE_WEEKDAY,
  I_CalendarDate.CalendarWeek AS PODATE_WEEK,
  cast ( ConsumedQty as mm_a_cntr_consumption_pct ) AS ConsumedQty,
  cast ( PO_ITEMS_NUM as mm_a_number_of_po_items) AS PO_ITEMS_NUM,
  cast ( dats_days_between( PreviousPOIDate , P_PurchaseOrderItemPAI_03.PurchaseOrderDate ) as mm_a_po_days_interval ) AS DAYS_INTERVAL,
  cast (div( RUNNING_TOTAL, PO_ITEMS_NUM ) as mm_a_avg_po_amt) AS AVG_PO_AMT,
  cast( div( RunningDays, PO_ITEMS_NUM ) as mm_a_avg_po_days ) AS AVG_PO_DAYS,
  PurchaseOrderItem.AccountAssignmentCategory AS AccountAssignmentCategory,
  PurchaseOrderItem.BaseUnit AS BaseUnit,
  PurchaseOrderItem.CommodityCode AS CommodityCode,
  PurchaseOrderItem.CompanyCode AS CompanyCode,
  PurchaseOrderItem.Customer AS Customer,
  PurchaseOrderItem.DocumentCurrency AS DocumentCurrency,
  PurchaseOrderItem.EarmarkedFunds AS EarmarkedFunds,
  PurchaseOrderItem.EarmarkedFundsItem AS EarmarkedFundsItem,
  PurchaseOrderItem.EffectiveAmount AS EffectiveAmount,
  PurchaseOrderItem.EvaldRcptSettlmtIsAllowed AS EvaldRcptSettlmtIsAllowed,
  PurchaseOrderItem.ExpectedOverallLimitAmount AS ExpectedOverallLimitAmount,
  PurchaseOrderItem.GoodsReceiptIsExpected AS GoodsReceiptIsExpected,
  PurchaseOrderItem.GoodsReceiptIsNonValuated AS GoodsReceiptIsNonValuated,
  PurchaseOrderItem.IncotermsClassification AS IncotermsClassification,
  PurchaseOrderItem.IncotermsLocation1 AS IncotermsLocation1,
  PurchaseOrderItem.IncotermsLocation2 AS IncotermsLocation2,
  PurchaseOrderItem.IncotermsTransferLocation AS IncotermsTransferLocation,
  PurchaseOrderItem.InternationalArticleNumber AS InternationalArticleNumber,
  PurchaseOrderItem.IntrastatServiceCode AS IntrastatServiceCode,
  PurchaseOrderItem.InvoiceIsExpected AS InvoiceIsExpected,
  PurchaseOrderItem.InvoiceIsGoodsReceiptBased AS InvoiceIsGoodsReceiptBased,
  PurchaseOrderItem.IsCompletelyDelivered AS IsCompletelyDelivered,
  PurchaseOrderItem.IsFinallyInvoiced AS IsFinallyInvoiced,
  PurchaseOrderItem.IsReturnsItem AS IsReturnsItem,
  PurchaseOrderItem.IsStatisticalItem AS IsStatisticalItem,
  PurchaseOrderItem.ItemNetWeight AS ItemNetWeight,
  PurchaseOrderItem.ItemVolume AS ItemVolume,
  PurchaseOrderItem.ItemVolumeUnit AS ItemVolumeUnit,
  PurchaseOrderItem.ItemWeightUnit AS ItemWeightUnit,
  PurchaseOrderItem.ManualDeliveryAddressID AS ManualDeliveryAddressID,
  PurchaseOrderItem.Manufacturer AS Manufacturer,
  PurchaseOrderItem.ManufacturerMaterial AS ManufacturerMaterial,
  PurchaseOrderItem.ManufacturerPartNmbr AS ManufacturerPartNmbr,
  PurchaseOrderItem.Material AS Material,
  PurchaseOrderItem.MaterialGroup AS MaterialGroup,
  PurchaseOrderItem.MaterialType AS MaterialType,
  PurchaseOrderItem.MultipleAcctAssgmtDistribution AS MultipleAcctAssgmtDistribution,
  PurchaseOrderItem.NetAmount AS NetAmount,
  PurchaseOrderItem.NetPriceAmount AS NetPriceAmount,
  PurchaseOrderItem.NetPriceQuantity AS NetPriceQuantity,
  PurchaseOrderItem.OrdPriceUnitToOrderUnitDnmntr AS OrdPriceUnitToOrderUnitDnmntr,
  PurchaseOrderItem.OrderItemQtyToBaseQtyDnmntr AS OrderItemQtyToBaseQtyDnmntr,
  PurchaseOrderItem.OrderItemQtyToBaseQtyNmrtr AS OrderItemQtyToBaseQtyNmrtr,
  PurchaseOrderItem.OrderPriceUnit AS OrderPriceUnit,
  PurchaseOrderItem.OrderPriceUnitToOrderUnitNmrtr AS OrderPriceUnitToOrderUnitNmrtr,
  PurchaseOrderItem.OrderQuantity AS OrderQuantity,
  PurchaseOrderItem.OverallLimitAmount AS OverallLimitAmount,
  PurchaseOrderItem.OverdelivTolrtdLmtRatioInPct AS OverdelivTolrtdLmtRatioInPct,
  PurchaseOrderItem.PartialInvoiceDistribution AS PartialInvoiceDistribution,
  PurchaseOrderItem.Plant AS Plant,
  PurchaseOrderItem.PriceIsToBePrinted AS PriceIsToBePrinted,
  PurchaseOrderItem.PricingDateControl AS PricingDateControl,
  PurchaseOrderItem.ProductType AS ProductType,
  PurchaseOrderItem.ProfitCenter AS ProfitCenter,
  PurchaseOrderItem.PurchaseOrderCategory AS PurchaseOrderCategory,
  PurchaseOrderItem.PurchaseOrderItemCategory AS PurchaseOrderItemCategory,
  PurchaseOrderItem.PurchaseOrderItemText AS PurchaseOrderItemText,
  PurchaseOrderItem.PurchaseOrderQuantityUnit AS PurchaseOrderQuantityUnit,
  PurchaseOrderItem.PurchaseRequisition AS PurchaseRequisition,
  PurchaseOrderItem.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  PurchaseOrderItem.PurchasingDocumentDeletionCode AS PurchasingDocumentDeletionCode,
  PurchaseOrderItem.PurchasingInfoRecord AS PurchasingInfoRecord,
  PurchaseOrderItem.ReferenceDeliveryAddressID AS ReferenceDeliveryAddressID,
  PurchaseOrderItem.RequisitionerName AS RequisitionerName,
  PurchaseOrderItem.ServicePackage AS ServicePackage,
  PurchaseOrderItem.ServicePerformer AS ServicePerformer,
  PurchaseOrderItem.StorageLocation AS StorageLocation,
  PurchaseOrderItem.SupplierConfirmationControlKey AS SupplierConfirmationControlKey,
  PurchaseOrderItem.SupplierMaterialNumber AS SupplierMaterialNumber,
  PurchaseOrderItem.SupplierSubrange AS SupplierSubrange,
  PurchaseOrderItem.TaxCode AS TaxCode,
  PurchaseOrderItem.TaxJurisdiction AS TaxJurisdiction,
  PurchaseOrderItem.UnderdelivTolrtdLmtRatioInPct AS UnderdelivTolrtdLmtRatioInPct,
  PurchaseOrderItem.UnlimitedOverdeliveryIsAllowed AS UnlimitedOverdeliveryIsAllowed,
  PurchaseOrderItem.ValuationType AS ValuationType,
  PurchaseOrder.CashDiscount1Days AS CashDiscount1Days,
  PurchaseOrder.CashDiscount1Percent AS CashDiscount1Percent,
  PurchaseOrder.CashDiscount2Days AS CashDiscount2Days,
  PurchaseOrder.CashDiscount2Percent AS CashDiscount2Percent,
  PurchaseOrder.CreatedByUser AS CreatedByUser,
  PurchaseOrder.CreationDate AS CreationDate,
  PurchaseOrder.ExchangeRate AS ExchangeRate,
  PurchaseOrder.IncotermsVersion AS IncotermsVersion,
  PurchaseOrder.InvoicingParty AS InvoicingParty,
  PurchaseOrder.IsIntrastatReportingExcluded AS IsIntrastatReportingExcluded,
  PurchaseOrder.IsIntrastatReportingRelevant AS IsIntrastatReportingRelevant,
  PurchaseOrder.Language AS Language,
  PurchaseOrder.LastChangeDateTime AS LastChangeDateTime,
  PurchaseOrder.ManualSupplierAddressID AS ManualSupplierAddressID,
  PurchaseOrder.NetPaymentDays AS NetPaymentDays,
  PurchaseOrder.PaymentTerms AS PaymentTerms,
  PurchaseOrder.PricingProcedure AS PricingProcedure,
  PurchaseOrder.PurchaseOrderDate AS PurchaseOrderDate,
  PurchaseOrder.PurchaseOrderSubtype AS PurchaseOrderSubtype,
  PurchaseOrder.PurchaseOrderType AS PurchaseOrderType,
  PurchaseOrder.PurchasingCompletenessStatus AS PurchasingCompletenessStatus,
  PurchaseOrder.PurchasingDocumentCondition AS PurchasingDocumentCondition,
  PurchaseOrder.PurchasingDocumentIsAged AS PurchasingDocumentIsAged,
  PurchaseOrder.PurchasingDocumentOrigin AS PurchasingDocumentOrigin,
  PurchaseOrder.PurchasingGroup AS PurchasingGroup,
  PurchaseOrder.PurchasingOrganization AS PurchasingOrganization,
  PurchaseOrder.PurchasingProcessingStatus AS PurchasingProcessingStatus,
  PurchaseOrder.ReleaseIsNotCompleted AS ReleaseIsNotCompleted,
  PurchaseOrder.Supplier AS Supplier,
  PurchaseOrder.SupplierAddressID AS SupplierAddressID,
  PurchaseOrder.SupplierPhoneNumber AS SupplierPhoneNumber,
  PurchaseOrder.SupplierQuotationExternalID AS SupplierQuotationExternalID,
  PurchaseOrder.SupplierRespSalesPersonName AS SupplierRespSalesPersonName,
  PurchaseOrder.SupplyingPlant AS SupplyingPlant,
  PurchaseOrder.SupplyingSupplier AS SupplyingSupplier,
  PurchaseOrder.ValidityEndDate AS PurchaseOrderValidityEndDate,
  PurchaseOrder.ValidityStartDate AS PurchaseOrderValidityStartDate,
  PurchaseContract.CorrespncExternalReference AS CorrespncExternalReference,
  PurchaseContract.CorrespncInternalReference AS CorrespncInternalReference,
  PurchaseContract.CreatedByUser AS ContractCreateByUser,
  PurchaseContract.CreationDate AS ContractCreationDate,
  PurchaseContract.LastChangeDateTime AS ContractLastChangeDateTime,
  PurchaseContract.NetPaymentDays AS ContractNetPaymentDays,
  PurchaseContract.PaymentTerms AS ContractPaymentTerms,
  PurchaseContract.PurchaseContractTargetAmount AS PurchaseContractTargetAmount,
  PurchaseContract.PurchaseContractType AS PurchaseContractType,
  PurchaseContract.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  PurchaseContract.PurchasingDocumentName AS PurchasingDocumentName,
  PurchaseContract.QuotationSubmissionDate AS QuotationSubmissionDate,
  PurchaseContract.ReleaseCode AS ReleaseCode,
  PurchaseContract.SupplierQuotation AS SupplierQuotation,
  PurchaseContract.ValidityEndDate AS ValidityEndDate,
  PurchaseContract.ValidityStartDate AS ValidityStartDate,
  PurchaseContractItem.ConfirmationControl AS ConfirmationControl,
  PurchaseContractItem.ContractNetPriceAmount AS ContractNetPriceAmount,
  PurchaseContractItem.DeliveryAddressID AS DeliveryAddressID,
  PurchaseContractItem.IsInfoAtRegistration AS IsInfoAtRegistration,
  PurchaseContractItem.IsInfoRecordUpdated AS IsInfoRecordUpdated,
  PurchaseContractItem.IsOrderAcknRqd AS IsOrderAcknRqd,
  PurchaseContractItem.NoDaysReminder1 AS NoDaysReminder1,
  PurchaseContractItem.NoDaysReminder2 AS NoDaysReminder2,
  PurchaseContractItem.NoDaysReminder3 AS NoDaysReminder3,
  PurchaseContractItem.OrderQuantityUnit AS OrderQuantityUnit,
  PurchaseContractItem.PurchaseContractItemText AS PurchaseContractItemText,
  _PurchasingCategoryMatlGroup._PurchasingCategory.PurchasingCategory AS PurchasingCategory,
  PurchaseContractItem.PurchasingContractDeletionCode AS PurchasingContractDeletionCode,
  PurchaseContractItem.PurchasingDocumentItemCategory AS PurchasingDocumentItemCategory,
  PurchaseContractItem.PurgCatName AS PurgCatName,
  PurchaseContractItem.PurgDocEstimatedPrice AS PurgDocEstimatedPrice,
  PurchaseContractItem.PurgDocOrderAcknNumber AS PurgDocOrderAcknNumber,
  PurchaseContractItem.PurgDocPriceDate AS PurgDocPriceDate,
  PurchaseContractItem.PurgDocReleaseOrderQuantity AS PurgDocReleaseOrderQuantity,
  PurchaseContractItem.RequirementTracking AS RequirementTracking,
  PurchaseContractItem.ShippingInstruction AS ShippingInstruction,
  PurchaseContractItem.StockType AS StockType,
  PurchaseContractItem.Subcontractor AS Subcontractor,
  PurchaseContractItem.TargetAmount AS TargetAmount,
  PurchaseContractItem.TargetQuantity AS TargetQuantity,
  PurchaseContractItem.VolumeUnit AS VolumeUnit,
  cast( DAYS2GO_QUANT as mm_a_contract_days_left) AS DAYS2GO_QUANT
FROM P_PurchaseOrderItemPAI_03
LEFT OUTER JOIN I_PurchaseOrder AS PurchaseOrder ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PurchaseOrderItem AS PurchaseOrderItem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PurchaseContract AS PurchaseContract ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PurchaseContractItem AS PurchaseContractItem ON /* join condition not captured in parsed metadata */
INNER JOIN I_CalendarDate ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PurchasingCategoryMatlGroup AS _PurchasingCategoryMatlGroup ON MaterialGroup = _PurchasingCategoryMatlGroup.MaterialGroup  -- association [1..1]
;