N_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 N_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 N_Product AS
SELECT
  cast (ProductSearch.matnr as productnumber preserving type ) AS Product,
  ProductSearch.bwscl AS SourceOfSupply,
  ProductSearch.mfrnr AS ManufacturerNumber,
  ProductSearch.bstme AS PurchaseOrderQuantityUnit,
  ProductSearch.begru AS AuthorizationGroup,
  ProductSearch.meins AS BaseUnit,
  ProductSearch.ernam AS CreatedByUser,
  ProductSearch.aenam AS LastChangedByUser,
  ProductSearch.spart AS Division,
  ProductSearch.brgew AS GrossWeight,
  ProductSearch.ntgew AS NetWeight,
  ProductSearch.matnr_external AS ProductExternalID,
  ProductSearch.gewei AS WeightUnit,
  cast (ProductSearch.attyp as prodcategory preserving type ) AS ProductCategory,
  cast (ProductSearch.matkl as productgroup) AS ProductGroup,
  cast (ProductSearch.bismt as productoldid) AS ProductOldID,
  cast( ProductSearch.ean11 as globaltradeitemnumber) AS ProductStandardID,
  cast (ProductSearch.mtart as producttype preserving type ) AS ProductType
FROM mara AS ProductSearch
LEFT OUTER JOIN I_ProductSalesDelivery AS _ProductSalesDelivery ON Product = _ProductSalesDelivery.Product  -- association [0..*]
LEFT OUTER JOIN I_DivisionText AS _DivisionText ON Division = _DivisionText.Division  -- association [0..*]
LEFT OUTER JOIN I_ProductText AS _Text ON Product = _Text.Product  -- association [0..*]
LEFT OUTER JOIN I_ProductGroup_2 AS _ProductGroup ON ProductGroup = _ProductGroup.ProductGroup  -- association [0..1]
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_ProductCategory AS _ProductCategory ON ProductCategory = _ProductCategory.ProductCategory  -- association [1..1]
LEFT OUTER JOIN I_SourceOfSupplyCategoryT AS _SourceOfSupplyText ON SourceOfSupply = _SourceOfSupplyText.SourceOfSupplyCategory  -- association [0..*]
LEFT OUTER JOIN I_Supplier AS _Supplier ON ManufacturerNumber = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_TextObjectPlainLongText AS _TextObjectPlainLongText ON Product = _TextObjectPlainLongText.TextObjectKey AND _TextObjectPlainLongText.TextObjectCategory = 'MATERIAL'  -- association [0..*]
LEFT OUTER JOIN I_DocumentInfoRecordObjectLink AS _DocInfoRecordObjectLink ON Product = _DocInfoRecordObjectLink.LinkedSAPObjectKey AND _DocInfoRecordObjectLink.LinkedSAPObject = 'MARA'  -- association [0..*]
LEFT OUTER JOIN I_UnitOfMeasureText AS _WeightUnitText ON WeightUnit = _WeightUnitText.UnitOfMeasure  -- association [0..*]
LEFT OUTER JOIN I_UnitOfMeasureText AS _PurOrderQuantityUnitText ON PurchaseOrderQuantityUnit = _PurOrderQuantityUnitText.UnitOfMeasure  -- association [0..*]
LEFT OUTER JOIN I_UnitOfMeasureText AS _BaseUnitOfMeasureText ON BaseUnit = _BaseUnitOfMeasureText.UnitOfMeasure  -- association [0..*]
LEFT OUTER JOIN I_ProductPlant AS _ProductPlant ON Product = _ProductPlant.Product  -- association [0..*]
LEFT OUTER JOIN I_ClfnObjectCharcValForKeyDate AS _CharValueAssignment ON Product = _CharValueAssignment.ClfnObjectID AND _CharValueAssignment.ClfnObjectTable = 'MARA'  -- association [0..*]
LEFT OUTER JOIN I_ClfnObjectClassForKeyDate AS _ClassAssignment ON Product = _ClassAssignment.ClfnObjectID AND _ClassAssignment.ClfnObjectTable = 'MARA'  -- association [0..*]
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_UnitOfMeasure AS _BaseUnitOfMeasure ON BaseUnit = _BaseUnitOfMeasure.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_Division AS _Division ON Division = _Division.Division  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _WeightUnitValueHelp ON WeightUnit = _WeightUnitValueHelp.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN E_Product AS _ProductExt ON Product = _ProductExt.Product  -- association [0..1]
;