I_PurchaseContractWD

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_PurchaseContractWD.
-- 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: IPURCHASECTRWD

CREATE VIEW I_PurchaseContractWD AS
SELECT
  Document.PurchaseContract AS PurchaseContract,
  Document.PurchaseContract AS PurchaseContractForEdit,
  Document.PurchaseContractType AS PurchaseContractType,
  Document.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  Document.CreationDate AS CreationDate,
  Document.Supplier AS Supplier,
  Document.CompanyCode AS CompanyCode,
  Document.PurchasingOrganization AS PurchasingOrganization,
  Document.PurchasingGroup AS PurchasingGroup,
  Document.DocumentCurrency AS DocumentCurrency,
  Document.IncotermsClassification AS IncotermsClassification,
  Document.IncotermsTransferLocation AS IncotermsTransferLocation,
  Document.PaymentTerms AS PaymentTerms,
  Document.CashDiscount1Days AS CashDiscount1Days,
  Document.CashDiscount2Days AS CashDiscount2Days,
  Document.NetPaymentDays AS NetPaymentDays,
  Document.CashDiscount1Percent AS CashDiscount1Percent,
  Document.CashDiscount2Percent AS CashDiscount2Percent,
  Document.PurchaseContractTargetAmount AS PurchaseContractTargetAmount,
  Document.ValidityStartDate AS ValidityStartDate,
  Document.ValidityEndDate AS ValidityEndDate,
  Document.ReleaseCode AS ReleaseCode,
  Document.CreatedByUser AS CreatedByUser,
  Document.PurchasingDocumentDeletionCode AS PurchasingDocumentDeletionCode,
  Document.SupplierAddressID AS SupplierAddressID,
  Document.SupplyingSupplier AS SupplyingSupplier,
  Document.InvoicingParty AS InvoicingParty,
  cast( Document.ExchangeRate as fis_exchange_rate preserving type ) AS ExchangeRate,
  Document.ExchangeRateIsFixed AS ExchangeRateIsFixed,
  Document.QuotationSubmissionDate AS QuotationSubmissionDate,
  Document.SupplierQuotation AS SupplierQuotation,
  Document.ReleaseIsNotCompleted AS ReleaseIsNotCompleted,
  Document.CorrespncExternalReference AS CorrespncExternalReference,
  Document.CorrespncInternalReference AS CorrespncInternalReference,
  Document.SupplierRespSalesPersonName AS SupplierRespSalesPersonName,
  Document.SupplierPhoneNumber AS SupplierPhoneNumber,
  Document.IncotermsVersion AS IncotermsVersion,
  Document.IncotermsLocation1 AS IncotermsLocation1,
  Document.IncotermsLocation2 AS 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,
  Document.IncotermsSupChnLoc1AddlUUID AS IncotermsSupChnLoc1AddlUUID,
  Document.IncotermsSupChnLoc2AddlUUID AS IncotermsSupChnLoc2AddlUUID,
  Document.IncotermsSupChnDvtgLocAddlUUID AS IncotermsSupChnDvtgLocAddlUUID,
  Document.PurchasingDocumentName AS PurchasingDocumentName,
  Document.PurchasingDocumentOrigin AS PurchasingDocumentOrigin,
  Document.LastChangeDateTime AS LastChangeDateTime,
  Document.PurchasingProcessingStatus AS PurchasingProcessingStatus,
  Document.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked,
  _PurchaseContractExtReference.PurgDocExternalReference AS PurgDocExternalReference,
  _PurchaseContractExtReference.PurgOutlineAgrmtExtSystID AS PurgOutlineAgrmtExtSystID,
  _PurchaseContractExtReference.PurgDocExtReferenceNodeType AS PurgDocExtReferenceNodeType,
  cast( ' ' as batxt ) AS PurchasingDocumentTypeName,
  cast( 0 as mm_pur_oa_consumed_val) AS PurContrConsumedVal,
  cast( ' ' as mm_a_cntr_expiry_predict_date ) AS ContractExpiryPredictedDate,
  cast( ' ' as mm_oa_validity_status ) AS PurchaseContractValidityStatus,
  cast( ' ' as mm_oa_validity_status ) AS PurContrValidityStatusName,
  cast( 0 as mm_oa_validity_criticality) AS PurContrStatusCriticality,
  cast( 0 as mm_a_supplier_opl_score ) AS SupplierOperationalScore,
  cast( ' ' as mm_oa_adv_pctr_ind ) AS PurContrHasAdvncdUsrInterface,
  cast( 0 as numberofdays ) AS NumberOfDays,
  cast( ' ' as mm_oa_iscontractexpired ) AS IsExpired,
  cast( ' ' as mm_oa_oc_type ) AS PurContrOutputCtrlType,
  cast( ' ' as mm_oa_oc_status ) AS PurContrOutputCtrlStatus,
  cast( ' ' as mm_oa_oc_status_txt ) AS PurContrOutputCtrlStatusTxt,
  cast( 0 as mm_oa_oc_time ) AS PurContrOutputCtrlTime,
  cast( 0 as mm_pur_oa_weighted_rel ) AS WeightedRelevance,
  cast( 0 as mm_oa_validity_criticality ) AS PurContrCnsmpnCriticality,
  cast( ' ' as mm_pur_ctr_criticality_status ) AS PurContrCriticalityStatus,
  cast( ' ' as mm_oa_approver_id) AS AccWorkflowApprover,
  cast( ' ' as mm_oa_approver_name) AS AccWorkflowApproverFirstName,
  cast( ' ' as val_text ) AS ApprovalStatusName,
  cast( ' ' as sww_aagent ) AS ApproverUser,
  cast( _PurContrValidityStatus.PurchaseContractValidityStatus as mm_pur_ctr_validity_status ) AS PurContrValidityStatus_2,
  _ContractTransientField.IsContrRefOfPurReqn AS IsContrRefOfPurReqn,
  _ContractTransientField.ChangeRecordReferenceUUID AS ChangeRecordReferenceUUID,
  _ContractTransientField.IsPurContrTemplate AS IsPurContrTemplate,
  _ContractTransientField.PurgContractIsInPreparation AS PurgContractIsInPreparation,
  cast( ' ' as val_text) AS PurchasingDocumentStatus,
  cast( ' ' as boolean) AS PurchasingItemHasHierarchy,
  cast( ' ' as mmpur_ctr_rework_comment ) AS PurContrReworkCommentText,
  cast( ' ' as mmpur_ctr_approvercomment ) AS PurContrApproverCommentText,
  Document.PurgAggrgdProdCmplncSuplrSts AS PurgAggrgdProdCmplncSuplrSts,
  Document.PurgHasCatalogRelevantItems AS PurgHasCatalogRelevantItems,
  Document.ActivePurchasingDocument AS ActivePurchasingDocument,
  Document.PurgDocChangeRequestStatus AS PurgDocChangeRequestStatus,
  Document.PurchasingDocumentVersion AS PurchasingDocumentVersion,
  Document.PurgDocIsChgVers AS PurgDocIsChgVers,
  Document.PurchasingDocVersionReasonCode AS PurchasingDocVersionReasonCode,
  _VersionType.ChangeRequestNote AS ChangeRequestNote,
  Document._DocumentCurrency AS _DocumentCurrency
