I_SpecStdAttribCodeForSpecType

DDL: I_SPECSTDATTRIBCODEFORSPECTYPE SQL: ISPCSTDADSPCT Type: view BASIC Package: VDM_PLMB_SPC_BAS
6 Fields 1 Data Sources

Specification Standard Attribute Code for Specification Type

I_SpecStdAttribCodeForSpecType is a Basic CDS View that provides data about "Specification Standard Attribute Code for Specification Type" in SAP S/4HANA. It reads from 1 data source (/plmi/spc_sa_def) and exposes 6 fields with key fields SpecificationType, SpecificationStdAttribCode. Part of development package VDM_PLMB_SPC_BAS.

Data Sources (1)

SourceAliasJoin Type
/plmi/spc_sa_def /plmi/spc_sa_def from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ISPCSTDADSPCT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
VDM.viewType #BASIC view
EndUserText.label Specification Standard Attribute Code for Specification Type view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY SpecificationType specification_type Specification Type
KEY SpecificationStdAttribCode attribute_name Element
SpecValAssgmtType specvalassgmttype Val. Asst Type
Characteristic characteristic_name Characteristic Name
SpecificationRating specificationrating Rating
SpecificationValidityArea specificationvalidityarea Validity Area

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 I_SpecStdAttribCodeForSpecType.
-- 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: ISPCSTDADSPCT

CREATE VIEW I_SpecStdAttribCodeForSpecType AS
SELECT
  specification_type AS SpecificationType,
  attribute_name AS SpecificationStdAttribCode,
  SpecValAssgmtType,
  characteristic_name AS Characteristic,
  SpecificationRating,
  SpecificationValidityArea
FROM /plmi/spc_sa_def
;

Learn More