C_PurchaseContractMassUpdt

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_PurchaseContractMassUpdt.
-- 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: CCTRMASSCHANGE

CREATE VIEW C_PurchaseContractMassUpdt AS
SELECT
  PurchaseContract,
  cast ('' as parvw) AS PartnerFunction,
  cast ('' as parza) AS PartnerCounter,
  PurchaseContractType,
  _PurchasingDocumentType._Text[1:Language = $session.system_language].PurchasingDocumentTypeName AS PurchasingDocumentTypeName,
  ExchangeRate,
  ExchangeRateIsFixed,
  CreationDate,
  PurchaseContractValidityStatus,
  Supplier,
  CompanyCode,
  cast (PurchasingOrganization as purchasingorganization_ll preserving type ) AS PurchasingOrganization,
  PurchasingGroup,
  DocumentCurrency,
  cast(IncotermsClassification as inco1_ll preserving type) AS IncotermsClassification,
  PaymentTerms,
  PurchaseContractTargetAmount,
  ValidityStartDate,
  ValidityEndDate,
  cast(' ' as abap.char( 80 )) AS NumberOfBusinessPartners,
  CorrespncExternalReference,
  CorrespncInternalReference,
  SupplierRespSalesPersonName,
  SupplierPhoneNumber,
  cast (PurchasingDocumentName as vdm_purgdoc_name_ll preserving type ) AS PurchasingDocumentName,
  IncotermsVersion,
  cast (IncotermsLocation1 as vdm_incotermlocation1 preserving type ) AS IncotermsLocation1,
  cast (IncotermsLocation2 as vdm_incotermlocation2 preserving type ) AS IncotermsLocation2,
  cast ('' as matkl) AS MaterialGroup,
  cast ('' as ewerk) AS Plant,
  cast ('' as matnr) AS Material,
  cast ('' as pstyp) AS PurchasingDocumentItemCategory,
  cast ('' as knttp) AS AccountAssignmentCategory,
  '' AS PurchasingContractDeletionCode,
  cast ('' as ltsnr) AS SupplierSubrange,
  cast ('' as lifnr) AS ReferenceSupplier,
  cast ('' as md_supplier_name) AS PreferredSupplierName,
  _Supplier.SupplierName AS SupplierName,
  CreatedByUser,
  CashDiscount1Percent,
  CashDiscount1Days,
  CashDiscount2Percent,
  CashDiscount2Days,
  NetPaymentDays,
  SupplierQuotation,
  QuotationSubmissionDate,
  InvoicingParty,
  SupplyingSupplier,
  cast ('' as xfeld) AS IsCreated,
  PurchasingDocVersionReasonCode,
  _VersionReasonVH.PurchasingDocVersionReasonText AS PurchasingDocVersionReasonText,
  _PurchaserNote.NoteDescription AS PurgDocNoteText
FROM P_PurchaseContractMassUpdt
LEFT OUTER JOIN C_PurContractItemMassUpdt AS _PurContractItmMassUpdt ON PurchaseContract = _PurContractItmMassUpdt.PurchaseContract  -- association [0..*]
LEFT OUTER JOIN C_MassUpdtPurchasingDocPart AS _PurCtrPartner ON PurchaseContract = _PurCtrPartner.PurchaseContract  -- association [1..*]
LEFT OUTER JOIN C_PurContrMassValdtyStsDropDwn AS _ValidityText ON PurchaseContractValidityStatus = _ValidityText.Status  -- association [0..1]
LEFT OUTER JOIN C_PurgDocVersionReasonValHelp AS _VersionReasonVH ON PurchasingDocVersionReasonCode = _VersionReasonVH.PurchasingDocVersionReasonCode  -- association [0..1]
LEFT OUTER JOIN I_Purctrnotes AS _PurchaserNote ON PurchaseContract = _PurchaserNote.PurchaseContract AND _PurchaserNote.ArchitecturalObjectNumber = PurchaseContract AND _PurchaserNote.TechnicalObjectType = 'EKKO' AND _PurchaserNote.DocumentText = 'K17' AND _PurchaserNote.Language = $session.system_language  -- association [0..1]
;