A_Product

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.
-- 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.
-- SQL view name: APRODUCT

CREATE VIEW A_Product AS
SELECT
  Product,
  ProductType,
  CrossPlantStatus,
  CrossPlantStatusValidityDate,
  CreationDate,
  CreatedByUser,
  LastChangeDate,
  LastChangedByUser,
  LastChangeDateTime,
  IsMarkedForDeletion,
  ProductOldID,
  GrossWeight,
  PurchaseOrderQuantityUnit,
  SourceOfSupply,
  WeightUnit,
  NetWeight,
  CountryOfOrigin,
  CompetitorID,
  ProductGroup,
  BaseUnit,
  ItemCategoryGroup,
  ProductHierarchy,
  Division,
  VarblPurOrdUnitIsActive,
  VolumeUnit,
  MaterialVolume,
  ANPCode,
  Brand,
  ProcurementRule,
  ValidityStartDate,
  LowLevelCode,
  ProdNoInGenProdInPrepackProd,
  SerialIdentifierAssgmtProfile,
  SizeOrDimensionText,
  IndustryStandardName,
  ProductStandardID,
  InternationalArticleNumberCat,
  ProductIsConfigurable,
  IsBatchManagementRequired,
  ExternalProductGroup,
  CrossPlantConfigurableProduct,
  SerialNoExplicitnessLevel,
  ProductManufacturerNumber,
  ManufacturerNumber,
  ManufacturerPartProfile,
  QltyMgmtInProcmtIsActive,
  IndustrySector,
  ChangeNumber,
  MaterialRevisionLevel,
  HandlingIndicator,
  WarehouseProductGroup,
  WarehouseStorageCondition,
  StandardHandlingUnitType,
  SerialNumberProfile,
  AdjustmentProfile,
  PreferredUnitOfMeasure,
  IsPilferable,
  IsRelevantForHzdsSubstances,
  QuarantinePeriod,
  TimeUnitForQuarantinePeriod,
  QualityInspectionGroup,
  AuthorizationGroup,
  DocumentIsCreatedByCAD,
  HandlingUnitType,
  HasVariableTareWeight,
  MaximumPackagingLength,
  MaximumPackagingWidth,
  MaximumPackagingHeight,
  UnitForMaxPackagingDimensions
FROM I_Product AS Product
LEFT OUTER JOIN A_ProductDescription AS _Description ON _Description.Product = Product  -- association [0..*]
LEFT OUTER JOIN A_ProductPlant AS _Plant ON _Plant.Product = Product  -- association [0..*]
LEFT OUTER JOIN A_ProductSalesDelivery AS _SalesDelivery ON _SalesDelivery.Product = Product  -- association [0..*]
LEFT OUTER JOIN A_ProductSalesTax AS _ProductSalesTax ON _ProductSalesTax.Product = Product  -- association [0..*]
LEFT OUTER JOIN A_ProductSales AS _ProductSales ON _ProductSales.Product = Product  -- association [0..1]
LEFT OUTER JOIN A_ProductQualityMgmt AS _ProductQualityMgmt ON _ProductQualityMgmt.Product = Product  -- association [0..1]
LEFT OUTER JOIN A_ProductProcurement AS _ProductProcurement ON _ProductProcurement.Product = Product  -- association [0..1]
LEFT OUTER JOIN E_Product AS _ProductExt ON Product = _ProductExt.Product  -- association [0..1]
LEFT OUTER JOIN A_ProductType AS _ProductType ON ProductType = _ProductType.ProductType  -- association [1..1]
LEFT OUTER JOIN A_ProductGroup AS _ProductGroup_2 ON ProductGroup = _ProductGroup_2.MaterialGroup  -- association [0..1]
LEFT OUTER JOIN A_ProductGroup AS _ProductGroup ON ProductGroup = _ProductGroup.MaterialGroup  -- association [0..1]
LEFT OUTER JOIN A_ProductBasicText AS _ProductBasicText ON Product = _ProductBasicText.Product  -- association [0..*]
LEFT OUTER JOIN A_ProductUnitsOfMeasure AS _ProductUnitsOfMeasure ON Product = _ProductUnitsOfMeasure.Product  -- association [0..*]
LEFT OUTER JOIN A_ProductStorage AS _ProductStorage ON Product = _ProductStorage.Product  -- association [0..1]
LEFT OUTER JOIN A_ProductInspectionText AS _ProductInspectionText ON Product = _ProductInspectionText.Product  -- association [0..*]
LEFT OUTER JOIN A_ProductPurchaseText AS _ProductPurchaseText ON Product = _ProductPurchaseText.Product  -- association [0..*]
LEFT OUTER JOIN A_ProductValuation AS _Valuation ON Product = _Valuation.Product  -- association [0..*]
;