C_PurCntrlContrItmMassUpdt

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_PurCntrlContrItmMassUpdt.
-- 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: CCNTRLCTRITMMASS

CREATE VIEW C_PurCntrlContrItmMassUpdt AS
SELECT
  CentralPurchaseContract,
  CentralPurchaseContractItem,
  ActivePurchasingDocument,
  cast (concat(concat(ActivePurchasingDocument, '/'), CentralPurchaseContractItem) as formattedcontractitem) AS FormattedPurchaseContractItem,
  PurchaseContractType,
  _CntrlPurContrTypeValueHelp.PurchasingDocumentTypeName AS PurchasingDocumentTypeName,
  ProductType,
  ProductTypeCode,
  _ProductTypeHelp.ProductTypeName AS ProductTypeName,
  MaterialGroup,
  _MaterialGroupValueHelp.MaterialGroupName AS MaterialGroupName,
  PurchasingCentralMaterial AS Material,
  PurchaseContractItemText AS MaterialDescription,
  TargetQuantity,
  OrderQuantityUnit,
  PurgDocReleaseOrderQuantity,
  ContractNetPriceAmount,
  DocumentCurrency,
  NetPriceQuantity,
  OrderPriceUnit,
  CntrlPurContrItmTargetAmount,
  NoDaysReminder1,
  NoDaysReminder2,
  NoDaysReminder3,
  SupplierConfirmationControlKey,
  _ConfirmationControlVH.SupplierConfControlKeyName AS SupplierConfControlKeyName,
  PurgDocOrderAcknNumber,
  RequirementTracking,
  SupplierMaterialNumber,
  IsOrderAcknRqd,
  PurgDocEstimatedPrice,
  PriceIsToBePrinted,
  UnderdelivTolrtdLmtRatioInPct,
  OverdelivTolrtdLmtRatioInPct,
  UnlimitedOverdeliveryIsAllowed,
  StockType,
  _SchedAgrmtMassUpdtStkTypeVH.DomainText AS DomainText,
  TaxCode,
  ShippingInstruction,
  _Mm_Shipinstructionvaluehelp.ShippingInstructionName AS ShippingInstructionName,
  IsInfoAtRegistration,
  GoodsReceiptIsExpected,
  GoodsReceiptIsNonValuated,
  InvoiceIsExpected,
  InvoiceIsGoodsReceiptBased,
  EvaldRcptSettlmtIsAllowed,
  PurchasingDocumentItemCategory,
  OrdPriceUnitToOrderUnitDnmntr,
  OrderPriceUnitToOrderUnitNmrtr,
  PlannedDeliveryDurationInDays,
  PricingDateControl,
  _CentralPurchaseContract.PurchasingOrganization AS PurchasingOrganization,
  _CentralPurchaseContract._PurchasingOrganization.PurchasingOrganizationName AS PurchasingOrganizationName,
  _CentralPurchaseContract.PurchasingGroup AS PurchasingGroup,
  _CentralPurchaseContract._PurchasingGroup.PurchasingGroupName AS PurchasingGroupName,
  _CentralPurchaseContract.CompanyCode AS CompanyCode,
  _CentralPurchaseContract._CompanyCode.CompanyCodeName AS CompanyCodeName,
  _CentralPurchaseContract.Supplier AS Supplier,
  _CentralPurchaseContract._Supplier.SupplierName AS SupplierName,
  _CentralPurchaseContract.ValidityStartDate AS ValidityStartDate,
  _CentralPurchaseContract.ValidityEndDate AS ValidityEndDate,
  _CentralPurchaseContract.PurchaseContractTargetAmount AS PurchaseContractTargetAmount,
  _CentralPurchaseContract.Currency AS Currency,
  _CentralPurchaseContract._DocumentCurrency._Text[1: Language = $session.system_language ].CurrencyName AS CurrencyName,
  cast( _CntrlPurContrAggrgnDistrSts.CntrlPurContrDistributionSts as me_distribution_status ) AS PurchasingProcessingStatus,
  _CntrlPurContrAggrgnDistrSts._CntrlPurContrDistrStatusText.ItemDistributionStatusName AS ItemDistributionStatusName,
  _CentralPurchaseContract.PurchasingProcessingStatus AS PurchasingDocumentStatus,
  _CentralPurchaseContractMass._CntrlPurContrStatusText.DocumentStatusName AS DocumentStatusName,
  _CentralPurchaseContract.CreatedByUser AS CreatedByUser,
  _CentralPurchaseContract._CreatedByUser.UserDescription AS UserDescription,
  _CentralPurchaseContract.CreationDate AS CreationDate,
  _CentralPurchaseContract.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked,
  _CentralPurchaseContract.PaymentTerms AS PaymentTerms,
  _CentralPurchaseContract._PaymentTerms._Text[1: Language = $session.system_language ].PaymentTermsName AS PaymentTermsName,
  _CentralPurchaseContract.CashDiscount1Days AS CashDiscount1Days,
  _CentralPurchaseContract.CashDiscount1Percent AS CashDiscount1Percent,
  _CentralPurchaseContract.CashDiscount2Days AS CashDiscount2Days,
  _CentralPurchaseContract.CashDiscount2Percent AS CashDiscount2Percent,
  _CentralPurchaseContract.NetPaymentDays AS NetPaymentDays,
  _CentralPurchaseContract.IncotermsClassification AS IncotermsClassification,
  _CentralPurchaseContract._IncotermsClassification._Text[1: Language = $session.system_language ].IncotermsClassificationName AS IncotermsClassificationName,
  _CentralPurchaseContract.IncotermsLocation1 AS IncotermsLocation1,
  _CentralPurchaseContract.IncotermsLocation2 AS IncotermsLocation2,
  _CentralPurchaseContract.IncotermsVersion AS IncotermsVersion,
  _CentralPurchaseContract._IncotermsVersion._Text[1: Language = $session.system_language].IncotermsVersionName AS IncotermsVersionName,
  _CentralPurchaseContract.QuotationSubmissionDate AS QuotationSubmissionDate,
  _CentralPurchaseContract.SupplierQuotation AS SupplierQuotation,
  _CentralPurchaseContract.CorrespncExternalReference AS CorrespncExternalReference,
  _CentralPurchaseContract.CorrespncInternalReference AS CorrespncInternalReference,
  _CentralPurchaseContract.SupplierRespSalesPersonName AS SupplierRespSalesPersonName,
  _CentralPurchaseContract.SupplierPhoneNumber AS SupplierPhoneNumber,
  cast ('' as xfeld) AS ContrItemIsCreated,
  PurchasingContractDeletionCode,
  _CentralPurchaseContract.PurchasingDocVersionReasonCode AS PurchasingDocVersionReasonCode,
  _CentralPurchaseContract._VersionReasonValHelp.PurchasingDocVersionReasonText AS PurchasingDocVersionReasonText,
  _PurchaseNote.Content AS PurgDocNoteText,
  cast(0 as mm_purgdoc_distr_pct) AS CntrlPurContrDistributionPct,
  cast(0 as mm_purgdoc_distr_pct) AS CntrlPurContrItmDistrPct,
  cast ('' as ekorg) AS ProcmtHubPurchasingOrg,
  cast('' as bkgrp) AS ProcmtHubPurchasingGroup,
  cast('' as bukrs) AS ProcmtHubCompanyCode,
  cast('' as ewerk ) AS Plant,
  cast('00000000000000' as abap.char( 30 )) AS ReleaseDateTime,
  cast ('' as abap.char( 120 )) AS InternalComment,
  cast ('' as abap.sstring( 1332 )) AS PurchasingDocInclusionList,
  cast ('' as abap.sstring( 1332 )) AS PurchasingDocExclusionList,
  cast ('' as abap.char( 1 )) AS PurOrdItemsAreSelected,
  cast ('' as abap.char( 1 )) AS PurOrdHeadersAreSelected
