C_ContractMaintain

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 C_ContractMaintain.
-- 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: CCTRMAINTAIN

CREATE VIEW C_ContractMaintain AS
SELECT
  ActivePurchasingDocument,
  PurchasingDocumentVersion,
  PurgDocIsChgVers,
  PurgContractIsInPreparation,
  PurchasingDocumentCategory,
  CreationDate,
  Supplier,
  CompanyCode,
  PurchasingOrganization,
  PurchasingGroup,
  DocumentCurrency,
  DocumentCurrency AS Currency,
  IncotermsClassification,
  IncotermsTransferLocation,
  PaymentTerms,
  CashDiscount1Days,
  CashDiscount2Days,
  NetPaymentDays,
  CashDiscount1Percent,
  CashDiscount2Percent,
  PurchaseContractTargetAmount,
  ValidityStartDate,
  ValidityEndDate,
  ReleaseCode,
  CreatedByUser,
  PurchasingDocumentDeletionCode,
  SupplierAddressID,
  SupplyingSupplier,
  InvoicingParty,
  ExchangeRate,
  ExchangeRateIsFixed,
  PurgDocChangeRequestStatus,
  PurchasingDocVersionReasonCode,
  QuotationSubmissionDate,
  SupplierQuotation,
  CorrespncExternalReference,
  CorrespncInternalReference,
  SupplierRespSalesPersonName,
  SupplierPhoneNumber,
  IncotermsVersion,
  IncotermsLocation1,
  IncotermsLocation1Identifier,
  IncotermsSupChnLoc1AddlUUID,
  IncotermsLocation2,
  IncotermsLocation2Identifier,
  IncotermsSupChnLoc2AddlUUID,
  IncotermsDvtgLocDescription,
  IncotermsDvtgLocIdentifier,
  IncotermsSupChnDvtgLocAddlUUID,
  PurchasingDocumentName,
  PurchasingDocumentOrigin,
  ReleaseIsNotCompleted,
  PurchasingProcessingStatus,
  PurchasingItemHasHierarchy,
  PurContrValidityStatus_2,
  cast( '' as mm_approver_name ) AS ApproverName,
  cast( 0 as mmpur_approver_count ) AS PurchaseContrNumberOfApprovers,
  PurContrCriticalityStatus,
  CreatedByUserName,
  cast( _PurContrCnsmpnInPctStatus.ContractConsumptionInPct as mmpur_oa_consumption_pctg ) AS ContractConsumptionInPct,
  IsPurContrTemplate,
  ChangeRecordReferenceUUID,
  PurgDocExternalReference,
  PurgOutlineAgrmtExtSystID,
  PurgDocExtReferenceNodeType,
  cast( '' as boolean) AS IsLglTransIntegEnabled,
  _PaymentTermsText[1: Language = $session.system_language].PaymentTermsName AS PaymentTermsName,
  SupplierOperationalScore,
  IsEndOfPurposeBlocked,
  ChangeRequestNote,
  PurgAggrgdProdCmplncSuplrSts,
  cast ('' as abap.char( 1 ) ) AS UICT_PurgAggrgdCmplncSuplrSts,
  cast ('' as ehfnd_boolean) AS ProductComplianceIsActive,
  cast ('' as ehfnd_bf_pcs_is_active) AS BusFtreProdCmplncSuplrIsActive,
  cast( '' as matnr ) AS Material,
  cast( '' as matkl ) AS MaterialGroup,
  cast( '' as producttype ) AS ProductType,
  cast( '' as mmpur_ctr_d_rework_ind ) AS PurContrIsApplicableForRework,
  PurContrApproverCommentText,
  PurContrReworkCommentText,
  cast ('' as boolean) AS SrvcProcmtItmHierIsEnbld,
  cast ('' as boolean) AS PurContrCatalogItemIsEnbld,
  PurgHasCatalogRelevantItems,
  cast ('' as boolean) AS VersionIsEnabled,
  cast( '' as boolean) AS TargetValueIsRelevantForVers,
  cast( '' as boolean) AS ValdtyEndDateIsRelevantForVers,
  cast ('' as ebeln) AS ChangeRequest,
  I_PurchaseContractWD.PurchaseContract AS PurchaseContract,
  I_PurchaseContractWD.PurchaseContractForEdit AS PurchaseContractForEdit,
  I_PurchaseContractWD.PurchaseContractType AS PurchaseContractType,
  I_PurchaseContractWD.PurchaseContractType AS PurchasingDocumentType,
  _CompanyCodeValueHelp.CompanyCodeName AS CompanyCodeName,
  _ContractTransientField.PurchaseContractConsumedAmount AS PurContrConsumedVal,
  _ContractTransientField.PurContrHasAdvncdUsrInterface AS PurContrHasAdvncdUsrInterface,
  _ContractTransientField.NumberOfDays AS NumberOfDays,
  _ContractTransientField.IsExpired AS IsExpired,
  _ContractTransientField.PurContrOutputCtrlType AS PurContrOutputCtrlType,
  _ContractTransientField.PurContrOutputCtrlStatus AS PurContrOutputCtrlStatus,
  _ContractTransientField.PurContrOutputCtrlStatusTxt AS PurContrOutputCtrlStatusTxt,
  _ContractTransientField.PurContrOutputCtrlDateTime AS PurContrOutputCtrlTime,
  _ContractTransientField.AccWorkflowApprover AS AccWorkflowApprover,
  _ContractTransientField.AccWorkflowApproverFirstName AS AccWorkflowApproverFirstName,
  _ContractTransientField.ApprovalStatusName AS ApprovalStatusName,
  _ContractTransientField.WorkflowApproverNote AS WorkflowApproverNote,
  _ContractTransientField.PurchasingDocumentStatus AS PurchasingDocumentStatus,
  _ContractTransientField.WeightedRelevance AS WeightedRelevance,
  _ContractTransientField.PurContrCnsmpnCriticality AS PurContrCnsmpnCriticality,
  _ContractTransientField.ContractExpiryPredictedDate AS ContractExpiryPredictedDate,
  _ContractTransientField.SuplrEvalOplScrInDcmlVal AS SuplrEvalOplScrInDcmlVal,
  _DocumentCurrencyText.CurrencyName AS CurrencyName,
  _IncotermsClassificationText.IncotermsClassificationName AS IncotermsClassificationName,
  _PurchaseContractStatus.PurchasingProcessingStatusName AS PurchasingProcessingStatusName,
  _Purchasecontracttype_Vh.PurchasingDocumentTypeName AS PurchasingDocumentTypeName,
  _PurchasingGroup.PurchasingGroupName AS PurchasingGroupName,
  _PurchasingOrganization.PurchasingOrganizationName AS PurchasingOrganizationName,
  _PurContrCnsmpnInPctStatus.PurContrCriticalityStatusText AS PurContrCriticalityStatusText,
  _PurContrCriticalityStatus.StatusCriticality AS StatusCriticality,
  _PurContrValdtyStatusValueHelp.PurContrValidityStatusText AS PurContrValidityStatusText,
  _PurContrValidityStatus.PurContrStatusCriticality AS PurContrStatusCriticality,
  _PurCtrIncoVersion.IncotermsVersionName AS IncotermsVersionName,
  _PurgDocExtRefNodeType.PurgDocExtRefNodeTypeName AS PurgDocExtRefNodeTypeName,
  _PurgTotProdCmplncSuplrStsT.PurgTotProdCmplncSuplrStsName AS PurgTotProdCmplncSuplrStsName,
  _Supplier.SupplierName AS SupplierName
