C_PurchaseContractItemDEX

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_PurchaseContractItemDEX.
-- 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: CMMPURCONTITMDEX

CREATE VIEW C_PurchaseContractItemDEX AS
SELECT
  PurchaseContract,
  PurchaseContractItem,
  DocumentCurrency,
  OrderQuantityUnit,
  TargetQuantity,
  StorageLocation,
  MaterialGroup,
  Material,
  ContractNetPriceAmount,
  NetPriceQuantity,
  PurchasingDocumentItemCategory,
  InvoiceIsExpected,
  PurchaseContractItemText,
  InvoiceIsGoodsReceiptBased,
  GoodsReceiptIsExpected,
  Plant,
  EvaldRcptSettlmtIsAllowed,
  TargetAmount,
  _PurchaseContractAPI01.PurchaseContractType AS PurchaseContractType,
  _PurchaseContractAPI01.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  _PurchaseContractAPI01.PurchasingGroup AS PurchasingGroup,
  _PurchaseContractAPI01.PurchasingOrganization AS PurchasingOrganization,
  _PurchaseContractAPI01.ValidityStartDate AS ValidityStartDate,
  _PurchaseContractAPI01.ValidityEndDate AS ValidityEndDate,
  _PurchaseContractAPI01.Supplier AS Supplier,
  _PurchaseContractAPI01.InvoicingParty AS InvoicingParty,
  _PurchaseContractAPI01.SupplyingSupplier AS SupplyingSupplier,
  _PurchaseContractAPI01.CreationDate AS CreationDate,
  _PurchaseContractAPI01.LastChangeDateTime AS LastChangeDateTime,
  cast ( _PurchaseContractAPI01.ExchangeRate as fis_exchange_rate preserving type) AS ExchangeRate,
  OrderPriceUnit,
  VolumeUnit,
  Customer,
  Subcontractor,
  ReferenceDeliveryAddressID,
  ManualDeliveryAddressID,
  cast ( DeliveryAddressID as adrn2_ll preserving type) AS DeliveryAddressID,
  AccountAssignmentCategory,
  MultipleAcctAssgmtDistribution,
  OrdPriceUnitToOrderUnitDnmntr,
  OrderPriceUnitToOrderUnitNmrtr,
  SupplierMaterialNumber,
  UnderdelivTolrtdLmtRatioInPct,
  PriceIsToBePrinted,
  SupplierConfirmationControlKey,
  OverdelivTolrtdLmtRatioInPct,
  UnlimitedOverdeliveryIsAllowed,
  PurgDocPriceDate,
  PurchasingInfoRecordUpdateCode,
  PurgDocReleaseOrderQuantity,
  PurgDocOrderAcknNumber,
  PurgDocEstimatedPrice AS PurchasingPriceIsEstimated,
  IsInfoAtRegistration,
  NoDaysReminder1,
  NoDaysReminder2,
  NoDaysReminder3,
  StockType,
  TaxCode,
  RequirementTracking,
  IsOrderAcknRqd,
  ShippingInstruction,
  GoodsReceiptIsNonValuated,
  ServicePerformer,
  ProductTypeCode,
  MaterialType,
  cast ( PurchaseContractItemFormatted as mm_pur_ctr_itm_frmtd preserving type) AS PurchaseContractItemFormatted,
  PurchasingContractDeletionCode,
  PurchaseContractItemUniqueID,
  PurchasingCategory,
  PurgCatName
