C_Procurementitems

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 C_Procurementitems.
-- 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: CPRCRSRCHITM

CREATE VIEW C_Procurementitems AS
SELECT
  prcrmntitm.OpnCtlgItemID AS OpnCtlgItemID,
  _ItemDesc.Language AS Language,
  prcrmntitm.OpnCtlgPriceID AS OpnCtlgPriceID,
  _ItemDesc.ProductDescription AS ProductDescription,
  prcrmntitm. ManufacturerName AS ManufacturerName,
  prcrmntitm.OpnCtlgMfrMaterialNumber AS ManufacturerMaterial,
  prcrmntitm.OpnCtlgHasPriceScale AS OpnCtlgHasPriceScale,
  prcrmntitm.ProductCatalogName AS ProductCatalogName,
  prcrmntitm.OpnCtlgIntCatalogName AS OpnCtlgIntCatalogName,
  prcrmntitm.OpnCtlgIsServiceMaterialType AS Service,
  prcrmntitm.Material AS Material,
  prcrmntitm.OpenCatalogMaterialGroup AS MaterialGroup,
  prcrmntitm.OpnCtlgSrchLongText AS OpnCtlgSrchLongText,
  prcrmntitm.MaterialGroupName AS MaterialGroupName,
  prcrmntitm.OpnCtlgSupplierName AS OpnCtlgSupplierName,
  prcrmntitm.Manufacturer AS Manufacturer,
  prcrmntitm.OpnCtlgSupplierID AS OpnCtlgSupplierID,
  prcrmntitm.OpnCtlgMaterialIDBySupplier AS OpnCtlgMaterialIDBySupplier,
  cast( prcrmntitm.OpenCatalogUnitOfMeasure as meins ) AS UnitOfMeasure,
  prcrmntitm.OpnCtlgItemPrice AS OpnCtlgItemPrice,
  prcrmntitm.CalculatedPrice AS CalculatedPrice,
  prcrmntitm.OpnCtlgItemCurrency AS OpnCtlgItemCurrency,
  prcrmntitm.ProductType AS ProductType,
  prcrmntitm.OpnCtlgCategoryID AS OpnCtlgCategoryID,
  prcrmntitm.OpnCtlgHasProdRelationExists AS OpnCtlgHasProdRelationExists,
  prcrmntitm.OpnCtlgMainImageName AS OpnCtlgMainImageName,
  prcrmntitm.OpnCtlgMainImageURL AS OpnCtlgMainImageURL,
  prcrmntitm.OpnCtlgMainImageText AS OpnCtlgMainImageText,
  prcrmntitm.OpnCtlgMainImageID AS OpnCtlgMainImageID,
  prcrmntitm.OpnCtlgPrcAmountInComCurrency AS OpnCtlgPrcComCurrency,
  prcrmntitm.OpnCtlgComCurrencyID AS OpnCtlgComCurrencyID,
  prcrmntitm.PricingScaleType AS PricingScaleType,
  prcrmntitm.OpnCtlgExternalProductID AS OpnCtlgExternalProductID,
  prcrmntitm.OpnCtlgWebServiceID AS OpnCtlgWebServiceID,
  prcrmntitm.OpnCtlgWebServiceName AS OpnCtlgWebServiceName,
  prcrmntitm.ItemType AS ItemType,
  prcrmntitm.OpnCtlgItemPriceQuantityValue AS NetPriceQuantity,
  prcrmntitm.OpnCtlgContentUnit AS OpnCtlgContentUnit,
  prcrmntitm.OpenCatalogPackingQuantityVal AS OpnCtlgPackingQty,
  prcrmntitm.OpnCtlgMinOrderQuantityValue AS OpnCtlgMinOrderQuantity,
  prcrmntitm.OpnCtlgMatlFixedLotSizeQtyVal AS MaterialFixedLotSizeQuantity,
  prcrmntitm.OpenCatalogReferenceContractID AS ContractAccount,
  prcrmntitm.OpnCtlgContractItem AS OpnCtlgContractItem,
  prcrmntitm.OpnCtlgExternalQuoteID AS OpnCtlgExternalQuoteID,
  prcrmntitm.OpnCtlgExtQuoteItem AS OpnCtlgExtQuoteItem,
  prcrmntitm.OpnCtlgExtSchemaType AS OpnCtlgExtSchemaType,
  prcrmntitm.OpnCtlgExternalCategoryID AS OpnCtlgExternalCategoryID,
  prcrmntitm.OpnCtlgExternalCategory AS OpnCtlgExternalCategory,
  prcrmntitm.OpenCatalogUserRatingValue AS UsageRating,
  prcrmntitm.ParentItem AS ParentItem,
  prcrmntitm.IsOpnCtlgManaged AS IsOpnCtlgManaged,
  prcrmntitm.IsOpnCtlgItmFrmMatlMstr AS IsOpnCtlgItmFrmMatlMstr,
  prcrmntitm.IsOpnCtlgItem AS IsOpnCtlgItem,
  prcrmntitm.OpnCtlgChangedDateTimeValue AS ChangedDateTime,
  prcrmntitm.OpnCtlgChangedBy AS OpnCtlgChangedBy,
  prcrmntitm.OpnCtlgItemSustainCompliance AS OpnCtlgItemSustainCompliance,
  prcrmntitm.OpnCtlgDirectEmissionValue AS OpnCtlgDirectEmissionValue,
  prcrmntitm.OpnCtlgDirectEmissionUnit AS OpnCtlgDirectEmissionUnit,
  prcrmntitm.OpnCtlgIndrctEmissionValue AS OpnCtlgIndrctEmissionValue,
  prcrmntitm.OpnCtlgIndrctEmissionUnit AS OpnCtlgIndrctEmissionUnit,
  prcrmntitm.OpnCtlgTempEmissionValue AS OpnCtlgTempEmissionValue,
  prcrmntitm.OpnCtlgTempEMissionUnit AS OpnCtlgTempEMissionUnit,
  prcrmntitm.OpnCtlgRecycleValue AS OpnCtlgRecycleValue,
  prcrmntitm.OpnCtlgRecycleUnit AS OpnCtlgRecycleUnit,
  prcrmntitm.OpnCtlgWaterConsumptionValue AS OpnCtlgWaterConsumptionValue,
  prcrmntitm.OpnCtlgWaterConsumptionUnit AS OpnCtlgWaterConsumptionUnit,
  prcrmntitm.OpnCtlgEnergyConsumptionValue AS OpnCtlgEnergyConsumptionValue,
  prcrmntitm.OpnCtlgEnergyConsumptionUnit AS OpnCtlgEnergyConsumptionUnit,
  prcrmntitm.OpnCtlgWasteGeneratedValue AS OpnCtlgWasteGeneratedValue,
  prcrmntitm.OpnCtlgWasteGeneratedUnit AS OpnCtlgWasteGeneratedUnit,
  prcrmntitm.LogicalSystem AS LogicalSystem,
  prcrmntitm.OpnCtlgSystemName AS OpnCtlgSystemName,
  prcrmntitm.SourceLogicalSystem AS SourceLogicalSystem,
  prcrmntitm.Decimals AS Decimals,
  prcrmntitm.OpnCtlgLeadTmeAnncmntDuDaysVal AS LeadTimeAnncmntDueInDays,
  prcrmntitm.OpnCtlgPriceValdtyStartDteVal AS OpnCtlgPrcValidityStartDate,
  prcrmntitm.OpnCtlgPriceValdtyEndDteVal AS OpnCtlgPrcValidityEndDate,
  prcrmntitm.TaxTolerancePercent AS TaxTolerancePercent,
  prcrmntitm.PurchasingDocumentItem AS PurchasingDocumentItem,
  prcrmntitm.OrderPriceUnitQty AS PurchasingDocumentPriceUnit,
  prcrmntitm.OrderQuantityUnit AS PurchasingDocumentOrderQty,
  prcrmntitm.PurchasingDocument AS PurchasingDocument,
  prcrmntitm.PurReqnSourceOfSupplyType AS PurchasingDocumentType,
  prcrmntitm.ValidityStartDate AS ValidityStartDate,
  prcrmntitm.NetPriceAmount AS NetPriceAmount,
  prcrmntitm.PlantName AS PlantName,
  prcrmntitm.CompanyCode AS CompanyCode,
  prcrmntitm.ValidityEndDate AS ValidityEndDate,
  prcrmntitm.BaseUnit AS BaseUnit,
  prcrmntitm.Currency AS Currency,
  prcrmntitm.SourceOfSupplyIsFixed AS SourceOfSupplyIsFixed,
  prcrmntitm.SourceOfSupplyIsBlocked AS SourceOfSupplyIsBlocked,
  prcrmntitm.OpnCtlgSourceListValidFromDate AS ValidFrom,
  prcrmntitm.OpnCtlgSourceListValidToDate AS ValidTo,
  prcrmntitm.PurchasingOrganization AS PurchasingOrganization,
  prcrmntitm.OpnCtlgArchivingStatus AS ArchivingStatus,
  prcrmntitm.OpnCtlgPriceValidToDateTime AS PriceValidityEndDate,
  prcrmntitm.OpnCtlgPriceValidFromDateTime AS PriceValidityStartDate,
  cast(0 as abap.int4( 10 )) AS OpnCtlgNumberOfHits,
  cast('' as abap.char( 1 )) AS PriceInformationIsRequired,
  prcrmntitm.OpnCtlgFilterValue AS OpnCtlgFilterValue
FROM I_Catalogitem AS prcrmntitm
;