A_CentralPurchaseContract

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_CentralPurchaseContract.
-- 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: ACNTRLPCTRH

CREATE VIEW A_CentralPurchaseContract AS
SELECT
  ActivePurchasingDocument AS CentralPurchaseContract,
  PurchaseContractType,
  PurchasingDocumentCategory,
  PurchasingDocumentSubtype,
  Supplier,
  CompanyCode,
  PurchasingOrganization,
  PurchasingGroup,
  ValidityStartDate,
  ValidityEndDate,
  DocumentCurrency,
  LastChangeDateTime,
  CreationDate,
  PaymentTerms,
  CashDiscount1Days,
  CashDiscount2Days,
  CashDiscount1Percent,
  CashDiscount2Percent,
  NetPaymentDays,
  IncotermsClassification,
  IncotermsTransferLocation,
  IncotermsVersion,
  IncotermsLocation1,
  IncotermsLocation2,
  PurchaseContractTargetAmount,
  cast (ExchangeRate as abap.char(12)) AS ExchangeRate,
  ExchangeRateIsFixed,
  SupplyingSupplier,
  QuotationSubmissionDate,
  SupplierQuotation,
  CorrespncExternalReference,
  CorrespncInternalReference,
  SupplierRespSalesPersonName,
  SupplierPhoneNumber,
  ReleaseCode,
  PurchasingDocumentName,
  CreatedByUser,
  PurchasingDocumentDeletionCode,
  PurchasingProcessingStatus,
  _CntrlPurContrAggrgnDistrSts.CntrlPurContrDistributionSts AS CntrlPurContrDistributionSts,
  IsEndOfPurposeBlocked,
  PurchasingDocVersionReasonCode,
  CntrlPurContrFlxblDistrIsAllwd,
  PurchasingDocumentVersion,
  PurgDocIsChgVers,
  PurgSingleCardinalityDistrType
FROM I_CentralPurchaseContract
LEFT OUTER JOIN A_CntrlPurContrHdrCndnValdty AS _CntrlPurContrHdrCndnValdty ON CentralPurchaseContract = _CntrlPurContrHdrCndnValdty.CentralPurchaseContract  -- association [0..*]
LEFT OUTER JOIN A_CntrlPurchaseContractItem AS _CentralPurchaseContractItem ON CentralPurchaseContract = _CentralPurchaseContractItem.CentralPurchaseContract  -- association [1..*]
LEFT OUTER JOIN A_CntrlPurContrHdrDistribution AS _CntrlContrHdrDistribution ON CentralPurchaseContract = _CntrlContrHdrDistribution.CentralPurchaseContract  -- association [1..*]
LEFT OUTER JOIN A_CntrlPurContrDistrMessages AS _CntrlPurContrDistrMessages ON CentralPurchaseContract = _CntrlPurContrDistrMessages.PurchasingDocument  -- association [1..*]
LEFT OUTER JOIN A_CntrlPurContrVersionHistory AS _CntrlPurContrVersionHistory ON CentralPurchaseContract = _CntrlPurContrVersionHistory.CentralPurchaseContract  -- association [1..*]
LEFT OUTER JOIN A_CntrlPurContrLegalTrans AS _LegalTransaction ON CentralPurchaseContract = _LegalTransaction.CentralPurchaseContract  -- association [0..*]
LEFT OUTER JOIN A_SubordinateCntrlContract AS _SubordinateCntrlContract ON CentralPurchaseContract = _SubordinateCntrlContract.PurchasingParentDocument  -- association [0..*]
LEFT OUTER JOIN A_CePuCoDistrdOutlineAgrmt AS _DistributedOutlineAgreement ON CentralPurchaseContract = _DistributedOutlineAgreement.CentralPurchaseContract  -- association [1..*]
LEFT OUTER JOIN E_PurchasingDocument AS _CntrlPurContrExtension ON CentralPurchaseContract = _CntrlPurContrExtension.PurchasingDocument  -- association [1..1]
LEFT OUTER JOIN A_CntrlPurContractHeaderNotes AS _CntrlPurContrHdrNotes ON /* condition not available in parsed metadata */  -- association [0..*]
;