C_CntrlPurContrHierMassUpdt

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_CntrlPurContrHierMassUpdt.
-- 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: CHCTRMASSUPD

CREATE VIEW C_CntrlPurContrHierMassUpdt AS
SELECT
  CentralPurchaseContract,
  ActivePurchasingDocument,
  PurchaseContractType,
  PurchasingOrganization,
  PurchasingGroup,
  CompanyCode,
  PurchasingDocumentSubtype,
  Supplier,
  _Supplier.SupplierName AS SupplierName,
  ValidityStartDate,
  ValidityEndDate,
  PurchaseContractTargetAmount,
  Currency,
  PurchasingProcessingStatus AS CntrlPurContrOvrlDistrStsTxt,
  cast( _CntrlPurContrAggrgnDistrSts.CntrlPurContrDistributionSts as me_distribution_status ) AS PurchasingProcessingStatus,
  _CntrlPurContrAggrgnDistrSts._CntrlPurContrDistrStatusText.ItemDistributionStatusName AS ItemDistributionStatusName,
  PurchasingProcessingStatus AS PurchasingDocumentStatus,
  CreatedByUser,
  _CreatedByUser.UserDescription AS UserDescription,
  CreationDate,
  IsEndOfPurposeBlocked,
  PaymentTerms,
  CashDiscount1Days,
  CashDiscount1Percent,
  CashDiscount2Days,
  CashDiscount2Percent,
  NetPaymentDays,
  IncotermsClassification,
  IncotermsLocation1,
  IncotermsLocation2,
  IncotermsVersion,
  QuotationSubmissionDate,
  SupplierQuotation,
  CorrespncExternalReference,
  CorrespncInternalReference,
  SupplierRespSalesPersonName,
  SupplierPhoneNumber,
  cast ('' as product_type) AS ProductTypeCode,
  cast ('' as matkl) AS MaterialGroup,
  cast ('' as matnr) AS Material,
  cast (0 as mm_purgdoc_distr_pct) AS CntrlPurContrItmDistrPct,
  cast (0 as mm_purgdoc_distr_pct ) AS CntrlPurContrDistributionPct,
  cast ('' as ekorg ) AS ProcmtHubPurchasingOrg,
  cast ('' as bkgrp ) AS ProcmtHubPurchasingGroup,
  cast ('' as bukrs) AS ProcmtHubCompanyCode,
  cast ('' as ewerk ) AS Plant,
  cast ('' as xfeld) AS ContrHdrIsCreated,
  PurchasingDocumentDeletionCode,
  PurchasingDocVersionReasonCode,
  _PurchaseNote.Content AS PurgDocNoteText
FROM I_CentralPurchaseContract
LEFT OUTER JOIN C_CntrlPurContrHierItmMassUpdt AS _CntrlPurContrHierItmMassUpdt ON CentralPurchaseContract = _CntrlPurContrHierItmMassUpdt.CentralPurchaseContract  -- association [1..*]
LEFT OUTER JOIN C_CPurConHierItmDistrMassUpdt AS _CPurConHierItmDistrMassUpdt ON CentralPurchaseContract = _CPurConHierItmDistrMassUpdt.CentralPurchaseContract  -- association [0..*]
LEFT OUTER JOIN C_CntrlPurContrHierTypeVH AS _CntrlPurContrTypeValueHelp ON PurchaseContractType = _CntrlPurContrTypeValueHelp.PurchaseContractType  -- association [1..1]
LEFT OUTER JOIN I_IncotermsVersionText AS _IncotermsVersionText ON IncotermsVersion = _IncotermsVersionText.IncotermsVersion AND _IncotermsVersionText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN C_PurgDocVersionReasonValHelp AS _VersionReasonVH ON PurchasingDocVersionReasonCode = _VersionReasonVH.PurchasingDocVersionReasonCode  -- association [0..1]
LEFT OUTER JOIN P_SGBT_NTE_CDS_APITP AS _PurchaseNote ON CentralPurchaseContract = _PurchaseNote.ObjectID AND _PurchaseNote.ObjectNodeType = 'CentralPurchaseContract' AND _PurchaseNote.NoteType = 'CH16' AND _PurchaseNote.LanguageCode = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CntrlPurContrDocStsText AS _CntrlPurContrStatusText ON _CntrlPurContrStatusText.PurchasingDocumentStatus = I_CentralPurchaseContract.PurchasingProcessingStatus  -- association [0..1]
LEFT OUTER JOIN I_PaymentTermsText AS _PaymentTermsText ON _PaymentTermsText.PaymentTerms = PaymentTerms  -- association [0..*]
LEFT OUTER JOIN I_CurrencyText AS _CurrencyText ON _CurrencyText.Currency = Currency  -- association [0..*]
LEFT OUTER JOIN I_IncotermsClassificationText AS _IncotermsClassificationText ON _IncotermsClassificationText.IncotermsClassification = IncotermsClassification  -- association [0..*]
;