C_ModProdSpecItemTP

DDL: C_MODPRODSPECITEMTP Type: view_entity CONSUMPTION
36 Fields 1 Data Sources

Model Product Specification Item

C_ModProdSpecItemTP is a Consumption CDS View that provides data about "Model Product Specification Item" in SAP S/4HANA. It reads from 1 data source (R_ModProdSpecItemTP) and exposes 36 fields with key field ModProdSpecItemUUID.

Data Sources (1)

SourceAliasJoin Type
R_ModProdSpecItemTP R_ModProdSpecItemTP projection

Annotations (19)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
EndUserText.label Model Product Specification Item view
Metadata.ignorePropagatedAnnotations false view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.query.implementedBy ABAP:CL_MM_PUR_MPS_HIERARCHY view
UI.headerInfo.typeName Model Product Specification Item view
UI.headerInfo.typeNamePlural Model Product Specification Items view
UI.headerInfo.description.value ModelProductSpecificationItem view
UI.headerInfo.title.value ModProdSpecItemDescription view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.elementSuffix MAE view
AbapCatalog.extensibility.allowNewDatasources false view
AbapCatalog.extensibility.quota.maximumFields 800 view
AbapCatalog.extensibility.quota.maximumBytes 34592 view

Fields (36)

KeyFieldSource TableSource FieldDescription
KEY ModProdSpecItemUUID ModProdSpecItemUUID MPS Item UUID
ModelProductSpecificationUUID ModelProductSpecificationUUID UUID
ModelProductSpecification ModelProductSpecification ID
ModelProductSpecificationItem ModelProductSpecificationItem Item ID
ModProdSpecAlternativeItemID ModProdSpecAlternativeItemID Alt. Item ID
ModProdSpecFormattedItemID ModProdSpecFormattedItemID Hierarchy Number
Plant Plant Valuation Area
PlantName _Plant PlantName Plant Name
ModProdSpecItemParentID ModProdSpecItemParentID Parent ID
PurchasingIsItemSet PurchasingIsItemSet Item Set
PurchasingDocumentItemCategory PurchasingDocumentItemCategory Item Category
ModProdSpecItemDescription ModProdSpecItemDescription Description
Product Product Product Sold
MaterialNameasProductNamelocalized Product Description
ProductTypeCode ProductTypeCode Product Type Group
NameasProductTypeNamelocalized Description of Product Type Group
MaterialGroup MaterialGroup Product Group
OrderQuantityUnit OrderQuantityUnit Sales Unit
OrderQuantity OrderQuantity Quantity
CreationDateTime CreationDateTime Timestamp
CreatedByUser CreatedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
HierarchyNode HierarchyNode Node
HierarchyParentNode HierarchyParentNode Hier.node
HierarchyDistanceFromRoot HierarchyDistanceFromRoot Dist. From Root
HierarchyDescendantCount HierarchyDescendantCount Desc. Count
HierarchyDrillState HierarchyDrillState Drill State
HierarchyNodeOrdinalNumber HierarchyNodeOrdinalNumber Node Number
_Parent _Parent
_UnitValueHelp _UnitValueHelp
_Plant _Plant
_Product _Product
_PurgDocumentItemCategory _PurgDocumentItemCategory
_ProductTypeCode _ProductTypeCode
_MaterialGroup _MaterialGroup

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_ModProdSpecItemTP.
-- 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_ModProdSpecItemTP AS
SELECT
  ModProdSpecItemUUID,
  ModelProductSpecificationUUID,
  ModelProductSpecification,
  ModelProductSpecificationItem,
  ModProdSpecAlternativeItemID,
  ModProdSpecFormattedItemID,
  Plant,
  _Plant.PlantName AS PlantName,
  ModProdSpecItemParentID,
  PurchasingIsItemSet,
  PurchasingDocumentItemCategory,
  ModProdSpecItemDescription,
  Product,
  _ProductText.MaterialName as ProductName: localized AS MaterialNameasProductNamelocalized,
  ProductTypeCode,
  _ProductTypeCodeText.Name as ProductTypeName: localized AS NameasProductTypeNamelocalized,
  MaterialGroup,
  OrderQuantityUnit,
  OrderQuantity,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser,
  HierarchyNode,
  HierarchyParentNode,
  HierarchyDistanceFromRoot,
  HierarchyDescendantCount,
  HierarchyDrillState,
  HierarchyNodeOrdinalNumber
FROM R_ModProdSpecItemTP
;

Learn More