A_PurchaseContractItem_2

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_2.
-- 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: APURCHASECTRIT2

CREATE VIEW A_PurchaseContractItem_2 AS
SELECT
  PurchaseContract,
  PurchaseContractItem,
  PurchasingContractDeletionCode,
  PurchaseContractItemText,
  CompanyCode,
  Plant,
  StorageLocation,
  RequirementTracking,
  MaterialGroup,
  SupplierMaterialNumber,
  OrderQuantityUnit,
  _OrderQuantityUnit.UnitOfMeasureISOCode AS OrderQuantityUnitISOCode,
  TargetQuantity,
  PurgDocReleaseOrderQuantity,
  OrderPriceUnit,
  _OrderPriceUnit.UnitOfMeasureISOCode AS OrderPriceUnitISOCode,
  OrderPriceUnitToOrderUnitNmrtr,
  OrdPriceUnitToOrderUnitDnmntr,
  ContractNetPriceAmount,
  DocumentCurrency,
  NetPriceQuantity,
  TaxCode,
  TaxCountry,
  TaxDeterminationDate,
  StockType,
  PurchasingInfoRecordUpdateCode,
  PriceIsToBePrinted,
  PurgDocEstimatedPrice AS PurchasingPriceIsEstimated,
  NoDaysReminder1,
  NoDaysReminder2,
  NoDaysReminder3,
  PlannedDeliveryDurationInDays,
  OverdelivTolrtdLmtRatioInPct,
  UnlimitedOverdeliveryIsAllowed,
  UnderdelivTolrtdLmtRatioInPct,
  PurchasingDocumentItemCategory,
  AccountAssignmentCategory,
  MultipleAcctAssgmtDistribution,
  GoodsReceiptIsExpected,
  GoodsReceiptIsNonValuated,
  InvoiceIsExpected,
  InvoiceIsGoodsReceiptBased,
  IsOrderAcknRqd,
  PurgDocOrderAcknNumber,
  ShippingInstruction,
  ManualDeliveryAddressID,
  VolumeUnit,
  _VolumeUnit.UnitOfMeasureISOCode AS PurContrVolumeUnitISOCode,
  IncotermsClassification,
  Subcontractor,
  EvaldRcptSettlmtIsAllowed,
  IncotermsLocation1,
  IncotermsLocation2,
  cast( ' ' as tminco_loc_1_id ) AS IncotermsLocation1Identifier,
  cast( ' ' as tminco_loc_2_id ) AS IncotermsLocation2Identifier,
  cast( ' ' as tminco_loc_d_id ) AS IncotermsDvtgLocIdentifier,
  cast( ' ' as tminco_loc_d_descr ) AS IncotermsDvtgLocDescription,
  Material,
  ServicePerformer,
  ProductTypeCode,
  MaterialType,
  PurContractItmReplnmtElmntType,
  PurgProdCmplncSupplierStatus,
  PurchaseContractItemFormatted,
  PurchasingParentItem,
  IsStatisticalItem AS IsOutline,
  PurgConfigurableItemNumber,
  PurgExternalSortNumber AS PurgDocExtRefSiblingSortNumber,
  _PurContrItmCnsmpnPercentage.ContractConsumptionInPct AS ContractConsumptionInPct,
  StockSegment,
  ProductSeasonYear,
  ProductSeason,
  ProductCollection,
  ProductTheme,
  ProductCharacteristic1,
  ProductCharacteristic2,
  ProductCharacteristic3,
  PurchaseOutlineAgreement,
  PurchaseOutlineAgreementItem,
  _PurContrItmCnsmpnOvrl.ContractItemConsumedQuantity AS ContractItemConsumedQuantity,
  _PurContrItmCnsmpnOvrl.ContrItemConsumedQuantityUnit AS ContrItemConsumedQuantityUnit,
  _PurContrItmCnsmpnOvrl.ContrItemOpenQty AS ContrItemOpenQty,
  _PurContrItmCnsmpnOvrl.ContrItemOpenQtyUnit AS ContrItemOpenQtyUnit
FROM I_PurchaseContractItem
LEFT OUTER JOIN A_PurchaseContract_2 AS _PurchaseContract ON PurchaseContract = _PurchaseContract.PurchaseContract  -- association [1..1]
LEFT OUTER JOIN A_PurchaseContractAccount_2 AS _PurCtrAccount ON PurchaseContract = _PurCtrAccount.PurchaseContract AND PurchaseContractItem = _PurCtrAccount.PurchaseContractItem  -- association [0..*]
LEFT OUTER JOIN A_PurContrItmCndnValdty AS _PurContrItemCndnValdty ON PurchaseContract = _PurContrItemCndnValdty.PurchaseContract AND PurchaseContractItem = _PurContrItemCndnValdty.PurchaseContractItem  -- association [1..*]
LEFT OUTER JOIN A_PurchaseContractAddress_2 AS _PurCtrAddress ON PurchaseContractItem = _PurCtrAddress.PurchaseContractItem AND PurchaseContract = _PurCtrAddress.PurchaseContract  -- association [1..*]
LEFT OUTER JOIN A_PurchaseContractItemNotes AS _PurCtrItemNotes ON PurchaseContractItemFormatted = _PurCtrItemNotes.ArchitecturalObjectNumber AND PurchaseContract = _PurCtrItemNotes.PurchaseContract AND PurchaseContractItem = _PurCtrItemNotes.PurchaseContractItem  -- association [0..*]
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..*]
LEFT OUTER JOIN I_PurContrItmCnsmpnPercentage AS _PurContrItmCnsmpnPercentage ON PurchaseContract = _PurContrItmCnsmpnPercentage.PurchaseContract AND PurchaseContractItem = _PurContrItmCnsmpnPercentage.PurchaseContractItem  -- association [1..1]
;