I_ProductGovTP

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_ProductGovTP.
-- 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_ProductGovTP AS
SELECT
  MasterDataChangeProcess,
  MDChgProcessSrceSystem,
  MDChgProcessSrceObject,
  MDChgProcessStep,
  MDChgProcessGoal,
  Product,
  PackingReferenceProduct,
  ProdNoInGenProdInPrepackProd,
  AssortmentListType,
  ItemCategoryGroup,
  ProdEffctyParamValsAreAssigned,
  IsApprovedBatchRecordReqd,
  SerialNoExplicitnessLevel,
  TransportIsInBulk,
  ProductIsHighlyViscous,
  DangerousGoodsIndProfile,
  ManufacturerPartProfile,
  OwnInventoryManagedProduct,
  ManufacturerNumber,
  ProductManufacturerNumber,
  DiscountInKindEligibility,
  ProdAllocDetnProcedure,
  ProdIsEnvironmentallyRelevant,
  GrossContent,
  NetContent,
  ContentUnit,
  CrossPlantStatusValidityDate,
  CrossPlantStatus,
  CrossPlantConfigurableProduct,
  StandardHandlingUnitType,
  Brand,
  ProductSeasonUsageCategory,
  ANPCode,
  IsChemicalComplianceRelevant,
  LastChangedByUser,
  LastChangeTime,
  HasTextilePartsWthAnimalOrigin,
  QualityInspectionGroup,
  TimeUnitForQuarantinePeriod,
  QuarantinePeriod,
  CountryOfOrigin,
  UnitForMaxPackagingDimensions,
  MaximumPackagingHeight,
  MaximumPackagingWidth,
  MaximumPackagingLength,
  OvercapacityTolerance,
  MaximumCapacity,
  HasVariableTareWeight,
  HandlingUnitType,
  IsRelevantForHzdsSubstances,
  HandlingIndicator,
  WarehouseProductGroup,
  WarehouseStorageCondition,
  IsPilferable,
  IndustryStandardName,
  BasicMaterial,
  SizeOrDimensionText,
  ProductionMemoPageFormat,
  ProductionOrInspectionMemoTxt,
  ProductDocumentPageCount,
  ProductDocumentPageNumber,
  ProductDocumentChangeNumber,
  ProductDocumentPageFormat,
  ProductDocumentVersion,
  ProductDocumentType,
  ProductDocumentNumber,
  BaseUnit,
  ProductOldID,
  ProductGroup,
  IndustrySector,
  ProductType,
  IsMarkedForDeletion,
  LastChangeDate,
  CreatedByUser,
  CreationTime,
  CreationDate,
  LaboratoryOrDesignOffice,
  ExternalProductGroup,
  HasEmptiesBOM,
  ProductValidEndDate,
  ValidityStartDate,
  AuthorizationGroup,
  PackagingMaterialGroup,
  IsBatchManagementRequired,
  ProductIsConfigurable,
  DocumentIsCreatedByCAD,
  ProductHierarchy,
  ProductMeasurementUnit,
  BaseUnitSpecificProductHeight,
  BaseUnitSpecificProductWidth,
  BaseUnitSpecificProductLength,
  InternationalArticleNumberCat,
  ProductStandardID,
  CompetitorID,
  Division,
  VolumeUnit,
  MaterialVolume,
  WeightUnit,
  NetWeight,
  GrossWeight,
  dats_tims_to_tstmp( CreationDate, CreationTime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL') as CreationDateTime AS clientNULLasCreationDateTime,
  dats_tims_to_tstmp( LastChangeDate, LastChangeTime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL') as LastChangeDateTime AS clientNULLasLastChangeDateTime
FROM I_ProductGov
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_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN P_ProductImageURL AS _ProductImageURL ON MasterDataChangeProcess = _ProductImageURL.MasterDataChangeProcess AND MDChgProcessSrceSystem = _ProductImageURL.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _ProductImageURL.MDChgProcessSrceObject  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasureText AS _UnitOfMeasureText ON _UnitOfMeasureText.UnitOfMeasure = BaseUnit  -- association [0..*]
LEFT OUTER JOIN I_ProductDescriptionGovTP AS _ProductDescription ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_ProductUnitOfMeasureGovTP AS _ProductUnitOfMeasure ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_ProductSalesGovTP AS _ProductSales ON /* condition not available in parsed metadata */  -- association [0..1]
LEFT OUTER JOIN I_ProductProcurementGovTP AS _ProductProcurement ON /* condition not available in parsed metadata */  -- association [0..1]
LEFT OUTER JOIN I_ProdQualityManagementGovTP AS _ProductQualityManagement ON /* condition not available in parsed metadata */  -- association [0..1]
LEFT OUTER JOIN I_ProductStorageGovTP AS _ProductStorage ON /* condition not available in parsed metadata */  -- association [0..1]
LEFT OUTER JOIN I_ProductClassAssignmentGovTP AS _ProductClassAssignment ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_ProductCharValuationGovTP AS _ProductCharValuation ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_ProductGovChgProcTP AS _Process ON /* condition not available in parsed metadata */  -- association [0..1]
;