I_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 I_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.

CREATE VIEW I_Product AS
SELECT
  cast (mara.matnr as productnumber preserving type ) AS Product,
  cast (mara.mtart as producttype preserving type ) AS ProductType,
  cast (mara.lvorm as ismarkedfordeletion) AS IsMarkedForDeletion,
  cast (mara.mstae as crossplantstatus) AS CrossPlantStatus,
  cast (mara.bismt as productoldid) AS ProductOldID,
  cast (mara.matkl as productgroup preserving type ) AS ProductGroup,
  cast (mara.volum as materialvolume) AS MaterialVolume,
  cast (mara.attyp as prodcategory preserving type ) AS ProductCategory,
  cast( mara.ean11 as globaltradeitemnumber) AS ProductStandardID,
  cast( mara.kzkfg as productisconfigurable preserving type ) AS ProductIsConfigurable,
  cast (mara.extwg as externalproductgroup preserving type ) AS ExternalProductGroup,
  cast (mara.satnr as crossplantconfigurableproduct preserving type ) AS CrossPlantConfigurableProduct,
  cast (mara.attyp as prodcategory preserving type ) AS ArticleCategory,
  cast('' as changenumber ) AS ChangeNumber,
  cast('' as productrevisionlevel) AS MaterialRevisionLevel,
  cast( 'X' as sdraft_is_active preserving type ) AS IsActiveEntity,
  cast( mara.chml_cmplnc_rlvnce_ind as chml_cmplnc_rlvnce_ind_pm ) AS IsChemicalComplianceRelevant,
  mara.matnr_external AS ProductExternalID,
  mara.productoid AS ProductOID,
  mara.ersda AS CreationDate,
  mara.created_at_time AS CreationTime,
  mara.ernam AS CreatedByUser,
  mara.laeda AS LastChangeDate,
  mara.mstde AS CrossPlantStatusValidityDate,
  mara.brgew AS GrossWeight,
  mara.bstme AS PurchaseOrderQuantityUnit,
  mara.bwscl AS SourceOfSupply,
  mara.gewei AS WeightUnit,
  mara.herkl AS CountryOfOrigin,
  mara.kunnr AS CompetitorID,
  mara.meins AS BaseUnit,
  mara.mtpos_mara AS ItemCategoryGroup,
  mara.ntgew AS NetWeight,
  mara.prdha AS ProductHierarchy,
  mara.spart AS Division,
  mara.vabme AS VarblPurOrdUnitIsActive,
  mara.voleh AS VolumeUnit,
  mara.mstav AS SalesStatus,
  mara.mstdv AS SalesStatusValidityDate,
  mara.begru AS AuthorizationGroup,
  mara.anp AS ANPCode,
  mara.brand_id AS Brand,
  mara.bwvor AS ProcurementRule,
  mara.datab AS ValidityStartDate,
  mara.disst AS LowLevelCode,
  mara.gennr AS ProdNoInGenProdInPrepackProd,
  mara.serial AS SerialIdentifierAssgmtProfile,
  mara.groes AS SizeOrDimensionText,
  mara.normt AS IndustryStandardName,
  mara.numtp AS InternationalArticleNumberCat,
  mara.xchpf AS IsBatchManagementRequired,
  mara.mlgut AS HasEmptiesBOM,
  mara.serlv AS SerialNoExplicitnessLevel,
  mara.mfrpn AS ProductManufacturerNumber,
  mara.mfrnr AS ManufacturerNumber,
  mara.mprof AS ManufacturerPartProfile,
  mara.qmpur AS QltyMgmtInProcmtIsActive,
  mara.hndlcode AS HandlingIndicator,
  mara.whmatgr AS WarehouseProductGroup,
  mara.whstc AS WarehouseStorageCondition,
  mara.hutyp_dflt AS StandardHandlingUnitType,
  mara.serial AS SerialNumberProfile,
  mara.adprof AS AdjustmentProfile,
  mara.scm_puom AS PreferredUnitOfMeasure,
  mara.pilferable AS IsPilferable,
  mara.hazmat AS IsRelevantForHzdsSubstances,
  mara.qqtime AS QuarantinePeriod,
  mara.qqtimeuom AS TimeUnitForQuarantinePeriod,
  mara.qgrp AS QualityInspectionGroup,
  mara.hutyp AS HandlingUnitType,
  mara.tare_var AS HasVariableTareWeight,
  mara.maxl AS MaximumPackagingLength,
  mara.maxb AS MaximumPackagingWidth,
  mara.maxh AS MaximumPackagingHeight,
  mara.maxc AS MaximumCapacity,
  mara.maxc_tol AS OvercapacityTolerance,
  mara.maxdim_uom AS UnitForMaxPackagingDimensions,
  mara.laeng AS BaseUnitSpecificProductLength,
  mara.breit AS BaseUnitSpecificProductWidth,
  mara.hoehe AS BaseUnitSpecificProductHeight,
  mara.meabm AS ProductMeasurementUnit,
  mara.datab AS ProductValidStartDate,
  mara.inhme AS ContentUnit,
  mara.inhal AS NetContent,
  mara.vpreh AS ComparisonPriceQuantity,
  mara.inhbr AS GrossContent,
  mara.liqdt AS ProductValidEndDate,
  mara.bbtyp AS AssortmentListType,
  mara.animal_origin AS HasTextilePartsWthAnimalOrigin,
  mara.fsh_sealv AS ProductSeasonUsageCategory,
  mara.mbrsh AS IndustrySector,
  mara.last_changed_time AS LastChangeTime,
  mara.profl AS DangerousGoodsIndProfile,
  mara.scm_matid_guid16 AS ProductUUID,
  mara.scm_matid_guid22 AS ProdSupChnMgmtUUID22,
  mara.aeszn AS ProductDocumentChangeNumber,
  mara.blanz AS ProductDocumentPageCount,
  mara.blatt AS ProductDocumentPageNumber,
  mara.bmatn AS OwnInventoryManagedProduct,
  mara.cadkz AS DocumentIsCreatedByCAD,
  mara.ferth AS ProductionOrInspectionMemoTxt,
  mara.formt AS ProductionMemoPageFormat,
  mara.gtin_variant AS GlobalTradeItemNumberVariant,
  mara.ihivi AS ProductIsHighlyViscous,
  mara.iloos AS TransportIsInBulk,
  mara.kosch AS ProdAllocDetnProcedure,
  mara.kzeff AS ProdEffctyParamValsAreAssigned,
  mara.kzumw AS ProdIsEnvironmentallyRelevant,
  mara.labor AS LaboratoryOrDesignOffice,
  mara.magrv AS PackagingMaterialGroup,
  mara.matfi AS ProductIsLocked,
  mara.nrfhg AS DiscountInKindEligibility,
  mara.ps_smartform AS SmartFormName,
  mara.rmatp AS PackingReferenceProduct,
  mara.wrkst AS BasicMaterial,
  mara.zeinr AS ProductDocumentNumber,
  mara.zeivr AS ProductDocumentVersion,
  mara.zeiar AS ProductDocumentType,
  mara.zeifo AS ProductDocumentPageFormat,
  mara.cuobf AS ProductConfiguration,
  mara.sgt_covsa AS SegmentationStrategy,
  mara.sgt_rel AS SegmentationIsRelevant,
  mara.przus AS ProductCompositionIsRelevant,
  mara.msbookpartno AS ManufacturerBookPartNumber,
  mara.logistical_mat_category AS LogisticalProductCategory,
  mara.sales_material AS SalesProduct,
  mara.color_atinn AS ProdCharc1InternalNumber,
  mara.size1_atinn AS ProdCharc2InternalNumber,
  mara.size2_atinn AS ProdCharc3InternalNumber,
  mara.color AS ProductCharacteristic1,
  mara.size1 AS ProductCharacteristic2,
  mara.size2 AS ProductCharacteristic3,
  mara.pstat AS MaintenanceStatus,
  mara.fsh_mg_at1 AS FashionProdInformationField1,
  mara.fsh_mg_at2 AS FashionProdInformationField2,
  mara.fsh_mg_at3 AS FashionProdInformationField3
