A_SpecificationPhraseItem

DDL: A_SPECIFICATIONPHRASEITEM SQL: ASPCPHRITEM Type: view CONSUMPTION
12 Fields 1 Data Sources 1 Associations

Specification Phrase Item

A_SpecificationPhraseItem is a Consumption CDS View that provides data about "Specification Phrase Item" in SAP S/4HANA. It reads from 1 data source (I_SpecificationPhraseItem) and exposes 12 fields with key fields SpecPhraseItemInternalID, SpecPhraseItemChgIntID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_SpecificationPhraseItem I_SpecificationPhraseItem from

Associations (1)

CardinalityTargetAliasCondition
[1..*] A_SpecificationPhrase _SpecificationPhrase _SpecificationPhrase.SpecPhraseInternalID = $projection.SpecPhraseInternalID

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ASPCPHRITEM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
EndUserText.label Specification Phrase Item view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY SpecPhraseItemInternalID SpecPhraseItemInternalID
KEY SpecPhraseItemChgIntID SpecPhraseItemChgIntID
SpecPhraseInternalID SpecPhraseInternalID
SpecPhraseItemStatus SpecPhraseItemStatus
SpecPhraseItemCode SpecPhraseItemCode
SpecPhraseItemIsDeleted SpecPhraseItemIsDeleted DID
SpecPhraseItemChangeDate SpecPhraseItemChangeDate Changed On
SpecPhraseItemLanguage SpecPhraseItemLanguage Primary lang.
SpecPhraseItemText SpecPhraseItemText
SpecPhraseItemValdtyStartDate SpecPhraseItemValdtyStartDate Valid From
SpecPhraseItemValdtyEndDate SpecPhraseItemValdtyEndDate Valid To
_SpecificationPhrase _SpecificationPhrase

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 A_SpecificationPhraseItem.
-- 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.
-- SQL view name: ASPCPHRITEM

CREATE VIEW A_SpecificationPhraseItem AS
SELECT
  SpecPhraseItemInternalID,
  SpecPhraseItemChgIntID,
  SpecPhraseInternalID,
  SpecPhraseItemStatus,
  SpecPhraseItemCode,
  SpecPhraseItemIsDeleted,
  SpecPhraseItemChangeDate,
  SpecPhraseItemLanguage,
  SpecPhraseItemText,
  SpecPhraseItemValdtyStartDate,
  SpecPhraseItemValdtyEndDate
FROM I_SpecificationPhraseItem
LEFT OUTER JOIN A_SpecificationPhrase AS _SpecificationPhrase ON _SpecificationPhrase.SpecPhraseInternalID = SpecPhraseInternalID  -- association [1..*]
;

Learn More