P_Contractmaintain_Trans

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 P_Contractmaintain_Trans.
-- 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: PCTRMAINTTRANS

CREATE VIEW P_Contractmaintain_Trans AS
SELECT
  _ContractRelevance.PurchaseContract AS PurchaseContract,
  _PurchaseContract.PurchaseContractType AS PurchaseContractType,
  _PurContractClassification.PurchaseContractClassification AS PurchaseContractClassification,
  _ContractRelevance.ActivePurchasingDocument AS ActivePurchasingDocument,
  ContractExpiryPredictedDate,
  PurchaseContractConsumedAmount,
  cast (0 as mm_a_supplier_opl_score) AS SupplierOperationalScore,
  cast (0 as mm_pur_ana_suplreval_opl_score) AS SuplrEvalOplScrInDcmlVal,
  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 PurContrOutputCtrlDateTime,
  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( '' as mmpur_approver_name) AS WorkflowApproverNote,
  WeightedRelevance,
  cast ('' as boole_d ) AS IsContrRefOfPurReqn,
  cast ( ContractConsumptionInPct as abap.char( 34 ) ) AS ContractConsumptionInPct,
  cast (0 as mm_oa_validity_criticality ) AS PurContrCnsmpnCriticality,
  cast ( '' as mm_oa_iscontracttemplate ) AS IsPurContrTemplate,
  cast ( hextobin('00000000000000000000000000000000') as sysuuid_x preserving type ) AS ChangeRecordReferenceUUID,
  cast('' as boolean) AS PurgContractIsInPreparation,
  cast ('' as val_text) AS PurchasingDocumentStatus,
  cast ('' as boolean) AS PurContrHasAdvncdUsrInterface,
  cast ('' as boolean) AS PurchasingIsBlocked
FROM I_PurchaseContractRelevance AS _ContractRelevance
INNER JOIN I_PurchaseContractVersion AS _PurchaseContract ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_QtyContractPrediction AS QtyContractPrediction ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CalendarDate AS CalendarDate ON /* join condition not captured in parsed metadata */
;