FROM I_PurchaseContractVersion AS Document
LEFT OUTER JOIN I_ContractTransientField AS _ContractTransientField ON PurchaseContract = _ContractTransientField.PurchaseContract AND ActivePurchasingDocument = _ContractTransientField.ActivePurchasingDocument  -- association [1..1]
LEFT OUTER JOIN I_PurchaseContractItemWD AS _PurchaseContractItemWD ON _PurchaseContractItemWD.PurchaseContract = PurchaseContract  -- association [1..*]
LEFT OUTER JOIN I_PurCtrNotesWD AS _PurctrnotesWD ON PurchaseContract = _PurctrnotesWD.PurchaseContract  -- association [0..*]
LEFT OUTER JOIN I_PurctrpartnersWithDraft AS _PurCtrPartnersWithDraft ON PurchaseContract = _PurCtrPartnersWithDraft.PurchaseContract  -- association [0..*]
LEFT OUTER JOIN I_PurchaseContractExtReference AS _PurchaseContractExtReference ON PurchaseContract = _PurchaseContractExtReference.PurchaseContract  -- association [0..1]
LEFT OUTER JOIN E_PurchasingDocument AS _PurchaseContractExtension ON PurchaseContract = _PurchaseContractExtension.PurchasingDocument  -- association [1..1]
LEFT OUTER JOIN E_PurchasingDocument AS _PurchaseCtrDraftExtension ON PurchaseContract = _PurchaseCtrDraftExtension.PurchasingDocument  -- association [1..1]
LEFT OUTER JOIN I_PurchasingDocumentCategory AS _PurchasingDocumentCategory ON _PurchasingDocumentCategory.PurchasingDocumentCategory = PurchasingDocumentCategory  -- association [0..1]
LEFT OUTER JOIN I_PurchasingDocumentType AS _PurchasingDocumentType ON _PurchasingDocumentType.PurchasingDocumentCategory = PurchasingDocumentCategory AND _PurchasingDocumentType.PurchasingDocumentType = PurchaseContractType  -- association [0..1]
LEFT OUTER JOIN I_IncotermsClassification AS _IncotermsClassification ON _IncotermsClassification.IncotermsClassification = IncotermsClassification  -- association [0..1]
LEFT OUTER JOIN I_IncotermsClassificationText AS _IncotermsClassificationText ON _IncotermsClassificationText.IncotermsClassification = IncotermsClassification AND _IncotermsClassificationText.IncotermsClassificationName = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _SupplyingSupplier ON SupplyingSupplier = _SupplyingSupplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _InvoicingParty ON InvoicingParty = _InvoicingParty.Supplier  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON _CompanyCode.CompanyCode = CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganization ON _PurchasingOrganization.PurchasingOrganization = PurchasingOrganization  -- association [0..1]
LEFT OUTER JOIN I_PurchasingGroup AS _PurchasingGroup ON _PurchasingGroup.PurchasingGroup = PurchasingGroup  -- association [0..1]
LEFT OUTER JOIN I_CurrencyText AS _DocumentCurrencyText ON _DocumentCurrencyText.Currency = DocumentCurrency AND _DocumentCurrencyText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_PaymentTerms AS _PaymentTerms ON PaymentTerms = _PaymentTerms.PaymentTerms  -- association [0..1]
LEFT OUTER JOIN I_PaymentTermsText AS _PaymentTermsText ON PaymentTerms = _PaymentTermsText.PaymentTerms  -- association [0..*]
LEFT OUTER JOIN I_PurCtrUserDetails AS _USERDETAILS ON CreatedByUser = _USERDETAILS.UserID  -- association [1..1]
LEFT OUTER JOIN I_PurContrValidityStatus AS _PurContrValidityStatus ON PurchaseContract = _PurContrValidityStatus.PurchaseContract AND ActivePurchasingDocument = _PurContrValidityStatus.ActivePurchasingDocument  -- association [1..1]
LEFT OUTER JOIN I_PurContrHdrCndnValdtyTP AS _PurContrHdrCndnValdtyTP ON PurchaseContract = _PurContrHdrCndnValdtyTP.PurchaseContract  -- association [1..*]
;