C_BatchCertificate

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_BatchCertificate.
-- 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: CBATCHCERTI

CREATE VIEW C_BatchCertificate AS
SELECT
  Batches.Batch AS Batch,
  Batches.Material AS Material,
  Batches.Plant AS Plant,
  _MaterialText.MaterialName AS MaterialName,
  Batches._Plant.PlantName AS PlantName,
  Batches.BatchIsMarkedForDeletion AS BatchIsMarkedForDeletion,
  Batches.MatlBatchIsInRstrcdUseStock AS MatlBatchIsInRstrcdUseStock,
  Batches.Supplier AS Supplier,
  Batches.BatchBySupplier AS BatchBySupplier,
  Batches.CountryOfOrigin AS CountryOfOrigin,
  Batches.RegionOfOrigin AS RegionOfOrigin,
  Batches.MatlBatchAvailabilityDate AS MatlBatchAvailabilityDate,
  Batches.ShelfLifeExpirationDate AS ShelfLifeExpirationDate,
  Batches.ManufactureDate AS ManufactureDate,
  Batches.NextInspectionDate AS NextInspectionDate,
  Batches.LastGoodsReceiptDate AS LastGoodsReceiptDate,
  Batches.IsSubordinateBatch AS IsSubordinateBatch,
  Batches.BatchIdentifyingPlant AS BatchIdentifyingPlant,
  Batches.CreationDateTime AS CreationDateTime,
  Batches.LastChangeDateTime AS LastChangeDateTime,
  Batches.ClfnObjectInternalID AS ClfnObjectInternalID,
  Batches.BatchExtWhseMgmtInternalId AS BatchExtWhseMgmtInternalId,
  Batches.StockSegment AS StockSegment,
  Batches.InventoryValuationType AS InventoryValuationType,
  cast( '' as kztxt_batch ) AS BatchShortDescription,
  cast( '' as kunnr ) AS Customer,
  cast( '' as md_customer_name ) AS CustomerName,
  cast( '' as land1_gp ) AS Country,
  cast( '' as ort01_gp ) AS CityName,
  cast( '' as pstlz ) AS PostalCode,
  cast( '' as ad_smtpadr ) AS EmailAddress,
  cast( '' as qvorlnr ) AS QltyCertificateProfile,
  cast( '' as qzgtyp ) AS QualityCertificateType,
  cast( '' as qcversion ) AS QltyCertProfileVersion,
  cast ( '' as na_parnr ) AS QltyCertRecipientNumber,
  cast( '' as qc_recipient_type ) AS QltyCertRecipientType
FROM I_Batch AS Batches
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON Batches.Material = _MaterialText.Material AND _MaterialText.Language = $session.system_language  -- association [1]
LEFT OUTER JOIN I_Product AS _Product ON Material = _Product.Product  -- association [1..1]
LEFT OUTER JOIN I_CountryText AS _CountryText ON Country = _CountryText.Country AND _CountryText.Language = $session.system_language  -- association [1..1]
;