P_PurchaseContractMassUpdate

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_PurchaseContractMassUpdate.
-- 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: PCTRMASSCHANGE

CREATE VIEW P_PurchaseContractMassUpdate AS
SELECT
  cast (_Header.PurchaseContract as abap.char( 16 )) AS FormattedPurchaseContractItem,
  _Header.PurchaseContract AS PurchaseContract,
  cast ('' as vdm_purchasecontractitem) AS PurchaseContractItem,
  _CtrCount.NumberOfContractItems AS NumberOfContractItems,
  cast ( '0' as abap.char(1)) AS HierarchyNodeLevel,
  cast ( ' ' as abap.char(16)) AS ParentNode,
  cast ('expanded' as abap.char(8)) AS DrillDownState,
  _Header.Supplier AS Supplier,
  _Header.PurchasingOrganization AS PurchasingOrganization,
  _Header.PurchasingGroup AS PurchasingGroup,
  _Header.PurchaseContractType AS PurchaseContractType,
  _Header.CompanyCode AS CompanyCode,
  _Header.IncotermsClassification AS IncotermsClassification,
  case _Header.CreationDate when (' ') then '00000000' else _Header.CreationDate end as CreationDate AS CreationDateendasCreationDate,
  _ContractStatusVH.PurchaseContractValidityStatus AS PurchaseContractValidityStatus,
  _Header._Supplier.SupplierName AS SupplierName,
  _Header.ReleaseCode AS ReleaseCode,
  _Header.PaymentTerms AS PaymentTerms,
  _Header.DocumentCurrency AS DocumentCurrency,
  cast(_Header.ExchangeRate as abap.quan( 9, 5 ) ) AS ExchangeRate,
  _Header.ExchangeRateIsFixed AS ExchangeRateIsFixed,
  _Header.CorrespncExternalReference AS CorrespncExternalReference,
  _Header.SupplierRespSalesPersonName AS SupplierRespSalesPersonName,
  _Header.SupplierPhoneNumber AS SupplierPhoneNumber,
  _Header.PurchaseContractTargetAmount AS PurchaseContractTargetAmount,
  _Header.CorrespncInternalReference AS CorrespncInternalReference,
  _Header.PurchasingDocumentName AS PurchasingDocumentName,
  _Header.IncotermsVersion AS IncotermsVersion,
  _Header.IncotermsLocation1 AS IncotermsLocation1,
  _Header.IncotermsLocation2 AS IncotermsLocation2,
  _IncotermsClassification._Text[1: Language = $session.system_language].IncotermsClassificationName AS IncotermsClassificationName,
  _Header.PurchasingDocumentDeletionCode AS PurchasingContractDeletionCode,
  cast ('' as txz01) AS PurchaseContractItemText,
  cast ('_' as matnr) AS Material,
  cast ('_' as ewerk) AS Plant,
  cast ('' as vdm_storage_location) AS StorageLocation,
  cast ('' as bednr) AS RequirementTracking,
  cast ('_' as matkl) AS MaterialGroup,
  cast ('' as idnlf) AS SupplierMaterialNumber,
  cast ('0' as ktmng) AS TargetQuantity,
  cast ('' as bstme) AS OrderQuantityUnit,
  cast ('' as bprme) AS OrderPriceUnit,
  cast ('' as mwskz) AS TaxCode,
  cast ('' as insmk) AS StockType,
  cast ('' as spinf) AS IsInfoRecordUpdated,
  cast ('' as prsdr) AS PriceIsToBePrinted,
  cast ('' as schpr) AS PurgDocEstimatedPrice,
  cast ('0' as mahn1) AS NoDaysReminder1,
  cast ('0' as mahn2) AS NoDaysReminder2,
  cast ('0' as mahn3) AS NoDaysReminder3,
  cast ('0' as uebto) AS OverdelivTolrtdLmtRatioInPct,
  cast ('' as uebtk) AS UnlimitedOverdeliveryIsAllowed,
  cast ('0' as untto) AS UnderdelivTolrtdLmtRatioInPct,
  cast ('_' as pstyp) AS PurchasingDocumentItemCategory,
  cast ('_' as pstyp) AS PurgDocExternalItemCategory,
  cast ('_' as knttp) AS AccountAssignmentCategory,
  cast ('' as vrtkz) AS MultipleAcctAssgmtDistribution,
  cast ('' as repos) AS InvoiceIsExpected,
  cast ('' as webre) AS InvoiceIsGoodsReceiptBased,
  cast ('' as kzabs) AS IsOrderAcknRqd,
  cast ('' as labnr) AS PurgDocOrderAcknNumber,
  cast ('' as evers) AS ShippingInstruction,
  cast ('0' as noram) AS PurgDocReleaseOrderQuantity,
  cast ('' as adrnr_mm) AS ManualDeliveryAddressID,
  cast ('' as bstae) AS SupplierConfirmationControlKey,
  cast ('' as voleh) AS VolumeUnit,
  cast ('' as adrn2) AS ReferenceDeliveryAddressID,
  cast ('' as mtart) AS MaterialType,
  cast ('' as serviceperformer) AS ServicePerformer,
  cast ('' as producttype) AS ProductType,
  cast ('' as maktx) AS MaterialName,
  cast ('' as kalsm_d) AS TaxCalculationProcedure,
  cast ('' as defpa) AS DefaultPartner,
  cast ('00000000' as pernr_d) AS EmploymentInternalID,
  cast('' as parza) AS PartnerCounter,
  cast('_' as parvw) AS PartnerFunction,
  cast ('0000000000' as parnr) AS SupplierContact,
  cast ('_' as lifn2) AS ReferenceSupplier,
  cast ('_' as ltsnr) AS SupplierSubrange,
  cast(' ' as boolean) AS IsStrategicPartner,
  cast('' as suppliername) as PreferredSupplierName AS char16asFormattedPurchaseContractItem,
  cast ('00000000' as paedt) AS CreationDate,
  cast ('_' as approvalstatus_ll) AS ApprovalStatus,
  cast ('00000000' as kdatb) AS ValidityStartDate,
  cast ('00000000' as kdate) AS ValidityEndDate,
  _Partner._Supplier.SupplierName AS PreferredSupplierName
FROM I_PurchaseContract AS _Header
INNER JOIN I_PurchaseContract AS _Hdr ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN C_PurContrMassUpdtValdtyStsVH AS _ContractStatusVH ON PurchaseContract = _ContractStatusVH.PurchaseContract  -- association [1..1]
LEFT OUTER JOIN P_ContractItemCount AS _CtrCount ON _CtrCount.PurchaseContract = PurchaseContract  -- association [1..1]
LEFT OUTER JOIN I_PurgDocumentItemCategory AS _ItemCategory ON _Item.PurchasingDocumentItemCategory = _ItemCategory.PurchasingDocumentItemCategory  -- association [1..1]
-- UNION ALL with additional select branch(es): I_PurchaseContractItem, I_PurchasingDocumentPartner
;