FROM I_PurchaseContractItemAPI01
LEFT OUTER JOIN E_PurchasingDocument AS _HeaderExtension ON PurchaseContract = _HeaderExtension.PurchasingDocument  -- association [1]
LEFT OUTER JOIN E_PurchasingDocumentItem AS _ExtensionItem ON PurchaseContract = _ExtensionItem.PurchasingDocument AND PurchaseContractItem = _ExtensionItem.PurchasingDocumentItem  -- association [1]
LEFT OUTER JOIN C_PurchaseContractDEX AS _PurchaseContractDEX ON PurchaseContract = _PurchaseContractDEX.PurchaseContract  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _DocumentCurrency ON DocumentCurrency = _DocumentCurrency.Currency  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _OrderQuantityUnit ON OrderQuantityUnit = _OrderQuantityUnit.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_StorageLocation AS _StorageLocation ON Plant = _StorageLocation.Plant AND StorageLocation = _StorageLocation.StorageLocation  -- association [0..1]
LEFT OUTER JOIN I_ProductGroup_2 AS _ProductGroup ON MaterialGroup = _ProductGroup.ProductGroup  -- association [1..1]
LEFT OUTER JOIN I_Product AS _Product ON Material = _Product.Product  -- association [0..1]
LEFT OUTER JOIN I_PurgDocumentItemCategory AS _PurgDocumentItemCategory ON PurchasingDocumentItemCategory = _PurgDocumentItemCategory.PurchasingDocumentItemCategory  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN I_PurchaseContractType AS _PurchasingContractType ON PurchaseContractType = _PurchasingContractType.PurchaseContractType  -- association [0..1]
LEFT OUTER JOIN I_PurchasingDocumentCategory AS _PurchasingDocumentCategory ON PurchasingDocumentCategory = _PurchasingDocumentCategory.PurchasingDocumentCategory  -- association [1..1]
LEFT OUTER JOIN I_PurchasingGroup AS _PurchasingGroup ON PurchasingGroup = _PurchasingGroup.PurchasingGroup  -- association [1..1]
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganization ON PurchasingOrganization = _PurchasingOrganization.PurchasingOrganization  -- association [1..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _InvoicingParty ON InvoicingParty = _InvoicingParty.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _SupplyingSupplier ON SupplyingSupplier = _SupplyingSupplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _OrderPriceUnit ON OrderPriceUnit = _OrderPriceUnit.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _VolumeUnit ON VolumeUnit = _VolumeUnit.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Subcontractor ON Subcontractor = _Subcontractor.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Address_2 AS _ReferenceDeliveryAddress ON ReferenceDeliveryAddressID = _ReferenceDeliveryAddress.AddressID AND _ReferenceDeliveryAddress.AddressPersonID = '' AND _ReferenceDeliveryAddress.AddressRepresentationCode = ''  -- association [0..1]
LEFT OUTER JOIN I_Address_2 AS _ManualDeliveryAddress ON ManualDeliveryAddressID = _ManualDeliveryAddress.AddressID AND _ManualDeliveryAddress.AddressPersonID = '' AND _ManualDeliveryAddress.AddressRepresentationCode = ''  -- association [0..1]
LEFT OUTER JOIN I_Address_2 AS _DeliveryAddress ON DeliveryAddressID = _DeliveryAddress.AddressID AND _DeliveryAddress.AddressPersonID = '' AND _DeliveryAddress.AddressRepresentationCode = ''  -- association [0..1]
LEFT OUTER JOIN I_PurgInfoRecordUpdateCode AS _PurgInfoRecordUpdateCode ON PurchasingInfoRecordUpdateCode = _PurgInfoRecordUpdateCode.PurchasingInfoRecordUpdateCode  -- association [0..1]
LEFT OUTER JOIN I_InventoryUsabilityCode AS _StockType ON StockType = _StockType.InventoryUsabilityCode  -- association [0..1]
LEFT OUTER JOIN I_ShippingInstruction AS _ShippingInstruction ON ShippingInstruction = _ShippingInstruction.ShippingInstruction  -- association [1..1]
LEFT OUTER JOIN I_BusinessPartner AS _ServicePerformer ON ServicePerformer = _ServicePerformer.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_ProductTypeCode AS _ProductTypeCode ON ProductTypeCode = _ProductTypeCode.ProductTypeCode  -- association [0..1]
LEFT OUTER JOIN I_ProductType_2 AS _MaterialType ON MaterialType = _MaterialType.ProductType  -- association [0..1]
;