I_ProductProc

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 I_ProductProc.
-- 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.

CREATE VIEW I_ProductProc AS
SELECT
  process_id AS MasterDataChangeProcess,
  process_step_no AS MDChgProcessStep,
  source_system AS MDChgProcessSrceSystem,
  source_id AS MDChgProcessSrceObject,
  cast( matnr as productnumber preserving type ) AS Product,
  ersda AS CreationDate,
  created_at_time AS CreationTime,
  ernam AS CreatedByUser,
  laeda AS LastChangeDate,
  lvorm AS IsMarkedForDeletion,
  cast( mtart as producttype preserving type ) AS ProductType,
  mbrsh AS IndustrySector,
  cast( matkl as productgroup preserving type ) AS ProductGroup,
  bismt AS ProductOldID,
  meins AS BaseUnit,
  zeinr AS ProductDocumentNumber,
  zeiar AS ProductDocumentType,
  zeivr AS ProductDocumentVersion,
  zeifo AS ProductDocumentPageFormat,
  aeszn AS ProductDocumentChangeNumber,
  blatt AS ProductDocumentPageNumber,
  blanz AS ProductDocumentPageCount,
  ferth AS ProductionOrInspectionMemoTxt,
  formt AS ProductionMemoPageFormat,
  groes AS SizeOrDimensionText,
  wrkst AS BasicMaterial,
  normt AS IndustryStandardName,
  labor AS LaboratoryOrDesignOffice,
  brgew AS GrossWeight,
  ntgew AS NetWeight,
  gewei AS WeightUnit,
  volum AS MaterialVolume,
  voleh AS VolumeUnit,
  spart AS Division,
  kunnr AS CompetitorID,
  ean11 AS ProductStandardID,
  numtp AS InternationalArticleNumberCat,
  aenam AS LastChangedByUser,
  laeng AS BaseUnitSpecificProductLength,
  breit AS BaseUnitSpecificProductWidth,
  hoehe AS BaseUnitSpecificProductHeight,
  meabm AS ProductMeasurementUnit,
  prdha AS ProductHierarchy,
  cadkz AS DocumentIsCreatedByCAD,
  cast( kzkfg as productisconfigurable preserving type ) AS ProductIsConfigurable,
  xchpf AS IsBatchManagementRequired,
  magrv AS PackagingMaterialGroup,
  begru AS AuthorizationGroup,
  datab AS ValidityStartDate,
  liqdt AS ProductValidEndDate,
  mlgut AS HasEmptiesBOM,
  cast( extwg as externalproductgroup preserving type ) AS ExternalProductGroup,
  cast( satnr as crossplantconfigurableproduct preserving type ) AS CrossPlantConfigurableProduct,
  mstae AS CrossPlantStatus,
  mstde AS CrossPlantStatusValidityDate,
  inhme AS ContentUnit,
  inhal AS NetContent,
  inhbr AS GrossContent,
  kzumw AS ProdIsEnvironmentallyRelevant,
  kosch AS ProdAllocDetnProcedure,
  nrfhg AS DiscountInKindEligibility,
  mfrpn AS ProductManufacturerNumber,
  mfrnr AS ManufacturerNumber,
  bmatn AS OwnInventoryManagedProduct,
  mprof AS ManufacturerPartProfile,
  profl AS DangerousGoodsIndProfile,
  ihivi AS ProductIsHighlyViscous,
  iloos AS TransportIsInBulk,
  serlv AS SerialNoExplicitnessLevel,
  xgchp AS IsApprovedBatchRecordReqd,
  kzeff AS ProdEffctyParamValsAreAssigned,
  mtpos_mara AS ItemCategoryGroup,
  bbtyp AS AssortmentListType,
  gennr AS ProdNoInGenProdInPrepackProd,
  rmatp AS PackingReferenceProduct,
  hutyp_dflt AS StandardHandlingUnitType,
  pilferable AS IsPilferable,
  whstc AS WarehouseStorageCondition,
  whmatgr AS WarehouseProductGroup,
  hndlcode AS HandlingIndicator,
  hazmat AS IsRelevantForHzdsSubstances,
  hutyp AS HandlingUnitType,
  tare_var AS HasVariableTareWeight,
  maxc AS MaximumCapacity,
  maxc_tol AS OvercapacityTolerance,
  maxl AS MaximumPackagingLength,
  maxb AS MaximumPackagingWidth,
  maxh AS MaximumPackagingHeight,
  maxdim_uom AS UnitForMaxPackagingDimensions,
  herkl AS CountryOfOrigin,
  qqtime AS QuarantinePeriod,
  qqtimeuom AS TimeUnitForQuarantinePeriod,
  qgrp AS QualityInspectionGroup,
  animal_origin AS HasTextilePartsWthAnimalOrigin,
  last_changed_time AS LastChangeTime,
  cast( chml_cmplnc_rlvnce_ind as chml_cmplnc_rlvnce_ind_pm preserving type ) AS IsChemicalComplianceRelevant,
  anp AS ANPCode,
  cast (attyp as prodcategory preserving type ) AS ProductCategory,
  fsh_sealv AS ProductSeasonUsageCategory,
  brand_id AS Brand,
  source_recency AS MDChgProcSrceLastChgdDateTime,
  validation_status AS MDChgProcessValidationStatus,
  source_modified AS MDChgProcessSourceModified,
  source_modification_blip AS MDChgProcessSourceModifBinary
FROM mara_prc
;