I_ProductProcTP

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_ProductProcTP.
-- 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_ProductProcTP AS
SELECT
  MasterDataChangeProcess,
  MDChgProcessStep,
  MDChgProcessSrceSystem,
  MDChgProcessSrceObject,
  Product,
  CreationDate,
  CreationTime,
  CreatedByUser,
  LastChangeDate,
  IsMarkedForDeletion,
  ProductType,
  IndustrySector,
  ProductGroup,
  ProductOldID,
  BaseUnit,
  ProductDocumentNumber,
  ProductDocumentType,
  ProductDocumentVersion,
  ProductDocumentPageFormat,
  ProductDocumentChangeNumber,
  ProductDocumentPageNumber,
  ProductDocumentPageCount,
  ProductionOrInspectionMemoTxt,
  ProductionMemoPageFormat,
  SizeOrDimensionText,
  BasicMaterial,
  IndustryStandardName,
  LaboratoryOrDesignOffice,
  GrossWeight,
  NetWeight,
  WeightUnit,
  MaterialVolume,
  VolumeUnit,
  Division,
  CompetitorID,
  ProductStandardID,
  InternationalArticleNumberCat,
  BaseUnitSpecificProductLength,
  BaseUnitSpecificProductWidth,
  BaseUnitSpecificProductHeight,
  ProductMeasurementUnit,
  ProductHierarchy,
  DocumentIsCreatedByCAD,
  ProductIsConfigurable,
  IsBatchManagementRequired,
  PackagingMaterialGroup,
  AuthorizationGroup,
  ValidityStartDate,
  ProductValidEndDate,
  HasEmptiesBOM,
  ExternalProductGroup,
  CrossPlantConfigurableProduct,
  CrossPlantStatus,
  CrossPlantStatusValidityDate,
  ContentUnit,
  NetContent,
  GrossContent,
  ProdIsEnvironmentallyRelevant,
  ProdAllocDetnProcedure,
  DiscountInKindEligibility,
  ProductManufacturerNumber,
  ManufacturerNumber,
  OwnInventoryManagedProduct,
  ManufacturerPartProfile,
  DangerousGoodsIndProfile,
  ProductIsHighlyViscous,
  TransportIsInBulk,
  SerialNoExplicitnessLevel,
  IsApprovedBatchRecordReqd,
  ProdEffctyParamValsAreAssigned,
  ItemCategoryGroup,
  AssortmentListType,
  ProdNoInGenProdInPrepackProd,
  PackingReferenceProduct,
  StandardHandlingUnitType,
  IsPilferable,
  WarehouseStorageCondition,
  WarehouseProductGroup,
  HandlingIndicator,
  IsRelevantForHzdsSubstances,
  HandlingUnitType,
  HasVariableTareWeight,
  MaximumCapacity,
  OvercapacityTolerance,
  MaximumPackagingLength,
  MaximumPackagingWidth,
  MaximumPackagingHeight,
  UnitForMaxPackagingDimensions,
  CountryOfOrigin,
  QuarantinePeriod,
  TimeUnitForQuarantinePeriod,
  QualityInspectionGroup,
  HasTextilePartsWthAnimalOrigin,
  LastChangeTime,
  IsChemicalComplianceRelevant,
  ANPCode,
  ProductSeasonUsageCategory,
  Brand,
  MDChgProcSrceLastChgdDateTime,
  MDChgProcessSourceModified,
  MDChgProcessSourceModifBinary,
  MDChgProcessValidationStatus
