C_ModProdSpecItemTP

DDL: C_MODPRODSPECITEMTP Type: view_entity CONSUMPTION
36 Fields 1 Data Sources 1 OData Services 2 Fiori Apps

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. It is exposed through 1 OData service (UI_MODPRODSPEC_MANAGE). It is used in 2 Fiori applications: Manage Model Product Specifications, Monitor Jobs for Model Product Specifications.

Data Sources (1)

SourceAliasJoin Type
R_ModProdSpecItemTP R_ModProdSpecItemTP projection

Annotations (17)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #CONSUMPTION view
EndUserText.label Model Product Specification Item view
Metadata.ignorePropagatedAnnotations false 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

OData Services (1)

ServiceBindingVersionContractRelease
UI_MODPRODSPEC_MANAGE UI_MODPRODSPEC_MANAGE V2 C1 NOT_RELEASED

Fiori Apps (2)

App IDApp NameTypeDescription
F5079 Manage Model Product Specifications Transactional Manage Model Product Specifications application is a master data object for complex/hierarchical products and can be used as a template for structured set of related services and materials for procurement processes.
F7440 Monitor Jobs for Model Product Specifications Transactional Monitor Jobs for Model Product Specifications app monitors jobs that were created when importing model product specifications using the app Manage Model Product Specifications.

Manage Model Product Specifications

Business Role: Purchaser

With this feature, you can now use the new app Manage Model Product Specifications. With this app, you can create and categorize structured sets of related service and material items. Thus, you can group together items that are frequently ordered together to complete a particular task. Then, you can use model product specifications as templates to create purchasing documents, such as purchase contracts.

Monitor Jobs for Model Product Specifications

Business Role: Others

With this feature, you can now use the app Monitor Jobs for Model Product Specifications. With this app, you can monitor jobs that were created when importing model product specifications using the app Manage Model Product Specifications. When you upload a spreadsheet to create or change model product specification, a job is scheduled. You can monitor these jobs in this app to track whether your upload was successful. You can further analyze errors related to imported model product specifications.

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
ProductTypeCode ProductTypeCode Product Type Group
NameasProductTypeNamelocalized
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