FROM I_PurchaseContractWD
LEFT OUTER JOIN C_ContractMaintainItem AS _PurchaseContractItemWD ON PurchaseContract = _PurchaseContractItemWD.PurchaseContract  -- association [1..*]
LEFT OUTER JOIN C_Contractnotes AS _PurCtrNotesWD ON PurchaseContract = _PurCtrNotesWD.PurchaseContract  -- association [0..*]
LEFT OUTER JOIN C_PurCtrPartners AS _PurctrpartnersWithDraft ON PurchaseContract = _PurctrpartnersWithDraft.PurchaseContract  -- association [0..*]
LEFT OUTER JOIN I_Purchasecontracttype_Vh AS _Purchasecontracttype_Vh ON PurchaseContractType = _Purchasecontracttype_Vh.PurchasingDocumentType  -- association [1..1]
LEFT OUTER JOIN I_PurCtrIncoVersion AS _PurCtrIncoVersion ON IncotermsVersion = _PurCtrIncoVersion.IncotermsVersion  -- association [1..1]
LEFT OUTER JOIN C_SupplierPurchOrgVH AS _SupplierValueHelp ON _SupplierValueHelp.Supplier = Supplier AND _SupplierValueHelp.PurchasingOrganization = PurchasingOrganization  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON _Supplier.Supplier = Supplier  -- association [0..1]
LEFT OUTER JOIN C_LegalTransactionIntegFacet AS _LegalTransaction ON _LegalTransaction.LglCntntMLinkdObj = ActivePurchasingDocument AND _LegalTransaction.LglCntntMIntegrationLink = 'PC'  -- association [0..*]
LEFT OUTER JOIN C_MM_CompanyCodeValueHelp AS _CompanyCodeValueHelp ON _CompanyCodeValueHelp.CompanyCode = CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_PurgDocExtRefNodeType AS _PurgDocExtRefNodeType ON PurgDocExtReferenceNodeType = _PurgDocExtRefNodeType.PurgDocExtReferenceNodeType  -- association [0..1]
LEFT OUTER JOIN C_PurchaseContrItemHierarchyTP AS _PurchaseContrItemHierarchyTP ON PurchaseContract = _PurchaseContrItemHierarchyTP.PurchaseContract  -- association [1..*]
LEFT OUTER JOIN C_PurchaseContractApprover AS _CTRApprover ON PurchaseContract = _CTRApprover.PurchaseContract  -- association [0..*]
LEFT OUTER JOIN I_PurgTotProdCmplncSuplrStsT AS _PurgTotProdCmplncSuplrStsT ON PurgAggrgdProdCmplncSuplrSts = _PurgTotProdCmplncSuplrStsT.PurgAggrgdProdCmplncSuplrSts AND _PurgTotProdCmplncSuplrStsT.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN C_PurContrHdrCndnValdtyTP AS _PurContrHdrCndnValdtyTP ON PurchaseContract = _PurContrHdrCndnValdtyTP.PurchaseContract  -- association [1..*]
LEFT OUTER JOIN I_PurchaseContractStatus AS _PurchaseContractStatus ON PurchasingProcessingStatus = _PurchaseContractStatus.PurchasingProcessingStatus  -- association [1..*]
LEFT OUTER JOIN I_PurContrCriticalityStatus AS _PurContrCriticalityStatus ON PurContrCriticalityStatus = _PurContrCriticalityStatus.PurContrCriticalityStatus  -- association [1..*]
LEFT OUTER JOIN I_PurContrValidityStatusVH AS _PurContrValdtyStatusValueHelp ON PurContrValidityStatus_2 = _PurContrValdtyStatusValueHelp.PurContrValidityStatus_2  -- association [1..*]
LEFT OUTER JOIN C_PurContrVersionHistory AS _PurContrVersionHistory ON ActivePurchasingDocument = _PurContrVersionHistory.ActivePurchasingDocument  -- association [1..*]
LEFT OUTER JOIN I_PurContrCnsmpnInPctStatus AS _PurContrCnsmpnInPctStatus ON PurchaseContract = _PurContrCnsmpnInPctStatus.PurchaseContract AND ActivePurchasingDocument = _PurContrCnsmpnInPctStatus.ActivePurchasingDocument  -- association [1..1]
LEFT OUTER JOIN C_SrceOfSupForPurchaseContract AS _SourceOfSupply ON PurchaseContract = _SourceOfSupply.PurchaseContract  -- association [0..*]
;