C_ChgRecdProductMltplAssgmt

DDL: C_CHGRECDPRODUCTMLTPLASSGMT Type: view_entity CONSUMPTION
24 Fields 1 Data Sources

Product Multiple Assignments

C_ChgRecdProductMltplAssgmt is a Consumption CDS View that provides data about "Product Multiple Assignments" in SAP S/4HANA. It reads from 1 data source (I_ChgRecdProductMltplAssgmtTP) and exposes 24 fields with key field Product.

Data Sources (1)

SourceAliasJoin Type
I_ChgRecdProductMltplAssgmtTP I_ChgRecdProductMltplAssgmtTP from

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Product Multiple Assignments view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
Search.searchable true view
VDM.viewType #CONSUMPTION view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY Product Product Product Sold
ProductDescription ProductDescription Description
ProductType ProductType Product Type Group
ProductCategory ProductCategory Prod Category
ProductGroup ProductGroup Product Sold Group
ProductStandardID ProductStandardID GTIN
ProductOldID ProductOldID Old Prd Number
Division Division Internal Division ID
DocumentIsCreatedByCAD DocumentIsCreatedByCAD CAD Indicator
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
LastChangedByUser LastChangedByUser User Name
LastChangeDate LastChangeDate Time Stamp
BaseUnit BaseUnit Unit of Measure
CrossPlantStatus CrossPlantStatus Cross-Plant Material Status
StatusDescription StatusDescription
LaboratoryOrDesignOffice LaboratoryOrDesignOffice Lab/Office
BasicMaterial BasicMaterial Basic Material
ProductManufacturerNumber ProductManufacturerNumber Mfr Part Number
SalesStatus SalesStatus X-DChain status
ProductHierarchy ProductHierarchy Prod.hierarchy
ProductHierarchyText ProductHierarchyText
AuthorizationGroup AuthorizationGroup AuthorizGroup
_ProductGroup_2 _ProductGroup_2

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 C_ChgRecdProductMltplAssgmt.
-- 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 C_ChgRecdProductMltplAssgmt AS
SELECT
  Product,
  ProductDescription,
  ProductType,
  ProductCategory,
  ProductGroup,
  ProductStandardID,
  ProductOldID,
  Division,
  DocumentIsCreatedByCAD,
  CreatedByUser,
  CreationDate,
  LastChangedByUser,
  LastChangeDate,
  BaseUnit,
  CrossPlantStatus,
  StatusDescription,
  LaboratoryOrDesignOffice,
  BasicMaterial,
  ProductManufacturerNumber,
  SalesStatus,
  ProductHierarchy,
  ProductHierarchyText,
  AuthorizationGroup
FROM I_ChgRecdProductMltplAssgmtTP
;

Learn More