A_SpecIdentifier

DDL: A_SPECIDENTIFIER SQL: ASPECIDENT Type: view COMPOSITE
15 Fields 1 Data Sources

Specification Identifier

A_SpecIdentifier is a Composite CDS View that provides data about "Specification Identifier" in SAP S/4HANA. It reads from 1 data source (I_SpecIdentifierForKeyDate) and exposes 15 fields with key fields SpecIdfgDescInternalID, SpecIdfgDescChangeState.

Data Sources (1)

SourceAliasJoin Type
I_SpecIdentifierForKeyDate I_SpecIdentifierForKeyDate from

Parameters (1)

NameTypeDefault
P_KeyDate sydate

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ASPECIDENT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
Metadata.ignorePropagatedAnnotations true view
Consumption.filter.businessDate.at true view
EndUserText.label Specification Identifier view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY SpecIdfgDescInternalID SpecIdfgDescInternalID
KEY SpecIdfgDescChangeState SpecIdfgDescChangeState
SpecificationInternalID SpecificationInternalID Specification
SpecIdfgDescIsDeleted SpecIdfgDescIsDeleted
SpecIdfgDescCreatedByUser SpecIdfgDescCreatedByUser
SpecIdfgDescCreationDate SpecIdfgDescCreationDate
SpecIdfgDescLastChangedByUser SpecIdfgDescLastChangedByUser
SpecIdfgDescLastChangeDate SpecIdfgDescLastChangeDate
SpecIdfgDescSortSequence SpecIdfgDescSortSequence
SpecIdfgDescCategory SpecIdfgDescCategory
SpecIdfgDescType SpecIdfgDescType
SpecIdfgDescLanguage SpecIdfgDescLanguage
SpecIdfgDescText SpecIdfgDescText
SpecificationAuthznGroup
SpecificationType

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_SpecIdentifier.
-- 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: ASPECIDENT
-- Parameters: P_KeyDate : sydate

CREATE VIEW A_SpecIdentifier AS
SELECT
  SpecIdfgDescInternalID,
  SpecIdfgDescChangeState,
  SpecificationInternalID,
  SpecIdfgDescIsDeleted,
  SpecIdfgDescCreatedByUser,
  SpecIdfgDescCreationDate,
  SpecIdfgDescLastChangedByUser,
  SpecIdfgDescLastChangeDate,
  SpecIdfgDescSortSequence,
  SpecIdfgDescCategory,
  SpecIdfgDescType,
  SpecIdfgDescLanguage,
  SpecIdfgDescText,
  _SpecificationForKeyDate( P_KeyDate : $parameters.P_KeyDate ).SpecificationAuthznGroup AS SpecificationAuthznGroup,
  _SpecificationForKeyDate( P_KeyDate : $parameters.P_KeyDate ).SpecificationType AS SpecificationType
FROM I_SpecIdentifierForKeyDate
;

Learn More