I_PurContrTemplate

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_PurContrTemplate.
-- 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: ICONTRTMPL

CREATE VIEW I_PurContrTemplate AS
SELECT
  purctr_hdr_d.draftuuid AS DraftUUID,
  purctr_hdr_d.purchasecontract AS PurchaseContract,
  purctr_hdr_d.purchasecontractforedit AS PurchaseContractForEdit,
  purctr_hdr_d.purchasecontracttype AS PurchaseContractType,
  purctr_hdr_d.purchasinggroup AS PurchasingGroup,
  purctr_hdr_d.purchasingorganization AS PurchasingOrganization,
  purctr_hdr_d.purchasingdocumentcategory AS PurchasingDocumentCategory,
  purctr_hdr_d.purchasingdocumentname AS PurchasingDocumentName,
  purctr_hdr_d.companycode AS CompanyCode,
  purctr_hdr_d.documentcurrency AS DocumentCurrency,
  purctr_hdr_d.exchangerateisfixed AS ExchangeRateIsFixed,
  purctr_hdr_d.purchasecontracttargetamount AS PurchaseContractTargetAmount,
  purctr_hdr_d.validitystartdate AS ValidityStartDate,
  purctr_hdr_d.validityenddate AS ValidityEndDate,
  purctr_hdr_d.supplier AS Supplier,
  purctr_hdr_d.ispurcontrtemplate AS IsPurContrTemplate,
  purctr_hdr_d.createdbyuser AS CreatedByUser,
  ChangeRecordReferenceUUID,
  purctr_hdr_d.purchasingdocumentdeletioncode AS PurchasingDocumentDeletionCode,
  purctr_hdr_d.isendofpurposeblocked AS IsEndOfPurposeBlocked
FROM purctr_hdr_d
LEFT OUTER JOIN I_PurContrItmTemplate AS _PurContrItmTemplate ON _PurContrItmTemplate.ParentDraftUUID = DraftUUID  -- association [1..*]
;