C_PurOrdItemEnh

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_PurOrdItemEnh.
-- 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: CPURORDITEMENH

CREATE VIEW C_PurOrdItemEnh AS
SELECT
  PurchaseOrder,
  cast (PurchaseOrderItem as ebelp preserving type) AS PurchaseOrderItem,
  PurchaseOrderItemCategory,
  Material,
  ManufacturerMaterial,
  MaterialGroup,
  Plant,
  _Plant.PlantName AS PlantName,
  cast (I_PurchaseorderItemEnhanced.AccountAssignmentCategory as knttp_ll preserving type) AS AccountAssignmentCategory,
  PurchaseOrderItemText,
  PurchaseRequisition,
  PurchaseRequisitionItem,
  ProductType,
  FirstDeliveryDate,
  OrderQuantity,
  PurchaseOrderQuantityUnit,
  DocumentCurrency,
  PurchaseOrderPriceUnit,
  NetPriceAmount,
  OrderPriceUnit,
  PurchaseOrderNetPriceQuantity,
  NetAmount,
  PurchasingDocumentDeletionCode,
  ServicePerformer,
  PerformancePeriodStartDate,
  PerformancePeriodEndDate,
  _PurchaseOrderItemCalcFields._PurchaseOrderItemStatus._PurchasingDocumentStatus._Text[1: Language = $session.system_language].PurchasingDocumentStatusName AS PurchaseOrderItemStatus,
  PFMTransDataFootprintUUID,
  _PurOrdItemCO2eqFootprint.PFMFootprintQuantity AS PFMFootprintQuantity,
  _PurOrdItemCO2eqFootprint.PFMFootprintUnit AS PFMFootprintUnit,
  PurchaseOrderType,
  PurchasingOrganization,
  PurchasingGroup,
  cast (I_PurchaseorderItemEnhanced.UnderdelivTolrtdLmtRatioInPct as untto_ll preserving type) AS UnderdelivTolrtdLmtRatioInPct,
  cast (I_PurchaseorderItemEnhanced.UnlimitedOverdeliveryIsAllowed as uebtk preserving type) AS UnlimitedOverdeliveryIsAllowed,
  I_PurchaseorderItemEnhanced.IsToBeAcceptedAtOrigin AS IsToBeAcceptedAtOrigin,
  I_PurchaseorderItemEnhanced.StorageLocation AS StorageLocation,
  cast (I_PurchaseorderItemEnhanced.IntrastatServiceCode as mm_isvco_ll preserving type) AS IntrastatServiceCode,
  I_PurchaseorderItemEnhanced.CommodityCode AS CommodityCode,
  ShippingInstruction,
  I_PurchaseorderItemEnhanced.FinancialChain AS FinancialChain,
  I_PurchaseorderItemEnhanced.IncotermsClassification AS IncotermsClassification,
  I_PurchaseorderItemEnhanced.IncotermsLocation1 AS IncotermsLocation1,
  I_PurchaseorderItemEnhanced.IncotermsLocation2 AS IncotermsLocation2,
  cast (I_PurchaseorderItemEnhanced.PurchasingInfoRecord as infnr_ll preserving type) AS PurchasingInfoRecord,
  cast (I_PurchaseorderItemEnhanced._PurchaseContract.PurchaseContract as konnr_ll preserving type) AS PurchaseContract,
  I_PurchaseorderItemEnhanced.PurContractForOverallLimit AS PurContractForOverallLimit,
  cast (I_PurchaseorderItemEnhanced._PurchaseContractItem.PurchaseContractItem as ktpnr_ll preserving type) AS PurchaseContractItem,
  I_PurchaseorderItemEnhanced.InfoRecordIsToBeUpdated AS InfoRecordIsToBeUpdated,
  TaxCode,
  I_PurchaseorderItemEnhanced.TaxJurisdiction AS TaxJurisdiction,
  _Plant._OrganizationAddress[1: AddressRepresentationCode = '']._Country.TaxCalculationProcedure AS TaxCalculationProcedure,
  SupplierConfirmationControlKey,
  PurgDocOrderAcknNumber,
  IsOrderAcknRqd,
  ItemIsRejectedBySupplier,
  RequisitionerName
