R_PPS_ProcPurReqnAutoSrcItemHN

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_PPS_ProcPurReqnAutoSrcItemHN.
-- 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_PPS_ProcPurReqnAutoSrcItemHN AS
SELECT
  PurchaseRequisitionItem.PurchaseRequisition AS PurchaseRequisition,
  PurchaseRequisitionItem.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  PurchaseRequisitionItem.PurchasingDocument AS PurchasingDocument,
  PurchaseRequisitionItem.PurchasingDocumentItem AS PurchasingDocumentItem,
  PurchaseRequisitionItem.PurReqnReleaseStatus AS PurReqnReleaseStatus,
  PurchaseRequisitionItem.PurchaseRequisitionType AS PurchaseRequisitionType,
  PurchaseRequisitionItem.PurchasingDocumentItemCategory AS PurchasingDocumentItemCategory,
  PurchaseRequisitionItem.PurchaseRequisitionItemText AS PurchaseRequisitionItemText,
  PurchaseRequisitionItem.AccountAssignmentCategory AS AccountAssignmentCategory,
  PurchaseRequisitionItem.Material AS Material,
  PurchaseRequisitionItem.ManufacturerMaterial AS ManufacturerMaterial,
  PurchaseRequisitionItem.ManufacturerPartProfile AS ManufacturerPartProfile,
  PurchaseRequisitionItem.ManufacturerPartNmbr AS ManufacturerPartNmbr,
  PurchaseRequisitionItem.MaterialGroup AS MaterialGroup,
  PurchaseRequisitionItem.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  PurchaseRequisitionItem.RequestedQuantity AS RequestedQuantity,
  PurchaseRequisitionItem.BaseUnit AS BaseUnit,
  PurchaseRequisitionItem.PurReqnPriceQuantity AS PurReqnPriceQuantity,
  PurchaseRequisitionItem.MaterialGoodsReceiptDuration AS MaterialGoodsReceiptDuration,
  PurchaseRequisitionItem.ReleaseCode AS ReleaseCode,
  PurchaseRequisitionItem.PurchaseRequisitionReleaseDate AS PurchaseRequisitionReleaseDate,
  PurchaseRequisitionItem.PurchasingOrganization AS PurchasingOrganization,
  PurchaseRequisitionItem.PurchasingGroup AS PurchasingGroup,
  PurchaseRequisitionItem.Plant AS Plant,
  PurchaseRequisitionItem.SourceOfSupplyIsAssigned AS SourceOfSupplyIsAssigned,
  PurchaseRequisitionItem.SupplyingPlant AS SupplyingPlant,
  PurchaseRequisitionItem.OrderedQuantity AS OrderedQuantity,
  PurchaseRequisitionItem.DeliveryDate AS DeliveryDate,
  PurchaseRequisitionItem.CreationDate AS CreationDate,
  PurchaseRequisitionItem.ProcessingStatus AS ProcessingStatus,
  PurchaseRequisitionItem.PurchasingInfoRecord AS PurchasingInfoRecord,
  PurchaseRequisitionItem.Supplier AS Supplier,
  PurchaseRequisitionItem.IsDeleted AS PurgDocumentItemDeletionCode,
  PurchaseRequisitionItem.FixedSupplier AS FixedSupplier,
  PurchaseRequisitionItem.RequisitionerName AS RequisitionerName,
  PurchaseRequisitionItem.PurReqnSSPRequestor AS PurReqnSSPRequestor,
  PurchaseRequisitionItem.CreatedByUser AS CreatedByUser,
  cast( PurchaseRequisitionItem.PurReqCreationDate as abap.dats ) AS PurReqCreationDate,
  PurchaseRequisitionItem.ManualDeliveryAddressID AS ManualDeliveryAddressID,
  PurchaseRequisitionItem.ItemDeliveryAddressID AS ItemDeliveryAddressID,
  PurchaseRequisitionItem.PurReqnItemCurrency AS PurReqnItemCurrency,
  PurchaseRequisitionItem.MaterialPlannedDeliveryDurn AS MaterialPlannedDeliveryDurn,
  PurchaseRequisitionItem.DelivDateCategory AS DelivDateCategory,
  PurchaseRequisitionItem.MultipleAcctAssgmtDistribution AS MultipleAcctAssgmtDistribution,
  PurchaseRequisitionItem.PartialInvoiceDistribution AS PartialInvoiceDistribution,
  PurchaseRequisitionItem.StorageLocation AS StorageLocation,
  PurchaseRequisitionItem.PurchaseContract AS PurchaseContract,
  cast( PurchaseRequisitionItem.PurReqnSourceOfSupplyType as abap.char( 1 ) ) AS PurReqnSourceOfSupplyType,
  PurchaseRequisitionItem.PurchaseContractItem AS PurchaseContractItem,
  PurchaseRequisitionItem.ConsumptionPosting AS ConsumptionPosting,
  PurchaseRequisitionItem.PurReqnOrigin AS PurReqnOrigin,
  PurchaseRequisitionItem.PurReqnItemBlockingStatus AS PurReqnItemBlockingStatus,
  PurchaseRequisitionItem.Language AS Language,
  PurchaseRequisitionItem.IsClosed AS IsClosed,
  PurchaseRequisitionItem.ReleaseIsNotCompleted AS ReleaseIsNotCompleted,
  PurchaseRequisitionItem.ServicePerformer AS ServicePerformer,
  PurchaseRequisitionItem.ProductTypeCode AS ProductTypeCode,
  cast ( case when PurchaseRequisitionItem.ProductTypeCode = '' then 'PS' else PurchaseRequisitionItem.ProductTypeCode end as abap.char( 2 ) ) as PPSProdTypeCodeInternal AS char2asPPSProdTypeCodeInternal,
  PurchaseRequisitionItem.PurchaseRequisitionStatus AS PurchaseRequisitionStatus,
  PurchaseRequisitionItem.ReleaseStrategy AS ReleaseStrategy,
  PurchaseRequisitionItem.PerformancePeriodStartDate AS PerformancePeriodStartDate,
  PurchaseRequisitionItem.PerformancePeriodEndDate AS PerformancePeriodEndDate,
  PurchaseRequisitionItem.SupplierMaterialNumber AS SupplierMaterialNumber,
  PurchaseRequisitionItem.Batch AS Batch,
  PurchaseRequisitionItem.MaterialRevisionLevel AS MaterialRevisionLevel,
  PurchaseRequisitionItem.MinRemainingShelfLife AS MinRemainingShelfLife,
  PurchaseRequisitionItem.GoodsReceiptIsExpected AS GoodsReceiptIsExpected,
  PurchaseRequisitionItem.InvoiceIsExpected AS InvoiceIsExpected,
  PurchaseRequisitionItem.GoodsReceiptIsNonValuated AS GoodsReceiptIsNonValuated,
  PurchaseRequisitionItem.RequirementTracking AS RequirementTracking,
  PurchaseRequisitionItem.MRPController AS MRPController,
  PurchaseRequisitionItem.TaxCode AS TaxCode,
  PurchaseRequisitionItem.PurchaseRequisitionIsFixed AS PurchaseRequisitionIsFixed,
  PurchaseRequisitionItem.PurchasingDocumentSubtype AS PurchasingDocumentSubtype,
  PurchaseRequisitionItem.PFMTransDataFootprintUUID AS PFMTransDataFootprintUUID,
  PurchaseRequisitionItem.PurReqnCatalog AS PurReqnCatalog,
  PurchaseRequisitionItem.PurReqnCatalogItem AS PurReqnCatalogItem,
  PurchaseRequisitionItem.PurReqnCrossCatalogItem AS PurReqnCrossCatalogItem,
  PurchaseRequisitionItem.PurContractForOverallLimit AS PurContractForOverallLimit,
  PurchaseRequisitionItem.PurchaseReqnItemUniqueID AS PurchaseReqnItemUniqueID,
  PurchaseRequisitionItem.IsPurReqnOvrlRel AS IsPurReqnOvrlRel,
  cast( PurchaseRequisitionItem.ItemNetAmount as abap.curr(15,2) ) AS ItemNetAmount,
  PurchaseRequisitionItem.ExternalApprovalStatus AS ExternalApprovalStatus,
  PurchaseRequisitionItem.IsOutline AS PurchasingIsItemSet,
  PurchaseRequisitionItem.PurchasingParentItem AS PurchasingParentItem,
  PurchaseRequisitionItem.PurReqnItemOutlineType AS PurReqnItemOutlineType,
  PurchaseRequisitionItem.PurgConfigurableItemNumber AS PurgConfigurableItemNumber,
  PurchaseRequisitionItem.PurgExternalSortNumber AS PurgExternalSortNumber,
  PurchaseRequisitionItem.CompanyCode AS CompanyCode,
  _PurReqnItemExtension.PPSPurReqnItemStatus AS PPSPurReqnItemStatus
FROM R_PPS_PurchaseRequisitionItem AS PurchaseRequisitionItem
INNER JOIN I_PPS_PurchaseReqnDocumentType AS _PurchaseRequisitionDocType ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN R_PPS_ProcPurReqnAutoSrcItemHN AS _Parent ON PurchaseRequisition = _Parent.PurchaseRequisition AND PurchasingParentItem = _Parent.PurchaseRequisitionItem  -- association [0..1]
LEFT OUTER JOIN R_PPS_PurReqnItemExtension AS _PurReqnItemExtension ON PurchaseRequisition = _PurReqnItemExtension.PurchaseRequisition AND PurchaseRequisitionItem = _PurReqnItemExtension.PurchaseRequisitionItem  -- association [1..1]
;