I_PPS_PurchaseRequestItem

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_PPS_PurchaseRequestItem.
-- 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 I_PPS_PurchaseRequestItem AS
SELECT
  cast( _PPSPurRequestItem.PurchaseRequisition as pps_e_purchase_request ) AS PPSPurchaseRequest,
  cast( _PPSPurRequestItem.PurchaseRequisitionItem as pps_e_purchase_request_item ) AS PPSPurchaseRequestItem,
  _PPSPurRequestItem.PurchaseRequisition AS PurchaseRequisition,
  _PPSPurRequestItem.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  _PPSPurRequestItem.PurchaseRequisitionItemText AS PurchaseRequisitionItemText,
  cast( hextobin(_PPSPurRequestExtHeader.PPSPurchaseRequisitionKey) as pps_e_purchase_request_uuid preserving type ) AS PPSPurchaseRequestUUID,
  _PPSPurRequestItem.PurchasingDocument AS PurchasingDocument,
  cast( _PPSPurRequestItem.PurchaseRequisitionType as pps_e_purchase_request_type ) AS PPSPurchaseRequestType,
  _PPSPurRequestItem.PurchasingDocumentItemCategory AS PurchasingDocumentItemCategory,
  _PPSPurRequestItem.AccountAssignmentCategory AS AccountAssignmentCategory,
  _PPSPurRequestItem.Material AS Material,
  _PPSPurRequestItem.ManufacturerMaterial AS ManufacturerMaterial,
  _PPSPurRequestItem.ManufacturerPartProfile AS ManufacturerPartProfile,
  _PPSPurRequestItem.ManufacturerPartNmbr AS ManufacturerPartNmbr,
  _PPSPurRequestItem.MaterialGroup AS MaterialGroup,
  _PPSPurRequestItem.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  _PPSPurRequestItem.IsOutline AS IsOutline,
  _PPSPurRequestItem.PurchasingParentItem AS PurchasingParentItem,
  _PPSPurRequestItem.PurgConfigurableItemNumber AS PurgConfigurableItemNumber,
  _PPSPurRequestItem.PurgExternalSortNumber AS PurgExternalSortNumber,
  _PPSPurRequestItem.RequestedQuantity AS RequestedQuantity,
  _PPSPurRequestItem.BaseUnit AS BaseUnit,
  cast( _PPSPurRequestItem.PurchaseRequisitionPrice as pps_e_pur_request_price ) AS PPSPurchaseRequestPrice,
  cast( _PPSPurRequestItem.PurReqnPriceQuantity as pps_e_pur_request_price_qty ) AS PPSPurRequestPriceQuantity,
  _PPSPurRequestItem.MaterialGoodsReceiptDuration AS MaterialGoodsReceiptDuration,
  _PPSPurRequestItem.ReleaseCode AS ReleaseCode,
  _PPSPurRequestItem.PurchasingOrganization AS PurchasingOrganization,
  _PPSPurRequestItem.PurchasingGroup AS PurchasingGroup,
  _PPSPurRequestItem.Plant AS Plant,
  _PPSPurRequestItem.SourceOfSupplyIsAssigned AS SourceOfSupplyIsAssigned,
  _PPSPurRequestItem.SupplyingPlant AS SupplyingPlant,
  _PPSPurRequestItem.OrderedQuantity AS OrderedQuantity,
  _PPSPurRequestItem.DeliveryDate AS DeliveryDate,
  _PPSPurRequestItem.CreationDate AS CreationDate,
  _PPSPurRequestItem.ProcessingStatus AS ProcessingStatus,
  _PPSPurRequestItem.PurchasingInfoRecord AS PurchasingInfoRecord,
  _PPSPurRequestItem.TaxCalculationProcedure AS TaxCalculationProcedure,
  _PPSPurRequestItem.Supplier AS Supplier,
  _PPSPurRequestItem.IsDeleted AS IsDeleted,
  _PPSPurRequestItem.FixedSupplier AS FixedSupplier,
  _PPSPurRequestItem.RequisitionerName AS RequisitionerName,
  _PPSPurRequestItem.PurReqnSSPRequestor AS PurReqnSSPRequestor,
  _PPSPurRequestItem.CreatedByUser AS CreatedByUser,
  _PPSPurRequestItem.ManualDeliveryAddressID AS ManualDeliveryAddressID,
  cast ( _PPSPurRequestItem.PurReqnItemCurrency as pps_e_pur_request_itm_currency ) AS PPSPurchaseRequestItemCurrency,
  _PPSPurRequestItem.MaterialPlannedDeliveryDurn AS MaterialPlannedDeliveryDurn,
  _PPSPurRequestItem.DelivDateCategory AS DelivDateCategory,
  _PPSPurRequestItem.PurchasingSourceType AS PurchasingSourceType,
  _PPSPurRequestItem.MultipleAcctAssgmtDistribution AS MultipleAcctAssgmtDistribution,
  _PPSPurRequestItem.PartialInvoiceDistribution AS PartialInvoiceDistribution,
  _PPSPurRequestItem.StorageLocation AS StorageLocation,
  _PPSPurRequestItem.PurchaseContract AS PurchaseContract,
  _PPSPurRequestItem.PurchaseContractItem AS PurchaseContractItem,
  _PPSPurRequestItem.ConsumptionPosting AS ConsumptionPosting,
  _PPSPurRequestItem.Language AS Language,
  _PPSPurRequestItem.IsClosed AS IsClosed,
  _PPSPurRequestItem.ReleaseIsNotCompleted AS ReleaseIsNotCompleted,
  _PPSPurRequestItem.ServicePerformer AS ServicePerformer,
  _PPSPurRequestItem.ProductTypeCode AS ProductTypeCode,
  _PPSPurRequestItem.ReleaseStrategy AS ReleaseStrategy,
  _PPSPurRequestItem.PerformancePeriodStartDate AS PerformancePeriodStartDate,
  _PPSPurRequestItem.PerformancePeriodEndDate AS PerformancePeriodEndDate,
  _PPSPurRequestItem.SupplierMaterialNumber AS SupplierMaterialNumber,
  _PPSPurRequestItem.Batch AS Batch,
  _PPSPurRequestItem.MaterialRevisionLevel AS MaterialRevisionLevel,
  _PPSPurRequestItem.MinRemainingShelfLife AS MinRemainingShelfLife,
  _PPSPurRequestItem.GoodsReceiptIsExpected AS GoodsReceiptIsExpected,
  _PPSPurRequestItem.InvoiceIsExpected AS InvoiceIsExpected,
  _PPSPurRequestItem.GoodsReceiptIsNonValuated AS GoodsReceiptIsNonValuated,
  _PPSPurRequestItem.RequirementTracking AS RequirementTracking,
  _PPSPurRequestItem.MRPController AS MRPController,
  _PPSPurRequestItem.TaxCode AS TaxCode,
  _PPSPurRequestItem.PurchasingDocumentSubtype AS PurchasingDocumentSubtype,
  _PPSPurRequestItem.PFMTransDataFootprintUUID AS PFMTransDataFootprintUUID,
  _PPSPurRequestItem.ExpectedOverallLimitAmount AS ExpectedOverallLimitAmount,
  _PPSPurRequestItem.OverallLimitAmount AS OverallLimitAmount,
  _PPSPurRequestItem.PurContractForOverallLimit AS PurContractForOverallLimit,
  _PPSPurRequestItem.LastChangeDateTime AS LastChangeDateTime,
  _PPSPurRequestItem.PurchaseOrderPriceType AS PurchaseOrderPriceType,
  _PPSPurRequestItem.IsPurReqnOvrlRel AS IsPurReqnOvrlRel,
  _PPSPurRequestItem.IsActiveEntity AS IsActiveEntity,
  _PPSPurRequestItem.ExternalApprovalStatus AS ExternalApprovalStatus,
  _PPSPurRequestItem.ItemNetAmount AS ItemNetAmount,
  _PPSPurRequestItem.Customer AS Customer,
  _PPSPurRequestItem.CommitmentItem AS CommitmentItem,
  _PPSPurRequestItem.FundsCenter AS FundsCenter,
  _PPSPurRequestItem.Fund AS Fund,
  _PPSPurRequestItem.GrantID AS GrantID,
  _PPSPurRequestItem.FunctionalArea AS FunctionalArea,
  _PPSPurRequestItem.EarmarkedFundsDocument AS EarmarkedFundsDocument,
  _PPSPurRequestItem.EarmarkedFundsDocumentItem AS EarmarkedFundsDocumentItem,
  _PPSPurRequestItem.BudgetPeriod AS BudgetPeriod,
  _PPSPurRequestItem.CostCenter AS CostCenter,
  _PPSPurRequestItem.GLAccount AS GLAccount,
  _PPSPurRequestItem.WBSElementInternalID AS WBSElementInternalID,
  _PPSPurRequestItem.IsPurReqnCmplt AS IsPurReqnCmplt,
  _PPSPurRequestItem.CompanyCode AS CompanyCode,
  _PPSPurRequestItem.PPSPerdOfPerfStartDate AS PPSPerdOfPerfStartDate,
  _PPSPurRequestItem.PPSPerdOfPerfEndDate AS PPSPerdOfPerfEndDate,
  _PPSPurRequestItem.PPSSmartNumberItem AS PPSSmartNumberItem,
  _PPSPurRequestItem.PPSSmartNumberItemIsManual AS PPSSmartNumberItemIsManual,
  _PPSPurRequestItem.PPSResponsiblePurchaser AS PPSResponsiblePurchaser,
  _PPSPurRequestItem.PPSConfigurableLineItemNumber AS PPSConfigurableLineItemNumber,
  _PPSPurRequestItem.PPSEstimatedDeliveryDate AS PPSEstimatedDeliveryDate,
  _PPSPurRequestItem.PPSIsOptionalItem AS PPSIsOptionalItem,
  _PPSPurRequestItem.PPSOptionExerciseStartDate AS PPSOptionExerciseStartDate,
  _PPSPurRequestItem.PPSOptionExerciseEndDate AS PPSOptionExerciseEndDate,
  _PPSPurRequestItem.PPSOptionalItemStatus AS PPSOptionalItemStatus,
  _PPSPurRequestItem.PPSEarmarkedFundsDocument AS PPSEarmarkedFundsDocument,
  _PPSPurRequestItem.PPSIsIncrementalFundedItem AS PPSIsIncrementalFundedItem,
  cast( hextobin(_PPSPurRequestItem.PPSPurchaseRequisitionItemKey) as pps_e_pur_request_item_uuid preserving type ) AS PPSPurchaseRequestItemUUID,
  _PPSPurRequestItem.PPSFiscalYear AS PPSFiscalYear,
  _PPSPurRequestItem.PPSPurgDocItmDoblgnStatus AS PPSPurgDocItmDoblgnStatus,
  _PPSPurRequestItem.PPSAutoSourcingLogHandle AS PPSAutoSourcingLogHandle,
  _PPSPurRequestItem.PPSItemIsFullyFunded AS PPSItemIsFullyFunded,
  _PPSPurRequestItem.PurReqnItemCurrency AS PurReqnItemCurrency,
  _PPSPurRequestItem._CompanyCode AS _CompanyCode,
  _PPSPurRequestItem._Currency AS _Currency,
  _PPSPurRequestItem._DesiredSupplier AS _DesiredSupplier,
  _PPSPurRequestItem._Parent AS _Parent,
  _PPSPurRequestItem._Plant AS _Plant,
  _PPSPurRequestItem._PurchaseReqn AS _PurchaseReqn,
  _PPSPurRequestItem._PurReqnItemExtension AS _PurReqnItemExtension,
  _PPSPurRequestItem._Supplier AS _Supplier,
  _PPSPurRequestItem._SupplyingPlant AS _SupplyingPlant
FROM R_PPS_PurchaseReqnItem_2 AS _PPSPurRequestItem
INNER JOIN R_PPS_PurReqnHeaderExtension AS _PPSPurRequestExtHeader ON /* join condition not captured in parsed metadata */
;