FROM I_PurchaseorderItemEnhanced
LEFT OUTER JOIN I_MaterialGroupText AS _MaterialGroupText ON MaterialGroup = _MaterialGroupText.MaterialGroup AND _MaterialGroupText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON Material = _MaterialText.Material AND _MaterialText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ProductTypeCodeText AS _ProductTypeCodeText ON _ProductTypeCodeText.ProductTypeCode = ProductType AND _ProductTypeCodeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN E_PurchasingDocumentItem AS _ItemExtension ON _ItemExtension.PurchasingDocument = PurchaseOrder AND _ItemExtension.PurchasingDocumentItem = PurchaseOrderItem  -- association [0..1]
LEFT OUTER JOIN I_PurgDocumentItemCategoryText AS _PurchaseOrderItemCategoryText ON _PurchaseOrderItemCategoryText.Language = $session.system_language AND _PurchaseOrderItemCategoryText.PurchasingDocumentItemCategory = PurchaseOrderItemCategory  -- association [1..1]
LEFT OUTER JOIN I_AcctAssignmentCategoryText AS _AcctAssignmentCategoryText ON _AcctAssignmentCategoryText.AccountAssignmentCategory = AccountAssignmentCategory AND _AcctAssignmentCategoryText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN C_MM_PlantValueHelp AS _PlantValHelp ON _PlantValHelp.Plant = Plant AND _PlantValHelp.PurchasingOrganization = PurchasingOrganization  -- association [0..1]
LEFT OUTER JOIN I_PurchaseOrderScheduleLine AS _PurOrdScheduleLine ON _PurOrdScheduleLine.PurchaseOrder = PurchaseOrder AND _PurOrdScheduleLine.PurchaseOrderItem = PurchaseOrderItem  -- association [1..*]
LEFT OUTER JOIN C_POScheduleLineFactSheet AS _POScheduleLineFactSheet ON _POScheduleLineFactSheet.PurchaseOrder = PurchaseOrder AND _POScheduleLineFactSheet.PurchaseOrderItem = PurchaseOrderItem  -- association [1..*]
LEFT OUTER JOIN C_POAccountAssignmentFactSheet AS _POAccountAssignmentFactSheet ON _POAccountAssignmentFactSheet.PurchaseOrder = PurchaseOrder AND _POAccountAssignmentFactSheet.PurchaseOrderItem = PurchaseOrderItem  -- association [1..*]
LEFT OUTER JOIN E_PurchasingDocumentItem AS _PurchaseOrderItemExtension ON PurchaseOrder = _PurchaseOrderItemExtension.PurchasingDocument AND PurchaseOrderItem = _PurchaseOrderItemExtension.PurchasingDocumentItem  -- association [1..1]
LEFT OUTER JOIN C_PODeliveryAddressFactSheet AS _PODeliveryAddressFactSheet ON PurchaseOrder = _PODeliveryAddressFactSheet.PurchaseOrder AND PurchaseOrderItem = _PODeliveryAddressFactSheet.PurchaseOrderItem  -- association [1..1]
LEFT OUTER JOIN C_MM_TaxCodeValueHelp AS _TaxCodeVH ON _TaxCodeVH.TaxCode = TaxCode AND _TaxCodeVH.TaxCalculationProcedure = TaxCalculationProcedure  -- association [0..1]
LEFT OUTER JOIN C_PurOrdItemCO2eqFootprint AS _PurOrdItemCO2eqFootprint ON _PurOrdItemCO2eqFootprint.PurchaseOrder = PurchaseOrder AND _PurOrdItemCO2eqFootprint.PurchaseOrderItem = PurchaseOrderItem  -- association [1..1]
LEFT OUTER JOIN I_FinancialChainText AS _FinancialChainText ON _FinancialChainText.FinancialChain = FinancialChain AND _FinancialChainText.Language = $session.system_language  -- association [1..1]
;