C_CeCoMassUpdtDocsImpacted

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_CeCoMassUpdtDocsImpacted.
-- 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: CECODOCSIMPACTED

CREATE VIEW C_CeCoMassUpdtDocsImpacted AS
SELECT
  P_PurgDocsSimlnDistDocs.SimulationJobUUID AS SimulationJobUUID,
  P_PurgDocsSimlnDistDocs.PurchasingDocument AS PurchasingDocument,
  P_PurgDocsSimlnDistDocs.PurchasingDocumentItem AS PurchasingDocumentItem,
  _CentralPurchaseContractHeader.PurchaseContractType AS PurchaseContractType,
  _CentralPurchaseContractHeader.PurchasingGroup AS PurchasingGroup,
  _CentralPurchaseContractHeader.PurchasingOrganization AS PurchasingOrganization,
  _CentralPurchaseContractHeader.CompanyCode AS CompanyCode,
  _CentralPurchaseContractHeader.CntrlPurContrFlxblDistrIsAllwd AS CntrlPurContrFlxblDistrIsAllwd,
  _CentralPurchaseContractHeader.Supplier AS Supplier,
  _CentralPurchaseContractHeader.ValidityStartDate AS ValidityStartDate,
  _CentralPurchaseContractHeader.ValidityEndDate AS ValidityEndDate,
  _CentralPurchaseContractHeader.PurchaseContractTargetAmount AS PurchaseContractTargetAmount,
  _CentralPurchaseContractHeader.Currency AS Currency,
  _CentralPurchaseContractHeader.PaymentTerms AS PaymentTerms,
  _CentralPurchaseContractHeader.CashDiscount1Days AS CashDiscount1Days,
  _CentralPurchaseContractHeader.CashDiscount1Percent AS CashDiscount1Percent,
  _CentralPurchaseContractHeader.CashDiscount2Days AS CashDiscount2Days,
  _CentralPurchaseContractHeader.CashDiscount2Percent AS CashDiscount2Percent,
  _CentralPurchaseContractHeader.NetPaymentDays AS NetPaymentDays,
  _CentralPurchaseContractHeader.IncotermsClassification AS IncotermsClassification,
  _CentralPurchaseContractHeader.IncotermsLocation1 AS IncotermsLocation1,
  _CentralPurchaseContractHeader.IncotermsLocation2 AS IncotermsLocation2,
  _CentralPurchaseContractHeader.IncotermsVersion AS IncotermsVersion,
  _CentralPurchaseContractHeader.QuotationSubmissionDate AS QuotationSubmissionDate,
  _CentralPurchaseContractHeader.SupplierQuotation AS SupplierQuotation,
  _CentralPurchaseContractHeader.CorrespncExternalReference AS CorrespncExternalReference,
  _CentralPurchaseContractHeader.CorrespncInternalReference AS CorrespncInternalReference,
  _CentralPurchaseContractHeader.SupplierRespSalesPersonName AS SupplierRespSalesPersonName,
  _CentralPurchaseContractHeader.SupplierPhoneNumber AS SupplierPhoneNumber,
  _CentralPurchaseContractHeader.PurchasingDocVersionReasonCode AS PurchasingDocVersionReasonCode,
  _CentralPurchaseContractHeader.PurchasingDocumentSubtype AS PurchasingDocumentSubtype,
  _CentralPurchaseContractItem.PurchaseContractItemText AS PurchaseContractItemText,
  _CentralPurchaseContractItem.TargetQuantity AS TargetQuantity,
  _CentralPurchaseContractItem.OrderQuantityUnit AS OrderQuantityUnit,
  _CentralPurchaseContractItem.PurgDocReleaseOrderQuantity AS PurgDocReleaseOrderQuantity,
  _CentralPurchaseContractItem.NoDaysReminder1 AS NoDaysReminder1,
  _CentralPurchaseContractItem.NoDaysReminder2 AS NoDaysReminder2,
  _CentralPurchaseContractItem.NoDaysReminder3 AS NoDaysReminder3,
  _CentralPurchaseContractItem.SupplierConfirmationControlKey AS SupplierConfirmationControlKey,
  _CentralPurchaseContractItem.PurgDocOrderAcknNumber AS PurgDocOrderAcknNumber,
  _CentralPurchaseContractItem.RequirementTracking AS RequirementTracking,
  _CentralPurchaseContractItem.SupplierMaterialNumber AS SupplierMaterialNumber,
  _CentralPurchaseContractItem.IsOrderAcknRqd AS IsOrderAcknRqd,
  _CentralPurchaseContractItem.PurgDocEstimatedPrice AS PurchasingPriceIsEstimated,
  _CentralPurchaseContractItem.PriceIsToBePrinted AS PriceIsToBePrinted,
  _CentralPurchaseContractItem.UnderdelivTolrtdLmtRatioInPct AS UnderdelivTolrtdLmtRatioInPct,
  _CentralPurchaseContractItem.OverdelivTolrtdLmtRatioInPct AS OverdelivTolrtdLmtRatioInPct,
  _CentralPurchaseContractItem.UnlimitedOverdeliveryIsAllowed AS UnlimitedOverdeliveryIsAllowed,
  _CentralPurchaseContractItem.StockType AS StockType,
  _CentralPurchaseContractItem.TaxCode AS TaxCode,
  _CentralPurchaseContractItem.ShippingInstruction AS ShippingInstruction,
  _CentralPurchaseContractItem.IsInfoAtRegistration AS IsInfoAtRegistration,
  _CentralPurchaseContractItem.GoodsReceiptIsExpected AS GoodsReceiptIsExpected,
  _CentralPurchaseContractItem.GoodsReceiptIsNonValuated AS GoodsReceiptIsNonValuated,
  _CentralPurchaseContractItem.InvoiceIsExpected AS InvoiceIsExpected,
  _CentralPurchaseContractItem.InvoiceIsGoodsReceiptBased AS InvoiceIsGoodsReceiptBased,
  _CentralPurchaseContractItem.EvaldRcptSettlmtIsAllowed AS EvaldRcptSettlmtIsAllowed,
  _CentralPurchaseContractMass.PurchasingProcessingStatus AS PurchasingDocumentStatus,
  _CentralPurchaseContractMass._CntrlPurContrStatusText.DocumentStatusName AS DocumentStatusName
