I_CntrlPurchaseContractItem

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_CntrlPurchaseContractItem.
-- 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: ICNTRLPCONITM

CREATE VIEW I_CntrlPurchaseContractItem AS
SELECT
  CentralPurchaseContract,
  CentralPurchaseContractItem,
  ActivePurchasingDocument,
  PurchasingDocumentSubtype,
  PurchasingGroup,
  PurchasingOrganization,
  PurchaseContractType,
  IsEndOfPurposeBlocked,
  PurgDocChangeRequestStatus,
  cast (Product as matnr preserving type ) AS Material,
  PurchaseContractItemText,
  ContractNetPriceAmount,
  OrderPriceUnit,
  VolumeUnit,
  OrderQuantityUnit,
  cast (ProductGroup as matkl preserving type ) AS MaterialGroup,
  Customer,
  Subcontractor,
  cast ( ' ' as ad_addrnum ) AS ManualDeliveryAddressID,
  cast ('' as adrnr ) AS DeliveryAddressID,
  Plant,
  StorageLocation,
  AccountAssignmentCategory,
  GoodsReceiptIsExpected,
  NetPriceQuantity,
  MultipleAcctAssgmtDistribution,
  PricingDateControl,
  TargetQuantity,
  TargetAmount,
  DocumentCurrency,
  OrdPriceUnitToOrderUnitDnmntr,
  PurchasingDocumentItemCategory,
  SupplierMaterialNumber,
  EvaldRcptSettlmtIsAllowed,
  UnderdelivTolrtdLmtRatioInPct,
  PriceIsToBePrinted,
  SupplierConfirmationControlKey,
  OverdelivTolrtdLmtRatioInPct,
  UnlimitedOverdeliveryIsAllowed,
  InvoiceIsExpected,
  InvoiceIsGoodsReceiptBased,
  PurgDocPriceDate,
  PurchasingInfoRecordUpdateCode AS IsInfoRecordUpdated,
  PurgDocReleaseOrderQuantity,
  PurgDocOrderAcknNumber,
  PurchasingPriceIsEstimated AS PurgDocEstimatedPrice,
  cast (IsInfoAtRegistration as mm_oa_infoatregn) AS IsInfoAtRegistration,
  NoDaysReminder1,
  NoDaysReminder2,
  NoDaysReminder3,
  StockType,
  TaxCode,
  RequirementTracking,
  IsOrderAcknRqd,
  ShippingInstruction,
  GoodsReceiptIsNonValuated,
  ServicePerformer,
  ProductTypeCode AS ProductType,
  ProductTypeCode,
  MaterialType,
  PurchaseContractItemFormatted AS FormattedPurchaseContractItem,
  PurchaseContractItemFormatted,
  PurchasingContractDeletionCode,
  PurchaseRequisition,
  PurchaseRequisitionItem,
  PartialInvoiceDistribution,
  PurchasingCentralMaterial,
  ProcmtHubExtReferencedMaterial,
  ProcmtHubRefcdConnectedSystem,
  CntrlPurContrItmTargetAmount,
  PurgDocItmBlkRsnCode,
  PurgDocItemRenegotiationStatus,
  PurchasingParentItem,
  IsStatisticalItem,
  PurgConfigurableItemNumber,
  PurgDocAggrgdSubitemCategory,
  PurgExternalSortNumber,
  PlannedDeliveryDurationInDays
FROM R_CntrlPurchaseContractItem
LEFT OUTER JOIN I_CentralPurchaseContract AS _CentralPurchaseContract ON CentralPurchaseContract = _CentralPurchaseContract.CentralPurchaseContract  -- association [1..1]
LEFT OUTER JOIN I_CntrlPurContrDistribution AS _CntrlPurContrDistribution ON CentralPurchaseContract = _CntrlPurContrDistribution.CentralPurchaseContract AND CentralPurchaseContractItem = _CntrlPurContrDistribution.CentralPurchaseContractItem  -- association [0..*]
LEFT OUTER JOIN I_CntrlPurContrItemCondition AS _CntrlPurContrItemCondition ON CentralPurchaseContract = _CntrlPurContrItemCondition.CentralPurchaseContract AND CentralPurchaseContractItem = _CntrlPurContrItemCondition.CentralPurchaseContractItem  -- association [1..*]
LEFT OUTER JOIN I_CntrlPurContrItmCndnValdty AS _CntrlPurContrItmCndnValdty ON CentralPurchaseContractItem = _CntrlPurContrItmCndnValdty.CentralPurchaseContractItem AND CentralPurchaseContract = _CntrlPurContrItmCndnValdty.CentralPurchaseContract  -- association [1..*]
;