C_PurCntrlContrMassUpdt

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_PurCntrlContrMassUpdt.
-- 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: CCNTRLCTRMASS

CREATE VIEW C_PurCntrlContrMassUpdt AS
SELECT
  CentralPurchaseContract,
  ActivePurchasingDocument,
  PurchaseContractType,
  _CntrlPurContrTypeValueHelp.PurchasingDocumentTypeName AS PurchasingDocumentTypeName,
  PurchasingOrganization,
  _PurchasingOrganization.PurchasingOrganizationName AS PurchasingOrganizationName,
  PurchasingGroup,
  _PurchasingGroup.PurchasingGroupName AS PurchasingGroupName,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  Supplier,
  _Supplier.SupplierName AS SupplierName,
  ValidityStartDate,
  ValidityEndDate,
  PurgSingleCardinalityDistrType,
  PurchaseContractTargetAmount,
  Currency,
  _DocumentCurrency._Text[1: Language = $session.system_language ].CurrencyName AS CurrencyName,
  PurchasingProcessingStatus AS CntrlPurContrOvrlDistrStsTxt,
  cast( _CntrlPurContrAggrgnDistrSts.CntrlPurContrDistributionSts as me_distribution_status ) AS PurchasingProcessingStatus,
  _CntrlPurContrAggrgnDistrSts._CntrlPurContrDistrStatusText.ItemDistributionStatusName AS ItemDistributionStatusName,
  _CntrlPurContrStatusText.DocumentStatusName AS DocumentStatusName,
  PurchasingProcessingStatus AS PurchasingDocumentStatus,
  CreatedByUser,
  _CreatedByUser.UserDescription AS UserDescription,
  CreationDate,
  IsEndOfPurposeBlocked,
  PaymentTerms,
  _PaymentTerms._Text[1: Language = $session.system_language ].PaymentTermsName AS PaymentTermsName,
  CashDiscount1Days,
  CashDiscount1Percent,
  CashDiscount2Days,
  CashDiscount2Percent,
  NetPaymentDays,
  IncotermsClassification,
  _IncotermsClassification._Text[1: Language = $session.system_language ].IncotermsClassificationName AS IncotermsClassificationName,
  IncotermsLocation1,
  IncotermsLocation2,
  IncotermsVersion,
  _IncotermVersionText.IncotermsVersionName AS IncotermsVersionName,
  QuotationSubmissionDate,
  SupplierQuotation,
  CorrespncExternalReference,
  CorrespncInternalReference,
  SupplierRespSalesPersonName,
  SupplierPhoneNumber,
  cast ('' as producttype) AS ProductType,
  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,
  _VersionReasonVH.PurchasingDocVersionReasonText AS PurchasingDocVersionReasonText,
  _PurchaseNote.Content AS PurgDocNoteText
FROM I_CentralPurchaseContract
LEFT OUTER JOIN C_CntrlPurContrTypeValueHelp AS _CntrlPurContrTypeValueHelp ON PurchaseContractType = _CntrlPurContrTypeValueHelp.PurchasingDocumentType  -- association [0..1]
LEFT OUTER JOIN I_IncotermsVersionText AS _IncotermVersionText ON IncotermsVersion = _IncotermVersionText.IncotermsVersion AND _IncotermVersionText.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]
;