A_PurchaseContractItem

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 A_PurchaseContractItem.
-- 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: APURCHASECTRITM

CREATE VIEW A_PurchaseContractItem AS
SELECT
  PurchaseContract,
  PurchaseContractItem,
  PurchasingContractDeletionCode,
  PurchaseContractItemText,
  CompanyCode,
  Plant,
  StorageLocation,
  RequirementTracking,
  MaterialGroup,
  SupplierMaterialNumber,
  OrderQuantityUnit,
  TargetQuantity,
  PurgDocReleaseOrderQuantity,
  OrderPriceUnit,
  OrderPriceUnitToOrderUnitNmrtr,
  OrdPriceUnitToOrderUnitDnmntr,
  ContractNetPriceAmount,
  DocumentCurrency,
  NetPriceQuantity,
  TaxCode,
  TaxCountry,
  TaxDeterminationDate,
  StockType,
  IsInfoRecordUpdated,
  PriceIsToBePrinted,
  PurgDocEstimatedPrice,
  NoDaysReminder1,
  NoDaysReminder2,
  NoDaysReminder3,
  PlannedDeliveryDurationInDays,
  OverdelivTolrtdLmtRatioInPct,
  UnlimitedOverdeliveryIsAllowed,
  UnderdelivTolrtdLmtRatioInPct,
  PurchasingDocumentItemCategory,
  AccountAssignmentCategory,
  MultipleAcctAssgmtDistribution,
  GoodsReceiptIsExpected,
  GoodsReceiptIsNonValuated,
  InvoiceIsExpected,
  InvoiceIsGoodsReceiptBased,
  IsOrderAcknRqd,
  PurgDocOrderAcknNumber,
  ShippingInstruction,
  ManualDeliveryAddressID,
  VolumeUnit,
  Subcontractor,
  EvaldRcptSettlmtIsAllowed,
  Material,
  ServicePerformer,
  ProductType,
  MaterialType,
  PurContractItmReplnmtElmntType,
  FormattedPurchaseContractItem,
  PurchasingParentItem,
  IsStatisticalItem AS IsOutline,
  PurgConfigurableItemNumber,
  PurgExternalSortNumber AS PurgDocExtRefSiblingSortNumber
FROM I_PurchaseContractItem
LEFT OUTER JOIN A_PurchaseContract AS _PurchaseContract ON PurchaseContract = _PurchaseContract.PurchaseContract  -- association [1..1]
LEFT OUTER JOIN A_PurCtrAccount AS _PurCtrAccount ON PurchaseContract = _PurCtrAccount.PurchaseContract AND PurchaseContractItem = _PurCtrAccount.PurchaseContractItem  -- association [0..*]
LEFT OUTER JOIN A_PurContrItemCondition AS _PurContrItemCondition ON PurchaseContract = _PurContrItemCondition.PurchaseContract AND PurchaseContractItem = _PurContrItemCondition.PurchaseContractItem  -- association [1..*]
LEFT OUTER JOIN A_PurCtrAddress AS _PurCtrAddress ON PurchaseContractItem = _PurCtrAddress.PurchaseContractItem AND PurchaseContract = _PurCtrAddress.PurchaseContract  -- association [1..*]
LEFT OUTER JOIN E_PurchasingDocumentItem AS _PurchaseContractItemExtension ON PurchaseContract = _PurchaseContractItemExtension.PurchasingDocument AND PurchaseContractItem = _PurchaseContractItemExtension.PurchasingDocumentItem  -- association [0..1]
LEFT OUTER JOIN A_ValAddedSrvcMM AS _ValueAddedService ON PurchaseContract = _ValueAddedService.ValAddedSrvcMMRefDocNmbr AND PurchaseContractItem = _ValueAddedService.ValAddedSrvcMMRefDocItem  -- association [1..*]
;