A_PurchaseContract_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_PurchaseContract_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: APURCONTRACT2

CREATE VIEW A_PurchaseContract_2 AS
SELECT
  ActivePurchasingDocument AS PurchaseContract,
  PurchaseContractType,
  CompanyCode,
  PurchasingDocumentDeletionCode,
  CreationDate,
  CreatedByUser,
  Supplier,
  PurchasingOrganization,
  PurchasingGroup,
  PaymentTerms,
  CashDiscount1Days,
  CashDiscount2Days,
  NetPaymentDays,
  CashDiscount1Percent,
  CashDiscount2Percent,
  DocumentCurrency,
  cast(ExchangeRate as fis_absolute_exchangerate preserving type) AS ExchangeRate,
  ExchangeRateIsFixed,
  ValidityStartDate,
  ValidityEndDate,
  QuotationSubmissionDate,
  CorrespncExternalReference,
  SupplierQuotation,
  SupplierRespSalesPersonName,
  SupplierPhoneNumber,
  SupplyingSupplier,
  IncotermsClassification,
  IncotermsTransferLocation,
  PurchaseContractTargetAmount,
  InvoicingParty,
  CorrespncInternalReference,
  ReleaseCode,
  IncotermsVersion,
  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,
  IsEndOfPurposeBlocked,
  LastChangeDateTime,
  cast( LastChangeDateTime as abap.dec(21,7) ) AS PurContrLastChgdDteTimeValue,
  PurchasingProcessingStatus,
  PurgAggrgdProdCmplncSuplrSts,
  _PurchaseContractStatus[1: Language = $session.system_language].PurchasingProcessingStatusName AS PurchasingProcessingStatusName,
  cast ('' as boolean) AS PurgContractIsInPreparation,
  PurgDocExternalReference,
  PurchasingDocumentName,
  _PurContrConsumptionDetail._PurContrCriticalityStatus.PurContrCriticalityStatusText AS PurContrAttentionRequiredText,
  _PurContrConsumptionDetail.ContractConsumptionInPct AS ContractConsumptionInPct,
  VersionIsEnabled,
  PurDocHasChgVers,
  PurchasingDocumentVersion,
  PurchasingDocVersionReasonCode
FROM I_PurchaseContract
LEFT OUTER JOIN A_PurchaseContractItem_2 AS _PurchaseContractItem ON PurchaseContract = _PurchaseContractItem.PurchaseContract  -- association [1..*]
LEFT OUTER JOIN A_PurchaseContractPartners_2 AS _PurCtrPartners ON PurchaseContract = _PurCtrPartners.PurchaseContract  -- association [0..*]
LEFT OUTER JOIN A_PurContrHdrCndnValdty AS _PurContrHdrCndnValdty ON PurchaseContract = _PurContrHdrCndnValdty.PurchaseContract  -- association [0..*]
LEFT OUTER JOIN A_PurchaseContractNotes AS _Purctrnotes ON PurchaseContract = _Purctrnotes.ArchitecturalObjectNumber  -- association [0..*]
LEFT OUTER JOIN E_PurchasingDocument AS _PurchaseContractExtension ON PurchaseContract = _PurchaseContractExtension.PurchasingDocument  -- association [0..1]
LEFT OUTER JOIN I_PurchaseContractStatus AS _PurchaseContractStatus ON PurchasingProcessingStatus = _PurchaseContractStatus.PurchasingProcessingStatus  -- association [0..*]
LEFT OUTER JOIN I_PurContrConsumptionDetail AS _PurContrConsumptionDetail ON PurchaseContract = _PurContrConsumptionDetail.PurchaseContract  -- association [1..1]
;