LEFT OUTER JOIN I_IncotermsVersionText AS _IncotermsVersionText ON IncotermsVersion = _IncotermsVersionText.IncotermsVersion AND _IncotermsVersionText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN C_CntrlPurContrTypeValueHelp AS _CntrlPurContrTypeValueHelp ON PurchaseContractType = _CntrlPurContrTypeValueHelp.PurchasingDocumentType  -- association [1..1]
LEFT OUTER JOIN I_CurrencyText AS _CurrencyText ON Currency = _CurrencyText.Currency  -- association [0..*]
LEFT OUTER JOIN C_SchedAgrmtMassUpdtStkTypeVH AS _SchedAgrmtMassUpdtStkTypeVH ON StockType = _SchedAgrmtMassUpdtStkTypeVH.DomainValue  -- association [0..1]
LEFT OUTER JOIN I_PaymentTermsText AS _PaymentTermsText ON PaymentTerms = _PaymentTermsText.PaymentTerms  -- association [0..*]
LEFT OUTER JOIN I_IncotermsClassificationText AS _IncotermsClassificationText ON IncotermsClassification = _IncotermsClassificationText.IncotermsClassification  -- association [0..*]
LEFT OUTER JOIN C_PurgDocVersionReasonValHelp AS _VersionReasonVH ON PurchasingDocVersionReasonCode = _VersionReasonVH.PurchasingDocVersionReasonCode  -- association [0..1]
LEFT OUTER JOIN C_MassUpdtConfCtrlVH AS _ConfirmationControlVH ON SupplierConfirmationControlKey = _ConfirmationControlVH.SupplierConfirmationControlKey  -- association [0..1]
LEFT OUTER JOIN C_Mm_Shipinstructionvaluehelp AS _ShipInstructionValueHelp ON _ShipInstructionValueHelp.ShippingInstruction = ShippingInstruction  -- association [0..1]
LEFT OUTER JOIN I_CentralPurchaseContractTP AS _CentralPurchaseContractMass ON PurchasingDocument = _CentralPurchaseContractMass.CentralPurchaseContract  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganization ON PurchasingOrganization = _PurchasingOrganization.PurchasingOrganization  -- association [0..1]
LEFT OUTER JOIN I_PurchasingGroup AS _PurchasingGroup ON PurchasingGroup = _PurchasingGroup.PurchasingGroup  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
;