FROM I_CntrlPurchaseContractItem
LEFT OUTER JOIN I_CentralPurchaseContract AS _CentralPurchaseContract ON CentralPurchaseContract = _CentralPurchaseContract.CentralPurchaseContract  -- association [1..1]
LEFT OUTER JOIN C_MM_MaterialGroupValueHelp AS _MaterialGroupValueHelp ON _MaterialGroupValueHelp.MaterialGroup = MaterialGroup  -- association [0..1]
LEFT OUTER JOIN C_ContractPrdTypeVH AS _ProductTypeHelp ON _ProductTypeHelp.ProductType = ProductTypeCode  -- association [0..1]
LEFT OUTER JOIN C_CntrlPurContrTypeValueHelp AS _CntrlPurContrTypeValueHelp ON PurchaseContractType = _CntrlPurContrTypeValueHelp.PurchasingDocumentType  -- association [1..1]
LEFT OUTER JOIN C_MassUpdtConfCtrlVH AS _ConfirmationControlVH ON SupplierConfirmationControlKey = _ConfirmationControlVH.SupplierConfirmationControlKey  -- association [1..1]
LEFT OUTER JOIN C_Mm_Shipinstructionvaluehelp AS _Mm_Shipinstructionvaluehelp ON _Mm_Shipinstructionvaluehelp.ShippingInstruction = ShippingInstruction  -- association [0..1]
LEFT OUTER JOIN C_SchedAgrmtMassUpdtStkTypeVH AS _SchedAgrmtMassUpdtStkTypeVH ON _SchedAgrmtMassUpdtStkTypeVH.DomainValue = StockType  -- association [0..1]
LEFT OUTER JOIN I_CentralPurchaseContractTP AS _CentralPurchaseContractMass ON CentralPurchaseContract = _CentralPurchaseContractMass.CentralPurchaseContract  -- 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 E_PurchasingDocumentItem AS _PurchasingDocItemExtension ON CentralPurchaseContract = _PurchasingDocItemExtension.PurchasingDocument AND CentralPurchaseContractItem = _PurchasingDocItemExtension.PurchasingDocumentItem  -- association [1..1]
LEFT OUTER JOIN E_PurchasingDocument AS _PurchasingDocumentExtension ON CentralPurchaseContract = _PurchasingDocumentExtension.PurchasingDocument  -- association [1..1]
LEFT OUTER JOIN I_CntrlPurContrAggrgnDistrSts AS _CntrlPurContrAggrgnDistrSts ON CentralPurchaseContract = _CntrlPurContrAggrgnDistrSts.CentralPurchaseContract  -- association [0..1]
;