FROM mara
LEFT OUTER JOIN I_ProductText AS _Text ON Product = _Text.Product  -- association [0..*]
LEFT OUTER JOIN I_ProductGroup AS _ProductGroup ON ProductGroup = _ProductGroup.MaterialGroup  -- association [0..1]
LEFT OUTER JOIN I_ProductGroupText AS _ProductGroupText ON ProductGroup = _ProductGroupText.MaterialGroup  -- association [0..*]
LEFT OUTER JOIN I_ProductGroup_2 AS _ProductGroup_2 ON ProductGroup = _ProductGroup_2.ProductGroup  -- association [0..1]
LEFT OUTER JOIN I_ProductGroupText_2 AS _ProductGroupText_2 ON ProductGroup = _ProductGroupText_2.ProductGroup  -- association [0..*]
LEFT OUTER JOIN I_ProductRetail AS _ProductRetail ON Product = _ProductRetail.Product  -- association [0..1]
LEFT OUTER JOIN I_Division AS _Division ON Division = _Division.Division  -- association [0..1]
LEFT OUTER JOIN I_DivisionText AS _DivisionText ON Division = _DivisionText.Division  -- association [0..*]
LEFT OUTER JOIN I_ExtProdGrp AS _ExternalProductGroup ON ExternalProductGroup = _ExternalProductGroup.ExternalProductGroup  -- association [0..1]
LEFT OUTER JOIN I_ExtProdGrpText AS _ExtProdGrpText ON ExternalProductGroup = _ExtProdGrpText.ExternalProductGroup  -- association [0..*]
LEFT OUTER JOIN I_ProductHierarchy AS _ProductHierarchy ON ProductHierarchy = _ProductHierarchy.ProductHierarchy  -- association [0..1]
LEFT OUTER JOIN I_ProductHierarchyText AS _ProductHierarchyText ON ProductHierarchy = _ProductHierarchyText.ProductHierarchy  -- association [0..*]
LEFT OUTER JOIN I_Producttype AS _ProductType ON ProductType = _ProductType.ProductType  -- association [1..1]
LEFT OUTER JOIN I_ProductTypeText AS _ProductTypeName ON ProductType = _ProductTypeName.ProductType  -- association [0..*]
LEFT OUTER JOIN I_Intntnlartnmbcat AS _InternationalArticleNumberCat ON InternationalArticleNumberCat = _InternationalArticleNumberCat.InternationalArticleNumberCat  -- association [0..1]
LEFT OUTER JOIN I_Intntnlartnmbcattext AS _IntArticleNumberText ON InternationalArticleNumberCat = _IntArticleNumberText.InternationalArticleNumberCat  -- association [0..*]
LEFT OUTER JOIN I_ProductCategory AS _ProductCategory ON ProductCategory = _ProductCategory.ProductCategory  -- association [1..1]
LEFT OUTER JOIN I_ProductCategoryText AS _ProductCategoryText ON ProductCategory = _ProductCategoryText.ProductCategory  -- association [0..*]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnitOfMeasure ON BaseUnit = _BaseUnitOfMeasure.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasureText AS _BaseUnitOfMeasureText ON BaseUnit = _BaseUnitOfMeasureText.UnitOfMeasure  -- association [0..*]
LEFT OUTER JOIN I_Product AS _CrossPlantConfigurableProduct ON CrossPlantConfigurableProduct = _CrossPlantConfigurableProduct.Product  -- association [0..1]
LEFT OUTER JOIN I_Brand AS _Brand ON Brand = _Brand.Brand  -- 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 I_UserContactCard AS _CreatedByUserContactCard ON CreatedByUser = _CreatedByUserContactCard.ContactCardID  -- association [1..1]
LEFT OUTER JOIN I_UserContactCard AS _LastChangedByUserContactCard ON LastChangedByUser = _LastChangedByUserContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_BasicMaterial AS _BasicMaterial ON BasicMaterial = _BasicMaterial.BasicMaterial  -- association [0..1]
LEFT OUTER JOIN E_Product AS _ProductExt ON mara.matnr = _ProductExt.Product  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ContentUnit ON ContentUnit = _ContentUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasureText AS _ContentUnitText ON ContentUnit = _ContentUnitText.UnitOfMeasure  -- association [0..*]
LEFT OUTER JOIN I_UnitOfMeasure AS _ProductMeasurementUnit ON ProductMeasurementUnit = _ProductMeasurementUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasureText AS _ProductMeasurementUnitText ON ProductMeasurementUnit = _ProductMeasurementUnitText.UnitOfMeasure  -- association [0..*]
LEFT OUTER JOIN I_Productprocurement AS _ProductProcurement ON Product = _ProductProcurement.Product  -- association [0..1]
LEFT OUTER JOIN I_ProductSales AS _ProductSales ON Product = _ProductSales.Product  -- association [0..1]
LEFT OUTER JOIN I_ProductStatus AS _ProductStatus ON CrossPlantStatus = _ProductStatus.Status  -- association [0..1]
LEFT OUTER JOIN I_ProductStatusText AS _ProductStatusText ON CrossPlantStatus = _ProductStatusText.Status  -- association [0..*]
LEFT OUTER JOIN I_UnitOfMeasure AS _WeightUnitValueHelp ON WeightUnit = _WeightUnitValueHelp.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasureText AS _WeightUnitText ON WeightUnit = _WeightUnitText.UnitOfMeasure  -- association [0..*]
LEFT OUTER JOIN I_UnitOfMeasure AS _QuantityUnitValueHelp ON VolumeUnit = _QuantityUnitValueHelp.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasureText AS _QuantityUnitText ON VolumeUnit = _QuantityUnitText.UnitOfMeasure  -- association [0..*]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitForMaxPackaging ON UnitForMaxPackagingDimensions = _UnitForMaxPackaging.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasureText AS _UnitForMaxPackagingText ON UnitForMaxPackagingDimensions = _UnitForMaxPackagingText.UnitOfMeasure  -- association [0..*]
LEFT OUTER JOIN I_UnitOfMeasure AS _TimeUnitForQuarantinePeriod ON TimeUnitForQuarantinePeriod = _TimeUnitForQuarantinePeriod.UnitOfMeasure AND _TimeUnitForQuarantinePeriod.UnitOfMeasureDimension = 'TIME'  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasureText AS _TimeUnitQuarantinePeriodText ON TimeUnitForQuarantinePeriod = _TimeUnitQuarantinePeriodText.UnitOfMeasure  -- association [0..*]
LEFT OUTER JOIN I_ProductDescription AS _MaterialText ON CrossPlantConfigurableProduct = _MaterialText.Product  -- association [0..*]
LEFT OUTER JOIN I_ChangeMstrObjTypeRevisionLvl AS _MaterialRevisionLevel ON MaterialRevisionLevel = _MaterialRevisionLevel.RevisionLevel AND _MaterialRevisionLevel.ChangeNumberObjectType = '41'  -- association [0..1]
LEFT OUTER JOIN I_ChemicalComplianceRelevant AS _ChemicalComplianceRelevant ON IsChemicalComplianceRelevant = _ChemicalComplianceRelevant.IsChemicalComplianceRelevant  -- association [0..1]
LEFT OUTER JOIN I_ChemicalComplianceRlvtText AS _ChemicalComplianceRlvtText ON IsChemicalComplianceRelevant = _ChemicalComplianceRlvtText.IsChemicalComplianceRelevant  -- association [0..*]
LEFT OUTER JOIN I_ItemCategoryGroup AS _ItemCategoryGroup ON ItemCategoryGroup = _ItemCategoryGroup.ItemCategoryGroup  -- association [0..1]
LEFT OUTER JOIN I_ItemCategoryGroupText AS _ItemCategoryGroupText ON ItemCategoryGroup = _ItemCategoryGroupText.ItemCategoryGroup  -- association [0..*]
LEFT OUTER JOIN I_BrandText AS _BrandText ON Brand = _BrandText.Brand  -- association [0..*]
LEFT OUTER JOIN I_ProductSalesDelivery AS _ESHProductSalesDelivery ON Product = _ESHProductSalesDelivery.Product  -- association [0..*]
LEFT OUTER JOIN I_SourceOfSupplyCategoryT AS _ESHSourceOfSupply ON SourceOfSupply = _ESHSourceOfSupply.SourceOfSupplyCategory  -- association [0..*]
LEFT OUTER JOIN I_Supplier AS _ESHSupplier ON ManufacturerNumber = _ESHSupplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_TextObjectPlainLongText AS _ESHTextObjectPlainLongText ON Product = _ESHTextObjectPlainLongText.TextObjectKey AND _ESHTextObjectPlainLongText.TextObjectCategory = 'MATERIAL'  -- association [0..*]
LEFT OUTER JOIN I_DocumentInfoRecordObjectLink AS _ESHDocInfoRecordObjectLink ON Product = _ESHDocInfoRecordObjectLink.LinkedSAPObjectKey AND _ESHDocInfoRecordObjectLink.LinkedSAPObject = 'MARA'  -- association [0..*]
LEFT OUTER JOIN I_UnitOfMeasureText AS _ESHPurOrderQuantityUnitText ON PurchaseOrderQuantityUnit = _ESHPurOrderQuantityUnitText.UnitOfMeasure  -- association [0..*]
LEFT OUTER JOIN I_ProductPlant AS _ESHProductPlant ON Product = _ESHProductPlant.Product  -- association [0..*]
LEFT OUTER JOIN I_ClfnObjectCharcValForKeyDate AS _ESHCharValueAssignment ON Product = _ESHCharValueAssignment.ClfnObjectID AND _ESHCharValueAssignment.ClfnObjectTable = 'MARA'  -- association [0..*]
LEFT OUTER JOIN I_ClfnObjectClassForKeyDate AS _ESHClassAssignment ON Product = _ESHClassAssignment.ClfnObjectID AND _ESHClassAssignment.ClfnObjectTable = 'MARA'  -- association [0..*]
LEFT OUTER JOIN I_ProdUnivHierarchyNode AS _ProdUnivHierarchyNode ON Product = _ProdUnivHierarchyNode.Product  -- association [0..*]
LEFT OUTER JOIN I_AssortmentListType AS _AssortmentListType ON AssortmentListType = _AssortmentListType.AssortmentListType  -- association [0..1]
LEFT OUTER JOIN I_AssortmentListTypeT AS _AssortmentListTypeText ON AssortmentListType = _AssortmentListTypeText.AssortmentListType  -- association [0..*]
LEFT OUTER JOIN I_BR_ANPCode AS _BR_ANPCode ON ANPCode = _BR_ANPCode.BR_ANPCode  -- association [0..1]
LEFT OUTER JOIN I_BR_ANPCodeText AS _BR_ANPCodeText ON ANPCode = _BR_ANPCodeText.BR_ANPCode  -- association [0..*]
LEFT OUTER JOIN I_EWM_MaterialHandling AS _HandlingIndicator ON HandlingIndicator = _HandlingIndicator.MaterialHandling  -- association [0..1]
LEFT OUTER JOIN I_EWM_MaterialHandlingT AS _HandlingIndicatorText ON HandlingIndicator = _HandlingIndicatorText.MaterialHandling  -- association [0..*]
LEFT OUTER JOIN I_EWM_WarehouseMaterialGroup AS _WarehouseProductGroup ON WarehouseProductGroup = _WarehouseProductGroup.WarehouseProductGroup  -- association [0..1]
LEFT OUTER JOIN I_EWM_WarehouseMaterialGroupT AS _WarehouseProductGroupText ON WarehouseProductGroup = _WarehouseProductGroupText.WarehouseProductGroup  -- association [0..*]
LEFT OUTER JOIN I_EWM_WhseStorageCondition AS _WarehouseStorageCondition ON WarehouseStorageCondition = _WarehouseStorageCondition.WarehouseStorageCondition  -- association [0..1]
LEFT OUTER JOIN I_EWM_WhseStorageConditionT AS _WarehouseStorageConditionText ON WarehouseStorageCondition = _WarehouseStorageConditionText.WarehouseStorageCondition  -- association [0..*]
LEFT OUTER JOIN I_EWM_HandlingUnitType AS _StandardHandlingUnitType ON StandardHandlingUnitType = _StandardHandlingUnitType.HandlingUnitType  -- association [0..1]
LEFT OUTER JOIN I_EWM_HandlingUnitTypeT AS _StandardHandlingUnitTypeText ON StandardHandlingUnitType = _StandardHandlingUnitTypeText.HandlingUnitType  -- association [0..*]
LEFT OUTER JOIN I_EWM_SerialNumberProfile AS _SerialNumberProfile ON SerialNumberProfile = _SerialNumberProfile.SerialNumberProfile  -- association [0..1]
LEFT OUTER JOIN I_EWM_SerialNumberProfileT AS _SerialNumberProfileText ON SerialNumberProfile = _SerialNumberProfileText.SerialNumberProfile  -- association [0..*]
LEFT OUTER JOIN I_EWM_QtyAdjustmentProfile AS _AdjustmentProfile ON AdjustmentProfile = _AdjustmentProfile.AdjustmentProfile  -- association [0..1]
LEFT OUTER JOIN I_EWM_QtyAdjustmentProfileT AS _AdjustmentProfileText ON AdjustmentProfile = _AdjustmentProfileText.AdjustmentProfile  -- association [0..*]
LEFT OUTER JOIN I_ProdEWMAdjmtProfile AS _AdjustmentProfile_2 ON AdjustmentProfile = _AdjustmentProfile_2.AdjustmentProfile  -- association [0..1]
LEFT OUTER JOIN I_ProdEWMAdjmtProfileText AS _AdjustmentProfileText_2 ON AdjustmentProfile = _AdjustmentProfileText_2.AdjustmentProfile  -- association [0..*]
LEFT OUTER JOIN I_EWM_QualityInspectionGroup AS _QualityInspectionGroup ON QualityInspectionGroup = _QualityInspectionGroup.QualityInspectionGroup  -- association [0..1]
LEFT OUTER JOIN I_EWM_QualityInspectionGroupT AS _QualityInspectionGroupText ON QualityInspectionGroup = _QualityInspectionGroupText.QualityInspectionGroup  -- association [0..*]
LEFT OUTER JOIN I_EWM_HandlingUnitType AS _HandlingUnitType ON HandlingUnitType = _HandlingUnitType.HandlingUnitType  -- association [0..1]
LEFT OUTER JOIN I_EWM_HandlingUnitTypeT AS _HandlingUnitTypeText ON HandlingUnitType = _HandlingUnitTypeText.HandlingUnitType  -- association [0..*]
LEFT OUTER JOIN I_ProductESPP AS _ProductESPP ON Product = _ProductESPP.Product  -- association [0..1]
LEFT OUTER JOIN I_Productscm AS _ProductSCM ON Product = _ProductSCM.Product  -- association [1..1]
LEFT OUTER JOIN I_ProductType_2 AS _ProductType_2 ON ProductType = _ProductType_2.ProductType  -- association [1..1]
LEFT OUTER JOIN I_ProductDescription_2 AS _ProductDescription_2 ON CrossPlantConfigurableProduct = _ProductDescription_2.Product  -- association [0..*]
LEFT OUTER JOIN I_RetailCharacteristicValue AS _RetProdCharc1 ON ProdCharc1InternalNumber = _RetProdCharc1.CharacteristicInternalID AND ProductCharacteristic1 = _RetProdCharc1.RetailCharacteristicValue  -- association [0..1]
LEFT OUTER JOIN I_RetailCharacteristicValueT AS _RetProdCharc1Text ON ProdCharc1InternalNumber = _RetProdCharc1Text.CharacteristicInternalID AND ProductCharacteristic1 = _RetProdCharc1Text.RetailCharacteristicValue  -- association [0..*]
LEFT OUTER JOIN I_RetailCharacteristicValue AS _RetProdCharc2 ON ProdCharc2InternalNumber = _RetProdCharc2.CharacteristicInternalID AND ProductCharacteristic2 = _RetProdCharc2.RetailCharacteristicValue  -- association [0..1]
LEFT OUTER JOIN I_RetailCharacteristicValueT AS _RetProdCharc2Text ON ProdCharc2InternalNumber = _RetProdCharc2Text.CharacteristicInternalID AND ProductCharacteristic2 = _RetProdCharc2Text.RetailCharacteristicValue  -- association [0..*]
LEFT OUTER JOIN I_RetailCharacteristicValue AS _RetProdCharc3 ON ProdCharc3InternalNumber = _RetProdCharc3.CharacteristicInternalID AND ProductCharacteristic3 = _RetProdCharc3.RetailCharacteristicValue  -- association [0..1]
LEFT OUTER JOIN I_RetailCharacteristicValueT AS _RetProdCharc3Text ON ProdCharc3InternalNumber = _RetProdCharc3Text.CharacteristicInternalID AND ProductCharacteristic3 = _RetProdCharc3Text.RetailCharacteristicValue  -- association [0..*]
LEFT OUTER JOIN I_FashionProdInfoField1 AS _FashionProdInfoFld1 ON FashionProdInformationField1 = _FashionProdInfoFld1.FashionProdInformationField1  -- association [0..1]
LEFT OUTER JOIN I_FashionProdInfoFld1Text AS _FashionProdInfoFld1Text ON FashionProdInformationField1 = _FashionProdInfoFld1Text.FashionProdInformationField1  -- association [0..*]
LEFT OUTER JOIN I_FashionProdInfoField2 AS _FashionProdInfoFld2 ON FashionProdInformationField2 = _FashionProdInfoFld2.FashionProdInformationField2  -- association [0..1]
LEFT OUTER JOIN I_FashionProdInfoFld2Text AS _FashionProdInfoFld2Text ON FashionProdInformationField2 = _FashionProdInfoFld2Text.FashionProdInformationField2  -- association [0..*]
LEFT OUTER JOIN I_FashionProdInfoField3 AS _FashionProdInfoFld3 ON FashionProdInformationField3 = _FashionProdInfoFld3.FashionProdInformationField3  -- association [0..1]
LEFT OUTER JOIN I_FashionProdInfoFld3Text AS _FashionProdInfoFld3Text ON FashionProdInformationField3 = _FashionProdInfoFld3Text.FashionProdInformationField3  -- association [0..*]
;