R_ProductTP

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 R_ProductTP.
-- 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 R_ProductTP AS
SELECT
  cast (Product as productnumber preserving type ) AS Product,
  ProductType,
  CreationDate,
  CreationTime,
  CreationDateTime,
  CreatedByUser,
  LastChangeDate,
  LastChangedByUser,
  IsMarkedForDeletion,
  CrossPlantStatus,
  CrossPlantStatusValidityDate,
  ProductOldID,
  GrossWeight,
  WeightUnit,
  ProductGroup,
  BaseUnit,
  ItemCategoryGroup,
  NetWeight,
  Division,
  VolumeUnit,
  MaterialVolume AS ProductVolume,
  AuthorizationGroup,
  ANPCode,
  SizeOrDimensionText,
  IndustryStandardName,
  ProductStandardID,
  InternationalArticleNumberCat,
  ProductIsConfigurable,
  IsBatchManagementRequired,
  ExternalProductGroup,
  CrossPlantConfigurableProduct,
  SerialNoExplicitnessLevel,
  ProductManufacturerNumber,
  ManufacturerNumber,
  ManufacturerPartProfile,
  IsApprovedBatchRecordReqd,
  HandlingIndicator,
  WarehouseProductGroup,
  WarehouseStorageCondition,
  StandardHandlingUnitType,
  SerialNumberProfile,
  IsPilferable,
  IsRelevantForHzdsSubstances,
  QuarantinePeriod,
  TimeUnitForQuarantinePeriod,
  QualityInspectionGroup,
  HandlingUnitType,
  HasVariableTareWeight,
  MaximumPackagingLength,
  MaximumPackagingWidth,
  MaximumPackagingHeight,
  MaximumCapacity,
  OvercapacityTolerance,
  UnitForMaxPackagingDimensions,
  BaseUnitSpecificProductLength,
  BaseUnitSpecificProductWidth,
  BaseUnitSpecificProductHeight,
  ProductMeasurementUnit,
  ArticleCategory,
  _ProductRetail.CountryOfOrigin AS CountryOfOrigin,
  Brand AS RetailArticleBrand,
  ValidityStartDate AS ProductValidStartDate,
  ProdNoInGenProdInPrepackProd AS ProdNrOfGnrcProdInPrepckProds,
  ContentUnit,
  NetContent AS ProductNetContentQuantity,
  GrossContent AS ProductGrossContentQuantity,
  ProductValidEndDate,
  AssortmentListType,
  HasTextilePartsWthAnimalOrigin AS TextilePartsIsWithAnimalOrigin,
  ProductSeasonUsageCategory,
  HasEmptiesBOM AS BillOfMaterialIsForEmpties,
  ProductConfiguration,
  _ProductRetail.ServiceAgreement AS ServiceAgreement,
  _ProductRetail.ConsumptionValueCategory AS ConsumptionValueCategory,
  _ProductRetail.GoodsIssueUnit AS GoodsIssueUnit,
  _ProductRetail.RegionOfOrigin AS RegionOfOrigin,
  _ProductRetail.ValuationClass AS ValuationClass,
  _ProductRetail.ValuationMargin AS ValuationMarginPercent,
  _ProductRetail.SalesUnit AS SalesUnit,
  IndustrySector,
  LastChangeDateTime,
  LastChangeTime,
  DangerousGoodsIndProfile,
  ProductDocumentChangeNumber,
  ProductDocumentPageCount,
  ProductDocumentPageNumber,
  OwnInventoryManagedProduct,
  DocumentIsCreatedByCAD,
  ProductionOrInspectionMemoTxt,
  ProductionMemoPageFormat,
  ProductIsHighlyViscous,
  TransportIsInBulk,
  ProdEffctyParamValsAreAssigned,
  ProdIsEnvironmentallyRelevant,
  LaboratoryOrDesignOffice,
  PackagingMaterialGroup AS PackagingProductGroup,
  PackingReferenceProduct,
  BasicMaterial AS BasicProduct,
  ProductDocumentNumber,
  ProductDocumentVersion,
  ProductDocumentType,
  ProductDocumentPageFormat,
  IsChemicalComplianceRelevant AS ProdChmlCmplncRelevanceCode,
  DiscountInKindEligibility,
  CompetitorID AS ProdCompetitorCustomerNumber,
  ProductHierarchy,
  ProdAllocDetnProcedure,
  _ProductRetail._SalesUnit AS _SalesUnit,
  _ProductRetail._GoodsIssueUnit AS _GoodsIssueUnit
FROM I_Product
LEFT OUTER JOIN R_VariantConfigurationTP AS _VariantConfiguration ON VarConfigurationBusObjectType = _VariantConfiguration.VarConfigurationBusObjectType AND VarConfigurationBusObjectKey = _VariantConfiguration.VarConfigurationBusObjectKey  -- association [0..1]
LEFT OUTER JOIN E_Product AS _ActiveProductExt ON Product = _ActiveProductExt.Product  -- association [1]
LEFT OUTER JOIN R_ProductDescriptionTP AS _ProductDescription ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_ProductUnitOfMeasureTP AS _ProductUnitOfMeasure ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_ProductPlantTP AS _ProductPlant ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_ProductSalesDeliveryTP AS _ProductSalesDelivery ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_ProductSalesTP AS _ProductSales ON /* condition not available in parsed metadata */  -- association [0..1]
LEFT OUTER JOIN R_ProductProcurementTP AS _ProductProcurement ON /* condition not available in parsed metadata */  -- association [0..1]
LEFT OUTER JOIN R_ProductQualityManagementTP AS _ProductQualityManagement ON /* condition not available in parsed metadata */  -- association [0..1]
LEFT OUTER JOIN R_ProductValuationTP AS _ProductValuation ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_ProductStorageTP AS _ProductStorage ON /* condition not available in parsed metadata */  -- association [0..1]
LEFT OUTER JOIN R_ProductEWMWarehouseTP AS _ProductEWMWarehouse ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_ProductChangeMasterTP AS _ProductChangeMaster ON /* condition not available in parsed metadata */  -- association [0..*]
;