R_ModelProductSpecificationTP

DDL: R_MODELPRODUCTSPECIFICATIONTP Type: view_entity TRANSACTIONAL

Model Product Specification

R_ModelProductSpecificationTP is a Transactional CDS View that provides data about "Model Product Specification" in SAP S/4HANA. It reads from 1 data source (R_ModelProductSpecification) and exposes 19 fields with key field ModelProductSpecificationUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
R_ModelProductSpecification R_ModelProductSpecification from

Associations (2)

CardinalityTargetAliasCondition
[1..1] E_ModelProductSpecification _ModProdSpecExtension $projection.ModelProductSpecificationUUID = _ModProdSpecExtension.ModelProductSpecificationUUID
[1..*] R_ModProdSpecItemTP _ModProdSpecItemTP

Annotations (15)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Model Product Specification view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.representativeKey ModelProductSpecificationUUID view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.sapObjectNodeType.name ModelProductSpecification view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.elementSuffix MEA view
AbapCatalog.extensibility.allowNewDatasources false view
AbapCatalog.extensibility.quota.maximumFields 730 view
AbapCatalog.extensibility.quota.maximumBytes 14592 view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY ModelProductSpecificationUUID ModelProductSpecificationUUID UUID
ModelProductSpecification ModelProductSpecification ID
ModelProductSpecificationName ModelProductSpecificationName Name
ModProdSpecGroupingCode ModProdSpecGroupingCode Grouping Code
ModProdSpecSearchTermText ModProdSpecSearchTermText Search Term
ModProdSpecActvtnStatusCode ModProdSpecActvtnStatusCode Activation Status
Language Language Report Text Language
IsDeleted IsDeleted TRUE
CreationDateTime CreationDateTime Timestamp
CreatedByUser CreatedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
_ModProdSpecItemTP _ModProdSpecItemTP
_ModProdSpecGroupingCode _ModProdSpecGroupingCode
_ModProdSpecGroupingCodeText _ModProdSpecGroupingCodeText
_ModProdSpecLanguageText _ModProdSpecLanguageText
_ModProdSpecStatusText _ModProdSpecStatusText
_CreatedByUser _CreatedByUser
_ChangedByUser _ChangedByUser

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 R_ModelProductSpecificationTP.
-- 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 R_ModelProductSpecificationTP AS
SELECT
  ModelProductSpecificationUUID,
  ModelProductSpecification,
  ModelProductSpecificationName,
  ModProdSpecGroupingCode,
  ModProdSpecSearchTermText,
  ModProdSpecActvtnStatusCode,
  Language,
  IsDeleted,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser
FROM R_ModelProductSpecification
LEFT OUTER JOIN E_ModelProductSpecification AS _ModProdSpecExtension ON ModelProductSpecificationUUID = _ModProdSpecExtension.ModelProductSpecificationUUID  -- association [1..1]
LEFT OUTER JOIN R_ModProdSpecItemTP AS _ModProdSpecItemTP ON /* condition not available in parsed metadata */  -- association [1..*]
;