A_Product_3

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 A_Product_3.
-- 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 A_Product_3 AS
SELECT
  Product,
  ProductType,
  CreationDate,
  CreationTime,
  CreationDateTime,
  CreatedByUser,
  LastChangeDate,
  LastChangedByUser,
  IsMarkedForDeletion,
  CrossPlantStatus,
  CrossPlantStatusValidityDate,
  ProductOldID,
  GrossWeight,
  WeightUnit,
  cast( _WeightUnitValueHelp.UnitOfMeasureISOCode as gewei_iso preserving type ) AS WeightISOUnit,
  ProductGroup,
  cast( BaseUnit as cmd_prod_meins preserving type ) AS BaseUnit,
  cast( _BaseUnitOfMeasure.UnitOfMeasureISOCode as meins_iso preserving type ) AS BaseISOUnit,
  ItemCategoryGroup,
  NetWeight,
  Division,
  VolumeUnit,
  cast( _QuantityUnitValueHelp.UnitOfMeasureISOCode as voleh_iso preserving type ) AS VolumeISOUnit,
  ProductVolume,
  AuthorizationGroup,
  ANPCode,
  SizeOrDimensionText,
  IndustryStandardName,
  ProductStandardID,
  InternationalArticleNumberCat,
  ProductIsConfigurable,
  IsBatchManagementRequired,
  ExternalProductGroup,
  CrossPlantConfigurableProduct,
  SerialNoExplicitnessLevel,
  IsApprovedBatchRecordReqd,
  HandlingIndicator,
  WarehouseProductGroup,
  WarehouseStorageCondition,
  StandardHandlingUnitType,
  SerialNumberProfile,
  IsPilferable,
  IsRelevantForHzdsSubstances,
  QuarantinePeriod,
  TimeUnitForQuarantinePeriod,
  cast( _TimeUnitForQuarantinePeriod.UnitOfMeasureISOCode as cifqqtimeuom_iso preserving type ) AS QuarantinePeriodISOUnit,
  QualityInspectionGroup,
  HandlingUnitType,
  HasVariableTareWeight,
  MaximumPackagingLength,
  MaximumPackagingWidth,
  MaximumPackagingHeight,
  MaximumCapacity,
  OvercapacityTolerance,
  UnitForMaxPackagingDimensions,
  cast( _UnitForMaxPackaging.UnitOfMeasureISOCode as cifmaxduom_iso preserving type ) AS MaxPackggDimensionISOUnit,
  BaseUnitSpecificProductLength,
  BaseUnitSpecificProductWidth,
  BaseUnitSpecificProductHeight,
  ProductMeasurementUnit,
  cast( _ProductMeasurementUnit.UnitOfMeasureISOCode as meabm_iso preserving type ) AS ProductMeasurementISOUnit,
  ArticleCategory,
  IndustrySector,
  LastChangeDateTime,
  LastChangeTime,
  DangerousGoodsIndProfile,
  ProductDocumentChangeNumber,
  ProductDocumentPageCount,
  ProductDocumentPageNumber,
  DocumentIsCreatedByCAD,
  ProductionOrInspectionMemoTxt,
  ProductionMemoPageFormat,
  ProductIsHighlyViscous,
  TransportIsInBulk,
  ProdEffctyParamValsAreAssigned,
  ProdIsEnvironmentallyRelevant,
  LaboratoryOrDesignOffice,
  PackagingProductGroup,
  PackingReferenceProduct,
  BasicProduct,
  ProductDocumentNumber,
  ProductDocumentVersion,
  ProductDocumentType,
  ProductDocumentPageFormat,
  ProdChmlCmplncRelevanceCode,
  DiscountInKindEligibility,
  ProdCompetitorCustomerNumber,
  ProductHierarchy,
  ProdAllocDetnProcedure,
  ProductManufacturerNumber,
  ManufacturerNumber,
  ManufacturerPartProfile,
  OwnInventoryManagedProduct,
  CountryOfOrigin,
  RetailArticleBrand,
  ProductValidStartDate,
  cast( ContentUnit as cmd_prod_meins preserving type ) AS ContentUnit,
  cast( _ContentUnit.UnitOfMeasureISOCode as meins_iso preserving type ) AS ProductContentISOUnit,
  ProductNetContentQuantity,
  ProductGrossContentQuantity,
  ProductValidEndDate,
  AssortmentListType,
  TextilePartsIsWithAnimalOrigin,
  ProductSeasonUsageCategory,
  BillOfMaterialIsForEmpties,
  ServiceAgreement,
  ConsumptionValueCategory,
  cast( GoodsIssueUnit as cmd_prod_meins preserving type ) AS GoodsIssueUnit,
  cast( _GoodsIssueUnit.UnitOfMeasureISOCode as meins_iso preserving type ) AS GoodsIssueISOUnit,
  RegionOfOrigin,
  ValuationClass,
  cast( SalesUnit as cmd_prod_meins preserving type ) AS SalesUnit,
  cast( _SalesUnit.UnitOfMeasureISOCode as meins_iso preserving type ) AS ProductSalesISOUnit,
  ProductConfiguration,
  VarConfigurationBusObjectKey,
  VarConfigurationBusObjectType
FROM R_ProductTP
;