FROM I_ProductProc
LEFT OUTER JOIN I_UnitOfMeasure AS _WeightUnitOfMeasure ON WeightUnit = _WeightUnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_ExtProdGrp AS _ExtProdGrp ON ExternalProductGroup = _ExtProdGrp.ExternalProductGroup  -- association [0..1]
LEFT OUTER JOIN I_IndustrySector AS _IndustrySector ON IndustrySector = _IndustrySector.IndustrySector  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnitOfMeasure ON BaseUnit = _BaseUnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_DocInfoRecdLabOfficeText AS _LabOfficeDescription ON _LabOfficeDescription.LaboratoryOrDesignOffice = LaboratoryOrDesignOffice  -- association [0..*]
LEFT OUTER JOIN I_MaterialGroupPackingMaterial AS _PackagingMaterialGroup ON _PackagingMaterialGroup.MaterialGroupPackingMaterial = PackagingMaterialGroup  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasureText AS _UnitOfMeasureText ON _UnitOfMeasureText.UnitOfMeasure = BaseUnit  -- association [0..*]
LEFT OUTER JOIN I_ProductProcKPIRecordType AS _RecordType ON MasterDataChangeProcess = _RecordType.MasterDataChangeProcess AND MDChgProcessStep = _RecordType.MDChgProcessStep AND MDChgProcessSrceSystem = _RecordType.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _RecordType.MDChgProcessSrceObject  -- association [0..1]
LEFT OUTER JOIN I_MDChangeProcessKPIRowVH AS _KPIUpdateStatusText ON MDChgProcKPIUpdateStatus = _KPIUpdateStatusText.MDChgProcKPIUpdateStatus  -- association [0..1]
LEFT OUTER JOIN I_MDChgProcKPIFilterRecordSts AS _KPIRecordStatusText ON MDChgProcessValidationStatus = _KPIRecordStatusText.MDChangeProcKPIValueKey AND _KPIRecordStatusText.MDChangeProcKPIFilter = '\\KPI\\RECORD_STATUS'  -- association [0..1]
LEFT OUTER JOIN I_MDChgProcRecordMessages AS _RecordMessages ON MasterDataChangeProcess = _RecordMessages.MasterDataChangeProcess AND MDChgProcessStep = _RecordMessages.MDChgProcessStep AND MDChgProcessSrceSystem = _RecordMessages.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _RecordMessages.MDChgProcessSrceObject  -- association [0..*]
LEFT OUTER JOIN I_MDChangeProcessRecordTarget AS _RecordTarget ON MasterDataChangeProcess = _RecordTarget.MasterDataChangeProcess AND MDChgProcessSrceSystem = _RecordTarget.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _RecordTarget.MDChgProcessSrceObject AND _RecordTarget.MDChgProcessSrceObjectTypeCode = '194'  -- association [0..1]
LEFT OUTER JOIN I_MDChgProcKPIFilterActvtnSts AS _RecordTargetText ON MDChgProcessActivationTarget = _RecordTargetText.MDChangeProcKPIValueKey AND _RecordTargetText.MDChangeProcKPIFilter = '\\KPI\\ACT_STATUS'  -- association [0..1]
LEFT OUTER JOIN I_MDChgProcReplicationStatus AS _ReplicationStatus ON MasterDataChangeProcess = _ReplicationStatus.MasterDataChangeProcess AND MDChgProcessStep = _ReplicationStatus.MDChgProcessStep AND MDChgProcessSrceSystem = _ReplicationStatus.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _ReplicationStatus.MDChgProcessSrceObject  -- association [0..1]
LEFT OUTER JOIN I_MDChgProcKPIFltrReplication AS _ReplicationStatusText ON MDChgProcessReplicationStatus = _ReplicationStatusText.MDChangeProcKPIValueKey AND _ReplicationStatusText.MDChangeProcKPIFilter = '\\KPI\\REP_STATUS'  -- association [0..1]
LEFT OUTER JOIN I_ProductDescriptionProcTP AS _ProductDescription ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_ProductUnitOfMeasureProcTP AS _ProductUnitOfMeasure ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_ProductSalesProcTP AS _ProductSales ON /* condition not available in parsed metadata */  -- association [0..1]
LEFT OUTER JOIN I_ProductProcurementProcTP AS _ProductProcurement ON /* condition not available in parsed metadata */  -- association [0..1]
LEFT OUTER JOIN I_ProdQualityManagementProcTP AS _ProductQualityManagement ON /* condition not available in parsed metadata */  -- association [0..1]
LEFT OUTER JOIN I_ProductStorageProcTP AS _ProductStorage ON /* condition not available in parsed metadata */  -- association [0..1]
LEFT OUTER JOIN I_ProductClassAssignmentProcTP AS _ProductClassAssignment ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_ProductCharValuationProcTP AS _ProductCharValuation ON /* condition not available in parsed metadata */  -- association [0..*]
;